Search results for query: *

I have a winforms application & depending on the user selection regarding SQL authentication there are 2 possible connection strings :- - using (var con = new SqlConnection(String.Format("Data Source={0}; database={1}; Integrated Security=True", Sql_ServerName, Sql_DataBaseName))) - using (var...

Not sure why this has been moved to the ADO.NET thread as I'm not using ADO ?? Thanks jmcilhinney - it was a mistake in my code example rather than my app. Discovered that I had to format the string first. All working now :)

Hi, Not sure why this has been moved to ADO.NET as I'm not using ADO ?? Thanks

Ok - here goes...... - User selects to import data (from .csv or .xls) - OpenFileDialog launches & User selects file - File is read into OriginalDT & the column headers are extracted to populate a ComboBox list - The User then selects the appropriate column to import from the ComboBox list...

Hia all, Hoping you're all having a great festive season !! Quick question to pose :- I've a DataTable that has a single column and houses data in string format (as imported from external files). I'm now moving this data to a secondary DataTable and would like to apply some conversion /...

Hi jmcilhinney, Happy festive season to you. Thanks for the reply - I've managed to resolve the questions though by placing all the DataTables into a seperate class & made them public. This has led to additional queries which I'll post shortly. KR

Hia, I'm looking to move data between two DataTables (with a twist) & am looking for some guidance...... I have a WinForms application that works as follows :- - Form_A is the main form & has graphing elements on it - Form_A has two DataTables (a RawDT & an AnalysisDT) - Form_A calls...

Thanks for the reply - dgcolumn1 is indeed a string variable. Turned out to be a simple error - I had part of the code relating to dtRaw in the incorrect scope (sigh).

Hi all, Hoping for some pointers / advice......... I have a winforms application that imports data from a flat file into a datatable. I need to select certain columns from this import & use there to populate a second datatable, as well as a dataview grid. The following is the code that I am...

Many thanks jmcilhinney - that worked a treat.

Hi all, I have an Excel spreadsheet that I am importing into a datagridview in a winforms application. Unfortunately the Excel spreadsheet comes from an external source that I have no control over and they often change the column order, headings, etc. All in all I cannot rely on a specific...