urgent: can any one plz solve my problem regading SQL Query
-
i am developing an application in ASP.net,i am using the following sql query, but in SQL Server "criminal" table i want the same record to be inserted, so can anyone tell me how to merge the two queries in one query so that only one row is inserted strQuery = "INSERT INTO criminal(cr_name,no_times,cr_desc,cr_pic,fing_print)VALUES('" + textBox1.Text + "','" + textBox5.Text + "','" + textBox4.Text + "','" + textBox6.Text + "','" + textBox7.Text + "')"; strQuery = "INSERT INTO criminal(pic_name) SELECT substring(cr_pic,11,30) FROM criminal";
-
i am developing an application in ASP.net,i am using the following sql query, but in SQL Server "criminal" table i want the same record to be inserted, so can anyone tell me how to merge the two queries in one query so that only one row is inserted strQuery = "INSERT INTO criminal(cr_name,no_times,cr_desc,cr_pic,fing_print)VALUES('" + textBox1.Text + "','" + textBox5.Text + "','" + textBox4.Text + "','" + textBox6.Text + "','" + textBox7.Text + "')"; strQuery = "INSERT INTO criminal(pic_name) SELECT substring(cr_pic,11,30) FROM criminal";
Try this strQuery = "INSERT INTO criminal(cr_name,no_times,cr_desc,cr_pic,fing_print,pic_name)VALUES('" + textBox1.Text + "','" + textBox5.Text + "','" + textBox4.Text + "','" + textBox6.Text + "','" + textBox7.Text + "','" + substring(textBox6.Text,11,30)+"')";
-
i am developing an application in ASP.net,i am using the following sql query, but in SQL Server "criminal" table i want the same record to be inserted, so can anyone tell me how to merge the two queries in one query so that only one row is inserted strQuery = "INSERT INTO criminal(cr_name,no_times,cr_desc,cr_pic,fing_print)VALUES('" + textBox1.Text + "','" + textBox5.Text + "','" + textBox4.Text + "','" + textBox6.Text + "','" + textBox7.Text + "')"; strQuery = "INSERT INTO criminal(pic_name) SELECT substring(cr_pic,11,30) FROM criminal";
Pardon me if i'm missunderstood, but those two queries is tend to insert different value to the table, so what is the reason you should merge them into one query?? maybe you could execute only one query by your application code , such as if xxx = "true" then strQuery = "INSERT INTO criminal(cr_name,no_times,cr_desc,cr_pic,fing_print)VALUES('" + textBox1.Text + "','" + textBox5.Text + "','" + textBox4.Text + "','" + textBox6.Text + "','" + textBox7.Text + "')"; else strQuery = "INSERT INTO criminal(pic_name) SELECT substring(cr_pic,11,30) FROM criminal"; end if
-
Try this strQuery = "INSERT INTO criminal(cr_name,no_times,cr_desc,cr_pic,fing_print,pic_name)VALUES('" + textBox1.Text + "','" + textBox5.Text + "','" + textBox4.Text + "','" + textBox6.Text + "','" + textBox7.Text + "','" + substring(textBox6.Text,11,30)+"')";
-
Pardon me if i'm missunderstood, but those two queries is tend to insert different value to the table, so what is the reason you should merge them into one query?? maybe you could execute only one query by your application code , such as if xxx = "true" then strQuery = "INSERT INTO criminal(cr_name,no_times,cr_desc,cr_pic,fing_print)VALUES('" + textBox1.Text + "','" + textBox5.Text + "','" + textBox4.Text + "','" + textBox6.Text + "','" + textBox7.Text + "')"; else strQuery = "INSERT INTO criminal(pic_name) SELECT substring(cr_pic,11,30) FROM criminal"; end if
i cant apply if because i want to insert one record which includes the columns in both queries, actually i want some solution to insert cr_name,no_times,cr_desc,cr_pic,fing_print,pic_name using one query not two separate SQL quries i want one row to be inserted
-
i am developing an application in ASP.net,i am using the following sql query, but in SQL Server "criminal" table i want the same record to be inserted, so can anyone tell me how to merge the two queries in one query so that only one row is inserted strQuery = "INSERT INTO criminal(cr_name,no_times,cr_desc,cr_pic,fing_print)VALUES('" + textBox1.Text + "','" + textBox5.Text + "','" + textBox4.Text + "','" + textBox6.Text + "','" + textBox7.Text + "')"; strQuery = "INSERT INTO criminal(pic_name) SELECT substring(cr_pic,11,30) FROM criminal";
1 - try reading the post on how to ask questions 2 - try using parameterised queries, so you're not open to injecton attacks 3 - try using real variable names, so your code is readable What was the question ? The most logical way I can see to do this, is to drop a column which always contains a substring of a value in another column, that's just duplicaton of data. Work out the pic name from the path in code, or write a proc that returns it as seperate data, but based entirely on the one column that contains all the data you need. OR, a yucky way to do it that would at least work, would be to store the Id of the column in question, and then update ony that, instead of doing an insert, which is obviously not what you want.
Christian Graus - Microsoft MVP - C++ "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
-
i had tried the same query but the following error comes Error 14 The name 'substring' does not exist in the current context C:\Documents and Settings\mehwish\My Documents\Visual Studio 2005\Projects\rescue15\new_wanted_criminal_record.cs 654 230 rescue15
Check if this works out strQuery = "INSERT INTO criminal(cr_name,no_times,cr_desc,cr_pic,fing_print,pic_name)VALUES('" + textBox1.Text + "','" + textBox5.Text + "','" + textBox4.Text + "','" + textBox6.Text + "','" + textBox7.Text + "','" + textBox6.Text.Substring(11,30) +"')";
-
Check if this works out strQuery = "INSERT INTO criminal(cr_name,no_times,cr_desc,cr_pic,fing_print,pic_name)VALUES('" + textBox1.Text + "','" + textBox5.Text + "','" + textBox4.Text + "','" + textBox6.Text + "','" + textBox7.Text + "','" + textBox6.Text.Substring(11,30) +"')";
-
again error comes. Error is ArgumentOutOfrangeException was unhandled Index and length must refer to a location within the string. Parameter name: length what do i do:(
you are getting that error bcos the length that u are specifying is greater than the no of the characters in the string. make sure that you are specifying the right parameters in order to extract the name for the pic...try this strQuery = "INSERT INTO criminal(cr_name,no_times,cr_desc,cr_pic,fing_print,pic_name)VALUES('" + textBox1.Text + "','" + textBox5.Text + "','" + textBox4.Text + "','" + textBox6.Text + "','" + textBox7.Text + "','" + textBox6.Text.Substring(11,textBox6.Text.Length-11) +"')"; i am assuming that the cr_pic name starts from the 11th position and u want it till the end. if you are still having a problem the post the format in which you are specifying the cr_pic
-
again error comes. Error is ArgumentOutOfrangeException was unhandled Index and length must refer to a location within the string. Parameter name: length what do i do:(
ya mavii u have tried to fetch the char in the string at the position outside the string Use the "IndexOf" fun keeping in mind that it starts from 0 and end at Length-1. Regards _________ Piyus Gupta
-
i am developing an application in ASP.net,i am using the following sql query, but in SQL Server "criminal" table i want the same record to be inserted, so can anyone tell me how to merge the two queries in one query so that only one row is inserted strQuery = "INSERT INTO criminal(cr_name,no_times,cr_desc,cr_pic,fing_print)VALUES('" + textBox1.Text + "','" + textBox5.Text + "','" + textBox4.Text + "','" + textBox6.Text + "','" + textBox7.Text + "')"; strQuery = "INSERT INTO criminal(pic_name) SELECT substring(cr_pic,11,30) FROM criminal";
STRQRY="INSERT INTO criminal SELECT '" + textBox1.Text + "','" + textBox5.Text + "','" + textBox4.Text + "','" + textBox6.Text + "','" + textBox7.Text + "' substring(cr_pic,11,30) FROM criminal "
-
i am developing an application in ASP.net,i am using the following sql query, but in SQL Server "criminal" table i want the same record to be inserted, so can anyone tell me how to merge the two queries in one query so that only one row is inserted strQuery = "INSERT INTO criminal(cr_name,no_times,cr_desc,cr_pic,fing_print)VALUES('" + textBox1.Text + "','" + textBox5.Text + "','" + textBox4.Text + "','" + textBox6.Text + "','" + textBox7.Text + "')"; strQuery = "INSERT INTO criminal(pic_name) SELECT substring(cr_pic,11,30) FROM criminal";
Other people have already answered the questions for you but I feel the need to weigh in on your architecture a little bit. 1. You really shouldn't rely on the default names that you get in Visual Studio. Consider renaming textBox1, et al, to more meaningful names. 2. Don't create direct SQL strings like this. This is bad bad practice which should be avoided at all costs because you have opened your code up to SQL Injection attacks. See this[^] article for more information. 3. Consider moving your data access logic into a separate data access layer (DAL).
Deja View - the feeling that you've seen this post before.
-
you are getting that error bcos the length that u are specifying is greater than the no of the characters in the string. make sure that you are specifying the right parameters in order to extract the name for the pic...try this strQuery = "INSERT INTO criminal(cr_name,no_times,cr_desc,cr_pic,fing_print,pic_name)VALUES('" + textBox1.Text + "','" + textBox5.Text + "','" + textBox4.Text + "','" + textBox6.Text + "','" + textBox7.Text + "','" + textBox6.Text.Substring(11,textBox6.Text.Length-11) +"')"; i am assuming that the cr_pic name starts from the 11th position and u want it till the end. if you are still having a problem the post the format in which you are specifying the cr_pic
thank you this is really working, can u suggest the solution for one more problem string strQuery = ""; openFileDialog1.ShowDialog(); string s = openFileDialog1.FileName; textBox6.Text = s; string st = "Pict" + Guid.NewGuid().ToString() + ".jpg"; File.Copy(openFileDialog1.FileName, Path.Combine(@"c:\inetpub\wwwroot\15 website\images", st)); strQuery = "INSERT INTO criminal(pic_name) VALUES(System.IO.Path.GetFileName(openFileDialog1.FileName))"; PROBLEM: error comes on this the SQL Query , am i inserting rightly?