|
Dim i, j As Integer
Dim xlApp As Excel.Application
Dim xlSht As Excel.Worksheet
Dim rng As Excel.Range
xlApp = New Excel._ExcelApplication
xlApp.DisplayAlerts = False
xlApp.Workbooks.Add()
xlSht = CType(xlApp.Sheets(1), Excel.Worksheet)
xlSht.Name = "BDIS-Download"
I was trying to assign the grid results to an excel sheet and received the following message: Expression is a value and therefore cannot be the target of an assignment
Dim dc As DataColumn
Dim dr As DataRow
For i = 0 To grdResult.Columns.Count - 1
xlSht.Cells(i + 1) = grdResult.Columns(i)
Next
With xlSht
rng = CType(.Columns(1), Excel.Range)
rng.AutoFit()
End With
xlApp.ActiveWorkbook.Close(True, "C:\BDISTest.xls")
xlApp.Quit()
ReleaseComObject(rng)
ReleaseComObject(xlSht)
ReleaseComObject(xlApp)
|
|
|
|
|
Shouldn't that read something like this[^]?
xlSht.Cells(i + 1).Value2 = grdResult.Columns(i)
I are Troll 
|
|
|
|
|
Hi guys,
I have developed a lengthy form, some time end user takes more than an hour to fill in and submit that form to database. All code is inside updatepanel and script manager control this is requirement. so end user is either filling in the form or sitting idle it doesn't make any difference.
I dont want to increase session timeout.
Is there anyway to fire button's submit event after 10 mins to enable the form to submit data automatically if user doesn't click the submit button.
any help would be really appreciated.
thanks
kind regards,
learner
|
|
|
|
|
From the description, it has to be one huge form to fill. I hope you have not placed entire thing into a single page.
What you can do is when the user navigates from one page to another, do a partial save so that you don't loose data.
"No matter how many fish in the sea; it will be so empty without me." - From song "Without me" by Eminem
|
|
|
|
|
thanks for your response danish,
but i think i couldn't explain my problem properly.
now scenario is Off course form is lenghty and everything is working absolutely fine there is no problem with insertion, updation or deletion. Now the problem is sometimes users take more time than normal that's why session got expire, my boss asked me to save data after 10 mins either end user submit or not. even all blank fields.
system can save form even there is not any field filled in.
Now my problem is that how I could store data after every 10 mins automatically.
any suggestion would be appreciated.
kind regards,
learner
|
|
|
|
|
Learner520 wrote: now scenario is Off course form is lenghty
That is what you should look to get rid off. Functionality might work. But think of someone using their mobile phones (no 3G) to browse your website or someone with almost dead internet connection. I would be very frustration to wait for ages to get form loaded.
Hence, I suggested to split form across the pages and you can save them when user moves from one page to another.
BTW if you still need to have save happening with current structure, you would need Ajax. You can keep your submit button in an UpdatePanel and then trigger its click event regularly. You can use a Timer for this. Set its interval as 10 mins and handle Elapsed event to call Save/Submit button click.
Use of UpdatePanel would help you getting rid of the page reload. Also, if you are doing save on regular basis, you will need to keep track if save is called first time or not. You should do save first and Update then after.
"No matter how many fish in the sea; it will be so empty without me." - From song "Without me" by Eminem
modified on Tuesday, February 2, 2010 9:58 AM
|
|
|
|
|
thanks danish
I have done in the same way as you told.
kind regards
learner
|
|
|
|
|
Hi i have a user control, in tht with in updatepanel...,
two link buttons are there using tht i am binding a repeater control values...,
the user control link button click events working in some pages and some pages giving error as
"sys.webforms.pagerequestmanagerservererrorexception : input string was not in correct format"...,
see in the following url...,
Right side "Latest/Highest Rated" block inside two link buttons
1) is Latest topic
2) is Highest Rated
Working Url:
http://www.indiainfoline.com/discuss/blogs/
Not working Url:
http://www.indiainfoline.com/Discuss/Blogs/Markets-in-2010-/474397
i dont know whts the exact probs...,
Plz help me out to rectify this..,
Thanks & Regards,
Member 3879881,
please don't forget to vote on the post
|
|
|
|
|
Why have you posted this question again when it has only been here for a few hours?
|
|
|
|
|
hi all talented people
here is my query:
how to send bulk emails automatically from database time to time using vb.net windows application.
your suggesstion is highlyyyyyyyyyyyyyyyyy welcome
thanks in advance
if some one have idea about this problem plz find out me on:abdulwahab79@gmail.com
|
|
|
|
|
it is easier to send the email using a stored procedure in SQL Server that is scheduled a job to send it
if this is not the way you want to go please explain to me in more detail and ill try to help you
|
|
|
|
|
Try to develop an windows application sending mail and assign it to task scheduller..!
LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.
|
|
|
|
|
You can schedule a job and can set the time<pre> when to send an email.
Firstly, you need to configure your database for sending mails. Connect to your database---> Go to Management ----> Right Click database mail and configure database mail.
Inderjeet Kaur
Sr. Software Engg
|
|
|
|
|
Use Windows Service for your purpose....
|
|
|
|
|
There are many examples of sending emails from a VB application, and windows scheduler will fire the application at the desired time, but have you considered writing a windows service if the requirement is to send at fixed intervals? BTW, there is no need to use SQL Server to send emails, there are built in classes in the .net framework and its very simple.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Respected,
Thanks for solving my previous problem.
Now how me print the HTML page with Default printer.
It ignore the printer setting popup dialog box.
Thanks.
|
|
|
|
|
|
Respected,
But sir I have print directly without showing the
print preview page and printer selection Dialog Box.
Thanks for replay
|
|
|
|
|
|
Hi,
I am writing an Mobile SMS application(Asp.net, C#.net), SMS provider has given the following URL to send SMS from the asp.net application.
http://01.02.01.xx/smpp/sendsms?username=xxxxxxxx&password=xxxxxxxx&to=xxxxxxx&from=xxxx&udh=x&text=xxxxx&dlr-url=x
but i don't have any idea, How to use this above URL, and to send sms to the mobile from the asp.net application, But if i execute the same in the browser, the message is going to mobile. Can you please help, how to implement the same in the asp.net application.
Thanks & Regards
Murthy
|
|
|
|
|
You will have to use the HTTP request response object to post your data to the service provider. This is called as HTML Screen Scraping and you can find the basic details here[^]
|
|
|
|
|
|
Hi All,
I am using browserMob Website Monitoring tool for my asp.net website and getting this error mail send by browserMob."Selenium.SeleniumException: Timed out after 30000ms"
I am don't know why this is happing and what is the solution of this.
Any body tell me the solution if this ................
Thnks .........
|
|
|
|
|
Hi Sumarjeet.
I'm not familiar with selenium but I found this answer here.
"Set , selenium.setTimeout("600000"); before selenium.openUrl() ; , It will solve the issue."
Hope it helps!
|
|
|
|
|
Hi everybody
i have used google map in my asp.net website.i have used google map api for this.i have plotted one marker successfully but there is problem when i am plotting multiple addresses,geocoder.getlatlang method is working asynchrounusly,as i m plotting 18 addresses then sometimes it show 8 sometimes 10 like this.i have searched on google a lot but no luck.
Thanks
modified on Monday, February 1, 2010 3:01 AM
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
