is this the complete code or have you missed some portion of it.

Thank you everyone. I figured out the latter part as well.

u said the only change tht u have made is the name of the column in ur database.
i hope u have also changed the name of the column in your code as well..
for example in the insert query u shud...

ok got the error now its working.
now i also want to add a check box column in the datagridview.
however i want it to be the column in the extreme right.
i can simply create a new check box...

the rows are generated but every column is blank

i tried it the adatapost's way

dataGridView1.DataSource = null;

OleDbDataAdapter clientinfoDataAdapter;
DataTable clientinfoDataTable = new DataTable();
...

thnx a lot guys..

option = Console.ReadLine();

m using ms access and c#
i fetch the data frm the database which includes sr.no. and store in a data table.
i thn display the contents using a datagridview.
everythin is working fine..
heres the...

problm solved dont no how...thnx ne ways...

also tried the following code

SqlConnection connect;
string con = "Data Source = localhost; Initial Catalog=master ;Integrated Security = True;";
connect...

m using visual studio 2005 and sql server 2005.
i want to create a backup of the sql server which m doin using the following code..

if (saveBackupDialog.ShowDialog() == DialogResult.OK)
...

some kind of sample code will be very helpful

first add a check box column to the datagridview.
to do this click on the datagridview control on ur form.
click on the right arrow on the top of ur datagrid.
click edit columns
add a column and...

in excel 07 the limit is 1048567. however even if this many rows are filled up cant we use another sheet.
and i was looking forward to export it in a single excel file with multiple workbooks....

hie
m using visual studio 2005 and sql 2005
i want to export my sql database to excel..

hie lennie..
i have visual studio 2005 and the code works fine. not sure about visual 2003 but u can still giv it a try...

textbox1.text =...