TypeDataset

How to create typed Dataset
1>First create a table with sql server enterprise manager
Say we have created a table with name member which have a following
filed :=>PKID(Int),MemberID(bigint),Name(Varchar),Salary(float),
SalaryType(bit).
2>Enter few records into the table.
3>Now open the visual studio .net editor.
4>Craete a new asp.net web site.
5>In Solution Explorer, right-click to add a new item, and select
DataSet. Give it the name MemberDataSet.xsd. Visual Studio will
recommend placing the DataSet file inside the App_Code folder,
which you should allow it to do for you.
6>Now cancel the connection interface which will open as default.
7>Open the server explorer.drag table into the design window.
8>Now right ckick on the TableAdaptor=>click on configure.
9>Customize the query accordingly=>Click Next=>Specify the Method name
=>Click next=>Click Next.
10>Now come to the code behind and add the following code.


The way out in which not need to create any connection.
TypedDatasetTableAdapters.MemberTableAdapter objTA = new TypedDatasetTableAdapters.MemberTableAdapter();
//TypedDataset.MemberDataTable objT = objTA.GetData(2,false);//Fetch data with parameter.
TypedDataset.MemberDataTable objT = objTA.GetDataByAll();
rptTest.DataSource = objT;
rptTest.DataBind();


the way out in which need to create connection.
string strConnectionString = "user id=sa;password=sa;data source=localhost;initial catalog=rnd;";
SqlConnection objConne = new SqlConnection(strConnectionString);
SqlCommand objComm = new SqlCommand("Select PKID,Name,MemberID,Salary from Member", objConne);
SqlDataAdapter objAdap = new SqlDataAdapter(objComm);
//objDS.Member[0].Name = "Priyabrata";
objAdap.Fill(objDS, "Member");
rptTest.DataSource = objDS.Tables["Member"].DefaultView;
rptTest.DataBind();


//Person Table first row name collumn
//objDS.Person[0].Name = 1;//It will generate compile time error.