asp.net常用方法

1、后台向前台弹出alert提示框

Response.Write("＜script language=javascript＞alert("帐号不能为空")＜/script＞");

2、连接sql server数据库

//web.config文件中再增加一行

＜appSettings＞ 
＜add key="SqlDatabase1" value="data source=localhost;user id=sa;password=sa;initial catalog=AspNetABC;Connect Timeout=30" /＞ 
＜/appSettings＞ 

string strConnection = ConfigurationSettings.AppSettings["SqlDatabase1"]; 
string sqlMember = "SELECT MemberName ,[Password] FROM Member " 
+ " WHERE MemberName = "" + txtMemberName.Text.Trim() + """ 
+ " AND [Password] = "" + txtPassword.Text.Trim() + """; 

// 连接SqlServer数据库 
SqlConnection conn = new SqlConnection(strConnection); 
// 建立SqlCommand 
SqlCommand cmd = conn.CreateCommand(); 
cmd.CommandText = sqlMember; 
conn.Open(); 
// 建立DataReader 
SqlDataReader dr = cmd.ExecuteReader(); 

// 判断DataReader是否为空记录 
if (dr.HasRows) 
{ 
Response.Write("＜script language=javascript＞alert("" + txtMemberName.Text + "欢迎你！")＜/script＞"); 
} 
else 
{ 
Response.Write("＜script language=javascript＞alert("找不到该会员，或密码错误。")＜/script＞"); 
} 

// 千万不要忘记关闭DataReader 
dr.Close(); 

conn.Close(); 

2、插入数据到数据库

//连接
// 连接SqlServer数据库 
SqlConnection conn = new SqlConnection(strConnection); 
// 建立SqlCommand 
SqlCommand cmd = conn.CreateCommand(); 
cmd.CommandText = "INSERT INTO NewsArticle (Title, SubTitle, Writer, Content) valueS (" 
+ """ + txtTitle.Text + ""," 
+ """ + txtSubTitle.Text + ""," 
+ """ + txtWriter.Text + ""," 
+ """ + txtContent.Text + "")"; 
conn.Open(); 
//Response.Write (cmd.CommandText); 
 插入记录
try 
{ 
cmd.ExecuteNonQuery(); 
} 
catch (Exception ex) 
{ 
Response.Write("＜script language=javascript＞alert("输入错误，数据库不能更新。")＜/script＞"); 
} 
finally 
{ 
conn.Close(); 
} 
}