private void btGenerate_Click(object sender, System.EventArgs e)
{
try
{
System.Data.DataSet ds = new System.Data.DataSet();
using (System.IO.MemoryStream stream = new System.IO.MemoryStream())
{
System.IO.StreamWriter writer = new System.IO.StreamWriter(stream, System.Text.Encoding.Unicode);
writer.Write(txtDatasetDefinition.Text);
writer.Flush();
stream.Seek(0, System.IO.SeekOrigin.Begin);
ds.ReadXmlSchema(stream);
writer.Close();
}
System.Text.StringBuilder outText = new System.Text.StringBuilder();
outText.Append("--SQL Command builder\r\n");
foreach (System.Data.DataTable table in ds.Tables)
{
outText.Append("-- Table : " + table.TableName + "\r\n");
DevAge.Data.SqlClient.SqlCommandBuilder cmdBuilder = new DevAge.Data.SqlClient.SqlCommandBuilder(table);
outText.AppendLine(cmdBuilder.GetDeleteCommand().CommandText);
outText.AppendLine(cmdBuilder.GetUpdateCommand().CommandText);
outText.AppendLine(cmdBuilder.GetInsertCommand().CommandText);
outText.Append("-- ############################################################\r\n");
}
txtSqlOutput.Text = outText.ToString();
}
catch (Exception ex)
{
MessageBox.Show(this, ex.Message);
}
}
private void btGenerate_Click(object sender, System.EventArgs e)
{
try
{
System.Data.DataSet ds = new System.Data.DataSet();
using (System.IO.MemoryStream stream = new System.IO.MemoryStream())
{
System.IO.StreamWriter writer = new System.IO.StreamWriter(stream, System.Text.Encoding.Unicode);
writer.Write(txtDatasetDefinition.Text);
writer.Flush();
stream.Seek(0, System.IO.SeekOrigin.Begin);
ds.ReadXmlSchema(stream);
writer.Close();
}
System.Text.StringBuilder outText = new System.Text.StringBuilder();
outText.Append("--SQL Command builder\r\n");
foreach (System.Data.DataTable table in ds.Tables)
{
outText.Append("-- Table : " + table.TableName + "\r\n");
DevAge.Data.SqlClient.SqlCommandBuilder cmdBuilder = new DevAge.Data.SqlClient.SqlCommandBuilder(table);
outText.AppendLine(cmdBuilder.GetDeleteCommand().CommandText);
outText.AppendLine(cmdBuilder.GetUpdateCommand().CommandText);
outText.AppendLine(cmdBuilder.GetInsertCommand().CommandText);
outText.Append("-- ############################################################\r\n");
}
txtSqlOutput.Text = outText.ToString();
}
catch(Exception ex)
{
MessageBox.Show(this, ex.Message);
}
}
