I have a database and I was thinking about using either a List Box or Data Grid to show the data. Is there is another way of showing the data? Also, when the user 'double-clicks' on the data in the List Box or Data Grid then I would like the information to come up in a new form. I know how to show a new form but I don't know how to get the information from the one that has been clicked.
View 12 Replies
I'm working in VS 2008, vb.net. I have a data grid that is getting filled based on a store procedure. When I preview the datagrid, I will get 29 rows back. This includes rows that have NULL values in it. And that's what I need. But when I run the program, it will only return in the Datagrid 12 rows, the rows that don'r have any NULL values. Where or how can I change it so the DataGrid will show NULL values?
View 2 RepliesI am using Visual Basic 2008, and SQL Server 2005. I have a single-user client-server app (i know that sounds stupid, but its for future expandibility and also the fact that documentation was easier to find for SQL server than Access files).The app is basically a medicals records system.
In one of the tables, called 'visits', it stores the dates on which each patient visits the doctor, among other things like symptoms and diagnosis. Another table stores all the patient names and IDs along with other details, and a relation has been set up between the patient ID in the patients table and the visits table. So i dragged the visits table from within the patients table (to get only the visits for that particular patient), and dragged it onto the form to make a datagridview. However, the datagridview didn't seem to recognise MS SQL server's smalldatetime format, and tried representing it as a picture. When i changed the format of the column to text boxes, it gave me a type mismatch error (Inconvertible type mismatch between SourceColumn 'VisitDate' of DateTime and the DataColumn 'VisitDate' of Byte[].) That means, for some reason, it is trying to convert the smalldatetime data to byte before it shows it, which is leading to the error. How do i fix this?
Also, I remember seeing some option for using completely custom column types in the datagridview, but i cant seem to find it now. The options in 'Edit Columns' are very limited, but i would like to set it to a masked text box, or something with a fixed format. Can someone recommend a good column type for representing dates, and how to make the datagridview show that kinda column?
[code]...
it shows up correcntly on the datagrid view though with the same code above expect the bit in bold changed. How would I get the data to show on the listbox?
I have a query (qryTallyMedalInformation) that i bound on datagridview and it has 5 columns ( country, athlete, medal, game and date). Instead of having country in the datagrid, I want to use it in a combobox to display records base on country selected.what i did (with wizard) doesnt work fine though. My country combobox shows duplicate data and the datagrid is showing all the records from different country. In one word I JUST DID NOTHING.
View 12 RepliesI set up SQL Server 2008 loaded VS2008 and all the ODBC drivers.All ODBC connections for DS and DGV's and using connection strings. I managed to get the connections working when I tested this on a new program.When I copy all the files from my other computer and try to view this it works with the connection string and connects to SQL server fine.But with the dgv I see nothing. Yet if I preview the datasets I get the result I am expecting
View 3 Replieshow can i get data from mysql table and show it in listbox in visual basic 2008
mysql table
id
filename varchar 255
filetime timestamp
and it is windows application
Searching for data in Access then showing output with VB 2008
View 6 RepliesI want to work with datagrid. I want that when I select any value from combobox of datagrid (value in combobox come from database) the textbox of same datagrid show the value of sleceted combobox no from same database. I select a item no form database in combobox of datagrid now I want textbox of datagrid show the item name related to the particulars of a particular item number.
View 1 RepliesI am trying to run a routine to load a gridview from a sql table. I would like a progress meter to run until the grid is loaded. I have tried using the background worker component...but I havent found a really basic example of how to run the progress meter on the uiwhile loading the grid in the dowork event.. is this as intricate as it looks? I just have the meter tied to the tick event of a timer
View 2 RepliesIam using vb 2005,sqlserver 2005,vb.net web application in my datagrid properties window not showing the rowcommand. I need create row command/.
View 1 Repliesi have an database and i have a table there name ad "product_order" i have created a form like attached picture..i want o view all of items in datagrid view where customer_id ( a column of database table) = label value of your id and when i will click to view this form this form will load automatically..
Public Class Form8
Private Sub Form8_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
End Sub
[code]....
I m working on vb.net ado.net oledb, I have also added datagrid Control to my form
for retriving database from .Mdb file i used following code
'decleared Name Space
Imports System.Data.OleDb
'Dicleared Variabls in Class Form1
[code]....
how to move current record in datagrid, i mean when i press Next record button then datagrid's data (table) also should move to next record or when i click any record in datagrid, then the current record of dataset also should move to clicked record of datagrid, so that i also may see datagrid's clicked record in textboxes in short i want to use default feature of vb6's ado control, when we bind datagrid with ado control, it worked autometically, both data grid and adodc wer connected each other at a time, so that moving next record also apears in datagrid.
i would like to filter my database for name and surname this is my code and i can't seem to get it right the listbox is showing system datarowview.
Private
Sub search_person_Load(ByVal
sender As System.Object,
ByVal e
[code]....
How do I show a directory into my form, or -optional- filter it on file types?
View 3 RepliesI have the code which gets HTML code and puts it in a richtextbox with seperate lines.I would like the richtextbox to delete each line which doesnt contain a url in it.
View 3 Replieshow to print a data in datagrid..?
View 6 Repliesi would like to check the possibilities to draw out data from a data grid, which is currently showing out some data in it.the datagrid contains 2 columns in it,but will display only one column at run time. The result is assumed to get changed according to some parameter values.
So i need to query the value of first column and i need to use it as parameter for a report in report viewer.i am trying it in VB.NET.Kindly let me know whether the above is possible? if so please do let me know how to start.
I'm trying to have a ListBox show a list of tables available in a database. This can then be selected to be used later on.My problem is getting the actual table name to show up. I have the connection to the mysql database working properly, but it just shows "System.Data.DataRowView"
[code]...
In a project I am doing, I was hoping to show a listbox at the bottom of a label when I click the label so a number can be selected. I don't want to use a combobox or numericupdown because of the look. The problem I have, and I hope can be resolved is that when the listbox is shown, it is drawn under the other controls. Is it possible to show it over the others?
View 3 Replieshow to insert data to a datagrid at run time, like values for the columns will be entered in text boxes and after cliking a button it should get inserted in to the data grid and have to be displayed immediately in the grid.
View 16 RepliesI have DataGrid full of data looks like this.
Cell_0 | Cell_1 | Cell_2 | Cell_3
-------------------------------
string | string | string | string
[code].....
How can i limit the user to enter only certain data in a datagrid. Lets say 0 - 9 only. When the user try's to enter any other char, it should stay 0
View 5 RepliesI need to read data from text file to datagrid. I have a datagrid with 3 columns: Column1, Column2, Column3. I have two columns in my text file, eache is separated by double space. I need to make so that column1 from text file goes to column1 into datagrid and colunm2 from text file goes to column3 into datagrid. Column2 in datagrid will be filled with values from OPC server. So i made a simple
Dim mSr As StreamReader = New StreamReader("C:VBpirm.txt")
Dim mLine As String = Nothing
Dim mArray() As String
[Code]...
I haves textboxes and a ddatagrid and a report. This is how I put the the data of the textboxes in my dataset and show the report, but I was unable to show my data in the datagrid in the report, how can I do? It�s not possible two datasource
[Code]...
I'm working on a mobile project, and I have this:
search textbox (fillby method)
combobox (bound to the data)
datagrid
[code].....
I placed a datagrid in my form which l retrive data from my sql. i am using oledb connection. if i run the form i can retrive the data but i am not getting the data in the grid at first ,there is a "+" sign, i have to clik that then it shows the table name and after clicking the table name i can view the data displays in the grid..
View 1 Repliesi got a listbox and a multiline textbox in my vb 2008 form, how can i make it keep auto scrolling to the bottom line when something new is added to the listbox/multiline textbox?
View 4 RepliesI am making a TimeCard application and I got stucked.. Anyway, the program looks like this: the user inserts date,start hour and finnish hour into 3 textboxes. On the fourth textbox it will show how many hours he has spent. I am using StreamWriter to save the data to a .txt file. My plan is to make this program as simple as possible (no database, access etc.). So, my biggest problem now is how to add all data from textbox4 (the amount of worked hours). I was thinking, to save into a separate txt file the data from textbox4 and then with StreamReader to get it back into a listbox.. but then.. how to add all of them? Im out of ideas..
View 3 RepliesI'm using the 2008 express edition. Now, I created an application that will allow the user to choose transaction in the combobox.text and input its price and quantity using an textbox.text. When the user click button1, it will be push in the datagrid/datable I created. And when the user click the button2, it must be save to excel file. The only thing I need is how to save the data from datagrid/datatable to excel. This is my code.
Imports System.Data
Imports System.Data.SqlClient
Imports Excel = Microsoft.Office.Interop.Excel
[Code]....
