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. Advertisements

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. Hai Nguyen

    Insert large text into a textbox

    Hai Nguyen, Feb 5, 2004, in forum: ASP .Net
    Replies:
    3
    Views:
    560
  2. =?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,880
    =?Utf-8?B?RGFiYmxlcg==?=
    Mar 20, 2006
  3. Replies:
    3
    Views:
    963
    George Ter-Saakov
    Feb 23, 2007
  4. Luqman
    Replies:
    5
    Views:
    1,690
    luqman
    Nov 22, 2007
  5. tanmaypatankar
    Replies:
    0
    Views:
    1,224
    tanmaypatankar
    Dec 18, 2007
  6. Paul

    SQLDataSource and Query Speed

    Paul, Jan 21, 2009, in forum: ASP .Net
    Replies:
    1
    Views:
    510
    Cowboy \(Gregory A. Beamer\)
    Jan 21, 2009
  7. donutman
    Replies:
    0
    Views:
    865
    donutman
    Jul 30, 2009
  8. agb

    writing two textbox's text in one textbox

    agb, Aug 26, 2003, in forum: ASP .Net Web Controls
    Replies:
    1
    Views:
    276
    Ken Cox [Microsoft MVP]
    Aug 27, 2003
Loading...