Click here to Skip to main content
15,499,958 members
Home / Discussions / C#
   

C#

 
GeneralRe: Dataset to defined XML schema Pin
Yosh_4-Apr-11 4:19
professionalYosh_4-Apr-11 4:19 
GeneralRe: Dataset to defined XML schema Pin
Pete O'Hanlon4-Apr-11 3:41
mvaPete O'Hanlon4-Apr-11 3:41 
GeneralRe: Dataset to defined XML schema Pin
Yosh_4-Apr-11 3:58
professionalYosh_4-Apr-11 3:58 
GeneralRe: Dataset to defined XML schema Pin
Pete O'Hanlon4-Apr-11 4:26
mvaPete O'Hanlon4-Apr-11 4:26 
GeneralRe: Dataset to defined XML schema Pin
Yosh_4-Apr-11 4:35
professionalYosh_4-Apr-11 4:35 
AnswerRe: Dataset to defined XML schema Pin
Pravin Patil, Mumbai4-Apr-11 4:26
MemberPravin Patil, Mumbai4-Apr-11 4:26 
GeneralRe: Dataset to defined XML schema Pin
Yosh_4-Apr-11 4:45
professionalYosh_4-Apr-11 4:45 
AnswerRe: Dataset to defined XML schema Pin
kevinnicol5-Apr-11 9:27
Memberkevinnicol5-Apr-11 9: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 21:41
professionalAbbas Fatshidi3-Apr-11 21:41 
AnswerRe: how Access to the default page other Webhost Pin
OriginalGriff3-Apr-11 22:36
mveOriginalGriff3-Apr-11 22:36 
AnswerRe: how Access to the default page other Webhost Pin
Bernhard Hiller3-Apr-11 23:08
MemberBernhard Hiller3-Apr-11 23:08 
AnswerRe: how Access to the default page other Webhost Pin
Abbas Fatshidi3-Apr-11 23:12
professionalAbbas Fatshidi3-Apr-11 23:12 
GeneralRe: how Access to the default page other Webhost Pin
Pete O'Hanlon3-Apr-11 23:46
mvaPete O'Hanlon3-Apr-11 23:46 
GeneralRe: how Access to the default page other Webhost Pin
Abbas Fatshidi3-Apr-11 23:54
professionalAbbas Fatshidi3-Apr-11 23:54 
GeneralRe: how Access to the default page other Webhost Pin
Pete O'Hanlon3-Apr-11 23:57
mvaPete O'Hanlon3-Apr-11 23:57 
GeneralRe: how Access to the default page other Webhost Pin
BobJanova4-Apr-11 0:56
MemberBobJanova4-Apr-11 0:56 
AnswerRe: how Access to the default page other Webhost Pin
#realJSOP4-Apr-11 2:19
mva#realJSOP4-Apr-11 2:19 
GeneralRe: how Access to the default page other Webhost Pin
Pete O'Hanlon4-Apr-11 2:40
mvaPete O'Hanlon4-Apr-11 2:40 
QuestionVideo stream modifications Pin
onionRings3-Apr-11 14:10
MemberonionRings3-Apr-11 14:10 
AnswerRe: Video stream modifications Pin
OriginalGriff3-Apr-11 22:39
mveOriginalGriff3-Apr-11 22:39 
AnswerRe: Video stream modifications Pin
Catalin Briciu4-Apr-11 13:18
MemberCatalin Briciu4-Apr-11 13:18 
AnswerRe: Video stream modifications Pin
Michael900017-Apr-11 21:26
MemberMichael900017-Apr-11 21:26 
GeneralRe: Video stream modifications Pin
onionRings31-May-11 5:34
MemberonionRings31-May-11 5:34 
QuestionGeneric programming help Pin
shivamkalra3-Apr-11 7:46
Membershivamkalra3-Apr-11 7:46 
AnswerRe: Generic programming help Pin
David19873-Apr-11 8:00
MemberDavid19873-Apr-11 8: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.