attaching filesI am using VB2005 and MS access as a database.I have created a project where a user can add a new record and sometimes with adding the new record you also need to add backup, example a picture,excel, word, txt,pdf.I need to know how to do this?It can be save either on a folder on a local drive or database.I would like to be able to select a file and save it, and if
View 2 RepliesI am attaching DBs using following code.
Dim conn As New SqlConnection("Server=MyHomeServerSQLExpress;Database=master;Integrated Security=SSPI")
Dim cmd As New SqlCommand("", conn)
cmd.CommandText = "CREATE DATABASE dbNoPWD ON ( FILENAME = 'd:dbNoPWD.mdf' ), ( FILENAME = 'd:dbNoPWD_log.ldf' ) FOR ATTACH"
conn.Open()
cmd.ExecuteNonQuery()
cmd.Dispose()
conn.Dispose()
I do not want to give any username and password. When I ran the above code and then checked SSMS, I found my attach DB was not checked in Roles (pls. see pic.) The problem with this is my network computers can not access this DB. I want to run some code like above (without sa password) and want that all my network computers can access the DB without my user get involved in setting up SSMS.
I am trying to write code to send a mail message with an attached file.my code works fine if I don't try to attach a file but crashes when I do. I have not been able to figure this out.[code]
View 2 RepliesI have a project that I am doing which is as follows and need your help to complete the last section I can start word no problem with process.start("winword.exe")the problem is the attachment I attached the documents using project resources and then add exisiting text files and attach it to the project but when I debug I get the following error the code used is as follows
Process.Start(My.Resources.Results
How to attach any type of file in VB.NET.I want information or if possible code to attach any type of file in VB.NET.
View 4 RepliesI have to attach an excel file to a MSSQL 2005 database, using a project written in VB.NET 2005.
View 1 RepliesI am having a problem on setting the SQL CE table column a field type. What field type does a column that only accepts only two inputs..
Example: If a table has a column named Gender..it should only accepts two types of input...like Make or Female.
Is there a way to make the textbox stop typing when a user types numbers? I don't want an error message, I'd just like the user to be able to insert 10 numbers and then it shouldn't add any newly typed numbers.[code]....
View 1 RepliesI have a class with a Property called 'Value' which is of type Object.Value can be of any type, a structure, a class, an array, IList etc.My problem is with the setter and determining whether the value has changed or not.This is simple enough for value types, but reference types and lists present a problem.For a class, would you assume that the Equals method has been implemented correctly, or just assume that the value has changed every time the setter is called?If I did assume it's changed, then perhaps I should assume it for value types as well, so that the behaviour is consistent.
View 2 RepliesI always saw there are files which like frmXXX.vb and frmXXX.resx etc.What types of these file and how to create them?
View 6 RepliesHow to retrieve file icons associated with the file types and add them with the items of Listview in vb.net
i read about SHGetFileInfo but i didnt understand anything from that
how to loop through a zip file and return all the file extensions in the zipped file.
View 2 RepliesI have gotten my application to open with an associated file type, but now I'm trying to figure out how to associate the file types to the app. I associated them on my PC manually by right clicking on a file and selecting "Open With.." and check-marking "Always use this application to open this file type".What I want to do, is have my program make itself the default application for a file type with the press of a button.If it makes it easier, I'm writing a text editor and want to give the users the option of making it the default text editor for .txt &/or .rtf files.
View 1 RepliesI am currently working on a document manager type application in vb 2008.
I want to be able to open and preview different file types in the app in addition to being able to open them with their associated programs.
Is it possible to create a universal file opener that will open and display any file type (and if so how do I do it) or do I have to write a separate file opener for each different file type I wish to support?
Associate .hwm File Types With Program?
View 3 Replieshow I could remove certain file extensions or file types from a populated listbox?I have listbox1 and I want to remove .rar files,.zip files and .txt files.How could I do so in one easy step?
View 7 RepliesI am not sure I am doing this correctly,I want to get a multiple number of file types (gif, jpg, png, etc.) and store them in one variable so I can access all the files in that var. I read that GetFiles doesn't allow for multiple patters, so how do I do this so I can have more than one file type in a variable?
Dim aryFiGif As FileInfo() = di.GetFiles("*.gif")
Dim aryFiJpg As FileInfo() = di.GetFiles("*.jpg")
Dim aryFiPng As FileInfo() = di.GetFiles("*.png")
Is there a way to check if certain file extensions exist within a directory?
View 2 RepliesI am trying to add mime types to a godaddy hosting account that uses IIS7.0. Every time I add the mime types, though, it crashes my web site. Here is the config file without the connection strings to the DB:
<?xml version="1.0"?>
<configuration>
<configSections>
[code]....
I have a web browser I'm using in my VB.net form to which I drag *.CTB files. At present I can drag any file type into the browser can I limit this to CTB file extensions only and if the user ties to drag in any other extension that a message box appears quoting that the file must be ctb extension?
View 1 RepliesI have a question (suppose to be simple). The question related to reading text file which is in the below format.
[Code]....
What I want here is to store the first data column in the file to be stored in AreasString and 2nd column in Level, 3rd in Importance and so on untill the end of the data. In addition, How can I check the type of data? For example, if I want to say: If 10.25 is double then msgbox ("it is double") else msgbox ("it is integer")
I am developing a desktop application in VB.NET 2005. I have a requirement whereby a user need to select a .txt file from his machine (client) and after clicking the save button, i need this file to be saved in the server into a specific folder. Similarly, i should be able to retrieve the file as well.
View 3 RepliesI am using following code to attach my database to SQL Server. The problem is if I create a new file and attach it through my code but when I detach the file using SSMS and again run the same code, it gives error. [code] All the permissions are the same even first time.Also what should be the connection string if I need to use DB with uid sa and pwd abc123?
View 1 RepliesI don't know if I am asking the question correctly, but I want to keep a program I use all the time in memory (running).So instead of closing the program (main form), I would like to simply set it's visible =false. This is easily done and works.Then on restart (I already know how to check to see if it is running) I would like to attach to it and make that running version's main form be visible again.
View 5 RepliesYes how would i make a program that auto clicks "new thread" and types in what are u put in textbox2 and then clicks sumbmit..Why I want to no:+ iM just trying to make a a program that makes it easyer to post.About the program Im trying to make: +im gonna have a webbroswer in my program and then i want then below there wil be a the thread auto click ...so day if i go to www.urlhere.com and go to there forum page i would jsut type everything in my auto clicker and i press button1 it will do everything for me like post the thread
View 2 RepliesI need to compare two dictionary values if the types stored are equal, this is what i have
if gettype(Args(key)) = gettype(argtypes(key)) then
'' do something
end if
[Code]....
Just after installing my application, I need to attach my DB to SQL server. I am using following code for it.
Dim cmd As New SqlCommand()
Dim vrMyConString As String = "Data Source=.SQLExpress; INITIAL CATALOG=master; uid=sa; pwd=sa;"
Dim conn As System.Data.SqlClient.SqlConnection = New SqlConnection(vrMyConString)
cmd.CommandText = "sp_attach_db 'e:dbTest.mdf', 'e:dbTest.ldf'"
' conn.ConnectionString = "Data Source=.SQLExpress; INITIAL CATALOG=master; uid=sa; pwd=sa;"
conn.Open()
[Code]...
It returns an error:"Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection."
I already made a .VB project using MVS 2010,I'm new in attaching database to SQL server and I'm confused attaching which database I'm going to attach because in the same folder i found that there's two
View 2 RepliesJust after installing my application, I need to attach my DB to SQL server. I am using following code for it.[code]It returns an error: "Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection."
View 11 RepliesI've written a simple program for viewing images. My issue is how someone would view these images If I deployed my project to a client. To display the images, I have an Access 2007 database with the full path written for each and the program reads the full path into the Picturebox.ImageLocation property. I've also stored the full, root, and relative paths in the database as separate fields. My issue is how to add these pictures to my project. and which project to add them to.
Do I add them to the main project with my forms?Do I add them to the installer/setup-wizard Project?Should I all the files individually or as a compressed .zip file? Additionally, I don't know how to point to these files once they're installed on a different machine/network. Do I write a different root path to the database when the program is installed somehow?