467 Posted Topics
 | You can do it. How far have you gone? Please, post your codes. Collect the RowIndex from orderline form DataGridView and nevigate to the Second Form Product DataGridView to pick the values from appropriate row matched by the eariler RowIndex.  |
 | You can do it by retriving the listindex value of that particular text, which you tried to select by default. Make a function to get the SelectedIndex. It should be like Privat Function CheckIndex(ByVal key As String) As Integer Dim Result As Integer = -1 For i As Integer = … |
 | At the time of creating your project define the location of your project in New Project Window. If you check the **create Directory for Solution**, it automatically creates a folder at the location of your project. the name would be as same as solution name. I which your project should … |
| | You use here the **contains** method to detect the end line of the file. But it can remove all lines which contain the keyword **"End of Report"**. **For example:** suppose there is a line like **"The rules and regulations are described at the End of Report"** in the middle of … |
| | You can do it. Your codes are quite correct. But, why are you going through a loop? It will slow down your process. Use **FindFirst** method to get quick result. |
| | > I want to accomplish this without using a combo box. @Triple_7 doesn't want to use combobox. It is in his posting.  |
| | You can give your project a meaningfull name at the time when you have tried to create a New Project. you can also specify the location to save your project in your desired Drive and Subfolder. VB tries to create a folder of the name same as your project name …  |
| | |
| | @imti321: You have forgotten to pass argument value for **append As Boolean** in your last line > My.Computer.FileSystem.WriteAllText("C:\Restran Conversion\somefile.txt", "Some text") and it can raise an exception. The codes should be If Not System.IO.File.Exists("C:\Restran Conversion\somefile.txt") Then System.IO.File.Create("C:\Restran Conversion\somefile.txt") End If My.Computer.FileSystem.WriteAllText("C:\Restran Conversion\somefile.txt", "Some text", False) 2. At run time the … |
 | Connection string should be like "mysql:host = $this->db_host; dbname= $this->db_name; $this->user; $this->pass;"); |
| | How do we understand, where from does your exception come and why? Please post your codes and exception |
| | You can do it by making a sub procedure. The code structure should be like Public sub ClearControls(ByVal FName as Form) 'Do your jobs here End Sub |
 | Your problem is in this section. >'Scroll through all items in a listbox >Dim itemText As String = Lb.ToString 'Get item string >If itemText.Contains("C:\Users\David\Documents\My >Documents\Computer Programs\David\KOAGCS") Then 'Check to see if item has our >search var >open = 1 >End If >MsgBox(open) You must need some modification. It should be … |
 | 2,260 Contributions (#82) Helped Solve 455 Q&As (#41) 96% Post Quality Score Total Up-Votes Received 384 Posts Receiving Up-Votes 357 Members Who've Up-Voted 203 Total Down-Votes Received 15 Posts Receiving Down-Votes 13 Members Who've Down-Voted 11 601 Reputation Points (#73) 38 Skill & Expertise Endorsements (#36) 16 VB.NET 10 C# …  |
| | @waqasmrd: I like to tell that make your question on distinct problem, what you are facing to get your desred result. Post your codes, how far you did and what result you have got and what you have desired to get. There are too many process to make a query … |
| | Use a database or xml file or a text file to store the number and do the restriction. |
| | Is there any `Add()` method to save data in settings? You can use the following. to save application settings values. My.Settings.MyAppUserName = TextBox1.Text My.Settings.Save() To retrieve TextBox1.Text = My.Settings.MyAppUserName |
| | `Contains()` always returns boolean value. You an use it to match between two strings or to get an bolean value if a substring exists in a string or not. If it exists or match it returns True else False. You can not use it to compare between two numbers. @coolsasuke: … |
| | > When I minimize the program while I've loaded this document, the program gets stuck and it takes quite a while atleast 1 minute(or more sometimes) to maximize back. From my point of view, this a threading problem. Here you are trying to open a text file. So do not … |
| | Store the checked items in an array. After changing the viewtype varify and check them programmatically. The codes should be like Dim x as Integer = 0 For litm As ListViewItem in ListView1.Items For i As Integer = x to UBound(LitmArray) If litm.Text = LitmArray(i) Then litm.Checked = True x … |
| | Show your codes, how far you did. Create a DataConnection to the Excel file and use it as a Database. |
| | DO you have a limited numbers of IDNos? Like only Two Or Three IDNos. If you know you have only one, two or three,,,,,,,ten IDNos, You can do this by above processes by taking textboxes at designtime. But if you do not know how many IDNos you have? How do … |
| | From my ponit of view, the SQL Statement iswritten wrongly. > $query = "UPDATE users SET password='$securepw' WHERE username='$username'"; As per your statement **$securepw** and **$username** behave like a text not a variable. I suppose your statement should be $query = "UPDATE users SET password='" + $securepw + "' WHERE …  |
| | Please try it Select A.Id, B.comment From Post A, (Select Image_Id, COUNT(Total_Comment) As comment From user_comment Group By Image_Id) B Where B.Image_Id = A.Id |
| | There is no distinct question. > Input Validation: Should be used on the test scores to assure they are valid. a negative number or character should not be accepted. only postive whole numbers less than or equal to 100 should be accepted. From the above lines, it can be assumed … |
 | Re: VB10 argumet.. Do your codes in **couesecombobox SelectedIndexChanged Event**. First Clear the items items from yearcombobox then add the items. Private Sub coursecombobox_SelectedIndexChanged(sender As System.Object, e As System.EventArgs) Handles coursecombobox.SelectedIndexChanged yearcombox.Items.Clear() yearcombox.Items.Add("1st Year") yearcombox.Items.Add("2nd Year") If Not coursecombobox.Items(coursecombobox.SelectedIndex) = "IT" Then yearcombox.Items.Add("3rd Year") yearcombox.Items.Add("4th Year") End If End Sub |
| | Obviously, you can attach a Navigator bar for a MySql Database as you already created a bar for an Access database. Process is same. Only you mast load a **MySql Connector for vb** to access mysql database from vb. The type of database system is your choice. Do not understand … |
 | Check the difference between the dates by using DateDiff() function. It should be like If dr.HasRows Then If DateDiff(DateInterval.Day, dr("due_date"), Now()) < 30 Then MsgBox("You have account already due") Else MsgBox("You dont have account due today") End If End If |
 | You can do your loops like For i As Integer = 0 To 255 For j As Integer = 0 To 255 Dim pb As New PictureBox Dim loc As New Point Dim sz As New Size(1, 1) pb.Size = sz pb.BackColor = Color.FromArgb(j, i, layer) loc.X = j + … |
| | Take a Boolean varable before declaring the for loop. Your codes Should be like Dim array as Textbox() = {txt1, txt2, txt3} 'Array of textbox's Dim match As Boolean = False For loop = 0 to 3 If Array(Loop).text = Data_In_Database then 'Do something match = True Endif next If … |
| | Please [read this](https://www.daniweb.com/software-development/vbnet/threads/487130/array-with-20-grades-that-shows-in-a-list-box#post2131293), hope you can get your answare from here |
| | Re: table import You can do it by using SQL Statement. Assume that you have two identical tables. To transfer One's data to another, the SQL statement is as follows Insert Into NewTableName Select * From OldTableName It can transfer all data from OldTable To NewTable. |
| | This codes always run when the Application starts. You have to put the codes in MyApplication Class. You get this Class in ApplicationEvents.vb Class file. There is no need to use a Timer control. Goto Project Properties window -> Application Tab ->Select **Splash** in Splash Screen ComboBox. Now open ApplicationEvents.vb … |
| | Post your codes and exception. |
| | Please, describe the errors/exceptions you get. |
| | Develop your application by using WPF (Windows Presentation Foundation). Start vb.net -> New Project ->WPF Application. |
| | Create the SQL Statement by concatinate the field names, which theuser selected. Dim xStr As String = "Select " For i As Integer = 0 To ListBox1.SelectedItems.Count - 1 xStr &= ListBox1.SelectedItems(i) If i < ListBox1.SelectedItems.Count - 1 Then xStr &= ", " End If Next xStr &= " From … |
| | Why couldn't we use between keyword? Like, `where (table.date_field Between starting_date and CURDATE();` |
| | Inspect the codes to locate where you write codes for showing the forms. The small window is a message box that you call for invalid text in the form info. |
| | What do you mean by > but want to make it to upload data online not to read them online I mean, you want to save data to the database, which resides at server, through TCP Port. **Begginnerdev**, tried to see how you could save data to your database. But, … |
| | In my opinion exception has been raised for shortage of "Space" in SQL Statement. It should be sql = "SELECT Chores.ChoresID, Chores.ChoresDate, Materials.MaterialName, Advisers.AdviserInit, Advisers.AdviserSurname, " _ & "Area.Area, Chores.StudentNo, Student.Forename " _ & "FROM Chores " _ & "INNER JOIN Materials on Materials.MaterialID = Chores.MaterialID " _ & "INNER … |
| | It should be like Dim conn As New System.Data.OleDb.OleDbConnection() conn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\temp\Database1.accdb" If conn.State = ConnectionState.Open Then conn.Close() conn.Open() Dim sql As String = "Select [Project Name] As ProNm From tbl_assignment Where ProjectNo ='" & cbbproject.Items(cbbproject.SelectedIndex) & "'" Dim sqlCom As New System.Data.OleDb.OleDbCommand(sql, conn) sqlCom.Connection = conn Dim sqlReader … |
| | VB6 uses MsAccess 98 version. So, if your Access database version is above than 98, vb6 visual Data Maneger couldn't able to open it. From my point of view, using MsAccess is better way to design the database. You could not modify the data type of a field by VDM. … |
| | To search you can use **ListView1.Items.ContainsKey(key As String)** function. |
| | It should be Clipboard.SetDataObject(Image.FromFile("C:\PICTURE\1.jpg")) objWb.Worksheets("blad1").Range("A3").Select() objWb.Worksheets("blad1").PasteSpecial(Format:="Bitmap", Link:=False, DisplayAsIcon:=False) Suppose it can help you. |
| | > timer one to be switched on when the mouse hoves in that particular circle and turn off when it moves off Has there any HitTest method for a circle or arc drawn on a form or a picturebox, when the mouse hoverring on them? My opinion it may be … |
| | Wrong SQL Statement and syntax for both operation For UpDate it should be Dim sql As String = "UPDATE tbl_datain SET UserName='" & txtname.Text & "' AdminNo ='" & txtadmin.Text & "' [Course Title] ='" & txtcourse.Text & "' [IC No] ='" & txtic.Text & "' Gender ='" & txtgender.Text … |
| | From myself, I will always coose ADODC Type object variable. Though an ADODC DataControl Object and an ADODC Object variable, both do their work same or less equal. In 1st case you never change the path of the Datasource programatically and also some times the recordset can initiate an error … |
| | |
| | In table create a field for right answar. After chooeing option it will compare with the right answar. And if return value =True then score=1 else 0. |
The End.