Search:

rayox,

Nobody wants to read through all of the code to solve a list of vague questions. If you could ask for HELP in learning about one of the issues I'm sure that one of these fine Gurus would...

Thank you Mur16. Apparently I've been an air-head all day. I had pre-defined columns setup in design-view. Problem solved.

Hello all,

I'm working on a project with a DataGridView that is filled using a SQL connection. Is there a way to modify (code-behind) the number/names of columns in the DataGridView based upon...

This sounds strange. Why are you creating a button for each table? And do you have any code yet?

I was able to make a few changes on the application level to force a similar query to work


--Reference Part List Data Table
Select * FROM BoM.dbo.Part, BoM.dbo.Part_Type, BoM.dbo.Part_Subtype,...

30527I am having difficulty creating a nested query for my VB.NET application.
--Attached is my Database Design for reference (ignore cruddy table names).

My main focus is on the Part and...

I had this program working a while ago and I came back to it and am having some issues. I am able to Populate a List from a DataSet well enough but for some reason my initial List persists through...

Hi all,

I am trying to populate a data set with multiple sql tables. I understand that I need to do this with multiple sqlcommands but how do I break up an SQL Statement into seperate commands?
...

Thank you, that's good to know. But I have decided to go a different route (no listview) to get the product my boss wants.

Cheers!

I will have to find a workaround. I fear that creating my own control will be a waste of time for me as I would be learning as I go.
Thank you for your help dglienna.

Listviews do have grouping and I have found samples that group by using IComparer class but never for databound items. The databinding is unavoidable and I don't know what other control I would be...

I am having difficulties finding relevant information regarding listview sorting and grouping. The following picture shows the listview I am trying to sort/group.
30257

I am attempting to group...

I have a combobox and a txtbox. Both are databound. Choosing a value in the combobox initiates the txtbox fill. Right now my event handle for this event is "onclick" but I would like to change the...

Here is what I have for the function so far:



Public Function GetPrice(ByVal Part_Number As String) As Double
Try
Using udtConn As New SqlConnection(sBoMConnectionString)...

While I do know how to create a mathematical SQL query I am having difficulties with creating a statement involving multiple rows, each row chose by one or more attributes selected in the GUI of my...

Dear Hannes,

I would like a clone of you to be peering over my shoulder so that you could smack me in the back of the head every time I make a stupid mistake.

I was releasing the objects...

oWkBk.Sheets("Sheet1").Delete()

This is the error I receive when I try to run the code line above:
"COM object that has been separated from its underlying RCW cannot be used."

I figured this one out by fooling around with my application some more. --Palm to forehead--

Hey guys,

So I've a program that is exporting an excel document. I have two different issues with this:
1. I need to add a worksheet
2. I need to delete the default worksheets (I...

I got it to work! Now I just need to clean it up. Thank you!


#Region "Exports to Excel"
''' <summary>
''' Exports to excel
''' </summary>
''' <param name="sender"></param>...

Sorry about that I have been moving code around trying to fix the situation and I sent the code without this:


oSheet.Cells(PartSections.PartNumber).Value = "Part Number"
...

I am having difficulties trying to format my excel export. The header (Motor Parts) is displayed correctly but the column headers are displaying above the motor Parts header. I think it is an issue...

That's very interesting. I guess I never really took the time to play around with NumericUpDowns before this week. I guess I will leave it as is.

Thanks for the article Hannes!

I posted the wrong code. That code was to check if the message box was working before I found out about the Enter key initiating the msgbox. I did have spnMiscQty.Value > 100 before that.

I do...

I have a numericupdown with a minimum set at 0 and a maximum at 100. However, at run-time a user may input an infinite number by skipping the arrows and inputting numbers with keys. I have tried to...