How would I select all the items from a table using C# Visual Studio?
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
namespace MySQLConnection
{
class Program
{
static void Main(string[] args)
{
Console.WriteLine(args[0]);
}
}
}
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using MySql.Data.MySqlClient;
namespace ConsoleApplication3
{
class Program
{
public static string db = "server=localhost;database=dsc;uid=root;password=";
static void Main(string[] args)
{
try
{
MySqlConnection con = new MySqlConnection(db);
con.Open(); // connection must be openned for command
MySqlCommand cmd = new MySqlCommand("Select * FROM `tablename`", con);
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Console.WriteLine(reader.GetString("id") + ": " + reader.GetString("name") + " - " + reader.GetString("hs"));
}
}
catch (Exception ex)
{
Console.WriteLine("Error: "+ex);
}
finally
{
con.Close();
}
}
}
}
SqlConnection conn = new SqlConnection([connectionstring]);
SqlCommand com1 = new SqlCommand("Select * from [tablename]",conn);
conn.Open(); //Open the connection
SqlDataReader reader = com1.ExecuteReader();
while(Reader.Read()){ //read each row at a time
console.write(reader["columname"].toString]);
}
conn.Close(); //don't forget to close it after you're done
Does that help?
The connectionstring is a string which depends on the database location. The stuff in brackets in the sqlcommand is a 'select *' which will return all columns.
When you want to write the stuff out, you either give the column name or an integer. If you don't even know how many columns, you can put a loop which breaks when there's an exception thrown.
