using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Collections;
public partial class _Default : System.Web.UI.Page
{
SqlConnection conn;
SqlCommand da,da2;
SqlDataReader dr;
DataSet ds;
SqlDataAdapter sda;
protected void Page_Load(object sender, EventArgs e)
{
string s = @"Data Source=.\SQLEXPRESS;AttachDbFilename =D:\学习\chang\webvs\sql\words.mdf;
Integrated Security=True;Connect Timeout=30;User Instance=True";
conn = new SqlConnection(s);
s = "select * from words order by id DESC;";//倒序
da = new SqlCommand(s, conn);
conn.Open();
dr = da.ExecuteReader();
if (dr.Read())
{
Label1.Text = dr.GetString(0).ToString() + ":" + dr.GetString(1).ToString();
}
if (dr.Read())
{
Label2.Text = dr.GetString(0).ToString() + ":" + dr.GetString(1).ToString();
}
if (dr.Read())
{
Label3.Text = dr.GetString(0).ToString() + ":" + dr.GetString(1).ToString();
}
if (dr.Read())
{
Label4.Text = dr.GetString(0).ToString() + ":" + dr.GetString(1).ToString();
}
if (dr.Read())
{
Label5.Text = dr.GetString(0).ToString() + ":" + dr.GetString(1).ToString();
}
conn.Close();
/* 从前往后读数据
string s = @"Data Source=.\SQLEXPRESS;AttachDbFilename =D:\学习\chang\webvs\sql\words.mdf;
Integrated Security=True;Connect Timeout=30;User Instance=True";
conn = new SqlConnection(s);
conn.Open();
sda = new SqlDataAdapter("select * from words ", conn);
ds=new DataSet();
sda.Fill(ds);
Label1.Text = ds.Tables[0].Rows[0][0].ToString() + ":" + ds.Tables[0].Rows[0][1].ToString();
Label2.Text = ds.Tables[0].Rows[1][0].ToString() + ":" + ds.Tables[0].Rows[1][1].ToString();
Label3.Text = ds.Tables[0].Rows[2][0].ToString() + ":" + ds.Tables[0].Rows[2][1].ToString();
Label4.Text = ds.Tables[0].Rows[3][0].ToString() + ":" + ds.Tables[0].Rows[3][1].ToString();
Label5.Text = ds.Tables[0].Rows[4][0].ToString() + ":" + ds.Tables[0].Rows[4][1].ToString();
*/
/* 从前往后读数据
string s = @"Data Source=.\SQLEXPRESS;AttachDbFilename =D:\学习\chang\webvs\sql\words.mdf;
Integrated Security=True;Connect Timeout=30;User Instance=True";
conn = new SqlConnection(s);
s = "select * FROM words";
da = new SqlCommand(s, conn);
conn.Open();
dr = da.ExecuteReader();
if (dr.Read())
{
Label1.Text = dr.GetString(0).ToString() +":"+ dr.GetString(1).ToString();
}
if (dr.Read())
{
Label2.Text = dr.GetString(0).ToString() +":"+ dr.GetString(1).ToString();
}
if (dr.Read())
{
Label3.Text = dr.GetString(0).ToString() +":"+ dr.GetString(1).ToString();
}
conn.Close();*/
}
protected void Button1_Click(object sender, EventArgs e)
{
if (TextBox1.Text == "" || TextBox2.Text == "")
{
TextBox1.Text = "不能为空";
TextBox2.Text = "不能为空";
}else
{
string s = @"Data Source=.\SQLEXPRESS;AttachDbFilename =D:\学习\chang\webvs\sql\words.mdf;
Integrated Security=True;Connect Timeout=30;User Instance=True";
conn = new SqlConnection(s);
string a=Time();
string txt1 = "Insert Into words (speaker,text,id) Values('";
txt1 += TextBox1.Text + "','";
txt1 += TextBox2.Text +"','"+a+ "')";
conn.Open(); // 打开数据库连接
da = new SqlCommand(txt1, conn);
da.ExecuteNonQuery();
TextBox1.Text = "";
TextBox2.Text = "";
conn.Close();
}
}
string Time()
{
int a1;
string a2, a3, a4, a5, a6;
a1 = DateTime.Now.Year;
a2 = fun(DateTime.Now.Month);
a3 = fun(DateTime.Now.Day);
a4 = fun(DateTime.Now.Hour);
a5 = fun(DateTime.Now.Minute);
a6 = fun(DateTime.Now.Second);
return a1+a2+a3+a4+a5+a6;
}
string fun(int b)
{
string a;
switch (b)
{
case 0: a = "00"; break;
case 1: a = "01"; break;
case 2: a = "02"; break;
case 3: a = "03"; break;
case 4: a = "04"; break;
case 5: a = "05"; break;
case 6: a = "06"; break;
case 7: a = "07"; break;
case 8: a = "08"; break;
case 9: a = "09"; break;
default: a = "" + b; break;
}
return a;
}
}
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Collections;
public partial class _Default : System.Web.UI.Page
{
SqlConnection conn;
SqlCommand da,da2;
SqlDataReader dr;
DataSet ds;
SqlDataAdapter sda;
protected void Page_Load(object sender, EventArgs e)
{
string s = @"Data Source=.\SQLEXPRESS;AttachDbFilename =D:\学习\chang\webvs\sql\words.mdf;
Integrated Security=True;Connect Timeout=30;User Instance=True";
conn = new SqlConnection(s);
s = "select * from words order by id DESC;";//倒序
da = new SqlCommand(s, conn);
conn.Open();
dr = da.ExecuteReader();
if (dr.Read())
{
Label1.Text = dr.GetString(0).ToString() + ":" + dr.GetString(1).ToString();
}
if (dr.Read())
{
Label2.Text = dr.GetString(0).ToString() + ":" + dr.GetString(1).ToString();
}
if (dr.Read())
{
Label3.Text = dr.GetString(0).ToString() + ":" + dr.GetString(1).ToString();
}
if (dr.Read())
{
Label4.Text = dr.GetString(0).ToString() + ":" + dr.GetString(1).ToString();
}
if (dr.Read())
{
Label5.Text = dr.GetString(0).ToString() + ":" + dr.GetString(1).ToString();
}
conn.Close();
/* 从前往后读数据
string s = @"Data Source=.\SQLEXPRESS;AttachDbFilename =D:\学习\chang\webvs\sql\words.mdf;
Integrated Security=True;Connect Timeout=30;User Instance=True";
conn = new SqlConnection(s);
conn.Open();
sda = new SqlDataAdapter("select * from words ", conn);
ds=new DataSet();
sda.Fill(ds);
Label1.Text = ds.Tables[0].Rows[0][0].ToString() + ":" + ds.Tables[0].Rows[0][1].ToString();
Label2.Text = ds.Tables[0].Rows[1][0].ToString() + ":" + ds.Tables[0].Rows[1][1].ToString();
Label3.Text = ds.Tables[0].Rows[2][0].ToString() + ":" + ds.Tables[0].Rows[2][1].ToString();
Label4.Text = ds.Tables[0].Rows[3][0].ToString() + ":" + ds.Tables[0].Rows[3][1].ToString();
Label5.Text = ds.Tables[0].Rows[4][0].ToString() + ":" + ds.Tables[0].Rows[4][1].ToString();
*/
/* 从前往后读数据
string s = @"Data Source=.\SQLEXPRESS;AttachDbFilename =D:\学习\chang\webvs\sql\words.mdf;
Integrated Security=True;Connect Timeout=30;User Instance=True";
conn = new SqlConnection(s);
s = "select * FROM words";
da = new SqlCommand(s, conn);
conn.Open();
dr = da.ExecuteReader();
if (dr.Read())
{
Label1.Text = dr.GetString(0).ToString() +":"+ dr.GetString(1).ToString();
}
if (dr.Read())
{
Label2.Text = dr.GetString(0).ToString() +":"+ dr.GetString(1).ToString();
}
if (dr.Read())
{
Label3.Text = dr.GetString(0).ToString() +":"+ dr.GetString(1).ToString();
}
conn.Close();*/
}
protected void Button1_Click(object sender, EventArgs e)
{
if (TextBox1.Text == "" || TextBox2.Text == "")
{
TextBox1.Text = "不能为空";
TextBox2.Text = "不能为空";
}else
{
string s = @"Data Source=.\SQLEXPRESS;AttachDbFilename =D:\学习\chang\webvs\sql\words.mdf;
Integrated Security=True;Connect Timeout=30;User Instance=True";
conn = new SqlConnection(s);
string a=Time();
string txt1 = "Insert Into words (speaker,text,id) Values('";
txt1 += TextBox1.Text + "','";
txt1 += TextBox2.Text +"','"+a+ "')";
conn.Open(); // 打开数据库连接
da = new SqlCommand(txt1, conn);
da.ExecuteNonQuery();
TextBox1.Text = "";
TextBox2.Text = "";
conn.Close();
}
}
string Time()
{
int a1;
string a2, a3, a4, a5, a6;
a1 = DateTime.Now.Year;
a2 = fun(DateTime.Now.Month);
a3 = fun(DateTime.Now.Day);
a4 = fun(DateTime.Now.Hour);
a5 = fun(DateTime.Now.Minute);
a6 = fun(DateTime.Now.Second);
return a1+a2+a3+a4+a5+a6;
}
string fun(int b)
{
string a;
switch (b)
{
case 0: a = "00"; break;
case 1: a = "01"; break;
case 2: a = "02"; break;
case 3: a = "03"; break;
case 4: a = "04"; break;
case 5: a = "05"; break;
case 6: a = "06"; break;
case 7: a = "07"; break;
case 8: a = "08"; break;
case 9: a = "09"; break;
default: a = "" + b; break;
}
return a;
}
}