Database to variable

[bluejaguar456]

Hello everyone,

does anyone know if there is a way of copying from a database to a variable without putting it in a dataset to view it on the form i dont want the user to view it on the form.

i know that in vb6 you can do somethin like this:

 variable = adodatabase.recordset.fields("xxxx")

with that code it puts it straight onto the database and nowhere else.

does anyone know if there is a way???

 

[grip003]

What do you mean by not showing it on the form? The only way I know how to retrieve information from a database is through the DataAdapter. You can load the information into a DataSet or a DataTable if you wanted to. I use MySQL as my database and I simply wrote a class for doing all my database retrievals. Here is the code I use to get a DataTable from a select sql statement:

public DataTable SelectSQL_DT(string selectStr, string dtName)
{
	try
	{
		MySqlConnection dbConnection = 
			new MySqlConnection(connectionString);
		dbConnection.Open();

		MySqlDataAdapter adapter = 
			new MySqlDataAdapter(selectStr, dbConnection);

		DataTable my_table = new DataTable(dtName);
		adapter.Fill(my_table);

		// Dispose of the adapter, it is no longer needed
		adapter.Dispose();

		dbConnection.Close();
		return my_table;

	}
	catch (MySqlException e)
	{
		throw new Exception("SQL statement execution " +
			"error!!\n\n" + "Trying statement:\n  " + selectStr +
			"\n\n" + e.Message);
	}

}

Hope that helps.