saeed razaee
چهارشنبه 07 اسفند 1387, 07:59 صبح
با سلام
من مي خواهم بعد از زدن كليك ثبت اطلاعات textbox پاك شود در حال حاضر بعد از زدن ثبت اطلاعات ثبت مي شود اما همچنان در textbox بر جا مي ماند.در ضمن كدهاي من به صورت زير است و صفحه برنامه نيز پيوست لطفا راهنمائي نمائيد.با تشكر
using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
Fill();
}
public void Fill()
{
SqlConnection ObjConnection = new SqlConnection("Data Source=Localhost;Initial Catalog=Sample;Integrated Security=True");
SqlDataAdapter ObjDataAdapter = new SqlDataAdapter("Select * From Table1", ObjConnection);
DataSet ObjDataSet = new DataSet();
ObjDataAdapter.Fill(ObjDataSet, "Table1");
GridView1.DataSource = ObjDataSet;
GridView1.DataBind();
ObjDataAdapter = null;
ObjConnection = null;
}
protected void insert_Click(object sender, EventArgs e)
{
SqlConnection ObjConnection = new SqlConnection("Data Source=Localhost;Initial Catalog=Sample;Integrated Security=True");
SqlCommand ObjCommand = new SqlCommand("Insert into Table1 (ID,Name) Values(@ID,@Name)", ObjConnection);
ObjCommand.Parameters.AddWithValue("@ID", txtID.Text);
ObjCommand.Parameters.AddWithValue("@Name", txtName.Text);
ObjConnection.Open();
ObjCommand.ExecuteNonQuery();
ObjConnection.Close();
Fill();
}
protected void Edit_Click(object sender, EventArgs e)
{
SqlConnection ObjConnection = new SqlConnection("Data Source=Localhost;Initial Catalog=Sample;Integrated Security=True");
SqlCommand ObjCommand = new SqlCommand("Update Table1 Set Name=@Name Where ID=@ID;", ObjConnection);
ObjCommand.Parameters.AddWithValue("@ID", txtID.Text);
ObjCommand.Parameters.AddWithValue("@Name", txtName.Text);
من مي خواهم بعد از زدن كليك ثبت اطلاعات textbox پاك شود در حال حاضر بعد از زدن ثبت اطلاعات ثبت مي شود اما همچنان در textbox بر جا مي ماند.در ضمن كدهاي من به صورت زير است و صفحه برنامه نيز پيوست لطفا راهنمائي نمائيد.با تشكر
using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
Fill();
}
public void Fill()
{
SqlConnection ObjConnection = new SqlConnection("Data Source=Localhost;Initial Catalog=Sample;Integrated Security=True");
SqlDataAdapter ObjDataAdapter = new SqlDataAdapter("Select * From Table1", ObjConnection);
DataSet ObjDataSet = new DataSet();
ObjDataAdapter.Fill(ObjDataSet, "Table1");
GridView1.DataSource = ObjDataSet;
GridView1.DataBind();
ObjDataAdapter = null;
ObjConnection = null;
}
protected void insert_Click(object sender, EventArgs e)
{
SqlConnection ObjConnection = new SqlConnection("Data Source=Localhost;Initial Catalog=Sample;Integrated Security=True");
SqlCommand ObjCommand = new SqlCommand("Insert into Table1 (ID,Name) Values(@ID,@Name)", ObjConnection);
ObjCommand.Parameters.AddWithValue("@ID", txtID.Text);
ObjCommand.Parameters.AddWithValue("@Name", txtName.Text);
ObjConnection.Open();
ObjCommand.ExecuteNonQuery();
ObjConnection.Close();
Fill();
}
protected void Edit_Click(object sender, EventArgs e)
{
SqlConnection ObjConnection = new SqlConnection("Data Source=Localhost;Initial Catalog=Sample;Integrated Security=True");
SqlCommand ObjCommand = new SqlCommand("Update Table1 Set Name=@Name Where ID=@ID;", ObjConnection);
ObjCommand.Parameters.AddWithValue("@ID", txtID.Text);
ObjCommand.Parameters.AddWithValue("@Name", txtName.Text);