.aspx:
<asp:TextBox ID="txtend" runat="server"></asp:TextBox></td>
该aspx代码将在其文本字段中存储“日期”。
我想在c#中访问此文本字段,其中代码中的代码显示为如何将字符串格式转换为日期类型并获得访问权限。
SqlDataAdapter adapter = new SqlDataAdapter(
"select * from Membership_det where updateDate is between "+txtstart.Text+" and "+txtend.Text+" ",
con);
DateTime startDate;
DateTime endDate;
if (DateTime.TryParse(txtstart.Text, out startDate) && DateTime.TryParse(txtend.Text, out endDate))
{
//string n1 = DropDownList2.SelectedItem.Text;
if (DropDownList1.SelectedItem.Text == "Membership")
{
SqlConnection con = new
SqlConnection(ConfigurationManager.ConnectionStrings["ProjectConnectionString"].ToString());
con.Open();
SqlDataAdapter adapter = new SqlDataAdapter("select p.Name,m.FID,m.MembNo,m.MembType,m.Validity,m.Remarks from Membership_det m INNER JOIN Personal_det p ON m.FID= p.FID where m.updateDate between @Start and @End ", con);
adapter.SelectCommand.Parameters.Add("@Start", SqlDbType.Date).Value = startDate;
adapter.SelectCommand.Parameters.Add("@End", SqlDbType.Date).Value = endDate;
DataTable dt = new DataTable();
adapter.Fill(dt);
con.Close();
GridView1.DataSource = dt;
GridView1.DataBind();
}
log.Debug("Info: Admin viewed the membership details");
}
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句