I have a combobox that pulls a list of values from a database. When a new entry is entered I want an entry in the combobox to read "New record". However, from what I have seen I can only insert and object, such as a DataRow, into the combobox. Is there anyway I can convert a string to to a DataRow, or some other object and insert it in to the combobox? I know there is I am just rusty on my vb.
View 3 Repliessetting a DataRowView equal to my DataGridViewRow.DataBoundItem, then using the DataRowView.Row property (In my code below).
Here's my code:
Dim tblTemp As New DataTable()
Dim row As Windows.Forms.DataGridViewRow
Dim rowView As DataRowView
[code]....
I have a DataGridView that is bound to a DataTable thru the code. I want to be able to modify the data when a row is selected from the Grid. How do I reference that row of data from the grid so I can convert it into the DataTable row to be updated? I'm trying to do something like this:
Dim row as DataGridViewRow = DirectCast(dgvAddress.CurrentRow, DataRow)
This isn't working. I'm getting an error basically stating that I can't convert a DataGridViewRow into a System.Data.DataRow.
[code].....
I've been at this for an hour, but I can't seem to format a string as a percent while I am looping through a datatable. The string value that is being passed in is "3.22"
Public Function securityDt() As DataTable
Dim secMasterDt As New clsDataSecurity
Dim dt As New DataTable
dt = secMasterDt.getSecurityMasters()
For Each row As DataRow In dt.Rows
[Code] .....
I have a project that I am creating a string based on a hierarchy. Without going too much into the logic, I am sure the IF THEN logic works.I have a master control table that contains a 4 number hierarchy sequence for each row. I need to loop through the control table to know how the string should look, and start a new string if the F_ID are different. I am using a For loop to index the control table and loop through it building the string as I go, based on the sequence. I am just concerned if I am referencing the previous datarow value with the .Item Overload option in the IF THEN statements correctly, and appending the stringbuilder variable using the composite primary keys properly.
The four tables example
FTable
F_ID F_Col
1 fffffff
[code]....
I am looping through the rows of a DataRowCollection and assigning the fields of each row to a variable. I always get "Input string was not in a correct format" no matter how I cast this. I just need gapCd to contain 0 if the field is null or the value otherwise. It seems the IsDbNull is not returning true properly. I've also tried DbNull.Value comparisons with no l
View 1 RepliesI'm having a problem converting a string of letters to a string of numbers. I've tried:
Dim A As String = ""
Dim strOutput As String = ""
Dim X As Integer = 0
[Code].....
I have two datatables with similar structures that I want to make one existing row to be updated from another datatable.
For example, "tableA" has three columns: "one", "two", and "three"; with "one" being the primary key...
and "tableB" has three columns as well: "one", "two", and "three"; with "one" being the primary key.
Say there is a row on tableA that is different than a row on tableB (with a matching primary key). What I wanted to do, as efficiently as possible, is to take the that row from tableB and replace the one on tableA so it'll be modified.
I'm not sure if there's an easier way of doing that instead of using loops for setting the row's items.
I'm trying to solve a problem regarding types of list. First of all I have a stored procedure in my DB which does a select of a single column and I try to proceed it in my app in VB. By making a method function I declared a DataTable that loads through the SqlCommand(with the CloseConnection behavior). After that I publicly declared a List(Of String) which needs to be populated with the rows/items from the stored procedure that is on the way. Below is my snippet of the code:
Dim dt As New DataTable()
Try
If conn.State = ConnectionState.Open Then
[Code]....
It's LPrefix = collection.Cast(Of String)() where I get an exception error telling me that I can't really convert it. The old fashion way is to iterate with for/for each loop but that's not what I want for best use of performance especially if the list will have thousands of rows from a single column. So basically, I want to insert those items from that DataTable to the List(Of String) without For/For Each loop.
Running on VisualStudio2010 Ultimate, .NET FrameWork 4.0.
i am converting a string to double?i would like to know in advanced whether it would case an error to convert a string to a double. for example if i try to convert "hello" to a double, it would give me an error. is there a way for me to know ahead of time whether converting something will cause an error?
View 2 Replieshow to convert a number value to its string value (ie.,1198.00 should be interpreted as Thousand Hundred and ninety eight)
View 2 RepliesI am returning one row from the database, and I want to convert the SQLDataReader to a string format, so I can pass it to my webservice.
Dim rdr As SqlDataReader = sqlcmd.ExecuteReader
If rdr.HasRows Then
rdr.Read()
[Code].....
There is a lot on the internet about converting a int to base 2 string, but I need to convert it back.
[code...]
I have made calculator in visual basic that can calculate the costs of products. You first select the type of product. Then you insert the dimensions. After that it calculates de costs. The type op products are stored in a Access database. In this database is stored a formula as a string. The problem is that i can't caculate the selected string with the formula and the given dimensions.
View 10 RepliesI am trying to convert a string of binary into hex. I have tried several ways and none have worked. This is my latest try. The code runs but doesn't appear to do anything.
[Code]...
I am using the .NET Framework 2.0, and I am trying to code a client bot for a game called Minecraft, Originally written in Java, there have been quite a few people who have made custom multi-player servers for this game, Primarily in C#, or in a language that i've never heard of, such as Pascal.I'm looking right now at sending this:
Packet ID: 0x00 (0) As Byte
Protocol Version: 0x07(7) As byte
Username: "umby25" As String
[code].....
"Byte cannot be converted to 1-Dimensional array of byte"
I don't understand why this whole thing would work in all of the other programming languages, but not Visual basic.I have tried converting the string using the same method that one of the open source C# servers used, and it failed, telling me that the dictionary does not contain that or something.
I am having trouble converting a string value to a text box name.The text boxes are created at runtime and I need to get the text value out so I can store them. I keep getting the error [code]
View 5 RepliesHow can I convert a string into an array?
The values are passed as a string:
Dim strInput as string
strInput = "Tom, John, Jason, Mike"
My error message is: Value of type 'String' cannot be converted to 'System.Array'
I was trying to figure out how to convert a string (that the user would input to the program via a textbox) into actual code for the program to compile. For example, if the user was to enter: (5*100)+(20-3). How could you take that inputted string, and have the program solve it and return the value?
View 3 RepliesI'm using AxVLC to try to play a video from my.resources and I can't seem to convert the binary to a string for it to work...This is what I have so far - produces no errors, or results (nothing happens).
Private
Sub
Button1_Click(ByVal
sender As
[code]....
I'm trying to convert a chosen color into hex base 6 to save to a config file for later use, and that part works, but when converting back to integer to use for a color, it gives me an error about incorrect base.
Dim hex_color = System.Drawing.ColorTranslator.ToOle(ColorDialog1.Color).ToString("X6")
Dim color_int As Integer = Convert.ToInt32(hex_color, 6)
Panel1.BackColor = System.Drawing.ColorTranslator.FromOle(color_int)
The message does not appear if a number is not entered - why?
Dim
IAL As Double
Dim inputIAL As Double
[Code].....
I was trying to convert from Double to String and everything working fine. But when I tried some bigger number with fractions in it. I got the number but rounded. I tried something like that:
Dim dd As Double = 1235212435.3453636
Dim str As String = dd
MsgBox(str)
But what I got is 1235212435.34536 instead of 1235212435.3453636
I am writing a tic-tac-toe game. The part of the code that I am having trouble with is randomly populating an "O" if the computer cannot win or block.
The code I have is;
Dim square As Integer = 6
Dim middle As Object = "grid" & square
Dim grid As Label
[Code]....
Unable to cast object of type 'System.String' to type 'System.Windows.Forms.Label'
I've got a richtextbox but want to check the keypresses before they come in the textbox. So I thought of using the KeyPress event from the form, checking that key and than writing it to the richtextbox with the Text property.But the KeyChar is a char while the Text property expects a string, and when I convert the KeyChar to a string(ToString) it gives a error.Does anyone know how to fix this or has anyone another idea for checking the presses before writing them?
View 4 RepliesHow to convert a md5 string value to number?
View 1 RepliesFirst: Ok so I'm trying to do a project in my beginning VB .Net class. We are supposed to be taking information from 5 different sections of a form and store them into an array and then call upon them later. We have Name, Address, City,State, and Zip. How would I go about saving the information into an array and then calling upon it later through File IO?
Second: I'm having a problem converting my string into a decimal. Whenever I calculate the price of the order I get 3-4 decimal places. Here is a little snippet of my code for the this:
[code]...
I have dimmed pricewithout tax as a decimal and stateselect as a string. The stateselect is based off a drop down list.
I have the following string:
20111209
How do I turn this into a DateTime Value? I've tried Convert.ToDateTime(s) normally but it keeps yelling that I'm doing things wrong because the string doesn't look like a datetime value.
I've been up for nearly 24 hours now. Trying to program an application for a game I have been playing.I've run in to a problem, I'm not sure how to solve.I have basic knowledge when it comes to VB (college class) so bare with me.[code]My only Idea would be loops to figure out where each of the edited numbers are in the array, But I was looking for something simple.Also, would it be easier to work with the bytes rather than edit them in string form?
View 4 RepliesCan someone please tell me how I would convert a string of "Thu Dec 13 10:00:06 2007" to an actual date?
View 6 Replies