database

Question

Hi I have a table called Employee with attributes(enameageaddresssalary) I use SQL server 2005 for database design. I can put values into this table now.How can I retrieve data from the table. I want to appear those data in same fields in the form. Ex:-the form contains two butns.Add and Load. I need codings for Load butn. Thank you CharithMax

Charith Liyanagamage · Answer

Thankx a lot......... charithmax

Niradhip Chakraborty · Answer

//The example creates a SqlConnection to the Northwind database. The SqlCommand selecting items from the employee table is then executed using the SqlCommand ExecuteReader method. The results of this command are passed to the SqlDataReader. //Code: SqlDataReader myDataReader = null; SqlConnection mySqlConnection = new SqlConnection(server=(local)\SQLExpress;Integrated Security=SSPI;database=northwind); SqlCommand mySqlCommand = new SqlCommand(SELECT EmployeeID LastName FirstName Title ReportsTo FROM Employees mySqlConnection); ... mySqlConnection.Open(); myDataReader = mySqlCommand.ExecuteReader(CommandBehavior.CloseConnection); //The example reads through the data using the SqlDataReader Read method and writing the data elements out to the console. //code while (myDataReader.Read()) { Console.Write(myDataReader.GetInt32(0) + 	); Console.Write(myDataReader.GetString(2) +   + myDataReader.GetString(1) + 	); Console.Write(myDataReader.GetString(3) + 	); if (myDataReader.IsDBNull(4)) Console.Write(N/A
); else Console.Write(myDataReader.GetInt32(4) + 
); } //Finally the example closes the SqlDataReader then the SqlConnection. //code // Always call Close when done reading. myDataReader.Close(); // Close the connection when done with it. mySqlConnection.Close();

Sen · Answer

try this link http://www.java2s.com/Code/CSharp/Database-ADO.net/NavigatethebindeddatausingBindingManagerBase.htm