Click here to Skip to main content
15,847,963 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: very very Urgent one plz....... Pin
peter rankel12-Jul-06 3:13
peter rankel12-Jul-06 3:13 
GeneralRe: very very Urgent one plz....... Pin
Hammad Arshad12-Jul-06 22:20
Hammad Arshad12-Jul-06 22:20 
QuestionObject reference not set to an instance of an object. error Pin
Jai Prakash Singh12-Jul-06 2:02
Jai Prakash Singh12-Jul-06 2:02 
AnswerRe: Object reference not set to an instance of an object. error Pin
J4amieC12-Jul-06 2:23
J4amieC12-Jul-06 2:23 
QuestionHow to make Click event on Image control Pin
Edd4812-Jul-06 1:38
Edd4812-Jul-06 1:38 
AnswerRe: How to make Click event on Image control Pin
minhpc_bk12-Jul-06 15:57
minhpc_bk12-Jul-06 15:57 
GeneralRe: How to make Click event on Image control Pin
Edd4812-Jul-06 21:27
Edd4812-Jul-06 21:27 
QuestionINSERT INTO and SELECT statements... pls help urgently Pin
For_IT12-Jul-06 1:20
For_IT12-Jul-06 1:20 
Hi
I am developing a UserControl, I save this user control code to the database, which will be loaded dynamically to the Page.

In my user control code consist of following lines:

<asp:SqlDataSource ID="GetDataFromDatabase" runat="server" ConnectionString="<%$ ConnectionStrings:sConnectionString %>"
SelectCommand="SELECT field_defaultvalue FROM cp_productfields WHERE field_product_id='ProductID' AND field_type='DropDownList' AND field_Control_ID='ddVCAuflag'"
ProviderName="<%$ ConnectionStrings:sConnectionString.ProviderName %>"></asp:SqlDataSource>

At this moment, I am manually puting this data to data
base using "INSERT INTO" statement.
But I get following error:

Incorrect syntax near 'ProductID'.

This is because single quotation mark around ProductID (field_product_id='ProductID').
If I change this single quotation to double quotation (e.g. field_id="ProductID") then this works okay.
But in that scenario, SELECT statement fails while execution.

Can anyone please let me know how can I achieve both successfully?

Thanks in advance.


AnswerRe: INSERT INTO and SELECT statements... pls help urgently Pin
postmaster@programmingknowledge.com12-Jul-06 2:24
postmaster@programmingknowledge.com12-Jul-06 2:24 
AnswerRe: INSERT INTO and SELECT statements... pls help urgently Pin
minhpc_bk12-Jul-06 16:00
minhpc_bk12-Jul-06 16:00 
Questionhow to get value on Server Pin
nabeelkhan12-Jul-06 1:00
nabeelkhan12-Jul-06 1:00 
AnswerRe: how to get value on Server Pin
minhpc_bk12-Jul-06 1:21
minhpc_bk12-Jul-06 1:21 
GeneralRe: how to get value on Server Pin
nabeelkhan12-Jul-06 1:36
nabeelkhan12-Jul-06 1:36 
GeneralRe: how to get value on Server Pin
minhpc_bk12-Jul-06 5:16
minhpc_bk12-Jul-06 5:16 
QuestionHelp me!! Pin
cloudking1196612-Jul-06 0:07
cloudking1196612-Jul-06 0:07 
AnswerRe: Help me!! Pin
Guffa12-Jul-06 0:23
Guffa12-Jul-06 0:23 
GeneralRe: Help me!! Pin
cloudking1196612-Jul-06 1:36
cloudking1196612-Jul-06 1:36 
QuestionFormView mode (pls urgent help) [modified] Pin
srinandan..11-Jul-06 23:38
srinandan..11-Jul-06 23:38 
AnswerRe: FormView mode (pls urgent help) Pin
minhpc_bk12-Jul-06 1:12
minhpc_bk12-Jul-06 1:12 
QuestionHTML production Pin
Harvey Turtle11-Jul-06 23:31
Harvey Turtle11-Jul-06 23:31 
AnswerRe: HTML production Pin
minhpc_bk12-Jul-06 1:16
minhpc_bk12-Jul-06 1:16 
GeneralRe: HTML production Pin
Harvey Turtle12-Jul-06 1:46
Harvey Turtle12-Jul-06 1:46 
GeneralRe: HTML production Pin
minhpc_bk12-Jul-06 5:13
minhpc_bk12-Jul-06 5:13 
QuestionJavascript Merge Excel Cells Pin
Old Gun11-Jul-06 23:24
Old Gun11-Jul-06 23:24 
AnswerRe: Javascript Merge Excel Cells Pin
Old Gun12-Jul-06 22:46
Old Gun12-Jul-06 22:46 

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.