By 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' successfully created a project fully functional using access database. I've read about SQL connection on VB .net. how to save three text boxes into three fields in excel and a way to retrieve it if I want.
View 2 RepliesI have a function that I pass in xml results and though I could call by Child position but appears now that some nodes if blank do not show up.
How can I call by name?
Below my code fails on the data (at bottom), on the field 'DesiredSalary' which isn't in the returned result.
#Region " fnYahooSearchResults"
Function fnYahooSearchResults(ByVal sXML As String) As DataTable
Dim myDataTable As DataTable = New DataTable()
[Code].....
i can create a textbox through run time but i dont know how to retrieve the values in them heres what i did
[Code]...
How to save and retrieve images in a vb.net 2005 program
View 3 RepliesIn the application I'm documenting, sometimes a value is stored in a Public variable & other times it's passed to/from a Public Property which does nothing except store it in/retrieve it from a Private variable. (And in one memorable exception, the Public Property stored it in a Public variable-I'm almost certain that was an oversight by the original programmer though.)
I know that passing it to/from the Public Property has the potential for better validation, but if the Property doesn't actually do anything except store/retrieve it is there any benefit to declaring it as a Property? (Or maybe I should put that the other way around. Personally I'd declare them all as properties because that will allow adding validation later-but I'm not rewriting this, I'm just trying to document it and, in this case, trying to figure out why sometimes it's done as a property & sometimes as a Public variable.)
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 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 need to design an application in visual basic 2005 that will retrieve pictures on a form. PS: All pictures should be located in a combo box! And the number of pictures are 2000.I've started with cmb.Items.Add("pic1") but that really tiresome to write 2000 codes.
View 9 RepliesI have a software coded using visual basic 2005. I don't have the 2005 version now and i need to edit that software. Is there any way to retrieve the code using vb2008 or vb2010? If not from where can i download the 2005 version? I need to do it at the earliest.
View 4 RepliesI am using vb.net 2005 and sql server...in vb.net, i was using picturebox.text to capture image from the user.
Am also using Bindings and tableadapters to generate the information from sql server..my server acts as designated server which lots of computers are using my server database...the sql server allows remote computers to share the database i have it in my server.[code]...
I 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 ?
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
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] .....
How can i retrieve NULL Field [ Date Out ]in sql 2005 database to a Grid View in ASP.Net. I need this field to be edited by the user.
View 2 RepliesDoes anyone have any suggestions how I might store the contents of a RichTextBox that also includes images to a MSSQL 2005 database?I suppose a possible answer to this would be to convert the entire content of the RichTextBox to a Byte Array, and then insert the array as a varbinary(max) datatype.But how do I convert the content ?
View 1 RepliesI 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?