|
Hello
I try to export some data fom my textboxes and comboboxes to a define excel sheet
I use this methode but i have an error message when exporting
"Dim path As String = CurDir() + "\WebUI\Editors\QuotationReport.xls"
Dim ex As Excel.Application
Dim wb As Excel.Workbook
' Dim ws As Excel.Worksheet
ex = CreateObject("Excel.Application")
ex.Visible = False
wb = ex.Workbooks.Open(path)
Dim objSheet As Excel.Worksheet
objSheet = wb.Sheets(1)
Dim Somme As Double = 0
"Here i assign the dat to a specific cells"
ex = Nothing
ex.Workbooks.Close()
Response.Clear()
Response.AddHeader("Content-Disposition", "attachment; filename=" & file.Name)
Response.AddHeader("Content-Length", file.Length.ToString())
Response.ContentType = "application/vnd.ms(-Excel)"
Response.WriteFile(file.FullName)
please can someone help me.
And thanks in advance
Assaf
|
|
|
|
|
|
Ok I have a google map on my page and there is a list of users in a drop down box. Is it possible to call a function ADDMARKER (javascript) to add a marker to the map? I know the listbox will have to postback to get the value.
The thing is, is that I have to use C# to get the users latitude and longitude. Mainly because all the code was written in VB and I have converted it to C#. Not sure how to convert it all to JavaScript.
Here is my function I need to call from javascript:
function addMarker(lat, lon, name, color) {
latlng = lat + lon;
map.addOverlay(createMarker(latlng, name, color));
}
Here is what is happening in the code behind on SelectedIndexChanged:
protected void dropUsers_SelectedIndexChanged(object sender, EventArgs e)
{
theName = dropUsers.SelectedItem.Text;
theCode = GetCode(theName);
lat = Tracker.GetDevice(theCode).Latitude;
lon = Tracker.GetDevice(theCode).Longitude;
theColor = "normal";
string javaScript = "<script type='text/javascript'>" +
"addMarker(" + lat + "," + lon + "," + theName + "," + theColor + "));" +
"</script>";
Page.ClientScript.RegisterStartupScript(typeof(string), "dropUsers_Changed", javaScript);
}
Of course it is not working.... I can do a messagebox and get the correct information but tahts not what I want to do...
|
|
|
|
|
This should work, I've done exactly the same thing with google maps in ASP.NET/C#. One thing you may want to remember is, when you do a postback, any script you inserted before is lost, and new script is added only if this event is fired.
Overall, it makes sense to make this an AJAX call that adds a marker after getting whatever data you want from the back end. Google maps are so AJAXy that any sort of postback is going to stick out like a sore thumb.
Christian Graus
Please read this if you don't understand the answer I've given you. If you're still stuck, ask me for more information.
|
|
|
|
|
I couldnt get that to work... anyways I found an application here on codeproject that pretty much made google maps all in C# instead of javascript.. works great for now!
Thank you for your reply.
|
|
|
|
|
Yeah, I think I found that same one, when I considered posting the one I wrote. Of course, it just takes care of generating the javascript for you, but that's what's great about CP, you don't need to reinvent the wheel. I'm glad it worked out for you.
Christian Graus
Please read this if you don't understand the answer I've given you. If you're still stuck, ask me for more information.
|
|
|
|
|
hello
i create a custom workflow in VS2005 and activate its feature in a site collection and
associate its template with a custom list. i choose "start this workflow when a new item
is created" option when i associate workflow template with the custom list.
when i create a new item in my custom list nothing is happen and when i go to my log file
i face with this exception :
"AutoStart Workflow: System.ArgumentException: New instances of this workflow template are currently disallowed.
at Microsoft.SharePoint.Workflow.SPWorkflowManager.StartWorkflowElev(SPListItem item, SPFile file, SPWorkflowAssociation association, SPWorkflowEvent startEvent, Boolean bAutoStart, Boolean bCreateOnly)
at Microsoft.SharePoint.Workflow.SPWorkflowAutostartEventReceiver.AutoStartWorkflow(SPItemEventProperties properties, Boolean bCreate, Boolean bChange, AssocType atyp)"
i dont know where is my fault
please help me as soon as posible
tanks in advance
|
|
|
|
|
hi
asp.net 2005
the work I want to do is this:
the customer select his image from the dialog and show the picture on the page than save that in database.
whatever I did:
controls : input(file) , image,button1(for show picture) , button2(for save)
code:
button1_click()
{
if (File1.PostedFile!=null)
{
Image1.ImageUrl = File1.PostedFile.FileName;
}
}
button2_click()
{
MemoryStream ms = new MemoryStream();
File1.PostedFile.SaveAs(File1.PostedFile.FileName);
byte[] arr = ms.GetBuffer();
ms.Close();
//can't attach ms to save file
SqlCommand com = new SqlCommand(); com.CommandText = "insert into Employees(photo) values(@photo);
com.Parameters.Add("@photo", SqlDbType.Image).Value = arr;
}
result upper code:not show picture and not save
please guid me or if you know other way show me.
|
|
|
|
|
ma_sa_ah_pa wrote: MemoryStream ms = new MemoryStream();
File1.PostedFile.SaveAs(File1.PostedFile.FileName);
byte[] arr = ms.GetBuffer();
ms.Close();
//can't attach ms to save file
using (Stream imageStream = flpUpload.PostedFile.InputStream)
{
byte[] bytes = new byte[imageStream.Length];
imageStream.Read(bytes, 0, bytes.Length);
}
|
|
|
|
|
thank but I want a response with more details.
|
|
|
|
|
What more details you need ? The code which I given explains the details which you need. I got down voted for trying to help you. It's bad.
|
|
|
|
|
I'm sorry
I didn't Know that select No Item have any effect on your vots becuse I'm a new member.
|
|
|
|
|
Actually this is more of seeking your opinion than seeking your help to have an issue resolved, I've been working on a website for a couple of months and I'm preparing to get it online, I'm planning to have it hosted on a dedicated server, the question is, would you obfuscate your code before deploying it to protect your hardwork? or you'd simply upload it with no obfuscation to avoid all the problems that come with it, e.g. performance decrease, being unable to log exceptions (as the information in the stack trace would be useless in that case) .. etc? What would you do? Thanks for any suggestions ...
|
|
|
|
|
I never used to do it. It makes the deployment tough - AFAIK.
|
|
|
|
|
You need to consider if theres actually any "valuable IP" in what you are deploying. I'd say that in 99% of applications, especially websites there just nothing unique or reusable being done.
If you are worried that someone might read your code and learn some techniques they couldnt read tutorials elsewhere (and better documented) then you must be doing some quite cool stuff 
Don't bother. We don't even obfuscate our products, its unlikely that anyone is going to be disassembling our code for reuse (and if they did they'd be exposing themselves to some pretty serious legal risk). Fact is that if your competitors need to copy you then they are always going to be behind.
I'm using yFiles (a graph layout library) at the moment. Its obfuscated which is a massive pain in the arse for debugging. You get exceptions being thrown out saying "couldnt cast a.a.b.c to d", not even giving a slight clue what went wrong. Who is going to have the skill and time to dissassemble and reengineer a product that complex, without any trace of its origin, and be able to make it better enough to be able to sell it? Leads me to recommend it only if you need specific features it offers (otherwise go with a cheaper one).
Mark Churchill
Director
Dunn & Churchill
Free Download:Diamond Binding: The simple, powerful, reliable, and effective data layer toolkit for Visual Studio.
|
|
|
|
|
Hello all. This question deals with some ADO.NET, in addition to ASP.NET. I am creating a website in which a user will be able to customize clothing (hats, t shirts, etc.). I will have a database that stores images, colors, etc. as well as customer info. I will need to be able use the fields from my database (color, size, image, etc.) in order to create a product. Can anyone help me out, or point me in the direction of some good resources that may help to shed some light on my problem. Any help would be greatly appreciated.
"If you don't know where you're going, you'll probably end up somewhere else." Yogi Berra
|
|
|
|
|
It's easy, you create a "Product" class and fill it with values fetched from database. Alternatively you can use some OR/M tools which does this.
|
|
|
|
|
|
You're going to use a repeater for something like this forum, b/c a repeater gives you absolute control over the layout.
Christian Graus
Please read this if you don't understand the answer I've given you. If you're still stuck, ask me for more information.
|
|
|
|
|
I am using Web Developer 2008 express edition. When I drag images into my webform from the App_Data folder, they are visible at design time but won't show when I "Preview in browser". The only thing that works right now is to hard code the entire path of the image. (which won't work when the site is deployed)
Here's a sample of what works and what doesn't:
Does Work:
style="width: 255px; height: 108px" />;
Doesn't Work:
style="width: 255px; height: 108px" />;
I didn't seem to have this problem in VS 2005. Thanks in advance.
"Make it as simple as possible, but no simpler" Issac Newton
|
|
|
|
|
Are you running the site from localhost ? That is, not localhost/something ? What if you put a / at the start of the path ? ~/ also forces start from the root, I believe.
Is the control in a subfolder ?
Christian Graus
Please read this if you don't understand the answer I've given you. If you're still stuck, ask me for more information.
|
|
|
|
|
Thanks for the reply. Yes I'm running local host.
I have also did the ~/ syntax and it has not changed anything. That's also the standard syntax that generates when you set the image url in the design mode. The jpg is located in a sub folder but the generated code from the designer compensates for that. To make sure all this is not confusing, I was originaly using design mode to set all my image urls but when I got no results at run time, I started trying to modify the source code. Any further suggestions will be greatly appreciated!
"Make it as simple as possible, but no simpler" Issac Newton
|
|
|
|
|
Hi!
I can't understand it...
I'm using a table control with "CssClass" property inside an user control.
If I set 'CssClass="footer"', the '.footer' style is applied ok; but if I set 'CssClass="report"', this style don't work.
Of course, both '.footer' and '.report' exist in css file and the master page that contains the user control have a '' in the 'head'.
Do you have any idea?
Thank you in advance.
--
[Adrián Córdoba]
|
|
|
|
|
Open the error console in Firefox so that you see if it reports any errors in your css.
Get the FireBug plugin for Firefox. There you can locate the element in the document outline and see exactly what css applies to it.
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
I'm not using Firefox. It isn't installed.
--
[Adrián Córdoba]
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
