handling the database

Question

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.

Suthish Nair · Answer

Sumit Do a order by on table column.

sumit banshal · Answer

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 Gupta · Answer

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(); }