In my main application i am trying to run Pre-defined Code blocks that the user has created. I would also like to send a DataSet as a parameter when the code is compiled. Is this possible. Currently I can pass in single values by assigning them as a string in the code wrapper through the <%= input %> expression. Then i compile this as source.
[Code]...
I'd like to know how to pass a DataSet to use in compiling code with the CodeDOM. I know how to pass single values as string but not a Dataset. I replace the <%= input %> with my logic statement provided by the user and then compile code. But how to send a loaded Dataset along with it I cannot figure out.
Dim code = <code
Imports System
Imports System.Windows.Forms[code]....
I know CodeDom doesn't support partial methods, but is there a workaround? I found a workaround for C#, but I need one for VB.NET.
View 2 RepliesImports System.CodeDom.Compiler
Public Class iCompiler
Public Shared Sub GenerateExecutable(ByVal Output As String, ByVal Source As String, ByVal Icon As String)[code].....
I have a method which must take an application setting as a parameter. E.g. MyMethod(ByVal setting As Setting)This example doesn't work because I do not know what to declare the variable as. Can someone please advise me on how I can get the method toaccept a My.Settings settings? My intentions are strictly to make the program
View 4 RepliesI created a dataset that is getting data from an access database. Now i would like to go further and make the dataset query accept a parameter from a form datepick value. the query in my table adapter I have changed it as follows to accept a parameter on date1.[code]The code I am using in my form is as below. I get a null reference exception on the second line(Object reference not set to an instance of an object). it seems as if my selectCommand is bringing nothing.[code]
View 4 RepliesI have a bound DataGridView (dgvBuild) that contains data based on a "ProductID" that is derived from selecting the value from a ComboBox. How do I pass the ComboBox Value to the DataAdapter to retrieve records to reload the dgvBuild? Below is the code for theDataAdapter.This is the line that was created when I bound the DataGridView to a DB Table.
View 8 RepliesI have a DataSet1.xsd This is connected to my access DB through OleDB. the DataSet Designer is stating that my column in my table is of type Double. Which is true when I verify it by opening Access and viewing that same column in my table.
I need to pass a parameter to my fill query so that on formload it populates the controls. I create the parameter in the dataset designer and give the paramter a name and specify the proper data type.
I edit the query to include the parameter.
on form load the generated code from the dataset designer inserts the fill command for the table adapter but doesn't include the parameter data, so I manually insert the data to be passed to the parameter.. This is where I get an error stating that datatype mismatched..
However the datatypes are correct.
I deleting the files of certain age in a directory and also need to write a log file. So my question is how can we pass a variable from one method to another?
Example : Dotnet.Explorer
So for instance I have this method: LoadFunkyInfo(byval funkyData as string) And I pass it something like this:
LoadFunkyInfo(giantTable.Rows.Item(0).Item("blahName")). Should I do this instead?
dim foo as string = giantTable.Rows.Item(0).Item("blahName")
LoadFunkyInfo(foo)
I read somewhere long ago, that it's better to assign the method to a variable and pass that variable to a method, as opposed to passing the method as a parameter. Is that still true? Or true at all?
I have been thrown in at the deep end with an existing VB.NET project at work. I have never used VB.NET before so I am struggling a little. Does anyone know how to solve the following.I need to pass an instance to client side and then pass it to a shared method in order to access instance methods from when the shared method.The starting point is a fileupload control within the HTML of my Contacts.aspx file:
<asp:FileUpload ID="DocUpload1" runat="server" onchange="CallMe();" />
The onchange event calls a javascript method, see below, this uses AJAX PageMethods to called a Shared method in my code behind This is the script code which is in my Contact.aspx file
[Code]...
If anyone knows the solution please could they update the code as I probably won't be able to understand if you just give a description. I just hope I am along the right tracks.
I have a C# interface defined as so:
public interface IMenuSecurityService
{
void SetSecurityFlags(List<MenuItem> items);
}
I need to implement this interface in a VB.Net class. When I implement the SetSecurityFlags method with the items parameter passed ByVal, it compiles.
Public Sub SetSecurityFlags(ByVal items As List(Of L1.Common.Model.MenuItem)) Implements IMenuSecurityService.SetSecurityFlags
' do some work
End Sub
When I try to implement it with the items parameter passed ByRef, I get the following compiler error: Class 'UserRights' must implement 'Sub SetSecurityFlags(items As System.Collections.Generic.List(Of Model.MenuItem))' for interface
Public Sub SetSecurityFlags(ByRef items As List(Of L1.Common.Model.MenuItem)) Implements IMenuSecurityService.SetSecurityFlags
' do some work
End Sub
I can't seem to figure this one out. Does VB.Net not support this or am I doing something wrong?
The GUID is the SelectedValue of a ComboBox (cbNetwork) If I execute a Debug.Print on the cbNetwork.SelectedValue, I see:
645b9d20-23eb-469e-9faa-e287600a54f3
However, when I try to execute the Fill method of the DataTableAdapter, I get an error "Specified cast is not valid."
[code].....
What happened when parameter passing. Here is a test project I write.
Public Class Form1
'1.test string
Private Sub btnString_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnString.Click
Dim str1 As String = "x"
[Code] .....
From the project you can see, when pass integer type parameter (value type) into a method , if use ByVal keyword, the value won't change. If use ByRef keyword, the value will change (I can understand it, to my understanding, when using ByVal, It pass the value of the argument to the method; when using BvRef, it pass the address of the argument to the method, so the value can be rewrite)
Well, for the following two scenarios , I can't understand why.
String type is reference type, but it acts like integer type.
Val type is also reference type, but no matter what you use(ByVal or ByRef), the result will be the same.
So my question is what actually passed into method? What's the underlying mechanism about pass parameter? What's the effect of ByRef and ByVal to value type and reference type?
I am looking for a way to pass a class method into a new thread. On my form I have a few object that contain methods.
For example obj1.doWork.
Now I want to do
Example
Dim t as new Thread
t = new Thread(AddressOf obj1.doWork)
t.start()
However I get an error on this saying:
Error1Overload resolution failed because no accessible 'New' is most specific for these arguments:
'Public Sub New(start As System.Threading.ParameterizedThreadStart)': Not most specific.
'Public Sub New(start As System.Threading.ThreadStart)': Not most specific.
passing parameters to dataset FILLBY GETDATABY
View 14 Repliesi have simple html page with 3 textboxes.
[Code]...
The page loads but is these textboxes are empty. what am i doing wrong?
Jst recently i came across the select() method of data table and felli n love with it instantaneously.
Basically I want query the data table on a date field, unfortunately the format of the date string returned from y database in to data-table and the date string i'm passing as inputs are different.
How can i make sure that the data is compared irrespective of the formats ? Can I use something like SqlParameters whoes data type is date for comparison ??
this is what i'm tying :
dim dat as date = "#1/3/2009#"
dt.select("StzDate ='" & dat "'")
entry in datateable dt : StzDate : 3/1/2009 12:00:000
Am I do'in something wrong ??
Also, can anyone redirect me to some site where I can learn a bit more about passing parameters to the select statement,etc...
We are getting correct output for crystal report using dataset which does not have a sub report.But it does not work for subreports?
View 3 RepliesTrying to make a vb.net program that is able to read values from an access database and pass them into some data sets. Here is the code I have so far, with the error line between the two dotted lines:
[Code]...
I have a class and method exposed to a client asp.net app. The class looks like
<DataContract()> _
Public Class Class1
Private v_string As String
Private v_integer As Integer
[code]....
The method is declared as
<OperationContract()> _
Function GetStuff(ByVal bar As Class1) As String
In the client code I create an instance of Class1 and set the values for v_string and v_integer, but using Wireshark to look at the xml being sent to the server only a value for v_string is being sent as part of Class1. I'm guessing this is because it considers the value of v_integer to be null/not set. Here is an example of the client code.
Dim MyService as New Service1.ServiceClient
Dim test as New Service1.Class1
test.P_integer = 1
[code]....
how different types are passed/used since Integer is a intergral type and String is a class, but can't seem to work out what to do to fix the problem.
I think I've misused this method and would like to know what it actually does.I 've looked it up on msdn forum and found this
[code...]
What does it mean by removing all the rows in all tables? Is it the datagridview table? When it says "removing", does it mean that it deletes everything?
The reason I misused it is because I thought dataset.clear means it flushes the record held in dataset.
When I click on the add new icon on bindingnavigator, a new form will appear, which allows me to insert data
[code...]
when I close the insert form, the parent form will be activated and datagridview will display the new record I just inserted. I thought the dataset.clear method helped display the new added record but then I realised I could do without the dataset.clear method.
[code...]
I have a filled dataset from a query.
I must modify 2 columns in this dataset, based on a custom function value (a normal vb function), which parameter is an another column from the dataset.[code]...
I am looking for some guidance with the most optimal or efficient way to export a dataset to an excel file. I have searched the forums and found a number of methods to do this. However, the code I am currently using is very inefficient as it is itterating through the rows and columns to create the excel file. The app I am working on needs to be able to create 50 or so excel files each with 500+ rows and 40-50 columns. This method seems to inefficient for my use
View 9 RepliesI am experiencing something very bizarre when I execute the Fill method of my adapter. I've been running this query for months and all of the sudden this is happening after I installed SP1 for Visual Studio 2008. For some reason several DataRows in 2 of the 3 tables within my DataSet have errors in them when I view them in debug mode using the DataSet Visualizer. Here is a picture of what I'm talking about
It does this to random rows. If I execute the Fill method the first time, rows (5-10) will have these errors. If I execute the Fill method again rows 12-23 are affected and so on. I have no idea what is happening here.
This is effected my DataGridViews, because they don't display any rows, because of the erros. I should also note that when I run the lines of code below in the Immediate Window it says the DataSet doesn't have errors.
?Me.ds.Tables("Current").HasErrors
False
?Me.ds.HasErrors
False
I created a new query in the dataset designer. There are now 2 queries there. The original one and the new one.I also added named parameters in the Where clause of the 2nd query.This is the query in the new one:
SELECT ID, FatherName, MotherName, EmergencyContactName,
EmergencyContactRelationship, Address1, Address2, City, State, Zip,
PrimaryPhone, SecondaryPhone, Emaile.
[code].....
I am trying to pass query string from one page to popup window as follow:
Dim popupScript As String = "window.open('cFinder.aspx?cName=" & c_TextBox.Text & "','', 'width=420,height=200,menubar=no,scrollbars=yes');"
If (Not Page.ClientScript.IsStartupScriptRegistered("popup")) Then
[code].....
Base class has one field to hold numeric balance value. With 2 methods that accept arguments for adding and subtracting the new input calculating new balance. Sub class has four fields dates, transaction, memo and amount.I have a deposit form, and withdraw form. Each time one transaction is entered it creates an object with sub class fields, then adds to the account collection. My problem is not understanding how to call the deposit/withdraw method and pass the current transaction amount back to the base class to alculate the new balance. Does anyone have any links to information/tutorials on how to perform something like this? As you can see with my code I have tried various different approaches without any success.
[Code]...
I have implemented inheritance for two parent classes called Table and Field. Each parent class has several child classes. In the Table parent class, I created a method that expects parameter List(Of Field).
I get an error when trying to pass in parameter List(Of ChildField) to the method that expects a parameter of List(Of Field). The error message is as below:
Value of type
'System.Collections.Generic.List(Of
com.hlb.icisbatch.data.ChildField)'
[Code]....
I am trying to call a method that started on a background thread on the UI thread calling BeginInvoke and passing in a delegate as follows:
Dispatcher.BeginInvoke(Function() UpdateApplicationDataUI())
to call this method:
Private Sub UpdateApplicationDataUI()
...
End Sub
However, I get an error in the call to BeginInvoke (the UpdateApplicationDataUI portion of the delegate is stating "Expression does not produce a value").
Me.Dispatcher.BeginInvoke(Function() New Action(AddressOf UpdateApplicationDataUI))