public void Write(XMLmodel model, string dbname, string tablename, string dirpath, string prefix = "") { string filename = dirpath + @"\" + "Data_" + prefix + "_" + dbname + "_" + tablename + ".xml"; //File.Create(filename); GenerateFile(model, filename); }
private void GenerateFile(XMLmodel data, string filepath) { XmlTextWriter writer = new XmlTextWriter(filepath, System.Text.Encoding.UTF8); writer.WriteStartDocument(true); writer.Formatting = Formatting.Indented; writer.Indentation = 2; writer.WriteStartElement("Data"); createNode(writer, data); writer.WriteEndElement(); writer.WriteEndDocument(); writer.Close(); }
private void createNode(XmlTextWriter writer, XMLmodel data) { foreach (var rows in data.Data) { writer.WriteStartElement("row"); for (int i = 0; i < rows.Count; i++) { writer.WriteStartElement(data.Columnname[i]); writer.WriteString(rows[i]); writer.WriteEndElement(); } writer.WriteEndElement(); } }
public XMLmodel Getdata(string tablename, string dbname, string connectionstring) { _dbname = dbname; _tableName = tablename; _conStr = connectionstring; XMLmodel datamodel = new XMLmodel(); datamodel.tablename = tablename; IEnumerable <string> col = GetColumnNames(); GetTableData(col, datamodel); return(datamodel); }
public void Setup(string dbname, string dirpath, string connectionstring, string prefix = "") { GetalltheTable tableobj = new GetalltheTable(); List <string> tablesList = tableobj.GettableList(connectionstring, dbname); Createtable ct = new Createtable(); ct.Write(dbname, dirpath, connectionstring, prefix); foreach (var table in tablesList) { GetTheDataFromTable dtDataFromTable = new GetTheDataFromTable(); XMLmodel model = dtDataFromTable.Getdata(table, dbname, connectionstring); XMLWriter wrobj = new XMLWriter(); wrobj.Write(model, dbname, table, dirpath, prefix); } }
private void GetTableData(IEnumerable <string> col, XMLmodel datamodel) { var result = new List <string>(); string column = ""; string conString = _conStr; using (SqlConnection con = new SqlConnection(conString)) { con.Open(); // Set up a command with the given query and associate // this with the current connection. using (SqlCommand cmd = new SqlCommand("use " + _dbname + ";SELECT top 5 * from " + _tableName, con)) { try { using (IDataReader dr = cmd.ExecuteReader()) { for (int i = 0; i < col.Count(); i++) { column = Convert.ToString(col.ElementAt(i)); datamodel.Columnname.Add(column); } while (dr.Read()) { List <string> data = new List <string>(); for (int i = 0; i < col.Count(); i++) { // column = ","+column + Convert.ToString(col.ElementAt(i)); data.Add(Convert.ToString(dr[datamodel.Columnname[i]])); } datamodel.Data.Add(data); } } } catch (Exception) { // throw; } } } }