SqlDataSource INSERT query and TextBox text

Discussion in 'ASP .Net' started by Hrvoje Vrbanc, Dec 8, 2005.

  1. Hello all!

    I'm new to ASP.NET 2.0 and I tried connecting and inserting to a SQL
    database by using SqlDataSource control.

    I build an INSERT query using the query builder tool but I'm puzzled with
    the following: I select the columns that I want to include into my query and
    then there is a column "Values". However, it looks that the cells in this
    column accept (or interpret everything entered) only literals and not
    variables. What should I do in order to put textbox text into the query? If
    I enter '"& textbox1.text &"' there, it is interpreted as literal and no
    variable are passed to query.

    Thank you in advance,
    Hrvoje
    Hrvoje Vrbanc, Dec 8, 2005
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. =?Utf-8?B?RGFiYmxlcg==?=

    insert row using Gridview and SqlDataSource?

    =?Utf-8?B?RGFiYmxlcg==?=, Mar 19, 2006, in forum: ASP .Net
    Replies:
    2
    Views:
    10,659
    =?Utf-8?B?RGFiYmxlcg==?=
    Mar 20, 2006
  2. Luqman
    Replies:
    5
    Views:
    1,420
    luqman
    Nov 22, 2007
  3. tanmaypatankar
    Replies:
    0
    Views:
    1,083
    tanmaypatankar
    Dec 18, 2007
  4. Paul

    SQLDataSource and Query Speed

    Paul, Jan 21, 2009, in forum: ASP .Net
    Replies:
    1
    Views:
    383
    Cowboy \(Gregory A. Beamer\)
    Jan 21, 2009
  5. donutman
    Replies:
    0
    Views:
    749
    donutman
    Jul 30, 2009
Loading...

Share This Page