|
Hi All,
I have a problem with "ExecuteNonQuery". When I insert or update my database record then SqlCommands.ExecuteNonQuery always return -1 but same thing I use another sql server its working fine.
I am sure that the actual problem is in my MS-SQL Server.
what should I do? Please me out.........
Thanks
Raj
|
|
|
|
|
For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the command. When a trigger exists on a table being inserted or updated, the return value includes the number of rows affected by both the insert or update operation and the number of rows affected by the trigger or triggers. For all other types of statements, the return value is -1. If a rollback occurs, the return value is also -1.
Anyways if you are able post here your piece of code and Sql statement then would be helpful to assist you.
|
|
|
|
|
hi,
No, you could not understand what I want to say. My previous all projects were working fine all ExecuteNonQuery working well but now I don't know all are ExecuteNonQuery return -1. When I used different used another SQl Server installed in other PC. then is works fine.
|
|
|
|
|
Did you read the quote from my Post ?
|
|
|
|
|
Show your code to see where could be problem.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Quote From MSDN NOCOUNT affects the return value
it says "For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the command. For all other types of statements, the return value is -1. If a rollback occurs, the return value is also -1."
There is another case that causes it to return -1: if NOCOUNT is set to ON. This usually happens because the query includes the line "SET NOCOUNT ON", but it can also be set in the "Connection Defaults" screen in the SQL Server management tool.
Please go through the statement. Hope this will help you.
|
|
|
|
|
Hi,
I have to print only the cheque numbers on the cheque pad which is a continuous roll of paper.I am printing it using javascript.Only first four cheques includes in the first page. when second page comes,certain height gap comes.After every page,there is some gap in the page break.How can i overcome this problem?
regards
Bill
|
|
|
|
|
You can't. All js can do, is print the current page. You'd have to load all your cheques onto one page and print that page.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server" DataObjectTypeName="G1_OnlineStoreObjects.Book"
DeleteMethod="Delete" SelectMethod="LoadBySeries" TypeName="G1_OnlineStoreDAO.BookDAO"
UpdateMethod="Update">
< SelectParameters >
<asp:QueryStringParameter Name="seriesID" Type="Int32" QueryStringField="SeriesID" />
< / SelectParameters >
< / asp:ObjectDataSource >
<asp:ObjectDataSource ID="ObjectDataSource2" runat="server" DataObjectTypeName="G1_OnlineStoreObjects.Book"
DeleteMethod="Delete" SelectMethod="LoadByVolumes" TypeName="G1_OnlineStoreDAO.BookDAO"
UpdateMethod="Update">
< SelectParameters >
<asp:QueryStringParameter Name="volumeID" Type="Int32" QueryStringField="VolumeID" />
< / SelectParameters >
< / asp:ObjectDataSource >
<asp:GridView Visible="false" ID="GridView1" runat="server" AutoGenerateColumns="False"
DataKeyNames="ID,SeriesID,VolumeID" DataSourceID="ObjectDataSource1" CellPadding="4"
ForeColor="#333333" GridLines="None">
< Columns >
<asp:CommandField ShowEditButton="True" ShowDeleteButton="True" />
<asp:BoundField DataField="BookName" HeaderText="BookName" SortExpression="BookName" />
< / Columns >
< / asp:GridView >
<asp:GridView Visible="false" ID="GridView2" runat="server" AutoGenerateColumns="False" DataKeyNames="ID,VolumeID,SeriesID"
CellPadding="4" DataSourceID="ObjectDataSource2" ForeColor="#333333" GridLines="None">
< Columns >
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
<asp:BoundField DataField="BookName" HeaderText="BookName" SortExpression="BookName" />
< / Columns >
< / asp:GridView >
besides that i have 2 page: Series.aspx and Volume.aspx. in Series when I click at some field I want it redirect me on ObjectDataSource1 and GridView1. like that when I click at Volume's field must redirect me on ObjectDataSource2 and GridView2.
How different this 2 DataSource in codebehind?
C# Developer
|
|
|
|
|
can anybody tell me how to bind css file to web user control!
as if im using master page,i can bind css file but i want to know if there is any way to add tag
for css in web user control!
|
|
|
|
|
Spurple wrote: i want to know if there is any way to add tag for css in web user control!
You are talking about Custom user control? You can simple add the css reference like you did in same other page. Please correct me if my understanding of your question is wrong.
|
|
|
|
|
you need to bind the css once in a page.just include it in the master page that will be available in the entire page.i e you webusercontrol will also be able access the css if master page is applied on the page.
|
|
|
|
|
Hi to all,
I am trying to send the "contact us" from data to email on submit button click. But giving this error.
Server Error in '/VICTORIAIN' Application.
Mailbox unavailable. The server response was: not local host hotmail.com, not a gateway
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Net.Mail.SmtpFailedRecipientException: Mailbox unavailable. The server response was: not local host hotmail.com, not a gateway
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[SmtpFailedRecipientException: Mailbox unavailable. The server response was: not local host hotmail.com, not a gateway]
System.Net.Mail.SmtpTransport.SendMail(MailAddress sender, MailAddressCollection recipients, String deliveryNotify, SmtpFailedRecipientException& exception) +858231
System.Net.Mail.SmtpClient.Send(MailMessage message) +2004
Contact_Us.send_data_to_mail() +189
Contact_Us.BtnSubmit_Click(Object sender, EventArgs e) +18
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1746
Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433
I am using this code:
SmtpClient smtpClient = new SmtpClient();
MailMessage message = new MailMessage();
MailAddress fromAddress = new MailAddress(TxtEmail.Text, TxtName.Text);
message.From = fromAddress;
message.To.Add("rohanrajpoot@in.com");
message.Subject = "This person has contacted us!";
message.IsBodyHtml = false;
message.Body = TxtMessage.Text;
smtpClient.Send(message);
In web.config I did this:
<system.net>
<mailSettings>
<smtp>
<network host="myhostname" port="25" userName="loginname" password="pass" defaultCredentials="true" />
</smtp>
</mailSettings>
</system.net>
Can anyone assist me....
cheers,
sneha
|
|
|
|
|
sneha Choudhary wrote: <smtp>
<network host="myhostname" port="25" username="loginname" password="pass" defaultcredentials="true">
Does SMTP configure Properly ?
|
|
|
|
|
I agree with the previous comment, it seems like your SMTP mail server must be configured incorrectly in your web.config file. I tested your code (slightly modified), using localhost as the mail server; it worked just fine.
string TxtEmail = "Sue.Smith@123.com";
string TxtName = "Sue Smith";
string TxtMessage = "This is a test email message.";
using(MailMessage message = new MailMessage())
{
message.From = new MailAddress(TxtEmail, TxtName);
message.To.Add(new MailAddress("rohanrajpoot@in.com"));
message.Subject = "This person has contacted us!";
message.IsBodyHtml = false;
message.Body = TxtMessage;
SmtpClient smtpClient = new SmtpClient { Host = "localhost" };
smtpClient.Send(message);
}
Regards,
Gary
|
|
|
|
|
Hi All,
Did any one know how to use HighSlide Popup in .net and I need to Show Routeplanner in highslide popup?
Can any one help me ?
Thankyou In Advance,
YamunaRani.
|
|
|
|
|
|
Hi Abhijit,
Thankyou for your reply.
Before posting this into Messageboard,i gone through the same Highslide site,the thing is here I am unable to download files which required as we need to pay amount for that.And the thing which i got as free is not useful for me.Becoz of that, i had sent this post, hoping that i will get any other solution.
Regards,
Yamuna
|
|
|
|
|
Hi,
Following is log of an error that we are frequently getting while invoking excel and perfoming calculations using asp.net (Excel 2007)
17Jul2009 13:03:42 INFO ODSReports.OrdStatsByPercentGraph - .Creating chart for OrdStatsBySKU
17Jul2009 14:14:51 WARN ODSReports.ODSExcelFunctions - Unable to programmatically set <CenterFooter> of PageSetup. Page formats might be incorrect. Please check and set Page setup options manually.The remote procedure call failed. (Exception from HRESULT: 0x800706BE)
>>>>>>>.Exception here - Remote procedure call failed. Note that the chart prep has taken 1 hr +
17Jul2009 14:14:51 WARN ODSReports.ODSExcelFunctions - Unable to programmatically set <RightFooter> of PageSetup. Page formats might be incorrect. Please check and set Page setup options manually.The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
>>>>>> RPC is unavailable...
Notes:
1) We get this error only when we use a large dataset (e.g. working with > 10000 rows). Things work perfectly when we use smaller datasets (e.g. 1000 rows etc)
2) We did not see this on Excel 2003. Excel 2007 seems to be slower and also having this problem.
Do you know of any info/issues regarding excel 2007 and RPC disconnect/timeout etc ?
Thanks a lot for your time
|
|
|
|
|
hiiiiiii
i hav created a menucontrol dynamically and populated it through the database.
how can i now navigate to particular aspx page on click of the menu item.
on clicking each menu item i want to open the aspx page related to that menuitem.
thanks...
|
|
|
|
|
Set url to
NavigateUrl property of MenuItem.
i.e
menuItem.NavigateUrl = "Home.aspx"; //set url page to your according needs
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
I Should start typing fast 
Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
Next time I wouldn't reply before you  LOL
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
|
Use the NavigateUrl property
Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
