I'm tring to retrieve a CustomerID in a string e.g. "12, Lucy, MyName" format "CustomerID, Forename, Surname"
So far I have
Dim String1, String2, String3 As String
Dim position As Integer
String1 = cbSurname.ToString
[Code].....
How do I just get te Customer ID from this as String3?
I am using VBNET2008 and SQL SERVER 2000.I tried to create this SQL string to retrieve CustomerID and a CustomerID and Name together but it's not working.Here are the SQL String that is not working.
Dim strsql As String = ""
strsql &= "Select CustomerID, "
strsql &= " ( CustomerID & " - " & CompanyName ) as [Companyname]"
strsql &= " From TestCustomers Order by CompanyName"
This is the error message"Conversion from string "Select CustomerID, CustomerID & " to type 'Double' is not valid.
Cause by this SQL String coding:
strsql &= " CustomerID & " - " & CompanyName as [Companyname]"
I am using the NORTHWIND DatacBase in SQL SERVER 2000 and the table is Customers
I am using Visual Basic 2010 Professional Edition. I have tried all day to create and add a property to the Windows form frmCard. I need to create a CustomerID which is a system.Guid but it needs to accept a string value from a DataSet and be able to pass it as a system.
View 1 RepliesI have the following code for Customers and their orders. I want to list all the customerID and the corresponding count of orders. How do I achieve it using LINQ? [code]
View 3 Repliesi want to load customerID and customerName in a combo box. ID will be invisible and name will be visible in column using visual basic 2008 for windows application.
View 4 RepliesI get the error Duplicate mapping to column 'CustomerID' in class 'xCustomers' in the following class, but i do not know what am i doing terribly wrong.
Public Class xCustomers
Inherits XPBaseObject
Public Sub New(ByVal session As Session)
[code].....
I have five fields
1.CustomerID
2.BusinessID
3.OfferID
4.Day of Purchase
5.Month Of Purchase
Private Function MakeCouponCode(ByVal sn As Int16) As String
Dim a(16) As Char
Dim chk As Int16
Dim check, tDate, slNo, couponCode As String
[CODE]...
I am using the above code to make a CouponCode...but somehow its not very hard to crack...Any idea how can i make a bullet proof coupon code in not more than 16 digits?
generating unique ids for invoices,customerids and employee ids, etc. and thought it would be great to share this as i will use it within my aps all the time now.[code]
View 7 RepliesBy using the below code i can able to number but cant able to get the string..In sqlsever i declared product_name and its data type as nchar(10)..while running this code the error appeared is MAKE SURE THE MAXIMUM INDEX ON LST IS LESS THEN THE LIST SIZE[code]...
View 3 RepliesI have several values in a column like: [code]I would like to retrieve only the values (I mean without KB, Bytes..etc).How can I do that?
View 13 RepliesHow can I retrieve values/string from my database using code?
View 1 RepliesI got this DLL functions explained in C++ as below :Void GetResultData(int pIndex,char pStrData[100][255], double pDoubleData[100])
View 2 RepliesI have the following code to retrieve a string value from the registry.
Dim retval As String = String.Empty
Try
objManagementBaseObject = objManagementClass.GetMethodParameters("GetStringValue")
[Code]...
The problem is that if sValue doesn't exist, it generates a ManagementException. I want those errors ignored because I don't care if the value doesn't exist, it's entirely possible and acceptable. How can I "accept" those errors but display all others?
On my website I got a page that generates a random word... now I want to fetch that word and store it in my vb application.
How can I fetch the desired word and store it in let's say text3.text ?
In my application I have many different forms each use 3 different database. And right now I am placing the connection string in each form but when it is need to change I have to change in every form. Now what I want to store all connection string in a vb class and call them in every form. So that if I need to change I can do in that class. I have stored my connection string in database so even I don't want to connect to database again and again. I have some idea in which maybe a public class is used and some how I will call it on other forms.
View 2 RepliesJust like the title says; I want to use something like Mid(stringName, startIndex,[integerLength]), but instead of the third argument taking a string length, I want it to take the end character index. So in an example like this:
alphabet = "ABCDEFG"
partial = *method I want to use*(alphabet, 2, 4) 'partial would equal "BC"
i am retrieving a iMAGE Extension variable string. for example: test.case-function.two.jpg and want to return the end '.JPG' portion only. so i can add to another variable value. Note the .JPG substring could be other Extension types such as PJPEG ect
View 1 RepliesBasically I want to retrieve all possible substring matches with n characters from a string, Here's my initial code but it only returns 2 matches.[code]...
View 3 RepliesI have this question about how to retrieve a column with DateTime from MySQL as String and put the data in a textbox. [code]I want to use this to cross reference with other table in other database, but to do that i need to copy the data into a textbox as string or a datetimepicker as datetime.
View 2 RepliesI'm writing a small tool that requires me to take a string as input, search it in a txt file & return the whole line on which the string occurs,..for eg. let's say my text file has line # 5 as : "TEMP-This is a test line" now if i give "TEMP" or "test" as input is want my code to chk evry line in the text file & return the entire line where the string is found...
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim FileName, FindStr As String
Dim objReader As New StreamReader("c:MyFile.txt")
[code]....
I am trying to populate an array with all the unique values in a string, to prevent me ReDim'ing an array every time I find a value that not already contained in the array I am trying to create (consumes alot of time), I am trying to get the unique values first so I only have to ReDim once and after that I can simply iterate through the string and the array I have will be the correct size for the unique values I aquire (I am using this...)
[Code]...
I have a datatable with one column, I am trying to retrieve the values in the table into a string array using linq.
Dim dt As DataTable = DataAccessManager.ExecuteSelectQuery(selectStr).Tables(0)
Dim strArr() As String = (From dr As DataRow In dt.AsEnumerable.AsQueryable _
Select dr("MASTERID").ToString()).ToArray()
I get an error "Range variable cannot match name of a member of the 'Object' class"
I have a connection string in my database which I read throughout my VB .Net application. I have another string which is NOT a connection string though. It instead has information about a domain on LDAP. So LDAP string just needs to be stored in the web.config as a string, and also to be retrieved as a string.
[Code]...
I do encounter interest problem when I am using VBNet2008 and SQL Server 2000. I am developing Window Application and one of the form I am using SQL String with Date between to retrieve specific data from SQL SERVER 2000 Table and it's not working and generated this error message:
Invalid column name strFromDate
Invalid column name strToDate
Here are the overall coding:
Dim sqlconn As SqlConnection
Dim sqlcmd As SqlCommand
Dim DA As SqlDataAdapter
Dim DR As SqlDataReader
[Code] .....
I have a textbox AND 3 checkboxes; checkbox1, checkbox2, checkbox3
In textbox we have 1,2,3
If I type in textbox1 = 1,2 then
checkbox1 and checkbox2 will be checked and checkbox3 will remain unchecked.....
How to do this in vb.net
Part of my project is to retrieve a string variable from an external source (google docs) and parse it. This string represents width and height. I have no problem retrieving, I just need to parse it in to two strings. The string has 4 variations.
Here are examples:
3"x4"
3"hx4"w
3hx4w
3x4
The width is always the first number and the height is always the second. Sometimes, the width and height have decimal points. Any way to parse this into two strings of the numeric values only?
I am trying to create a program that is able to submit post data for the page [URL] where it submits the request fields and then the resulting page is receiving in a string.
View 2 RepliesI am after some simple code to retrieve a txt file of a server (http) and store it in a string.
I have had a look around, but non luck.
I am using VB2010 on Windows 7
I'm trying to retrieve a string from within another string. My code doesn't give me any errors and I can't figure this out at all.
The client side app is receiving a delimiter based string in this format.
username-action-coordinatesX-coordinatesY-ID
Here is part of the code that I use to retrieve data coming in. I can retrieve "avmove" but for some reason I can't retrieve adata(2) or adata(3). I've tried using another select case statement after "avmove" and an If statement. But, like I said I can't do it. Case "www" works and so does Case "chat".
Public Sub UpdateHistory(ByVal str As String)
Dim aData As String() = Nothing
aData = str.Split("-")
[Code]....
Here is the structure of my database: i have textbox1 and textbox2 and 8 checkboxes in my ASP.NET (VB.NET) webform.i want to retrieve the seats on the particular dates means if i enter 11/12/2010 in textbox1 then in textbox2 the output would be from seat_select column, let say (1,2,3) where date would be 11/12/2010
If i enter 13/12/2010 in textbox1 then in textbox2 the output would be 1,2