c# Select MSSQL
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();
3.88
11
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);
}
}
Thank you!
11
3.88
(8 Votes)
0
Are there any code examples left?
New code examples in category C#
Relative searches
Select c##
c# select $
sql select example c#
select sql server c#
select c#
C# mssql query
. select c#
c sharp sql select query from
c sharp sql select query
c# sql query select
sql select in c#
select in c# sql
select sql statement c#
select query in sql server using c#
select() c#
c# .select
c# select from sql server
sql select query in c#
c# sql select query example
C# sql select in
.select c#
select query c#
c# select query
c# select()
sql select syntax c#
c# select from table mssql
c# sql get query result
select c#
select linq c# example
c# execute sql query and get result top row
c# select
select linq c#
c# Select MSSQL
sql client c# choose the specific database to query
select statement in c#
where select c#
sqlconnection c# select example
select * table using sql and c#
how to show selectstatement in c#
sql select query c#
select from select sql asp.net c#
c# sql select
