Click here to Skip to main content
15,887,477 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: very very Urgent one plz....... Pin
peter rankel12-Jul-06 2:13
peter rankel12-Jul-06 2:13 
GeneralRe: very very Urgent one plz....... Pin
Hammad Arshad12-Jul-06 21:20
Hammad Arshad12-Jul-06 21:20 
QuestionObject reference not set to an instance of an object. error Pin
Jai Prakash Singh12-Jul-06 1:02
Jai Prakash Singh12-Jul-06 1:02 
AnswerRe: Object reference not set to an instance of an object. error Pin
J4amieC12-Jul-06 1:23
J4amieC12-Jul-06 1:23 
QuestionHow to make Click event on Image control Pin
Edd4812-Jul-06 0:38
Edd4812-Jul-06 0:38 
AnswerRe: How to make Click event on Image control Pin
minhpc_bk12-Jul-06 14:57
minhpc_bk12-Jul-06 14:57 
GeneralRe: How to make Click event on Image control Pin
Edd4812-Jul-06 20:27
Edd4812-Jul-06 20:27 
QuestionINSERT INTO and SELECT statements... pls help urgently Pin
For_IT12-Jul-06 0:20
For_IT12-Jul-06 0: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 1:24
postmaster@programmingknowledge.com12-Jul-06 1:24 
AnswerRe: INSERT INTO and SELECT statements... pls help urgently Pin
minhpc_bk12-Jul-06 15:00
minhpc_bk12-Jul-06 15:00 
Questionhow to get value on Server Pin
nabeelkhan12-Jul-06 0:00
nabeelkhan12-Jul-06 0:00 
AnswerRe: how to get value on Server Pin
minhpc_bk12-Jul-06 0:21
minhpc_bk12-Jul-06 0:21 
GeneralRe: how to get value on Server Pin
nabeelkhan12-Jul-06 0:36
nabeelkhan12-Jul-06 0:36 
GeneralRe: how to get value on Server Pin
minhpc_bk12-Jul-06 4:16
minhpc_bk12-Jul-06 4:16 
QuestionHelp me!! Pin
cloudking1196611-Jul-06 23:07
cloudking1196611-Jul-06 23:07 
AnswerRe: Help me!! Pin
Guffa11-Jul-06 23:23
Guffa11-Jul-06 23:23 
GeneralRe: Help me!! Pin
cloudking1196612-Jul-06 0:36
cloudking1196612-Jul-06 0:36 
QuestionFormView mode (pls urgent help) [modified] Pin
srinandan..11-Jul-06 22:38
srinandan..11-Jul-06 22:38 
AnswerRe: FormView mode (pls urgent help) Pin
minhpc_bk12-Jul-06 0:12
minhpc_bk12-Jul-06 0:12 
QuestionHTML production Pin
Harvey Turtle11-Jul-06 22:31
Harvey Turtle11-Jul-06 22:31 
AnswerRe: HTML production Pin
minhpc_bk12-Jul-06 0:16
minhpc_bk12-Jul-06 0:16 
GeneralRe: HTML production Pin
Harvey Turtle12-Jul-06 0:46
Harvey Turtle12-Jul-06 0:46 
GeneralRe: HTML production Pin
minhpc_bk12-Jul-06 4:13
minhpc_bk12-Jul-06 4:13 
QuestionJavascript Merge Excel Cells Pin
Old Gun11-Jul-06 22:24
Old Gun11-Jul-06 22:24 
AnswerRe: Javascript Merge Excel Cells Pin
Old Gun12-Jul-06 21:46
Old Gun12-Jul-06 21: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.