Setting the value of insert parameter of SqlDataSource in codebehind

Question

I have this SqlDataSource in my form:

<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 

        InsertCommand="INSERT INTO [contact] ([Name], [phone], [email], [comment], [time]) VALUES (@Name, @phone, @email, @comment, @time)" 
        oninserting="SqlDataSource1_Inserting" >
        <InsertParameters>
            <asp:ControlParameter ControlID="TBname" Name="Name" PropertyName="Text" Type="String" />
            <asp:ControlParameter ControlID="TBphone" Name="phone" PropertyName="Text" Type="String" />
            <asp:ControlParameter ControlID="TBemail" Name="email" PropertyName="Text" Type="String" />
            <asp:ControlParameter ControlID="TBmessage" Name="comment" PropertyName="Text" Type="String" />
        </InsertParameters>
    </asp:SqlDataSource>

And I have this function which has to save the values of TextBoxes in first four fields and current time in fifth field:

protected void SaveToDB(object sender, EventArgs e)
{
        SqlDataSource1.InsertParameters["time"].DefaultValue = DateTime.Now.ToString();
        SqlDataSource1.Insert();
}

4 of 5 fields get their values from some TextBoxes in my form. now problem is the last field: time which I can't set it's value. When the function runs, gives you this error:

Exception Details: System.Data.SqlClient.SqlException: String or binary data would be truncated. The statement has been terminated.

What should I do?

thank you for taking time.

@JaneDoe: Yes! that'll do. first, please write your your comment as an answer so i can tick it true answer. type of "time" field in my db was char(10), which i made it char(Max) and it's good now. thank you, — Mahyar Kakaee
– Mahyar Kakaee, Commented Jun 3, 2012 at 9:00

andrewsi · Accepted Answer · 2012-09-25 21:49:21Z

3

You should be able to use the SQL GetDate function directly in the InsertCommand without using code-behind.

InsertCommand="INSERT INTO [contact] ([Name], [phone], [email], [comment], [time]) VALUES (@Name, @phone, @email, @comment, GetDate())"

edited Sep 25, 2012 at 21:49

andrewsi

10.7k132 gold badges37 silver badges52 bronze badges

answered Sep 25, 2012 at 21:31

Dave

6691 gold badge6 silver badges13 bronze badges

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

Comments

Thousand · Accepted Answer · 2012-06-03 11:56:45Z

2

try this:

DateTime.Now.ToShortDateString();

"String or binary data would be truncated." usually has to do with fields in databases having a smaller size then what you're trying to put into it.

edited Jun 3, 2012 at 11:56

answered Jun 3, 2012 at 11:43

Thousand

6,6484 gold badges41 silver badges46 bronze badges

Collectives™ on Stack Overflow

Setting the value of insert parameter of SqlDataSource in codebehind

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related