i have used in line queries for inserting and retrieving data from database
how should i use stored proceduress
Insertion code
string strSQL1 = "select * from cust_details";
DataSet ds = new DataSet();
SqlConnection m_conn;
SqlDataAdapter m_dataAdapter;
m_conn = new SqlConnection(conn);
try
{
m_conn.Open();
m_dataAdapter = new SqlDataAdapter(strSQL1, m_conn);
SqlCommandBuilder sqldb = new SqlCommandBuilder(m_dataAdapter);
m_dataAdapter.Fill(ds);
DataTable dt = ds.Tables[0];
DataRow dr = dt.NewRow();
dr[0] = TextBox1.Text;
dr[1] = TextBox2.Text;
dr[2] = Convert.ToInt32(TextBox3.Text);
dr[3] = DropDownList1.SelectedItem.ToString();
dr[4] = TextBox4.Text;
dr[5] = TextBox5.Text;
dr[6] = TextBox6.Text;
dt.Rows.Add(dr);
m_dataAdapter.Update(ds, ds.Tables[0].TableName);
m_conn.Close();
bflag = true;
}
catch (Exception ex)
{
Label8.Text = ex.ToString();
ds = null;
}
Retrival code
try
{
SqlConnection conn3 = new SqlConnection(conn);
String q1;
//string ddl = DropDownList1.SelectedItem.ToString();
q1 = "select * from Product where ID ='" + DropDownList1.SelectedItem.ToString() + "'";
SqlCommand cmd = new SqlCommand(q1, conn3);
conn3.Open();
SqlDataReader odr1 = cmd.ExecuteReader();
odr1.Read();
if (odr1.HasRows)
{
Label40.Text = odr1[0].ToString();
Label41.Text = odr1[1].ToString();
Label42.Text = odr1[2].ToString();
Label43.Text = odr1[3].ToString();
Label44.Text = odr1[4].ToString();
Label45.Text = odr1[5].ToString();
Label46.Text = odr1[6].ToString();
Label47.Text = odr1[7].ToString();
}
}
catch (Exception ex)
{
}