take a look at: http://msdn.microsoft.com/en-us/magazine/cc163566.aspx Intelligence is almost useless for those who have nothing else! Email: caiokf@gmail.com

brettokumar wrote: 'invalid sql statement ' Error message is clear, isn't it? brettokumar wrote: string Qry = "Exec user_insert_proc('BW100000906','127.0.0.1','acibre','BrettoKumar','09006833242hijklm', 'bretto_be@yahoo.com',2,'abraham','Bretto','Abraham','1','27-Apr-1971','','22-Sep-2008 12:37:55 AM','22-Sep-2008 12:37:55 AM','ttk','alwarpet','620001','chennai','tamilnadu','BW','04411-123456789','0441-123456789','91-98947455711','','','8237536982482857233565195638026419924352543044988390181159607082248527607624911769985440292861738021','22-Sep-2008 12:37:55')"; What a disaster. Read about SQL Injection and change this to parametrized queries. All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia How to use google | Ask smart questions

Besides optimizing your query (perhaps by indexing the column) you can increase the query timeout in your code. Bob Ashfield Consultants Ltd

You can't assign anything to the FileName property of the upload control. That would be a serious security hole, as you could access the contents of files on the client system by automatically uploading them. The user has to select the file to upload. Despite everything, the person most likely to be fooling you next is yourself.

objDDL.fillDDL(ddlState, "codstate", "", False, Constants._DDL_Default_Select) objDDL.fillDDL(ddlDistrict, "CODDistrict", "", False, Constants._DDL_Default_Select) objDDL.fillDDL(ddlCity, "CODcity", "", False, Constants._DDL_Default_Select) using ddlstate,district,city tables

http://displaytag.sourceforge.net/11/tut_externalSortAndPage.html[^] http://forums.digitalpoint.com/showthread.php?t=726963[^] this links may help u ... :-O Pradeep Reddy

Hi Bretto, Here is a suggestion. Why not you go for a Ajax Calender control since you want to assign the value to a server control ie: textbox. Here is the sample code...just try it and see it may be easy for you. If you already added the AjaxControlToolKit.dll in to your tool bar you may see a CalenderExtender. First drag a script manager to your page and then drag a CalenderExtender to your page. Now here the the code... Now once you click on the textbox a calender control will appear and its date will be set to the textbox control Another reason to go for Ajax Calender Control is because of its functionality, year wise, month wise traversal and lot more..just try and see.. Hope it will help... Thx, Gayani

brettokumar wrote: please help me This could help you[^] led mike

i got it why you got this error!!! You cannot use a Like wild card with Integers .. is ur newsid is int? Cheers, ZAK

brettokumar wrote: but it will display error like this: The message could not be sent to the SMTP server. The transport error code was 0x800ccc15. The server response was not available First Configre is SMTP Server. You code is fine. You need to Configure your SMTP server that allow you sebnd mail using SMTP. cheers, Abhijit

Page.Request.UserHostAddress.ToString(); is this you was looking for ?

the problem is in the second update if i'm reading this correctly, @sp_CRID is a comma delimited list if integers which must be treated as a string. andi'm guessing the sno column is an int. Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

complie error with regards, bretto

yep thats what i read...they are replacing it with something, but i dont think it works quite the same. Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

You can go to the watch tab and type in expressions to see their values when you're at a breakpoint. 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 guess your code is wrong. Create a separate JS function and give it there. function doMouseOver(obj){ obj.className='opaque'; obj.bgColor='<%=Session["BackColor"]% > } onmouseover=doMouseOver(this) Hope it helps All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia How to use google | Ask smart questions

hi christiam graus thanks for ur kind help this link is very use full for me with regards, bretto