Search results for query: *

Thanks SQLSister. RotorTorque ;-)

bborisev anhd SQLSister, There could be an unlimited number of records, but usually no more than 3. I will know how many files there are because I will do an attachment count in my VB.Net 2005 application. CaseID is an Identity field in tblCases, and a foreign key in tblAttachments. Thank...

bborissov, Here is some sample data: Table tblCases (should save 1 record) CaseID = 1 Description = "Error File" Table tblAttachments (should save 2 records) CaseID = 1 AttachmentFilePath = C:\Image1 CaseID = 1 AttachmentFilePath = C:\Image2 I also want the Query to Return The CaseID from...

Hi all, I have an insert query that needs to save data into 2 tables (tblCases, tblAttachments). There could be multiple attachments per 1 Case. Table tblCases Has the following fields: CaseID Description Table tblAttachments has the following fields: CaseID AttachmentFilePath Thanks in...

Hi all, I have a VB.Net 2005 application that I need to add a Help Desk button to the toolbar. The following should occur when the user clicks the button: 1.Take a snapshot of the screen (i.e. Print Screen), and save the snapshot as a .GIF or .JPG file. Another option will be to take a...

AlexCuse, In my ComboBox, if I right-click a dropdown menu appears. One of the options in the menu is Delete. Is there a way to capture the event when a user clicks on Delete? Thanks you RotorTorque :-)

Thank you AlexCuse. RotorTorque. ;-)

Hi all, I use a ComboBox in my VB.Net 2005 application. I allow the users to add items to this ComboBox by entering an items name in a TextBox they then press a button and the item is added to the ComboBox. Now they want to be able to remove an item from the ComboBox if they mistakenly add...

Thank you Sorwen, Do you know how to modify the Border in a ToolStrip control? Thanks once again. RotorTorque :-)

Thank you ZmrAbdulla RotorTorque :-)

Thank you Teamgc. Your solution worked. RotorTorque

SiriusBlackOp, in your code: With ComboBox1 .DataSource = DS.Tables(0) .DisplayMember = "Description" .ValueMember = "Code" '.SelectedIndex = 0 'OPTIONAL End With How would I use the ComboBox1_Click event to get the ValueMember value? Thanks in...

Hi all, I am using the following code in my VB.Net 2005 application to get data into a DataSet and then load a combobox: Public Sub GetSubType(ByVal cbo As ComboBox, ByVal intX As Integer) Dim SQLConn As New SqlClient.SqlConnection SQLConn = New SqlClient.SqlConnection...

Hi all, I have a toolstip control in my VB2005 application. I have added a textbox to the toolstrip. I want the user's to be able to tab into this textbox when they tab through the various controls in the form. How can I do this? Thanks in advance, RotorTorque :-)

Hi all, I used the following code for filling a Dataset with a Stored Procedure 'Declare and Set the connection property Dim SQLConn As New SqlClient.SqlConnection SQLConn = New SqlClient.SqlConnection SQLConn.ConnectionString = My.Settings.HelpDeskConnection SQLConn.Open() 'Declare a SQL...

Thanks for the input chrissie1. RotorTorque

Hi all, What are the benefits of using n-tier architecture? I know it helps with code readability and makes code easier to follow, Especially if you are an Old School programmer. But, as far as improving an application's performance, does it help it? The reason why I bring this up is...

Hi all, If I use bound controls, then is there still a need for n-tier architecture? RotorTorque

Thanks gmmastros. Removing the paranthesis worked. ca8msm, what's the correct command type for a stored procedure in VB.NET code? RotorTorque :-)

Thanks RiverGuy RotorTorque :-)