C#, Asp.net

Kamala Veni

10y990

Am having Multiple Text box in the form after entering details having a sepreate save button,i haved the data,bt while clicking individual save button have to save and all textbox should clean ..

hw i can do dat?

protected void btsn1_Click(object sender, EventArgs e)

{

SqlConnection cnn = new SqlConnection();

cnn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["cppschConnectionString"].ConnectionString; cnn.Open();

SqlCommand cmd = new SqlCommand();

cmd.CommandText = "select * from tbl_sch111";

cmd.Connection = cnn;

SqlDataAdapter da = new SqlDataAdapter();

da.SelectCommand = cmd;

DataSet ds = new DataSet();

da.Fill(ds, "tbl_sch111");

SqlCommandBuilder cb = new SqlCommandBuilder(da);

DataRow drow = ds.Tables["tbl_sch111"].NewRow();

drow["Date"] = lb.Text;

drow["Time"] = lbb.Text;

drow["Day"] = lbd.Text;

drow["blk_1"] = txtbl1.Text;

drow["blk_2"] = txtbl2.Text;

drow["blk_3"] = txtbl3.Text;

drow["blk_4"] = txtbl4.Text;

drow["blk_5"] = txtbl5.Text;

drow["blk_6"] = txtbl6.Text;

drow["blk_7"] = txtbl7.Text;

drow["blk_8"] = txtbl8.Text;

drow["blk_9"] = txtbl9.Text;

drow["blk_10"] = txtbl10.Text;

ds.Tables["tbl_sch111"].Rows.Add(drow);

da.Update(ds, "tbl_sch111");

ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "alert('Data Insert Successfully...');", true);

}

protected void bts2_Click(object sender, EventArgs e)

{

SqlConnection cnn = new SqlConnection();

cnn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["cppschConnectionString"].ConnectionString; cnn.Open();

SqlCommand cmd = new SqlCommand();

cmd.CommandText = "select * from tbl_sch111";

cmd.Connection = cnn;

SqlDataAdapter da = new SqlDataAdapter();

da.SelectCommand = cmd;

DataSet ds = new DataSet();

da.Fill(ds, "tbl_sch111");

SqlCommandBuilder cb = new SqlCommandBuilder(da);

DataRow drow = ds.Tables["tbl_sch111"].NewRow();

drow["Day"] = l2.Text;

drow["Time"] = l.Text;

drow["Date"] = l3.Text;

drow["blk_1"] = TextBox1.Text;

drow["blk_2"] = TextBox2.Text;

drow["blk_3"] = TextBox3.Text;

drow["blk_4"] = TextBox4.Text;

drow["blk_5"] = TextBox5.Text;

drow["blk_6"] = TextBox6.Text;

drow["blk_7"] = TextBox7.Text;

drow["blk_8"] = TextBox8.Text;

drow["blk_9"] = TextBox9.Text;

drow["blk_10"] = TextBox10.Text;

ds.Tables["tbl_sch111"].Rows.Add(drow);

da.Update(ds, "tbl_sch111");

ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "alert('Data Insert Successfully...');", true);

//Response.Redirect("Upsch.aspx");

}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ravi Patel10y ago
Hi,

check this

http://www.c-sharpcorner.com/blogs/clear-textboxes-values-in-asp-net1
Kamala Veni10y ago
if i had 96 text box in a single form for 1 day and lyk dis i have fr 7 days, how can i do fr dat,? any another way?
Ravi Patel10y ago
Hi ,
try this

protected void btsn1_Click(object sender, EventArgs e)
{
SqlConnection cnn = new SqlConnection();
cnn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["cppschConnectionString"].ConnectionString; cnn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select * from tbl_sch111";
cmd.Connection = cnn;
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
DataSet ds = new DataSet();
da.Fill(ds, "tbl_sch111");
SqlCommandBuilder cb = new SqlCommandBuilder(da);
DataRow drow = ds.Tables["tbl_sch111"].NewRow();
drow["Date"] = lb.Text;
drow["Time"] = lbb.Text;
drow["Day"] = lbd.Text;
drow["blk_1"] = txtbl1.Text;
drow["blk_2"] = txtbl2.Text;
drow["blk_3"] = txtbl3.Text;
drow["blk_4"] = txtbl4.Text;
drow["blk_5"] = txtbl5.Text;
drow["blk_6"] = txtbl6.Text;
drow["blk_7"] = txtbl7.Text;
drow["blk_8"] = txtbl8.Text;
drow["blk_9"] = txtbl9.Text;
drow["blk_10"] = txtbl10.Text;
ds.Tables["tbl_sch111"].Rows.Add(drow);
da.Update(ds, "tbl_sch111");
txtbl1.Text= string.Empty;
// do the same thing as above for all textbox
ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "alert('Data Insert Successfully...');", true);
}

protected void bts2_Click(object sender, EventArgs e)
{
SqlConnection cnn = new SqlConnection();
cnn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["cppschConnectionString"].ConnectionString; cnn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select * from tbl_sch111";
cmd.Connection = cnn;
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
DataSet ds = new DataSet();
da.Fill(ds, "tbl_sch111");
SqlCommandBuilder cb = new SqlCommandBuilder(da);
DataRow drow = ds.Tables["tbl_sch111"].NewRow();
drow["Day"] = l2.Text;
drow["Time"] = l.Text;
drow["Date"] = l3.Text;
drow["blk_1"] = TextBox1.Text;
drow["blk_2"] = TextBox2.Text;
drow["blk_3"] = TextBox3.Text;
drow["blk_4"] = TextBox4.Text;
drow["blk_5"] = TextBox5.Text;
drow["blk_6"] = TextBox6.Text;
drow["blk_7"] = TextBox7.Text;
drow["blk_8"] = TextBox8.Text;
drow["blk_9"] = TextBox9.Text;
drow["blk_10"] = TextBox10.Text;
ds.Tables["tbl_sch111"].Rows.Add(drow);
da.Update(ds, "tbl_sch111");
TextBox1.Text= string.Empty;
//// do the same thing as above for all textbox
ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "alert('Data Insert Successfully...');", true);
//Response.Redirect("Upsch.aspx");
}