WinForm adds data to the DataGridView control when the TextBox enters data and clicks the Add button

You can use dataset

It's very convenient. Perform operations on adding, deleting, and modifying datarows.

Every time you do it.

The datagridview is also changed once.

After the change is complete, use the dataadapter to save it to the database.

datatable dt = new datatable();

datacolumn dc ;

dc = new datacolumn("Time", typeof(string));

dc = new datacolumn("Number",typeof(string));

dc = new datacolumn("Name",typeof(string));

datarow dr;

dr = ;

dr["Time"] = "2009－6－30";

dr["Number"] = "001";

dr["Name"] = "Zhang San";;

If it's just a cell that is displayed to datagridciew, you can write it like this:

Here the line index is written].cells[write column index here].value = ;

The first step is to write a query method in your public class to return the dataset, and the second step is to call the method in the load event or query event to bind the datagridview

Step 3: Add when adding a piece of data is successful. Just re-call the method that returns the dataset to bind the datagridview. This is generally the case.

Hope it helps.

When the addition is successful, the method of the query is called, and the DataGridView is assigned, which is the easiest, and we generally do this, and we do it at work.

After the interface is drawn, add a click event to the button, and click the event to connect to the database to add data. The content referenced by the library you use is different, and the data manipulation class is written differently.

Is the data that DataGridView needs to display in the database? textbox is a search condition, and you need to be able to hi me.

Hi, I'll do it for you, you write the rough one first, and I'll change it for you.

Beginner? Minute problems need to be done by others?

There is no binding between command and connection!

Create a constructor for command to use.

sqlcommand com = new sqlcommand(con);

Get the assignment of the connection property of sqlcommand = con

First of all, make sure that the database contains as much data as you can find.

Is the SQL statement you queried correct, try writing it like this:

select * from [dbo].[flight schedule] where departure city='" + str1 + "'and Arrival City='" + str2 + "'";

There's just not knowing if your datagridview is data-bound

Place two widgets at the same time, initialize the shape, and click the button;

In the click event of the button, when you click the button, the label control is dynamically deleted and a textbox control is dynamically added.

datatable dt=new datatable();

Add three columns. one");

two");

three");

Each click of the button is written inside the event.

datarow dr=;

dr["one"]=this.the first text box value; Assign the value dr[ to the first column"two"]=this.the second text box value; Assign the value dr[ to the second column"three"]=this.

the third text box value; Assign a value to the third column; Add this line to the datatable.

At last; Bind a datagridview

Use the array to save the value you get, and then bind the list array to the gridview.

When you add a column to DataGridView, you can select the type of the column, including TextBox, Button, LinkLabel, etc., and have a property called ColumnType