protected void Page_Load(object sender, EventArgs e) { String a = "SELECT * FROM [dvs_chart] WHERE [ChartId] = " + 15; DataTable t = DatabaseClass.ExecuteQuery(a); drawchart(t); }
private void loadGrid() { DatabaseClass d = new DatabaseClass(); try { d.openDb(); var s = "select * from barang"; dt = new DataTable(); dt = d.read(s); /* * Console.WriteLine(dt.Rows.Count.ToString()); * if (dt.Rows.Count == 0) * { * DataRow row = dt.NewRow(); * dt.Rows.Add(row); * } * */ gv.DataSource = dt; gv.DataBind(); } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { d.closeDB(); } }
protected void bt_simpan_Click(object sender, EventArgs e) { DatabaseClass d = new DatabaseClass(); string id = tb_id.Text.ToString(); string nama = tb_nama.Text.ToString(); string jenis = tb_jenis.Text.ToString(); string harga = tb_harga.Text.ToString(); if (nama.Length == 0 || jenis.Length == 0 || harga.Length == 0) { return; } try { d.openDb(); var s = "insert into barang values " + "('" + id + "', '" + nama + "', '" + jenis + "', " + harga + ")"; d.execute(s); loadGrid(); kosong(); } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { d.closeDB(); } }
protected void onRowUpdating(object sender, GridViewUpdateEventArgs e) { DatabaseClass d = new DatabaseClass(); try { string id = (gv.Rows[e.RowIndex].FindControl("lbl_id") as Label).Text.ToString().Trim(); string nama = (gv.Rows[e.RowIndex].FindControl("tb_nama") as TextBox).Text.ToString().Trim(); string jenis = (gv.Rows[e.RowIndex].FindControl("tb_jenis") as TextBox).Text.ToString(); string harga = (gv.Rows[e.RowIndex].FindControl("tb_harga") as TextBox).Text.ToString().Trim(); d.openDb(); var s = "update barang set nama = '" + nama + "', jenis = '" + jenis + "', " + "harga = " + harga + " where id_barang = '" + id + "'"; Console.WriteLine(s); d.execute(s); onRowCancelingEdit(null, null); } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { d.closeDB(); } }
public void drawchart(DataTable t) { String s = "SELECT " + t.Rows[0][5].ToString() + ", " + t.Rows[0][7].ToString() + " FROM [" + t.Rows[0][1].ToString() + " ];"; //DrawSaved_ChartUserControl.assingDataPoint(s); //String connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString; //SqlConnection connection = new SqlConnection(connectionstring); //connection.Open(); //SqlCommand cmd = new SqlCommand(s, connection); //SqlDataReader reader = cmd.ExecuteReader(); DrawSaved_ChartUserControl.READER = DatabaseClass.ExequteReaderQuery(s); //DrawSaved_ChartUserControl.READER = reader; //Chart1.Series["Series1"].Points.DataBindXY(reader, "xAxis", reader, "yaxis"); //Chart1.DataManipulator.Sort(PointSortOrder.Descending, "Series1"); //Chart1.DataManipulator.GroupByAxisLabel("SUM","Series1"); if (DatabaseClass.getTableDatafromTable(t.Rows[0][1].ToString()) != null) { DrawSaved_ChartUserControl.Visible = true; /// DrawSaved_ChartUserControl.DATASETFORCHART = DatabaseClass.getTableDatafromTable(t.Rows[0][1].ToString()); DrawSaved_ChartUserControl.CHARTTITLE = t.Rows[0][3].ToString(); DrawSaved_ChartUserControl.CHARTTYPE = t.Rows[0][4].ToString(); DrawSaved_ChartUserControl.XVALUEMEMBER = t.Rows[0][5].ToString(); DrawSaved_ChartUserControl.YVALUEMEMBER = t.Rows[0][7].ToString(); DrawSaved_ChartUserControl.ENABLELEGEND = true; DrawSaved_ChartUserControl.XAXISINTERVAL = 1; DrawSaved_ChartUserControl.XAXISTITLE = t.Rows[0][6].ToString(); DrawSaved_ChartUserControl.YAXISTITLE = t.Rows[0][8].ToString(); DrawSaved_ChartUserControl.CHARTBACKGROUNDCOLOR = t.Rows[0][9].ToString(); DrawSaved_ChartUserControl.CHARTSERIESCOLOR = t.Rows[0][10].ToString(); if (t.Rows[0][11].ToString() == "1") { DrawSaved_ChartUserControl.ENABLE3D = true; } else { DrawSaved_ChartUserControl.ENABLE3D = false; } DrawSaved_ChartUserControl.SORTING = "Ascending"; DrawSaved_ChartUserControl.FORMULA = "Sum"; DrawSaved_ChartUserControl.CreateChart_UserControl(); } DatabaseClass.closeReaderConnection(); DatabaseClass.closeConnection(); // connection.Close(); }
protected void onRowDeleting(object sender, GridViewDeleteEventArgs e) { DatabaseClass d = new DatabaseClass(); try { string id = (gv.Rows[e.RowIndex].FindControl("lbl_id") as Label).Text.ToString().Trim(); d.openDb(); var s = "delete barang where id_barang = '" + id + "'"; Console.WriteLine(s); d.execute(s); onRowCancelingEdit(null, null); } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { d.closeDB(); } }