//Service.cs
[WebMethod]
public DataSet
GetSampleDataDT()
{
// getting connection string
DataSet dt = new DataSet();
DataTable dt1 = new
DataTable();
SqlDataAdapter sda;
SqlConnection con = new
SqlConnection("Data
Source=dxgdfhgfj;Initial Catalog=g);
con.Open();
SqlCommand cmd = new
SqlCommand("stp_selectall",
con);
cmd.CommandType = CommandType.StoredProcedure;
sda = new SqlDataAdapter(cmd);
sda.Fill(dt1);
dt.Tables.Add(dt1);
return dt;
}
//pl
private void button1_Click(object
sender, EventArgs e)
{
ServiceSoap
obj = new ServiceSoapClient();
DataSet
dtData = new DataSet();
dtData = obj.GetSampleDataDT();
DataTable
dt = new DataTable();
dt = dtData.Tables[0];
ListViewItem
lst = new ListViewItem();
foreach
(DataRow r in
dt.Rows)
{
lst = new
ListViewItem(r["id"].ToString());
lst.SubItems.Add(r["name"].ToString());
listView1.Items.Add(lst);
}
}
No comments:
Post a Comment