private void button2_Click(object sender, EventArgs e) { try { this.textBox1.Clear(); var connection_str = System.Configuration.ConfigurationManager.ConnectionStrings["DEMO_UD"]; string s = connection_str.ConnectionString; U2Connection con = new U2Connection(); con.ConnectionString = s; con.Open(); this.textBox1.AppendText("Connected.........................(UniData Account)" + Environment.NewLine); U2Command cmd = con.CreateCommand(); cmd.CommandText = "SELECT ID, FNAME,LNAME FROM STUDENT_NF_SUB"; DataSet ds = new DataSet(); m_da = new U2DataAdapter(cmd); m_da.Fill(ds); m_U2CommandBuilder = new U2CommandBuilder(m_da); this.dataGridView1.DataSource = ds.Tables[0].DefaultView; this.textBox1.AppendText("Done........................." + Environment.NewLine); } catch (Exception e3) { this.textBox1.AppendText(e3.Message); MessageBox.Show(e3.Message); } }
public static List <Orders> ReadExistingOrders(String OrderID) { List <Orders> Cart = new List <Orders>(); OrderID = OrderID; string connection = ConfigurationManager.AppSettings["MVWriter"]; U2Connection con = new U2Connection(); con.ConnectionString = connection; con.Open(); U2Command cmd = con.CreateCommand(); cmd.CommandText = "SELECT PROD, QUAN, COST FROM UNNEST SHOPPINGCART ON CARTS WHERE RECID = '" + OrderID + "'"; DataSet ds = new DataSet(); U2DataAdapter da = new U2DataAdapter(cmd); da.Fill(ds); DataTable dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { Orders ExistingLineItems = new Orders { Cost = dr["COST"].ToString(), Quantity = dr["QUAN"].ToString(), Serial = dr["PROD"].ToString() }; Cart.Add(ExistingLineItems); } con.Close(); return(Cart); }
private void ExecuteDataSet(U2Connection con) { try { if (settings.AccessMode == "Native") { // Need to confirm how to use UniDataSet } else { U2Command cmd = con.CreateCommand(); cmd.Connection = con; cmd.CommandText = settings.CommandText; U2DataAdapter da = new U2DataAdapter(); da.SelectCommand = cmd; DataSet ds = new DataSet(); da.Fill(ds); } } catch (System.Exception ex) { throw ex; } }
public ActionResult Index() { List <APMST> sample = new List <APMST>(); try { string s = ConfigurationManager.AppSettings["TESTString"]; U2Connection con = new U2Connection(); con.ConnectionString = s; con.Open(); U2Command cmd = con.CreateCommand(); cmd.CommandText = "SELECT PROD,SALE, DESC1 FROM IVMST"; // FNAME = SingleValue, PRICE = multivalue DataSet ds = new DataSet(); U2DataAdapter da = new U2DataAdapter(cmd); da.Fill(ds); DataTable dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { //APMST loadRecord = new APMST { NAME = dr["NAME"].ToString() }; APMST loadRecord = new APMST { NAME = dr["PROD"].ToString() }; sample.Add(loadRecord); } con.Close(); } catch (Exception e) { // Console.WriteLine(e.Message); if (e.InnerException != null) { } } finally { // string line = Console.ReadLine(); } return(View(sample)); }
static void Main(string[] args) { try { Console.WriteLine("start........................."); Stopwatch sw = new Stopwatch(); sw.Start(); U2ConnectionStringBuilder conn_str = new U2ConnectionStringBuilder(); conn_str.UserID = "administrator"; conn_str.Password = "******"; conn_str.Server = "localhost"; conn_str.Database = "XDEMO"; conn_str.ServerType = "UNIVERSE"; conn_str.Pooling = false; string s = conn_str.ToString(); U2Connection con = new U2Connection(); con.ConnectionString = s; con.Open(); Console.WriteLine("Connected..."); U2Command cmd = con.CreateCommand(); cmd.CommandText = "SELECT * FROM PRODUCTS"; DataSet ds = new DataSet(); U2DataAdapter da = new U2DataAdapter(cmd); da.Fill(ds); sw.Stop(); TimeSpan elapsed = sw.Elapsed; string elapsedTime = String.Format("{0:00}:{1:00}:{2:00}.{3:00}", elapsed.Hours, elapsed.Minutes, elapsed.Seconds, elapsed.Milliseconds / 10); int nSec = elapsed.Seconds; con.Close(); Console.WriteLine("Time Taken in seconds:" + elapsedTime); Console.WriteLine("End........................... "); } catch (Exception e) { Console.WriteLine(e.Message); } finally { Console.WriteLine("Enter to exit:"); string line = Console.ReadLine(); } }
static void Main(string[] args) { try { U2ConnectionStringBuilder conn_str = new U2ConnectionStringBuilder(); conn_str.UserID = "user"; conn_str.Password = "******"; conn_str.Server = "localhost"; conn_str.Database = "demo"; conn_str.ServerType = "UNIDATA"; conn_str.Pooling = false; string s = conn_str.ToString(); U2Connection con = new U2Connection(); con.ConnectionString = s; con.Open(); Console.WriteLine("Connected........................."); U2Command cmd = con.CreateCommand(); cmd.CommandText = "SELECT * FROM STUDENT_NF_SUB"; DataSet ds = new DataSet(); U2DataAdapter da = new U2DataAdapter(cmd); da.Fill(ds); DataTable dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { Console.WriteLine(dr["FNAME"]); } con.Close(); } catch (Exception e) { Console.WriteLine(e.Message); } finally { Console.WriteLine("Enter to exit:"); string line = Console.ReadLine(); } }
private static void FillDataSetWithUNNEST() { try { U2ConnectionStringBuilder conn_str = new U2ConnectionStringBuilder(); conn_str.UserID = "user"; conn_str.Password = "******"; conn_str.Server = "localhost"; conn_str.Database = "HS.SALES"; conn_str.ServerType = "UNIVERSE"; conn_str.FirstNormalForm = false; conn_str.Pooling = false; string s = conn_str.ToString(); U2Connection con = new U2Connection(); con.ConnectionString = s; con.Open(); Console.WriteLine("Connected........................."); U2Command cmd = con.CreateCommand(); cmd.CommandText = "SELECT FNAME, PRICE FROM UNNEST CUSTOMER ON ORDERS"; // FNAME = SingleValue, PRICE = multivalue DataSet ds = new DataSet(); U2DataAdapter da = new U2DataAdapter(cmd); da.Fill(ds); DataTable dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { Console.WriteLine(dr["FNAME"] + "==" + dr["PRICE"]); } con.Close(); } catch (Exception e) { Console.WriteLine(e.Message); } finally { //Console.WriteLine("Enter to exit:"); //string line = Console.ReadLine(); } }
static void Main(string[] args) { try { U2ConnectionStringBuilder conn_str = new U2ConnectionStringBuilder(); conn_str.UserID = "user"; conn_str.Password = "******"; conn_str.Server = "localhost"; conn_str.Database = "demo"; conn_str.ServerType = "UNIDATA"; conn_str.Pooling = false; conn_str.FirstNormalForm = false; string s = conn_str.ToString(); U2Connection con = new U2Connection(); con.ConnectionString = s; con.Open(); Console.WriteLine("Connected........................."); U2Command cmd = con.CreateCommand(); cmd.CommandText = "SELECT * FROM STUDENT UNNEST NL_ALL CGA ;"; DataSet ds = new DataSet(); U2DataAdapter da = new U2DataAdapter(cmd); da.Fill(ds); DataTable dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { Console.WriteLine(dr["FNAME"] + "==" + dr["SEMESTER"]); } con.Close(); } catch (Exception e) { Console.WriteLine(e.Message); } finally { Console.WriteLine("Enter to exit:"); string line = Console.ReadLine(); } }
/// <summary> /// Get dataset in SQL mode /// </summary> /// <param name="conStrBdr"></param> /// <param name="strTableName"></param> /// <returns></returns> private DataSet GetSQLDataSet(U2ConnectionStringBuilder conStrBdr, string strTableName) { try { U2Connection con = new U2Connection(); con.ConnectionString = conStrBdr.ToString(); con.Open(); U2Command cmd = con.CreateCommand(); cmd.CommandText = string.Format("SELECT * FROM [{0}]", strTableName); U2DataAdapter da = new U2DataAdapter(); da.SelectCommand = cmd; DataSet ds = new DataSet(); da.Fill(ds); con.Close(); return(ds); } catch (Exception e) { throw e; } }
private void button3_Click(object sender, EventArgs e) { try { this.textBox1.AppendText("Start..." + Environment.NewLine); //strat get U2 data U2ConnectionStringBuilder conn_bldr = new U2ConnectionStringBuilder(); conn_bldr.UserID = "admin"; conn_bldr.Password = "******"; conn_bldr.Server = "192.168.102.132"; conn_bldr.ServerType = "universe"; conn_bldr.Database = "HS.SALES"; conn_bldr.AccessMode = "Native"; conn_bldr.RpcServiceType = "uvcs"; string lConnStr = conn_bldr.ConnectionString; U2Connection lConn = new U2Connection(); lConn.ConnectionString = lConnStr; lConn.Open(); Console.WriteLine("Connected..."); U2Command cmd = lConn.CreateCommand(); // CUSTID,FNAME,LNAME : Single Value //PRODID, BUY_DATE : Multi Value //Syntax : Action=?;File=?;Attributes=?;Where=?;Sort cmd.CommandText = string.Format("Action=Select;File=CUSTOMER;Attributes=CUSTID,FNAME,LNAME,PRODID,BUY_DATE;Where=CUSTID>0;Sort=CUSTID"); U2DataAdapter da = new U2DataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); DataTable dt = ds.Tables[0]; //end get U2 data //load table storage string lTableStorageName = "CUSTOMER3"; StorageCredentials creds = new StorageCredentials(accountName, accountKey); CloudStorageAccount account = new CloudStorageAccount(creds, useHttps: true); CloudTableClient client = account.CreateCloudTableClient(); CloudTable table = client.GetTableReference("CUSTOMER6"); table.CreateIfNotExists(); string lUri = table.Uri.ToString(); // Console.WriteLine(table.Uri.ToString()); this.textBox1.AppendText(lUri + Environment.NewLine); foreach (DataRow item in dt.Rows) { var t1 = item["CUSTID"].ToString(); var t2 = item["Z_MV_KEY"].ToString(); DateTime lhiredate; if (item["BUY_DATE"] == DBNull.Value) { lhiredate = DateTime.Now;// new DateTime(); } else { lhiredate = (DateTime)item["BUY_DATE"]; } CustomerEntity entity = new CustomerEntity(t1,t2) { FNAME = (string)item["FNAME"], LNAME = (string)item["LNAME"], PRODID = (string)item["PRODID"], BUY_DATE = lhiredate }; TableOperation insertOperation = TableOperation.InsertOrReplace(entity); table.Execute(insertOperation); this.textBox1.AppendText("Entity inserted!" + Environment.NewLine); } this.textBox1.AppendText("End..." + Environment.NewLine); } catch (Exception ex) { this.textBox1.AppendText(ex.Message + Environment.NewLine); } }
private void button3_Click(object sender, EventArgs e) { try { this.textBox1.AppendText("Start..." + Environment.NewLine); //strat get U2 data U2ConnectionStringBuilder conn_bldr = new U2ConnectionStringBuilder(); conn_bldr.UserID = "admin"; conn_bldr.Password = "******"; conn_bldr.Server = "192.168.102.132"; conn_bldr.ServerType = "universe"; conn_bldr.Database = "HS.SALES"; conn_bldr.AccessMode = "Native"; conn_bldr.RpcServiceType = "uvcs"; string lConnStr = conn_bldr.ConnectionString; U2Connection lConn = new U2Connection(); lConn.ConnectionString = lConnStr; lConn.Open(); Console.WriteLine("Connected..."); U2Command cmd = lConn.CreateCommand(); // CUSTID,FNAME,LNAME : Single Value //PRODID, BUY_DATE : Multi Value //Syntax : Action=?;File=?;Attributes=?;Where=?;Sort cmd.CommandText = string.Format("Action=Select;File=CUSTOMER;Attributes=CUSTID,FNAME,LNAME,PRODID,BUY_DATE;Where=CUSTID>0;Sort=CUSTID"); U2DataAdapter da = new U2DataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); DataTable dt = ds.Tables[0]; //end get U2 data //load table storage string lTableStorageName = "CUSTOMER3"; StorageCredentials creds = new StorageCredentials(accountName, accountKey); CloudStorageAccount account = new CloudStorageAccount(creds, useHttps: true); CloudTableClient client = account.CreateCloudTableClient(); CloudTable table = client.GetTableReference("CUSTOMER6"); table.CreateIfNotExists(); string lUri = table.Uri.ToString(); // Console.WriteLine(table.Uri.ToString()); this.textBox1.AppendText(lUri + Environment.NewLine); foreach (DataRow item in dt.Rows) { var t1 = item["CUSTID"].ToString(); var t2 = item["Z_MV_KEY"].ToString(); DateTime lhiredate; if (item["BUY_DATE"] == DBNull.Value) { lhiredate = DateTime.Now;// new DateTime(); } else { lhiredate = (DateTime)item["BUY_DATE"]; } CustomerEntity entity = new CustomerEntity(t1, t2) { FNAME = (string)item["FNAME"], LNAME = (string)item["LNAME"], PRODID = (string)item["PRODID"], BUY_DATE = lhiredate }; TableOperation insertOperation = TableOperation.InsertOrReplace(entity); table.Execute(insertOperation); this.textBox1.AppendText("Entity inserted!" + Environment.NewLine); } this.textBox1.AppendText("End..." + Environment.NewLine); } catch (Exception ex) { this.textBox1.AppendText(ex.Message + Environment.NewLine); } }
/// <summary> /// Get dataset in SQL mode /// </summary> /// <param name="conStrBdr"></param> /// <param name="strTableName"></param> /// <returns></returns> private DataSet GetSQLDataSet(U2ConnectionStringBuilder conStrBdr, string strTableName) { try { U2Connection con = new U2Connection(); con.ConnectionString = conStrBdr.ToString(); con.Open(); U2Command cmd = con.CreateCommand(); cmd.CommandText = string.Format("SELECT * FROM [{0}]", strTableName); U2DataAdapter da = new U2DataAdapter(); da.SelectCommand = cmd; DataSet ds = new DataSet(); da.Fill(ds); con.Close(); return ds; } catch (Exception e) { throw e ; } }