这是我今天的第二个贴了,,,因为第一个贴还想得到更多的建议所以分还没结,当然也因为太菜了所以还没弄没明白,,,分明天回来一定结,
下面的是个程序,,从上个星期开始弄到现在还没好使,二个问题,第一个问题是文本框想让它显示2007-04-10-0001,不会弄,然后想跳过只让它们都显示同样的日期却一个有显示而另一个没有,,第二问题是WEBGRID与数据库连接的问题,连不上数据库
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using CommonLibrary;namespace NetApp.Web.DigitSale
{
/// <summary>
/// CheckDealer 的摘要说明。
/// </summary>
public class CheckDealer : System.Web.UI.Page
{
protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.WebControls.TextBox TextBox1;
protected System.Web.UI.WebControls.Label Label2;
protected System.Web.UI.WebControls.TextBox TextBox2;
protected System.Web.UI.WebControls.Label Label3;
protected System.Web.UI.WebControls.Label Label4;
protected ISNet.WebUI.WebCombo.WebCombo WebCombo1;
protected ISNet.WebUI.WebCombo.WebCombo WebCombo2;
protected ISNet.WebUI.WebGrid.WebGrid WebGrid1;
protected System.Web.UI.WebControls.Label Label5;
private DataSet dataset;
protected System.Web.UI.WebControls.ImageButton ImageButton2;
protected System.Web.UI.WebControls.ImageButton ImageButton1;
private void Page_Load(object sender, System.EventArgs e)
{
TextBox1.Text=System.DateTime.Today.ToString("yyyy-MM-dd");
TextBox2.Text=System.DateTime.Today.ToString("yyyy-MM-dd");
dataset = GetConditionData();
// 在此处放置用户代码以初始化页面
SetCondition();
} #region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.TextBox1.TextChanged += new System.EventHandler(this.TextBox1_TextChanged);
this.WebGrid1.InitializeDataSource += new ISNet.WebUI.WebGrid.DataSourceEventHandler(this.WebGrid1_InitializeDataSource);
this.ImageButton1.Click += new System.Web.UI.ImageClickEventHandler(this.ImageButton1_Click);
this.Load += new System.EventHandler(this.Page_Load); }
#endregion private DataSet GetConditionData()
{
return new DataManager().GetCheckCondition();
}
private void SetCondition()
{
this.WebCombo1.DataSource = dataset.Tables[1].DefaultView;
this.WebCombo1.DataTextField = "BaseName";
this.WebCombo1.DataValueField = "BaseNo";
this.WebCombo2.DataSource = dataset.Tables[3].DefaultView;
this.WebCombo2.DataTextField = "EmployeeCode";
this.WebCombo2.DataValueField = "EmployeeName";
this.DataBind();
} private void ImageButton1_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
string BaseNo;
if (this.WebCombo1.Value.Equals(""))
BaseNo = "%%";
else
BaseNo = this.WebCombo1.Value;
DataTable td =GetCheckerDealer(BaseNo);
this.WebGrid1.DataSource = td.DefaultView;
this.WebGrid1.DataBind();
}
private DataTable GetCheckerDealer(string BaseNo)
{
return SqlHelper.ExecuteDataset(ConfigInfo.UniqueInstance.ConnectionString,
System.Data.CommandType.StoredProcedure,"web_checkdealer",
this.GetStoreProcedureParameters("web_checkdealer",
new object[]{BaseNo})).Tables[0];
}
}
}
一方面,我不知道DataTable td =GetCheckerDealer(BaseNo);
this.WebGrid1.DataSource = td.DefaultView;
this.WebGrid1.DataBind();
这几条语句到底对不对,请高手们帮看一下,
另一方面,我运行时,总会显示生成项目出错,而this.GetStoreProcedureParameters下会出现波浪线,说GetStoreProcedureParameters无定义,那究竟怎么样才能出它的定义呢,请大家邦邦忙啊,,,,
我真的很菜,,,,,,
下面的是个程序,,从上个星期开始弄到现在还没好使,二个问题,第一个问题是文本框想让它显示2007-04-10-0001,不会弄,然后想跳过只让它们都显示同样的日期却一个有显示而另一个没有,,第二问题是WEBGRID与数据库连接的问题,连不上数据库
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using CommonLibrary;namespace NetApp.Web.DigitSale
{
/// <summary>
/// CheckDealer 的摘要说明。
/// </summary>
public class CheckDealer : System.Web.UI.Page
{
protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.WebControls.TextBox TextBox1;
protected System.Web.UI.WebControls.Label Label2;
protected System.Web.UI.WebControls.TextBox TextBox2;
protected System.Web.UI.WebControls.Label Label3;
protected System.Web.UI.WebControls.Label Label4;
protected ISNet.WebUI.WebCombo.WebCombo WebCombo1;
protected ISNet.WebUI.WebCombo.WebCombo WebCombo2;
protected ISNet.WebUI.WebGrid.WebGrid WebGrid1;
protected System.Web.UI.WebControls.Label Label5;
private DataSet dataset;
protected System.Web.UI.WebControls.ImageButton ImageButton2;
protected System.Web.UI.WebControls.ImageButton ImageButton1;
private void Page_Load(object sender, System.EventArgs e)
{
TextBox1.Text=System.DateTime.Today.ToString("yyyy-MM-dd");
TextBox2.Text=System.DateTime.Today.ToString("yyyy-MM-dd");
dataset = GetConditionData();
// 在此处放置用户代码以初始化页面
SetCondition();
} #region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.TextBox1.TextChanged += new System.EventHandler(this.TextBox1_TextChanged);
this.WebGrid1.InitializeDataSource += new ISNet.WebUI.WebGrid.DataSourceEventHandler(this.WebGrid1_InitializeDataSource);
this.ImageButton1.Click += new System.Web.UI.ImageClickEventHandler(this.ImageButton1_Click);
this.Load += new System.EventHandler(this.Page_Load); }
#endregion private DataSet GetConditionData()
{
return new DataManager().GetCheckCondition();
}
private void SetCondition()
{
this.WebCombo1.DataSource = dataset.Tables[1].DefaultView;
this.WebCombo1.DataTextField = "BaseName";
this.WebCombo1.DataValueField = "BaseNo";
this.WebCombo2.DataSource = dataset.Tables[3].DefaultView;
this.WebCombo2.DataTextField = "EmployeeCode";
this.WebCombo2.DataValueField = "EmployeeName";
this.DataBind();
} private void ImageButton1_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
string BaseNo;
if (this.WebCombo1.Value.Equals(""))
BaseNo = "%%";
else
BaseNo = this.WebCombo1.Value;
DataTable td =GetCheckerDealer(BaseNo);
this.WebGrid1.DataSource = td.DefaultView;
this.WebGrid1.DataBind();
}
private DataTable GetCheckerDealer(string BaseNo)
{
return SqlHelper.ExecuteDataset(ConfigInfo.UniqueInstance.ConnectionString,
System.Data.CommandType.StoredProcedure,"web_checkdealer",
this.GetStoreProcedureParameters("web_checkdealer",
new object[]{BaseNo})).Tables[0];
}
}
}
一方面,我不知道DataTable td =GetCheckerDealer(BaseNo);
this.WebGrid1.DataSource = td.DefaultView;
this.WebGrid1.DataBind();
这几条语句到底对不对,请高手们帮看一下,
另一方面,我运行时,总会显示生成项目出错,而this.GetStoreProcedureParameters下会出现波浪线,说GetStoreProcedureParameters无定义,那究竟怎么样才能出它的定义呢,请大家邦邦忙啊,,,,
我真的很菜,,,,,,
private void Page_Load(object sender, System.EventArgs e)
{
strID = "20070101001";
strID =strID.Substring(8,3);
int intID = Toint32(strID) + 1;
strID = intID.ToString();
TextBox1.Text=System.DateTime.Today.ToString("yyyy-MM-dd")+strID
TextBox2.Text=System.DateTime.Today.ToString("yyyy-MM-dd");
dataset = GetConditionData();
// 在此处放置用户代码以初始化页面
SetCondition();
}
private void Page_Load(object sender, System.EventArgs e)
{
string strID;
strID = "20070101001";
strID =strID.Substring(8,3);
int intID = Toint32(strID) + 1;
strID = intID.ToString();
TextBox1.Text=System.DateTime.Today.ToString("yyyy-MM-dd")+strID
TextBox2.Text=System.DateTime.Today.ToString("yyyy-MM-dd");
dataset = GetConditionData();
// 在此处放置用户代码以初始化页面
SetCondition();
}
{
string strID;
strID = "20070101001";
strID =strID.Substring(8,3);
int intID = Convert.Toint32(strID) + 1;
strID = intID.ToString();
TextBox1.Text=System.DateTime.Today.ToString("yyyy-MM-dd")+strID;
TextBox2.Text=System.DateTime.Today.ToString("yyyy-MM-dd");
dataset = GetConditionData();
// 在此处放置用户代码以初始化页面
SetCondition();
}我加的是不是不对啊,还是没有显示,而且,Convert.Toint32(strID)下面还是有波浪线的
请大家帮帮忙吧,,,,,,,,,,,,,,,
string str = DateTime.ParseExact(strID, "yyyyMMddHHmm", null).ToString("yyyy-MM-dd-HHmm");
TextBox1.Text = str;
TextBox2.Text = str;这样就显示出你要的效果了
还有,
TextBox1.Text=System.DateTime.Today.ToString("yyyy-MM-dd")+strID;
这条语句的文本框依然没有显示,,,,,,
这样赋值……
DataSet dataset = GetConditionData();
{
string strID = "200701010001";
string str = DateTime.ParseExact(strID, "yyyyMMddHHmm", null).ToString("yyyy-MM-dd-HHmm");
TextBox1.Text = str;
TextBox2.Text = str; DataSet dataset = GetConditionData();
// 在此处放置用户代码以初始化页面
SetCondition();
}改成这样之后,文本框一依然没有显示,而文本框显示为2007-04-11它们真的很顽固
System.DateTime.Now代表当前系统时间,你要是想显示格式化的当前系统时间,直接用
TextBox1.Text = System.DateTime.Now.ToString("yyyy-MM-dd-HHmm");
这条语句在每个服务器组件语句里都包含了, 只是右健网页的那项并没有打勾
private void Page_Load(object sender, System.EventArgs e)
{
TextBox1.Text=System.DateTime.Today.ToString("yyyy-MM-dd")+"-";
TextBox2.Text=System.DateTime.Today.ToString("yyyy-MM-dd")+"-";
DataSet dataset = GetConditionData();
// 在此处放置用户代码以初始化页面
SetCondition();
}我把代码换成上面的那种形式,只在日期后面加一个"-"
但是结果还是一样,文本框一没有显示,文本框二只有显示2004-04-11
前面的HTML代码为
<%@ Register TagPrefix="iswebgrid" Namespace="ISNet.WebUI.WebGrid" Assembly="ISNet.WebUI.WebGrid" %>
<%@ Register TagPrefix="iswebcombo" Namespace="ISNet.WebUI.WebCombo" Assembly="ISNet.WebUI.WebCombo" %>
<%@ Page language="c#" Codebehind="CheckDealer.aspx.cs" AutoEventWireup="false" Inherits="NetApp.Web.DigitSale.CheckDealer" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>CheckDealer</title>
<meta content="Microsoft Visual Studio .NET 7.1" name="GENERATOR">
<meta content="C#" name="CODE_LANGUAGE">
<meta content="JavaScript" name="vs_defaultClientScript">
<meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema">
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<FONT face="宋体" id="FONT1" runat="server">
<asp:label id="Label1" style="Z-INDEX: 101; LEFT: 24px; POSITION: absolute; TOP: 32px" runat="server"
Font-Size="9pt">盘点单号</asp:label><asp:textbox id="TextBox1" style="Z-INDEX: 102; LEFT: 88px; POSITION: absolute; TOP: 24px" runat="server"></asp:textbox><asp:label id="Label2" style="Z-INDEX: 103; LEFT: 256px; POSITION: absolute; TOP: 32px" runat="server"
Font-Size="9pt">盘点日期</asp:label><asp:textbox id="TextBox2" style="Z-INDEX: 104; LEFT: 320px; POSITION: absolute; TOP: 24px" runat="server"></asp:textbox><asp:label id="Label3" style="Z-INDEX: 105; LEFT: 24px; POSITION: absolute; TOP: 64px" runat="server"
{
TextBox1.Text=System.DateTime.Now.ToString("yyyy-MM-dd-");
TextBox2.Text=System.DateTime.Now.ToString("yyyy-MM-dd-"); DataSet dataset = GetConditionData();
//在此处放置用户代码以初始化页面
SetCondition();
}<form id="Form1" method="post" runat="server">
<FONT face="宋体" id="FONT1" runat="server">
<asp:label id="Label1" style="Z-INDEX: 101; LEFT: 24px; POSITION: absolute; TOP: 32px" runat="server" Font-Size="9pt">盘点单号</asp:label>
<asp:textbox id="TextBox1" style="Z-INDEX: 102; LEFT: 88px; POSITION: absolute; TOP: 24px" runat="server"></asp:textbox>
<asp:label id="Label2" style="Z-INDEX: 103; LEFT: 256px; POSITION: absolute; TOP: 32px" runat="server" Font-Size="9pt">盘点日期</asp:label>
<asp:textbox id="TextBox2" style="Z-INDEX: 104; LEFT: 320px; POSITION: absolute; TOP: 24px" runat="server"></asp:textbox>
</FONT>
</form>
上边代码运行之后会在TextBox1和TextBox2中显示:2007-04-11-