C# sql select

SqlConnection conn = new SqlConnection("Data Source=;Initial Catalog=;Persist Security Info=True;User ID=;Password=");
conn.Open();

SqlCommand command = new SqlCommand("Select id from [table1] where name=@zip", conn);
command.Parameters.AddWithValue("@zip","india");
 // int result = command.ExecuteNonQuery();
using (SqlDataReader reader = command.ExecuteReader())
{
  if (reader.Read())
  {
     Console.WriteLine(String.Format("{0}",reader["id"]));
   }
}

conn.Close();

Source: stackoverflow.com

C# Select MSSQL

DataSet ds = new DataSet();
//https://www.oracle.com/webfolder/technetwork/tutorials/obe/db/dotnet/ODPNET_Core_get_started/index.html
using (SqlConnection con = new SqlConnection(connectionstr))
{
    using (SqlCommand cmd = con.CreateCommand())
    {
        con.Open();
        cmd.CommandText = "select * from master.sys.server_principals";
        SqlDataAdapter adapter = new SqlDataAdapter(cmd);
        adapter.Fill(ds);
    }
}

How to use sqlcommand

 SqlConnection conn = new SqlConnection("Database=student;Server=.;user=sa;password=aaaaaaa");  
            conn.Open();  // Open the connection  
            // body    
            // body   
            conn.Close(); // Close the connection

Source: c-sharpcorner.com

Similar codes

5 votes285 views6 answers
Sql add days to date
SQL
3 votes319 views2 answers
Laravel tosql with bindings
SQL
1 vote335 views3 answers
How to pass password to mysql command line
SQL
10 votes337 views2 answers
Doublon sql
SQL
39 votes380 views4 answers
Select duplicates in sql
SQL
10 votes312 views4 answers
How to alter table name in mysql
SQL
4 votes329 views2 answers
Float postgres
SQL
0 vote300 views1 answer
How to check even or odd in sql
SQL
0 vote300 views1 answer
Which MySQL data type to use for storing boolean values
SQL
1 vote302 views2 answers
Restart identity cascade
SQL