private static void CreateTable(out string tableid, out string serverid) { string tablename = ""; System.Console.WriteLine("Enter TableName"); tablename = System.Console.ReadLine(); System.Console.WriteLine("Enter Field name seperated by ,"); string fields = ""; tableid = ""; fields = System.Console.ReadLine(); var fs = fields.Split(','); serverid = CreateServer(); if (serverid != "") { Tz.Net.DataManager dm = new Tz.Net.DataManager(serverid, ""); dm.NewTable(tablename, "sys"); foreach (string s in fs) { if (s == "UserID") { dm.AddPrimarykey(s, System.Data.DbType.String, 25); // dm.AddField(s, System.Data.DbType.String, 25, true); } else { dm.AddField(s, System.Data.DbType.String, 25, true); } } try { dm.AcceptChanges(); tableid = dm.getTableID(); System.Console.WriteLine("table created"); System.Console.ReadLine(); } catch (System.Exception ex) { tableid = ""; System.Console.WriteLine(ex.Message); } } }
private static void addColumn(string tbID, string serverid) { Tz.Net.DataManager dm = new Tz.Net.DataManager(tbID, serverid); string fields; fields = System.Console.ReadLine(); var fs = fields.Split(','); foreach (string s in fs) { if (s == "UserID") { dm.AddPrimarykey(s, System.Data.DbType.String, 25); } else { dm.AddField(s, System.Data.DbType.String, 25, true); } } dm.AcceptChanges(); System.Console.WriteLine("fields added"); System.Console.ReadLine(); }