hello i`m having problem using c# windows form

Question

hello i`m having problem using c# windows form trying to connect to database and having this error here DataTable dTable = new DataTable (); dAdapter.Fill(dTable);

Saroj Kumar Sahu · Answer

Hi It sounds like your connection is not initializedSo initialized your connection before DataAdapter declaration like ... //Define your connection string string sqlConnectString = Data Source=(local);Integrated security=SSPI;Initial Catalog=DBName;; SqlDataAdapter da = new SqlDataAdapter(Your sqlQuery sqlConnectString);

Pankaj Kumar Choudhary · Answer

Hello @Modestas your code is correct it contain only one mistake that your not providing connection name MySqlCommand cmd = new MySqlCommand(SELECT tes FROM ins conn); or dAdapter.SelectCommand.Connection = myCon;

Manoj Bhoir · Answer

Hi You have not initialize SelectCommand Connection Property for DataAdapter. dAdapter.SelectCommand.Connection = myConn; Just add this line in your code above this line : DataTable dTable = new DataTable(); Or just Change : MySqlCommand cmd = new MySqlCommand(Your Select Query); To MySqlCommand cmd = new MySqlCommand(Your Select Query myConn );

Upendra Pratap Shahi · Answer

firstly take your datatable with return value from database after that you fill dataadapter because your datatable is empty at this time and also chek datatable null condition.