I am using an INSERT INTO statement and one of my database variables is a varchar(51). Can a string be directly stored as a varchar or do I need to convert this to something else beforehand?
View 1 Replies
I have an ASP.Net form, where it grabs a value from a textbox:
[Code]...
I got the dates stored as varchar(100). I need to get them sorted when I use these records but I can't now because they are not stored as datetime. Is there any other way to sort dates or if somebody know would I loose my data if I would try to convert the column from varchar(100) to datetime now as it holds my dates or maybe it would convert ok?
View 33 RepliesI'm trying to insert a string that contains a comma into a varchar in vb.net. How do I make the insert statement I'm building understand that I want "X,Y" to be in the varchar and not X in the varchar and Y in the next column?
View 1 RepliesI'm pulling records from a db table (sybase) where I have run into a problem with a long varchar field. Using the OLEdb class I convert the field into a string variable which works fine in most cases, but there are problem with a few records. Examining the field in the database it shows that the value is not null, but the length of the field is 0.(SELECT field, length(field) FROM table). When I try to convert this into a string the result is rubbish.strContent = objReader.Item(i). I can't figure out what's the problem here, so I have avoided the issue by doing a table update before I start the process of getting data (I set the field value to null if field.length = 0
View 3 RepliesAfter having some trouble in my own code using String.Split and the Split(String(), Int32, StringSplitOptions) overload, I decided to look to the MSDN.I copied the entire VB.NET code example from this link: url...I placed it in a new class, and received the following errors (same errors as my own code example):[code]Why can my code not recogognize the string() parameter overloads to String.Split? Remember, i took the code from the MSDN link above, copied and pasted and it still did not work.I am counting on using the string() instead of char() overloads shown here: url...
View 15 RepliesI tried so many times to convert this to DO UNTIL LOOP unfortunately it does not work properly can you help me?
Heres: the code
CODE:
I want to let a Visual Basic 2005 project be edited on Visual Studio 2010 Without Conversion is that possible?
if there is a way to convert the solution back to work with Visual basic 2005.
I used site to convert from C# to VB but converted code doesn't work. Can some one to convert that code to VB 2008.
private void TreeViewItem_Selected(object sender, RoutedEventArgs e)
{
ExpandToItem(sender as TreeViewItem);
}
void ExpandToItem(TreeViewItem i)
[Code]...
I'd like to convert a string which contains a decimal number into string that contains the binary value, the octal and the hexadecimal value of that decimal number.Afterwards I also like to convert a string containing a binary, octal and hexd. number into a decimal string.Basically I'm looking for the functions:
dec2bin
dec2oct
dec2hex
bin2dec
oct2dec
hex2dec
I'd not prefer to rewrite a function, I'm sure the framework must have these functions already.
I need to convert the following code to work in a visual studio 2008 windows form application, the moment ObjectQuery, ManagementObjectSearcher, ManagementObject and ManagementObjectCollection are not valid.
im objectQuery As New ObjectQuery("SELECT * FROM Win32_NetworkAdapter WHERE NetConnectionId IS NOT NULL")
Dim searcher As New ManagementObjectSearcher(Scope, objectQuery)
[code].....
Whats the best way to convert a list(of string) to a string with the values seperated by ,
View 3 RepliesIs there any way to convert null terminated string to normal string.I mean I can easily make a program to find the location of vbnull but there has to be a built in function for that.
View 1 RepliesI need to convert a string array into a very long string with following requirement:
can not using any character escaping can not using XML can not using single character as separator (e.g. comma or space as separator)
how can i convert these datatypes: date to string and integer to string.Because it must be in a string datatype when I display it in a datetimepicker and textbox.
View 3 Replieshow I can convert an RTF String to a regulat text string. The rtf string has tons of formatting info, but all I need is the text in the string.
View 5 RepliesCurrently, I'm using the following code to pull info from the management class.
[code]...
I'm also pulling info from the bios, disk drives, video, etc. What I've noticed, is although it runs fine on my pc, it may error out on some pcs since it is hardware dependent.I'm having trouble implementing a check to find if it exists before I convert to a string and add it to my overall string.
I'm trying to execute a MySQLCommand like so[code]...
It seems to be something to do with the "size" parameter, but I don't see what is wrong with it.
How can i increment varchar in vb.net 2010?.
[code]...
I have a textbox where I can enter a number. If the number exists in my sql database then it would change the label accordingly. It seems to work with any input number except for numbers starting with zero. If I input a number starting with zero(012345678) I get the error: Arithmetic Overflow error converting varchar to data type numeric.
Imports System.Data.SqlClient
Public Class ValidateForm
Private Sub MineralCloseButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MineralCloseButton.Click
[Code]......
I need to Dim lblFilePath. As what do I Dim it, String dos not work. This might not makes sence to you,
[Code]....
I have following code snippet that is supposed to replace the existing text in a local text file but instead it's just appending the new values on top of the file and pushes the older text down.
Here is the code:
dim sr as streamreader = file.opentext(path)
dim contents as string = sr.Readtoend()
sr.close()
Dim sw as streamwriter = file.Createtext(Path)
sw.Write(contents.replace("old value1", "new value")
sw.Write(contents.replace("old value2", string.empty)
sw.close()
What do I need to change to make it replace existing text rather than append?
I am trying to create stored procedure that gone return varchar value, and that value I need to display in textbox. This is the code for stored procedure:
[Code]...
im making this simple app and i want to know
Let the user add collums?
let the user remove collums?
let the user delete rows?
how to change the the varchar of a row?
how to save the data of the varchar in the settings?
how do i search a varchar field in a sql database and get rid of the char unless it is an number 0 thru 9 and then add that number to the monthly calendar todays date to determine a due date?
View 4 RepliesMy mssql database:
id(int)
dt(varchar)
txt(varchar)
i stored dates on dt column as varchar. How to i select data by datetimepicker like:select * from table where date='"+datetimepicker.value+"'
this piece of code works fine....
Private Sub save()
Dim con As New SqlClient.SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=D:Chuttu VBProjectsLICLIC.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True")[code]......
NOTE: I get no errors.
I need to check if a label starts with a certain text, but it wont work!Here is the code I have:
Dim str1 As String = Label1.Text
Dim value As String = "abc123"
If str1.StartsWith(value) Then
'do something
end if
May I also add that the label i'm checking (the text inside it) has no spaces, i don't know if that makes any difference.
I'm trying to concatenate two properties into one string like so:
public class thing
public property word() as string()
public property count() as integer()
[Code]....
This is what I want, but it doesn't help that its in the debug output...I need to put it into a single string. I've tried using a_thing.count(i).tostring, but it doesnt work. If I look at the arrays individually, they have exactly the contents I want. But I can't concatenate them. Does it have something to do with suppressing the new line that debug.writeline usually creates?
I currently have the following GridView TemplateField:
[Code]...
