vb.net and gridview

[rockyy]

can anyone help me how to add data if i click on Add button(user input)

and view data in gridview control

database already made using(sql server)
ty

[GaryMazzone]

What is the process behind the add button.

Are you adding directly to the database?
Is the grid populated with a dataset?
If populaated by a dataset are there Update, Insert and Delete statements defined on the data adapter?

[rockyy]

ya i want it directly added to a database which takes user input from textbox's/combo box's

sql server:-database name(mygary)

[GaryMazzone]

Then once the query fires to insert the new data you will need to requery the database to refill the grid. If it is a data set you might be able to call refresh on it.

[rockyy]

if the query fires once(insert into my gary values(......) i can't refill the gird so u can tell me how to do it with data set thanx

[GaryMazzone]

How do you fill the grid to start with?

[rockyy]

bro i wanna use the dgv(datagrid view) only to view table enteres which are being made at sql server
only to display those values
if my table has 3 fields(id,name,password) containing value(gary,"mazzona","mazzone")
so my datagrid view should display these values

[rockyy]

if anyone here knows please reply
thanx

[GaryMazzone]

You write a select statement to run against the database. That is what I'm asking you how do you fill the grid to start with. According to your comments you don't at this point.

I suggest you Look at the FAQ at the top of the database fourm and look thought the ADO.Net tutorial.