Saturday 19 April 2014

Database value in textBox if selected in listbox in window form


                                                                                                                                          Previous...
                                                                                                                                             Next...

Here i will explain database value in textbox if selected value in list box. Before this i explained that how to link listbox with database.

Step(1):- Form
Drag and down a listbox from toolbox.
Step(2):- Code
Click on list box and write this code.

Private Void listBox1.SelectedIndexChanged(object sender , EventArgs e)
{
    string str = "server = MUNESH\\SQL2008R2;Database=datastore;UID=sa;Password=123;";
    SqlConnection con = new SqlConnection(str);
    string query = "select * from tablename where name = '"+listBox1.text+"' ";
    SqlCommand cmd = new SqlCommand( query,con);
    sqldatareader dbr;
    try
    {
        con.open();
        dbr = cmd.executereader();
        while(dbr.read())
        {
            string sID = (string) dbr["ID"].tostring;
            string sname = (string) dbr["name"// name is string value
             string ssurname = (string) dbr["surname"] 
            string sage = (string) dbr["age"].tostring;
            textbox1.text = sid;
            textbox2.text = sname;
            textbox3.text = ssurname ;
            textbox4.text = sage;

        }
        catch(execption es)
        {
           messagebox.show(es.message);
        }
    }
}

Step(3):- Output
Run your application.
                                                                                                                                          Previous...
                                                                                                                                             Next...

No comments:

Post a Comment

C# program Selection Sorting

Selection sort is a straightforward sorting algorithm. This algorithm search for the smallest number in the elements array and then swap i...