handling the database

sumit banshal

i want to retrieve a single data from a table. As for example i have a table named Tbl_MemoNo. this table has two fields named MemoNo and Date. i want to retrieve a single data of MemoNo field to windows form application (Visual Studio 2008). i am using C# language in developing the form. please help me.

3 Replies

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

Suthish Nair16y ago
Sumit,
Do a order by on table column.
sumit banshal16y ago
thank you mahakjee. your code is working. but i have a still a problem. your code select the first data from the field fname. i need to select the last data from the field. suppose the table has two data in fname column. the first data is 1 and second is 2. your code select the 1 but i need to select 2. how can i do it? please give me suggestion. thank you
Mahak Gupta16y ago
Hiii

Please Try this

Stap 1:-> Create a table in the Database in my case cust and I called fname(column) from this table

Step2:->Please first set the connectionString in the Databsae :-

Step 3:-> Take a TextBox(to show the return value) and a Button(Button1)

Step 4:-> Write the code on the Button1_Click :-

SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ToString());
   cn.Open();
   SqlCommand cmd1 = new SqlCommand("select * from cust", cn);
   SqlDataReader dr1;
   dr1 = cmd1.ExecuteReader();
   if (dr1.Read())
   {
   TextBox1.Text = dr1["fname"].ToString();
   }