saving and reading data into textboxes from sql database

jude somtoo

i have four textboxes,a button and some other comboboxes, the textboxes is meant for the studentid,department,faculty,and programme whereby if the user enter a studentid and click the search button these othe textboxes will be filled up from the registeredstudent database but my problem is that whenever i enter a studentid and click the search button these textboxes will be filled and when i want to continue with other comboboxes ,when choosed a combobox the data are still there but choosing another combobox all the data in the textboxes will disappear.Another problem is that i have a metrogrid(from metro framework) where i see my saved inputs but whenever i click the search button with the textboxes filled but when i click on on textbox the data in it is shown in the metrogrid but clicking on another textbox all other filled data except the one shown in the metrogrid disappears. please i need help. This program is in c sharp windows form application not ASP.NET

2 Replies

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

jude somtoo9y ago
I have reader. Read () in my code which didn't work but now i used dataset which is having the same problem that is when you click on a textbox it saves but when you click on another textbox all other disappear. Please help me
Manikandan Murugesan9y ago
The line reader.Read() is missing in your code. You should add it. It is the function which actually reads data from the database:
string conString = "Data Source=localhost;Initial Catalog=LoginScreen;Integrated Security=True";
SqlConnection con = new SqlConnection(conString);

string selectSql = "select * from Pending_Tasks";
SqlCommand com = new SqlCommand(selectSql, con);

try
{
    con.Open();

    using (SqlDataReader read = cmd.ExecuteReader())
    {
        while(reader.Read())
        {
            CustID.Text = (read["Customer_ID"].ToString());
            CustName.Text = (read["Customer_Name"].ToString());
            Add1.Text = (read["Address_1"].ToString());
            Add2.Text = (read["Address_2"].ToString());
            PostBox.Text = (read["Postcode"].ToString());
            PassBox.Text = (read["Password"].ToString());
            DatBox.Text = (read["Data_Important"].ToString());
            LanNumb.Text = (read["Landline"].ToString());
            MobNumber.Text = (read["Mobile"].ToString());
            FaultRep.Text = (read["Fault_Report"].ToString());
        }
    }
}
finally
{
    con.Close();
}
EDIT : This code works supposing you want to write the last record to your textboxes. If you want to apply a different scenario, like for example to read all the records from database and to change data in the texboxes when you click the Next button, you should create and use your own Model, or you can store data in the DataTable and refer to them later if you wish.