inserting date using c#.Net into SQL Server 2008 using insert query

Question

I am making desktop application using C#.NET and SQL Server 2008.......in which i took one label name date and had a toolbox datetime picker.and also took field name date in database...........nw i want to insert the date throgh form using datetimepicker and get get inserted in datatbase.......

using code

SqlConnection con = new SqlConnection("Data Source=SW-PC-20;Integrated security =SSPI;Initial catalog=PSM");

con.Open();

SqlCommand cmd = new SqlCommand("insert into Campaign(Campaign_id,List_of_thresholds,Duration,Starting_Date,Ending_Date,Total_Budget_of_all_thresholds) values (" + Convert.ToInt32(cbocampaign.Text) + ",'" + cbolist_threshold.Text + "',' " + txtduration.Text + " '," + Convert.ToDateTime(DateTimePicker1.Text) + "," + Convert.ToDateTime(DateTimePicker2.Text) + "," + Convert.ToInt32(txtbudget.Text) + ")", con);

            cmd.ExecuteNonQuery();

MessageBox.Show("Insertion successfully done");

*PROBLEM :*it is not able to convert datetime picker error occuring .....

Convert.ToDateTime(DateTimePicker1.Text) `

Please give me solution for this and also give me the coding of fetching data into textboxes using data grid view

regards

shivani

Oh, if only the DateTimePicker control exposed the selected value as a DateTime, rather than forcing you to fiddle about with the datetime as a text value. Oh. msdn.microsoft.com/en-us/library/… — Damien_The_Unbeliever
– Damien_The_Unbeliever, Commented Apr 28, 2011 at 9:40

Arsen Mkrtchyan · Accepted Answer · 2011-04-28 09:26:42Z

5

Use SqlParameter instad of concuting string, it will solve your problem, and prevent sql injection

answered Apr 28, 2011 at 9:26

Arsen Mkrtchyan

50.9k33 gold badges155 silver badges187 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Maksim Kondratyuk · Accepted Answer · 2011-04-28 09:28:54Z

1

I think the problem is in default datetime format. You can try to parse datetime using DateTime.ParseExact http://msdn.microsoft.com/en-us/library/w2sa9yss.aspx.

answered Apr 28, 2011 at 9:28

Maksim Kondratyuk

1,39916 silver badges27 bronze badges

Comments

edze · Accepted Answer · 2011-04-28 09:46:17Z

1

this.dateTimePicker1.Value.ToString("dd.MM.yyyy")

Furthermore, I agree with ArsenMkrt, it is better to use parameters.

answered Apr 28, 2011 at 9:46

edze

3,0331 gold badge25 silver badges29 bronze badges

Collectives™ on Stack Overflow

inserting date using c#.Net into SQL Server 2008 using insert query

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related