I have the following table:
----------------------------------------------
ID|Name |City |Phone |IsWorking
----------------------------------------------
1 |Joe |New York |111-111-1111|No
----------------------------------------------
[code]....
i try to print data but when i put this code ..my data is repeated example[code].....
View 4 RepliesI have text files with X Y Z data. There are three columns, one each for X, Y and Z and the files are tab delimited.The value of X is constant over a (repeating) range of Y. Z is the dependent variable.
For example:
0 1 44
0 2 32
0 3 22
[code]....
I need something to take this file and break into multiple tab-delimited columns. In the output, I would like the initial range of Y to be the first column (ie 1 to 4). Then, the second column should have the Z values for that domain (X=0 in above example). Then, the next column should have the Z values for the next domain of Y (i.e. 1 to 4 again, but now for X=5 in above example) and so on. Also, I'd like the first line value in each of the new columns containing Z values to be the X-value they were originally associated with.Thus, I'd like the output file to look like
Y 0 5 9
1 44 66 51
2 32 11 72
[code]....
I have a datatable as shown in the figure. Let me explain my required based on this image. I have 7 rows of data. The rows 1 and 2 contains columns till UnitSqcNo same. I want only row 3 among the two. In general I want select all the rows with distinct model, unittype, unit and rest with greater CompId. ie the table should look like
View 1 RepliesI am trying to read and save data into a access Database but using the rows and colunms valeu can
View 1 RepliesActually I am trying to make a datagridview in which there r 3 columns...payment_no, due_date and payment_date. In this DGV I want to show 5 rows (it depends on no of payments) of above 3 columns, something like this...
payment_no due_date payment_date
1 20.02.09 (filled by update query)
2 20.03.09 (filled by update query)
3 20.04.09 (filled by update query)
and so on........
How 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]......
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 am creating a project in VB.NET in which one of the reports require that the name of employees should be displayed as column names and whatever work they have done for a stated period should appear in rows below that particular column.Now as it is clear, the columns will have to be added at runtime. Am using an ODBC Data source to populate the grid. Also since a loop will have to be done to find out the work done by employees individually, so the number of rows under one column might be less or more than the rows in the next column.Is there a way to create an empty data table and then update its contents based on columns and not add data based on addition of new rows.
View 1 RepliesI need to sort an array. I need the most repeated strings at the start and the least repeated at the end. Any easy way to do this? My brain is currently fried
View 7 RepliesI have 4 textboxes, user puts text in it and it should be displayed in 4 columns in a listbox
I have red how to put text in two columns but cant add to third and forth column
ListView1.Items.Add(TextBox1.Text).SubItems.Add(ComboBox1.Text)
Is it posible to multiply the amount in row 4?
I have some values in 4 rov an i will display the sum of them in a textbox?
a checkboxlist control on my page and each item relates to a boolean value column in a flat table on my sql server. I've worked out how to transpire checked listitems into the table ok, but I'm having problems auto populating the checkboxlist with the boolean (selected or not) columns.
View 5 Repliesget specific data from below case?. As it is imported from text file, all row data located at A column per Row and total number of rows are more than 30000. From below, I want to get Company name and Address data only out of long text data.
For your understanding, a)Each row start with 6digits number like 3336041, 3336058 etc and end with pin code 6digits. b) there are minimum 4 or more digit's space after company name and each address data.
Result should be got <company name> and <Address field> data only.
for example 1st block should have below format;
PROCON INSTRUMENTATION PRIVATE LTD
244, G S T ROAD, URAPAKKAM,GUDUVANCHERY TAMILNADU, TAMIL NADU Pin:603202
2nd block: to display in another lines as like above - marked as bold in sample text
3rd block: to display in another lines as like above - marked as bold in sample text
[Code]...
currently i need to use 4 different texts files in order to read data and run my program, is there any way that i can just use 1 text file or 1 excel spreadshee
Dim File1 As New System.IO.StreamReader("C:Documents and SettingsUserDesktopWindDirectionLanding.txt") 'Calling out the file.
Dim File2 As New System.IO.StreamReader("C:Documents and
[code].....
I have a table with several rows of data that I need to return to the controller. In my view, I initially load the table by selection of a time period and clicking a button. The table loads all my relevant records but one of my table cells contains a dropdown list. So I should be able make a selection in the dropdown click "update" and my controller saves the changes.
So everything works until I try and save. The model that is sent to the controller is completely null. The list property I have tied to the table cells returns to the controller null.
[Code]...
NOTE: This is written in VB.NET but C# help is welcome. I am familiar with both languages in MVC.
<VB.Net 2010 + SQL Server 2008 + Linq To Sql>
Let's say I have ten rows on a data grid and I have changed data of three rows.
I am trying to save data by Linq for those three rows, but I am not sure how it is possible to save them.
I can do it by looping whole rows by checking each row for any change.
Is there any smarter way rather than looping by code, such as For Next.
I am trying to select multiples rows from a database table and insert the text into several "label" controls. For example, if the database search returns 5 results. then insert the first row's text into label 1, the second row's text into label 2, and so on. The number of rows will be variable. I was thinking of a while statement. I am having a problem understanding how to even seperate multiple rows from a query in VB. Would using an array for the query results be the right way to go? row one would be row(0), row two's text would be row(1), etc.
View 6 Repliesi 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 RepliesDeclare some class level variables that will keep track of the sums for each column. For example:
[Code]....
During the RowDataBound event, retrieve the data from each column and add it to the appropriate sum. I'm not sure if you are developing an ASP.NET application or a Win-forms desktop application so I cannot help you any further at this point. What have you tried so far to solve the problem?
I 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 have this application which has one class. I need to return a recordset of data to the calling form. If i use Properties to return, it can only return only a single value at a time. Right now i'm returning a datareader object with one of the properties.Can anyone suggest a better way to return multiple rows of data to the calling method via Class Property?
View 1 RepliesI've run into a bit of a roadblock trying to figure out how to programmatically not allow the same data in multiple comboboxes. I'm usnig VS2008 and I have 3 comboboxes on a form, all with the same data, say "apple", "orange", and "red". The comboboxes are nothing more than a user definable sorting method on which gets calculated first. When I use the .SelectedItemChanged event on any of these, I'll obviously be duplicating. Any idea on how I can program to automatically switch the combobox that is duplicated to the value that is missing? I don't want to hard code it as further down the road I will have up to 7 comboboxes. Below is what I started with coding. Not sure if it is the best way to go about it, but it works on 4 of the 6 combinations.
[Code]...
i have codes for adding data to listview from database but there's a problem ..
Public Sub showmyrecords()
Dim lvi As ListViewItem
Dim dt As New DataTable
[code].....
I 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 looking for a howto or someone expert in ADO.NET who can explain me how to properly solve the following scenario:I have two datatables in a dataset:
ParentTable (ParentID, Name) for user data ChildTable (ParentID, ActivityID, ...) for schedule data
Tables are linked together at the database level by ParentID which is an Identity column in ParentTable.
Both tables are data bound to a separate DataGridView on the GUI. There supposed to be a "1 parent/N children" relationship between the tables, meaning if I create a new entry in the ParentTable (a new user) I get a clean DataGrid in the child grid to type schedule data for the user. So I setup two DataAdapters for each table to fill their result into a DataSet. I also set up a DataRelation object and assign it to the DataSet to link the two tables by their ParentID columns. Also when I add a row into the ChildTable via DataGrid I use SetParentRow to set the parent row.
[Code]...
I'm using VB.net 2005. I have working programs that I populate DataGridViews with something like the following:
[Code]...
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 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 vb.net web application and when a particular function runs , i get data timeouts in the rest of the application..(ie..row not found errors or column does not belong to table but it does) The function is adding multiple rows in multiple tables in the database and is running in a for loop. It seems to be all SQL related but I am not seeing anything in the error logs in SQL or in the application Right now I am assuming it is memory related where to start note..the for loop will be replaced with a bulk insert but right now I jest need to resolve the issue of the timeouts
View 1 Repliesvisual basic 2008 express
access 2007 db
I am attempting to fill a form with multiple rows from an access table based off of a parameterized query. My query works fine but I don't want to return one row at a time, I want to return all rows that match my query in multiple text boxes. I know that I can use a datagrid view to accomplish this, but I would prefer the look of a textboxes on a form. I have read through many books and searched the internet forums but think I may just not know what to search for as nothing has worked yet. Can anyone point me in the right direction. So far I have tried setting the text box value to the row().item(), creating a different dataset for each row, and even setting variables for the results of the query to then be passed to the text boxes. Since none of this work, I don't really have any starting code to post. If I could just get a starting point I could work from there, so don't feel the need to code anything for me, just set me in the right direction.