WebServices Retrieve using DataSet

Results 1 to 2 of 2

Thread: WebServices Retrieve using DataSet

  1. #1
    Join Date
    Dec 1969

    Default WebServices Retrieve using DataSet

    hi,<BR>i am using webservice to retrive information of orderdetails related to particular customer.<BR>i want to get the order details for particular customerid which i am giving as input.<BR><BR>Coding:-<BR>[WebMethod]<BR> public DataSet getorderlist(string str1)<BR> {<BR> SqlConnection sql;<BR> DataSet ds=new DataSet();<BR> DataView dv =new DataView();<BR> sql = new SqlConnection("server=(local)\NetSDK;database=Nort hwind;Trusted_Connection=Yes");<BR> SqlDataAdapter sda = new SqlDataAdapter("select * from Orders",sql);<BR> sda.Fill(ds,"orders");<BR> dv.Table =ds.Tables["orders"];<BR> dv.RowFilter ="CustomerID=&#039;VINET&#039;";<BR> <BR> return ds; <BR> <BR> }<BR><BR>It is giving the result but it returns all rows.<BR><BR>can any one clarify this doubt<BR><BR>thanks in advance,<BR>ulaga<BR>

  2. #2
    Join Date
    Dec 1969

    Default * Reposted above. (eop)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts