Search results for query: *

Duh! Access. Sorry about that.

I have a .csv file full of email address that I upload to a folder on the web site. I need to write some asp script to insert the contents of the csv file into an existing table. Been at this for hours. Any suggestions how to write the insert statement?

EXEC sp_configure 'allow updates', 1 RECONFIGURE WITH OVERRIDE GO Update sysusers set name = 'new name' where name = 'old name' and issqlrole = 1 GO EXEC sp_configure 'allow updates', 0 RECONFIGURE WITH OVERRIDE GO

Is there a way to rename a role? I don't want to spend the time setting up all the permissions associated with the role. Thanks,

Under <EditItemTemplate> set Visible=false for the label displaying the original data.

EditCommandColumn is the last column. Thanks <asp:datagrid id="DG_Combo" CellPadding="3" BackColor="White" BorderWidth="1px" BorderStyle="None" BorderColor="#CCCCCC" Width="99%" Runat="server" AutoGenerateColumns="False" OnUpdateCommand="DG_Combo_Update" OnEditCommand="DG_Combo_Edit"...

I have a datagrid with an editable column. Everything works fine, but when the Edit button is clicked and the dropdown appears, the orginal value in that cell is still showing. Another way I could say this is that the dropdown does not replace the origin value of the cell, it appears along...

DotNetGnat's advice is most likely what you need. I am using VS 2003, and every now and then, the Handle statement on the end just doesn't show up; I have to type it in. Example below: Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click...

Mmmmm...... Let me ask a slightly different question. Am I right in closing and disposing of the dataReader, Command, and the connection?

Below is a small piece of code that connects to a database, puts the data into a DataReader, loops through the DataReader, then attemps to close the connection. I run the code, everything works. Dim myConnectionString As String = ConfigurationSettings.AppSettings("ConnectionString_BillyBob")...

Not everything I was looking for, but a very useful set of macros. http://www.codeproject.com/vb/net/CustomMacro.asp

Is it possible to write a macro in VS2003 that would find each Sub and Function, and then insert a statement to write the name of the Sub or Function to any output file as the first line or the Sub or Function? That might have been a bit confusing, so I'll try to explain it another way: I need...

Below is a selection of code I've highlighted. Me._oRelease.PriceShipping = .Item("PriceShipping") Me._oRelease.PriceTotal = .Item("PriceTotal") Me._oRelease.PriceTotalItems = .Item("PriceTotalItems") Me._oRelease.ReleaseGID = .Item("ReleaseGID") Me._oRelease.ReleaseStatusTypeGID =...

I downloaded someone's project from the internet. I created a new folder in the wwwroot folder, copied all the files to the new folder, then create a virtual web site using IIS. The project runs fine, but now I want to get it into Visual Studio. I have tried for hours with no success. Can...

Thanks for confirming that, jbenson001. I'll stop trying to figure it out.

Thanks. That is what I am doing. I was looking for a way to redirect from the sub. Actually, it is a sub calling another sub calling a function. I assume from your answer that transfer and redirect will only work from the web page, yes?

I have a *.aspx and a *.aspx.vb page. The code-behind page calls a sub in a module. If an exception occurres in the sub, I want to redirect to an error page. How do you do that?

Here is exactly what I was looking for: Finding the physical path of a web application from within a VB module. Public Function GetAppPath() As String Return System.AppDomain.CurrentDomain.BaseDirectory() End Function

Unfortunately, I should have said "classes" and "modules." I was looking for someway to set it once like I did in the web.config. That way I could call it anyplace in the project. But now that the project will be running on a number of servers, I would have to create a appSettings for each...

I cannot use Server.MapPath because where I need to use it is in a vb class, not in a .aspx page. Does that make sense?