[ASP .Net - Microsoft Visual Web Developer 2010]I've problem with this code:
[Code]...
Then, using that xReader.Read, store the value on the database onto that label based on the OrderNumber...
In our application we use IDataReader which actually call function from one.dll where weExecureDataReader()
We have many calls in application and in some places For some reason I am getting error message "DataReader already open" but I am not sure where.What will happend if I simple close that conection in the that .dll? Am I going to make trouble to database because one datareader left opened? I assume closing connection will close reader too and gargage collector will manage that left opened datareader..
I have two cases to extract information from the IDataReader object
Case - 1 - Length, calculates ordinal and then parse string
public static string GetString(IDataReader rdr, string columnName)
{
int ordinal = rdr.GetOrdinal(columnName);
[Code]....
Which technique should be preferred and why and if any specific context ?
how to get all rows in a datagridview values and pass it to new access database in vb format?
View 10 RepliesI have a function that I use to export the contents of anything that implements IDataReader into delimited string (that I can then write to disk or send to a response stream). It works, and it's quick for smaller recordsets but gets bogged down once the record counts get over a thousand (I have something that does the same thing only it writes to a new Excel spreadsheet and it runs in about 25% of the time). I understand that with record sets that are very large, this could cause a memory issue since I'm reading it into a string, but typically these won't be any larger than 100k (if written out to disk). My question is, here's my function, is there anything you can spot that I could do more efficiently (like, I suppose I could stream line by line to the response in asp.net, or line by line to the file on a console app, I haven't tried that).
[Code]...
I have a Stored Procedure that seems to be very slow. Executing it in Oracle SQL Developer;
SET TIMING ON;
DECLARE
CUR_OUT UTILS.T_CURSOR;
P_ARTTYID NUMBER;
P_ORDERST VARCHAR2(200);
[Code]...
Am currently creating an interactive dating sms service using vb.net.but when i get to the point for user to find requested matching records,am only able to get the first 3 records. i want it to be able to move to the next 3 and the following 3 and so forth until end of requested records each time the user sends 'next'.am using a 'do loop while' and a datareader but its not working how i want,below is the code:
ElseIf TextSend.Text.Contains("next") Or TextSend.Text.Contains("NEXT") Or TextSend.Text.Contains("Next") Then
If TextFrom.Text = "" Or TextTo.Text = "" Then
[Code].....
when i click the dgv row for the first time the CurrentGridIndex get the rows index but the second time i change the combbox item without clicking any more rows because it should be selected already i find that the CurrentGridIndex is set to 0any explaination why that happen and how to fix it am i select the rows in wrong code?
Private CurrentGridIndex As Integer
Private Sub ComboBox3_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox3.SelectedIndexChanged
[code]......
'look at the picture
'dtg1.cell(0) = file directory
'im select multi file and i want to chang attrib all file select in dtg1
For Each fl As System.IO.File In dtg1.SelectedRows
System.IO.File.SetAttributes(dtg1.Rows(dtg1.MultiSelect).Cells(0).Value, &H80)
Next
how would you select a row in a datagridview if the number of rows = 1
View 6 RepliesI'm using DGV to display data. I also have a DFVCheckboxColumn. If user checks a checkbox column the data from that row is transfered to database. i'm able to select multiple columns with pressing the CTRL key.But i wanna select multiple rows without pressing CTRL key. Can someone give me samplecode or guide me in this
View 1 RepliesI have the following code that loads an XML file into a datatable (I went this route because I do not know how to query XML directly). I want to use the Select method to return a row where "age = 72". However, I can't seem to get this to work. Also, if there is a better way to search through a datatable for specifc values that would not require iterating through the whole table to get the results
Imports System.Xml
Module Module1
Sub Main()
[Code]....
The following VB line, where _DSversionInfo is a DataSet, returns no rows:
_DSversionInfo.Tables("VersionInfo").Select("FileID=88")
But inspection shows that the table contains rows with FileID's of 92, 93, 94, 90, 88, 89, 215, 216. The table columns are all of type string.
Further investigation showed that using the ID of 88, 215 and 216 will only return rows if the number is quoted.
i.e. _DSversionInfo.Tables("VersionInfo").Select("FileID='88'")
All other rows work regardless of whether the number is quoted or not. I understand that the numbers should be quoted just not why some work and others don't?
I'm having the datatable with three columns, i need to return the rows in which the third column having the null values.
ie., I need to do like this below mentioned coding,
Dim rows As DataRow() = ds.Tables("Tablename").Select("col3 is null")
Is it possible? if no, anyone tell me the way to get the results.
I'm writing a program for Employees Management and i need to automatically generate a Payroll for each one then calculate some things and save it to another table.
I know how to calculate and save. I just need to get all the ID column of all rows in my Employees table, and select each Employee ID one by one in order to calculate each payroll automatically.
I created below, this function gets all values in each cell of excel, but i do have a problem with this because its taking minutes to display the text from each cell, is there a way that i could make a function or call a excel method or property to get all values in a worksheet and put it in a string so i could display it.. actually our main purpose is to store all data that we could get into the database for reference and search criteria.[code]...
View 3 RepliesI have this function that i created below, this function gets all values in each cell of excel, but i do have a problem with this because its taking minutes to display the text from each cell, is there a way that i could make a function or call a excel method or property to get all values in a worksheet and put it in a string so i could display it or store it in a single column in our database.. actually our main purpose is to store all data that we could get into the database for reference and search criteria.[code]...
View 1 RepliesFor a project i am working on, i am taking bookings. These bookings are stored in a database alongside a users personal details. The personal details are assigned an ID according to the user who booked it. A user can book more than once with different personal details.
My problem is that i want a user to be able to edit a booking. I want a list of all the names that user booked to be listed in a combo box. This is the part i am having trouble with. i am using an access database and using sql statements to pull out the data. This is what i have tried so far:
SELECT [First Name]
FROM PersonalDetails
GROUP BY [First Name], UserID
HAVING (UserID = ?)
If i execute this query in the query editor, it works and shows the two records currently assigned the input id. However, if i try to output this to, for example, a text box, then it remains blank. I am assuming thisis because there is more than one output, but i'm not sure.
I am trying to get distinct rows based on multiple columns (attribute1_name, attribute2_name) and get datarows from datatable using Linq-to-Dataset.[code]How to do thin Linq-to-dataset?
View 3 Repliesi have datagridview with rows in it and one of the col show type of product. there are row with same type. on click of button i want to select all the row where productype = 1 (for example)
do i have to go thru each row in grid and check the condition for product type and then select it or there is another quick method.
How to select the ListView rows by using up down keys instead of clickng each row everytime?
View 2 RepliesI would like to select a number of rows from a table and out of those I need away of selecting a column from the last row?
View 8 RepliesI want the user only to be able to select rows and not individual cells in a VB.NET DataGridView. Is there a way to make this happen? I don't see an option for the DataGridView object to control this via properties.
View 2 RepliesI have an EnumerableRowCollection that looks like the following:
VendorCode | GroupType | Variance
01165 G .16
01165 G .16
01165 CH .16
01165 CH .18
07754 G .25
07754 G .25
07754 G .39
Essentially, this is a massive list of vendor codes, their groups, and price variances. I need to compose a query that will create a distinct list vendor codes and group types. The catch, however, is that I need to evaluate all of the variances associated with that particular VendorCode/GroupType to see if they are all the same - it they are not, I need to return some way of signifying that the group has a "custom" variance, otherwise it needs to return the value (ie: if they are all .16, then return .16, if there are multiple values, return "custom")
The result would look like this, based off of the list I showed above.
VendorCode | GroupType | Variance
01165 G .16
01165 CH custom
07754 G custom
I have no trouble getting a distinct list of VendorCode/GroupType - this is what I have so far:
Dim distinctList = From q In query Select q.VendorCode, q.GroupType, (evaluated q.Variance here?) Distinct
(where "query" is an EnumerableRowCollection(Of (anonymous type)))
I'm at a loss, though, on how to evaluate the variance property to get the result that I need?
I'm am creating a "pop-up" CheckedListBox over a button on my DataGridView. The values in the list are going to be filtered based on the value in column 0 of the DataGridView.I have already pulled in a "master" DataTable with two columns: ACODE and MATRIX.I want to call the following function and return an array of strings that I can use to build this CheckedListBox with. The line between "For Each r" and "Next" generates a "Number of indices is less than the number of dimensions of the indexed array". The number of items is variable in the array so I can't predefined it. I know I'm going down the wrong path.
Function StudyGroupSamples(ByVal sampleType As String) As String()
Dim thisArray() As String
Dim theseRows() As DataRow
[code]....
Is it possible to add a button column to a datagridview and then remove a select group of these from rows without removing the rows themselves? That is, I want the ability to hide or remove these buttons in certain rows after certain actions have occured. I realized that I could simply delete the rows with these buttons, but I want to keep the data in these rows visible without the user thinking they have to use the buttons. I am assuming that I can also disable the buton in the desired rows as well.
View 2 Repliesi have a problem to retreive whole rows of a datagridview and transfer to my new access database in vb environment anyone can give me advice or examples of how to do it ? for example my datagridview colums have JOB_NO, ERR_DESC , REMARK
now i would to post all row (not selected datagridrow) from this datagridview to my new database .. i search at google using row count may do the job but i still fail on ...
I need to select multiple random rows in DatagridView with keypress.Ex:
Row1 -selected
Row2 -not selected
Row3 - selected
I do have part of code that will update certain field in database on keypress, but i have no idea how to create multiple selection and display it on DataGrid.CTRL+Click is nice, but I would like to have option of selecting rows with keypress.In following code I am checking if certain field is marked for selection(i want to give user an option to start selection, exit program then continue selection later) but it allways select all rows in table (even if only one is marked).
Dim NumRow As Integer
NumRow = 0
Do Until NumRow = dbtShow.RowCount - 1
[code]....
My question is: What is the best way to select multiple random rows in code?
I'm using the following select statement to pull rows of data and display them in a datagrid.[code]This displays sometimes 5,000 different rows of data with one of the columns being time. Their times are something along the lines of 6:08, 6:09, etc. Is there a way I can show only 1 row for all times between 6-6:59?[code]
View 1 RepliesI have added an unbound checkbox column to my DGV. I have two questions on handling it:
1. How to have a checkbox on this Column header, which on checking must check all the rows in the DGV and vice versa?
2. How do i get the Boolean value of the checked rows in DGV on event handling? In other words, how do i know what rows are selected?