deleting and filtering

Question

Hi!
These lines of codes work well. Its saving only! Then I would like to learn how to do two things:
1. How to delete rows?
2. How to filter a data from a TextBox?
Following the logic of my codes please (for example, Protected void Delete_Click and Protected void TxtBoxFilter_Click)
Protected void Save_Click(Object sender, EventArgs e)
{
   string strcon = "Data Source=localhost\\sqlexpress;Inital Catalog=Mfwamba;Integrated Security=True";
   SqlConnection con new SqlConnection(strcon);
SqlCommand com = new SqlCommand("save123", con);
com.CommandType = CommandType.StoreProcedure;
SqlParameter p1 = new SqlParameter("FirstName",txtfirstname.Text);
SqlParameter p2 = new SqlParameter("LastName",txtlastname.Text);
com.Parameters.Add(p1);
com.Parameters.Add(p2);
con.Open();
com.ExecteNonQuery();
labelinfo.Text = "Registered successfull.";
}
Protected void Delete_Click(Object sender, EventArgs e)
{
   // ???
}
}
Protected void TxtBoxFilter_Click(Object sender, EventArgs e)
{
   // ???
}
}

Iftikar Hussain · Answer

try like this protected void ButtonFilter_Click(Object sender EventArgs e) { string strcon = Data Source=localhost\sqlexpress;Initial Catalog=Mfwamba;Integrated Security=True; SqlConnection con = new SqlConnection(strcon); SqlCommand com = new SqlCommand(select * from registrationtab where username like @username con); SqlParameter p1 = new SqlParameter(@username txtboxUser.Text); com.Parameters.Add(p1); con.Open(); // FROM HERE WHERE THE MESSAGE APPEAR AFTER CLICKING ON THE BUTTON SqlDataReader reader = com.ExecuteReader(); while (reader.Read()) { txtboxUser.Text = reader[username].ToString(); } con.Close(); //SqlDataAdapter.Fill(dt); //GridView1.DataSource = dt; //GridView1.DataBind(); } Regards Iftikar

Israel · Answer

It's works. Thanx! Regards Israel.

Israel · Answer

Thanx. All my full codes. Then the real message: Must declare the scalar variable @txtboxusername using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data; using System.Data.SqlClient; public partial class WebForm2 : System.Web.UI.Page { protected void Buttonregisterme_Click(object sender EventArgs e) { string strcon = Data Source=localhost\sqlexpress;Initial Catalog=Mfwamba;Integrated Security=True; SqlConnection con = new SqlConnection(strcon); SqlCommand com = new SqlCommand(storlogin134 con); com.CommandType = CommandType.StoredProcedure; SqlParameter p1 = new SqlParameter(username txtboxUser.Text); SqlParameter p2 = new SqlParameter(email txtboxEmail.Text); SqlParameter p3 = new SqlParameter(password txtboxPass.Text); com.Parameters.Add(p1); com.Parameters.Add(p2); com.Parameters.Add(p3); con.Open(); com.ExecuteNonQuery(); labelinfo.Text = Registered successful.; } protected void Buttonlogin_Click(object sender EventArgs e) { string strcon = Data Source=localhost\sqlexpress;Initial Catalog=Mfwamba;Integrated Security=True; SqlConnection con = new SqlConnection(strcon); SqlCommand com = new SqlCommand(CheckUser con); com.CommandType = CommandType.StoredProcedure; SqlParameter p1 = new SqlParameter(username txtboxUser.Text); //SqlParameter p2 = new SqlParameter(email txtboxEmail.Text); SqlParameter p3 = new SqlParameter(password txtboxPass.Text); com.Parameters.Add(p1); //com.Parameters.Add(p2); com.Parameters.Add(p3); con.Open(); SqlDataReader rd = com.ExecuteReader(); if (rd.HasRows) { rd.Read(); labelinfo.Text = Login successful; } else { labelinfo.Text = Invalid username or password.; } } protected void ButtonCheckExistance_Click(object sender EventArgs e) { string strcon = Data Source=localhost\sqlexpress;Initial Catalog=Mfwamba;Integrated Security=True; SqlConnection con = new SqlConnection(strcon); SqlCommand com = new SqlCommand(existance con); com.CommandType = CommandType.StoredProcedure; SqlParameter p1 = new SqlParameter(email txtboxEmail.Text); com.Parameters.Add(p1); con.Open(); SqlDataReader rd = com.ExecuteReader(); if (rd.HasRows) { rd.Read(); this.labelinfo.ForeColor = System.Drawing.Color.Red; labelinfo.Text = already Exist; } else { this.labelinfo.Text = you can login now; this.txtboxUser.Text = ; this.txtboxPass.Text = ; this.txtboxEmail.Text = ; } } protected void ButtonDelete_Click(object sender EventArgs e) { string strcon = Data Source=localhost\sqlexpress;Initial Catalog=Mfwamba;Integrated Security=True; SqlConnection con = new SqlConnection(strcon); //SqlCommand com = new SqlCommand(delete from registrationtab where username=@username  con); SqlCommand com = new SqlCommand(delete from registrationtab where username=@username  con); SqlParameter p1 = new SqlParameter(@username txtboxUser.Text); //SqlParameter p2 = new SqlParameter(@email txtboxEmail.Text); //SqlParameter p3 = new SqlParameter(@password txtboxPass.Text); com.Parameters.Add(p1); //com.Parameters.Add(p2); //com.Parameters.Add(p3); con.Open(); com.ExecuteNonQuery(); con.Close(); labelinfo.Text = Deleted successful.; } protected void ButtonFilter_Click(Object sender EventArgs e) { string strcon = Data Source=localhost\sqlexpress;Initial Catalog=Mfwamba;Integrated Security=True; SqlConnection con = new SqlConnection(strcon); SqlCommand com = new SqlCommand(select * from registrationtab where username like @username con); SqlParameter p1 = new SqlParameter(@username txtboxUser.Text); SqlParameter p2 = new SqlParameter(@email txtboxEmail.Text); con.Open(); // FROM HERE WHERE THE MESSAGE APPEAR AFTER CLICKING ON THE BUTTON SqlDataReader reader = com.ExecuteReader(); while (reader.Read()) { txtboxUser.Text = reader[username].ToString(); } con.Close(); //SqlDataAdapter.Fill(dt); //GridView1.DataSource = dt; //GridView1.DataBind(); }

Iftikar Hussain · Answer

please share your code Regards Iftikar

Israel · Answer

Hmmmm this message appear: Must declare the scalar variable @txtboxfirstname

Iftikar Hussain · Answer

then you can do like this Protected void ButtonFilter_Click(Object sender EventArgs e) { string strcon = Data Source=localhost\sqlexpress;Inital Catalog=Mfwamba;Integrated Security=True; SqlConnection con new SqlConnection(strcon); SqlCommand com = new SqlCommand(select * from YourTableName where FirstName like @FirstName con); SqlParameter p1 = new SqlParameter(@FirstNametxtfirstname.Text); SqlParameter p2 = new SqlParameter(@Surnametxtfirstsurname.Text); con.Open(); SqlDataReader reader = com.ExecuteReader(); while (reader.Read()) { txtsurname.Text =reader[Surname].ToString() } con.Close(); } Regards Iftikar

Israel · Answer

Thanx. But I wish to display my data on my txtboxsurname. This the point

Sanjeeb Lenka · Answer

hi try like this Protected void ButtonFilter_Click(Object sender EventArgs e) { string strcon = Data Source=localhost\sqlexpress;Inital Catalog=Mfwamba;Integrated Security=True; SqlConnection con new SqlConnection(strcon); SqlCommand com = new SqlCommand(select * from YourTableName where FirstName like @FirstName con); SqlParameter p1 = new SqlParameter(@FirstNametxtfirstname.Text); com.Parameters.Add(p1); con.Open(); DataTable dt=new DataTable(); SqlDataAdapter sqlDataAdapter=new SqlDataAdapter(com); sqlDataAdapter.Fill(dt); Gridview1.DataSource = dt; Gridview1.DataBind(); con.Close(); } here i am using grid to bind the searched data . you can use any other control also

Iftikar Hussain · Answer

you no need to write it it will preserve your data after clicking on button. just remove the below line and check txtsurname.Text = com.Parameters.Add(2); Also let me know where you need to display the data after filtering Regards Iftikar

Israel · Answer

Hi! Thanx. The first answer to my first question its works very well. But I did do a mistake on my second question where I was talking about txtboxfilter_Click. It's about ButtonFilter_Click. Big sorry! Then I put this line of codes txtsurname.Text = com.Parameters.Add(1); to have the data's row appearing in my txtsurname's textbox. But sound that I didnt write well the code. Reagrding the textbox where to write the data search can be on the same firstname's box... Then clicking on my button I have appearing data. Protected void ButtonFilter_Click(Object sender EventArgs e) { string strcon = Data Source=localhost\sqlexpress;Inital Catalog=Mfwamba;Integrated Security=True; SqlConnection con new SqlConnection(strcon); SqlCommand com = new SqlCommand(select * from YourTableName where FirstName like @FirstName con); SqlParameter p1 = new SqlParameter(@FirstNametxtfirstname.Text); SqlParameter p2 = new SqlParameter(@Surnametxtfirstsurname.Text); com.Parameters.Add(p1); txtsurname.Text = com.Parameters.Add(2); con.Open(); DataTable dt=new DataTable(); SqlDataAdapter sqlDataAdapter=new SqlDataAdapter(com); sqlDataAdapter.Fill(dt); con.Close(); }

Iftikar Hussain · Answer

Hi Try like this Protected void Delete_Click(Object sender EventArgs e) { string strcon = Data Source=localhost\sqlexpress;Inital Catalog=Mfwamba;Integrated Security=True; SqlConnection con new SqlConnection(strcon); SqlCommand com = new SqlCommand(delete from YourTableName where FirstName=@FirstName con); SqlParameter p1 = new SqlParameter(@FirstNametxtfirstname.Text); com.Parameters.Add(p1); con.Open(); com.ExecteNonQuery(); con.close(); labelinfo.Text = Deleted successfull.; } Protected void TxtBoxFilter_Click(Object sender EventArgs e) { string strcon = Data Source=localhost\sqlexpress;Inital Catalog=Mfwamba;Integrated Security=True; SqlConnection con new SqlConnection(strcon); SqlCommand com = new SqlCommand(select * from YourTableName where FirstName like @FirstName con); SqlParameter p1 = new SqlParameter(@FirstNametxtfirstname.Text); com.Parameters.Add(p1); con.Open(); DataTable dt=new DataTable(); SqlDataAdapter sqlDataAdapter=new SqlDataAdapter(com); sqlDataAdapter.Fill(dt); con.Close(); } Regards Iftikar