Click here to Skip to main content
15,889,216 members
Home / Discussions / C#
   

C#

 
GeneralRe: Dynamically Add Columns to Existing DataTable Pin
MumbleB29-Jul-08 3:08
MumbleB29-Jul-08 3:08 
GeneralRe: Dynamically Add Columns to Existing DataTable Pin
paas29-Jul-08 3:10
paas29-Jul-08 3:10 
AnswerRe: Dynamically Add Columns to Existing DataTable [modified] Pin
Tuwing.Sabado29-Jul-08 3:07
Tuwing.Sabado29-Jul-08 3:07 
GeneralRe: Dynamically Add Columns to Existing DataTable Pin
MumbleB29-Jul-08 3:23
MumbleB29-Jul-08 3:23 
GeneralRe: Dynamically Add Columns to Existing DataTable Pin
Tuwing.Sabado29-Jul-08 3:35
Tuwing.Sabado29-Jul-08 3:35 
GeneralRe: Dynamically Add Columns to Existing DataTable Pin
MumbleB29-Jul-08 9:50
MumbleB29-Jul-08 9:50 
AnswerRe: Dynamically Add Columns to Existing DataTable Pin
J a a n s29-Jul-08 3:12
professionalJ a a n s29-Jul-08 3:12 
GeneralRe: Dynamically Add Columns to Existing DataTable Pin
MumbleB29-Jul-08 3:29
MumbleB29-Jul-08 3:29 
This is the modified code I have now. I only connect to the DB on button click even. From the count at the bottom of the code it picks up the correct table etc but it for some reason doesn't add the new column. I currently have 29 columns in the DB with approximately 2000 rows of data. It returns all that showing that I am successfully connecting and it is reading the correct table.

private void btnAddColumn_Click(object sender, EventArgs e)
{
    conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source = T:\Nasmeea\PSSZ.mdb";
    conn.Open();
    OleDbDataAdapter da = new OleDbDataAdapter("Select * From [DivInfo]", conn);
    DataTable dataTable = new DataTable("DivInfo");
    da.Fill(dataTable);
    DataColumn dValue = new DataColumn();
    dValue.ColumnName = txtboxColumns.Text.ToString();
    dValue.DataType = Type.GetType("System.String");
    dataTable.Columns.Add(dValue);
    dataTable.AcceptChanges();
    conn.Close();
    MessageBox.Show("Column Count:" + dataTable.Columns.Count.ToString());
    MessageBox.Show("Row Count: " + dataTable.Rows.Count.ToString());
}


Excellence is doing ordinary things extraordinarily well.

GeneralRe: Dynamically Add Columns to Existing DataTable [modified] Pin
Tuwing.Sabado29-Jul-08 3:43
Tuwing.Sabado29-Jul-08 3:43 
GeneralRe: Dynamically Add Columns to Existing DataTable Pin
MumbleB29-Jul-08 9:53
MumbleB29-Jul-08 9:53 
GeneralRe: Dynamically Add Columns to Existing DataTable Pin
MumbleB29-Jul-08 19:21
MumbleB29-Jul-08 19:21 
Questionauto select, insert, update, delete ... option in winforms Pin
dream_liner_7e729-Jul-08 1:56
dream_liner_7e729-Jul-08 1:56 
AnswerRe: auto select, insert, update, delete ... option in winforms Pin
Tuwing.Sabado29-Jul-08 3:16
Tuwing.Sabado29-Jul-08 3:16 
QuestionAxInterop.xyz.dll deployment problem Pin
Krazy Programmer29-Jul-08 1:34
Krazy Programmer29-Jul-08 1:34 
AnswerRe: AxInterop.xyz.dll deployment problem Pin
paas29-Jul-08 4:17
paas29-Jul-08 4:17 
QuestionIs there a collection in .NET that combines the functionality of both a List and a Dictionary? Pin
Waleed Eissa29-Jul-08 0:24
Waleed Eissa29-Jul-08 0:24 
AnswerRe: Is there a collection in .NET that combines the functionality of both a List and a Dictionary? Pin
Guffa29-Jul-08 0:48
Guffa29-Jul-08 0:48 
AnswerRe: Is there a collection in .NET that combines the functionality of both a List and a Dictionary? Pin
Frank Horn29-Jul-08 2:17
Frank Horn29-Jul-08 2:17 
AnswerRe: Is there a collection in .NET that combines the functionality of both a List and a Dictionary? Pin
Waleed Eissa29-Jul-08 2:44
Waleed Eissa29-Jul-08 2:44 
GeneralRe: Is there a collection in .NET that combines the functionality of both a List and a Dictionary? Pin
J4amieC29-Jul-08 3:04
J4amieC29-Jul-08 3:04 
GeneralRe: Is there a collection in .NET that combines the functionality of both a List and a Dictionary? Pin
Waleed Eissa30-Jul-08 3:18
Waleed Eissa30-Jul-08 3:18 
QuestionGet Element which is clicked next Pin
ezazazel29-Jul-08 0:01
ezazazel29-Jul-08 0:01 
Questionfind page rand of a site ???? Pin
mr.mohsen28-Jul-08 23:33
mr.mohsen28-Jul-08 23:33 
AnswerRe: find page rand of a site ???? Pin
Guffa29-Jul-08 0:53
Guffa29-Jul-08 0:53 
GeneralRe: find page rand of a site ???? Pin
mr.mohsen29-Jul-08 2:16
mr.mohsen29-Jul-08 2:16 

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.