Search:

JM- Thank you for this idea, I was finally able to solve the issue. By using Dim dt_test As DataTable = dt_Record.GetChanges(DataRowState.Added) I was able to determine TWO rows were getting added...

Thank you for your suggestions. However, I'm not sure if it fully helps what I was trying to achieve, although I'm sure there is a better way then what I did it.
Only if blnNew=True do I want to...

I did debug my code with breakpoints. In the Immediate window I ran CType(bs_Record.current, datarowview).Item("Room") and dt_Record.Rows.Item(772).item("Room") after the BindingSource.EndEdit and...

Peter,
I'm not sure what the "modern structured programming techniques for control flow" would be for VB.net - I'm used to coding in VBA for Excel. I'm open to anything you have to offer as an...

I'm at a complete loss and very confused. I have two different WinForms that perform almost exactly the same - that is to retrieve data from the database and be able to edit & save that data back,...

I was able to get something worked out to "join" my three tables into a single DataTable. Granted it's probably not the most efficient, but it does work.

The code first creates a clone and copy of...

I am trying to find the correct way to join two datatables, or more, into a single datatable and use it as the datasource for a DataGridView. I have read through all sort of examples and posts, but...

techgnome: I am interested in BOTH open and closed forms. The reason is this; because I save the "visible" setting for each form, I need to know when the application exits if the form was visible...

Thank you, techgnome. That makes perfect sense. I did not realize they were working in "layers." I will have to isolate why, in certain circumstances, windows are opening when their "visible"...

Background: I have an application in which I am storing user settings like window position, size, and if a secondary window is open on application exit. I use these settings to open the secondary...

Background: I have an application in which I am storing user settings like window position, size, and if a secondary window is open on application exit. I use these settings to open the secondary...

I will resolve/delete this thread and create two new threads...

This is a two-part question, but deals with the same things. Mostly.

My.Settings vs. User.Config Entries -
Background: I have an application in which I am storing user settings like window...

While I do state that *ALL* records are pulled on initial load, there is still a pretty complex SQL command to get what I need. I'll post it below. I'm also not sure if I'll be able to optimize it...

I have a WinForm that contains 15 comboboxes (lists of last name, first name, dob, etc.) and a DataGridView used for search results. On initial load the DGV is filled with ALL records from the DB and...

In what regards are you referring? My answer is what I was able to come up with on my own - since I received no answers elsewhere. \

If you have a better, more "approved" way to accomplish the...

After a long time playing around in LINQpad, and then finally re-reading JM's answer to a former question I had, I realized what I was doing wrong.

As per his post:


So... Once I realized I...

I am having some issues with trying to figure out the correct way, or syntax, to join a series of columns from a separate table into a query.

Currently I am testing in LINQpad using two queries; ...

JM: THANK YOU!! I finally have something that works.

It's not pretty and seems excessive for what I'm doing, but it does exactly what I need it to. And I have learned something new!


...

JM: I tried your code as follows but I get an error.
170325


With cboxPhysician
Dim lst = (From e In dbACL.tbl_Physician
Group Join f In dbACL.tbl_Title On e.ID_Title Equals f.ID_Title...

I am trying to convert SQL to Entity and this is the final piece that I can't find an answer for. I need to concatenate name/title columns, but NOT if they contain a NULL value.
Example; if...

techgnome: Thanks! I have seen several examples/posts where they stated that putting DataSource last may solve some issues. I have never had an issue, but you are correct - it's a good habit to...

After enough searching the web (I can't seem to find anything easily) I was able to accomplish everything I needed. That includes returning a DISTINCT list, sorting it, and adding a blank value to...

JM: As I stated in my first post: I have little idea of what I am doing, but I am trying to learn. To give my reasoning; I have 16 tables that hold static values, these values are simply used to...

JM: Yes, you are correct - I do know that parentheses need to be applied to the group. I have actually tried it BOTH ways and still got the same errors. So it's not a matter of where the...

First off, I'll admit that I am not very familiar with EF or Classes, but I am trying to learn.

I am trying to find the best way to fill comboboxes by either straight query to the table(s) using...

Karen - would you be able to give an example, or two, of using these that is pertinent to my code? .AsNoTracking() does not work with my EF query to the stored procedure (see code below.)
I also...

OK, I have given up banging my head on the wall trying to figure out the "best way" to move forward and would like some input from the masses. I apologize if the following is not clear as I have no...

I did as you suggested - create a BindingSourse and bind the DataTable and controls to it - and called the EndEdit before the Update. And you know what? It worked!!! So that tells me that the...

I read through your post, Retrieving-and-Saving-Data-in-Databases, and modified the code accordingly. To answer your question, the Update command returns "1" Which by what you're telling me is that...

Sorry, forgot to mention that there is NO ERROR occurring when the Update command runs.

No, adding that did not solve it. Below is what I used to set the @ID parameter. I stepped through again to verify that testID was setting correctly and the DataTable was seeing the new textbox...

I am trying to update a database with info from a WinForm. I had no issues when using a “normal” SQL update command written by hand (parameters set to the text box values,) but I am trying to clean...

Any advice? Comments?

Any advice? Comments?

I am looking for a better way to fill my DataGridView (DGV) and also fill ~12 Comboboxes (CB). The Comboboxes act like a "filter" for the DGV (i.e. the "Last Name" CB would filter the "Last_Name"...

I am looking for a better way to fill my DataGridView (DGV) and also fill ~12 Comboboxes (CB). The Comboboxes act like a "filter" for the DGV (i.e. the "Last Name" CB would filter the "Last_Name"...