Problem I traced is 1) The SQL Command is "INSERT" instead of select command. Insert Command insert data into tables and return the number of records inserted. 2) DataReader returns object. You have to convert the same into the data type you want eg. code { object obj = dr.read(); Convert.ToString(obj); } SO YOUR REQUIRED CODE SHALL BE LIKE FOLLOWS ---- SqlConnection con = new SqlConnection("server=AAB;database=ab;uid=sa;pwd=pass"); con.Open(); SqlCommand cmd = new SqlCommand("SELECT * FROM myTable", con); SqlDataReader dr = cmd.ExecuteReader(); while (!dr.IsDbNull()) { Object obj = dr.Read(); label1.Text= obj.ToSring(); } dr.Close(); --- try and reply.

modified on Saturday, May 30, 2009 4:09 AM

THANK YOU VERY MUCH..... As of now, since this is a small/ medium application, the current design may be OK. If I want to copy only the font end, whether I should require individual connection. I am asking this question because, if some of customer wants web front end, whether I have to change the entire back end code, because all the class on the same is using a single static sqlConnection. Please advise. Once again thanking you for your great advise. REGARDS PRASANTH

As I already mentioned, I am beginner and I have developed the three-tier application referring many links in the internet. Eventhough my application can work on multi-user environment, now the customer is working only with one computer and works fine. I have tested the same on two machines and works fine. Please note my applications contains the following files 1. APPL.EXE // Contains only Menu and 3. FRONTEND.DLL // Front End Forms 2. BUSINESSLAYER.DLL // Business Layer 3. DATALAYER.DLL // Data Layer 4. REPORTS.DLL // Crystal Reports and Forms to view the same. On loading Appl.exe, I am opening a static sqlConnection and using the static connection on datalayer.dll. This is because when I want to copy the application to another customer I have to change only the code on APPL.EXE. I have also implemented the same on using another class and works fine. But I want to know when I have to implement the software on another computer, Whether I have to copy all the files to the second machine or copy the APPL.EXE file to the second machine and refer the DLL files on the Server. If you want more details, please inform.

I am a beginner in C# Windows Application Development. I have developed an application with accounting package in three-tier architecture. I am using a single static sql connection for entire application at present. But I am not thinking it's a good practice. Please advise

The reply posted by hdv212 is correct. You can also achieve the same by introducing a Binding Source. -------------- BindingSource myBindingSource = new BindingSource() private Form1_Load() { myBindingSource.DataSource = myDataSet; myBindingSource.DataMember = "myTableName"; // TableName on the myDataSet myBindingSource.Filter = ""; myGridView.DataSource = myBindingSource; } Now in your TextBox_Changed Event write the following code { myBindingSource.Filter = "lastName = " + textBox1.text; } :-O