|
i m currently using asp.net with c# (.net 2005, 2.0 framework)
cmd = new SqlCommand("UPDATE tbl1 set name='" + textbox1.Text + "',lock_datetime='" where id='" + txtid.Text + "'",conn);
MyLib.cmd.ExecuteNonQuery();
after executing this query i need the value which is updated in the table (i.e, the name which is saved from textbox1 to database)
how to retrive it? - KARAN
|
|
|
|
|
um, isn't it testbox1.Text ?
Also, this code is a disaster - you need to read on SQL Injection Attacks, aka all the ways this code allows me to attack, exploit and destroy your database.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Try to use stored procedures rather then inline code.
Like Graus said it is the value in textbox1.text but you can also get it from the database using a simple sql select statement
|
|
|
|
|
thanks my friends..
after updating we can get the value by applying select query.
what i m exactly expecting is after the update statement has been executed successfully, the updated value should return and i like to store it in a string variable. is there any function or process like this?
help me !
thanks in advance....
|
|
|
|
|
Well, apart from the obvious ( it's ALREADY in a string variable ), if you want to do this to confirm it was stored, you can do this in a stored proc.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
i dont know to write store procedure....... anyway... thanks....
|
|
|
|
|
Application_Start in global.asax is not firing.can anybody help
|
|
|
|
|
Where are you storing the session in state_server ?. Events in global.asax will be fired only if they are stored in InProc..Check your web.config to if it is InProc.
Thank you
Thanks
Laddie
Kindly rate if the answer was helpful
|
|
|
|
|
I want to build a crawler that crawls over nyddc.com and fetch all the excel files on that site, but i want to know how my crawler login and goes to intended page, means if i have username and password how can i use both to login in nyddc and fetch excel files from a page.
|
|
|
|
|
Well, you can't do it in ASP.NET, you have to do it in C#, in a windows app.
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
To be completely correct, you CAN do it in ASP.NET, but I don't see any reason why would you 
|
|
|
|
|
So how can i do that please help me.
|
|
|
|
|
My friend, answer to your question is too complex to be explained in one post here. It would be better if you start with something and ask for particular problem you are facing.
The best way I guess is to start with the WebRequest class, which helps you to work with the content of the page:
WebRequest myRequest = WebRequest.Create("http://www.ThePageIWantToWorkWith.com");
more here:
http://msdn.microsoft.com/en-us/library/system.net.webrequest(VS.71).aspx[^]
|
|
|
|
|
How can i create a aspx page dynamically. Suppose i have a page called create.aspx in which there is a textbox , now what i want is that if i give new in textbox that a new aspx page named new.aspx page should be created
|
|
|
|
|
I dont think this is the best idea, maybe it would be better to have a few blank pages and then put code into that, given the user the ability to add new pages is not very secure and gives you less control over your website.
Plus you then have to link the newly created pages up with the exisiting
|
|
|
|
|
But I have seen in many sites they create pages dynamically, for eg if i post a new property in domegos.com they create page of the name which i have specified as property name.
|
|
|
|
|
|
|
we have an ISP , and we want that when every user open a url ( every url )all packet are sended to this server then , at first is opened a popup then open that url .
what should i do ? wuild you mind help me?
|
|
|
|
|
Not really an asp.net question is it...
|
|
|
|
|
i want to use the MSExcel in front end pls give any idea....
how to get the data from MSExcel
|
|
|
|
|
Dont put question as your subject, we know you are asking a question thats why you are posting on the forum.
Can you be a bit clearer
what does this mean:
nithydurai wrote: I want to use the MSExcel in front end pls give any idea....
nithydurai wrote: how to get the data from MSExcel
check this out: http://support.microsoft.com/kb/306572
|
|
|
|
|
Hi All,
I need the Asp.net 1.1 support Rating Control. Any one know about this please send the source code or URL.my id is linguage_23@yahoo.com,ling@sdi.la
(I Am using "Castle Rater Control" Rating control, while am using this control,inside the datagrid its getting an error.Its say "image null exception" .But its working in outer of the datagrid.
Any suggestion is welcome.
Thanks in advance.
By,
S.Lingeswararaj
|
|
|
|
|
lingeswararaj.s wrote: please send the source code or URL.my id
We cant just send you a block of code and let you take the credit! 
Try giving us some code you have written so far and we can see what is wrong with it and provide full error message
|
|
|
|
|
Hi,
Here is the URL for source code am using:
http://blogs.crsw.com/mark/archive/2005/01/30/719.aspx
I have using this code, when i am using this code inside the datalist its getting an error. Image null..on object
let me know .
thanks and regards,
S.Lingeswararaj
linguage_23@yahoo.com
ling@sdi.la
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
