|
My code looks like this:
List<string> items;
private void button2_Click(object sender, EventArgs e)
{
//finalize button click
items = new List<string>();
for (int i = 0; i < passagelistBox.Items.Count; i++)
{
items.Add(passagelistBox.Items[i].ToString());
}
foreach (string currentitem in items)
{
DoInsertData(currentitem.Split(new char[] {','}));
}
}
private void DoInsertData(string[] item)
{
string sql = "INSERT INTO tblPassages (column_num, row_num) VALUES (@p1, @p2)";
cmd.CommandText = sql;
SqlParameter p1 = new SqlParameter("@p1", item[0]);
SqlParameter p2 = new SqlParameter("@p2", item[1]);
cmd.Parameters.Add(p1);
cmd.Parameters.Add(p2);
p1.SqlDbType = SqlDbType.VarChar;
p2.SqlDbType = SqlDbType.VarChar;
cmd.Connection = cn;
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
cmd.Connection = null;
}
while I wxecute this code at the line : cmd.ExecuteNonQuery(); a exception is raised as follws:
System.Data.SqlClient.SqlException was unhandled
Message="String or binary data would be truncated.\r\nThe statement has been terminated."
Source=".Net SqlClient Data Provider"
ErrorCode=-2146232060
Class=16
LineNumber=1
Number=8152
Procedure=""
Server="localhost"
State=2
StackTrace:
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at SeatLayout.Form1.DoInsertData(String[] item) in D:\Box Office\SeatLayout\SeatLayout\Form1.cs:line 179
at SeatLayout.Form1.button2_Click(Object sender, EventArgs e) in D:\Box Office\SeatLayout\SeatLayout\Form1.cs:line 161
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.Run(Form mainForm)
at SeatLayout.Program.Main() in D:\Box Office\SeatLayout\SeatLayout\Program.cs:line 17
at System.AppDomain.nExecuteAssembly(Assembly assembly, String[] args)
at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
Please help me.....
Thanks in advance..
Regards
Sangram
|
|
|
|
|
why do you use those two parameters @p1 and @p2 when you can simply do something like this:
string sql = "INSERT INTO tblPassages (column_num, row_num) VALUES ('" + item[0] + "','" + item[1] + "')";
I presume that column_num and row_num are string values in the database.
Usually you use parameters when you use a stored procedure to execute a query.
So you don't need these lines
SqlParameter p1 = new SqlParameter("@p1", item[0]);
SqlParameter p2 = new SqlParameter("@p2", item[1]);
cmd.Parameters.Add(p1);
cmd.Parameters.Add(p2);
p1.SqlDbType = SqlDbType.VarChar;
p2.SqlDbType = SqlDbType.VarChar;
Tell me if it helped... 
Just call me Valy...
|
|
|
|
|
Hi Valy,
I changed the code as you said but the exception is same.
Regards
Sangram
|
|
|
|
|
|
Please look at the problem when trying to help and please (as already has been said) don't give bad advice.
Looking at the message of the generated exception;
Message="String or binary data would be truncated.\r\nThe statement has been terminated."
...the cause is pretty obvious and if you're not aware of the cause, I imagine a Google search on this would tell you exactly what you need to know.
Rhys
"The trouble with having an open mind, of course, is that people will insist on coming along and trying to put things in it"
They say a little knowledge is a dangerous thing, but it's not one half so bad as a lot of ignorance."
Terry Pratchett
|
|
|
|
|
SqlConnection conn = new SqlConnection(connectionString); //the sql connection
conn.Open();
string strQuery = "insert into Temp(ProductName,Cantity) values ('"+item[0]+"',cast ('"+item[1]+"' as numeric(5,0)))"; //the query
SqlCommand com1 = new SqlCommand(strQuery, conn); //the sql command
com1.ExecuteNonQuery();
conn.Close();
These is a sample of my code that works just fine. Are you sure the fields in the table are corect...
In my sample the table Temp has 2 fields, ProductName is nchar(50) and Cantity is numeric(5,0).
Be careful with the " ' " also (string values must be placed between ' in a query otherwise it doesn't work).
Just call me Valy...
|
|
|
|
|
As you've been told before, you should read (and understand) the problem and not give bad advice like building your SQL statements by string concatenation.
Hint: Google for "SQL injection".
The simple reason for the exception is (as the exception messages tells very clearly) that "String or binary data would be truncated." while trying to put some data into the database.
So obviously at least one of the values is longer than what the corresponding DB field can hold.
Regards,
mav
--
Black holes are the places where God divided by 0...
|
|
|
|
|
It looks like you're trying to insert a string value into a field when the length of the string is greater than the length of the dB field.
For example, you're trying to do something akin to inserting the string 'This string is too long for my data field' into a VARCHAR(10) field.
Rhys
"The trouble with having an open mind, of course, is that people will insist on coming along and trying to put things in it"
They say a little knowledge is a dangerous thing, but it's not one half so bad as a lot of ignorance."
Terry Pratchett
|
|
|
|
|
hi.
i am in interview of machine test...
help me please.
i need event in datagrid
when we clicking cell of datagrid using mouse then that particular cell color has to be chaged.
how can i do........
can anyone help me.......
thanking u..
|
|
|
|
|
SwaSubhaVijju wrote: i am in interview of machine test...
Are you giving any exam?
Apurva Kaushal
|
|
|
|
|
SwaSubhaVijju wrote: i am in interview of machine test...
You are aware this is cheating, right? 
Cheers,
Vıkram.
After all is said and done, much is said and little is done.
|
|
|
|
|
sorry i am not cheeting anyone...
they are providing me all facilities for search and do
i know i am a software engineer i wont cheet anyone...
|
|
|
|
|
Hi,
Go to your properties window of the datagrid, then go the events, there you would find the list of all datagrid events. You could select one as per your requirement.
Gautham
|
|
|
|
|
|
hi.........
how to get event in datagrid(when i press in cell of datagrid it should display alert message)
help me please......
|
|
|
|
|
Don't Cross post in Multiple Forums.
Regards,
Satips. ![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
Don't walk in front of me, I may not follow;
Don't walk behind me, I may not lead;
Walk beside me, and just be my friend. - Albert Camus
|
|
|
|
|
i didnt get u what do u mean
|
|
|
|
|
You have posted the same question in the Asp.Net forum and also here .
Hope now you got it what i said.
Regards,
Satips.
Don't walk in front of me, I may not follow;
Don't walk behind me, I may not lead;
Walk beside me, and just be my friend. - Albert Camus
|
|
|
|
|
Crikey! He's posting the same question in the same forum, just phrasing it different!
What a bastard!!
- S
50 cups of coffee and you know it's on!
|
|
|
|
|
You're going to have to dive into javascript to display an alert message.
Basically you can handle the ItemDataBound event, find the control you want to display the message for using FindControl, and do yourcontrol.Attributes.Add("onclick", "javascript: alert('whatever you want to say');")
- S
50 cups of coffee and you know it's on!
|
|
|
|
|
thanks....
but i didnt get u if possible clear once again
|
|
|
|
|
in my C# program,i input "at" in a textBox,then the program send "at" to serialport,but when i click receive button,the message I receive from serial port is the same as I input,namely "at",not "ok",why?who can answer my question?How I solve this problem and get the right response "ok" from serial port?
next is my code:
public partial class Form1 : Form
{
private SerialPort sp = null;
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
try
{
sp = new SerialPort("COM1");
sp.ReadTimeout = 5000;
sp.Open();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button2_Click(object sender, EventArgs e)
{
try
{
sp.Write(textBox1.Text);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button3_Click(object sender, EventArgs e)
{
try
{
/*string text=null;
char[] buffer = new char[10];
sp.Read(buffer,0,6);
for (int i = 0; i < buffer.Length; i++)
{
text += buffer[i];
}
textBox2.Text = text;*/
/*string text = null;
char t = (char)sp.ReadChar();
text+=t.ToString();
while (true)
{
t = (char)sp.ReadChar();
if (t == '\0') break;
else text += t.ToString();
}
textBox2.Text = text;*/
string text = null;
byte[] t = new byte[20];
char[] c = new char[20];
sp.Read(t, 0, t.Length);
sp.Read(t, 0, t.Length);
c = Encoding.ASCII.GetChars(t);
int i;
for (i = 0; i < c.Length; i++)
{
if (c[i] == 'O' || c[i] == 'K')
text += c[i].ToString();
}
textBox2.Text = text;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
|
|
|
|
|
Hi All
Any one know how to retrieve outlook appointment using MAPI and C#
gihan koli
|
|
|
|
|
Get it[^]
Regards,
Satips.
Don't walk in front of me, I may not follow;
Don't walk behind me, I may not lead;
Walk beside me, and just be my friend. - Albert Camus
|
|
|
|
|
I have a enum with string values.I want to store all this in a string array.
And want to check with a parameter of a function with the string array.
can any body has the code in c#?
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
