string cConnectStr = "user id=sa;password=;initial catalog=Mydatabase;data source=MyServer"; SqlConnection oSqlConn = new SqlConnection(cConnectStr); DataSet DsMyData = new DataSet(); SqlDataAdapter oSqlAdapter = new SqlDataAdapter(cMyStoredProcName, oSqlConn); SqlParameter parmID = new SqlParameter("@nCustID",SqlDbType.Int); // ncustID is the actual parameter name in the SP parmID.Value = nCustId; // nCustID is the integer containing the value you want to pass oSqlAdapter.SelectCommand.CommandType = CommandType.StoredProcedure; oSqlAdapter.SelectCommand.Parameters.Add(parmID); oSqlAdapter.Fill( DsMyData,"MyDataSet"); oSqlConn.Close();Again, there are many different ways, and you'd want to abstract out the connection object handling and other things, but hopefully that should give you an idea. If you had two parameters, you'd create a second parameter object and add it.