PeterHarding: Created page with 'http://dotnetperls.com/datagridview-tutorial See: * http://foxcentral.net/microsoft/NETforVFPDevelopers_Chapter07.htm * http://foxcentral.net/microsoft/NETforVFPDevelopers.htm ...'

2011-01-30T08:01:23Z

Created page with 'http://dotnetperls.com/datagridview-tutorial See: * http://foxcentral.net/microsoft/NETforVFPDevelopers_Chapter07.htm * http://foxcentral.net/microsoft/NETforVFPDevelopers.htm ...'

New page

http://dotnetperls.com/datagridview-tutorial

See:

* http://foxcentral.net/microsoft/NETforVFPDevelopers_Chapter07.htm
* http://foxcentral.net/microsoft/NETforVFPDevelopers.htm

<pre>
public class Supplier
{
protected SqlDataAdapter DataAdapter;

public DataSet GetSupplierByID(int supplierID)
{
// Build the connection string
string ConnectionString = "server=(local);"+
"uid=sa;pwd=;"+
"database=Northwind";

// Build the command string
string CommandString = "SELECT supplierid, CompanyName" +
" FROM Suppliers WHERE supplierid = " + supplierID;

// Create the data adapter, passing the command and connection strings
DataAdapter = new SqlDataAdapter(CommandString, ConnectionString);

// Instantiate a DataSet object
DataSet ds = new DataSet();

// Fill the DataSet
DataAdapter.Fill(ds);

return ds;
}

/// Save the specified DataSet
public int Save(DataSet ds)
{
// Create a Command Builder and build the delete, update and insert commands
SqlCommandBuilder CommandBuilder = new SqlCommandBuilder(DataAdapter);
DataAdapter.DeleteCommand = CommandBuilder.GetDeleteCommand();
DataAdapter.UpdateCommand = CommandBuilder.GetUpdateCommand();
DataAdapter.InsertCommand = CommandBuilder.GetInsertCommand();

// Update the data in thet DataSet
int RowsUpdated = DataAdapter.Update(ds, ds.Tables[0].ToString());

return RowsUpdated;
}
}
</pre>

[[Category:Dot.NET]]
[[Category:Microsoft]]

Using DataAdaptors - Revision history

PeterHarding: Created page with 'http://dotnetperls.com/datagridview-tutorial See: * http://foxcentral.net/microsoft/NETforVFPDevelopers_Chapter07.htm * http://foxcentral.net/microsoft/NETforVFPDevelopers.htm ...'