I am confused which data type to define for my variable which stores value returned by LINQ Statement.
Currently I am defining it as some data type but its generating error like: ""Unable to cast object of type 'WhereSelectListIterator2""`
[Code]...
Here i want myBase to hold the data which has UIN = 4
I am trying to read some data from an Excel 8.0 worksheet using OLEDB thusly:(Warning - contains curly braces)
Code:
DbProviderFactory factory = DbProviderFactories.GetFactory("System.Data.OleDb");
using (DbConnection connection = factory.CreateConnection())
{
[code]....
The problem is that for some columns it sets the data type to be Double even though the spreadsheet column format is "Text" and teh column contains non-numeric data. Then when it gets to that cell it returns DBNull instead of the text value.
I have the following statement, I want to turn it into a Public Shared Function :
If isEmployee Then
Dim employeeInstance As New Employee
employeeInstance = GetEmployeeInstanceByUserId(userId)
[Code]....
Public Shared Function GetWorkerInstance(Byval isEmployee as Boolean) As ...(not sure what to write here)...
There two possible return Type. I'm not sure what I should declare for the function return type.
For each column in data table i want to add parameter with same data type as column data type. But looks it's not that simple.
Dim cmd As New SqlCommand
Dim dType As New System.Data.SqlDbType
For Each cl As DataColumn In DataTable1.Columns
[CODE]...
How can I do this?
I need to create a function which have either 1 parameter with a string as data type or 2 parameters with double as data type.Something like the substring method.
View 2 RepliesI'v designed a ms access database table with one field having Datetime datatype. I can Insert data into it from vb.net front end by trns_dt DateTime.Now.DateBut when I fetch records from the tableand assign the dataset datasource as da, it shows datatype mismatch error.
daleDbDataAdapter("SelectDaily_Transactiondtp_from_dt.value dtp_To.value con)
dsDataSet
[code].....
I am returning a date from my database table:
objSQLDataReader("date")
Which gives me:
31/05/2011 16:00:50
How do I change this to:
31 May 2011
I have a asp.net page that has several SqlDataSources defined that feed data into some graphs. The problem is that the graph product does not handle "no data" very well, and throws an error. I'd like this to handle the situation more gracefully-- so I need to check whether the SqlDataSource returned data or now before rendering the graph (and if not, just post a message saying "No Data" or something).
Is there an easy way to check if the data source returned data, and do this if/then without a bunch of code behind?
I tend to use
If Not IsDBNull(dr("data")) Then
myData = dr("data")
End If
to catch nulls. Is there a better way? It seems I use this over and over again? Anyone write a function to check this something like
mydata = IfNotNull("data")
I don't know how to handle the different data types that could be returned.
I am inserting a record in an SQL table and trying to get the record ID back so I can use it to insert subsequent/related records in another SQL table. I am missing something but have no idea what. Code is below.
<asp:SqlDataSource id="SqlDS_HydInspection" runat="server"connectionstring="<%$ ConnectionStrings:
MenomoneeFalls_DB3ConnectionString %>"
[Code]....
I'm sure im just making a simple mistake some place but i just cant find it. I have datatable which I can and can make changes, save back to the database just fine. But if I reload the data after updating, no data is retrieved from the database. But if I stop debugging completely and then start again, it loads just fine...until i call Update.
Here is some code I am using for testing purposes.
Private myDataSet As New DataSet
Private conn As MySqlClient.MySqlConnection
Dim myDataAdapter As New MySqlClient.MySqlDataAdapter
[Code]....
I am calling an Oracle function PKGDummy.F_EMPDATA using vb.net.
View 1 RepliesUsing Visual Basic 2008 How can i read data returned from the serial port . also how can i clear the buffer.
View 6 Replies[URL] Using this I have managed to use Server Side Web Methods to perform actions with AJAX.In most instances, I just need it to do stuff (save things to a database for example) so don't need to do anything with the response, but now I've come across a situation where I do, and I can't work it out!The Web Method returns a JSON object, which looks like this:
{"d":"[{"validDetails":"True","lateAlert":"","LoginResponse":"Logging in Jamie at 16:53 please wait"}]"}
This is the output shown from Firebug. I am not sure what the 's are, but bear with it...The AJAX call and attempt at outputting this response is:
$("form").on("submit", function () {
var LogonObject = new Object;
LogonObject.password = $('#password').val();
[code]....
And several other variations from info I have found on Google and SO, but it seems to treat the results variable as a string, not an array, and the output I get on the alerts is each individual character, ie;
[, {, ", v, a, l, i, d, D... etc
So I wondered if results needed to be converted to JSON again (though I don't know why) so I tried
results = $.parseJSON(data.d)
But that didn't work either.
EDIT, the code which generates the response (missing out tons of logic, but this is the important bit):
Public Class OutputObject
Public validDetails, lateAlert, LoginResponse As String 'content of JSON output'
End Class
[code].....
I have the following code to bind data to my form controls:
dateFromDate.DataBindings.Add("Value", dvUpdateCME, "From Date")
dateToDate.DataBindings.Add("Value", dvUpdateCME, "To Date")
[code].....
how to read all the tables returned by SQL Stored Procedure? My Stored procedure returns two tables:
ID Name
-----------
1 Jeff
2 Joe
[code]....
i want to read data from both of these tables. I tried using SQLDataReader and then populating into datatables but then i can only read the values of 1st table. I want to read both the table values. How do i do it?
I have been prototyping a simple site search tool.I found some online references to using webclient.download data. I have a (mostly) working prototype, but it only returns static HTML on the page that is being searched.I also would like to be able to search the contents of controls (such as text in label controls that are set at run time.) In the code below, the data in label1 is not returned.[code].....
View 3 RepliesI have two functions written in VB.NET:
1) The first function (call it GetValues()) returns values in a SQL database as a list via a stored proc. One of the fields is DateTimeSubmitted. All of this data is displayed on my webpage using a repeater control. It works fine.
2) The second function (call it NiceDate()) I created to change the DateTimeSubmitted to a nice date such as "one minute ago" or "yesterday".
My problem is I have no idea which is the best part of the process to do the conversion (at point of data extraction or in pageload etc.) or in fact how to do the conversion.
Can any one provide me the link or give me an idea how to read all the tables returned by SQL Stored Procedure?
My Stored procedure returns two tables:
ID Name
-----------
1 Jeff
2 Joe
ID Pages
----------
1 2
i want to read data from both of these tables. I tried using SQLDataReader and then populating into datatables but then i can only read the values of 1st table. I want to read both the table values. How do i do it? please let me know if you guys have any ideas how to deal with this.
I'm trying to re-write an old VB 6 OCX into a VB.net DLL and I'm having problems accessing the object returned from a COM object. Here is a snippet of the old VB 6 code: Dim objResult as Object
[Code]....
I have a program that calculates commission, but if the commission is nothing then I do not want it to show a zero commission. I want a message box to show a message that there is no commission earned.
View 1 RepliesMy colleague gave me a DLL that manage all database business. I wanted to invoke a function that uses Stored Procedure and return the search result. In the function receive a parameter type in ystem.Data.IDataParameter[]. Below is my codes.
[Code]...
I have a function (on vb.net) to get a data from a XMLWebService:
[Code]...
I added this lines in the form load of DataGridPrinter by Merrion in the codebank..[code]Unable to cast object of type 'System.Data.DataViewManager' to type 'System.Data.DataTable'.
View 2 Repliesevery time i run this code i get the same error
Unable to cast object of type 'System.Data.DataTable' to type 'System.Data.DataView'.
the code is
Dim plmExcelCon As New System.Data.OleDb.OleDbConnection
Dim cmdLoadExcel As System.Data.OleDb.OleDbDataAdapter
Dim PrmPathExcelFile As String
[Code]......
[code] "The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.The statement has been terminated." [code]
View 6 RepliesI have one question. i have seen some codes like:
Req = CType(System.Net.HttpWebRequest.Create("url"), Net.HttpWebRequest)
Is it really necessary to cast the same type, or is there a difference when its not casted.
I have a number of controls (Device1, Device2, etc.) that all inherit from BaseDeviceControl. In the DragEnter event handler I am trying to test for the correct type by using the BaseDevvceControl like this....
[Code]....
I am pulling data from a local MSSQL database using a stored procedure, then send the data to a web service. Every part of the component works well except for a pesky problem will a DBNull being returned from the DataRow field, when I know that the field is not null and has valid data. The database and associated INSERT statements that add to this field are designed to not allow NULL entries. When I debug break the program on or right before the line that throws the error I see that the field has valid data for the current row.If I add a null check to the code (as below) the operation continues as normal:
Dim dataResultsTable = Me.myViewTableAdapter.GetData(int)
For Each myDataRow In dataResultsTable.Rows
If worker.CancellationPending Then
[code]....
Why is the read operation returning DBNull instead of the data in the database?
EDIT: Just to be clear, the operation does return the proper data, but the data is not being saved into the variable.
<ItemsControl DockPanel.Dock="Top" ItemsSource="{Binding Path={x:Static vmc:clsPersonViewModel.ChildrenPath}, Mode=OneWay}">
<ItemsControl.ItemTemplate>
[Code].....
In the code above, if there are no children (the ChildrenPath property returns NULL), nothing is rendered in the view. In the code below, when ChildrenDataSetPath is NULL the XamDataGrid still gets rendered. How do I achieve the same for a single object (as opposed to a collection) as the datacontext?
<DataTemplate DataType="{x:Type vmb:clsPersonViewModel}">
<igDP:XamDataGrid DataSource="{Binding Path={x:Static vmb:clsPersonViewModel.ChildrenDataSetPath}}">
[Code].....