About My project solution

Question

1.00/5 (2 votes)

See more:

Dear Friends,

C#

private void textBox1_TextChanged(object sender, EventArgs e)
        {
            SqlConnection conn = new SqlConnection();
            conn.ConnectionString = "Data Source=192.168.1.4;Initial Catalog=ParamBills;Persist Security Info=True;User ID=sa;Password=login";
            conn.Open();
            SqlCommand cmd = new SqlCommand("select Product_Name,Product_Code,Item_Name,Item_code,qty from Master_Stock_Register where Product_Name='" + textBox1.Text + "'", conn);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            da.Fill (dt);
            dataGridView1.DataSource = dt;
          // dataGridView1.DataBind();
            conn.Close();
        }

This solution is: when i changed text box value the data grid values also changed.. but i need add one by one below grid.. please help me..

Posted 18-Dec-13 2:52am

Vivek.anand34

Updated 18-Dec-13 2:54am

CHill60

v2

Add a Solution

Comments

CHill60 18-Dec-13 8:55am

Why are you requerying the data for you dataGridView1 every time you change the text in textBox1???

Vivek.anand34 18-Dec-13 9:00am

Yes for eg.i buy many things from store.. one thing is entered in text tat cames to grid. but another thing enter in that text box below alredy entered thing is hided. but add 1-by-1 how many thing we buy in stores

CHill60 18-Dec-13 9:07am

I didn't understand your reply. But here is a clue ... I can't think of any reason why you would need to requery for the datagridview every time a user types a character into a textbox. Rethink your design

Vivek.anand34 18-Dec-13 9:11am

U go and buy some things in supermarket.. one product entered in text box that comes to grid. and another product enter in textbox tat also comes to grid.. tat ly i asking.. but above code cant add in grid jst changed wt am typed in text box..

Ganesh KP 18-Dec-13 9:06am

what you are trying to achieve?

Vivek.anand34 18-Dec-13 9:08am

my project is Stock sales in super market.. that sold details is maintain in db.

Vivek.anand34 18-Dec-13 9:06am

please any one reply me.... concept is "Sales" in super market.. we enter product name in text box then tat product details, qty,unit,rate,total.. wil come below grid. but i can't add 1-by-1 in the grid..

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 18-Dec-13 10:15am

Can you check and see if my answer is correct or not? If you need anything else, tell me.

Ganesh KP 18-Dec-13 9:29am

best thing u can do is get all the data before or on page loads and when ever user enters some data (probably a key press event) search for a products that start with or having the entered text. In this way you can save a lot of traffic to your database and I hope this is the best method to do.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

phil.o · Answer 1 · 2013-12-18T04:18:00

Execute your procedure in the Validated event handler, rather than in the TextChanged one; as you already have been told, recreating a DB connection and query everytime a new character is entered in a TextBox is a design issue, it will make your application less responsive and annoying, from a user experience point of view.

You should also avoid constructing SQL queries by concatenating values obtained from users; this leaves your code opened to SQL injection attacks.
For example, if anyone enters the following text in textBox1:

';DROP DATABASE ParamBills;--

then you're busted.

Regards.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Answer 2 · 2013-12-18T04:13:00

You can do one thing.

Take one HiddenField and store the TextBox value in it inside the TextChanged Event.
Something like below...

C#

private void textBox1_TextChanged(object sender, EventArgs e)
{
    if(String.IsNullOrEmpty(hdnField.Value))
    {
        hdnField.Value = textBox1.Text;
    }
    else
    {
        hdnField.Value = hdnField.Value + "," + textBox1.Text;
    }

    SqlConnection conn = new SqlConnection();
    conn.ConnectionString = "Data Source=192.168.1.4;Initial Catalog=ParamBills;Persist Security Info=True;User ID=sa;Password=login";
    conn.Open();
    SqlCommand cmd = new SqlCommand("select Product_Name,Product_Code,Item_Name,Item_code,qty from Master_Stock_Register where Product_Name IN (@TextBoxValue)", conn);
    command.Parameters.AddWithValue("@TextBoxValue", hdnField.Value);

    SqlDataAdapter da = new SqlDataAdapter(cmd);
    DataTable dt = new DataTable();
    da.Fill (dt);
    dataGridView1.DataSource = dt;
  // dataGridView1.DataBind();
    conn.Close();
}

About My project solution

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0