C#

...<br />
SqlDataReader drSQL;<br />
string strID;<br />
string strID;<br />
 try<br />
  {<br />
    strSQL = "SELECT * FROM table1";<br />
    SqlCommand cmd = new SqlCommand(strSQL,myconnection);<br />
    myconnection.Open();<br />
    drSQL = cmSQL.ExecuteReader();<br />
     if (drSQL.Read())<br />
       {<br />
          txtIndex.Text = drSQL["id_main"].ToString();<br />
          strID = drSQL["Id_detail"].ToString();<br />
          //this is a function for getting name of goods<br />
          FindItemByID(cbxGoods, strID)<br />
       }<br />
...

private void btNext_Click(object sender, EventArgs e)<br />
  {<br />
    ??<br />
  }

<br />
[WebMethod]<br />
public MyDataSet.MyTableDataTable MyTableGetAll() {<br />
MyDataSetTableAdapters.MyTableTableAdapter vTa = new MyDataSetTableAdapters.MyTableTableAdapter();<br />
return vTa.GetAll();<br />
}<br />
<br />
[WebMethod]<br />
public int MyTableUpdate(MyDataSet.MyTableDataTable pDt) {<br />
MyDataSetTableAdapters.MyTableTableAdapter vTa = new MyDataSetTableAdapters.MyTableTableAdapter();<br />
return vTa.Update(pDt);<br />
}<br />

<br />
// Server side<br />
[WebMethod]<br />
public {XML or String} MyTableGetAll() {<br />
MyDataSetTableAdapters.MyTableTableAdapter vTa = new MyDataSetTableAdapters.MyTableTableAdapter();<br />
return SomeEncryptFunction(vTa.GetAll());<br />
}<br />
<br />
// Client side<br />
public localhost.MyDataSet.MyTableDataTable GetMyTableData() {<br />
localhost.WebService vSvc = new localhost.WebService();<br />
return SomeDecryptFunction(vSvc.MyTableGetAll());<br />
}<br />
<br />
// Some Other place in the Client Side<br />
...<br />
oDataBoundObject.DataSource = GetMyTableData();<br />
...<br />