Re: Excel Interop services exception -- Urgent - ASP.NET Discussion Boards

Re: cannot connect to sqlserver 2005

Mr. Wonderful8-Mar-10 23:21

8-Mar-10 23:21

Dear sashidhar,
I told you same code exactly was written in visual studio 2005 , and successfully make a connection. there is no error in my connection string. by the way, the security type is integrated security=true. and what you told me about username and password it is true, i mean it doesn't work in sql server management studio. so any idea.

Regards Smile | :)

Re: cannot connect to sqlserver 2005

DX Roster9-Mar-10 1:20

DX Roster

9-Mar-10 1:20

use follwing syntax

try
{
Sqlconnection con=new Sqlconnection("connection String");
con.open();
}
catch()
{}

If You Get your answer then please Rating me...

Thanks..
"Are You Ready"
DX-ARMY

Re: cannot connect to sqlserver 2005

Mr. Wonderful9-Mar-10 17:51

Mr. Wonderful

9-Mar-10 17:51

Hi,
The connection now is working under windows XP, but still not working under windows 7, maybe the prolem in windows 7 Compatibility or need some updates.

regards Smile | :)

Re: cannot connect to sqlserver 2005

jayantbramhankar9-Mar-10 9:30

jayantbramhankar

9-Mar-10 9:30

Put your connection string here, so we can go through it.

Crystal Report

Any_India8-Mar-10 21:16

Any_India

8-Mar-10 21:16

Hi
any one know the cristal report.I want to upload crystal report in web server.But is gives error that some dll file missing.Where to find that dll?

Re: Crystal Report

Sandeep Mewara9-Mar-10 1:03

Sandeep Mewara

9-Mar-10 1:03

Follow the link:
Deploying a Crystal Reports Application to a Remote Server[^]

Excel Interop services exception -- Urgent

Phanindra Kumar8-Mar-10 21:04

Phanindra Kumar

8-Mar-10 21:04

Hi,

I am using Excel objects in my application.When i am trying to create an object for excel object i am getting the following error.

System.Runtime.InteropServices.COMException (0x80080005): Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80080005

The same code is working fine on devolopment machine. But after publish the site on PreProd i am getting the above error.

Thanks in advance.

Phani

Phanindra...

Re: Excel Interop services exception -- Urgent

Sandeep Mewara9-Mar-10 1:01

Sandeep Mewara

9-Mar-10 1:01

You don't have MS Office installed on your PrePod.
Apart from Interop DLL, you would need MS Office to be installed on the server.

how to give automatic reminder to particular person through mail

developerit8-Mar-10 18:40

developerit

8-Mar-10 18:40

hi, iam having the table fields

name nvarchar(50),

emailid nvarchar(50),

startdate datetime,

enddate datetime.

when the end dates comes before ten days we have to remind him that your contract is left for 10 days only. for every 2 days he should get the reminder . when the date ends then he should get the message that you are not in contract how to do this.

Re: how to give automatic reminder to particular person through mail

Brij8-Mar-10 18:45

Brij

8-Mar-10 18:45

There are several ways to accomplish this Like
-Create a windows service which check the databse and send the mails accordingly to all.
- Create a exe which which check the databse and send the mail and schedule this exe to a specific time daily in windows scheduler.
....

Cheers!!
Brij

Re: how to give automatic reminder to particular person through mail

Amit Patel19858-Mar-10 19:39

Amit Patel1985

8-Mar-10 19:39

Hi all

Can u give the any example because same thing i need to implement

Thanks and regards,
Amit Patel

Re: how to give automatic reminder to particular person through mail

Sandeep Mewara8-Mar-10 19:45

Sandeep Mewara

8-Mar-10 19:45

Here you go:
How to with code sample link[^]

Re: how to give automatic reminder to particular person through mail

Brij8-Mar-10 20:04

Brij

8-Mar-10 20:04

Please follow the following steps
-Develop a console Application which will do the following things
-- Connects to DB and get the list of all the recipients where you need to send the reminder mail.This you can calculate with the help of enddate.This list you can prepare by C# also.Do as per you convenience.
-- Create/get a mail format that is to be sent the reciepients.
-- Loop all the reciepients, update the subject and mail body according to the reciepient and send mail one by one.
-- Create a task in windows scheduler,which will execute your exe at regular interval.

Please let me know if you face problem at any step.

Cheers!!
Brij

Re: how to give automatic reminder to particular person through mail

developerit9-Mar-10 23:58

developerit

9-Mar-10 23:58

please give me the same example.which helps me. iam getting errors

Re: how to give automatic reminder to particular person through mail

developerit9-Mar-10 23:55

developerit

9-Mar-10 23:55

can you give a small example for this .which helps me

Problem with Multiple Insert in sql server from c# code.

Johndas8-Mar-10 17:43

Johndas

8-Mar-10 17:43

Hi all,
can you please guide me, how to insert multiple insert using this code.

SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usp_Information";

for (Int64 acct = 1000000000000001; acct <= 1000000000024000; acct++)
{
String sAcct = Convert.ToString(acct);
SqlParameter p1 = new SqlParameter();
p1.ParameterName = "@ShawNumber";
p1.SqlDbType = SqlDbType.VarChar;
p1.Direction = ParameterDirection.Input;
p1.Value = sAcct;

SqlParameter p2 = new SqlParameter();
p2.ParameterName = "@UserId";
p2.SqlDbType = SqlDbType.Int;
p2.Direction = ParameterDirection.Input;
p2.Value = 88578539;

SqlParameter p3 = new SqlParameter();
p3.ParameterName = "@ParentShawNumber";
p3.SqlDbType = SqlDbType.VarChar;
p3.Direction = ParameterDirection.Input;
p3.Value = "22";

cmd.Parameters.Add(p1);
cmd.Parameters.Add(p2);
cmd.Parameters.Add(p3);
cmd.ExecuteNonQuery();

}

Here cmd.ExecuteNonQuery(), it is use for single insert statment, i want to insert multiple records at a time, please guide me.

Thanks in Advance.

JohnDas

Re: Problem with Multiple Insert in sql server from c# code.

Sandeep Mewara8-Mar-10 19:49

Sandeep Mewara

8-Mar-10 19:49

What are you doing?
The way you had put

cmd.Parameters.Add(p1);
cmd.Parameters.Add(p2);
cmd.Parameters.Add(p3);

in for loop, the same three parameters keep on adding again and again.
Does this method works fine for you? I doubt 2nd execution would work!

hi,how to save user changes header colors and font size in web application?

pramodgorityala8-Mar-10 7:55

pramodgorityala

8-Mar-10 7:55

hi every one,

i have one problem in my web application,i have two layouts.
iam giving user can change the header colors and font size in the css.but how to save user changes colors and font size.. and where ?
give me information or give url's..

thanks to all

Re: hi,how to save user changes header colors and font size in web application?

#realJSOP8-Mar-10 7:56

#realJSOP

8-Mar-10 7:56

Google "asp.net themes"

.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001

Re: hi,how to save user changes header colors and font size in web application?

Sandeep Mewara8-Mar-10 9:43

Sandeep Mewara

8-Mar-10 9:43

You need ASP.NET 2.0 Personalization feature!
Here you go:
MSDN: Personalization and User Profiles in ASP.NET 2.0[^]

How to get the index of the gridview with click of asp button

laziale8-Mar-10 4:57

laziale

8-Mar-10 4:57

Hello -
I want to get the index of the row where the button is clicked.
Please note that I am using EventArgs, not GridViewCommandEventArgs, since with GridViewCommandEventArgs nothing is happening, once the button is clicked.

Thx, Laziale

Re: How to get the index of the gridview with click of asp button

Brij8-Mar-10 5:24

Brij

8-Mar-10 5:24

laziale wrote:
not GridViewCommandEventArgs, since with GridViewCommandEventArgs nothing is happening

Can you post your code?

Cheers!!
Brij

Re: How to get the index of the gridview with click of asp button

laziale8-Mar-10 5:39

laziale

8-Mar-10 5:39

hello
thx for your reply and here is my code:
backend:

protected void updateNote(object sender, GridViewCommandEventArgs e)
       {
           string selectedIndex = "";
           int index = 0;
        index = Convert.ToInt32(e.CommandArgument);
         //  index = 1;
        //   Button bttn = (Button)sender;

        GridViewRow row = gvOrderNotes.Rows[index];

            ListItem item = new ListItem();
           item.Text = Server.HtmlDecode(row.Cells[3].Text);
           selectedIndex = item.Text;
       }

html:

<ItemTemplate>
                                       <asp:Button runat="server" ID="ChkUpdate" onclick="updateNote" AutoPostBack="true" Width="160%" Text="Update Order"/>
                                       <ajaxToolkit:ConfirmButtonExtender ID="chkUpdateConfirmBtnExtender" runat="server" TargetControlID="chkUpdate" DisplayModalPopupID="modalPopupExtenderChkUpdate"></ajaxToolkit:ConfirmButtonExtender>
                                       <ajaxToolkit:ModalPopupExtender ID="modalPopupExtenderChkUpdate" runat="server" TargetControlID="chkUpdate" PopupControlID="pnlChkUpdate"
                                       OKControlID="chkUpdateOK" CancelControlID="chkUpdateCancel" BackgroundCssClass="modalBackground" />
                                  </ItemTemplate>

Thx for your help one more time.
Laziale

Re: How to get the index of the gridview with click of asp button

Brij8-Mar-10 7:49

Brij

8-Mar-10 7:49

Why dont you use rowcommand event of gridview..
use your button like in the link

Cheers!!
Brij

Re: How to get the index of the gridview with click of asp button

Abhijit Jana8-Mar-10 5:38

Abhijit Jana

8-Mar-10 5:38

You have to use e.RowIndex, where e is EventArgs.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.