Reply to thread

Message: <blockquote data-quote="Core" data-source="post: 7601803" data-attributes="member: 263471">I can see you don't have a basic idea how DataBases work,first of all I can give you an advice honesty understand the theory then do the practicals.there are lot of ways you can connect with a database the easiest way is through a DataSet. and using a DataAdapterDim _dataSet as new DataSet()Dim _dataAdapter as new System.Data.OleDbDataAdapter()Dim _con as new System.Data.OleDbConnection()Dim _commandString as String = "SELECT * From tableName";'remember if you want to get data from specific column then append'WHERE columnName=data (mostly the key) the it will return only that rowDim _com as new System.Data.OleDbCommand(_commandString ,_con);then made the connection string_con.ConnectionString = "in here you should give the connection string"it may depend on which version use Provider=Microsoft.ACE.OLEDB.12.0;Data  Source=C:\myFolder\myAccess2007file.accdb;Jet OLEDB Database Password=MyDbPassword;the OLEDB 12 is the provider which handle the 2007 version of Access DataBasesso it may be changed if that's 2003 or olderif you want to change the command text later use_com.SelectCommand.CommandTet = "your command goes here"__dataAdapter.Fill(_dataSet,"Table\'s name of the dataSet);now you have made the connection and prepare everything now just open the connection_con.Open() 'then it will fill the DataSet from DataBase where you can manipulate your data while in the program.//now use your commands to work with DataSet //it uses Dim _row as DataRow = _dataSet.Tables["tablesName"].Rows[0]which will return the row number 0 in the tablesName table in the DataSetif you want to finally update the DataBase useCommandBuilder namespacebut remember if you use_dataAdapter.Update(_dataSet,"the table where data in the dataset)you gotta use CommandBuilder as well.finally close and dispose everything_dataSet.Dispose()_dataAdapater.Dispose()_con.Close() _con.Dispose()</blockquote>

Verification: Haya warak paha keeyada? (haya wadi kireema paha)

Top Bottom