I would like to know how to select multiple records from a gridview, (ie checkboxes in itemtemplate) and process SQL statements on the records. So in short, its basically selecting records from a grid view by ticking the check boxes, and clicking a process button which then proceeds to execute the SQL statements corresponding to the records selected.[URL]..
View 1 RepliesI have students who will be enrolled into a course. The student grid view has many columns like client_no, student_name, date_of_birth, address, etc. There are over 100000 students so I will need to filter the student grid view to find the correct student to enroll in the course. Once they are found, the user selects them and somehow moves them to the enrolled grid view. If a student drops out then they would be removed from the enrolled grid view.This process needs to be easy to understand and use. Are there any examples available or other suggestions on how to do this?
View 1 RepliesI am writing a program to search computer in the same network.I just get an result array like
[10.10.10.111, 10.10.10.112, ...]
I want to show the result ip addresses in something like the data grid view but I have no sql database.I want to show the result as rows. User can click on any of the rows to "Select" the IP for other processing.
IP
---
10.10.10.111 <-- this can be selected
10.10.10.112
...
is my coding and i want delete the record from grid view and data base also .. but i can only delete from grid view
this my Module coding
Imports System.Data.OleDb
Module Module1
Public con As New OleDbConnection
[Code]....
I need to update a link Table with the data I select from multiple grids, the problem is only the last command statement takes effect, therefore I am only updating the link table from the last command statement, is there a way to update the link table with all the command statements?
Dim ConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|aop29.mdb"
Dim objConnection As New OleDb.OleDbConnection(ConnectionString)
[Code].....
I am creating a simple Website where users will update SQL database. The website works fine however, new records in the SQL database records needs to appended every night from a text file. What is best way to append records in the background every night? have created a stand alone vbscript to append the recoeds to the table in SQL Database hoping to schedule it to run every night but the problem I am facing is when users are using the Website my vbscript fails with the message "The file is being used by
View 4 RepliesI am almost there but for some reason I don't find the answer to my issue. Here it goes. In my application I have a form which displays a data grid view with some info I get through XML from a web server. The data grid view have as first column a Check Box colum. The second column have the information I get into a variable (from cells), one by one, to pass it to the sub with the XML command.
What I want to do is to be able to select all the rows and send the cell info of the second row (only for the selected rows) to my sub which will execute once then send the second cell info and execute the sub and so on until all the loop is complete. Currently my code works only if I delete one row at a time (sending the XML code will delete the info in the web server and update the datagridview which in return will remove the item).
[Code]...
I was working on an app that calls a batch file to do some simple tasks and found out this machine has some issues when trying to run them. really weird! so i did some testing and here are my resultsthis is a little strange to me and i can't think of why this is happening... let's say i have a simple bat file called test.bat these are the contents
@echo off
echo testing...
pause
When i go to run this bat, this is the output: C:>â– @ 'â– @' is not recognized as an internal or external command, operable program or batch file. It seems every bat i make on this machine is being preempted by the block character which renders bat files useless...
I have created tool which performs batch processing on files that are selected. The sub routine I have defined in the code, now I want to implement a way through which I can select actions that I want to perform and then perform the actions. For example the list has multiple actions, like Open, Close, SaveAs, Resize, Color Correct etc. I should be able to select what all I want to do on each file and then perform this actions. Someone suggested me using delegates for this, but I cant use that since all my functions have different parameters. Ither option I had is to use a nested IfElse or Switch to determine which action is selected and call function according to it, but thats to heavy I think, is there any optimized a better way to do this.???
View 2 RepliesHow can I do this, this what I got so far.
Dim ClassID As Integer = 1
Dim da As New SqlDataAdapter
Dim con As New SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=D:Database
[code].....
I am trying have a data grid selection populate a form. I am new to this.Basically I have a connection persistance object and I would like to call that and call a stored procedure with the value of the selection. The datagrid is bound to an object.
[Code]...
i have a form which search data in specific date and show result in the datagridview, what i want is that when delete button is clicked all datas that in the datagridview will be deleted sameway in the database
View 3 RepliesThis is a VB .NET application where we are showing the output of a SQL statement in a Datagrid view. using .NET 2005.We need to get the seperators of the headers on the grid control to be the same colors as the GridColor on the form. See the picture below:We've tried looking through all of the properties of the DataGridView control, and found some interesting things that looked promising such as the DataGridViewAdvancedHeaderStyle, and DataGridViewHeaderBorderStyle, but none of it seems to allow you to change the colors on it.Does anyone know how to do this without remaking the entire thing with a GDI+ control?
View 2 RepliesI have 1 datagridview and i want to transfer all records to another datagridview, how can i possibly do that. Newbie here. This is my code in transferring 1 record to another datagridview to another one.
[Code]...
i have datagridview populated with stock code, name and description.And i have docked my datagridview to the bottom. so whenever the form is resized, the bottom section will be occupied completely with the datagridview.But i want to display one extra empty column and multiple empty rows to completely fill in the datagridview.The extra empty column width will be adjusted to the right end side of datagridview.And the no of empty rows will be generated based on how many is required to fill up to the bottomSo that i can create datagridview with full column and row even though some columns or rows are empty.
View 1 Replieshow to cambine 2 data grid view into 1 data grid view
View 2 Replieshow to view the next record and previous record in the database.? just like in the picture below.? what condition should we use.?
View 8 Repliesi have 4-5 forms and contains grid and some coding is done on selectionchanged event of grid. eveything is working fine but one of the form has this problem.as soon as i call the form form1.show and it fires the selectionchanged of grid before even it fire form load event. i'm not sure why? i try to debugged it step by step, as soon as form.show command is done the control goes to selectionchage event of grid and at the same time it is working fine on rest of the forms.
View 1 Repliesi have 10 checkboxes...i want a short way to check if checkbox1.checked=true and check box3.checked=true.... blah blah blah and so on to do codes...i was using long typeing code like:
if checkbox1.checked=true and checkbox2.checked=false and checkbox3.checked=true and checkbox4.checked=true and checkbox5.checked=true and checkbox1.checked=true.....etc then
msgbox"done"
end if
[code]....
I am making a program which will read data from csv and pick up Username & Computer name from the csv.
Then it will run commands via telnet with those username and computer on line at a time. I have reached this goal without any problem. I wanted to paste the code here but its too much.
Basically what i now want to do is have a option for user to skip a command.
Like if csv have 3 users in it. i.e.
j.doe, comp1
t.test, comp2
u.user, comp3
Popup will come and say do you want to run the command "add user j.doe, comp1" something and you will have option to say Yes, No , Cancel.
Where yes will run the command and no will skip that user (go to next one) and cancel will end the whole process.
I know Msgbox yes,no is there but i dont know how to skip that user.
Following is the code which migh
vb
Dim objCmdSelect As New OleDbCommand("SELECT * FROM " & fileNam & "", objConn)
For i = 0 To objDataset1.Tables(0).Rows.Count - 1
[Code]....
When we left click a grid cell, or list item, it highlights. Left click outside it and the selection jumps to the new place.
I can RIGHT click anywhere in the grid without disturbing an existing highlight, but I want it to work more like windows explorer would in terms of file selection..
i.e. if I right click inside the range, the range stays, if I right click outside the range, the range moves to a new single cell that I just right flicked.
Try it now on this page. Select some text, right click on the selection and it stays. Right click outside the selection and it goes. In datagrid (for example), the selection can only be modified with a left click.
How can we change this so the selection behaviour of a datagrid/list is more like this text pane?
On a related note. If I left click in a textbox I can drag a selection out. If i wanted to right click and drag the selection out, would it be the same process? (It's for a custom string manipulation picker control..)
I am currently creating a merging program which is processing multiple text files with header. I've manage to merge the text files but I'm stuck with the header that needs computation.
path of input files and header explanation: Input Files
After merging, I need to put back the header, adding up each values, which I explained in the path above. How can I do that?
Here's my current code:
Imports System.IO
Public Class Form1
Dim openFolder As New FolderBrowserDialog
'The routines must be
[Code] .....
I am embarking in the wonderous world of 2D animation and using directx9. I am a complete noob in the world of game engine design etc. I find DX quite usefull and in fact easy to use but in my opinion it's the engine design that makes or breaks the application. There are a massive amount of tutorials on the web explaning how to render a single image to a target but not so much for rendering a lot of sprites.
View 3 RepliesI have a requirement. I have a wcf method add and delete which takes person object as parameter. I retrieve these methods into a tree view.
Now, when I click on the node for eg. ADD, I need to retrieve the parameters into another tree view.
Requesting help for this situation.
I am using visual studio vb 2005 and I searched the forums for an answer to this but didn't find exactly what I was looking for. I am using the following code to populate a list box. What I want is to have a datagrid view show the results of a dataset that is generated when a user selects something from the list box. I know how to generate the dataset, but I'm not sure how to bind that to a datagrid view and I'm not sure what event I should use from the list box.[code]
View 6 RepliesI've discovered a problem that's fairly huge in my work environment and unusual. I'd say that it's impossible for it to be happening except that it is happening.
You have a window (we'll call it window 1) open with a page in it, you enter some data on the form, push the button to submit the data...behind the scenes a decent amount of work is going on.While data is processing in window 1 , you open window 2 and try to load the same page that is processing data in window 1.Window 2 will not render the page until window 1 is done doing whatever it's doing behind the scenes and has re-rendered on the screen.This is happening for all .NET pages in our environment.
i've a problem with deleting record from datagrid. i have few columns in my datatable and all publish on to a grid and under "ID" column there are id nos and they are "NOT" unique. user able to search using this "ID" no. problem comes in deleting records since the "ID" is not unique. if i use following command to delete; it deletes all the records which are having same "ID". but i want to delete only the current row records,
sqlDelete = "DELETE * FROM table1 WHERE ID ='" & form1.dgv1.CurrentRow.Cells(0).Value.ToString & "'"
VS 2005 - WinForms - VB - DataGridView Is there a way to have the New Record position to be at the top of the grid? I could do this using Janus Grid?
View 5 RepliesI have an vb 2008 express application that connects to an Access db via oledb (configured by the VB wizard), then from the db it feeds two datagrid views. It works perfectly in my PC however when installing it to other pcs get an exception...
Message: No value given fro on or more required parameters
Source: Microsoft Office Access Database Engine
StackTrace:
System.Data.OleDb.OleDbException: No value given for one or more required parameters.
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)[code]......
my data dosen't display in data grid view in WPF project this is my code is there any mistakes ?
Imports MySql.Data.MySqlClient
Imports System.Data
Class MainWindow
Dim con As MySqlConnection
Dim com As New MySqlCommand
[Code]...