#region Component Designer generated code /// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.sqlDataAdapter1 = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlConnection1 = new System.Data.SqlClient.SqlConnection(); // // sqlDataAdapter1 // this.sqlDataAdapter1.SelectCommand = this.sqlSelectCommand1; this.sqlDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Action", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("IssueId", "IssueId"), new System.Data.Common.DataColumnMapping("Title", "Title"), new System.Data.Common.DataColumnMapping("ItemType", "ItemType"), new System.Data.Common.DataColumnMapping("Area", "Area"), new System.Data.Common.DataColumnMapping("MileStone", "MileStone"), new System.Data.Common.DataColumnMapping("Project", "Project"), new System.Data.Common.DataColumnMapping("Priority", "Priority"), new System.Data.Common.DataColumnMapping("Status", "Status"), new System.Data.Common.DataColumnMapping("AssignTo", "AssignTo")})}); // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = @"SELECT Issue.IssueId, Issue.Title, Issue.ItemType, Issue.Area, Issue.MileStone, Issue.Project, Action.Priority, Action.Status, Action.AssignTo, Action.ActionId, Action.IssueId AS Expr1 FROM Action INNER JOIN Issue ON Action.IssueId = Issue.IssueId WHERE (Action.ActionId IN (SELECT MAX(ActionId) FROM Action GROUP BY IssueId))"; this.sqlSelectCommand1.Connection = this.sqlConnection1; // // sqlConnection1 // this.sqlConnection1.ConnectionString = "data source=服务器;initial catalog=issuetracker;persist security info=False;" + "user id=;password=;workstation id=服务器;packet size=4096";这是原来的sql语句,这次该怎末绑定,我怎末把传回的值作为条件写新的sql??? } #endregion
<script language="javascript">
function show()
{
document.Form1.TextBox1.value=window.showModalDialog("WebForm2.aspx");
}
</script>
然后在2.aspx中按钮事件中加代码:
Response.Write("<script> window.returnValue='"+this.TextBox1.Text+"'</script>");
Response.Write("<script>window.close()</script>");
目的是让2.aspx中TextBox1中的数据传到1.aspx中的TextBox1中
button1_click()里面 是BindGrid(txtName.text)pop.aspx中,确定按钮,中代码如下:
Response.Write("<script language=javascript>opener.document.all.txtName.value='" & strName & "';opener.document.all.button1.click();window.close()</script>")原理是 pop.aspx页面更改main.aspx里txtName的值,然后重新绑定datagrid。
推荐用SESSION解决!
将隐藏域中的内容发送到服务端,服务端再进行相应的处理,根据隐藏域中的内容从数据库中取得内容,显示到datagrid.
button1_click()里面 是BindGrid(txtName.text)不行,报错BindGrid
将隐藏域中的内容发送到服务端,服务端再进行相应的处理,根据隐藏域中的内容从数据库中取得内容,显示到datagrid 这一步如何完成?
我也在考虑这方面的问题!在1.aspx中有个按钮,点击后弹出2.aspx,2.aspx是个日历表,用户选择一个日期后关闭2.aspx并且修改1.aspx中的一个label的值!!!难道要用上面这么复杂的方法吗???
将隐藏域中的内容发送到服务端,服务端再进行相应的处理,根据隐藏域中的内容从数据库中取得内容,显示到datagrid 这一步如何完成?
在服务端这个按钮的点击事件中做如下事:
1,读取隐藏域的内容
2,根据隐藏域的内容到数据库取数据放入dataset
3,把dataset冻datagrid绑定
{ if (!Page.IsPostBack)
{
if(this.TextBox1.Text.Trim() =="")
{
pIssue.FillData(this.issueDataSet1,"IssueID");
}
else
{
pIssue.FillData(this.issueDataSet1,this.TextBox1.Text.Trim());
}
this.DataGrid1.DataBind();
this.DataGrid1.SelectedIndex=0;
Session.Contents.Add("selectedIssueId","");
}
}弹出页面:private void cmdSearch_Click(object sender, System.EventArgs e)
{
string Project = this.ProjectSel.SelectedItem.Value.Trim();
string Status = this.StatusSel.SelectedItem.Value.Trim();
string AsssginTo = this.AsssginToSel.SelectedItem.Value.Trim();
string Priority = this.PrioritySel.SelectedItem.Value.Trim();
string conditionSel = Project + "&" + Status + "&" + AsssginTo + "&" + Priority ;
Response.Write("<script> window.opener.document.Form1.TextBox1.value = '"+conditionSel+"';opener.refresh();</script>");
Response.Write("<script language=javascript>window.close();</script>"); }
1、在pop.aspx页面中写一个刷新main.aspx页面的语句:
Response.Write("window.opener."+main页面的formID+".submit()"+"\n");
2、在main.aspx文件中放一个隐藏的TextBox,在传值时,传一个值到这个TextBox
3、在TextBox中的TextChanged事件里加入重新邦定DATAGRID的代码
先前我已经绑定了,要从新绑定,该怎末做?
刚接触C#,多多指点!!!
------------------------------------
你这次邦定是根据你传回的值来邦定的.两次邦定的SQL语句不同,其它相同.
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.sqlDataAdapter1 = new System.Data.SqlClient.SqlDataAdapter();
this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlConnection1 = new System.Data.SqlClient.SqlConnection();
//
// sqlDataAdapter1
//
this.sqlDataAdapter1.SelectCommand = this.sqlSelectCommand1;
this.sqlDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Action", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("IssueId", "IssueId"),
new System.Data.Common.DataColumnMapping("Title", "Title"),
new System.Data.Common.DataColumnMapping("ItemType", "ItemType"),
new System.Data.Common.DataColumnMapping("Area", "Area"),
new System.Data.Common.DataColumnMapping("MileStone", "MileStone"),
new System.Data.Common.DataColumnMapping("Project", "Project"),
new System.Data.Common.DataColumnMapping("Priority", "Priority"),
new System.Data.Common.DataColumnMapping("Status", "Status"),
new System.Data.Common.DataColumnMapping("AssignTo", "AssignTo")})});
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = @"SELECT Issue.IssueId, Issue.Title, Issue.ItemType, Issue.Area, Issue.MileStone, Issue.Project, Action.Priority, Action.Status, Action.AssignTo, Action.ActionId, Action.IssueId AS Expr1 FROM Action INNER JOIN Issue ON Action.IssueId = Issue.IssueId WHERE (Action.ActionId IN (SELECT MAX(ActionId) FROM Action GROUP BY IssueId))";
this.sqlSelectCommand1.Connection = this.sqlConnection1;
//
// sqlConnection1
//
this.sqlConnection1.ConnectionString = "data source=服务器;initial catalog=issuetracker;persist security info=False;" +
"user id=;password=;workstation id=服务器;packet size=4096";这是原来的sql语句,这次该怎末绑定,我怎末把传回的值作为条件写新的sql??? }
#endregion
this.sqlDataAdapter1
this.sqlSelectCommand1
并给sqlSelectCommand1赋以根据TextBox的sql语句,再sqlDataAdapter1.Fill基本上要把你上面列的代码都要在TextChanged事件里面再来一次
private void TextBox1_TextChanged(object sender, System.EventArgs e)
{
sqlSelectCommand1.CommandText = ""; //这里就是根据TextBox内容生成的sql语句了
sqlDataAdapter1.Fill(ds,"tablename"); //填充dataset,作为datagrid的数据源
}
{
pIssue.FillData(this.issueDataSet1,"IssueId");
DataGrid1.CurrentPageIndex = e.NewPageIndex;
DataGrid1.DataBind();
}
{
if( (this.TextBoxPro.Text == "" )//即排序前的显示数据
{
pIssue.FillData(this.issueDataSet1,"IssueId");
DataGrid1.CurrentPageIndex = e.NewPageIndex;
DataGrid1.DataBind();
}
else //即排序所要显示的数据
{
DataGrid1.CurrentPageIndex = e.NewPageIndex;
this.ButtonSel_Click();
}
}private void ButtonSel_Click(object sender, System.EventArgs e)
{//这里是Datasouce,DataBind,sqlDataAdapter}
出现的问题是入上所写,报错!!
但是如果把else中的this.ButtonSel_Click();去掉,而代之以private void ButtonSel_Click中的全部代码,就没有问题为什末是这样???
谢谢!!请指点一下!!
[email protected]
我做的第二个form点击按钮的时候会再弹出一个跟第二个form一样的页面,
就好像按了一下Ctrl+N一样