Displaying single record....

Question

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.

madinewala · Answer

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(dsirfan_table); DataRowCollection drw = ds.Tables[irfan_table].Rows; for(int i=0; i<drw.Count;i++) { MessageBox.Show(drw[i][name].ToString()); MessageBox.Show(drw[i][age].ToString()); } also you could determine the number of columns at DataRowCollection drw = ds.Tables[irfan_table].Columns; and create so many required items on you form.. HTH irfan

is04768 · Answer

One thing that I forget to mention is that I also want to give the firstlastnext record buttons as we do in vb using NextRecord method etc. Ho to do this?