Click here to Skip to main content
15,867,972 members
Home / Discussions / .NET (Core and Framework)
   

.NET (Core and Framework)

 
GeneralRe: c# forms (holy crap i'm not ready for this) Pin
Richard MacCutchan14-Mar-20 22:10
mveRichard MacCutchan14-Mar-20 22:10 
GeneralRe: c# forms (holy crap i'm not ready for this) Pin
Uranium-23515-Mar-20 4:41
Uranium-23515-Mar-20 4:41 
GeneralRe: c# forms (holy crap i'm not ready for this) Pin
Richard MacCutchan15-Mar-20 4:44
mveRichard MacCutchan15-Mar-20 4:44 
GeneralRe: c# forms (holy crap i'm not ready for this) Pin
Uranium-23515-Mar-20 7:40
Uranium-23515-Mar-20 7:40 
GeneralRe: c# forms (holy crap i'm not ready for this) Pin
Richard MacCutchan15-Mar-20 8:00
mveRichard MacCutchan15-Mar-20 8:00 
AnswerRe: c# forms (holy crap i'm not ready for this) Pin
Uranium-2359-Apr-20 23:01
Uranium-2359-Apr-20 23:01 
GeneralRe: c# forms (holy crap i'm not ready for this) Pin
Uranium-23510-Apr-20 10:12
Uranium-23510-Apr-20 10:12 
GeneralRe: c# forms (holy crap i'm not ready for this) Pin
Uranium-23511-Apr-20 16:33
Uranium-23511-Apr-20 16:33 
wait a second I used this

C#
DataTable returnTable = new DataTable();
           DataColumn dtColumn;
           DataRow dataRow;

           MessageBox.Show(fieldCount.ToString());

           for (int i = 0; i <= (fieldCount - 1); i++)
           {
               //MessageBox.Show(sqlite_datareader.GetDataTypeName(i));

               switch (sqlite_datareader.GetDataTypeName(i))
               {
                   case "TEXT":
                       dtColumn = new DataColumn();
                       dtColumn.DataType = typeof(String);
                       dtColumn.ColumnName = sqlite_datareader.GetName(i);
                       returnTable.Columns.Add(dtColumn);
                   break;

                   case "INTEGER":
                       dtColumn = new DataColumn();
                       dtColumn.DataType = typeof(Int32);
                       dtColumn.ColumnName = sqlite_datareader.GetName(i);
                       returnTable.Columns.Add(dtColumn);
                   break;
               }
           }



           for (int j = 0; sqlite_datareader.Read(); j++)
           {
               for (int k = 0; (k <= fieldCount - 1); k++)
               {
                   MessageBox.Show(sqlite_datareader.GetDataTypeName(k));
                   MessageBox.Show(sqlite_datareader.GetName(k));

                   switch (sqlite_datareader.GetDataTypeName(k))
                   {

                       case "TEXT":
                           dataRow = returnTable.NewRow();
                           dataRow[sqlite_datareader.GetName(k)] = sqlite_datareader.GetString(k);
                           returnTable.Rows.Add(dataRow);
                           //returnTable.Rows.Add(sqlite_datareader.GetString(k));
                           break;

                       case "INTEGER":
                           dataRow = returnTable.NewRow();
                           dataRow[sqlite_datareader.GetName(k)] = sqlite_datareader.GetInt32(k);
                           returnTable.Rows.Add(dataRow);
                           //returnTable.Rows.Add(sqlite_datareader.GetString(k));
                           break;
                   }

               }
                 */


to try to load the query into a datatable (unsuccessfully, datatype problems), and you can just use .load()? That was a day well wasted
QuestionEntity Framework Code First is generating an extra column - need some help please Pin
simpledeveloper9-Mar-20 9:44
simpledeveloper9-Mar-20 9:44 
AnswerRe: Entity Framework Code First is generating an extra column - need some help please Pin
Uranium-2359-Mar-20 14:13
Uranium-2359-Mar-20 14:13 
AnswerRe: Entity Framework Code First is generating an extra column - need some help please Pin
Richard Deeming10-Mar-20 0:55
mveRichard Deeming10-Mar-20 0:55 
QuestionBest way to remotely send/retrieve data (securely) Pin
Uranium-2357-Mar-20 15:03
Uranium-2357-Mar-20 15:03 
AnswerRe: Best way to remotely send/retrieve data (securely) Pin
Gerry Schmitz8-Mar-20 10:05
mveGerry Schmitz8-Mar-20 10:05 
GeneralRe: Best way to remotely send/retrieve data (securely) Pin
Uranium-2358-Mar-20 19:41
Uranium-2358-Mar-20 19:41 
QuestionSending email via .net core 3 using Worker Service Pin
ElenaRez25-Feb-20 4:00
ElenaRez25-Feb-20 4:00 
AnswerRe: Sending email via .net core 3 using Worker Service Pin
ZurdoDev25-Feb-20 4:25
professionalZurdoDev25-Feb-20 4:25 
SuggestionRe: Sending email via .net core 3 using Worker Service Pin
Richard MacCutchan25-Feb-20 4:27
mveRichard MacCutchan25-Feb-20 4:27 
SuggestionRe: Sending email via .net core 3 using Worker Service Pin
Richard Deeming25-Feb-20 4:55
mveRichard Deeming25-Feb-20 4:55 
QuestionProblems with EntityFramwork - compatible Framework Database Driver not found?! Pin
ricardo188515-Feb-20 9:33
ricardo188515-Feb-20 9:33 
AnswerRe: Problems with EntityFramwork - compatible Framework Database Driver not found?! Pin
Gerry Schmitz15-Feb-20 9:52
mveGerry Schmitz15-Feb-20 9:52 
QuestionClosing and Disposing Excel Application Process in C# Pin
Pramod_Kumar14-Feb-20 4:26
Pramod_Kumar14-Feb-20 4:26 
AnswerRe: Closing and Disposing Excel Application Process in C# Pin
Richard Deeming4-Feb-20 4:37
mveRichard Deeming4-Feb-20 4:37 
Questionconverting text file data from string to X,Y,Z coordinates Pin
Sher Shah 11-Feb-20 3:32
Sher Shah 11-Feb-20 3:32 
AnswerRe: converting text file data from string to X,Y,Z coordinates Pin
Pete O'Hanlon1-Feb-20 4:10
subeditorPete O'Hanlon1-Feb-20 4:10 
GeneralRe: converting text file data from string to X,Y,Z coordinates Pin
Sher Shah 11-Feb-20 5:11
Sher Shah 11-Feb-20 5:11 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.