800 Posted Topics
Re: Do you have a method to connect to the access database? If not, you will have to: 1) Connect to the database (Use [this](http://connectionstrings.com/) for your connection string) 2) Create a new command (Use [this](http://www.daniweb.com/software-development/vbnet/threads/407064/database-code-sample) for a simple guide on connecting to the database.) 3) Execute the command. (Use the … | |
Re: You will have to add them to your project. Look in the toolbox when in design view, you will find PrintDocument under the printing tree. or Add it manually; Imports System.Drawing.Printing .... Dim pd As New PrintDocument | |
Re: You have posted the same question repeatedly about 3 times already. Have you not received the answers you needed on the other posts? | |
Re: For one thing, you can't see if you do have an error. All of your catch's are empty. Try placing: MsgBox(ex.Message) In all of them, it will give you a little bit of an explanation of what happens. Are you allowing the user to select a range of products? If … | |
Re: [Here](http://stackoverflow.com/questions/2479403/stop-the-screen-saver-and-hibernation-temporarily-in-vb-net) is a post on stackOverflow about something related. Maybe it would be a good starting point for you. | |
Re: Reading and writing from/to a text file is a VERY simple procces; You need to define a stream reader/writer Dim sr As New StreamReader("C:/Users/MyUser/Desktop/file.txt") Do While sr.Peek <> -1 Dim curLine as String = sr.ReadLine 'curLine now holds an entire line from the text file, from crlf to crlf' Loop … | |
Re: Are you receiving any errors, or is the database just not getting updated? | |
Re: Are you appending the data that is in memory back out the file? If so you are just adding everything back in again. Example: If you are reading into table > add more to end > post back out = Post all data in table, including data that is already … | |
Re: Do you have any generational specific formatting? Example: Any Excel 2003,2005,2007 formatting that is not compatible with your interopt? | |
Re: You will have to create a custom print method. In this method you will have to loop through the datagridview and parse everything line by line. You will have to pass each line as a String variable. You can use [this](http://www.knowdotnet.com/articles/printgriddemo.html) as a reference. It is a tedious process. One … | |
Re: Have you checked your projects publish settings? You can set publish settings by: Open the Solution > Click "My Project" > Click the Publish Tab | |
Re: Do a string plit, storing the values in a array. Only look for the value at the 1 index. Example: Dim infoString as String = "mister.john#gotodaniweb.com2" Dim ar() as String = infoString.Split("#") 'ar(0) = mister.john' 'ar(1) = gotodaniweb.com2' | |
Re: You will want to do the reverse of what poojavb has posted. Dim dr As Object If e.CloseReason = CloseReason.UserClosing Then dr = MsgBox("Do you want to save the changes?", MsgBoxStyle.YesNo Or MsgBoxStyle.Question) If dr = vbNo Then Me.Dispose() e.Cancel = False Else btnSave(sender,e) Me.Dispose() e.Cancel = False End If … | |
Re: You can do as poojavb has stated, but if you are using this textbox for input in a database, you will have to be sure that the user can't submit the changes when the textbox is empty (contains default mask) or it will blow up. | |
Re: Possible duplicate of [this?](http://www.daniweb.com/software-development/vbnet/threads/423128/is-it-possible-to-show-only-particular-records-in-gridview-with-the-followi) | |
Re: Are you wanting a data monitor for network activity and bandwidth? Your question is a bit vague, and is not very legible. Can you please give us a little bit more information...and possibly better typing? If you can't convey your point in english you can always type into a translator … | |
Re: Example: Dim Conn as New OledbConnection(ConStr) con.Open() Dim Save as New OledbCommand("INSERT INTO Client(Nom,Prenom,Adresse,Téléphone,date) VALUES(@p1,@p2,@p3,@p4,@p5)",Conn) 'Add parameters' Save.ExecuteNonQuery() | |
Re: > Dim x As String = dsResult.Tables(0).Rows(0)(0).ToString() Dim x As String = dsResult.Tables(0).Rows(0).Item(0).ToString | |
Re: This does something very close to what you want, try to use this as a reference. Dim j As Integer = CInt(TextBox1.Text) Dim numOfPasses As Integer = j Dim numbers() As String = {"0", "1", "2", "3", "4", "5", "6", "7", "8", "9"} For i = 0 To j Dim … | |
Re: If I understand what you are wanting, you will want do something like this: Private Sub Button2_Click(sender As Object, e As EventArgs) Handles Button2.Click TextBox4.Text = subjectWords(Get_Random(0, subjectWords.Count - 1)) & " " & predicateWords(Get_Random(0, predicateWords.Count - 1)) & " " & _ complementWords(Get_Random(0, complementWords.Count - 1)) & "." End … | |
Re: Please don't hijack dead threads. Please start a thread of your own. Thank you. | |
Re: You have SQL Server 2012 Express (Free from Microsoft's Website) You have Oracle(Some free versions, haven't worked with.) | |
Re: I think what you are meaning to do is. Dim sConnection As String = "Provider=SQLOLEDB;Data Source="XXXX.XXXXX.COM:5000;Initial Catalog=IBMDADB2;Integrated Security=SSPI" Also, you might want to remove the user name and password from your string....This is a public forum, and is open to the unregistered public. At bare minimum, you could have a … | |
Re: We are not here to answer homework, If you have code or any attempt....please post. We can't just do your homework for you, or you would never learn anything. | |
Re: You will need to make use of the Microsoft Office Interopt libraries if you are wanting to manipulate a workbook that is not open. | |
Re: Change the name of resources in one of the .resx file. You will then have to change any references to the old name in the corrosponding source code. Example. My.Resources.Resources to My.Resources.ResFix | |
Re: You will have to post your code, but at a 3,000 ft. glance; you just need to have only one execute statement. | |
Re: It is possible to have security permissons denying writing to the root of a drive. Also, are you getting the data from notepad or something of the sort? | |
Re: Create a connection to the database, using [this](http://www.connectionstrings.com) as a reference. Connect to the database and create/execute a query, storing the values in a table: Dim ConStr As String = "Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;" Dim con As OleDBConnection(ConStr) Dim cmd As OleDBCommand Dim da As New OledbDataAdapter Dim ds As New DataSet Dim … | |
| |
Re: Place a text box on the page (can be hidden) and store the textvalue into the text box/ | |
Re: Access is a single user application, therefore; it is not possible. You might want to look into SQL or MySQL as an alternitave if you are wanting multiple users. | |
Re: What you will need to do is: 1) Loop through the workbook, comparing and storing all values that reference that person. 2) Loop through those values, adding them to the message (body?)** **It may be easier to write the values to a text file and attach the text file to … | |
Re: Do you mean something like this? Try Dim myDir As String = My.Computer.FileSystem.SpecialDirectories.Desktop & "/tmpOldLoc/" Dim toDir As String = My.Computer.FileSystem.SpecialDirectories.Desktop & "/tmpNewLoc/" If Directory.Exists(myDir) = True Then Dim di As New IO.DirectoryInfo(myDir) Dim diar1 As IO.FileInfo() = di.GetFiles() Dim dra As IO.FileInfo For Each dra In diar1 File.Copy(dra.FullName, toDir … | |
Re: You will need to create the sub for the click and then add the handler on runtime. Example: AddHandler RadioButton1.Click, AddressOf RBC Private Sub RBC(sender As Object, e As EventArgs) 'Place code here End Sub | |
Re: One alternative is to place an open file dialog in the project, then allow the user to navigate to the data base. You will: 1) Place the dialog 2) Do some coding to prevent empty paths 3) Store the value from the dialog on the form. 4) Create a backup … | |
Re: I have this feeling that Iamature is begging for homework. As Mitja stated, he has posted the same question, re worded, at least twice. He also PM'ed me, asking for me to code his project for him. I don't mind **helping**, but **doing** the work for someone is a different … | |
Re: [Here](http://social.msdn.microsoft.com/Forums/en-US/vbgeneral/thread/86a1eb3c-d731-4b28-b4ff-0a9d78609c3a) is a good reference I used when I did a small project with USB manipulation. | |
Re: Here is a tiny little recursive sub procedure I have written to do what you are needing it to do. Public Sub PlusOne(int As Integer) If int <= 1000 Then ListBox1.Items.Add("HelloWorld") int += 1 PlusOne(int) End If End Sub Just need to pass 1 in as int when you first … | |
Re: Do you have any code in the form's resize event or any code anywhere that changes their location? Also, is the screen resolution any different when debugging/release? | |
Re: For loops are actualy pretty easy to use. Example: For Each object In Collection Next For Each Control in Me.Controls 'Loops through every control on the form.' Next For i = 0 to Me.Controls.Count Next 'Would be the same as coding' for(i=0;i=Me.Controls.Count;i++) { } Hope this helps. | |
Re: You will have to right a for/each loop for each sub level. Each level is considered it's own collection. Example: For Each i As Control In Me.Controls For Each j As Control In i.Controls For Each k As Control In j.Controls If TypeOf k Is TextBox Then End If Next … ![]() | |
Re: You have actually posted this in the wrong forumn. There ASP.NET form can be found [Here](http://www.daniweb.com/web-development/aspnet/18) | |
Re: You could write a sql statement to instert each one, then place it in a loop. Example: Dim conStr As String = "Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;" Dim con As New SqlConnection(conStr) Dim cmd As SqlCommand Try For i = 0 To ComboBox1.Items.Count con.Open() Dim sqls As String = "INSERT INTO … | |
Re: You could create a boolean check. Example: Dim canExecute As Boolean = False 'From the ComboBox's indexChanged event, do the following:' If ComboBox1.SelectedValue = "A" Then canExecute = True End If 'From the Button's click event, do the following:' If canExecute = True Then 'My Code Here' End If Is … | |
Re: For one thing, > myDa.Fill(mydataset, "Old_info") and > search_data_DataGridView.DataSource = mydataset.Tables("Old_inf0").DefaultView Are refrencing two different tables. You have a zero placed at the end of > search_data_DataGridView.DataSource = mydataset.Tables("Old_inf0").DefaultView | |
Re: Something like this: Dim conStr As String = "Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;" Dim con As New SqlConnection(conStr) Dim cmd As SqlCommand Try Dim myValue As String = "This is a test." con.Open() Dim sqls As String = "INSERT INTO table (column) VALUES ('" & myValue & "')" cmd = New … | |
Re: Is it a possibility you need to instal the mySQL adapter? [Here](http://www.mysql.com/downloads/connector/) are the adapters available. | |
Re: There are a number of ways to do what thines is saying. Are you parseing the data in line by line or the entire file? Are you storing the data in a single string or in an array? | |
Re: Example: Dim sqls As String = "INSERT INTO table (column1) VALUE ('" & DateTimePicker1.Value & "')" |
The End.