Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Using conn As New SqlConnection("Database=Clinic_Management_System;Data Source=.SQLExpress;Integrated Security=True;AttachDBFilename=|DataDirectory|Clinic Management System.mdf") Dim cmdRecord As SqlCommand
I have a gridview that is bound to a datasource on a Windows Form (VB.NET). The grid displays a list of "certifications", and each "certification" can be associated with many languages. So in the grid, I'd like to display "languages" as a column, and display a comma delimited list of the language names for each "certification".
In the "certification" class, one of the properties is a list of "language" objects, and each "language" has an ID (guid), name (string), and value (integer).
So in the datasource, I have the list of "languages", but I can't figure out how to display them in a column on the grid. The gridview won't let me add the language list property as a column.
So is the ONLY way to add a new property on the "certification" class, which returns a string that contains the comma delimited list, and show THAT on the grid? Or is there a way to display that list of "languages"?
I have a GridView which is programatically filled from the DB (not a SqlDataSource or such). There are 4 columns which are TemplateFields as I format their text. They are Dates and Times and this is the one of their TemplateField:[code]'ve been using the method in this Post which was converted to VB code from this to convert the GridView to a PDF using iTextSharp.My issue is that I'm getting a Null Reference exception here when adding the GridView data to the PDF(inside the For Loops):[code]These Date/Time columns show up as empty on the PDF while all other columns show up with no issues.
Elementos = From b In Elementos Where b.Value.IdGrupo = 0 Select b
"Elementos" is a dictionary(of long, MyObject). MyObject has approximately 50 properties.
The problem I have is that I have a new requirement to accept string parameter with a "where" condition. Something like "property1>10 and property2 like 'anystring' or property3<=25". (That means any property could have a condition. I have string and numeric properties.)
I'd like to keep using linq, adding the condition as it comes. I'm aware that it could produce an exception if the condition is misspelled or something, but that's acceptable (by try catchs). I wouldn't want to parse the string to build parameters or anything.
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.
The reason this is being done is at this point we have no idea what the column contains.However, if the formatter is "{0:MM/dd/yyyy}" and the DataRow("ColumnINeed") is an integer containing 42, String.Format is returning: MM/dd/yyyy In this situation I need it to throw an exception instead of returning nonsense.Is there anyway to make String.Format throw an exception if the object does not match what the format string is expecting?
Is 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.
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.
How find an object's type when it is a subclass of another object and I only know the string value of the object's type's name. I created the following classes: HTML Public Class word End Class Public Class noun Inherits word [Code] .....
Then, in my code I create a new properNoun and check to see if it is a properNoun, noun or word: HTML Private Sub checkTypes() Dim pn As New properNoun MsgBox("Is a properNoun: :" & TypeOf pn Is properNoun) 'TRUE MsgBox("Is a noun: :" & TypeOf pn Is noun) 'TRUE [Code] .....
I correctly see that pn is a properNoun, a noun and a word. The problem is, using 'GetType' to check pn against a string value, I can only see that pn is a properNoun, not that its parent classes are noun and word. Is there a way to check pn against the string value "noun" or "word" and get back a positive result, indicating that pn is indeed a noun and a word as well as a properNoun?
I have a question. I have a class of Cars that I need to display in a simpli-ish string if they will be sold or not base on their number.
[Code]...
I'd like to display a simple string like this:Cars to be sold: 1, 3-5, 7-8, 11, which is based of the .Sell value.Is there some kind of heuristic to create this kind of string in .NET or is it just a bunch of for/each and if/then and redimming of arrays?
Is there a way to dynamically create an object using a string as the class name?I've been off VB for several years now, but to solve a problem in another language, I'm forced to develop a wrapper in this one. I have a factory method to dynamically create and return an object of a type based on input from elsewhere. The provided input is meant to be the class name from which to create an object from. Normal syntax means that the entire class has to be explicitly spelled out. To do it this way, there could literally be hundreds of if/then's or cases to handle all the available class/object choices within the referenced libs:
If c_name = "Button" then obj = new System.Windows.Forms.Button If c_name = "Form" then obj = new System.Windows.Forms.Form ....
I am running into a simple issue for which I cannot find an effective solution.
I need to convert 2 D array of objects to 1D String.
Dim saRet(,) As Object = Nothing Dim fileLineArray() As String = Nothing SaRet = xlrange.Value //it gets values assigned as objects In a loop.... fileLineArray(i) = Cstr(SaRet(i,0))
I get the error, index was out of bound. ToString isnt able to convert 2d array of objects to 1 D.
I have lots of labels that I need to refer to. E.g. label1 = listbox1.selecteditem.tostring & "123" label2 = listbox1.selecteditem.tostring & "123"
I have 20 labels which i need to repeat the same process for. What I found was this code which always gives me the null reference error. CType(Me.Controls("Label" & i), Label).Text = "what i want here"
I have stated dim i as integer = 1 And later i = i + 1 until it is 20.
I've tried i.tostring and cstr(i) when referring to it but it keeps saying it doesn't exists even though i have labels 1 to 20 named label1, label2 etc. on my Form.
I don't know if I explained this in my title, this is what i want to do. (In VB on a active server page) I have 5 buttons called but1.....but2. Right now I have the following code to make them invisible
I am using standard String.Format method. It is using numeric objects. Console.WriteLine("obj1 = {0} and obj2 = {1}", "obj1", "obj2"); I want to use named indexes.Like this Console.WriteLine("obj1 = {o1} and obj2 = {o2}", new { o1 = "obj1", o2 = "obj2"}); How I can use same last code?
Currently, 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 figure I should use 'Aggregate' but apparently I am getting it wrong First I get a list of my Entity objects Dim employers As List(Of myEntity) = (New XXXX()).getZZZ(userName, userType) Then I figured this would be a way to put all the names in a string Dim names as String = employers.Aggregate(Function(current, [next]) current.Name & " " & [next].Name)
I want to retrieve an object by using a string representation of the objects name. For example lets say i want to change the font of 3 labels on a form programatically. Instead of changing the font property for each individual label like so:
I'm writing a program that reads a directory of xml files (not well-formed), parses the xml, and dumps the data into an Excel Workbook.The file contents are similar in that they have many common xml nodes/attributes.Some files have additional nodes/attributes.The xml in these files represent configuration settings for a Web Application, one file per user.The expected output is a worksheet with a column for each node/attribute combination and a row of node/attribute values for each user.I'm just about finished with the program, but I've run into a bit of a snag.As the final step in the process, I need to loop through a generic list of array objects (that represent a user row) and send the array elements to Excel.I don't know the correct syntax to get the array objects out of the list and have been unable to find sample code specific to generic lists of array objects.[code]
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?
I'm working on a mass text replacer program because I'm sick of all the 10-day trial ones out there that aren't very good.The entire program is basically finished (All easy stuff), but now I need to code the actual replace/delete stuff, which I'm stuck on because apparently the way I originally intended to do it is not possible.
The way it works is you load a text file (.txt, .cfg, .ini, .doc, etc.) which opens a StreamReader which writes all the data into a listbox. Then you pick whether you want to replace or delete a string. If you select replace, then you enter the string to search for and in another textbox you enter the string to replace it with.
The way I originally intended to do this was like this:
If o1.Text = "Replace" Then 'The option Replace(txtfile, str1, a1) 'txtfile is the data, str1 is the string to find and a1 is the replacement End If
The problem is, I believe this method requires txtfile, str1 and a1 to be strings, but they're all 1-dimensional string arrays, which cannot be converted to strings, or at least I don't know how to convert them.
A friend told me one way I could do this is to open both a StreamReader and StreamWriter and do the replace/delete line by line as they are entered into the memory and write them to a temporary file which is then copied over the original. I can do this kind of, but I still don't know the proper way of doing the actual replace code because the string to find and the string to replace with are still 1-dimensional string arrays rather than strings.