Click here to Skip to main content
Sign Up to vote bad
good
See more: C#
Run Mode screen as follows; Save(Button)
 
Date Session CK RK MK Gs VB SJ

1/1/2013 1 REO PH2 TFC
 

 
Date Base Design as follows;
 
Date Datetime
Session number
Course Text
Faculty_Code Text
 
In database i want to save the above output as follows;
 
Date session Course Faculty_Code
1/1/2013 1 REo CK
1/1/2013 1 PH2 RK
1/1/2013 1 TFC MK
1/12013 1 GS
1/12013 1 VB
1/1/2013 1 Sj
 
i saved the insert values in the database it is working. i want to save null values in the database.
 
it is a windows application using c sharp.
 
how can i do.
 
when i click the save button output i get already as follows in datagridview;
 

Date session Course Faculty_Code
1/1/2013 1 REo CK
1/1/2013 1 PH2 RK
1/1/2013 1 TFC MK
 
Then i want to null values also in the database also as follows.
 
1/12013 1 GS
1/12013 1 VB
1/1/2013 1 Sj
Posted 30-Jan-13 6:26am


1 solution

You need to use a query to save data in the database.
 
To save null values
1) Make sure the columns in the tables allow saving nulls.
2) Go ahead and save values in these fields using the query.
  Permalink  

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

  Print Answers RSS
Your Filters
Interested
Ignored
     
0 Sergey Alexandrovich Kryukov 6,889
1 Prasad_Kulkarni 3,671
2 OriginalGriff 3,359
3 _Amy 3,312
4 CPallini 2,925


Advertise | Privacy | Mobile
Web02 | 2.6.130617.1 | Last Updated 30 Jan 2013
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid