|
I had a problem with insert command,It is working perfecly for some times and giving syntax error for the some times.In which cases this will be possible,Any specific reasons,i have placed it in try catch block .I have 50 columns to insert into database and checked all the datatypes and punctuations correctly.
|
|
|
|
|
|
|
It sounds like you are not encoding your strings correctly. If a string value can contain characters that break the syntax, it has to be encoded.
What database are you using?
---
b { font-weight: normal; }
|
|
|
|
|
I am using sqlserver,and i have given each column in a seperate line,bcz of this problem.but still it is giveing like syntax error at line1.
why any solution,i ckecked all the syntax and datatypes.
How to encode in asp.net for character display or insertion.
I have more than 25 columns with nvarchar datatype
-- modified at 5:48 Friday 29th September, 2006
|
|
|
|
|
|
The error message is referring to the line in the SQL query, not in the ASP.NET code, as the syntax error is in the query, not in the ASP.NET code.
If you are creating the query by concatenating strings rather than using Parameter objects, you have to encode the string values that you put in the query.
For MS SQL Server you have to encode the apostrophe character, as that is used to surround the string values. An apostrophe inside a string is written as two apostrophes, so you have to replace any apostrophes in string values with two apostrophes:
... ,'" + aValue.Replace("'", "''") + "', ...
---
b { font-weight: normal; }
|
|
|
|
|
I don't understand your solution.
I have a similar problem with Multiview + UpdatePanel + Validator
explication :
This problem I’m having with validators on an update panel is not the one where there is an invalid postback, but it may be related. This problem is occuring when I have a validator on a view inside of a multiview inside of an update panel.
Here’s my setup.
1. ScriptManager with Partial Rendering enabled.
2. Update panel with Mode set to always.
3. Multiview inside of update panel.
4. 2 views inside of multiview.
5. View #1 has textbox and required field validator
6. View #2 just has a textbox.
7. Previous and Next buttons.
When page loads I enter a value in textbox on view #1, thus satisfying the validator. I click next to go to view #2. All is good. I click previous to return to view #1. Error occurs (javascript). VS breaks into the function ValidatorGetValue(id). Specifically, it breaks on the line reading “if (typeof(control.value) . . . .”. When I hover over the control variable it is reading “null”. The error reads: ‘null’ is null or not an object. The id being passed in is the ClientID of the textbox on view #1. But I’m guessing that view has not yet been rendered to the browser.
// Code Break
function ValidatorGetValue(id) {
var control;
control = document.getElementById(id);
if (typeof(control.value) == "string") {
return control.value;
}
return ValidatorGetValueRecursive(control);
}
The lower left corner of IE indicates a javascript error:
Line: 104
Char: 5
Error: 'null' is null or not an object
Code: 0
URL: <the page="" url="">I can put "CausesValidation = false" for my 2 button (Next and previous) and I would not have any problem, but I don't want to do it !
Is there an other solution ? or not ? i change their sequence but problem exist
|
|
|
|
|
If i don't want to use javascript to perform comfirmation message box function, so i want to display a pop up message box display yes/no for user. so, when i using messagebox.show , it not run.So , for displaying messagebox for client pc, how should i do? any idea ?
thanks.
p/s: for addition information, this button run as delegate event handler, actually i also not sure what is "delegate event handler". I only know that code for this button is not coding inside the btn_click events, is write inside another function, so i want adding the comfirmation message box inside that function instead of btn_click event.
-- modified at 4:15 Friday 29th September, 2006
Best regards,
Chee ken
|
|
|
|
|
try to use
System.Windows.Forms.MessageBox.Show("Hello");
|
|
|
|
|
Thanks for your reply, but this one can't show the messagebox in client pc ,because this is server site.
Best regards,
Chee ken
|
|
|
|
|
Man if you want to do it in server side then I think you have to use javascript.
Best Regards,
Apurva Kaushal
|
|
|
|
|
oh, i just looking for another solution before i really use the javascript at final. thanks for reply. 
Best regards,
Chee ken
|
|
|
|
|
There are various server side MessageBox solutions, write messagebox onto codeproject search bar, you will find three or four solutions
keep Learning and you never will be out of date...
|
|
|
|
|
How do I set GPO environment through UI.
Please click on this link http://www.microsoft.com/technet/prodtechnol/windows2000serv/howto/grpolwt.mspx#E64AG
I want all this setting through code.
Can any one help.....
Regards,
Farid
|
|
|
|
|
I want to implement Paging on Master Detail Layout but i dont know how it will work because i can only set one pageddatasource at a time for either master or child record... please help me
R A M
|
|
|
|
|
Hi,
We are using Windows 2003 server on our server with IIS 6.0, my doubt is in that server we already have web sites created using .Net version 1.1, now recently we are going to upload an site with .Net version 2.0, is there any thing to be changed in the server regarding version??? else it will work well with out changin
Know is Drop, Unknown is Ocean
|
|
|
|
|
In the IIS snap-in, open the Properties window and go to the ASP.NET tab and check the version in there. For more information, see IIS documentation[^].
|
|
|
|
|
hi friends
I am using third party control r.a.d.grid control . On a simple ascx user control i have registered it.Added dll in reference. and simply binded it with datasource as datatable coming frm database as follows but it didn't get displayed on the page. no error is coming while binding . still not displayed only. I have written it outside !Ispostback() condition still not working
in page load event following code is written :
DataSet ds_longtermRentals=new DataSet();
SHG_DAL.Longterm_rentals obj_longtermrentals=new Longterm_rentals();
ds_longtermRentals=obj_longtermrentals.LoadFirstLontermRentals(int.Parse(Session["LanguageID"].ToString()));
if(ds_longtermRentals.Tables[1].Rows.Count>0)
{
DataTable dt= new DataTable();
dt=ds_longtermRentals.Tables[1];
if(dt.Rows.Count>0)
{
RadGrid1.DataSource = dt;
RadGrid1.DataBind();
}
}
plz help. its urgent.
regards,max
|
|
|
|
|
|
Hi
i want to Upload the Zip File and after the Upload it extracts itself.
Can any one help me..how can i do this
Thanks in Advance
Aavesh
|
|
|
|
|
Hi there,
I guess that you are able to use a zip library such as SharpZipLib or GZipStream class to programmatically unzip the uploaded file.
|
|
|
|
|
Hi Tech gurrs
i want to know that how can i controll concurrency in my asp .net web site. suppose at a point of time 100s of users are connected to my site and they are updating the database so how can i handle this problem we have to handle asp .net or handle in SQL server please suggest
Thanks in advance
Saurabh Gupta
Saurabh Gupta
Software Engineer
|
|
|
|
|
|
Thanks
for 4 ur help........
Saurabh Gupta
Software Engineer
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
