DataTable myTable=DS.Tables[
"
表名
"]; --->添加
DataRow myNewRow=myTable.NewRow();
myNewRow[ " 你要添加的列名 "]= " 值 ";
myNewRow[ " 你要添加的列名 "]= " 值 ";
myTable.Rows.Add(myNewRow);
dg2.DataSource=myTable.DefaultView;
dg2.DataBind(); // 将新添的数据邦定
DataRow[] myNewRow2=myTable.Select( " id_jldw=11 AND name_jldw='内容' "); ----->修改
// myNewRow2[0]["要修改的列名"]=值;
myNewRow2[ 0][ " 要修改的列名 "]=值;
myNewRow2[ 0][ " 要修改的列名 "]=值;
dg3.DataSource=myTable.DefaultView;
dg3.DataBind(); // 将新添的数据邦定
myTable.Rows[ 0].Delete(); // 删除第一行 ---->删除
dg4.DataSource=myTable.DefaultView;
dg4.DataBind();
DataRow myNewRow=myTable.NewRow();
myNewRow[ " 你要添加的列名 "]= " 值 ";
myNewRow[ " 你要添加的列名 "]= " 值 ";
myTable.Rows.Add(myNewRow);
dg2.DataSource=myTable.DefaultView;
dg2.DataBind(); // 将新添的数据邦定
DataRow[] myNewRow2=myTable.Select( " id_jldw=11 AND name_jldw='内容' "); ----->修改
// myNewRow2[0]["要修改的列名"]=值;
myNewRow2[ 0][ " 要修改的列名 "]=值;
myNewRow2[ 0][ " 要修改的列名 "]=值;
dg3.DataSource=myTable.DefaultView;
dg3.DataBind(); // 将新添的数据邦定
myTable.Rows[ 0].Delete(); // 删除第一行 ---->删除
dg4.DataSource=myTable.DefaultView;
dg4.DataBind();
protected
void Button1_Click(
object sender, EventArgs e)
{
string getname = this.DropDownList1.SelectedItem.Text.ToString();
string getcode = this.DropDownList1.SelectedItem.Value.ToString();
if (ViewState[ " ptable "] == null)
{
pipetable = new DataTable();
pipetable.Columns.Add( new DataColumn( " pid ", typeof( int)));
pipetable.Columns.Add( new DataColumn( " pname ", typeof( string)));
DataColumn column = new DataColumn();
column.ColumnName = " ID ";
column.AutoIncrement = true;
column.AutoIncrementSeed = 1;
column.AutoIncrementStep = 1;
pipetable.Columns.Add(column);
ViewState[ " ptable "] = pipetable;
}
else
{
pipetable = (DataTable)ViewState[ " ptable "];
}
DataRow[] myNewRow = pipetable.Select("pid='" + getcode + "'");
if (myNewRow.Length.ToString() == "0")
{
DataRow row;
row = pipetable.NewRow();
row[0] = " " + getcode.ToString() + " ";
row[1] = " " + getname.ToString() + " ";
pipetable.Rows.Add(row);
}
BindGridView(pipetable);
BindLine();
}
{
string getname = this.DropDownList1.SelectedItem.Text.ToString();
string getcode = this.DropDownList1.SelectedItem.Value.ToString();
if (ViewState[ " ptable "] == null)
{
pipetable = new DataTable();
pipetable.Columns.Add( new DataColumn( " pid ", typeof( int)));
pipetable.Columns.Add( new DataColumn( " pname ", typeof( string)));
DataColumn column = new DataColumn();
column.ColumnName = " ID ";
column.AutoIncrement = true;
column.AutoIncrementSeed = 1;
column.AutoIncrementStep = 1;
pipetable.Columns.Add(column);
ViewState[ " ptable "] = pipetable;
}
else
{
pipetable = (DataTable)ViewState[ " ptable "];
}
DataRow[] myNewRow = pipetable.Select("pid='" + getcode + "'");
if (myNewRow.Length.ToString() == "0")
{
DataRow row;
row = pipetable.NewRow();
row[0] = " " + getcode.ToString() + " ";
row[1] = " " + getname.ToString() + " ";
pipetable.Rows.Add(row);
}
BindGridView(pipetable);
BindLine();
}
protected
void GridView1_RowDeleting(
object sender, GridViewDeleteEventArgs e)
{
pipetable = (DataTable)ViewState[ " ptable "];
pipetable.Rows[e.RowIndex].Delete();
pipetable.AcceptChanges();
BindGridView(pipetable);
BindLine();
}
{
pipetable = (DataTable)ViewState[ " ptable "];
pipetable.Rows[e.RowIndex].Delete();
pipetable.AcceptChanges();
BindGridView(pipetable);
BindLine();
}
public
void BindLine()
{
DateTime dt = DateTime.Now;
string DateFormats = Convert.ToDateTime(dt).ToString( " yyyy-MM-dd ");
pipetable = (DataTable)ViewState[ " ptable "];
string allpipes = "";
if (pipetable.Rows.Count > 0)
{
for ( int k = 0; k < pipetable.Rows.Count; k++)
{
string ppid = pipetable.Rows[k][ " pid "].ToString();
allpipes += ppid + " , ";
}
allpipes = allpipes.TrimEnd( ' , ');
string sql1 = " select PID,Pname from HeatLine where PID in ( " + allpipes + " ) and convert(varchar(10),DateAndTime,120) = ' " + DateFormats + " ' ";
DataSet ds1 = newdb.CommonDataSet(sql1); // 取得所有管线
}
}
{
DateTime dt = DateTime.Now;
string DateFormats = Convert.ToDateTime(dt).ToString( " yyyy-MM-dd ");
pipetable = (DataTable)ViewState[ " ptable "];
string allpipes = "";
if (pipetable.Rows.Count > 0)
{
for ( int k = 0; k < pipetable.Rows.Count; k++)
{
string ppid = pipetable.Rows[k][ " pid "].ToString();
allpipes += ppid + " , ";
}
allpipes = allpipes.TrimEnd( ' , ');
string sql1 = " select PID,Pname from HeatLine where PID in ( " + allpipes + " ) and convert(varchar(10),DateAndTime,120) = ' " + DateFormats + " ' ";
DataSet ds1 = newdb.CommonDataSet(sql1); // 取得所有管线
}
}