April 21, 2011

Display details in Gridview using Data Adapter ASP.Net

SqlConnection conPCH = new SqlConnection(ConfigurationManager.ConnectionStrings["HUO"].ConnectionString);
SqlCommand cmdPCH = new SqlCommand("spGetPrevCallHistory", conPCH);
cmdPCH.CommandType = CommandType.StoredProcedure;

cmdPCH.Parameters.AddWithValue("@CID", CID);

SqlDataAdapter daPCH = new SqlDataAdapter(cmdPCH);

DataSet dsPCH = new DataSet();

daPCH.Fill(dsPCH);

gvPCH.DataSource = dsPCH;
gvPCH.DataBind();

No comments:

Post a Comment