I am trying to pass the datatable of a search query to another page and bind it to a listbox. The problem is the the listbox just displays system.data.datarowview and no results.
I have listed the code below.
First page SQL and session store:
Protected Sub btnSearch_Click(sender As Object, e As System.EventArgs) Handles btnSearch.Click
[Code]....
I have a session which contains a datatable and also have a function which returns a datatable. I need to add these two. How can I do this? The below code is to be replaced with correct code.
Session("Table")=Session("Table")+obj.GetCustomer() where obj is an object of the business layer.
The '+' sign cannot be used to add these two, so how can I do this?
I have an ASP.NET 2003 web application. There is a .vb module file within that application. Is there anyway I can pass a session variable into this .vb module from a aspx.vb page?
View 2 RepliesIn my project I am using a session table. I am binding this session table to the gridview,in gridview row updating event.I keep the records of session table to a datatable and I use the code below code for updating:
dttable.rows(e.rowindex)("name")="arun"
dttable.Acceptchanges()
My problem is when using PageIndexChanging, I can edit in the 1st page of GridView without any problem, but in second page it is editing the one corresponding to e.RowIndex in the first page, so no change occurs other than the first page in the gridview.
I have set up a class as a facade to access the session variables for my app. In this app I store an entire dataset for a particular employer as a session variable.Within one of the sub pages I have a button that adds a row to an existing table stored in that dataset.
Dim curRow As Data.DataRow = mySession.tWorksiteOtherMeasures.NewRow()
curRow("lngWorksiteID") = getSelectedWorksiteID(getSelectedSiteID())
curRow("strMeasure") = ""
curRow("lngStatusID") = -1
[code]....
When in the code to add the row the row count increments and the row exists. Once out of that scope the page refreshes due to the button being contained in an updatePanel. When that happens and I click the add button again the row counts for that item reset to 0 and 1 after the code runs. The previous added row is gone.Here is how the Dataset is assigned from the web service:
Public Shared Sub loadDSEmployer(ByVal strUserId As String)
Dim myService As New someservice.service
mySession.dsEmployer = myService.GetEmployerAndSites(strUserId, isInternal)
End Sub
I set timeout for 30 mins in web.config like below
<forms name=".FormsAuth" loginUrl="/Login.aspx" timeout="30" protection="All"
slidingExpiration="true" >
<sessionState mode="InProc" stateConnectionString="tcpip=127.0.0.1:42424"
[code]....
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...
in my form, i have a textbox in which its visible property is set to false. this textbox is bound to my table's primary key column.
whenever i try to add a new record, it automatically generates a value and i can see that when the visible property is set to true. now when i set it to false and do a messagebox.show(textbox.text), it shows no value. so i set the visible to true and then the messagebox does show a value.
i don't want this textbox shown in my form but i need to get the value from the textbox when the primary key value is generated.
how can i do this without showing the textbox?
Why is this not working for me? What is wrong with my code below? I am trying to read a stored proc and applying values to labels. Getting error that say "Incorrect syntax near CareerInner".........
Private Sub LoadData()
' Define data objects
Dim conn As SqlConnection
[Code]......
I am passing value via an object property form1 to form2 my class was working before, but I guess when i create the instance of the form2 in form1 my calls in my class no longer work properly.
[Code]...
I am storing a session variable that a user types into a textbox. With their valid input, their session gets created and they get a little more functionality than the regular end users of the site.I was wondering if it is possible to find a way to add someone's session variable to the end of a URL. This way we can email a link to one of our clients, they click it, and their session has automatically begun. They already have the textbox to enter their code into, but I was told that it would be much easier for the users to just click a link that will start their session.
View 1 RepliesI am trying to delete rows from datatable using code below,
View 10 RepliesI'm currently working on a VB .net project that requires connection to a MySQL table. I've no problems loading data from MySQL table to a datagridview. I'm hoping to allow users to make changes to the datagridview and save those changes back to the MySQL table. Below is the Sub I wrote to save the changes. Before saving, it will check if there were any changes made to the datatable. However, datatable.getchanges() does not seem to detect changes made to datagridview (and hence, datatable; I "bound" the datatable to datagridview by means of bindingsource).
[Code]...
On startup of my software which i developed in vb.net, it connects to mssql server. I want to have session id or session number of the connection with mssql. I'm sure it is unique number and i want to use this session in my software for different purposes. My question is
1. is there anything like session id or session unique number when you connection mssql server
2. if yes to 1 then how i can get it in vb
vs2010 vb.net QUESTION1 If i do a select and fill a datatable and want to access that data from another class. How can I do that? QUESTION1 example
[Code]...
adding to the binding source then setting the combobox to selectedIndex of newly added row is not working.the new row is in there but it does not set the selectedIndex to the specified index. but if I run the code a second time it selects it.what can i do to make sure the combo uses the specified index?
Dim drv As DataRowView = CType(Dispatch.M8CustomersBindingSource.AddNew(), DataRowView)
drv("custID") = "999999"
drv("CustomerName") = "Select Customer"
[code].....
I have a DataTable "dt1" that has thousands of rows.
Columns are:
- Type_And_Model
- Val_1
- Val_2
- Val_3
- Val_4
There are only about 30 different "Type_And_Model"-types.How can I insert into a new DataTable (dt2) only distinct "Type_And_ Model" types with the sum of their specific values and total appearance number?
dt1 - DataTable with thousands of rows
Type1 2 2 5 5
Type1 4 2 7 5
Type2 2 2 5 8
Type1 2 2 9 5
Type3 3 2 5 5
Type1 6 2 5 7
Type3 2 7 5 9
Type1 8 2 9 5
.....
INTO =>
dt2 -DataTable with disinct types and their sum values + appearance numbers.
Type1 22 10 35 27 5
Type2 2 2 5 8 1
Type3 5 9 10 14 2
I am trying to display value of the field ("UserID") for every row exists in datatable to checkboxlist(make the checkboxlist item selected).
I used for loop, but only the field value from last row of RoleUsers table is selected in the checkboxlist.
Here is my code
Private Sub DisplayRoleUser()
Dim conn As SqlConnection
Dim cmd As SqlCommand
[Code].....
I have a datatable and I apply a filter to the defaultview.rowfilter property of that datatable. If I then loop through the rows collection of the datatable, will I only be able to see those rows that the filter applies to, or will it loop through all the rows?
View 6 RepliesI am working on a project that takes an xml schema and xml data files and places them into a DataTable, the 2 files are generated from a working table that i have written to disk. I wish to load these 2 files into a DataTable. Here is What i have
vb.net
Friend Function CreateTable(ByVal tableName As String) As Boolean
Dim table As New DataTable(tableName)
table.ReadXmlSchema(tableName & ".xsd")
[code]....
this however produces the following error on line 3
Quote:
System.ArgumentException was unhandled Message=DataTable 'get_item_list' does not match to any DataTable in source.
get_item_list is the parameter passed into this function (tableName)
I have a datagridview bound to a datatable setting its datasource property to the datatable. I would like to have a child form that contains a list of columns associated with the datatable that contains a checkbox that will allow the user to hide and show the columns ( I do not know the best control to use here) (I assume this is the easy part as All i need to do is loop through each of the datatable's columns to get the column name)
now I would like save these visible columns on some event like form_closing so that the next time the user opens the form up it will remember the settings
I came across a problem with using a BindingSource as my DataGridViews.DataSource. Whenever I applied a filter to a column in the BindingSource and the user makes changes that don't match the column filter the DataGridViewRows would automatically disappear. A similar thing would happen when applying a Sort to a column. If the user made any changes the DridGirdViewRows would automatically sort causing rows to be moved around. This was not ideal for my application and there isn't anyway to stop this from happening with the BindingSource.
To correct this issue I have to use subsets of data. I use a DataView to apply the filter and sort to the main DataTable, which creates the subset DataTable.The problem is when I use the DataView.ToTable method I loose the Primary Key and RowError information. So I have to reapply this information everytime the user filters or sorts the DataGridView.Is there a better way to get a subset DataTable?[code]...
I have a datatable that has a resource in one field and hours used in another, it looks like this -
Resource Hours Used
Manager 1
Accountant 1
Field Staff 2
Accountant 3
Manager 4
Manager 1
Administrator 6
Field Staff 4
Manager 0.5
Administrator 1
What I want to do is be able to create a summary of the data table above that groups multiple occurrences of a resource and adds up the hours used for that resource, creating a summary that looks like this -
Resource Hours Used
Manager 6.5
Accountant 4
Field Staff 6
Administrator 7
Is there a simple way to assign a populated datatable's columns to another empty datatable? That is, I want to copy a datatable's structure only but not its data.
View 6 RepliesI'm using vb.net 2010.I have a DataSet with a Table and data. MyDataSet1 which contains Table1 I want to create another table that is the same as the Table1 but without data, but it should have the columns, etc.
View 1 RepliesI am getting array of selected datarows from a datatable.select.I use the commands below to get that array or datarows
Dim foundRows() As DataRow
strExpression =
Here is what I tried.I have looked at examples by MS but they all just write to the screen and I have no interest in that.
For Each rowWork In foundRows
dtWork.Rows.Add(rowWork)
Next[code]....
"LineOfBusiness = 'CPP'"
foundRows = modXchange.pdtWork.Select(strExpression)
Now, I want to place the rows from foundrows into an empty data table.I did what I thought was the obvious but that only returns a bunch of rows with no data
load the contents of a query from a dataTable Adapter into a datatable?
View 2 RepliesI am trying to add NewRow to the database by using datatable in dataset, but before I do that I want to make sure that row is not already there. I create new row for the datatable I am working with, fill it with information. I fill datatable with the row from database that has the same primary key as my NewRow by using tableadapter.fill method, but when I do that my NewRow that was never added to the datatable is filled with information from database(and not information that I assigned to it). I count rows in my datatable before I fill it and it's 0, so why is my NewRow affected by Fill command? (I am using VB.NET 2005 Framework 2.0)
[Code]....
I'm trying to copy one row from DataTable to another, I looked almost everywhere and I can't find a reason why this is happening, I'm using ImportRow and still the New DataTable is empty. Here's one of the answers similar I found and It's still not working!:
Dim newTable As New DataTable
Dim dsFrom As New DataTable
For Each DBShoes In list
Dim iShoeID As Integer
[code]....
how to copy data from datatable to table in dataset i ry this but its readonly property
ds.datatable1=newdt.copy