csharpdoost
سه شنبه 24 بهمن 1391, 13:59 عصر
چک کردم توی mytable داده دارم .
private DataTable GetDataTable()
{
using (SqlConnection sqlconnection = new SqlConnection("server=localhost;Integrated security=true;database=testSQLConnection"))
{
using (SqlCommand sqlCommand = new SqlCommand("SELECT * FROM authors " +
"WHERE au_id = @au_id", sqlconnection))
{
sqlCommand.Parameters.AddWithValue("@au_id", txtAuId.Text);
sqlconnection.Open();
using (SqlDataReader myReader = sqlCommand.ExecuteReader())
{
DataTable myTable = new DataTable();
myTable.Load(myReader);
sqlconnection.Close();
return myTable;
}
}
}
}
private DataTable GetDataTable()
{
using (SqlConnection sqlconnection = new SqlConnection("server=localhost;Integrated security=true;database=testSQLConnection"))
{
using (SqlCommand sqlCommand = new SqlCommand("SELECT * FROM authors " +
"WHERE au_id = @au_id", sqlconnection))
{
sqlCommand.Parameters.AddWithValue("@au_id", txtAuId.Text);
sqlconnection.Open();
using (SqlDataReader myReader = sqlCommand.ExecuteReader())
{
DataTable myTable = new DataTable();
myTable.Load(myReader);
sqlconnection.Close();
return myTable;
}
}
}
}