C#

FirstPrevNext

Re: Exception valerian.precop10-Jul-07 20:36 valerian.precop 10-Jul-07 20:36  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... Re: Exception sangramkp10-Jul-07 21:17 sangramkp 10-Jul-07 21:17  Hi Valy, I changed the code as you said but the exception is same. Regards Sangram Re: Exception Brady Kelly10-Jul-07 21:40 Brady Kelly 10-Jul-07 21:40  Parameters are certainly not only for stored procedures. Please read about good practice and parameters before giving bad advice. Here is a start: http://www.csharp-station.com/Tutorials/AdoDotNet/Lesson06.aspx[^] Re: Exception Rhys Gravell10-Jul-07 22:33 Rhys Gravell 10-Jul-07 22:33  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 Re: Exception valerian.precop10-Jul-07 21:39 valerian.precop 10-Jul-07 21:39  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... Re: Exception mav.northwind11-Jul-07 8:52 mav.northwind 11-Jul-07 8:52  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... Re: Exception Rhys Gravell10-Jul-07 22:29 Rhys Gravell 10-Jul-07 22:29  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 event fire SwaSubhaVijju10-Jul-07 19:20 SwaSubhaVijju 10-Jul-07 19:20  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.. Re: event fire _AK_10-Jul-07 19:37 _AK_ 10-Jul-07 19:37  SwaSubhaVijju wrote: i am in interview of machine test... Are you giving any exam? Apurva Kaushal Re: event fire Vikram A Punathambekar10-Jul-07 19:43 Vikram A Punathambekar 10-Jul-07 19:43  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. Re: event fire SwaSubhaVijju10-Jul-07 19:54 SwaSubhaVijju 10-Jul-07 19:54  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... Re: event fire gauthee10-Jul-07 19:59 gauthee 10-Jul-07 19:59  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 Re: event fire gauthee10-Jul-07 20:04 gauthee 10-Jul-07 20:04  You can check out this link: http://www.c-sharpcorner.com/UploadFile/sd_patel/DataGridClientSideEvents11232005064819AM/DataGridClientSideEvents.aspx Gautham datagrid SwaSubhaVijju10-Jul-07 19:03 SwaSubhaVijju 10-Jul-07 19:03  hi......... how to get event in datagrid(when i press in cell of datagrid it should display alert message) help me please...... Re: datagrid Sathesh Sakthivel10-Jul-07 19:18 Sathesh Sakthivel 10-Jul-07 19:18  Don't Cross post in Multiple Forums. 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 Re: datagrid SwaSubhaVijju10-Jul-07 19:22 SwaSubhaVijju 10-Jul-07 19:22  i didnt get u what do u mean Re: datagrid Sathesh Sakthivel10-Jul-07 19:26 Sathesh Sakthivel 10-Jul-07 19:26  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 Re: datagrid Steve Echols10-Jul-07 19:28 Steve Echols 10-Jul-07 19:28  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! Re: datagrid Steve Echols10-Jul-07 19:26 Steve Echols 10-Jul-07 19:26  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! Re: datagrid SwaSubhaVijju10-Jul-07 19:53 SwaSubhaVijju 10-Jul-07 19:53  thanks.... but i didnt get u if possible clear once again while i input "at" to serialport in my program,but return "at" not as excepted "ok"? supercsharp110-Jul-07 18:46 supercsharp1 10-Jul-07 18:46  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); } } } MAPI with C# gihankoli10-Jul-07 18:13 gihankoli 10-Jul-07 18:13  Hi All Any one know how to retrieve outlook appointment using MAPI and C# gihan koli Re: MAPI with C# Sathesh Sakthivel10-Jul-07 18:33 Sathesh Sakthivel 10-Jul-07 18:33  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 Enum working with string array saymajum10-Jul-07 16:38 saymajum 10-Jul-07 16:38  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#? Re: Enum working with string array PIEBALDconsult10-Jul-07 16:50 PIEBALDconsult 10-Jul-07 16:50  Did you read my reponse to your earlier post? If you did, but didn't like it, try: System.Enum.GetNames ( typeof(YourEnumTYpe) )

Last Visit: 31-Dec-99 18:00     Last Update: 16-May-24 3:42 Refresh ᐊ Prev1...8973897489758976897789788979898089818982 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

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