Click here to Skip to main content
15,902,907 members
Home / Discussions / C#
   

C#

 
GeneralRe: Dynamically Add Columns to Existing DataTable Pin
Tuwing.Sabado29-Jul-08 3:35
Tuwing.Sabado29-Jul-08 3:35 
Hi,

I wondering what went wrong!

I've tried on my oracle database and it is working perfectly before posting my solution to your problem.

Here are my exact code which almost the same with your codes.

System.Data.OracleClient.OracleConnection conn = new OracleConnection();
conn.ConnectionString = "Data Source=testDB;User ID=Claims;Password=claim2be;";
OracleDataAdapter da = new OracleDataAdapter("Select Key,Value From System_Setting", conn);
DataTable dataTable = new DataTable("System_Setting");
da.Fill(dataTable);
DataColumn dValue = new DataColumn();
DataColumn dMember = new DataColumn();
dValue.ColumnName = "dValue";
dValue.DataType = Type.GetType("System.String");
dMember.ColumnName = "dMember";
dMember.DataType = Type.GetType("System.String");
dataTable.Columns.Add(dValue);
dataTable.Columns.Add(dMember);



The output of my codes for column count is 4 my columns are Key,Value,dMember and dValue.

Please be specific with regards of actual and expected output, errors and othere information which will help us to resolve your problem.

Thanks,
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 
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 
QuestionRow clicking in ViewGrid in C#.NET2.0 Pin
YSridhar28-Jul-08 23:10
YSridhar28-Jul-08 23:10 
AnswerRe: Row clicking in ViewGrid in C#.NET2.0 Pin
stancrm28-Jul-08 23:19
stancrm28-Jul-08 23:19 
QuestionRegular Expression Help Pin
Paw Jershauge28-Jul-08 22:35
Paw Jershauge28-Jul-08 22:35 
AnswerRe: Regular Expression Help Pin
Christian Graus28-Jul-08 22:48
protectorChristian Graus28-Jul-08 22:48 

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.