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
[code]....
I am getting this error, Not sure why it is happening "Error The SqlParameterCollection only accepts non-null SqlParameter type objects, not Int32 objects."I have tried with all sorts of possibilties, now try to enter default data as dummy data,
Using connection As New SqlConnection
connection.ConnectionString = ConfigurationManager.ConnectionStrings("DentalDeviceConnectionString").ConnectionString
connection.Open()[code].....
I am developing a VB.NET application with SQL Server 2008 and I get the above error when I try to run this ASPX file. What is the cause?
[Code]...
I have a web application running written on ASP .Net.We have a class accessing the back end written in VB .net which has shared functions for DB interactions.The above error comes up when ever two users are in the same page... tying to do the same thing.Couldn't find a reason why this would happen.The scope of the SQL command is limited and parameters are cleared at the end.
View 2 RepliesI keep getting a strange error message when I try to call my stored procedure. Possibly I have a syntax error? Not my store procedure does not return a value. Also the error message is included at the end of this post.
--VB .NET Code
Dim connString As String = ConfigurationManager.ConnectionStrings("EMRConnectionString").ConnectionString
Dim conn As New SqlConnection(connString)
' Create a new sql command, and reference the stored procedure by name
[code]....
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 function that is getting passed a String and a DataRow.The String is a custom formatter. The idea is to do this
String.Format(passed_in_String, DataRow("ColumnINeed"))
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?
I have used XML serialization to persist objects in my application but I am now interested in using null- able Data types for properties. Will I still be able to serialize?
View 6 Repliesmake objects from the ToolBox using code instead of changing existing objects invisible then visible later?
View 7 RepliesI have a program like this.
Module Module1
Public Class Mstr
Public Property Prop1 As String
Public Property Prop2 As String[code]....
But it is not working as I expect it to. You can see it from.The DtlsB properties of all three DtlsA objects are having values from last iteration.
I want to let the user input objects to a richtextbox 1 object on each line, and somehow use Random.Next to select pseudorandomly a few objects, the number 'few' inputted in a textbox.
View 9 RepliesI have a user control that inherits the FW ListView and I need to dispose of two objects when the form's disposing of it's objects. Here's what I've concluded already, am I on the right track?
[Code]...
long story short, I have created a ListView type control, using UserControls for the parent control and the ListViewItems. Most the of the control is written and works fine, right up to the point where I tried to replicate the 'Control.SelectedItems(0).Index' property and the 'SelectedIndexChanged' event.
Each child object knows its index value, and could pass this value via the SelectedIndexChanged event (assuming this is how it works in a normal ListView control -- user clicks on an item, and that item fires an event updating the selected index value in the parent object).
How does the child object raise an event in the parent object? I have a feeling this could be done with Delegates, but I'm still learning about their usage.
I am working on creating an application (game) for a PocketPC with Visual Studio2005 in VB/.NET. I try to dynamically create a (new)button upon clicking a label and assigning certain properties to this button. For this I used below displayed code, but this button does not appear on 'Form1' - which is big enough to display it- but creates an error: A NullReferenceException. Such occurs when you try to reference an object in your code that does not exist, but I think I just did by using'..New..' Who can tell me what is wrong and how to fix this? [Code]
View 16 Repliesgetting the following error Unable to cast object of type 'System.Object[]' to type 'OrderService.webdirect_WebLinesRow[]'. On the line
webdirect(web_companyID, web_locationCode, web_customerNumber, web_orderNumber, web_orderReference, web_orderDate, webLinesArray.ToArray(), o_Company, o_LocationCode, o_CustomerNumber, o_OrderNumber, o_OrderStatus, o_OrdDescrip, webRespArray)
I created the webLinesArray.ToArray() array as such
Dim webLinesArray As New ArrayList()
Am I missing an additional cast or something ?
I want to compare two objects to check if all the properites of both the object have same value or not. for this i need to use the reflection to enumarate through all the properties of an object and check the value of the property. To try the code just i have written a Employee Class having Two Properties EmployeeNo and EmployeeName. I am creating an object of the Employee class and need to write a function that can list the values of all the properties in the class.
[Code]...
I am new to VB.Net and I'm a little confused why this line happened to be valid in VB:
DataGridView1.DataSource = ds.Tables("Customerslist")
DataSource is of type Object while Tables("Customerslist") is of type DataTable. How will I know what types of objects can be assigned to the Datasource property?
I have an RDLC report that I am rendering directly to the Response Stream as PDF (rather than using the ReportViewer). In the code that renders the report, it's DataSource is bound to a List(Of ClassA) objects defined in a custom assembly. This seems to work for the most part. My problem is that I can't seem to handle the situation where a nested object is null. For example, given ClassA and ClassB (the nested object) defined as follows:
Public Class ClassA
Public Id As Integer
Public Name As String
[Code]....
the report displays "#Error" if TheNestedObject is null. If TheNestedObject is not null, it correctly displays the Name.
I created a Class which inherits Combobox and the listview is added . Now what I need is once the user click listview, the listview has to close and the clicked item has to added with combobox text. simply can say combobox1.text = listview.item(0).textFor closing & displaying the listview I need to handle the events. For
My Codings :========Public Class Combu_lstviewInherits ComboBoxPrivate treeViewHost As ToolStripControlHostPrivate Shadows dropdown As ToolStripDropDownPublic mylistview As New ListView
Public Sub New()mylistview.BorderStyle = BorderStyle.Nonemylistview.View = View.Detailsmylistview.HeaderStyle =
[code].....
I am tring to bind a class to a form where the class contains other class variables. For example:
Class Character
Private _name as String
Property Name as String
[code]......
Is there a way to attach a Sub or Function to an event of many controls at once?For instance, to clear a bound combobox I use this routine on the KeyDown event of the combobox:
VB
Private Sub MyComboBox_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles cboID.KeyDown If e.KeyCode = Keys.Delete Then sender.SelectedIndex = -1 End IfEnd Sub
But if I have many comboboxes, I have to copy the same routine over and over to all of them...Is there a way to attach the routine to the KeyDown event of all comboboxes?
Pseudocode example:
VB
Sub AttachEventOnKeyDown For Each ctl As Control In Me.Controls If TypeOf (ctl) Is ComboBox Then ' On ctl.KeyDown execute "MyDeleteRoutine(ctl)" End If NextEnd Sub
How can this be done?
I've tried posting this to a few forums, even microsoft... Hopefully this forum is the place to be.
I'm programming an application in Visual Studio 2010, namely in VB.net. I have been developing an application which uses a derived class inherited from TreeView, with the aim of putting custom objects on the nodes. The method I have been using is to have a variable array against the node (of type object) which contains variables in custom classes to contain each of the variables associated with the node.
The two problems I had to overcome were, how to serialize a TreeView, and how to serialize an array of objects (of variable type). Good thing is I overcame both of these with some work of some other folks (and 3 days of my own work).[code]....
lets say I have:
arecord.name = "A"
arecord.value = 15 ' a number of type "long"
'
I then
call records.add(arecord,arecord.name)
' so far, so good but lets look at the next record
arecord.name = "B"
arecord.value = "this is text" as opposed to a number of type "long"
'can I then
call records.add(arecord,arecord.name)
Given an object instance, how can I recurse its members (i.e. the whole object graph) for an object of a specific type, or one that inherits from a specific type?
View 1 RepliesWhat's a sound approach to override the CompareTo() method in a custom class with multiple approaches to comparing the data contained in the class? I'm attempting to implement IComparable(Of T) just so I have a few of the baseline interfaces implemented. Not planning on doing any sorting yet, but this will save me down the road if I need to.
Reading MSDN states mostly that we have to return 0 if the objects are equal, -1 if obj1 is less than obj2, or 1 is obj1 is greater than obj2. But that's rather simplistic.
Consider an IPv4 address (which is what I'm implementing in my class). There's two main numbers to consider -- the IP address itself, and the CIDR. An IPv4 address by itself is assumed to have a CIDR of /32, so in that case, in a CompareTo method, I can just compare the addresses directly to determine if one is greater or less than the other. But when the CIDR's are different, then things get tricky.
Assume obj1 is 10.0.0.0/8 and obj2 is 192.168.75.0/24. I could compare these two addresses a number of ways. I could just ignore the CIDR, and still regard as obj2 as being greater than obj1. I could compare them based on their CIDR, which would be comparing the size of the network (and a /8 will trump a /24 quite easily). I could compare them on both their numerical address AND their CIDR, on the off chance obj2 was actually an address inside the network defined by obj1.
What's the kind of approach used to handle situations like this? Can I define two CompareTo methods, overloaded, such that one would evaluate one address relative to another address, and the second would evaluate the size of the overall network? How would the .NET framework be told which one to use depending on how one might want to sort an array? Or do some other function that relies on CompareTo()?
I have a nested class, let's call it class1 and it has class2 inside it; VB.Net eg:[code]
1) How can I define X number of Class2 objects[let's call it: Node(x) array]** with NEW() subroutine called?' this raises error: dim cls2(n) as new class2 end sub.
2) How can I return actual number of Node() array? [code]Outside my class in main project I define cls1 object:[code]Now an array of class2 is created inside cls1.
3) Now,How can I access All of them[node(x) array which is created inside cls1] with all properties and methods available?
I remember I wrote a ProcessManager class with this functionality in .net 2003, nearly 4 years age, I don't have the code now.
I have a linq query like that:
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 was wondering how I could go about getting a list of string from a list of objects, while removing duplicates[code]....
View 2 RepliesHowever I do not want to make like 100 blocks of code made of If statements doany idea that this could be done. Like for example
Dim str1 as string = "X" or "O"
If btn1.text = str1 and btn2.text = str1 then
Messagebox.Show("Blah Blah")
[code].....
I have a form that displays data. What I would like to have is a button that when pressed will display some test extran textboxes in a dimmed/transparent type of fashion. I can get that using another form, but would like to do it without the second form.
View 1 Replies