insert data from textbox with multiple lines contents into sql table

Question

i have put the following code in .aspx

<asp:TextBox ID="txtyourwords" runat="server" Rows="1" TextMode="MultiLine">
</asp:TextBox>


SqlCommand cmd = new SqlCommand("Insert INTO planning_t (date,course,planning) values("+Calendar1.SelectedDate.ToShortDateString()+","+DropDownList2.SelectedIt‌‌em.Text+","+txtyourwords.Text.ToString()+" )", con);

now i want to insert the contents of textbox--(txtyourwords) into a table... what will be code in C# for .cs file. and datatype for this column is varchar(MAX).

error is: Error getting data. Incorrect syntax near 'Engineering'. 'Engineering' is dropdownlist.selecteditem.text — user4569202
– user4569202, Commented Feb 17, 2015 at 17:16
{SqlCommand cmd = new SqlCommand("Insert INTO planning_t (date,course,planning) values("+Calendar1.SelectedDate.ToShortDateString()+","+DropDownList2.SelectedIt‌em.Text+","+txtyourwords.Text.ToString()+" )", con);} — user4569202
– user4569202, Commented Apr 14, 2015 at 7:08

user4569202 · Accepted Answer · 2015-04-14 06:35:16Z

1

SqlCommand cmd = new SqlCommand("Insert INTO planning_t (date,course,planning) values('"+Calendar1.SelectedDate.ToShortDateString()+"','"+DropDownList2.SelectedIt‌em.Text+"','"+txtyourwords.Text.ToString()+"' )", con);

answered Apr 14, 2015 at 6:35

user4569202

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

Collectives™ on Stack Overflow

insert data from textbox with multiple lines contents into sql table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related