public IDataLink CreateLink(string connectionString) { TextLink tl = new TextLink(); tl.Initialize(connectionString); return(tl); }
public void Initialize(IDataLink link) { _link = link as TextLink; }
public ActionResult Mapping() { string tempfileName = Session["import_file_path"].ToString(); bool isFirstRowHeader = Request["IsFirstRowHeader"] == "on" ? true : false; string rowDelimiter = Request["RowDelimiter"]; string columnDelimiter= Request["ColumnDelimiter"]; string tableName = Request["TableName"]; ImportInfo imfo = new ImportInfo(); imfo.DestinationTableName = tableName; imfo.ImportFileLocation = tempfileName; imfo.FirstRowHasColumnNames = isFirstRowHeader; imfo.RowDelimiter = TemplateToString(rowDelimiter); imfo.ColumnDelimiter = TemplateToString(columnDelimiter); StringBuilder sbConn = new StringBuilder(); sbConn.Append("@File="); sbConn.Append(tempfileName); sbConn.Append(";@Type=Delimited;"); sbConn.Append("RowSeperator="); sbConn.Append(imfo.RowDelimiter); sbConn.Append(";ColumnSeperator="); sbConn.Append(imfo.ColumnDelimiter); sbConn.Append(";FirstRowHasNames="); sbConn.Append(imfo.FirstRowHasColumnNames.ToString()); SqlDataLink sqlLink = new SqlDataLink(); sqlLink.Initialize(ConfigurationManager.AppSettings["SqlConnection"]); sqlLink.Connect(); ColumnDefinition[] sqlCds = sqlLink.GetSchema("SELECT * FROM " + imfo.DestinationTableName); imfo.DestinationColumns = sqlCds; TextLink tl = new TextLink(); tl.Initialize(sbConn.ToString()); tl.Connect(); ColumnDefinition[] cds = tl.GetSchema(""); List<string> columns = new List<string>(); foreach (ColumnDefinition cd in cds) { columns.Add(cd.ColumnName); } imfo.SourceColumns = columns.ToArray(); return View(imfo); }
public IDataLink CreateLink(string connectionString) { TextLink tl = new TextLink(); tl.Initialize(connectionString); return tl; }