How I get the data from a dataset:
CustomerDAL cDAL = new CustomerDAL();
DataSet ds = cDAL.GetContactPerson(id);
DataRow dr = ds.Tables[0].Rows[0];
_PK_ContactPerson = (int)dr["PK_ContactPerson"];
_FirstName = (String)dr["FirstName"];
_FirstName = (String)dr["FirstName"];
_Phone = (String)dr["PhoneNumber"];
_Fax = (String)dr["FaxNumber"];
_Email = (String)dr["EmailAdress"];
_Country = (String)dr["Country"];
_PostalCode = (String)dr["ZipCode"];
_City = (String)dr["City"];
_Street = (String)dr["StreetAdress"];
_MobilePhoneNumber = (String)dr["MobilePhoneNumber"];
_Title = (String)dr["Title"];
How I give data to a stored procedure in my database.
public int CreateContactPerson(int fk_Customer, string firstName,string lastName,string phoneNumber,string mobilePhoneNumber,string faxNumber,string emailAdress,string country,string zipCode,string city,string streetAdress,string title)
{
int pkContactPerson=0;
if(dbConnection.State == ConnectionState.Closed)
dbConnection.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "CreateContactPerson";
cmd.Connection = dbConnection;
cmd.Parameters.Add("@FirstName", firstName);
cmd.Parameters.Add("@LastName", lastName);
cmd.Parameters.Add("@PhoneNumber", phoneNumber);
cmd.Parameters.Add("@MobilePhoneNumber", mobilePhoneNumber);
cmd.Parameters.Add("@FaxNumber", faxNumber);
cmd.Parameters.Add("@EmailAdress", emailAdress);
cmd.Parameters.Add("@Country", country);
cmd.Parameters.Add("@ZipCode", zipCode);
cmd.Parameters.Add("@City", city);
cmd.Parameters.Add("@StreetAdress", streetAdress);
cmd.Parameters.Add("@Title", title);
SqlParameter param = new SqlParameter();
param.ParameterName = "@autonum";
param.SqlDbType = SqlDbType.Int;
param.Direction = ParameterDirection.Output;
cmd.Parameters.Add(param);
cmd.ExecuteNonQuery();
pkContactPerson = (int)cmd.Parameters["@autonum"].Value;
if(dbConnection.State == ConnectionState.Open)
dbConnection.Close();
return pkContactPerson;
}
Larege examples maybe ^^
I've never tried to give data to a dataset but seing how none has replied I give you this so you get to see something.
|
