I have taken this part from a previous application that works. This does not display any thing in the grid when i watch it it does show that it got 1 row but in reality it does not display it
Private Sub btn_all_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btn_all.Click
Dim con3 As New SqlConnection("xxxx")
[Code].....
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 RepliesThe Random generator works fine. What I have a problem with is adding the rows and columns.
Array
0,0 0,1 0,2 = row total
1,0 1,1 1,2 = row total
[code]....
I have Dataset ds filled up with values Until now I was displaying values in GridView. Now I want that all the rows should be columns and columns should be rows.I have 2 options: Either 1 I can directly convert grid to columns and display it, or 2 I can convert the GridView to html and then write loops to convert. I was trying the 2nd option but I cant figure out how I should do that.[code]With this code I am still getting same as GridView. Please help me for converting rows to columns and vice versa.
View 1 RepliesI have a csv file. I need to open it, delete whole row on basis of a column value, Update few of the column values and save the file as .dat file. I am using VB.net 2010
View 1 RepliesI am stuck on how I go about using the nested for loops.Add code in the Draw button�s Click event to create the number of rows and columns selected, using the character selected Use nested For loops to create the rectangle of characters based on the user selections. The outer loop will control the number of rows. Use the value selected in the Rows combo to determine the stopping value of the outer loop. Use the value selected in the Columns combo to determine the stopping value of the inner loop, which controls the number of characters per line.
Public Class MainForm
Private Sub MainForm_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
cb_Rows.Items.Add(1)
cb_Rows.Items.Add(2)
[code]....
I have a student database in ms-access format with 3 tables
1) class ( classid, classname)
2) subjects ( subjectid, classid, subjectname)
3) students (studentid, classid, studentname)
now i want to create a form to enter exam marks for the students in the following manner:
studentid, studentname, classname, subjectname1, subjectname2, subjectname3, .... subjectname-n
1, student1, class1, marks, marks, marks, marks, marks
2, student2, class2, marks, marks, marks, marks, marks
3, student3, class3, marks, marks, marks, marks, marks
how i can i convert subjectname from row to column and how to write a new table to store exam marks for this purpose.
I'd like to copy some rows of data from a data-bound datagridview to a different datagridview.I thought adding a row would just be like this: [code]The trouble is that, instead of copying all the data from the row and putting it in the correct cells in the other datagridview, it seems to be taking the whole row object and putting it in the first cell, so the first cell contains this: [code]And the other rows are empty. How do I make rows copy properly?
View 3 Repliesi want to make a datagrid with 2 columns and many rows
the columns i want to have databinding with a datatable
i want the 1 row 1 column of datagrid have data from 1 row of datatable
i want the 1 row 2 column of datagrid have data from 2 row of datatable
[code].....
[Code] The code in above had already create rows and columns(row=20,column=8),and all data have already insert into datagridview1 when i click button1. Now i want insert data again when i click button2. Because the datagriview have already create rows and columns. In button 2, i don't want create again rows and columns, i just want insert 10 rows data into datagriview1. Which part that i need to eliminate?
View 2 RepliesI have the following data structure in a data base.
Table File
- File_ID (PK)
- File_Name
I am using Datagridview to show some table data from database. It is working but its appearance is not what i am looking for. Is there a way to edit columns and rows manually ?
This is a list of what i want to do :
1. First of all i want to change column captions. because they are like "Fld_name" etc.
2. There is a column that shows date. I want to write a code for it ( convert date type )
3. I want to add a button at the end of each row and write a code for it ( show detail about that record )
In my application i need to move rows and columns in tablelayout panel at runtime.like how to we are doing at designtime.
View 3 RepliesIn my datagrid, I know the number of rows that it will have - it will always have 12 rows.Can I scroll through the cells downwards via the columns instead of the usual horizontal way via the rows?
View 3 RepliesI am trying to create a console application that computes the row and column sum and prints the elements with the resulting sums for each row and column.[code]My column sum code is currently showing the row sums.and the rowsum code is showing a continuous sum, rather than a sum for just that row.
View 4 RepliesHow do I updatezz data from 2 rows to 2 columns?
tool: vb.net
server: MySQL (SQLyog)
I have 2 tables, membercardlist and memberinfo:
table membercardlist:
------------- ------------ ------------
| AccountNo | CardNo | status |
------------- ------------ ------------
| 9999 | B009 | inactive |
[Code]......
how to print, and got it working pretty well. The text string I have printing into a rectangle, and if a word does not fit it will wrap down to the next line, and then keep going like that, but now I need to split my page into three different areas that will each print different text.I am pretty sure I could draw three different rectangels then draw the text I need on each of them, but is it possible to somehow merge them together into a single rectangle that will be printed?
View 9 RepliesI am trying to calculate an equation every time I change something in the Worksheet. [code] Everytime I try this formula everything locks up. Maybe I could limit the rows and columns to be scanned to D2:F500.
View 4 Replieswhat i need to do is to get some data from sqlserver and send it to a dataset(no problem there) after i get the dataset filled i need to send the columns and rows to a textfile but i have to separate the columns on the dataset with this "|"
View 2 RepliesI have divided the circle into rows and columns and each block(square) formed in the circle is of equal size. I have the X and Y co-ordinates of each square/block. Each block is either defined as good or bad.
Problem: I need to add 2 blocks on the same row and determine if the result is good or bad. If any of the block is bad, the group of two block is called as bad. If both are good, only then group is good. what would be the algorithm for it? I need to do in visual basic language. Also, I need to do more cases like adding 3 blocks and determine if the group of 3 block is good or bad. In this, if any block is bad, the whole group is bad.
Update: When I divided the circle into rows and columns i.e blocks, I remove the blocks that are not in the shape of square. That is, those square/blocks which are touching the circumference of circle are deleted. I can upload the photo tomorrow now.
I have the following table:
----------------------------------------------
ID|Name |City |Phone |IsWorking
----------------------------------------------
1 |Joe |New York |111-111-1111|No
----------------------------------------------
[code]....
I want to change the row color of every row in my DataGridView where a particular column value = "RBF3". I am currently using the DataBindingComplete event which seems to work fine, but it fires every time I change a cells value. I'd like for this bit of code to only fire when the datagridview is first displayed, sorted, or filtered. Is this possible?
[Code]...
I have a datagridview that has 1 combobox column (it will eventually have between 1 and 3 more) but I can't find anything anywhere on how to add rows to this column. I create the columns:
[Code]...
I would like to insert, delete and add rows in tablelayoutpanel1. On my right I have numericupdown1. So, when I chose let say number 5 and then click button1, I would like that in my tablelayoutpanel1 VB add or insert row 5. Same thing with button2 - but this button deletes selected row.[code]...
View 2 Repliesames tile1 to tile 100Array is loaded from a textfile of 10,10 (not stored as a 10,10 just parsed from line to line, which I feel needs to be changed asap)Each tile is then given a corresponding graphic (e.g. grass, water, lava) and soon hopefully I will add interaction with certain tiles
View 2 RepliesHow can I program a multiplication table that will input the x and y as columns and rows.
View 4 RepliesSo I am writing a program that uses ArrayA(10) and ArrayB(10) and uses Do loops to output the sum of ArrayA(1) + ArrayB(1) in one column then the difference in the next column, then the product in the next column, then the quotient in column 4 of a Matrix(10, 4) in a listbox. And continues doing this until there are 10 rows of 4 columns. I was wondering for tips on how I can get this done.
View 6 RepliesThis is my first time posting in a forum like this, so please excuse me if I accidentally break any thread rules (btw, where can i find these?). I am very new to Visual Basic and have been trying to teach myself as I create this program. I have experience with macros in excel so I do understand some of the coding, but definitely nowhere near being proficient. I am using Visual Basic 2008 Step by Step (Michael Halvorson) to teach myself.
I am trying to create some code in my program that will allow the user to open an excel file and then return the number of rows and columns in the worksheet. There will only be 1 worksheet in the workbook (since this is just a small part of a larger program I am writing). I already tested the code that will open the file in another program and it worked fine; the thing that is catching me is the row and column counts. I'm a bit stuck here and was hoping someone could point me in the right direction. Here is the code as follows: Code: I have another sub for a quit button which I chose to leave out. The last line for the MessageBox is causing me problems.
I need to build an interface that allows the user to select a horse from a list. The horses are as follows: horse1, horse2, horse3 and horse4. The application should display the way the horse places with a 1 means the horse won, 2 indicates second place , 3 indicates third and 0 indicates the horse did not place. Application needs to display a summary of each horse's individual performance as well as the performances of the other horses. Table for keeping track of each horse is as follows:
5 races-how each placed
1 2 3 4 5
horse1 0 1 0 3 2
[Code]....