Professional Web Applications Themes

DataAdapter - ASP.NET General

Hi I use a DataAdapter. To which is pass a Stored Proc and Connection SqlDataAdapter DA = new SqlDataAdapter("storedProd",Conn); how do i pass parameters to my stored proc Kindly Help...

  1. #1

    Default DataAdapter

    Hi

    I use a DataAdapter. To which is pass a Stored Proc and
    Connection

    SqlDataAdapter DA = new SqlDataAdapter("storedProd",Conn);
    how do i pass parameters to my stored proc

    Kindly Help
    Shalini Noronha Guest

  2. #2

    Default Re: DataAdapter

    Shalini,

    You should create a SqlCommand object

    SqlClient.SqlCommand SqlCommand;
    SqlCommand.CommandText = "storedProd";
    SqlCommand.CommandType = CommandType.StoredProcedure;
    SqlCommand.Parameters.Add(New SqlClient.SqlParameter("MyFirstParameter",
    [Value As Object]);
    SqlCommand.Parameters.Add(New SqlClient.SqlParameter("MySecondParameter",
    [Value As Object]);

    SqlCommand.Connection = Conn

    SqlDataAdapter DA = new SqlDataAdapter(SqlCommand);

    Sincerely,

    --
    S. Justin Gengo, MCP
    Web Developer

    Free code library at:
    [url]www.aboutfortunate.com[/url]

    "Out of chaos comes order."
    Nietzche


    "Shalini Noronha" <shalini_maria> wrote in message
    news:032901c35d19$4e32e630$a301280aphx.gbl...
    > Hi
    >
    > I use a DataAdapter. To which is pass a Stored Proc and
    > Connection
    >
    > SqlDataAdapter DA = new SqlDataAdapter("storedProd",Conn);
    > how do i pass parameters to my stored proc
    >
    > Kindly Help

    S. Justin Gengo Guest

Similar Threads

  1. DataAdapter question
    By Eric A. Johnson in forum ASP.NET Data Grid Control
    Replies: 1
    Last Post: October 17th, 10:15 PM
  2. DataAdapter and multiple result sets
    By Michael C# in forum ASP.NET Web Services
    Replies: 2
    Last Post: May 10th, 06:05 PM
  3. update sql unique key with dataadapter
    By luudt in forum ASP.NET Data Grid Control
    Replies: 1
    Last Post: November 14th, 04:46 PM
  4. Distributed Arch Guidance for DataAdapter and WS
    By Emre Aydinceren in forum ASP.NET Web Services
    Replies: 1
    Last Post: July 9th, 01:01 PM
  5. DataAdapter Insert data into a query
    By Paul in forum ASP.NET General
    Replies: 0
    Last Post: June 30th, 06:47 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139