Why does the code below result in 3 rows in my datagrid when there is only 2 rows in my CSV file? I end up with 2 populated rows and one empty row. The CSV file only contains 2 lines. I suspect the logic of the code below.
Do While Read()
row = New DataGridViewRow()
For Index = 0 To FieldCount - 1
[Code].....
I have a VB 2008 program over the Northwind DB customer table.It uses LINQ to add, delete and edit records.
So I load everything into a datatable/dataset first.The Add and Delete occurs when the buttons are clicked on a binding navigator. The edit occurs when a cell is changed, and that row is clicked off. I've set the Customer ID field as the primary key in the DT. I then bind everything together with a binding mavigator.
So far so good, Adding & Editing works nicely the DGV & customer table . [code]...
I have a datagridview that is being loaded from a dataset. This dataset is the result of a SQL Statement (which could be my problem). The MS Access Client table is the main table and contains 2 records, however, after loading the dataset, the row count is 3.
Below is the procedure where I load the dataset and then the DGV.
Public Function LoadClientDataSet()
Try
strSQL = "SELECT A.clientID, A.name, B.phone, B.zipCode, B.stateCD " & _
[Code]....
To add Row programmatically,
Connected Datagridview with datatable
I like to add Blank Row in the datagridview, So
On the Last Cell, CellLeave Event
Datatable1.Rows.Add()
It is adding a row in the dataTable, but adding two rows in the datagridview, why...?
I have a datagridview with a datasource from a MySQL query. Works fine. However, I want to add an extra column and generate some data into the cells. This works fine too and shows up as intended. However, I cannot sort on that extra column and the contents of the cells in the column are cleared out if I sort on the other colums. I realize this is all because of the original datasource, but Im hoping there is a way to "connect" the extra column in somehow?
Grid_SearcherResults.DataSource = dbconnection.bSource
Grid_SearcherResults.Columns.Add("Location", "Location")
'Then some code to set the value of the cells in the new column.. etc
For a WinForms VB.Net application, I use the Bindingsource's filtering capacity to filter data, which is seen in a DataGridview. The BindingSource is from a DataSet, created using the Designer, and the data comes from a Access DB, using JetEngine and .Net 3.5. So basically:
Datagridview.Datasource = xxBindingSource
xxBindingsource.Filter = "[extended filter string with multiple columns]"
This filtering works fine, however, now I included some extra columns in the DataGridView, which I'd like to filter on, too. Of course, when I feed the manually added columns to the Filter of the BindingSource, this doesn't work out.I've done some research, and was not able to find any way to use the BindingSource's filtering syntax on the DataGridview. I'd like to use this syntax though, as I designed quite a nice UserControl and class around it, to provide smooth, fast and simple filtering capabilities.
I have an application that is sending data to another system. every thing is ok, but after my 1st varible I get extra characters in the buffer. my code is something like
Private Sub Reg_ClientInfo()
With My_Reg
.ID = 710
.AppName = "DS;"
[code]....
We are filling a combobox with customer names from a table. select ID, name from tbl_customers order by name The names we are filling with CMB_custom.Items.Add(RSselct("name").Value) Is there a possibillity to put the ID into the combobox? If we select a name from the combo we can get also the ID.
View 4 Replies[Code]....
So func is a function that accepts a string and return a string. In practice, internally, func also utilizez text1, text2. In fact, func can even be a member function with access the object that owns it (something like me or this operator).
And all that can be accomplished without changing the signature of func? How do the compiler do this?
I got a predefined code where extra methods should need to be written for, but I don't know how to do this exactly.
My predefined code is(and may not be changed):
[Code].....
Code: Private Sub PrintDetails(ByVal Sender As Object, ByVal e As System.Drawing.Printing.PrintPageEventArgs) e.Graphics.DrawString("sample", New Font("TimesNewRoman", 10, FontStyle.Bold, GraphicsUnit.Inch), Brushes.Black, New Point(10, 10)) end sub
when i use a print preview dialog to watch this printing is shows onlys and a i know that when i change the graphics unit to points i get it rightbut i don't want to reduce the size of the text i want that much bigger but i want it in 2nd, 3rd pages ?
Is there anyway to add stuff to a program, without having to download the whole program again?
View 3 RepliesDear Sir/Madam: I use VB 2008, where to find an extra Icon? I would like to change the icon on my windows form. Do I need to download, because I already used and registered Visual Studio 2008 Professional. [URL]
View 7 RepliesI have an .net application with 2 processes, communicating using a network stream.The protocol consists of a set of commands, some with parameters, which are sent through the stream to the server. The server processes the command, and sends a response.
The protocol for one of the commands looks like this:
[code]...
Usually, this works fine. Very rarely (probably once every few millions of calls), The reading side gets the wrong values. I added code to trace the values sent and received. This shows that occasionally, the reading side gets two extra bytes, with the value 0, which was not sent by the writing side. These extra bytes appear in different places, e.g. in one case they were between i1 and i2; in another they were between the first and second byte of s2. Does anyone have any idea where these 2 bytes could come from? I checked my code, and every place that writes to the stream is traced, so it doesn't look like they are actually written to the stream. It might be worth noting that s1 is always 0, in the current implementation.
Public Sub WriteTextFile(ByVal SourceToWrite As String, ByVal LocationToWrite As String)
Dim file As System.IO.StreamWriter
IO.File.Delete(LocationToWrite)
[Code].....
This is a module I made to write to a .txt file. Every time it adds a new line with null value. wouldn't really bother me but it adds but then something that only suppose to have like 3 lines in it ends up with 5000 over time, anyone know how to not add that extra line while writing file?
Suppose that I want to implement another method for a class namely hasFiles for System.IO.Directory , How can I do that?
for example if I add <Extension()> _ tag before each function or Sub I can add a new function or method for each Control.
I'm wanting to add two forms to my project that will allow me 1) Pull all the current MS Updates installed and list them in a nice looking grid, 2) Pull a list of all the available updates for the machine. I would love for this to work on XP/Vista/7.
View 5 RepliesIn the top right corner of a SharePoint site the user can select "My Settings" to update their details etc.
I am currently writing an automated app that will update user profiles from an Export we are getting on a nightly basis.
My question is...can i add extra fields to the information that is stored and editable against each user?
For example if I might want to add an "Office Location" field?
I am using WSS 3.0.
VS2010 (SP1) / .NET4 on Windows XP Pro Im having a slight issue with my password hashing function. The following function hashes the supplied password using SHA512 and returns a Base64 string.
[Code]....
I am exporting a sql data table to excel using VB 2008. The export works fine but when I open the excel spreadsheet and click on individual cells, I see an apostrophe at the beginning of the string. Is there a way to keep this from happening in the export?
Here is my code:
Dim strfileall = "C: estdata.xls"
Dim SQL1
As String =
[code]....
I'm getting a late binding error message on this specific section of code: objsys.Sessions(shrd.ocSess) Any suggestions as to why I'm getting this late binding error and how to fix it? [Code]
View 2 RepliesAssuming that I am going to add new record. I use this function to generate the ID for the new record.
Public Function GetMax(ByVal strTable As String, ByVal strField As String) As Integer
Dim cmd1 As New SqlCommand
Dim conn As New SqlConnection(gStrConnection)
Dim no As Integer
Dim str1 As String
[Code] .....
It returns 1. How can I modify this to make it 20120001 wherein the first 4 number (2012) will depends on the year today.
When I insert data from my datagridview to my database an extra row is inserted at the end which contains no data. How can I overcome this issue. Each time I click on a new line in my datagridview and start the enter data, a new line is enabled below. Is there any way I can stop this blank line being inserted into my database?
Dim ds As New DataSet
ds.Tables.Add("Main")
Dim col As New DataColumn
[code]....
I am using a masked text box to format phone numbers. However, I do not want the extra formatting that gets insterted from the masked text box: (800)-555-1212
All I want is: 8005551212
But I still want the user to type it in like this (to make it easier for user):
(800)-555-1212
I am thinking I can run a replace function on it, but I am not sure what event to use. I found a number of tutorials, but not that useful for what I am doing. [URL]
I have a translator and i have everything working, but if you put a space at the beginning of the first word typed, or you have more than one space between words, it crashes and give me "System.ArguementOutOfRangeException"
the code is
Private Sub btnConvert_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnConvert.Click
Dim boolhpunct As Boolean = False
Dim strpunctuation As String
[code]....
I have an array called lines() which is basically an array indicating which lines to read from a file. for example lines(1) = 0 means 'read the first line from the file', lines(2) = 4 means 'read the 5th line from the file' (counting from 0 not 1) The program first reads the file (which has a lot of random lines) so it can identify which lines match my criteria. The way I store the line positions is this:
For i = 0 to noOfLines -1 'total num of lines in file
If count = match Then 'this is my match criteria
lines(x) = i 'store the line in the array
[code]....
I need to return the same results from linq as I get using SQL
SELECT DISTINCT Area, Region
FROM dbo.Regions
Union
SELECT null,'All'
Order by 1,2
I use this for showing an "All" selecting in a combo box
My current linq points to a view that does the union for me but I want to know how to do it right in linq. I can't figure out how to union a row for the null,'All' values.
Public Shared Function GetRegions(ByVal Area As String) As IEnumerable
Dim DB As New SiteDBDataContext
Return From values In DB.uv_Areas _
[Code].....
I am getting extra whitespace characters rendered in my horizontal list of anchor tags below. This is causing a major CSS styling issue for me. I know this question has been addressed as far as a C# workaround is concerned (asp.net mvc razor extra space), but can anyone help me with a VB workaround? I don't have the advantage of curly braces to eliminate all whitespace in a single-line If condition.
I have managed to work around it for now by writing an HtmlHelper extension method, but this dynamic code is only used in one place (the master layout page). It seems to me that this should really be done in the .vbhtml page. Here is the erroneous code, along with commented-out attempts at workarounds. The goal is to create a horizontal list of "sibling" pages based on a site map, with slightly different styles for the current page's link and the link just before it. [Code]
So my program works off a few templates in a folder called "Templates".So far, i have been deploying my program as though it would run from a CD. Deleting the autorun file, inserting the Templates folder myself, and then using a self extracting ZIP to make it easy for the user to install.While this works, i would like to make it easier on myself by just including the Templates folder and the two template files (both .xls files) in the program every time i deploy.I've tried dragging and dropping the folder + files into my solution explorer bin folder but it doesn't work.I'm using Visual Basic 2010 Express.
View 1 Replies1. I get an empty page at the end of a report. I have 4 pages instead of 3, 8 instead of 7 and so on. I see and print these empty pages. The report width less than the page width minus margins, so this cannot be the reason of my problem. How can I get rid of these pages?
2. If I have a few controls ReportViewer then to print the report I must to press each print button on each ReportViewer, and each ReportViewer prints with a new page. Have I possibility to print all the ReportViewers consequently pressing one button and to continue the report?