|
it is giving no error but the data is not getting saved and the Profile.UserId is changing from -1 which is default to 0 please help me getting this solved as i m new to asp.net and the main Relational Key of all my database table is UserId and untill this is not solved i cant go any further...i have excecuted my stored procedure manualy and it is returning value of UserId but some how i made mistake in code os save function..
appu
|
|
|
|
|
It's been a while since I did any vb stuff but I suspect the problem is that you the return value needs to be an int and I believe you the add has a type argument as well that you need to specify.
Dim returnValue As DbParameter (make int)
returnValue = myCommand.CreateParameter
returnValue.Direction = ParameterDirection.ReturnValue
myCommand.Parameters.Add(returnValue) (add type to add, type would be SqlDbType.Int)
here is an example in c# and this works.
MyError = "adding ReturnValue parameter";
SqlC.Parameters.Add("@RETURN_VALUE", SqlDbType.Int);
SqlC.Parameters["@RETURN_VALUE"].Direction = ParameterDirection.ReturnValue;
MyError = "building exec string for stored procedure";
string cmd = "DeleteDateRange";
SqlC.CommandType = CommandType.StoredProcedure;
SqlC.CommandText = cmd;
MyError = "Executing query, calling DeleteDateRange";
ReturnValue = SqlC.ExecuteNonQuery();
ReturnValue = Convert.ToInt32(SqlC.Parameters["@RETURN_VALUE"].Value);
2 cents, good luck.
MrPlankton
|
|
|
|
|
Your question has nothing to do with ASP.NET.
You should post it in either the VB.NET or SQL forum.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
If i m not wrong then this is ASP.NET Section.
Better u go through VB.Net Section, U will get Better response 
Believe Yourself™ :->™
|
|
|
|
|
How can I connect Database and Tables at runtime in Crystal Report?
|
|
|
|
|
techpub wrote: How can I connect Database and Tables at runtime in Crystal Report?
This is the ASP.NET forum. Your question has nothing to do with ASP.NET.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
I want to connect crystal Report with databases using ASP.NEt code.
That's why , i thought, this is the right forum.
Sorry for that.
|
|
|
|
|
techpub wrote: I want to connect crystal Report with databases using ASP.NEt code.
That's why , i thought, this is the right forum.
It isn't. Your question relates specifically to Crystal Reports. The fact that you are using ASP.NET is irrelevent.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
U can try For The ADO.NET Section. 
There u will get many responses .
Believe Yourself™ :->™
|
|
|
|
|
|
The main reason I can see for this is if you had permissions issue on the folder itself.
Vista sucks.
Christian Graus - Microsoft MVP - C++
"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 )
|
|
|
|
|
That's not going to affect directory permissions which in Vista are OFF by default. So fiddle with the Style's directory permissions and you should be gtg.
Todd Smith
|
|
|
|
|
Just Check out for Administrative rights and folder permissions that may be solve the problem.
Sluggish Vista 
Believe Yourself™ :->™
|
|
|
|
|
Is there any free framework to develop asp.net web directory or asp.net virtual shops? I mean a web directory that you only need to configure the layout and to add sites. Something like for forums. Thanks a lot.
http://www.softrun.ro
|
|
|
|
|
Hey all,
I am fairly new to the asp.net world and so far i am missing C# fully capabilities and control.
But since i want to learn how to create OS Independent solutions i want to try it out.
Could anyone help me with this:
1-) How can i display a message box? In java script i know i can use alert, prompt and confirm. But i am using C# scripts... and some asp books i have doesn't have it.
2-) I have a treeView control on the website but i want to collapse all elements but the selected node, i am doing like this:
protected void TreeVIEW_SelectedNodeChanged(object sender, EventArgs e)
{
TreeView Current = (TreeView)sender;
TreeNodeCollection childs = Current.SelectedNode.ChildNodes;
Current.SelectedNode.CollapseAll();
foreach (TreeNode child in childs)
if (child.Parent == Current.SelectedNode)
child.Parent.Expand();
else
child.Parent.Collapse();
}
what am i doing wrong???
thx all
Luis E Tineo S
modified on Thursday, February 07, 2008 1:59:38 PM
|
|
|
|
|
kingletas wrote: But i am using C# scripts
Well, that just doesn't work. Javascript, not C#, is what runs on the client. So to show the client a message box, you need to use javascript.
Christian Graus - Microsoft MVP - C++
"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 )
|
|
|
|
|
Dear all,
hi , i was trying to send an xml document over xmlhttp msxml2 object , the problem is i couldn't instantiate the same object using ASP.net
any ideas ????
modified on Thursday, February 07, 2008 10:35:07 AM
|
|
|
|
|
Can you please post the error you are getting at your end?
Best Regards,
Sam Xavier
www.componentone.com
|
|
|
|
|
Can Someone help here, I am getting the following error on a Windows forms User Control running on an asp.net webpage,
"request for permission of type system.net.mail.smtppermission failed",
the User Control is a complied DLL and I have included it on the ASp.net page, the user control is supposed to send an email when I click send it works fine in a vb form and does run the code on the webpage but wont send the email. how do i set the SMtp Permission in my code using the SmtpPermission Class in System.Net.Mail.
below is the code for sending the mail in the dll,
Function SendMail(ByVal MailServer As String, ByVal mailUser As String, ByVal MailPassword As String, ByVal EmailAddress As String, ByVal Message As String, ByVal FormAddress As String, ByVal Subject As String, ByVal Port As String, ByVal Auth As Boolean) As Boolean
Try
Dim message1 As New MailMessage(EmailAddress, FormAddress, Subject, HttpUtility.HtmlDecode(Message).ToString)
message1.IsBodyHtml = True
Dim emailClient As New SmtpClient(MailServer)
emailClient.UseDefaultCredentials = False
' used to authenticate the account used for sending mail
If Auth = True Then
Dim basicAuthenticationInfo As New System.Net.NetworkCredential(mailUser, MailPassword)
emailClient.Credentials = basicAuthenticationInfo
End If
emailClient.Port = CInt(Port)
emailClient.Send(message1)
Return True
Catch ex As Exception
MsgBox("SendMail Failed: " & ex.Message)
Return False
End Try
End Function
I have included the dll like so on the aspx webpage
<OBJECT id="SendMail2" height="193" width="527" classid="http:OCTBulkMailer.dll#OCTBulkMailer.eMailer" VIEWASTEXT >
<PARAM NAME="fromAddressVal" VALUE="email">
<PARAM NAME="emailEmailSubjectVal" VALUE="Testmail from OCT Mailer">
<PARAM NAME="emailMessageVal" VALUE='<%= Message %>' >
<PARAM NAME="SmtpAuthVal" VALUE="True">
<PARAM NAME="SmtpPassVal" VALUE="pass">
<PARAM NAME="SmtpUserVal" VALUE="email">
<PARAM NAME="Title" VALUE="Bulk Mailer">
<PARAM NAME="EmailAddressesVal" VALUE='<%= addresses %>'>
<PARAM NAME="SmtpServerVal" VALUE="server">
<PARAM NAME="SmtpPortVal" VALUE="25">
<PARAM NAME="Instructions" VALUE="Click Start to Start sending your mails">
</OBJECT>
|
|
|
|
|
iam creating a dll when iam writing a function with private and building the project .the dll is ofrming nice but when iam copying the dll and making an instance the method of that dll is not comming ...but when iam using public function it is comming ....what is the reason..even iam creating the object for the same class only
|
|
|
|
|
jagadeeshkumar2106 wrote: iam creating a dll when iam writing a function with private and building the project .the dll is ofrming nice but when iam copying the dll and making an instance the method of that dll is not comming
Private method are accessible in same class only
Even if you create a object of that class and try to access the method it will give error
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
|
|
|
|
|
hi sandeep will u explain in clear
|
|
|
|
|
|
It sounds to me like you should not be writing dlls, or any code, you should be working through a beginners book that explains these sort of concepts clearly.
Christian Graus - Microsoft MVP - C++
"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 )
|
|
|
|
|
Hi,
Sorry for such a newb type question, but im really in need of your help....
I need to display images as a gallery. I can retrieve and display images no problem, however i need to show 10 images at a time in 2 rows of 5, with paging.
Im using .Net 2.0 C#. Can anyone point me in the right direction eg which data control to use or even a good tutorial on how to do it?
Many Thanks guys!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
