protected void btnselect_Click(object sender, EventArgs e) { string table_naame = drp_table.SelectedItem.Text.ToString(); string number = txtno.Text; try { if (con.State == ConnectionState.Closed) { con.Open(); } string query = "Select headlines,detail,ImagePath From " + @table_naame + " Where ID=" + @number + ""; com = new SqlCommand(query, con); SqlDataAdapter da = new SqlDataAdapter(com); DataTable dt = new DataTable(); da.Fill(dt); txtheaadline.Text = dt.Rows[0]["headlines"].ToString(); txtdetail.Text = dt.Rows[0]["Detail"].ToString(); ImageDisplay.ImageUrl = dt.Rows[0]["ImagePath"].ToString(); } catch (Exception ex) { throw ex; } finally { if (con.State == ConnectionState.Open) { con.Close(); } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)