Displaying single record....

is04768

Hi guys... I am making a desktop application in which i wish to display single record retrieved from the data base. I know I cant do this using dataGrid control.So is there any other way to do so? Also keep in mind that I do not know that how many columns will be returned at runtime. Plz help me ASAP. Thanx for the help in @dvancce. Ann.

2 Replies

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

madinewala23y ago
Hi, heres the sample code....I use OLEDB instead of SQLData... string connString = "Provider=SQLOLEDB;" + "Initial Catalog=irfandb;Data Source=irrfanpc;User ID=ir;Password=fan"; OleDbConnection conn = new OleDbConnection(connString); string strqry = "select name, age from irfan_table where no=197342"; //OleDbCommand comm = new OleDbCommand(strqry, conn); DataSet ds = new DataSet(); OleDbDataAdapter oda = new OleDbDataAdapter(strqry, conn); oda.Fill(ds,"irfan_table"); DataRowCollection drw = ds.Tables["irfan_table"].Rows; for(int i=0; i
is0476823y ago
One thing that I forget to mention is that I also want to give the first,last,next record buttons as we do in vb using NextRecord method etc. Ho to do this?