protected void Button1_Click(object sender, EventArgs e)
{
Entity_info sai = new Entity_info();
sai.name = TextBox1.Text;
BAL_info info = new BAL_info();
TextBox1.Text = "786" + info.insert(sai);
}
public string insert(BaseEntity BE)
{
string con = "Data Source=BUNTY-PC;Initial Catalog=Synetrader;Integrated Security=True";
Entity_info entinfo = (Entity_info)BE;
SqlConnection conn = new SqlConnection(con);
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
//cmd.CommandText = "insert into a values('"+entinfo.name+"')";
//cmd.CommandText = "update a set name='"+entinfo.name+"'where name='sai786'";
cmd.CommandText = "delete from a where name='saiganesh'";
conn.Open();
int i = cmd.ExecuteNonQuery();
return(i.ToString());
}
