Perform A Drag And Drop In Data Grid?
Jun 10, 2011How can i perform a drag and drop in the data grid?
I am trying to make a program that can swap row to row or column to row (vice versa) contents.
ADVERTISEMENT
SQL Data Access: VB2008 / VB2010 - WinForms - Create A Datasourse And Drag / Drop Fields Or Tables On A Form To Create A Grid
Oct 22, 2010I have used VB (versions 2 - 6) through many years; however, I am crash-course training myself into the VB2008 / VB2010 world kicking a screaming. I would like suggestions as to what SQL database access method should I focus more on in my learning process without making me feel that I'm a million years behind. I know I have WinForms where I can create a datasourse and drag / drop fields or tables on a form to create a grid (not really what I'm looking for).
My trouble isn't so much designing the form but in how I access the database. Theres XML, LINQ to SQL, ADO.NET, and many other methods. Not only do I need to grasp these methods quickly but I also need to know what type of projects I should create. What I mean is...I was thinking that I would design a WinForm app; however, I see that there are WPF apps and others to chose from. This is getting deep. I know it depends on the project that I'm working on. My plans are to write an app based off of either an SQL Express 2008 or SQL Server 2008 database. This first app will be standalone for now but may later become multi-user. I know I'm far behind on my learning curve coming from VB6. I have read a bit on VB2005 / 2008 / 2010. I own
both VB2008 and VB2010. I use VB2008 at work. I know ADO.NET is still alive but by what I read online, it's a dying method and is only kept for backward compatibility. XML and LINQ to SQL and other methods are all pretty new to me.
Coding To Perform Addition Of Cells On Data Grid View
Jan 11, 2012i want to know that how can we add two cells of a datagrid view.I have 5 cells, quantity,rate,discount,tax and Total amount.I want to show the total amount in "Total Amount" cell.
View 3 RepliesDrag And Drop - Drag Picturebox1 And Drop It In Picturebox2
Nov 18, 2009I am currently working on a drag and drop project and I was wondering if there is a way to drag picturebox1 and drop it in picturebox2; that will snap to a specific location in the picturebox2?
View 2 RepliesListView Drag&Drop Allow To Drag&Drop Between Form?
Aug 27, 2009ListView Drag&Drop allow to Drag&Drop between form??
Public Class frmModule
Private Sub ListView1_ItemDrag(ByVal sender As System.Object, ByVal e As System.Windows.Forms.ItemDragEventArgs) Handles ListView1.ItemDrag[code]....
Can it be drap and drop item to other form control??How to write the event when mouse up at the other form control?
List Box Drag And Drop The Data
Feb 9, 2010the following code allows me to drag and drop the data, so i can reorder the list box. However, is there are way of seeing the line across the list box where it will be moved to?
[Code]...
Checking For Text Data When Doing Drag And Drop?
Nov 1, 2009I'm doing drag and drop from a list view. In my starting list view's ItemDrag event handler, I say (amomgst other things):
data.SetFileDropList(coll)
data.SetText(CurrentFolder, TextDataFormat.Text)
sender.DoDragDrop(data, DragDropEffects.Copy Or DragDropEffects.Move)
CurrentFolder being a string that holds the name of the folder represented by the list view. In the target control's DragDrop event handler, CType(e.Data, DataObject).GetText evaluates to what CurrentFolder was when ItemDrag was executed.But: e.Data.GetDataPresent(TextDataFormat.Text) always evaluates to FALSE.If I replace "TextDataFormat.Text" by "DataFormats.Text" (in both places) the result is the same. I am asking this although my code does what I want, because I feel that I should not call CType(e.Data, DataObject).GetText before I have established that TextData is actually present. So how do I properly check for the presence of the text data.
C# - Drag And Drop From Excel Cells To A Drag-enabled Task Pane Programatically?
Oct 31, 2010I am using Excel 2007, VS2008 Pro.I am building a VSTO Add-in that requires "drag and drop from Excel cells to a drag-enabled task pane".So far I notice that I can only drag and drop within the cells themselves. It does not allow me to drop into the task Pane or drag past the sheet limits.(http:)[url]...
Note: The task pane has drag drop enabled, I ahve already tested I can drag/drop from task pane to excel but I need to do this the other way around?
Allows The User To Drag And Drop A Xls File Onto The Form And A DataGridView Fills With The Xls Sheet Data?
Mar 25, 2010I have a VB .NET (VS 2008) application which allows the user to drag and drop a xls file onto the form and a DataGridView fills with the xls sheet data. The user than can apply changes to the data or add entries. Data integrity is checked during the load into the DataGridView (duplicates are removed and invalid entries are filtered out). After doing all this the user can click a button and the data is uploaded to a SQL server (2008) DB. I have a primary key set up (row number) and I have a compound key in the SQL table.
It is all working beautifully. Now here is my question:
I want to check for duplicate entries (between SQL server and DataGridView data) before the data is uploaded and commited to the table. What would be the most efficient way to that?
VS 2008 Listview Drag And Drop (preserving The Listview .tag After Drag And Drop)
May 25, 2011I am trying to figure out a way to include the listview's tag field when dragging one listview's subitems into another listview. I am hoping someone here has experience with this. My Listview drag code is below - the two listviews that I am dragging subitems into or from are LV1 and LV3. Also, this is being done in Visual Basic 2008 and the project is a windows application.
[Code]...
Drag/Drop Within A Tree And Drag/drop From Tree To Textbox
Oct 20, 2010drag and drop nodes within the same tree (not between trees) when users drag and drop nodes within the tree, give them the option to move the original node to a new location within the tree OR to just copy the original node in a new location (seems complex but I have a month to figure this out). change the system default blue highlight for selected nodes to another color change the system default cursors for invalid and valid drops (instead of the circle with slash indicating invalid target, i want a red minus) and (instead of the little plus sign with little box indicating a valid target, i want just a big green plus sign) add a red insert line to indicate where the node would be dropped within a tree also drag and drop the text of a node from the tree to a textbox add a "folder" image next to parent nodes and a "document" image next to children nodes
I have looked through the internet but I am having difficulty sorting through all the information available (I see a lot of information for Visual Basic 5 and 6, and those codes don't work for me in visual studio 2008). I can email anyone my code I have so far.
Public Class Form1
Private MouseIsDown As Boolean = False
Public Sub TreeView_ItemDrag(ByVal sender As Object, ByVal e As ItemDragEventArgs)Handles TreeView1.ItemDrag
[Code]....
Drag/Drop In A Drop Down List?
Apr 5, 2011Is it possible to reorder the elements of a drop down list (combobox) via drag and drop?For example, when the list is dropped down, I want the user to be able to drag the items up or down to reorder them. I tried this (and some google searching) but I'm wondering if its just not possible:
Private Sub cmbClassLists_MouseDown(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles cmbClassLists.MouseDown
If cmbClassLists.DroppedDown And Not cmbClassLists.SelectedIndex = -1 Then
[code].....
VS 2010 Perform Row Delete To Datatable Which Is A Datasource To The Grid?
May 11, 2011I want to know how to perform row delete to datatable which is a datasource to the grid.
In details: I have a datagridview (dg) and its datasource is set to dtItem. User will select some rows in dg and press 'delete' button.
dg.DataSource = dtItem;
I will perform a loop and delete the records. Here is the code eg:
foreach (DataGridViewRow drw in dg.Rows)
{
if (drw.Selected)
[Code]....
The problem is it didn't delete correctly. If user selects row index 0 and 1 in dg and delete it, it will delete the first one correctly and then finished cuz no more row is selected in next gridviewrow.
I tried google and didn't find what I want. may be because i don't know the correct keywords I should use to search.
Can't Drag And Drop Right
Jun 23, 2009I want to be able to hold CTRL down to select multiple text entries and drag them all to certain text boxes. Or even one at a time, but once I try dragging another word into the box it replace the first one. Is there any way to just have it add to the text box rather than replace it?
And if possible, place a "-" between each entry?
This is the pop-up form with the listbox that contains the words to drag:
Private Sub ListBox1_MouseDown(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles ListBox1.MouseDown
ListBox1.DoDragDrop(ListBox1.SelectedItem, DragDropEffects.Copy)
[Code]....
Drag And Drop In Wpf?
Jan 20, 2011I am wondering how to do simple drag and drop in wpf? All examples I found over the new were in C#
View 8 RepliesDrag-n-Drop Dll And Exe Only?
Feb 23, 2010How would i set a panel to allow drag-n-drop from explorer to my program, only with dll and exe files though.
View 4 RepliesVB Drag And Drop From LB To DGV
Sep 9, 2009I am writing a small program that has two list box's which are populated from my sql database. I want to drag an item from LB1 to column1 in a datagridview and drag an item from LB2 to column2 in the same datagridview.
I am getting close, but I am having trouble getting the data to drop. I did some testing and I can drop a string, but I am not able to get the string data from my listbox. I just get a datarowview. I see the string inside the "itemarray", but cannot get to it.
Here is my dodragdrop:
LB_OriginalPallets.DoDragDrop(LB_OriginalPallets.SelectedItems(indexOfOldPalletToDrag), DragDropEffects.Copy)
.net - Drag And Drop Objects?
Mar 26, 2012How to implement Drag and Drop multiple objects in the form in Visual Basic. The drag-able object will be provided within the same form but in a different panel. I must be able to delete the object also.
View 1 RepliesAllow The User To Drag And Drop Them?
Oct 20, 2010I am trying to generate buttons and allow the user to drag and drop them.
I have this sub:
Sub Form1_MouseClick(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles Me.MouseClick
Dim nodebtn As New Button
[Code]....
Also if I declare the nodebtn as a global variable, I do not face this problem, the button is dragable. However when I click to add new buttons, no new button is generated, instead a button is generated with the count on it.
Do Drag/drop Within The Same Form?
Jul 10, 2009I have this app that gets the files/subdirectories from a selected one (it stores the files with their icon in a listview), I was wondering how could I drag a selected file from the listview into another directory (outside of the form), let's say the desktop.
How can I do this? I have only found examples of how to do drag/drop within the same form.
Drag & Drop Into DataGrid
Oct 28, 2009In my Project I want to Drag the text of the Text Box into any Particular cell of the DataGrid which ever user wants to,
but my problem is I am not able to find the Coordinates of the cell cell in which user will drop the text and hence not able to put the text into desired Cell.
Code snippet below shows the code in the Dragdrop event of the dataGrid
Dim sText As String = ""
Dim nrow As Integer = 'Need to get this rowIndex
Dim nCol As Integer = 'Need to get this ColIndex
[Code].....
Drag & Drop To Start An App
Jan 29, 2010I have an app that usually sits on the desktop. how I can drag & drop a data file onto the icon, which would start the app and load the data file.
View 15 RepliesDrag + Drop Between 2 Forms?
Jun 22, 2009how can i implement dragdrop between 2 child forms (each containing a listbox)?
View 2 RepliesDrag And Drop A Usercontrol In .net?
Mar 19, 2011I have a usercontrol, UserControl1, which I want to drag and drop on my form, Form1.
View 2 RepliesDrag And Drop Across The Screen
Jan 23, 2010I am very new to Visual Basic, but I am trying to build a simple program, and how to create a drag and drop that works, but I can't seem to figure out how to change the display as I drag across the screen. Basically, right now I have a circle with a line through it that goes across my screen as I drag and what I would like is for it to be the text that I am dragging that drags across the screen, just like a file on my desktop would do when I grab it and try to drag it somewhere else on the desktop. I have put my code in below, how to get rid of the circle with the line through it, and replace it with the actually text that I am trying to drag. I am using Visual Basic 2010
Public Class frmDragDrop
Private Sub labelMouseDown(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles lbdragfrom.MouseDown
lbdragfrom.DoDragDrop(lbdragfrom.Text, DragDropEffects.Copy)
End Sub
[Code] .....
Drag And Drop Between More Than 2 Listboxes
Jan 8, 2010I've seen the code on this site to setup a drag-and-drop between 2 listboxes (and that works perfectly for me), but I have a need to be able to move items between up to 12 listboxes. For example, I move an item from listbox1 to listbox2; at some point in the future, I need to be able to move that same item from listbox2 to listbox3, then at another point in time from listbox3 back to listbox1, etc. When I make these moves, I need the item to be removed from its previous location. I've attempted to modify the 2-listbox code to include, on my test form, a third listbox, but that code copies to the third listbox, and when I attempt to move the item from the third listbox to the second, it, too, only copies and does not remove the item from listbox3.
View 1 RepliesDrag And Drop Filenames Into VB App
Nov 11, 2009I'm a relative novice at coding in visual basic 2008 and am trying to implement dragging and dropping filenames from windows explorer into a listbox within my VB app. My customer wants to do this as opposed to selecting filenames from a directory browsing window.
View 3 RepliesDrag And Drop From One Textbox To Another?
May 19, 2011I noticed the allow drop property for textbox controls. Is it possible to drag and drop from one textbox to another?
View 2 RepliesDrag And Drop In Datagridview?
Jun 21, 2010I'm creating an application in which the form contains one datagridview and 20 pictureboxes.When the DGV is populated, the user will drag a row from DGV and drop in any one of the pictureboxes.The picturebox should able evaluate a column value(say column 1) from the dropping row and according to that it should change its picture.
View 5 RepliesDrag And Drop In VB 2008
Jan 21, 2010How do I drag and drop a control (such as a GroupBox) during runtime from one location on a form to another? I simply want to move it around during runtime.
View 6 Replies