[Solved] how to get data from sql server to visual studio in textbox?

Posted 2 Nov '12 - 20:32

Solution 1

fill your retrieved value from database in dataset and assign like

TextBox1.Text=ds.Tables(0).Rows(0).Item("columnname").value

Permalink

Posted 2 Nov '12 - 21:15

Anusha SR880

Edited 3 Nov '12 - 0:19

Savalia Manoj M5.8K

Comments

armarzook - 4 Nov '12 - 9:34

Used the below code to get what i want but its still not working... Private Sub ComboBox1_SelectedIndexChanged_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged TextBox2.Text = ComboBox1.SelectedValue con.ConnectionString = myconstring Dim da As New SqlDataAdapter("SELECT max(sl_no) as max FROM e1 where project_id='" + TextBox1.Text + "'", con) Dim dt As New DataTable da.Fill(dt) MsgBox("Connected") MsgBox(dt.Rows(0).Item("max").ToString) TextBox1.Text = dt.Rows(0).Item("max").ToString

Solution 2

Hi armarzook,

I would suggest you to use a BindingSource control to achieve this purpose.

For details, you can refer to the link below:
Quickest Way to Create a .NET Database Application[^]

Hope this helps!
Happy Coding Smile | :)

Best Regards,
Sunny K

Permalink

Posted 2 Nov '12 - 21:47

Sunnykumar082.5K

Solution 3

Hi
may be your problem is grid textbox assigning your datebase value thats right

protected void gridview1_RowDataBound(object sender, GridViewRowEventArgs e)
   {
       if (e.Row.RowType == DataControlRowType.DataRow)
       {
        Textbox TextBox1= ((Textbox)e.Row.FindControl("textboxID"));
          TextBox1.Text=ds.Tables(0).Rows(0).Item("columnname").value
                    
         }
       }

pls check that one

Permalink

Posted 2 Nov '12 - 23:16

E.moorthy286

Edited 3 Nov '12 - 0:19

Savalia Manoj M5.8K

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

0	Sergey Alexandrovich Kryukov	415
1	OriginalGriff	315
2	Slacker007	240
3	Maciej Los	240
4	Aarti Meswania	210

0	Sergey Alexandrovich Kryukov	8,953
1	OriginalGriff	7,134
2	CPallini	3,758
3	Rohan Leuva	3,066
4	Maciej Los	2,528

how to get data from sql server to visual studio in textbox?

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

		9,885,179 members (32,520 online) Visit CodeProject.TV Discuss CodeProject.TV Sign in Email Password Forgot your password? Sign in using

Interested
Ignored

how to get data from sql server to visual studio in textbox?

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us