deleting and filtering

Israel

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)
{
   // ???
}
}

11 Replies

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

Iftikar Hussain13y ago
Accepted 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
Israel13y ago
It's works. Thanx! Regards, Israel.
Israel13y ago
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 Hussain13y ago
please share your code

Regards,
Iftikar
Israel13y ago
Hmmmm, this message appear: Must declare the scalar variable "@txtboxfirstname"
Iftikar Hussain13y ago
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("@FirstName",txtfirstname.Text);
SqlParameter p2 = new SqlParameter("@Surname",txtfirstsurname.Text);
con.Open();
SqlDataReader reader = com.ExecuteReader();
while (reader.Read())
{
txtsurname.Text =reader["Surname"].ToString()
}
con.Close();
}

Regards,
Iftikar
Israel13y ago
Thanx. But I wish to display my data on my txtboxsurname. This the point
Sanjeeb Lenka13y ago
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("@FirstName",txtfirstname.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 Hussain13y ago
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
Israel13y ago
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("@FirstName",txtfirstname.Text);
SqlParameter p2 = new SqlParameter("@Surname",txtfirstsurname.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 Hussain13y ago
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("@FirstName",txtfirstname.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("@FirstName",txtfirstname.Text);
com.Parameters.Add(p1);
con.Open();
DataTable dt=new DataTable();
SqlDataAdapter sqlDataAdapter=new SqlDataAdapter(com);
sqlDataAdapter.Fill(dt);
con.Close();
}

Regards,
Iftikar