Click here to Skip to main content
15,923,015 members
Home / Discussions / C#
   

C#

 
AnswerRe: MultiThread Programing Pin
Yosh_29-Jul-08 5:00
professionalYosh_29-Jul-08 5:00 
AnswerRe: MultiThread Programing Pin
Yosh_29-Jul-08 5:01
professionalYosh_29-Jul-08 5:01 
AnswerRe: MultiThread Programing Pin
Guffa29-Jul-08 6:34
Guffa29-Jul-08 6:34 
AnswerRe: MultiThread Programing Pin
Joe Woodbury29-Jul-08 9:24
professionalJoe Woodbury29-Jul-08 9:24 
Questionjavascript for grid view checkbox Pin
umeshdaiya29-Jul-08 3:14
umeshdaiya29-Jul-08 3:14 
AnswerRe: javascript for grid view checkbox Pin
leppie29-Jul-08 4:51
leppie29-Jul-08 4:51 
QuestionCannot pass params! Any ideas? Pin
FruitBatInShades29-Jul-08 2:56
FruitBatInShades29-Jul-08 2:56 
AnswerRe: Cannot pass params! Any ideas? Pin
J4amieC29-Jul-08 3:00
J4amieC29-Jul-08 3:00 
GeneralRe: Cannot pass params! Any ideas? Pin
Luc Pattyn29-Jul-08 4:00
sitebuilderLuc Pattyn29-Jul-08 4:00 
GeneralRe: Cannot pass params! Any ideas? Pin
J4amieC29-Jul-08 4:27
J4amieC29-Jul-08 4:27 
GeneralRe: Cannot pass params! Any ideas? Pin
FruitBatInShades29-Jul-08 22:47
FruitBatInShades29-Jul-08 22:47 
QuestionRe: Cannot pass params! Any ideas? Pin
Luc Pattyn29-Jul-08 3:11
sitebuilderLuc Pattyn29-Jul-08 3:11 
QuestionHttp traffic from IE Pin
George_George29-Jul-08 2:31
George_George29-Jul-08 2:31 
AnswerRe: Http traffic from IE Pin
J4amieC29-Jul-08 2:45
J4amieC29-Jul-08 2:45 
GeneralRe: Http traffic from IE Pin
George_George29-Jul-08 3:15
George_George29-Jul-08 3:15 
QuestionDynamically Add Columns to Existing DataTable Pin
MumbleB29-Jul-08 2:20
MumbleB29-Jul-08 2:20 
AnswerRe: Dynamically Add Columns to Existing DataTable [modified] Pin
paas29-Jul-08 3:02
paas29-Jul-08 3:02 
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.

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.