public List <vmColumn> GetDatabaseTableColumnList([FromBody] vmParam model) { List <vmColumn> data = new List <vmColumn>(); string conString_ = conString + " Database=" + model.DatabaseName + ";"; using (SqlConnection con = new SqlConnection(conString_)) { int count = 0; con.Open(); using (SqlCommand cmd = new SqlCommand("SELECT COLUMN_NAME, DATA_TYPE, ISNULL(CHARACTER_MAXIMUM_LENGTH,0), IS_NULLABLE, TABLE_SCHEMA FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '" + model.TableName + "' ORDER BY ORDINAL_POSITION", con)) { using (IDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { count++; data.Add(new vmColumn() { ColumnId = count, ColumnName = dr[0].ToString(), DataType = dr[1].ToString(), MaxLength = dr[2].ToString(), IsNullable = dr[3].ToString(), Tablename = model.TableName.ToString(), TableSchema = dr[4].ToString() }); } } } } return(data.ToList()); }
public List <ColumnInfo> GetDatabaseTableColumnList([FromBody] vmParam model) { var dbName = model.DatabaseName; var tableName = model.TableName; return(getColumnsFromTable(dbName, tableName)); }
public List <TableInfo> GetDatabaseTableList([FromBody] vmParam model) { var dbName = model.DatabaseName; List <TableInfo> data = getAllTableFromDb(dbName); return(data.ToList()); }
public IActionResult GetMapColumns([FromBody] vmParam model) { var result = ""; string webRootPath = _hostingEnvironment.WebRootPath; //From web var filePath = webRootPath + "\\template\\ColumnMap\\colmap.json"; if (!System.IO.File.Exists(filePath)) { using (StreamWriter sw = System.IO.File.CreateText(filePath)) { sw.Write("[]"); } } var content = System.IO.File.ReadAllText(filePath, Encoding.UTF8); result = content; return(Json(result)); }
public List <vmTable> GetDatabaseTableList([FromBody] vmParam model) { List <vmTable> data = new List <vmTable>(); string conString_ = conString + " Database=" + model.DatabaseName + ";"; using (SqlConnection con = new SqlConnection(conString_)) { int count = 0; con.Open(); DataTable schema = con.GetSchema("Tables"); foreach (DataRow row in schema.Rows) { count++; data.Add(new vmTable() { TableId = count, TableName = row[2].ToString() }); } } return(data.ToList()); }
public List <vmColumn> GetDatabaseTableColumnList([FromBody] vmParam model) { return(GetTableColumns(model.DatabaseName, model.TableName).ToList()); }