having problem with Access database
-
This is my code in C#.The database i am trying to access is having 49 entries in NotesdataTable sequentially(1 to 49).When i check ,i get the entry at first row, first column as 23 when the expected one is 1. string s=""; int i,j; string path=Application.StartupPath; conn=new OleDbConnection("FILE NAME="+path+"\\itskiosk.udl"); adpt=new OleDbDataAdapter("Select * from NotesDataTable",conn); DataSet dataset=new DataSet(); adpt.Fill(dataset,"NotesDataTable"); MessageBox.Show(dataset.Tables["NotesDataTable"].Rows[0][0].ToString()); What is the problem. If any body has any idea pl let me know. Thank you. world of intelegence
-
This is my code in C#.The database i am trying to access is having 49 entries in NotesdataTable sequentially(1 to 49).When i check ,i get the entry at first row, first column as 23 when the expected one is 1. string s=""; int i,j; string path=Application.StartupPath; conn=new OleDbConnection("FILE NAME="+path+"\\itskiosk.udl"); adpt=new OleDbDataAdapter("Select * from NotesDataTable",conn); DataSet dataset=new DataSet(); adpt.Fill(dataset,"NotesDataTable"); MessageBox.Show(dataset.Tables["NotesDataTable"].Rows[0][0].ToString()); What is the problem. If any body has any idea pl let me know. Thank you. world of intelegence
-
This is my code in C#.The database i am trying to access is having 49 entries in NotesdataTable sequentially(1 to 49).When i check ,i get the entry at first row, first column as 23 when the expected one is 1. string s=""; int i,j; string path=Application.StartupPath; conn=new OleDbConnection("FILE NAME="+path+"\\itskiosk.udl"); adpt=new OleDbDataAdapter("Select * from NotesDataTable",conn); DataSet dataset=new DataSet(); adpt.Fill(dataset,"NotesDataTable"); MessageBox.Show(dataset.Tables["NotesDataTable"].Rows[0][0].ToString()); What is the problem. If any body has any idea pl let me know. Thank you. world of intelegence
check the table name that u have mentioned in C# code with the one u created in Database. I observed a mismatch between those two from ur query. u might have done... NotesdataTable in Database NotesDataTable in C# code. check it venkat