Try something along these lines:
TextBox1.Text=(dt1.rows(DataGrid1.CurrentRowIndex).item(0).tostring)
where dt1 is the datatable you're using as the data source and you want the data from the first column of the grid to be shown in the text box.
dp.SyntaxHighlighter.ClipboardSwf = '/dp.SyntaxHighlighter/Scripts/clipboard.swf'
dp.SyntaxHighlighter.HighlightAll('381571b4631840c6b8a8abfe5b54ed97')
I have been trying to find and/or think up a way for data to automatically update a data table.I have a log that shows all the customers that came in today with various information. There could be twenty or thirty employees adding to this log or updating or doing things with that customer. This information is in a Data Table on a ASPX page in Visual Studio 2010 that the code is binded in the aspx.vb page that is calling a page in my APP_CODE database file that calls a query in my Database to get the information.My question is could someones actions on a different computer make my computer refresh or to re-bind that data.I have thought of some kind of timer/counter maybe that looks to see if the count of the log is different.
View 2 Repliesi have a data grid in my form.It has 3 colums.On clicking the second col I want to put a value of 1 in there.I tried using datagrid click event but nothing happens in fact the the program wont even go there.[code]
View 2 RepliesI'm curious what we all are using to display grids of data.I keep falling back to LISTVIEW's in DETAIL mode - they visually look nice to me. But I'm always writing code to load them from datatables and such - lots of work.DATAGRIDVIEW's - not so nice looking. Of course we can edit them easily - and they bind really easily
View 2 Repliesi'm trying to pass a variable between two datagrids. The first is on an main form, and the second is in a dialog form.
I tried using functions and also through public variables like this:
Invoice_new (Parent FORM):
Controls:
DatagridView: invoice_items
Public WriteOnly Property ValueFromChild() As String
Set(ByVal Value As String)
[Code]....
an application i developed using vb 2008 express, to fill a web form with data from an access database, one after another when a button is clicked hasn't given me what i expected. the loop was suposed to stop after filling web form with the first data on clicking a button and continue to fill the webform with the next(2nd) data from the database on clicking the button again. Below is the code i wrote
Private
Sub STARTButton_Click(ByVal
sender As System.Object,
ByVal e
[Code]....
I have looked at the answers in the forum and some seem dated. I an an old vb2 person and need to move up. I understand sql very well and use complex queries. First test project and trying to add multiple tables to a data grid (Only Form in project).I used the Data wizard to add the Access data base and worked by way through to near the end. The query works in the wizard and returns the correct rows. The error message is "The solution returned by the new query differs from the base query."
During the creation process I selected all the tables. Reading some of the old anwsers I get the inpression that VB 2010 does not handle multiple tables in a datagrid (forum items go back to version 2008).
I have a window application develpoed in vs 2008, framework 3.5, in which i have put a button.. Now where i click that button the other text boxes are filled up with the data from database thru web service.. what i want is while all text boxes are being filled i want to show an animated loading gif image till data loading is completed in all the text boxes.. i have tried to use image picture box but while data is loading gif image is displyes but in static mode.. cant see animation... i think this is because data loading and animation both are done thru one UI thread..
View 8 Repliesi'm using vb 2008 and i'm wondering if theres any way to get the gui grids back (like in vb 6) and to turn off/make snap less sensitive..
View 2 RepliesIm using a datagrid for user to enter input. However,im restricting the grids to some value.My grid is actually not bounded to any database. so,here is my requirement: whn the form is getting displayed,all grids are getting displayed.,which dont want.,only row2 shld get displayed to user after he'l finish entering values in row1.. im using vb.net as front end and access as backend..
View 8 Repliesi want to know that when im adding my data in form after loading one person data then 2nd person data the 2nd person data cannot come to next line it is adding on the same line.plz tell me wat can i do?
View 6 RepliesI am trying to load a xml file into a data set by loading the information into a data row. when i try to complete the task it throws a nullReferenceException. the row has data in it and i used the code earlier and it work.
[URL]
Imports System.IO
Imports System.Xml
Public Class frmMain
[Code].....
I have a question, I have a combo box, which when changed fills the data grid. Now Wen I change the Tab and come back to same tab again(one containing the combo box)..the value of combo box remains there, however the grid gets empty. I need this data to be maintained till the user selects another value from drop down.
View 1 RepliesI have two grids inside a TabItem and in the code-behind I want to be able to add controls to both grids and have all the controls visible at run-time. Currently at run-time the controls added to "Grid3" are not visible while he controls added to "Grid4" are visible.The overlapping grids have the same rows but a different set of columns.I'm trying to do this with two grids so that I can vary the number of controls I can add per row in the code-behind by adding the controls to one of the two grids.Here's the XML:
<Grid Name="TabControlGrid" Margin="20,171,0,70">
<TabControl >
<TabItem Header="Tab1" >[code].....
The controls in the XML are just place holders for the controls I am adding to the grids in the code-behind.
How are crossword puzzle grids made? I have written a program to generate a puzzle, my problem is the GUI part.I ended up using Visual Basic (VB) because I'm more familiar with that language.However, eventually I have to write this in Java. So far the only way I am displaying the results in a grid-like format is using two controls Groupbox with a Label inside it.This way I can put the number to the word's clue in the title line of the Groupbox, and the individual letter in the Label. To make the cell in the grid editable (my goal for a different version of the puzzle), I guess a Textbox would have to replace the Label.The GUI for real online (professional) crossword puzzle grids is much nicer than this.I know there is a way to combine controls to make a customized one. Even if this works in VB, I'm not certain if it can be done in Java, therefore, I really don't want to go that route (unless someone knows how make customized controls in Java). I have searched the net and looked in books on games, VB and Java with no luck.I need something that I can grow dynamically depending on the grid size needed to hold the content.
View 1 RepliesI am trying to use a grid to display datasets. The database that I am using is not on my local machine. I have to dial in and log in to the database. We are using an image database. I was shown by my boss that he uses MSFlexGrid, but it appears that is no longer available on the newer versions of Visual Studio (he is using VB6). I was wondering if there was a way to display these grids without going through the Data Sources?
View 4 RepliesStarting to design an application and wondering if its ok to have only one form as the application which could hold up to 15 gridviews separated in tabs etc. with a navbar as navigation on the left. Is this too much or ok? Is it better to have one gridview per form? What is the norm?
View 6 RepliesI'm reading in an XML file, to a DataSet. This contains two tables and the relationship is automatically created. I'm using two DataGridViews in an attempt to display the master and detail data.
If I set the datasource of the grids as follows, then the detail view updates correctly:
[Code]...
I am new to WPF but what i am trying to to do is i have a parentGrid with 3 rows, the first two are a menu strip and a toolbar, the third row is a child grid that is populated with the choices that are selected from the tool bar. the problem is that i want the forms that load in the child grid to not have their height surpass what i have set that row equal to in the parentGrid.[code]
View 6 RepliesI dont know if this has been answered but what i am trying to to do is i have a parentGrid with 3 rows, the first two are a menu strip and a toolbar, the third row is a child grid that is populated with the choices that are selected from the tool bar. the problem is that i want the forms that load in the child grid to not have their height surpass what i have set that row equal to in the parentGrid.is there an effective way to do this?
here is basically what i have for code
<Grid x:Name="ParentGrid" Margin="0" >
<Grid.RowDefinitions>
[code]....
I have two grids displaying records of employees like name, job no, and position . Now I have to swap their jobs from Emp A to Emp B which is from one grid to other.
View 1 RepliesI have a bit of a weird issue. We use DevExpress controls to do all our Windows Form development. Anyway, I found a perfect use for the DataRow.SetParentRow/GetParentRow methods in my grid. So I created a DataRelation, added it to the DataSet and bound it as the data source for my grid. The issue is I now find this:On my grid. It seems to be the DataRelation (when I mouse over it the tooltip is the DataRelation name).
View 1 RepliesI am using Visual Basic.Net 2003 with an Access 2000 database.
An integral part of the program that i'm working on is a DataGrid which I am filling from three different queries, based on the user's input. The Grid properties are coded with specific requirements for each of the queries. I have two simple (hopefully) problems.
1) There is no scroll bar on the grid and I can't find a property or event that will allow me to add the Vertical Scroll Bar. How do I do that.
2) The grids contain only four columns each. I want the user to be able to click on a cell and populate four string variables.
which way do you think is best? Using connection As New OleDb.OleDbConnection(My.Settings.CustomerConnectionString & My.Settings.CustomerDatabasePath)
Using command As New OleDb.OleDbCommand("SELECT [customer] FROM [tblCustomers] ORDER BY [customer] ASC", connection)
connection.Open()
Using reader As OleDb.OleDbDataReader = command.ExecuteReader()
[Code]...
Its my first time here. And I'm a new to programming and to VB.NET too so please don't mind if I say or ask stupid things :POkay here's my question. Let's say I have a table which contains student details. (Student Code, Name, DOB, Sex, Address, Contact No) and I have a grid which shows ONLY the student code and the name.
Now What I wanna do is when you double click on a cell, ALL the data related to that particular row should be loaded into a form with textboxes.
I'm trying to load data into a DGV row at a time from a dataset and keep getting the following error on the highlighted line.
Private Sub LoadClientGrid()
Try
grdClientList.Rows.Clear()
For Each row As DataRow In rsClientGrid.Tables("tblClients").Rows
Dim grdRow As New DataGridViewRow
[Code] .....
I have here a huge csv file with millions of rows entries. I want to load this data in a vb.net application, what datatype should i use, datatable, array or sth. else? It needs to be as fast as possible. how i can optimize the loading of the data? I once loaded this data in a datatable and it took days.. then i exportet it as xml data and loaded this xml file with the data. this was about thousand times faster.
View 5 RepliesI have an xml file called "QuotesxmlDoc", in my program I have written code for a search screen that searches the xml file for titles or keywords in quotes saved and the information is then shown in a datagridview, see the code below:
Private Sub btnSearchQoutes_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSearchQoutes.Click
Dim xmlnav As XPathNavigator
[Code].....
On the main screen of the program, I want to show all the saved quotes from the xml file in a datagridview, I just need to show the date, category, author, title of the quotes, I also need the datagridview to refresh everytime a new quote is saved.
Loading into a Datagridview, Nothing seems to work no Error even with test data Added.
Here is some code
Dim SqlConnectionString, SqlCommmandText As String
Dim SqlAdapter As SqlDataAdapter
Dim Table As DataTable
[code]....
I have a small VB program written using VB Express 2008Part of it uses an Access database this all works fine using the custom classes.I want to extend it to use some parameterised settings which I have stored in a table in the same Access database .I want to load these parameters from the table at program startup, then use them later in the code as needed.In SQL I want to execute :-select parameter, parameter_value from system_ parametersthen store this in an array which I want to index on the parameter column/elementAny suggestions on how I can load this data into the array ?
View 1 Replies