C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Communities   Interview   Jobs   Projects   Offshore Development    
Silverlight Tutorials | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Revenue Sharing |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...

New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !




Query


Posted Date: 28 Aug 2008      Total Responses: 3

Posted By: Chandra Sheker.G       Member Level: Gold     Points: 1


I am passing the values like but i geeting the exceptions pls Correct me if i am wrong
cmd.Parameters.Add("EMPID", SqlDbType.VarChar, 10);
cmd.Parameters["EMPID"].Value = iif(empid="",DBNull.Value,empid);




Responses

Author: Kiran Kumar    28 Aug 2008Member Level: GoldRating:     Points: 3
I think you need to send the parameter starting with @

And is this the post that i have read already.. or something i don't know.

I think this is duplicated question.

Kiran Kumar T.



Author: Arthanari    28 Aug 2008Member Level: BronzeRating:     Points: 0
Can you tell me..what exception you get..


Author: Vivek Sharma    12 Sep 2008Member Level: GoldRating:     Points: 3
Hi,

cmd.Parameters.Add("EMPID", SqlDbType.VarChar, 10);

Use it in this way

cmd.parameters.add("@EMPID",SqlDbType.VarChar,10) = txtEmpid.text;

I hope it will work .

Regards
Vivek Sharma



Post Reply
You must Sign In to post a response.
Next : asp.net gridview
Previous : asp.net search
Return to Discussion Forum
Post New Message
Category: ASP.NET

Related Messages



dotNet Slackers   BizTalk Adaptors    Web Design

budget conference call

Contact Us    Privacy Policy    Terms Of Use