|
thank you... it looks useful. i will give it a try and hopefully it does the trick. Thank you for your time.
"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison
|
|
|
|
|
I have multiple embeded Excel spreadsheet in a Word document.
And I want to run some calculation in one spreadsheet with value from an other spreadsheet embeded in this Word document.
Any tip?
|
|
|
|
|
|
Matthew Cuba wrote: You might have better luck in a forum that deals with Excel and Word.
Indeed, but there none on CodeProject!
Matthew Cuba wrote: Try looking here
thanks!
|
|
|
|
|
Super Lloyd wrote: Indeed, but there none on CodeProject!
But there are more appropriate CP forums for this than the C# one. Try the general forum or the lounge.
--
CleaKO The sad part about this instance is that none of the users ever said anything [about the problem].
Pete O`Hanlon Doesn't that just tell you everything you need to know about users?
|
|
|
|
|
I am designing a windows application with Visual C#. (beginner)
In this application I created a windows form "MenuSettings" with a tabcontrol for general & specific settings.
in one of the tabs 4 directory paths must be set. Visually this is shown as 4 rows where each row has a button to browse for a directory and a textbox to show the selected full directory path.
my questions are:
1)How can i make this button browse for a directory
2)Show the selected directory in the related textbox
3)and store the selected directory path as a variable
|
|
|
|
|
1) Search for FolderBrowserDialog
2) To get the selected folder from FolderBrowserDialog, use the SelectedPath property. To display this directory in a TextBox, use the TextBox's .Text property.
3) Create a string field in your class. Name it something appropriate. Set it equal to the SelectedPath you get back from the FolderBrowserDialog.
|
|
|
|
|
|
Does anyone know of a free (preferebly c#) auto-scheduler available?
I have a bunch of 2.0 console apps that need to be executed at different times of each day and I figured I'd look around for an auto-scheduler that's already available before I go and create one from scratch (why reinvent the wheel ?)
Thanks.
-Goalie35
|
|
|
|
|
Couldn't you just use the Scheduled Tasks utility that is in Windows? Seems to work well enough for me.
Regards,
Matt
It isn't enough to do well in life.
One must do good when and where one can.
Otherwise, what's the point?
|
|
|
|
|
Hi All,
I have developed an ASP.NET application to send emails. I have followed the coding steps to create the application. But however, the mail is not getting delivered to the destination ID.
Can anyone help me in giving details about all the steps to be done before running the application. A sample application would be more helpful.
Thanks in advance,
Murali
|
|
|
|
|
What you have coded for the SMTP?
And what error it shows?
Did the Norton blocking you in sending the mails?
Regards,
Satips.
|
|
|
|
|
Hi,
Thanks for the reply.
If i set the SMTP Server name in the code as "smtp.gmail.com"(example), then i get the 'Could not access(CDO.Message) object' error message.
However, if i set it as 'localhost' then the email is redirected to the 'Queue' folder under the /Inetpub/mailroot.
Do i need to do any more settings?
Thanks in advance,
Murali
|
|
|
|
|
(1)Specify a valid mail server for the SmtpMail.SmtpServer property. If that property is not set, at least set it to 127.0.0.1. For example:
SmtpMail.SmtpServer = "127.0.0.1"
(2)If you are using "localhost" or "127.0.0.1" as the SmtpMail.SmtpServer, you may not have permissions to relay through the IIS SMTP Service. To allow access, open up the IIS Admin MMC. Locate the SMTP Virtual Server, and right-click, then select Properties. On the Access tab, click the Relay button. In the Relay Restrictions dialog, grant your IP address (127.0.0.1) to the Computers listbox. Close down all dialogs, and restart the SMTP Service.
(3)If you are using "localhost" or "127.0.0.1" as the SmtpMail.SmtpServer, make sure Anonymous access is allowd. To allow access, open up the IIS Admin MMC. Locate the SMTP Virtual Server, and right-click, then select Properties. On the Access tab, click the Authentication button. Be sure "Anonymous Access" is the only checkbox checked. Close down all dialogs, and restart the SMTP Service.
(4)The email address does not have a valid TO address. After iterating through the InnerExceptions, you may find this error message actually has to do with relaying. Try sending a test email to an email address that exists on the server specified by SmtpMail.SmtpServer. If you can send an email to that server, then it is a relay issue. Talk to your mail server administrator about letting your code relay through the mail server.
(5)Use a real FROM address that exists on the SmtpMail.SmtpServer. Do not use something like "asdf@asdf.com", or some other bogus address as your MailMessage.FromProperty. More advanced mail servers will catch this, and will deny relaying.
Regards,
Satips.
|
|
|
|
|
Hi,
I followed your steps. I send a sample mail to an ID existing in the local SMTP Server and the delivery was a SUCCESS.
However, if i try to send the mail to a different ID say hello@gmail.com, then i get a delivery fail message in the 'Drop' folder of the 'mailroot' folder.
Do i need to enable some options in the destination SMTP Server to recieve mails from my machine?
Thanks in advance,
Murali
|
|
|
|
|
Does anyone knows how to make a column become a checkedbox in runtime. Here is my code from the dataset:
-----------------------------------------------------------------------------
sql = @"SELECT lastName,firstName,MiddleName,LoginName,Passwd,ReadOnly,Updates,Deletes,Inserts,Administrator FROM Users ";
SqlDataAdapter da = new SqlDataAdapter(sql, conString);
da.Fill(ds, "Users");
//dataGridView1.DataBindings.Clear();
dataGridView1.DataSource = ds.Tables["Users"];
-----------------------------------------------------------------------------
I want the following column become checkedbox.
ReadOnly,Updates,Deletes,Inserts and Administrator
|
|
|
|
|
I have made a COM DLL and facing this error
Error:Retrieving the COM class factory for component with CLSID {} failed due to the following error: 8007000e
can anybody solve this problem
Thanx
|
|
|
|
|
The error code implies that class was not registered. If you have a proxy/stub for the above CLSID then you need to register it on the machine.
Regards,
Satips.
|
|
|
|
|
I have registered it on that machine but that machine is a 64 bit envirment.
will it make any difference?
wat will be the solution for that?
Thanx
|
|
|
|
|
Yes. But I dont know the solutoin exactly. Google it
|
|
|
|
|
hi!
i am building an application which inserts 100000 or more records in XML file and then retrieve those records when required in a datagridview control.
The retrieval of records is very slow, it takes 1-2 minutes in populating datagridview. First i thought it is because of XML, but today i came to know that it takes more than one minute for just creating 100000 rows of datagridview. I checked it by inserting 100000 empty rows in datagridview.
I tried to create rows in a separate thread but it gave exception that row cannot be inserted from a thread other than the one which created datagridview. i tried the technique available on msdn, which makes "Thread-Safe Calls to Windows Forms Controls" but it did'nt worked (may be i was not able to handle it)....
Now can any one please tell me how to get required result...? how can i add 100000 or more rows in datagridview control within 10 seconds...? is there any alternative way to do this?
Thanks in advance...
Regards,
Affan Ahmad Toor
|
|
|
|
|
Maybe 100,000 rows in a datagridview isn't what you really want. The user can only see a few of these at a time anyway, right? Just a thought.
Regards,
Matt
It isn't enough to do well in life.
One must do good when and where one can.
Otherwise, what's the point?
|
|
|
|
|
You don't. You create a DataTable, or some other DataSet that holds all of your data, then bind the DataGridView to this data source.
I can fill a DataTable with 100,000 row of randomly generated data and show it in a DataGridView in less than 4 seconds.
Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic 2006, 2007
|
|
|
|
|
Hi!
Thanks for reply, i just solved my problem with your mentioned method. I am not able to populate 100000 records in 4 seconds, as you mentioned, it is taking approximately 10 seconds, but stil it is better than 1 minute and fulfils my requirment..
Thanks again...
Regards,
Affan Ahmad Toor
|
|
|
|
|
Affan Toor wrote: I am not able to populate 100000 records in 4 seconds, as you mentioned, it is taking approximately 10 seconds,
Noone ever said XML was fast. Storing 100000 records in an XML file is not a good idea. XML was meant to be a transport, not a database. It only has the look and feel of a database table.
Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic 2006, 2007
|
|
|
|