View Complete Post
I need to have an automated process to generate and send out csv data on a set schedule. Using the sp_send_dbmail routine is working great except for one small problem I am having trouble getting around.
I am specifying a query to be run and including the results as a file attachment. The customer wants a csv file with column names.
The attachment always includes a 'separator line' of dashes between the column header and the actual data. Is there any way to eliminate this line of dashes? When I use @query_result_header = 0 flag, it removes the line of dashes, but the column names are
also removed as well.
I want to keep the column names, but just remove the line of dashes. Any ideas?
Hello all again!
I am working on another project that I have come up empty handed and wondered if anyone out there has any other answers. I just got my incomming email to work in WSS 3.0.
Now I was wondering if there was a way to get the body of an incoming email message to be copied to a "Notes" Field in a list item on a site?
Here is what I have. I have created a document library called email-in. I am going to use this to bounce the emails off of. I will configure this to recieve email. However, once an email message is sent to it I would like to take
the body of the email message and copy it to a multi-line text field I have in another corresponding list.
The way I was going to be correlating the two is by the "case" number that we deal with i.e. 00123456. This matches a hyperlink description field that I have on the list item that I want to append the body of the email to.
Therefore, I would like to have system operate like this:
Person creates and email with the subject field contents of 00123456. Then the message is placed in the body of the email. After this the email will be received by the system and the system will look at the subject and se
Here are a comboBox with some items, some of them are disabled, you cannot select a disabled item by mouse, but you can select it by typing!
ComboBox jQuery: Styling DropDownList Alternating Items (Rows) In the following example, I will show how you can style any asp:dropdownlist very easily. The example demonstrates how you can change alternating row items background color, using the fadeTo() to add a nice touch in the dropdownlist. You can change alt rows with a couple lines.
I have a table containing courses, columns are
Name - "Yoga Classes"
DateStart - "2/23/2010"
DateEnd - "2/24/2010"
I am using ListView Control to bind it, is there a way to display them and group them by Month?
Piano Class (10th Jan 2010 - 11th Jan 2010)Guitar Class (10th Jan 2010 - 11th Jan 2010)
Yoga Class (15th Feb 2010 - 16th Feb 2010) etc...
Thanks for help.
I am currently in the process of writing a facebook type 'activity feed' for a site. Currently I am binding the last 10 items to a repeater control, which contains a usercontrol representing each item. This works fine but there are a couple of requiremnts that are giving me problems and wondered if the the good people of the forum could make some suggestions.
The requirement is that when a user clicks a refresh button any new events are added to the top of the list, the previous items drop down and the equivalent number of old items drop off the bottom, all with nice slider transitions.
I have put the repeater inside of an update control and are able to handle the transitions by using RegisterStartup script to drop jquery calls onto the page for the slider. However I cannot find a way to dynamically add or remove new datarows to the repeater. I need the old items to stay in the repeater and be pushed down by the new items, so completely refreshing the datasource seems like a bad idea.
I was thinking about maybe storing the datasource in the viewstate and adding rows to that, maybe with an extra column on the end which stores what transition is needed on the databind for my jquery, but there will be a 'View more items' link at the bottom of the page, so I am worried that the list could get pretty large and there
Please let me know is there anything else i can do i really would like use this effect.
P.S all the effect have the same render problem, and i am using ie8 under compatibility mode.
I'm wondering what's the best way to approach an online article system that allows users to comment by clicking on the line they are commenting about? Essentially the same way Adobe Acrobat works with comments where you can click anywhere and the text is saved for that location.
I'm assuming a mix of jQuery would be the crux of the interface. The system would need to save comments so that when another user logs in, they will also see the other comments but they canÃÂ´t edit them - only add their own.
Any suggestions would be great.
I am working on a project currently where I need to get data out of a 3rd party vendor's software that uses a .sdf file I looked this up and its a SQL CE file. I was hoping to just link to with with access but thats apparently not going to happen. I need to link to the database extract data from it to a csv file for later use. I also and most important I need to get the data from it and create a report that can be printed while on a customers site that my or may not have web access so I need for this program to be on and off line. I had my webapplication that I have been working on open and was able to bring up the sdf file under the server exploere however I can't seem to get anything out of it when I try to do grid views or detail views errors out.
Can I use one of Visual Studio projects to create this sort of applicaiton if so what would be the best approach. I would love to get an access odbc driver since office is allready installed on the employee's laptop's
I am new to this, so bear with me. I am writing an application in C# that uses LINQ to validate a datacontext off a textbox to see if the record exists already. If the record does exist I inserted an if statement to advise the user that the record exists, if the record does not exist I would like to allow the record to be added to the database. If I take out my else statement everything works fine as far as inserting goes, but I do not want to allow inserts in this scenario. I have tried moving the if and else statement to different parts of the code but can't quite figure this one out. Any help would be apprecaited, attached is the code. This code is set to a button press. As a matter of fact, if you see any other errors along the way please feel free to point them out.
protected void enterBTN_Click(object sender, EventArgs e)
//make new data context
SHCDataContext insNewAll = new SHCDataContext();
//LINQ to check if customer exists in database
var checkExisting = from c in insNewAll.Customers
//make list to store values