Click here to Skip to main content
15,921,959 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: CSS class or XSLT please help me Pin
ToddHileHoffer30-Jan-09 7:10
ToddHileHoffer30-Jan-09 7:10 
AnswerRe: CSS class or XSLT please help me Pin
Manas Bhardwaj30-Jan-09 10:44
professionalManas Bhardwaj30-Jan-09 10:44 
GeneralRe: CSS class or XSLT please help me Pin
indian14330-Jan-09 23:07
indian14330-Jan-09 23:07 
QuestionMembership API help is needed Pin
Rameez Raja30-Jan-09 5:24
Rameez Raja30-Jan-09 5:24 
AnswerRe: Membership API help is needed Pin
vaghelabhavesh30-Jan-09 5:46
vaghelabhavesh30-Jan-09 5:46 
JokeRe: Membership API help is needed Pin
GaryWoodfine 30-Jan-09 10:37
professionalGaryWoodfine 30-Jan-09 10:37 
GeneralRe: Membership API help is needed Pin
Rameez Raja30-Jan-09 15:40
Rameez Raja30-Jan-09 15:40 
QuestionError inserting through insertCommand Pin
AllPhee30-Jan-09 4:11
AllPhee30-Jan-09 4:11 
Hi there,
I am trying to insert some data into a database table and am getting an error which says
"String or binary data would be truncated. The statement has been terminated. "

What is the problem here pls help.

The error is at the ExecuteNonQuery Line 2nd last line.


Dim insertCommand As SqlCommand<br />
        Dim strConnection As String = "Data Source=cccc;Initial Catalog=Bccc;Integrated Security=True"<br />
        Dim objConnection As New SqlConnection(strConnection)<br />
        Dim strRate As String = "INSERT INTO tblTable(FkPId,RateType) VALUES (@PId,@Rate)"<br />
        insertCommand = New SqlCommand(strRate, objConnection)           <br />
objConnection.Open()<br />
<br />
insertCommand.Parameters.AddWithValue("@PId", ddlRooms.SelectedValue)<br />
insertCommand.Parameters.AddWithValue("@Rate", ddlRate.SelectedValue)<br />
                   <br />
insertCommand.ExecuteNonQuery()<br />
objConnection.Close()<br />


allphpro

AnswerRe: Error inserting through insertCommand Pin
ToddHileHoffer30-Jan-09 4:57
ToddHileHoffer30-Jan-09 4:57 
GeneralRe: Error inserting through insertCommand Pin
AllPhee1-Feb-09 19:12
AllPhee1-Feb-09 19:12 
QuestionJavascript onresize in an ASP.Net web page [May Be Solved] Pin
#realJSOP30-Jan-09 3:36
professional#realJSOP30-Jan-09 3:36 
AnswerRe: Javascript onresize in an ASP.Net web page Pin
Manas Bhardwaj30-Jan-09 4:10
professionalManas Bhardwaj30-Jan-09 4:10 
GeneralRe: Javascript onresize in an ASP.Net web page Pin
#realJSOP30-Jan-09 4:24
professional#realJSOP30-Jan-09 4:24 
AnswerRe: Javascript onresize in an ASP.Net web page Pin
ToddHileHoffer30-Jan-09 4:55
ToddHileHoffer30-Jan-09 4:55 
GeneralRe: Javascript onresize in an ASP.Net web page Pin
#realJSOP30-Jan-09 5:38
professional#realJSOP30-Jan-09 5:38 
GeneralRe: Javascript onresize in an ASP.Net web page Pin
#realJSOP30-Jan-09 6:37
professional#realJSOP30-Jan-09 6:37 
GeneralRe: Javascript onresize in an ASP.Net web page Pin
Christian Graus30-Jan-09 15:26
protectorChristian Graus30-Jan-09 15:26 
GeneralRe: Javascript onresize in an ASP.Net web page Pin
#realJSOP31-Jan-09 3:01
professional#realJSOP31-Jan-09 3:01 
QuestionServer Error Pin
5fingers30-Jan-09 3:06
5fingers30-Jan-09 3:06 
AnswerRe: Server Error Pin
ToddHileHoffer30-Jan-09 3:20
ToddHileHoffer30-Jan-09 3:20 
QuestionAJAX UpdatePanel control Pin
Radhakrishnan G.30-Jan-09 3:06
Radhakrishnan G.30-Jan-09 3:06 
QuestionTreeView Control Pin
Civic0630-Jan-09 2:28
Civic0630-Jan-09 2:28 
AnswerRe: TreeView Control Pin
ToddHileHoffer30-Jan-09 2:34
ToddHileHoffer30-Jan-09 2:34 
GeneralRe: TreeView Control Pin
Civic0630-Jan-09 2:55
Civic0630-Jan-09 2:55 
GeneralRe: TreeView Control Pin
ToddHileHoffer30-Jan-09 3:09
ToddHileHoffer30-Jan-09 3:09 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.