using (SqlConnection sqlConn = new SqlConnection("Data Source=TANYA-PC;Initial Catalog=biore1;Integrated Security=True")) //here goes connStrng or the variable of it
{
sqlConn.Open();
string sqlQuery = @"SELECT farmername,villagename,gender,farmsize FROM cottonpurchase WHERE farmercode = @code";
using (SqlCommand cmd = new SqlCommand(sqlQuery, sqlConn))
{
cmd.Parameters.Add("@code", SqlDbType.Int).Value = intValue;
using (SqlDataReader reader = cmd.ExecuteReader())
{;
if (reader.Read())
{
TxtFarmerName.Text = (string)reader[0];
TxtVillageName.Text = (string)reader[1];
TxtGender.Text = (string)reader[2];
}
else
MessageBox.Show("For Farmer Code " + intValue.ToString() + " there is no farmer in the database.");
}
}
}
Senin, 26 Februari 2018
Using - End Using connection
Langganan:
Posting Komentar (Atom)

Tidak ada komentar:
Posting Komentar