Thursday, 18 June 2015

WebServices

//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