Click here to Skip to main content
15,904,500 members
Home / Discussions / C#
   

C#

 
QuestionWPF C# Messagebox Result Issue Pin
Derek Kennard21-Jan-18 19:30
professionalDerek Kennard21-Jan-18 19:30 
AnswerRe: WPF C# Messagebox Result Issue Pin
phil.o21-Jan-18 23:03
professionalphil.o21-Jan-18 23:03 
GeneralRe: WPF C# Messagebox Result Issue Pin
Derek Kennard22-Jan-18 6:37
professionalDerek Kennard22-Jan-18 6:37 
GeneralRe: WPF C# Messagebox Result Issue Pin
phil.o22-Jan-18 6:40
professionalphil.o22-Jan-18 6:40 
GeneralRe: WPF C# Messagebox Result Issue Pin
Derek Kennard22-Jan-18 7:43
professionalDerek Kennard22-Jan-18 7:43 
GeneralRe: WPF C# Messagebox Result Issue Pin
Derek Kennard23-Jan-18 8:05
professionalDerek Kennard23-Jan-18 8:05 
GeneralRe: WPF C# Messagebox Result Issue Pin
phil.o23-Jan-18 11:53
professionalphil.o23-Jan-18 11:53 
QuestionCoding Moveable Elements for Games or Whatever Pin
Member 1358827720-Jan-18 2:03
Member 1358827720-Jan-18 2:03 
SuggestionRe: Coding Moveable Elements for Games or Whatever Pin
Richard MacCutchan20-Jan-18 3:01
mveRichard MacCutchan20-Jan-18 3:01 
AnswerRe: Coding Moveable Elements for Games or Whatever Pin
BillWoodruff20-Jan-18 5:17
professionalBillWoodruff20-Jan-18 5:17 
AnswerRe: Coding Moveable Elements for Games or Whatever Pin
Eddy Vluggen21-Jan-18 3:10
professionalEddy Vluggen21-Jan-18 3:10 
GeneralRe: Coding Moveable Elements for Games or Whatever Pin
Nathan Minier22-Jan-18 1:21
professionalNathan Minier22-Jan-18 1:21 
GeneralRe: Coding Moveable Elements for Games or Whatever Pin
Member 1358827722-Jan-18 5:47
Member 1358827722-Jan-18 5:47 
GeneralRe: Coding Moveable Elements for Games or Whatever Pin
Nathan Minier22-Jan-18 5:58
professionalNathan Minier22-Jan-18 5:58 
GeneralRe: Coding Moveable Elements for Games or Whatever Pin
Eddy Vluggen22-Jan-18 8:42
professionalEddy Vluggen22-Jan-18 8:42 
AnswerRe: Coding Moveable Elements for Games or Whatever Pin
Gerry Schmitz22-Jan-18 12:03
mveGerry Schmitz22-Jan-18 12:03 
QuestionRe: Coding Moveable Elements for Games or Whatever Pin
Eddy Vluggen22-Jan-18 13:54
professionalEddy Vluggen22-Jan-18 13:54 
AnswerRe: Coding Moveable Elements for Games or Whatever Pin
Gerry Schmitz22-Jan-18 14:23
mveGerry Schmitz22-Jan-18 14:23 
GeneralRe: Coding Moveable Elements for Games or Whatever Pin
Eddy Vluggen22-Jan-18 14:37
professionalEddy Vluggen22-Jan-18 14:37 
GeneralRe: Coding Moveable Elements for Games or Whatever Pin
Gerry Schmitz22-Jan-18 16:38
mveGerry Schmitz22-Jan-18 16:38 
GeneralRe: Coding Moveable Elements for Games or Whatever Pin
Eddy Vluggen23-Jan-18 0:20
professionalEddy Vluggen23-Jan-18 0:20 
GeneralRe: Coding Moveable Elements for Games or Whatever Pin
Gerry Schmitz23-Jan-18 7:37
mveGerry Schmitz23-Jan-18 7:37 
QuestionHow to insert the XML file in SQL Server Pin
Jieha Lee19-Jan-18 4:23
Jieha Lee19-Jan-18 4:23 
How to insert this XML file in SQL Server? I have done one but cannot output. The error said "String was not recognized as a valid DateTime"

Here the code that I done:

SqlDataAdapter adpter = new SqlDataAdapter();
DataSet ds = new DataSet();
int appointment_ID = 0;
string nric = null;
string client_Name = null;
DateTime? appointment_Date = null;
DateTime? start_Time = null;
SqlConnection conn = new SqlConnection(@"Data Source=USER1-PC\SQLEXPRESS;Integrated Security=true;Database=ProductDB");
XmlReader xmlFile = XmlReader.Create("G://appointment.xml", new XmlReaderSettings());
ds.ReadXml(xmlFile);
int i = 0;
conn.Open();
for (i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
{
appointment_ID = Convert.ToInt32(ds.Tables[0].Rows[i].ItemArray[0]);
appointment_Date = DateTime.Parse(ds.Tables[0].Rows[i].ItemArray[1].ToString());
start_Time = DateTime.Parse(ds.Tables[0].Rows[i].ItemArray[2].ToString());
nric = ds.Tables[0].Rows[i].ItemArray[3].ToString();
client_Name = ds.Tables[0].Rows[i].ItemArray[4].ToString();
SqlCommand command = new SqlCommand("insert into Appointment values(" + appointment_ID + ",'" + appointment_Date + "'," + start_Time + "'," + nric + "'," + client_Name + ")", conn);
adpter.InsertCommand = command;
adpter.InsertCommand.ExecuteNonQuery();
}
conn.Close();
MessageBox.Show("Done .. ");

Here is appointment.xml:

<interface>
<appointment>
<appointment_id> 000000087508
<appointment_date>2018-01-25
<appointment_start_time>13:15:00
<client>
<nric>456987123
<client_name>JAMES


<appointment>
<appointment_id>000000087501
<appointment_date>2018-01-25
<appointment_start_time>14:30:00
<client>
<nric>963258741
<client_name>Bill Tan

<client>
<nric>123456789
<client_name>David Ang


<checksum>2

AnswerRe: How to insert the XML file in SQL Server Pin
OriginalGriff19-Jan-18 4:58
mveOriginalGriff19-Jan-18 4:58 
AnswerRe: How to insert the XML file in SQL Server Pin
jschell20-Jan-18 5:54
jschell20-Jan-18 5:54 

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.