Topics

Hi all, I have a very strange problem with accessing and reading from my access database. my .mdb file is password protected, the pass is "12345". ok, the code works fine when I want to read data from Table "SC" but when I want to read the data from Table "Groups" I cannot!!! you simply can replace this code with the one is my form_load event: and will see that it won't work anymore! pleassssseeeeeeee help meeeeeee! :( Dim STrPath = System.IO.Directory.GetCurrentDirectory & "\0.mdb" Try DB = New OleDbConnection("Provider=microsoft.jet.oledb.4.0; data source='" & STrPath & "';jet oledb:database password=12345") Dc…

Hi all 1st Question. How i can know that the file already successfully downloaded into local path in client pc. Im using the the Repsonse.Wirte(FilePath) 2nd Question All the file to download will display in the datagrid and 1 of the column display the status of the file either "Downloaded" or "Not yet downloaded" After i Downloaded the File i will update the status for the particular File in database. The status was updated in db and i try to bind the datagrid back but it seems like not working... Any comments? Please help i am stuck :confused: Thanks in advance

I need to be able to access a file via a network path using the TextFieldParser object. I have the following code: <code> Dim tfParser As New TextFieldParser(\\servername\e\April_CDR_Search\0423\filename.csv) </code> I get the error that the file can't be found, when I know it is there. When I change it to my local drive (with C:\ as the prefix, it works fine). Is there something else I need to include in order for the TextFieldParser object to find the file on the network drive?

Using visual basic .net, I was wondering how I would be able to get the target file of a shortcut (.lnk file). Thank you for any help.

I have 2 computers, A and B. On computer A I have installed sqlserver 2005 and I have enabled Ad Hoc queries. On computer B I have an excel file, MyExcel.xls. On comp B I have installed only SQL Server Management Studio and it can access the databases on computer A On computer B I�m trying to select the data from that excel file(witch I remind you is on computer B) using the following query: select * from OpenDataSource( 'Microsoft.Jet.OLEDB.4.0', 'Data Source="\\ComputerB\Share\MyExcel.xls";user id=myUser;password=myPassword; Extended properties=Excel 8.0')...Sheet1$ When I parse this query I got the message: �Ad hoc access to OLE DB provider 'Microsoft.J…

Hi: I am working on routine that takes in a datatable, and add extended properties to each column, by reading an XMLDocument object. The routine is currently doing a dt = source.copy, and then has a for each statement, in which extended properties are added by reading each XML node. I would like to also include a functionality so I can set sequence for the columns, so the routine returns a datatable with columns sequenced from a sequence attribute in my xml. Can someone please tell me how to set the sequence for each column in a datatable before returning it. Following is the function, that works right now, but doesnt do the sequencing althought it does take in a datat…

Hi Guys, I have a few aspx pages which returns xml results.. Meaning user will send a url through external application and it will return xml results in an aspx page. For ex: user might send a url like : http://10.20.2.2/fol/getNames.aspx And this page might return some data in xml format like the following <names> <name id = "1" name="john" age="20" /> ... </names> So the flow is : User send URL -> XML Results return to aspx page -> apply xslt -> return html My question is that how can i apply xslt to this getNames.aspx so that it converts the data into some html format table? thank you very much for any sugess…

Hi!, My web site on a server which does not allow changing file permissions. The server normally does not allow any file upload or writing for ASP.NET. I tried using "<identity impersonate= true>" on web config but this did not solved my problem. When I open my ftp connection and upload a file manually then my ASP.NET code can write for a while (about 20 mins). How can i find a good solution on this issue? Do I have to follow these boring steps each time? Thanks in advance.

Hi, I need to get child control to the gridview during edit mode. In fact I have a date field, during edit mode, the date will be in a textbox, beside the textbox is an image button. For what I need is if user click on the button, it will popup a calendar. After user selected the date, then calendar will automatic close. And that selected date will be place into the textbox. So, how do I get control to the image button which is in edititemtemplate? Is anyone can help me!! Calvin

Hi, This is my first time to handle ASP.NET Web Applications after being drown into Windows Application for months :p. Currently, I have read about XCOPY, Publishing, Web Setup Project, Web Deployment Project and manual installation. I want to know what's the best solution to implement patching Web Apps. That is to the least possible to 0 downtime. I have read about this Application State that dies if I'm going to rewrite a dll that is running, can someone elaborate more about this? Please point me to the right direction. In short, I want to implement a `plug-n-play` architecture. Is it possible? Thanks.

Is it not possible to retreive session variables created in a Sub in a Public Shared Function? I get the following error message: "BC30369: Cannot refer to an instance member of a class from within a shared method or shared member initializer without an explicit instance of the class". I underlined the code where the error occurrs. Here's the code: Sub GetLoggedInUser() Dim userID As String Dim strFullName As String strFullName = User.Identity.Name 'Get just the corpId (remove the domain info) userID = strFullName.Substring(strFullName.IndexOf("\", 0) + 1) Session("sUserId") = userID End Sub Public Shared …

Hello everyone. How can I get DX9 to render into a picturebox on a forum? Will this cause a slow down, and should I be using the whole window? The reason why I ask is becuase I need a chatbox which lines can easily be added and has support for different colors per line. So I find it easier to use Forms and use RichTextBox becuase I wouldn't know how to code an entire UI system in DX9. Also, I could use some good DX9 and C# tutorials. Thanks!

Second week at my new job and looking at the DB :) 1.They have made every field either char or numeric or created user-defined database type. Read about the diff between char and varchar:Char being faster and it's used for "fixed length" if it's less than 30 bytes. Varchar used for "variable length". 2. They have made ALL char fields NOT NULL with default value of BLANK. Questions 1. Still not sure what variable length and fixed length mean. How would I know if the data is less than 30 bytes? 2. Is there a downside to making everything NOT Null and having default of blank?

Hi, I try to use gridview with objectdatasource to obtain the images from the sql database. Within the database, a datafield is declare as "image" datatype. Now in my gridview, it doesn't show me the image instead of showing me a text "System.Byte[]" May I know how to solve it. What column I should use for the image? ImageField, TemplateField, Bound Field? Please help me!!! Calvin

Hi, I am using objectdatasource as datasource in page. I use the "File Upload" control to get the image and save to database. Within the database table, there are a lot of datafield. I got the problem of setting the parameter value for the image. I use three datafield to store the image relevant data. Datafield DataType 1. imgName (nvarchar 50) 2. imgData (Image) 3. imgType (nvarchar 50) Try Dim imgName As String Dim imgContentType As String Dim imgLen As Int32 Dim imgbin() As Byte If Me.FileUpload.HasFile = True Then If Me.FileUpload.PostedFile.FileName.Trim.Length > 0 And Me.FileUpload.Post…

Network admins at my company did something...took away privileges and add others and now my report interface no longer is able to read the user accessing the reports. This is important because there is code that is dependent upon the user that logs in. I need help trying to figure out what went wrong so I can fix it because they don't think they did anything wrong. Where do I start? User.Identity.Name used to return the username logging into the application. Now it returns nothing, so certain users are unable to access their special reports. Help?!?! :confused:

I'm at a new job and looking at their app... Last application I worked with was an internal application to the company that was developed for us by a vendor. They used windows authentication: There was table with userNames in them..one field was the "windows usename" that the users would type in. So when the app was launched, the windows login was checked against that field. And if I remember correctly, the database had a LOGIN user that was used in the web.config to connect to the database. Current app I'm looking at is not fully developed yet but in the database, I can see login names. This app is NOT an internal application...it will be sold to potential clie…