|
hi
when i run this code this generate error
why?
objCommand.Parameters.Add("@nopersoneli", SqlDbType.int).Value =int.parse(txtNoPersoneli.text);
thanks a lot
|
|
|
|
|
1. What's the error you're getting
2. Should that be @"nopersoneli" ?
3. Should that be txtNoPersoneli.Text ?
4. Does txtNoPersoneli.Text definately contain a valid integer?
4b. Consider getting the integer value before this line by using int.TryParse method.
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)Expect everything to be hard and then enjoy the things that come easy. (code-frog)
|
|
|
|
|
DaveyM69 wrote: 2. Should that be @"nopersoneli" ?
it seems hes trying to execute a SQL Stored Procedure using SqlCommand... see my reply
Harvey Saayman - South Africa
Junior Developer
.Net, C#, SQL
you.suck = (you.Passion != Programming & you.Occupation == jobTitles.Programmer)
1000100 1101111 1100101 1110011 100000 1110100 1101000 1101001 1110011 100000 1101101 1100101 1100001 1101110 100000 1101001 1101101 100000 1100001 100000 1100111 1100101 1100101 1101011 111111
|
|
|
|
|
Yeah - just saw the 'crapiness' of the question and jumped on the obvious without too much thought. I never even looked at the beginning of the statement - the possibilities I spotted from briefly scanning just one line of code made me close my eyes!
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)Expect everything to be hard and then enjoy the things that come easy. (code-frog)
|
|
|
|
|
Firstly "problem in code" is as usefull as BLAH for a subject line!
Secondly give us more detail, what exception is thrown?
by the looks of things you need to do this...
objCommand.Parameters.AddWithValue("@nopersoneli", Int32.parse(txtNoPersoneli.Text));
or
objCommand.Parameters.Add("@nopersoneli", SqlDbType.Int);
objCommand.Parameters["@nopersoneli"].Value = Int32.parse(txtNoPersoneli.Text);
Harvey Saayman - South Africa
Junior Developer
.Net, C#, SQL
you.suck = (you.Passion != Programming & you.Occupation == jobTitles.Programmer)
1000100 1101111 1100101 1110011 100000 1110100 1101000 1101001 1110011 100000 1101101 1100101 1100001 1101110 100000 1101001 1101101 100000 1100001 100000 1100111 1100101 1100101 1101011 111111
|
|
|
|
|
Harvey Saayman wrote: by the looks of things you need to do this...
His code 'structure' is actually correctly and will do the same as both your examples. Note: the Add method returns a IDBParameter.
xacc.ide - now with TabsToSpaces support IronScheme - 1.0 alpha 4a out now (29 May 2008) ((lambda (x) `((lambda (x) ,x) ',x)) '`((lambda (x) ,x) ',x))
|
|
|
|
|
leppie wrote: is actually correctly
[joke]
Don't let Dalek Dave see that, you'll definitively get a English lesson
[/joke]
leppie wrote: the Add method returns a IDBParameter.
I didn't even notice that! The examples i gave is how i use the SqlCommand(or used, im a Linq fan boy now!), the latter of the two is used for DateTime parameters to ensure that the data gets to the db in the correct format.
Harvey Saayman - South Africa
Junior Developer
.Net, C#, SQL
you.suck = (you.Passion != Programming & you.Occupation == jobTitles.Programmer)
1000100 1101111 1100101 1110011 100000 1110100 1101000 1101001 1110011 100000 1101101 1100101 1100001 1101110 100000 1101001 1101101 100000 1100001 100000 1100111 1100101 1100101 1101011 111111
|
|
|
|
|
objCommand.Parameters.Add("@nopersoneli", SqlDbType.int).Value =
convert.Toint32(txtNoPersoneli.text);
if that doesn´t work is because "txtNoPersoneli.text" cannot be converted to a int value, or "@nopersoneli" is not int.
listen, there is not a reason for that not work
nelsonpaixao@yahoo.com.br
trying to help & get help
|
|
|
|
|
<a href="newdetails1.aspx?pid=<%#Eval("companyname") %>">
<asp:Label ID="Label4" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"companyname") %>'>"</asp:Label></a>
The above code in code behind page. (if we send krish & co.)
pi = Request.QueryString["pid"].ToString();
The above code in aspx page. ( its reciving in pi(krish) )
Can u pls solve this issue...
krishna
|
|
|
|
|
You probably need to escape the & sign.
replace it with "&" (without the quotes).
[Edit: oops. the escape string is "&" without the quotes]
Simon
modified on Thursday, September 25, 2008 6:32 AM
|
|
|
|
|
Iam dynamically retriving the companyname from database to display in the page where i binded while clicking that companyname to pass complete companyname.
Can you pls give me some examples, it will be gr8 full to me, pls
krishna
|
|
|
|
|
I don't use asp, so I could be wrong. But in html, & signs must be escaped.
You need to create a function to process the company name that you read from the database and replace any illegal html characters like < or > or & with the correct escape string.
(I noticed in my last post the escape string was escaped the string you need is "&" without the quotes.)
(There is probably already a function to do this. You might be better asking this question in the asp.net forum)
Simon
|
|
|
|
|
ASP.Net questions belong in the ASP.Net forum!
Harvey Saayman - South Africa
Junior Developer
.Net, C#, SQL
you.suck = (you.Passion != Programming & you.Occupation == jobTitles.Programmer)
1000100 1101111 1100101 1110011 100000 1110100 1101000 1101001 1110011 100000 1101101 1100101 1100001 1101110 100000 1101001 1101101 100000 1100001 100000 1100111 1100101 1100101 1101011 111111
|
|
|
|
|
You have to url-encode the string that you put in an url:
<a href="newdetails1.aspx?pid=<%#Server.UrlEncode(Eval("companyname"))%>">
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
Use HttpUtility.URLEncode()
This will solve your problem.
Thanks & Regards
Pete
SIEMENS Information Systems Ltd
|
|
|
|
|
Hi,
.net 2 vs2005
I have a winform app with a close button. The code behind the close is this.Close(); this.Dispose();
The problem is that after deploying my app, in the task manager I can still see my exe under processes after pressing the close button. Do I need to shut down differently?
Thanks,
Chas
|
|
|
|
|
You don't need to call this.dispose on the apps main form. If you started it up correctly (by using Application.Run(new Form1()); ) then the calling code will do the dispose for you. Do this first, and check that it's not causing your problem.
Apps remaining running is usually because you haven't stopped a background thread somewhere. Are you using any background workers, or threads, or anything like that? Check they are all stopped and disposed of before the form is closed.
Simon
|
|
|
|
|
try to use
Application.Exit(); hope it helps
dhaim
programming is a hobby that make some money as side effect
|
|
|
|
|
Hi all,
this msg is regarding my previous post.
(how to hide OS and run only SINGLE application)
i ve created a WIndows Service and it starts automatically with computer.
But how can I run my application from that Service.
My Windows service resides in the same project.
So where i m stuck is : How can i Run my application form the WIndows service?
I wrote OnStart event of Windows Service and wrote System.Diagnostics.Process in it,
but it did not work?
ANy solution.....
Regards,
SIFAR.
|
|
|
|
|
Are you sure OnStart event fired sucessfully in your windows service..
Venky
|
|
|
|
|
How do you know it didn't work?
Mark
Mark Salsbery
Microsoft MVP - Visual C++
|
|
|
|
|
ServerManager mgr = new ServerManager();
mgr.ApplicationPools["test"].Enable32BitAppOnWin64 = true;
mgr.CommitChanges();
Above code should set property Enable32BitAppOnWin64 to true for application pool having name test, but it doesn't do that, can anyone please tell what am I doing wrong.
Please note that ServerManager class is present in Microsoft.Web.Administration namespace.
Thanks,
Mushq
|
|
|
|
|
Do you get any exceptions? I use the following code and it works fine for me (cutdown a bit):
using (ServerManager mgr = new ServerManager())
{
ApplicationPool appPool = mgr.ApplicationPools[appPoolName];
if (appPool == null)
throw new ApplicationException(string.Format("The pool {0} does not exist", appPoolName));
appPool.Enable32BitAppOnWin64 = true;
mgr.CommitChanges();
}
|
|
|
|
|
Hi Pete,
Thanks for the response and sorry for the late reply.
Pete O'Hanlon wrote: Do you get any exceptions?
No, I don't get any exception.
I have observed when i try to set property through code it shows me that the property has been successfully changed to true even next time I try to get that property programmatically it shows me that property is true, but when I open that in IIS it shows me that property to be false.
Please check the screen shot for that.
http://img87.imageshack.us/my.php?image=iiswin32bitcheckmf6.jpg[^]
Kind Regards,
Mushq
|
|
|
|
|
Hi Pete O'Hanlon,
I was checking that property incorrectly, you are right that your mentioned code is working fine.
Thanks a lot.
Kind Regards,
Mushq
|
|
|
|