Register  |  Login




Advertisement

Start Your Own Q&A Site

Create your own Q&A site easily, allowing you to quickly grow a new community around any subject matter or generate new organic traffic for your existing website.

Question

Status: Open Points: 75 Time: 23:00 - Dec 28, 2008  

priyaravi2008

how to insert new row in gridview at design time?

i want to insert new record in gridview at runtime?

Categories

Answer Discussion
Tutorials

 

thiruhitech

Date:: Mar 12, 2009

Time:: 07:23

SqlConnection connection = new SqlConnection(connection string);
connection.Open();
string sql = "insert into table_name values('','','','','');
SqlDataAdapter dp = new SqlDataAdapter(sql, connection);
DataSet ds = new DataSet();
dp.Fill(ds);
grid_name.DataBind();
connection.Close();

priyaravi2008

Date:: Mar 12, 2009

Time:: 23:40

thankyou for your response.this codings is used to bind the table in gridview i want to insert new row in datatable at design its possible?

thiruhitech

Date:: Mar 13, 2009

Time:: 03:12

try this one
string sql = "SELECT * FROM TeamMember_table";
SqlDataAdapter dp = new SqlDataAdapter(sql, connection);
DataSet ds = new DataSet();
dp.Fill(ds);
DataTable table = ds.Tables[0];
table.Rows.Add("", "", ..., "")

priyaravi2008

Date:: Mar 20, 2009

Time:: 07:33

thankyou thiru.

Answer this Question

New User

Email:

Upon submission of this form, you will automatically be registered as a Quomon user and we will send your login information to this address

Registered User

Username:

Password:

Forgot Your Password?

Tutorials cannot be submitted until the Answer Discussion is complete.

Submit answers in the Answer Discussion area

Similar Questions

Earn money by sharing your knowledge through Quomon's revenue sharing program

Ask a Question

Have a new question? Ask!

You have 100 characters to use



Top Experts

View More

Rank

Expert

Points

1.

nidhi

10354

2.

oracleofDelphi

6493

3.

rcastagna

5596

4.

LAGM

4848

5.

PeterNZ

3487

6.

gonzalo

2840

7.

Mason

2770

8.

jgivoni

2303

9.

xarcus

1820

10.

Anpanman

917

Become an Expert

Register today to share your knowledge with the community and be recognized and rewarded for your contributions.


Register Here




"Psst, Quomon is a great site. Pass it on."     Tell a Friend  |   Link To Us  |   Save to Delicious  |   Digg! Digg it



Language Options

English:

www.quomon.com

Español:

www.quomon.es