Click here to Skip to main content
16,015,641 members
Home / Discussions / C#
   

C#

 
GeneralRe: Dataset to defined XML schema Pin
Yosh_4-Apr-11 3:19
professionalYosh_4-Apr-11 3:19 
GeneralRe: Dataset to defined XML schema Pin
Pete O'Hanlon4-Apr-11 2:41
mvePete O'Hanlon4-Apr-11 2:41 
GeneralRe: Dataset to defined XML schema Pin
Yosh_4-Apr-11 2:58
professionalYosh_4-Apr-11 2:58 
GeneralRe: Dataset to defined XML schema Pin
Pete O'Hanlon4-Apr-11 3:26
mvePete O'Hanlon4-Apr-11 3:26 
GeneralRe: Dataset to defined XML schema Pin
Yosh_4-Apr-11 3:35
professionalYosh_4-Apr-11 3:35 
AnswerRe: Dataset to defined XML schema Pin
Pravin Patil, Mumbai4-Apr-11 3:26
Pravin Patil, Mumbai4-Apr-11 3:26 
GeneralRe: Dataset to defined XML schema Pin
Yosh_4-Apr-11 3:45
professionalYosh_4-Apr-11 3:45 
AnswerRe: Dataset to defined XML schema Pin
kevinnicol5-Apr-11 8:27
kevinnicol5-Apr-11 8:27 
I have done similar things before using an sql data adapter. This produces a seperate file for xml schema though. I'm not sure if this is what your looking for.

SqlCommand cmd = new SqlCommand();
cmd.Connection = new SqlConnection(@"cnnstring");
cmd.Connection.Open();
cmd.CommandText = "SELECT * FROM Table1; SELECT * FROM Table2";

DataSet ds = new DataSet();

SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);

ds.WriteXmlSchema(@"C:\dat.xsd");
ds.WriteXml(@"C:\dat.xml");

cmd.Connection.Close();

Questionhow Access to the default page other Webhost Pin
Abbas Fatshidi3-Apr-11 20:41
professionalAbbas Fatshidi3-Apr-11 20:41 
AnswerRe: how Access to the default page other Webhost Pin
OriginalGriff3-Apr-11 21:36
mveOriginalGriff3-Apr-11 21:36 
AnswerRe: how Access to the default page other Webhost Pin
Bernhard Hiller3-Apr-11 22:08
Bernhard Hiller3-Apr-11 22:08 
AnswerRe: how Access to the default page other Webhost Pin
Abbas Fatshidi3-Apr-11 22:12
professionalAbbas Fatshidi3-Apr-11 22:12 
GeneralRe: how Access to the default page other Webhost Pin
Pete O'Hanlon3-Apr-11 22:46
mvePete O'Hanlon3-Apr-11 22:46 
GeneralRe: how Access to the default page other Webhost Pin
Abbas Fatshidi3-Apr-11 22:54
professionalAbbas Fatshidi3-Apr-11 22:54 
GeneralRe: how Access to the default page other Webhost Pin
Pete O'Hanlon3-Apr-11 22:57
mvePete O'Hanlon3-Apr-11 22:57 
GeneralRe: how Access to the default page other Webhost Pin
BobJanova3-Apr-11 23:56
BobJanova3-Apr-11 23:56 
AnswerRe: how Access to the default page other Webhost Pin
#realJSOP4-Apr-11 1:19
professional#realJSOP4-Apr-11 1:19 
GeneralRe: how Access to the default page other Webhost Pin
Pete O'Hanlon4-Apr-11 1:40
mvePete O'Hanlon4-Apr-11 1:40 
QuestionVideo stream modifications Pin
onionRings3-Apr-11 13:10
onionRings3-Apr-11 13:10 
AnswerRe: Video stream modifications Pin
OriginalGriff3-Apr-11 21:39
mveOriginalGriff3-Apr-11 21:39 
AnswerRe: Video stream modifications Pin
Catalin Briciu4-Apr-11 12:18
Catalin Briciu4-Apr-11 12:18 
AnswerRe: Video stream modifications Pin
Michael900017-Apr-11 20:26
Michael900017-Apr-11 20:26 
GeneralRe: Video stream modifications Pin
onionRings31-May-11 4:34
onionRings31-May-11 4:34 
QuestionGeneric programming help Pin
shivamkalra3-Apr-11 6:46
shivamkalra3-Apr-11 6:46 
AnswerRe: Generic programming help Pin
David19873-Apr-11 7:00
David19873-Apr-11 7:00 

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.