Monday, September 29, 2008

using sqlparameter and dataset in C#

// using sqlparameter in C#,Dataset with sqlparameters in c#

SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@TypeID", SqlDbType.Int);
param[0].Value = ddlArticleType.SelectedValue;

DataSet ds = new DataSet();
ds = Obj.GetDataSet(strconnect, "Proc_GetActiveTypeID", param);
DdlCategory.DataSource = ds;
DdlCategory.DataTextField = "Categoryname";
DdlCategory.DataValueField = "CategoryId";
DdlCategory.DataBind();
DdlCategory.Items.Insert(0, "Select Category");

'Please rate this if you like it



Top Blogs

1 comment:

Icymar "Iceman" Tagimacruz said...

I want to learn C#...

visit mine at www.icymartagimacruz.blogspot.com