Click here to Skip to main content
15,891,629 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
First I have taken chekbox with years-2010,2011,2012
Datagridview with months(desc,jan,feb....dec),desc as primary key
1)I want to insert year into database based on checkbox selection(i.e,I am not taking year in gridview).
2)If I am doing changes in perticularrow,that perticular year having that month only has to reflect,how it is possible???

in my code i have used
SQL
Dim cb As New SqlCommandBuilder(adp)

adp.Update(ds, "Prof_fees")
for data to be update in database,but problem is with year...

Plz help me in this regard,if possible plz provide sample code.

Thanks in advance……
Posted
Comments
Karwa_Vivek 24-May-11 7:06am    
not Clear
Can you please Elaborate your problem little more
Kschuler 24-May-11 15:11pm    
Please edit your question and clarify. You're saying your grid only has the months, but you want to a date to your database using the year from checkboxes outside the grid? You may want to provide more information about your database and how your file and column is structured. What happens when you run your code that is incorrect? Do you get an error message? If so, what is it?

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900