Why am I getting an InvalidCastingException at the ".RowCount = 2" line?
Private Sub frmTesting_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
With DataGridView1
.RowCount = 2[code].....
I have a problem with a datagridview control, when first loaded with existing data it shows the correct rowcount figure.However, I have a function that when invoked triggers an oledbcommand to clear those records from the database (access) and load new ones from a file (excel/text).The oledbcomands work fine, and the gridview refreshes with the new data fine. However, the rowcount after this refresh is always 0, even with records. What I am doing is creating a module for my app that allows the user to specify the column title and types for a file import - and the procedure will read the header row from a txt/csv or excel file automatically.[code]If I just make edits in the datagridview (as in not invoke the above) the rowcount returns properly.If I close and re-open the form the new data appears, and the rowcount property returns fine also, but I don't really want to have to tell the user to close and re-open it before making any changes.I must be missing something on the refresh or with the datatable or adapter side of things.
View 2 RepliesI have an application putting new data into a database so I want to use a DataGridView to display the data. I have a timer triggering every 5 seconds and running this UpdateGridFromDatabase() routine every cycle.
It works, but I can see my application memory usage going up by 10kB every 5 seconds until my computer with 6GB of RAm & 64 bit Windows 7 grinds to a halt! Can anyone see at a glance what I am doing wrong? I am trying to open & close everything as necessary. I have also dimmed two variables outside - I had then inside previously and it didn't make any difference.
I'm not sure about this code. What I wanted to do is to count the number of records in the table that I selected and then add a value of 1 to it to generate a transaction number.
I'm not sure on how to count the number of rows in the reader. So far, this is my code.
Dim intTransaction As Integer = 0
Try
con.Open()
[Code]....
I want to get the row count of my datagridview. I currently use this code below. But the RowCount value is &H7. I have 7 rows displayed in the datagridview. The code below seems to work, but I don't understand what &H7 means. Does it have something to do with Hexadecimals?
' tell user if no results are available to update
If dgv.RowCount < 1 Then
MsgBox("There are no results available to set Ready.", MsgBoxStyle.Information)
Return "Failed"
[code]....
I have a store procedure that updats Table_A
I Have every thing working but i need to display the number of rows afected on update.
in SP i use this: SELECT @@rowcount
to get the rows but i dont know how to display it to a label
How can I autosize my datagrid size depending on my rowcount?
View 1 RepliesI have the following records in DataGrid .see in Pic. On button click, I am scanning thru all the records. Just tell me that dataGrid RowCount is from:
For j = 0 To DataGridView1.RowCount - 2
Or
For j = 0 To DataGridView1.RowCount - 1
Private Sub Button11_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button11.Click
[Code] ......
My datagridview.rows.rowcount always returns 1 no matter how many rows i have in myatagridview?The datagridview is populated by a loop in another function
View 4 RepliesI'm using VS2005. On my old Win XP AMD computer, I developed a stock price chart in VB.net which I could scroll left/right with Hscrollbar. However my old PC failed due to faulty AMD motherboard. Now I'm using an Intel PC with Win XP and same VS2005. My VB.net solution has compiled and runs as it did before - with this difference. Sometimes my scrollbar flashes and sometimes it doesn't. Another thread mentioned "too many controls causing flicker" - but my Form does not have many controls on it. I can't find a property that mentions "flashing" when I search the scrollbar class members.
View 10 RepliesI am having an issue with the SQLCommand query update handling apostrophes. I have a gridview that accepts edited text which might have apostrophes and other such accent characters.The UPDATE keeps throwing errors on the apostrophes in the text entered causing the SQL UPDATE to fail.
Here is the code:
Dim lbl1 As Label = GridView3.Rows(e.RowIndex).Cells(0).FindControl("Label1")
IDVal = lbl1.Text
[code].....
I have a background worker that's checking the status of four services on a remote server.This is setup on a timer (5 Seconds) as below. For some reason it's hanging the UI thread causing the application to 'lock' for a second each tick, I cannot work out why?!
Private Sub ServiceTimer_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ServiceTimer.Tick
_ServiceBGWorker = New System.ComponentModel.BackgroundWorker()
[code]......
I am currently programming a complicated inheritance structure for an Insurance Application. One DLL has classes that can be used and inherited from. DLL Two has Classes specific for our Auto Line of business, however when i attempt to use Object 2 from a Web Application it errors out because one of the classes is ambiguous because it appears that DLL Two inherits a class from DLL One which appears to pull in the entire inherited class. Since the Web app has a reference to both DLL One and Two, One has the class, Two seems to also have it and so compilation errors out with an ambiguous class in the same namespace.
To attempt to get more specific ill try a quick run down.DLL One - PGPolicy.dll contains standard classes with properties and methods needed for every line of business such as:
Policy, Name, NamedInsured, Unit
DLL Two - PGPolicyAuto.dll contains the following Auto specific classes:
Vehicle Inherits from Unit
Driver Inherits from Name
Since PGPolicy.dll contains classes needed by all lines of business and PGPolicyAuto.dll has more specific classes for the Auto line of business, the web application references both of them. The problem is that since Driver inherits the Name class, it appears to create a Name class in the same name space that the PGPolicy.dll has the namespace in, which gives me an Ambiguous class "Name" in the PG.Policy Namespace.
I am running into problems with my compiled .exe on other machines. On some computers it works, on others it doesn't (all using Windows XP with the .NET framework installed). When I run the .exe on some computers it crashes right away and hits the 'Send error report' dialog. On others it runs just fine. I'm pretty sure this has to do with missing components, but how can I fix it so it works for all computers? How do I find out which components are missing?
View 29 RepliesWe are trying to implement Source Control with Visual SVN, Tourtoise, and Ankh. All works well once a project is placed in the repository. But, when you try to open a project stored on your local client, that is not stored in the repository, Visual Studio freezes up. (VS2008)
View 1 RepliesWe are trying to implement Source Control with Visual SVN, Tourtoise, and Ankh. All works well once a project is placed in the repository. But, when you try to open a project stored on your local client, that is not stored in the repository, Visual Studio freeze
View 7 RepliesWhat I'm trying to do is build 16 forms dynamically at runtime (all will be identical). These 16 forms each will display a camera, which is using an ActiveX control made by a 3rd party. I am able to create the forms correctly and provide all necessary parameters for each control, but since I have to declare my own AddHandler event which checks if the camera connected, I need to somehow reference the ActiveX control at runtime, but I can't tell it which form it's on because it says it's not declared.[code]...
View 9 RepliesI'm trying to automate the process of logging into twitterfeed.com, and filling in the information (the feed url and twitter username are pulled from textboxes). I had it mostly working the other day, even if it is a bit sloppy (the only way I could get one button to click is to send 50-some tabs). However, lately it seems to enter in a sort of loop. When I pause the program, Visual Studio indicates that it is the Application.DoEvents in the Private Sub "wait" that is still running even after it should be.
Public Class Form1
Private feed, username, temp As String
' Code stolen off of a website as an alternative to sleeping, or trying to do a timer + while combo like I had been doing
[Code].....
i'm working on something like a slot machine reel spinning with images on it.I've constructed a long image, dynamically, and have that image now stored in memory.I'm able to simulate that image "spinning" nicely by moving it vertically within a panel, and having it repeat. This is taking place in a separate "timer" function.
This seems to move quite smoothly until (on some machines) I output a bit of audio. I'm using the format:
My.Computer.Audio.Play(SoundFile3, AudioPlayMode.Background)
The SoundFile3 is simply a physical path to an audio file.When I call this function for the audio, and when it's not a powerhorse pc, it disrupts the spinning, and the spinning acts a little crazy/random.
Is there a more efficient approach for audio, like storing it in memory ahead of time?I'm tempted to go the multi-thrad approach to try to get the option of multiple sounds at the same time, but I don't know ifthat will help or hurt the situation. And I don't know how that's done.
I have a project in VSTO/VB using a BackgroundWorker that works fine. It is a form that calls for a web page of information. The web page can take a while, so I have the form calling with the BackgroundWorker.I then have an Excel Addin project that has added the BackgroundWorker project. When I call up the form from the Excel Addin project and use the BackgroundWorker to request the web page, it grabs the web page ok. But the work done upon completion, during the BackgroundWorker1_RunWorkerCompleted method, is resulting in an error message:
View 2 RepliesI create an empty boolean array check_state(), and then if a condition is met later in the script, I redim it and save a list of check box states as booleans into the array, and later check the array values, but I can't work out how to do this without causing an error if the array was not defined to begin with
View 1 RepliesI am trying to develop a web application to populate data to three datagrids(datagrid control) using 2003 version, each datagrid has three columns and about 10,000 rows. The problem I got is it only allow load data once, whenever I changed the setting and reloaded data, the Page Can Not Be Displayed error will popout. I tried to remove one or two datagrids, it would allow populate data few more times, eventually will error out.
View 1 Repliesim coding in vb 2008 express, just wondering if its possible to delete the application files folder without causing the app not to run? seems it stores every previous version i have created. is it necessary for them to be there? im using click once to publish.
View 1 RepliesA developer has created a custom control in ASP.NET using VB.NET. The custom control uses a repeater. In certain scenarios, the rpt_ItemDataBound event is encountering a data error. My goal is rather than having the user see the yellow screen of death, give the user a friendlier error explaining exactly what the data error is. I figured I would be able to use a Try/Catch block as shown below throw the exception, however, it appears that the event has nowhere to be thrown to and stops executing at the "End Try" line.
Protected Sub rpt_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.RepeaterItemEventArgs) Handles rpt1.ItemDataBound, rpt2.ItemDataBound
Try
ProcessBadData...
Catch ex As Exception
Throw ex
End Try
End Sub
In VB.NET, I can find where the repeater's DataSource is being set, however, I can not find a DataBind event. How I can capture the exception in this ASCX control so I can report it to the user. The stack trace looks like this. There is another repeater within the repeater that is actually causing the error (rptOther) and I'm able to catch the error, but I can only throw it to the rpt_ItemDataBound. How rpt_ItemDataBound is getting called without a DataBind event.
at Company.WebForms.Control.rptOther_ItemDataBound(Object sender, RepeaterItemEventArgs e)
at System.Web.UI.WebControls.Repeater.OnItemDataBound(RepeaterItemEventArgs e)
at System.Web.UI.WebControls.Repeater.CreateItem(Int32 itemIndex, ListItemType itemType, Boolean dataBind, Object dataItem)
at System.Web.UI.WebControls.Repeater.CreateControlHierarchy(Boolean useDataSource)
at System.Web.UI.WebControls.Repeater.OnDataBinding(EventArgs e)
at System.Web.UI.WebControls.Repeater.DataBind()
at Company.WebForms.Control.rpt_ItemDataBound(Object sender, RepeaterItemEventArgs e)
In a Windows Form on Visual Basic, I have a DateTime Picker for a user to select a time and date from.I'm inserting this value via a parameterized query into an Access Database. However, as I'm running the form, I keep getting the error Data type mismatch in criteria expression.If I remove the parameter from the Insert command, the field enters fine. But when I put it back in, it doesn't work.[code]
View 2 RepliesIm coming from a background of writing vba in excel, but have go to the point where im fed up of having everything running in excel and have started leaning vb.net. i am trying to do something i have done before, but am pretty much rewriting it as having got the end i now see a better way of doing things
Normally Google is full of help full answers but today it isn't, i may be i'm doing something odd or am trying to use completely the wrong tool for the job am happy to be told either.
I am trying to take data from a text file dumped from one of our databases, i have read the (huge) and oddly formatted text file in, converted it to a 1d array = InPutArray
[Code]...
How to I redirect to another page *after* printing document? Things seemed to be working fine until this morning we discussed that users were submitting duplicate entries.The reason for this is that once the user clicks to Submit their request,they are presented with a button that says, ">>>Click Here To Print Form<<<<".
Users are required to print this form but for some reason, they forget to do so.In the event that they forget to print this form, they are taking back to the input screen with boxes still retaining the data they initially entered.Is there a way to redirec them to results.aspx page, whether they print the form or not?
<script type ="text/javascript">
function doPrint() {
var printContent = document.getElementById("pdmyop");[code].....
This code seems to be accurate when comparing to the many examples that are similar on different forums and I would think it should work:
Dim pC As New Process
pC.StartInfo.CreateNoWindow = True
pC.StartInfo.RedirectStandardOutput = True[code]....
When I remove the pC.BeginOutputReadLine() command, the application continues to function, but nothing is added to lbOutput.
With the pC.BeginOutputReadLine() command, it gives the error "vshost.exe has stopped working"
Either way, my batch file does what its supposed to do. Any one have any ideas what I am doing wrong with the process?
I can do the basics when I put controls on a form but this one is a little more complex. I have an application that reads in a .TSV and populates a form with controls based on the number of objects it "reads." So for instance: I have a file that contains 10 people objects and my code populates a form with controls for each person. Easy stuff..Now lets say I have a ComboBox with the items: "Alive", "Deceased", "Unborn". Right next to this I have a textbox for age. Now originally, this textbox is not enabled because the default value for the ComboBox is "Unborn". But lets say when the user selects "Alive", I want that textbox to become enabled so an age can be entered.Obviously from me asking this and the title of this question, I don't know how to go about doing this. I don't really understand events and I learn by example but the MSDN examples don't quite cut it.
View 4 RepliesI created a windows application service that runs every 20 seconds to collect data from avaya cms and then dump it into a database. I did this using a timer. Since I had to have access to the clipboard to get the data and parse it, I had to be in STA. Unfortunately,just putting the STA before the Main() (or any other sub) did not keep the service in single thread mode. So I had to create a new thread and join it like so:
Public Class CMS
Protected Overrides Sub OnStart(ByVal args() As String)
Timer1.Enabled = True
Timer1.Start()
[code]....