|
Hi,
I've seen people complain about this error other places, but noone ever answers them...
Can't find solution to this erro message:
'c:\documents....\...xls' could not be found. Check the selling blah blah blah
(it appears in excel when clicking the send to excel button)
It seems it's trying to open a file that doesn't exist yet or something...
Then I can click the button on my apsx page again, and it will work fine in excel...
But any help solving this problem will be very appreciated...
I'm sure some of you have seen this probelm before? :s
-- modified at 4:20 Monday 7th August, 2006
the code:
Response.Clear()
Response.Buffer = True
Response.AddHeader("Content-Disposition", "attachment;filename=Wells.xls")
Response.ContentType = "application/vnd.ms-excel"
Me.EnableViewState = False
Response.Charset = String.Empty
Dim myTextWriter As New System.IO.StringWriter()
Dim myHtmlTextWriter As New System.Web.UI.HtmlTextWriter(myTextWriter)
Exceldg.RenderControl(myHtmlTextWriter)
Response.Write(myTextWriter.ToString())
Response.End()
when i remove the line Response.AddHeader("Content-Disposition", "attachment;filename=Wells.xls")
it just opens the excel inside the browser without errors, so i'm guessing error is from that line for some unknown (to me) reason
|
|
|
|
|
Solved it myself, posting solution for others:
I had and needed this on top of my page
Response.CacheControl = "no-cache"
(Or it wouldn't show last added items..)
Had to remove that line to get the excel thing working...
And to solve the display thing, I just sent a unique new id for each time a record was added (open aaa.aspx?id="& newID &" instead of open aaa.aspx))
|
|
|
|
|
hi,
I want to use the dateTimePicker control in VB.net,with the format dd/MM/yyyy, but I want the cursor to move from dd, to MM then to yyyy,directly while changing the value, so that the user don't have to move with the left arrow.
can anybody help me, please
Regards.
MK
|
|
|
|
|
I need to simulate a mouse click by pressing a button on the keyboard, the button part is fine, i just need to know how to make the mouse click without user input. I would Preferably like to acheive this without the use of APIs, as i dont quite understand how to use them properly.
Help Appreciated! Thanks in advance.
Posted by The ANZAC
|
|
|
|
|
The ANZAC wrote: I would Preferably like to acheive this without the use of APIs, as i dont quite understand how to use them properly.
I don't want to sound harsh here, but why don't you learn how to use the APIs? - they are there to make life easier, and they will make your life easier when you learn them.
|
|
|
|
|
Ok, I am willing to learn but for this project would prefer not to use it, school is hectic at moment and haven't got that much time to learn. If it's not possible to achieve this task without API, could you recommend good place for API Newbies.
Posted by The ANZAC
|
|
|
|
|
hi
all
How to change password of sa (SQLSERVER 2000) through VB.Net code ?
ankesh
|
|
|
|
|
Try it with this stored procedures build in in SQLSERVER 2000.. See also the help to transact SQL
EXEC sp_password NULL, 'ok', 'Victoria'
Hans Braun
|
|
|
|
|
1st, i check for a valid id for the user n if its valid, a new form will show
the new form contains textboxes and a combo box
i would wan the textboxes and the combo box to display the corresponding stuff from the database
for exmaple
name: my name
address : my address
the followin is the code i used
--------
this 1 is which i validate the id, it works, but jus in case i wana know if the other code did not work because of it
--------
Private Sub submitB_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles submitB.Click
Dim strcon As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Jasmine\My Documents\project\db1.mdb"
Dim con As OleDb.OleDbConnection
Dim dr As OleDb.OleDbDataReader
Dim cmd As New OleDb.OleDbCommand
Try
Dim strselect As String = "Select BorrowerId from member where BorrowerId = '" & idTB.Text & "'"
'create a new connection
con = New OleDb.OleDbConnection(strcon)
con.Open()
cmd.Connection = con
cmd.CommandText = strselect
dr = cmd.ExecuteReader
If dr.Read Then
If idTB.Text = dr("BorrowerId") Then
MessageBox.Show("Valid Id")
EditMember.Show()
End If
Else
MessageBox.Show("Invalid Id")
End If
If idTB.Text = "" Then
MessageBox.Show("Please Enter The BorrowerID")
End If
dr.Close()
Catch eException As Exception
MessageBox.Show(eException.Message)
End Try
End Sub
--------
this 1 is where i wan the info to display out on the textboxes n combo box
--------
Private Sub EditMember_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim strcon As String = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source =C:\Documents and Settings\Jasmine\My Documents\project\db1.mdb"
Dim con As OleDb.OleDbConnection
Dim dr As OleDb.OleDbDataReader
Dim cmd As New OleDb.OleDbCommand
Try
Dim strselect As String = "Select Fname, Lname, Address1, Address2, Address3, ContactNo, HandPhNo, Email, CourseOfStudy from member where BorrowerId = '" & EditMemberLog.idTB.Text & "'"
'create a new connection
con = New OleDb.OleDbConnection(strcon)
con.Open()
cmd.Connection = con
cmd.CommandText = strselect
dr = cmd.ExecuteReader(CommandBehavior.SingleRow Or CommandBehavior.CloseConnection)
If dr.Read Then
Me.fNameTB.Text = dr("Fname")
Me.lNameTB.Text = dr("Lname")
Me.add1TB.Text = dr("Address1")
Me.add2TB.Text = dr("Address2")
Me.add3TB.Text = dr("Address3")
Me.hmTB.Text = dr("ContactNo")
Me.hpTB.Text = dr("HandPhNo")
Me.emailTB.Text = dr("Email")
Me.cosCB.Text = dr("CourseOfStudy")
End If
dr.Close()
Catch eException As Exception
MessageBox.Show(eException.Message)
End Try
End Sub
---------------------
pls, i need help asap...my tis proj is dued tml 9am >.<
oh btw, tis is my 1st proj on vb so...er, nothing too complicated pls >.<
|
|
|
|
|
Not exactly sure what your problem is... is it throwing you an exception? Not giving you the correct data? What?
|
|
|
|
|
ia, workin in vb.net 2005 i need to add mp3 file that run automactialy when i run the aplication it run in background of application no mediaplayer for it how i do that
ma_refay
|
|
|
|
|
If you are using VB.NET 2005 you could start a BackgroundWorker and in the DoProcess Event you could have code to start playing the media file. Just include the BackGroundWorker in the Main method of the program.
|
|
|
|
|
Use API call : mciSendString to play the mp3 file
http://justicemansoftware.tk
|
|
|
|
|
can u help me on how to translate the following C++ code into VB.
#define SCARD_ATTR_VALUE(Class, Tag)((((ULONG)(Class)) << 16) | ((ULONG)(Tag)))
ur response is greatly appreciated. thnx!
Kool Jboy
-- modified at 7:22 Sunday 6th August, 2006
|
|
|
|
|
This is a macro. You'll have to convert it to a function. << 16 is the same as * 2 ^ 16, or 65536. So a function that takes two numbers ( Class and Tag ) and return (Class * 65536) + Tag.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Thanks! It's now as clear as crystal water. 
Kool Jboy
|
|
|
|
|
Hello
I have a linklabel, when i press the first time it do a specific job
the second time i clicked it do another job
How can differ between first click and the second one.
Thank you in advance
Assaf
|
|
|
|
|
You need to handle the click event and set a flag so you know if it was clicked before, and respond accordingly
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
I'm sorry can you give ore hint about this subject
because i fail to do this
With my regard
Assaf
|
|
|
|
|
Have a bool variable that is set to false.
bool is1stMethodDone=false;
in the click method:
if(is1stMethodDone)
{
do some code...
is1stMethodDone=true;
}
else
{
do some other code...
}
-- modified at 18:10 Monday 7th August, 2006
|
|
|
|
|
I found this error when i run the function
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. no work was done.
basicly i trying to refer to the No. and retrieve the information form the access to my VB6data report. Which i doing is delivery order report.
i create a data enviroment and my command i put the sql command which it "select * from DO where [NO]= " & dorder.dono.text"
is the .. SQL problem.. or.. others.? cause i when i test on the form which it able to retrieve to the form but problem come out in data report..
|
|
|
|
|
hello friends,
i have to develop a software for placement activity in MBA college.
the project requires
1.The TPO should sent a notice to students on their respective Laptops.
2.Students should reply to the request sent by the TPO.
3.Students will be provided Login-id's and passwords through which they can access this software.
So my query is whether the software should be installed on the client side or server side.
And which programming languages will make this work.
from bhavik parekh
|
|
|
|
|
|
If the only functionality is for a message to be sent, and then replied to, do you really need a full application? What's wrong with just sending out emails?
Otherwise, I'd suggest doing a full pros and cons list of the sensible approaches (web-based, distributed client, client-server...)
As for language, there aren't many modern languages that can't do what you are after. I'd suggest working out how you wish to implement it before deciding on a language to use.
|
|
|
|
|
i finish work in school project but i don't know how make permission
for example no body can open or deal with trasury menu or dir it's details or salary or money in or out from treasury except accountant
mangers can see all schedules and edit in it .teachers can not edit schedule
how i can security level for persons use my application
answer me quickly thanks
ma_refay
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
