in an sql table there's an id, first name and last name field. i'd like to concatenate the first and the last name fields and display it as one in a dropdown control.
this is the vb.net code:
con()
sqry = "[SELECT QUERY]"
sqcom = New SqlCommand(sqry, sqcon)
[Code]....
^this code displays only the first name. how do i go about concatenating in asp.net?
I'm trying to concatenate two fields in LINQ so that I can then filter with a keyword. I found a question posted here that I thought was my answer, but I'm getting 0 records back for some reason. This is supposed to return a JSON result for an autocomplete textbox (it works when I don't concatenate fields).
Here's my code:
[Code]...
I have a list of servers in the first dropdown. I want to get list of all databases in the second dropdown depending on the server selected in the first dropdown.
For this I need to query each server while selecting the server.
I'm currently refactoring an old Visual Basic DLL (VB.Net), which stores all of its data in one module called Globaldefinitions as public fields. There are about 200 fields, referenced thousands of times all around the code:
Public Module Globaldefinitons
Public a As Short
...
Public zz10 As Double
[Code]...
I need to change the module into a class with non-shared fields. This means, each and every of these thousands of references needs to reference the instance of that class:
globalDefinitionsInstance.a = 5
How do I go about this efficiently?
Regular expressions operating on the source fall flat. Refactoring tools like Re-Sharper or CodeRush don't seem to offer this functionality. Visual Studio 2010 cannot do it automatically either.
Class Foo
ReadOnly name As String
Public Sub New(name As String, dependentUpon As Foo)
Me.name = name
[code]....
The output of New Bar() is:
Dependent created. Dependent upon nothing.
Independent created. Dependent upon nothing.
It seems fields are initialized in the same order as they appear in the source code, which (a) leads to an unexpected result, and (b) seems a little puzzling, given that one is normally not permitted to read from uninitialized variables in .NET, yet that seems to be working fine above.I would've expected VB.NET to be smart enough to initialize referenced fields first, and only then those that reference it; i.e. I'd have liked to see this output instead:
Independent created. Dependent upon nothing.
Dependent created. Dependent upon Independent.
how to get VB.NET to behave like that instead, without simply having to swap the declaration order of dependent and independent inside class Bar?
I'm trying to create a table in Word using data from a table in Access. There are four fields in the access table that I need. 3 fields are text which I can populate the Word without any issues. However the fourth field is a memo with >255 characters.I'm struggling to come up with the proper code to allow me to populate the Word field with the memo data that has more than 255 characters. The code I have so far is listed below. But when it hits the memo field, it crashes on the line I marked with **. I know it's not text, but I've tried many different field types, but nothing has worked so far.[code]...
View 1 RepliesMy intent is to have the code - on a button.click event - check the Username and Password fields and return an error depending on which is wrong. Or if both are wrong, return a different error message. I've set the username as parts and the password as parts (still learning how to use external authentication). [Code]
View 2 RepliesI have several sqldatasources for my gridview. All of the columns are autogenerated. However they all have some consistent fields and I'd like to make those fields template fields so I can modify the edit template for them such as adding a drop down menu. Is this possible?
View 1 RepliesDim a As String = ""
Dim x As Integer = 0
Dim y As String = ""
[code].....
In Visual Studio 2010 for Windows Phone , every time I want to concatenate 2 strings , I get an error message:
[Code]....
My program is supposed to Concatenate the name to the end of the message.I can not get it to do so.. Here is my code.
Private Sub picOn_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles picOn.Click
picOn.Visible = False
picOff.Visible = True[code]...........
I am making an application to execute few UNIX commands from Windows Application.[code]....
View 5 RepliesI have a filename in a string. I want to split the given string into 2 (1 is filename without extension, 2 is only extension) strings. Then add _dev to the end of first string and concatenate with 2nd one.
ex: Dim name as string="abc.txt"
Dim finalName as string
The finalName should be like this "abc_dev.txt"
I had a previous thread asking how to make an unbound column work, but quickly found that this causes huge performance issues. I have a table called TieIns, it contains a column TieIn_ID and some other various information.
[Code]...
I have two strings arrays
Dim sir1() As String = "m1-m2","m1-m3"
Dim sir2() As String = "1-0","0-0"
What I want is this output:
m1-m2 1-0
m1-m3 0-0
Which is the fast method to concatenate them?
I tried
Dim sir3() As String
sir3=sir1&sir2 but with no result
Ok I am a newbie and I need to concatenate a number and an integer. Can somebody give me a idea on how to accomplish the following/I need to take the number (which is an integer from a simple math function) and the letter A and create something like "A10" or "A45" or "A123". Can someone please give me a tip on how to accomplish this?The program creates the integer by using the value of a drop down box and a reference number of 9. The maximum value will be 109 and the minimum is 10. It needs to be combined with the letter A, which does not change.
View 5 RepliesI have two DataGridView. I need to copy both data to the Clipboard (so when the user pastes, both data will be copied, in the order I copied).
Dim dataObj As DataObject
dataObj = dgvToExport.GetClipboardContent()
'How to add this? dataObj = dgvNotes.GetClipboardContent()
Clipboard.SetDataObject(dataObj, True)
I have two strings arrays
Dim sir1() As String = "m1-m2","m1-m3"
Dim sir2() As String = "1-0","0-0"
[code].....
I do have a multi select dropdown box.I want all the selected items uin in a string with comma seperated value.[code]I want a shortcut like join to accomplish the task.
View 1 RepliesI have a spreadsheet, in which I need to concatenate certain cells.Basically if the ID cell is blank then I need to concatenate the description cell with the previous description cell and delete the row.In your opinion what is the best way to do this:
a) Should I read the excel file into a dataset, process the dataset and write back to excel?
b)Should I directly Edit spreadsheet?
BTW the spreadsheet has 13,000 rows, hence the need for automation?
how do i concatenate strings? i have done it like this.
[Code]...
experience on how to create an engine using C# (VB.NET is okay too) that is generic enough to handle most cases of MS Word text fields I need to fill with data I'm getting from a database? In short, I'm about to embark on this little Office automation excursion and I'm hoping a little bit of feedback here.
View 2 RepliesHow do I do this in Razor (VB.NET):
[Code]....
I am supporting an application, which uses lots of String concatenations and I believe this is the cause of a memory leak which eventually causes an OutOfMemory exception. Please have a look at the code below:
Public Sub ConcatenateString() As String Dim Test1 As String
Test1 = "Hello"
Test1=Test1 & "my"
Test1=Test1 & "name"
[code]....
I believe there are nine Strings in memory at line ten as String is an immutable object, but only one reference to the String Test1 that contains: "Hello my name is Joe Blogs what is yours?". My question is; are all of these Strings picked up by the garbage collector when they go out of scope? i.e. when the sub routine finishes running. I seem to have a memory leak and am thinking that I should really be using a StringBuilder object.
In our school theres a programming class and the teachers gone for the week and the sub is starting to get very frustrated, so I offered to help in any way i can. I have never programmed Visual Basic but I have programmed Ms-Dos, Javascript, HTML, *.vbs, *.ahk, *.gml, and a variety of other languages.
The class is going to build a program that calculate how many rabbits are born in a family. So when they click the button it shows in a text box the actual equation and then the answer after the equal sign that where i assume concatenation comes in.Here's the code I've thrown together for when the buttons pressed:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim RabitAmount As Integer
Dim ShowEquation As String
[code]....
I got the equation to answer it self and show in the text box but it won't show the equation?
i wish to concatenate date and time from 2 different datetimepicker after concatenated I want it to be save in sql database format which is yyyy-MM-dd HH:mm:ss
I'm doing half way and my query is like below.
Dim insertCmd As New SqlCommand(Sqlstr, connection)
insertCmd.Parameters.Add("@School_Subject", Data.SqlDbType.NVarChar).Value = txtSchoolSubject.Text
[Code].....
This seems basic but here's my problem. I am trying to build my connect string as a public variable that will connect to either an express version of SQL Server or a non-express version. The app.config defines it as being express or not and is modified to the user's choosing when it is deployed using the a firstRun routine.
The problem is that even though I'm modifying the value of the variable SQLexpress when the app is initiated which in turn should modify the value of the variable g_strConnectionString it doesn't. The value of g_strConnectionString will always take on the initial value of SQLexpress. I know I can define 2 separate variables for the connection string but I'd prefer not to have to change all of the references throughout each of the various programs in this system as they all have the same issue.
So in the following load event I've traced it and when it sets globals.SQLexpress = "", I then look at the value of g_strConnectionString and it still contains "SQLEXPRESS". It seems I need to somehow force vb to refresh this variable after it's been changed.
[Code]...
Does anyone know how I can go about concatenating multiple columns from a table to populate into a combobox? I have 4 columns from which I need the data to show up in 1 line when clicking on the dropdown/combobox list. I'm not sure if I have to deal with the display member or the value member.
View 2 RepliesI have a table which contains a list of products for a company. They input data about how much stock they have and also the level at which they want to be reminded that they need to order new stock.
[Code]...
I want to list all the true results in a form which the user is then able to navigate through. What would be the best way to go about doing this?
How do I concatenate a string in a asp.net gridview boundfield? I only want to show a "..." after a set number of characters that comeback from a Typed Data Set. Whats the best way to do this?
View 2 Replies