On May 28, 5:34 pm, "Scott M." <s...@nospam.nospam> wrote:
> Well, your code indicates that you want the name of a column in the textbox.
> Is that right, or did you want the value of one of the columns in your
> textbox?
>
> Instead of this (to get the the first column's name):
> txt_offer.Text = ds.Tables(0).Columns(0).ToString
>
> Use this to get the first column's value:
> txt_offer.Text = ds.Tables(0).Rows(0).Item(0).ToString
>
> -Scott
>
> <backward...@gmail.com> wrote in message
>
> news:1180323677.122033.31390@q19g2000prn.googlegroups.com...
>
>
>
> > Hi all,
>
> > Just having a bit of trouble in returning the results of the SQL
> > SELECT statement to a textbox
>
> > This is only to return one row and i'm not sure how to get it to
> > display in the text box.
>
> > here is my code so far
>
> > Private Sub Btn_find_Click(ByVal sender As System.Object, ByVal e
> > As System.EventArgs) Handles Btn_find.Click
> > sql.ConnectionString = ("Data Source=" +
> > Me.Combo_kiosk.Text.ToString() + ";Application Name = " +
> > Application.ProductName + ";Initial Catalog=test;Integrated
> > Security=SSPI")
> > sql.Open()
>
> > cmd.Connection = sql
> > cmd.CommandType = CommandType.Text
> > cmd.CommandText = "SELECT OfferID FROM smspromotionaloffer
> > WHERE OfferKioskText LIKE '%" + Me.txt_input.Text + "%'"
>
> > 'cmd.ExecuteReader()
>
> > Dim ds As New DataSet()
> > Dim da As New SqlClient.SqlDataAdapter(cmd)
> > da.Fill(ds, "Output")
> > txt_offer.Text = ds.Tables(0).Columns(0).ToString
>
> > sql.Close()
>
> > End Sub
>
> > Atm i get the coloum name show in the textbox. i'm rather new to
> > programing and i know thats not the right way of doing this.
>
> > thanks in adavance
>
> > Andy- Hide quoted text -
>
> - Show quoted text -

<backwards15@gmail.com> wrote in message
news:1180323677.122033.31390@q19g2000prn.googlegroups.com...
> Hi all,
>
> Just having a bit of trouble in returning the results of the SQL
> SELECT statement to a textbox
>
> This is only to return one row and i'm not sure how to get it to
> display in the text box.
>
> here is my code so far
>
> Private Sub Btn_find_Click(ByVal sender As System.Object, ByVal e
> As System.EventArgs) Handles Btn_find.Click
> sql.ConnectionString = ("Data Source=" +
> Me.Combo_kiosk.Text.ToString() + ";Application Name = " +
> Application.ProductName + ";Initial Catalog=test;Integrated
> Security=SSPI")
> sql.Open()
>
> cmd.Connection = sql
> cmd.CommandType = CommandType.Text
> cmd.CommandText = "SELECT OfferID FROM smspromotionaloffer
> WHERE OfferKioskText LIKE '%" + Me.txt_input.Text + "%'"
>
> 'cmd.ExecuteReader()
>
> Dim ds As New DataSet()
> Dim da As New SqlClient.SqlDataAdapter(cmd)
> da.Fill(ds, "Output")
> txt_offer.Text = ds.Tables(0).Columns(0).ToString
>
> sql.Close()
>
> End Sub
>
>
> Atm i get the coloum name show in the textbox. i'm rather new to
> programing and i know thats not the right way of doing this.
>
> thanks in adavance
>
> Andy
>

> On May 28, 5:34 pm, "Scott M." <s...@nospam.nospam> wrote:
>> Well, your code indicates that you want the name of a column in the
>> textbox.
>> Is that right, or did you want the value of one of the columns in your
>> textbox?
>>
>> Instead of this (to get the the first column's name):
>> txt_offer.Text = ds.Tables(0).Columns(0).ToString
>>
>> Use this to get the first column's value:
>> txt_offer.Text = ds.Tables(0).Rows(0).Item(0).ToString
>>
>> -Scott
>>
>> <backward...@gmail.com> wrote in message
>>
>> news:1180323677.122033.31390@q19g2000prn.googlegroups.com...
>>
>>
>>
>> > Hi all,
>>
>> > Just having a bit of trouble in returning the results of the SQL
>> > SELECT statement to a textbox
>>
>> > This is only to return one row and i'm not sure how to get it to
>> > display in the text box.
>>
>> > here is my code so far
>>
>> > Private Sub Btn_find_Click(ByVal sender As System.Object, ByVal e
>> > As System.EventArgs) Handles Btn_find.Click
>> > sql.ConnectionString = ("Data Source=" +
>> > Me.Combo_kiosk.Text.ToString() + ";Application Name = " +
>> > Application.ProductName + ";Initial Catalog=test;Integrated
>> > Security=SSPI")
>> > sql.Open()
>>
>> > cmd.Connection = sql
>> > cmd.CommandType = CommandType.Text
>> > cmd.CommandText = "SELECT OfferID FROM smspromotionaloffer
>> > WHERE OfferKioskText LIKE '%" + Me.txt_input.Text + "%'"
>>
>> > 'cmd.ExecuteReader()
>>
>> > Dim ds As New DataSet()
>> > Dim da As New SqlClient.SqlDataAdapter(cmd)
>> > da.Fill(ds, "Output")
>> > txt_offer.Text = ds.Tables(0).Columns(0).ToString
>>
>> > sql.Close()
>>
>> > End Sub
>>
>> > Atm i get the coloum name show in the textbox. i'm rather new to
>> > programing and i know thats not the right way of doing this.
>>
>> > thanks in adavance
>>
>> > Andy- Hide quoted text -
>>
>> - Show quoted text -
>
>
> thanks so much. The second of those two was the one i was after.
>
> Regards,
>
> Andy
>
>