urgent help needed :(

  1. #1

    urgent help needed :(

    hello every one
    i am working on a simple extjs page having a grid , i want to show my mssql server data in it , for this i am using webservice , now i have this code for my webservice
    using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Web.Services;
    using System.IO;
    using System.Text;
    using System.Collections;
    using System.Configuration;
    using System.Data;
    using System.Data.SqlClient;
    using System.Web;
    using System.Web.Script.Services;
    using System.Web.Script.Serialization;
    using System.Runtime.Serialization;
    namespace JSWorking
    {
        /// <summary>
        /// Summary description for WebService2
        /// </summary>
        [WebService(Namespace = "http://tempuri.org/")]
        [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
        [System.ComponentModel.ToolboxItem(false)]
        // To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line. 
        // [System.Web.Script.Services.ScriptService]
        public class WebService2 : System.Web.Services.WebService
        {
            HttpContext postedContext = HttpContext.Current;
            [WebMethod (EnableSession = true )]
            [ScriptMethod (ResponseFormat = ResponseFormat .Json ,UseHttpGet = true ,XmlSerializeString = false )]
            public List <Object[]> GetData ( string Name , int PhoneNo , int CellNo , int IDNo , string Advance )
            {
                string strCN = "Data Source=waqas\\sqlexpress2;Initial Catalog=myDB;User Id=waqas;Password=patanahi;";
                SqlConnection CN = new SqlConnection(strCN);
                CN.Open();
                string strQuery = "Select Name,PhonenO,CellNo,IDNo,Advance from Students";
                SqlCommand cmd = new SqlCommand(strQuery,CN);
                cmd.CommandType = CommandType.Text;
                SqlDataReader reader = cmd.ExecuteReader();
                List<Object[]> myArray = new List<object[]>();
                try
                {
                    while (reader.Read())
                    {
                        Object[] values = new Object[reader.FieldCount];
                        int fieldCount = reader.GetValues(values);
                        myArray.Add(values);
    
                    }
                    return myArray;
                }
                catch (Exception ex)
                {
                throw ex;  
    
                }
                finally 
                {
                reader.Close ();
                    reader.Dispose ();
                    cmd.Dispose ();
                    CN.Close ();
                    CN.Dispose ();
                }
                }
            }
        }
    tell me is there any error in it , now how can i show my data in my grid using this webservice , please help me ,


    Any help will be greatly appreciated ,

    Best regards


    M.Waqas Aslam
  2. #2

Similar Threads

  1. Replies: 5
    Last Post: Sep 19, 2011, 8:20 PM
  2. need urgent help challenging job
    By grajaneesh in forum 1.x Help
    Replies: 1
    Last Post: Apr 08, 2011, 2:31 PM
  3. Help Needed with PagingToolbar
    By pooja in forum 1.x Help
    Replies: 1
    Last Post: Jan 12, 2011, 10:57 AM
  4. Help Needed
    By pooja in forum 1.x Help
    Replies: 0
    Last Post: Jan 07, 2011, 6:07 AM
  5. Desperate Help Needed for V0.7
    By EzaBlade in forum 1.x Help
    Replies: 1
    Last Post: Jul 07, 2009, 6:06 PM

Tags for this Thread

Posting Permissions