ajax.net与asp.net控件的交互

最新推荐文章于 2021-12-02 09:37:07 发布

tswpop

最新推荐文章于 2021-12-02 09:37:07 发布

阅读量135

点赞数

文章标签： asp.net datagrid dataset string cmd insert

本文链接：https://blog.csdn.net/tswpop/article/details/978635

版权

[Ajax.AjaxMethod]
  public int AddAjaxTable(string name)
  {

   //   SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["connectionString"] );

   OleDbConnection conn = new OleDbConnection(System.Configuration.ConfigurationSettings.AppSettings["connectionString"]);
　   //SqlCommand cmd = new SqlCommand("insert into ajaxTable(name) values(’"+name+"’)", conn);
   //    OleDbCommand cmd = new OleDbCommand("insert into ajaxTable(id) values('"+name+"')", conn);
   //   OleDbCommand cmd = new OleDbCommand("insert into ajaxTable(id,name,age) values('"+name.ToString()+"','"+name.ToString()+"',20",conn);
　  //cmd.Connection.Open();
   string inser = "insert into ajaxTable(id,name) values("+"'"+name+"','"+name+"')";
   // strInsertSql = "INSERT INTO tbcomplexdimdefine( fdi_no,complex_dim,complex_type) VALUES("+"'"+clsComplexDimInfocach.FdiNo+"',"+"'"+clsComplexDimInfocach.Name+"',"+"'"+strcomplex_type+"')";
   OleDbCommand cmd = new OleDbCommand(inser,conn);
   conn.Open();

　   int result = cmd.ExecuteNonQuery();

　 //conn.Dispose();

　 cmd.Dispose();
conn.Close();

　 return result;

}

  [Ajax.AjaxMethod]
  public DataSet GetDataSet()
  {
   OleDbConnection conn = new OleDbConnection(System.Configuration.ConfigurationSettings.AppSettings["connectionString"]);
　      // SqlCommand cmd = new SqlCommand("select * from ajaxTable order by id", conn);
   OleDbCommand cmd = new OleDbCommand("select * from ajaxTable order by id", conn);

　 //SqlDataAdapter ap = new SqlDataAdapter( cmd );
OleDbDataAdapter ap = new OleDbDataAdapter( cmd );

　 DataSet ds = new DataSet();

　 ap.SelectCommand.Connection.Open();

　 ap.Fill( ds, "db" );

　 conn.Dispose();

　 cmd.Dispose();
return ds;

}
[Ajax.AjaxMethod]

public string GetAjaxTable( string Ttop, string Tleft,string Theight,string Twidth,string Tposition)

{

　 //这个方法就是拿到datagrid生成出来的html

　     //   SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["connectionString"]);
   OleDbConnection conn = new OleDbConnection(System.Configuration.ConfigurationSettings.AppSettings["connectionString"]);
　      // SqlCommand cmd = new SqlCommand("select * from ajaxTable order by id", conn);
   OleDbCommand cmd = new OleDbCommand("select * from ajaxTable order by id", conn);

　 //SqlDataAdapter ap = new SqlDataAdapter( cmd );
OleDbDataAdapter ap = new OleDbDataAdapter( cmd );

　 DataSet ds = new DataSet();

　 ap.SelectCommand.Connection.Open();

　 ap.Fill( ds, "db" );

　 conn.Dispose();

　 cmd.Dispose();

　 //实例化一个datagird类并设置好数据源

   //   DataGrid dg = new DataGrid();

   //   TextBox dg = new TextBox();
   //   dg.Text = ds.Tables["db"].Rows[0][0].ToString();

   System.Web.UI.WebControls.DataGrid DataGrid2 = new DataGrid();
   DataGrid2.Style.Add("Left",Tleft);
   DataGrid2.Style.Add("Top",Ttop);
   DataGrid2.Style.Add("POSITION",Tposition);
   //DataGrid1.Style.Add("Z-INDEX","102");
   DataGrid2.Style.Add("height",Theight);
   DataGrid2.Style.Add("width",Twidth);
   // DataGrid dg = new DataGrid();
　     DataGrid2.DataSource = ds.Tables["db"];

　      DataGrid2.DataBind();
   DataGrid2.ID="DataGrid1";



   //   DataGrid2.DataSource = ds.Tables["db"];
   //   DataGrid2.DataBind();

　 //实例化一个HtmlTextWriter的类

　 System.Text.StringBuilder strb = new System.Text.StringBuilder();

　 System.IO.StringWriter sw = new System.IO.StringWriter( strb );

　 System.Web.UI.HtmlTextWriter htw = new HtmlTextWriter( sw );

　 //执行控件的render并输出到HtmlTextWriter里

　 DataGrid2.RenderControl( htw );
//DataGrid2.RenderControl(htw);

　 string s = strb.ToString();

　 return s;//最后就是返回这个html啦

}

客户端：

function AddAjax(name) { 　 document.getElementById("AddTextBox").value = ""; Third.AddAjaxTable(name); 　 LoadGrid(); } function LoadGrid() { 　var Ttop = document.getElementById("DataGrid1").style.top; var Tleft = document.getElementById("DataGrid1").style.left; var Theight = document.getElementById("DataGrid1").style.height; var Twidth = document.getElementById("DataGrid1").style.width; var Tposition = document.getElementById("DataGrid1").style.position; 　 document.getElementById('DataGrid1').outerHTML = Third.GetAjaxTable(Ttop,Tleft,Theight,Twidth,Tposition).value; 　　 var dataset = Third.GetDataSet(); 　 var dd = dataset.value; 　 //alert(dd.Tables[0].Rows.length); 　 //document.getElementById('Temp').innerText = dd.Tables[0].Rows[0].id;//id;//dd.Tables[0].Rows[0]["id"];直接加id也行　　 var tab = document.getElementById("DataGrid1"); 　 document.getElementById('Temp').innerText = tab.rows[1].cells[0].innerHTML; //for(var y=0; y