Imports System.Data
Imports System.Data.SqlClientPublic Class WebForm1
Inherits System.Web.UI.Page#Region " Web 窗体设计器生成的代码 " '该调用是 Web 窗体设计器所必需的。
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent() End Sub
Protected WithEvents Label1 As System.Web.UI.WebControls.Label
Protected WithEvents Label2 As System.Web.UI.WebControls.Label
Protected WithEvents TextBox1 As System.Web.UI.WebControls.TextBox
Protected WithEvents TextBox2 As System.Web.UI.WebControls.TextBox
Protected WithEvents Button1 As System.Web.UI.WebControls.Button
Protected WithEvents Button2 As System.Web.UI.WebControls.Button
Protected WithEvents Button3 As System.Web.UI.WebControls.Button
Protected WithEvents Label3 As System.Web.UI.WebControls.Label
Protected WithEvents Label4 As System.Web.UI.WebControls.Label
Protected WithEvents DataGrid1 As System.Web.UI.WebControls.DataGrid
Protected WithEvents Button4 As System.Web.UI.WebControls.Button
Protected WithEvents Button5 As System.Web.UI.WebControls.Button '注意: 以下占位符声明是 Web 窗体设计器所必需的。
'不要删除或移动它。
Private designerPlaceholderDeclaration As System.Object Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
'CODEGEN: 此方法调用是 Web 窗体设计器所必需的
'不要使用代码编辑器修改它。
InitializeComponent()
End Sub#End Region Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
End Sub
'在此处放置初始化页的用户代码 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim a As String
Try
Dim conn As New SqlConnection("Server=(local);Database=shiyan;Uid=sa;pwd=jkx2004")
Dim cmd As New SqlCommand("select * from dhl_hy where 学号='" + TextBox1.Text + "'", conn)
conn.Open()
Dim dr As SqlDataReader = cmd.ExecuteReader()
dr.Read() a = dr.GetValue(2)
If TextBox2.Text.Trim.ToString = a.Trim.ToString Then
Label2.Text = "登陆成功"
Else
Label2.Text = "登录不成功"
End If
If Label2.Text = "登陆成功" Then
Button4.Enabled = True
Else
Button4.Enabled = False
End If
Catch ee As Exception
Label2.Text = "该用户不存在"
End Try
End Sub Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Response.Redirect("webform2.aspx")
End Sub Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click
Dim conn As New SqlConnection("Server=(local);Database=shiyan;Uid=sa;pwd=jkx2004")
Dim cmd As New SqlCommand("select * from dhl_hy where 学号='" + TextBox1.Text + "' ", conn)
conn.Open()
Dim dr As SqlDataReader = cmd.ExecuteReader() '建立DataReader对象
DataGrid1.DataSource = dr '指定数据源
DataGrid1.DataBind() '执行绑定:显示内容
conn.Close()
End Sub Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
Response.Redirect("webform3.aspx")
End Sub Private Sub Button5_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button5.Click
Response.Redirect("webform1.aspx")
End Sub
End Class
Imports System.Data.SqlClientPublic Class WebForm1
Inherits System.Web.UI.Page#Region " Web 窗体设计器生成的代码 " '该调用是 Web 窗体设计器所必需的。
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent() End Sub
Protected WithEvents Label1 As System.Web.UI.WebControls.Label
Protected WithEvents Label2 As System.Web.UI.WebControls.Label
Protected WithEvents TextBox1 As System.Web.UI.WebControls.TextBox
Protected WithEvents TextBox2 As System.Web.UI.WebControls.TextBox
Protected WithEvents Button1 As System.Web.UI.WebControls.Button
Protected WithEvents Button2 As System.Web.UI.WebControls.Button
Protected WithEvents Button3 As System.Web.UI.WebControls.Button
Protected WithEvents Label3 As System.Web.UI.WebControls.Label
Protected WithEvents Label4 As System.Web.UI.WebControls.Label
Protected WithEvents DataGrid1 As System.Web.UI.WebControls.DataGrid
Protected WithEvents Button4 As System.Web.UI.WebControls.Button
Protected WithEvents Button5 As System.Web.UI.WebControls.Button '注意: 以下占位符声明是 Web 窗体设计器所必需的。
'不要删除或移动它。
Private designerPlaceholderDeclaration As System.Object Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
'CODEGEN: 此方法调用是 Web 窗体设计器所必需的
'不要使用代码编辑器修改它。
InitializeComponent()
End Sub#End Region Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
End Sub
'在此处放置初始化页的用户代码 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim a As String
Try
Dim conn As New SqlConnection("Server=(local);Database=shiyan;Uid=sa;pwd=jkx2004")
Dim cmd As New SqlCommand("select * from dhl_hy where 学号='" + TextBox1.Text + "'", conn)
conn.Open()
Dim dr As SqlDataReader = cmd.ExecuteReader()
dr.Read() a = dr.GetValue(2)
If TextBox2.Text.Trim.ToString = a.Trim.ToString Then
Label2.Text = "登陆成功"
Else
Label2.Text = "登录不成功"
End If
If Label2.Text = "登陆成功" Then
Button4.Enabled = True
Else
Button4.Enabled = False
End If
Catch ee As Exception
Label2.Text = "该用户不存在"
End Try
End Sub Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Response.Redirect("webform2.aspx")
End Sub Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click
Dim conn As New SqlConnection("Server=(local);Database=shiyan;Uid=sa;pwd=jkx2004")
Dim cmd As New SqlCommand("select * from dhl_hy where 学号='" + TextBox1.Text + "' ", conn)
conn.Open()
Dim dr As SqlDataReader = cmd.ExecuteReader() '建立DataReader对象
DataGrid1.DataSource = dr '指定数据源
DataGrid1.DataBind() '执行绑定:显示内容
conn.Close()
End Sub Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
Response.Redirect("webform3.aspx")
End Sub Private Sub Button5_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button5.Click
Response.Redirect("webform1.aspx")
End Sub
End Class
解决方案 »
- 怎样可以在asp.net网页上弹出浏览网页对话框,且可以实现多选
- 控件点击没反应。在线等
- nHibernate的一个问题
- 十万火急关于面向对象的设计模式
- vs2008新建网站 不可选状态
- 为什么SESSION这么快就超时了,有什么办法解决吗?
- DataGrid绑定数据更新的问题?
- 报表中饼图怎么在图中显示数值和百分比?
- VSS如何撤销别人的修改
- 请问:BC30002: 未定义类型“ADOConnection”是什么原因?
- 对于.net网站,看到好多网址页面的url不是xx.aspx,而是xx.action。这是什么意思?
- asp.net4.0+sql2008 多用户同时操作时 页面显示错误数据
在线转工具
可以把vb.net转为C#
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Diagnostics;
using System.Data.SqlClient;public class WebForm1 : System.Web.UI.Page
{ #region " Web 窗体设计器生成的代码 " //该调用是 Web 窗体设计器所必需的。
[System.Diagnostics.DebuggerStepThrough()] private void InitializeComponent()
{
}
protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.WebControls.Label Label2;
protected System.Web.UI.WebControls.TextBox TextBox1;
protected System.Web.UI.WebControls.TextBox TextBox2;
private System.Web.UI.WebControls.Button withEventsField_Button1;
protected System.Web.UI.WebControls.Button Button1 {
get { return withEventsField_Button1; }
set {
if (withEventsField_Button1 != null) {
withEventsField_Button1.Click -= Button1_Click;
}
withEventsField_Button1 = value;
if (withEventsField_Button1 != null) {
withEventsField_Button1.Click += Button1_Click;
}
}
}
private System.Web.UI.WebControls.Button withEventsField_Button2;
protected System.Web.UI.WebControls.Button Button2 {
get { return withEventsField_Button2; }
set {
if (withEventsField_Button2 != null) {
withEventsField_Button2.Click -= Button2_Click;
}
withEventsField_Button2 = value;
if (withEventsField_Button2 != null) {
withEventsField_Button2.Click += Button2_Click;
}
}
}
private System.Web.UI.WebControls.Button withEventsField_Button3;
protected System.Web.UI.WebControls.Button Button3 {
get { return withEventsField_Button3; }
set {
if (withEventsField_Button3 != null) {
withEventsField_Button3.Click -= Button3_Click;
}
withEventsField_Button3 = value;
if (withEventsField_Button3 != null) {
withEventsField_Button3.Click += Button3_Click;
}
}
}
protected System.Web.UI.WebControls.Label Label3;
protected System.Web.UI.WebControls.Label Label4;
protected System.Web.UI.WebControls.DataGrid DataGrid1;
private System.Web.UI.WebControls.Button withEventsField_Button4;
protected System.Web.UI.WebControls.Button Button4 {
get { return withEventsField_Button4; }
set {
if (withEventsField_Button4 != null) {
withEventsField_Button4.Click -= Button4_Click;
}
withEventsField_Button4 = value;
if (withEventsField_Button4 != null) {
withEventsField_Button4.Click += Button4_Click;
}
}
}
private System.Web.UI.WebControls.Button withEventsField_Button5;
protected System.Web.UI.WebControls.Button Button5 {
get { return withEventsField_Button5; }
set {
if (withEventsField_Button5 != null) {
withEventsField_Button5.Click -= Button5_Click;
}
withEventsField_Button5 = value;
if (withEventsField_Button5 != null) {
withEventsField_Button5.Click += Button5_Click;
}
} }
//注意: 以下占位符声明是 Web 窗体设计器所必需的。
//不要删除或移动它。 private System.Object designerPlaceholderDeclaration;
private void Page_Init(System.Object sender, System.EventArgs e)
{
//CODEGEN: 此方法调用是 Web 窗体设计器所必需的
//不要使用代码编辑器修改它。
InitializeComponent();
} #endregion
private void Page_Load(System.Object sender, System.EventArgs e)
{ }
//在此处放置初始化页的用户代码 private void Button1_Click(System.Object sender, System.EventArgs e)
{
string a = null;
try {
SqlConnection conn = new SqlConnection("Server=(local);Database=shiyan;Uid=sa;pwd=jkx2004");
SqlCommand cmd = new SqlCommand("select * from dhl_hy where 学号='" + TextBox1.Text + "'", conn);
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
dr.Read(); a = dr.GetValue(2);
if (TextBox2.Text.Trim().ToString() == a.Trim().ToString()) {
Label2.Text = "登陆成功";
} else {
Label2.Text = "登录不成功";
}
if (Label2.Text == "登陆成功") {
Button4.Enabled = true;
} else {
Button4.Enabled = false;
}
} catch (Exception ee) {
Label2.Text = "该用户不存在";
}
} private void Button2_Click(System.Object sender, System.EventArgs e)
{
Response.Redirect("webform2.aspx");
} private void Button4_Click(System.Object sender, System.EventArgs e)
{
SqlConnection conn = new SqlConnection("Server=(local);Database=shiyan;Uid=sa;pwd=jkx2004");
SqlCommand cmd = new SqlCommand("select * from dhl_hy where 学号='" + TextBox1.Text + "' ", conn);
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
//建立DataReader对象
DataGrid1.DataSource = dr;
//指定数据源
DataGrid1.DataBind();
//执行绑定:显示内容
conn.Close();
} private void Button3_Click(System.Object sender, System.EventArgs e)
{
Response.Redirect("webform3.aspx");
} private void Button5_Click(System.Object sender, System.EventArgs e)
{
Response.Redirect("webform1.aspx");
}
public WebForm1()
{
Load += Page_Load;
Init += Page_Init;
}
}