I've modified one of the Microsoft C# Walkthroughs using a parameterized query to use storedprocedures instead of sql statements to pull data from the author table of the pubs database. I've added Update, Insert, and Delete buttons to the form but I have no idea on how to wire themup to pass and retrieve data from the stored procedures (the stored procedures were generatedby the Data Adapter Wizard). Everything to load and page records works as in the walkthrough.Any help would be greatly appreciated.C# Code Follows=========================================================================using
using
namespace
{
InitializeComponent();
}
components.Dispose();
#region
((System.ComponentModel.ISupportInitialize)(
"ecurity info=True;initial catalog=pubs;password=\"SNWb@Ckd0Re\"";
#endregion
[STAThread]
Application.Run(
sqlDataAdapter1.SelectCommand.Parameters["@Param2"].Value = txtStateParameter.Text;
dsDataSet1.Clear();
sqlDataAdapter1.Fill(dsDataSet1);
ShowPosition();
iCnt =
iPos =
txtPosition.Text = "(No records)";
txtPosition.Text = iPos.ToString() + " of " + iCnt.ToString() ;