Click here to Skip to main content
15,905,913 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: Image button in Gridview Pin
Gayani Devapriya15-May-08 8:35
Gayani Devapriya15-May-08 8:35 
Questionurl encode with '+' Pin
g00fyman15-May-08 1:03
g00fyman15-May-08 1:03 
AnswerRe: url encode with '+' Pin
Sandeep Kumar15-May-08 3:33
Sandeep Kumar15-May-08 3:33 
GeneralRe: url encode with '+' [modified] Pin
g00fyman15-May-08 13:47
g00fyman15-May-08 13:47 
GeneralRe: url encode with '+' Pin
g00fyman15-May-08 14:06
g00fyman15-May-08 14:06 
QuestionHow find text box is focussed while i click the button Pin
Guvera15-May-08 0:51
Guvera15-May-08 0:51 
AnswerRe: How find text box is focussed while i click the button Pin
eyeseetee15-May-08 0:54
eyeseetee15-May-08 0:54 
Questionsaving a query into a database column? Pin
Karan_TN15-May-08 0:33
Karan_TN15-May-08 0:33 
currently i m using asp.net with c# (.net 2005, 2.0 framework) and sql server 2000.

i want to store a sql query into a field in database... how to do it?

execute the below statement, and how to store it?

INSERT INTO tbl_templates_rsamonitoring(Template_Name,query,insert_date) values('sample','select tbl_rsa.rsa_level4 as \"BU - Level 4\",tbl_rsa.rsa_level5 as \"BU - Level 5\",tbl_rsa.rsa_sbu as \"BU - Level 3\",tbl_rsa.rsa_category as \"BU - Level 1\",tbl_rsa.rsa_level8 as \"BU - Level 8\",REPLACE(CONVERT(VARCHAR,tbl_rsa.rsa_ctrlculture, 106), ' ', '-') as \"Control Culture\" from tbl_rsa where rsa_mode=1','5/15/2008 3:53:47 PM')

that is...

template_name = sample
query='select tbl_rsa.rsa_level4 as \"BU - Level 4\",tbl_rsa.rsa_level5 as \"BU - Level 5\",tbl_rsa.rsa_sbu as \"BU - Level 3\",tbl_rsa.rsa_category as \"BU - Level 1\",tbl_rsa.rsa_level8 as \"BU - Level 8\",REPLACE(CONVERT(VARCHAR,tbl_rsa.rsa_ctrlculture, 106), ' ', '-') as \"Control Culture\" from tbl_rsa where rsa_mode=1
insert_date='5/15/2008 3:53:47 PM

how to achieve it? - KARAN
AnswerRe: saving a query into a database column? Pin
Christian Graus15-May-08 0:43
protectorChristian Graus15-May-08 0:43 
GeneralRe: saving a query into a database column? Pin
Karan_TN15-May-08 0:56
Karan_TN15-May-08 0:56 
Questionneeded updated value?? Pin
Karan_TN14-May-08 23:16
Karan_TN14-May-08 23:16 
AnswerRe: needed updated value?? Pin
Christian Graus15-May-08 0:03
protectorChristian Graus15-May-08 0:03 
AnswerRe: needed updated value?? Pin
eyeseetee15-May-08 0:20
eyeseetee15-May-08 0:20 
GeneralRe: needed updated value?? Pin
Karan_TN15-May-08 0:28
Karan_TN15-May-08 0:28 
GeneralRe: needed updated value?? Pin
Christian Graus15-May-08 0:42
protectorChristian Graus15-May-08 0:42 
GeneralRe: needed updated value?? Pin
Karan_TN15-May-08 1:50
Karan_TN15-May-08 1:50 
QuestionApplication_Start not firing Pin
sebastian314-May-08 23:16
sebastian314-May-08 23:16 
AnswerRe: Application_Start not firing Pin
Laddie14-May-08 23:21
Laddie14-May-08 23:21 
Questionlogin into the another site Pin
Mogaambo14-May-08 22:30
Mogaambo14-May-08 22:30 
AnswerRe: login into the another site Pin
Christian Graus15-May-08 0:02
protectorChristian Graus15-May-08 0:02 
GeneralRe: login into the another site Pin
l0kke15-May-08 0:32
l0kke15-May-08 0:32 
GeneralRe: login into the another site Pin
Mogaambo15-May-08 4:09
Mogaambo15-May-08 4:09 
GeneralRe: login into the another site Pin
l0kke19-May-08 2:32
l0kke19-May-08 2:32 
Questioncreating aspx pages at runtime Pin
Mogaambo14-May-08 22:05
Mogaambo14-May-08 22:05 
AnswerRe: creating aspx pages at runtime Pin
eyeseetee14-May-08 22:17
eyeseetee14-May-08 22:17 

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.