本文介绍两种ASP.Net项目中全局变量使用的方式。web.config文件 和 Gloab文件。以下分别说明：
方法一：web.config文件
——设置：
在web.config文件里添加关键字key是通过<appSettings>标记来实现的，但是appSettings标记通常放在<system.web>.....</system.web>标记外面。例：
<configration>
<appSettings>
<add key="connString1" value="server=localhost;user id=sa;pwd=;database=数据库名字"/>
<add key="connString2" value="provider=Microsoft.Jet.OleDb.4.0;Data Source=数据库路径"/>
</appSettings>
<system.web>
</system.web>
</configration>
——读取：
要在代码中引用这些数据库连接字符串，需要先添加对System.ConFiguration名字空间的引用，在这个名字空间中含有ConfigurationSettings类，其静态方法ConfigurationSettings.AppSettings属性可获取web.config文件中<appSettings>节的设置，读到的值为string型。例如：
using System.Configuration;
string conn1 = ConfigurationSettings.AppSettings["connString1"];
string ......
3 mistakes to avoid when using jQuery with ASP.NET AJAX
AJAX, ASP.NET, JavaScript, jQuery By Dave Ward on June 5th, 2008
Over the past few weeks, I think I have definitely embodied Jeff Atwood’s claim that we’re all amateurs, learning together. Despite my best efforts to thoroughly test before posting, a few problems slipped through in my recent posts about using jQuery to consume ASP.NET JSON serialized web services and using jQuery to call ASP.NET AJAX page methods.
On the bright side, your great feedback in both posts’ comments has reinforced the fact that some of the best content on my blog is the part that you write.
In this post, I’m going to detail three of the problems that were discovered as a result of those previous two posts:
An extra requirement when making a read-only request to IIS6+.
An oddity in Internet Explorer 7’s XmlHttpRequest class.
A common mistake when passing JSON parameters through jQuery.
Finally, I’ll suggest w ......
3 mistakes to avoid when using jQuery with ASP.NET AJAX
AJAX, ASP.NET, JavaScript, jQuery By Dave Ward on June 5th, 2008
Over the past few weeks, I think I have definitely embodied Jeff Atwood’s claim that we’re all amateurs, learning together. Despite my best efforts to thoroughly test before posting, a few problems slipped through in my recent posts about using jQuery to consume ASP.NET JSON serialized web services and using jQuery to call ASP.NET AJAX page methods.
On the bright side, your great feedback in both posts’ comments has reinforced the fact that some of the best content on my blog is the part that you write.
In this post, I’m going to detail three of the problems that were discovered as a result of those previous two posts:
An extra requirement when making a read-only request to IIS6+.
An oddity in Internet Explorer 7’s XmlHttpRequest class.
A common mistake when passing JSON parameters through jQuery.
Finally, I’ll suggest w ......
刚学习.Net没有多长时间，以前都是看别人的文章，学习前辈们的经验和技巧，自己受益匪浅。今天也来个原创的，发个文件上传的代码。主要实现的功能有：1.可以控制允许上传的文件类型；2.上传之后自动以时间命名；3.自动创建上传文件要保存的目录。
不足之处：没有对允许上传的文件大小做限制。其他不足之处还望各位指出，以便改进。第一次发文章，鲜花、砖头自己准备！呵呵~~~
要引入命名空间 System.IO;
#region 上传文件
protected void btn_upload_Click(object sender, EventArgs e)
{
bool fileOK = false;
//文件的上传路径
string path = Server.MapPath("~/UpLoadFiles/Files/");
//判断上传文件夹是否存在，若不存在，则创建
if (!Directory.Exists(path))
{
//创� ......
using (con)
{
con.Open();
String sqltext = "select * from emp where empno=@empno";
SqlCommand cmd = new SqlCommand(sqltext, con);
cmd.Parameters.AddWithValue("@empno", this.TextBox.Text);
GridView1.DataSource = cmd.ExecuteReader();
GridView1.DataBind();
}
即使用参数化，而不是直接拼接sql语句，简单有效，能基本应对网站的一般安全要求。但是每个sql语句又要参数化，对于参数比较多的语句写起来比较麻烦。 ......
using (con)
{
con.Open();
String sqltext = "select * from emp where empno=@empno";
SqlCommand cmd = new SqlCommand(sqltext, con);
cmd.Parameters.AddWithValue("@empno", this.TextBox.Text);
GridView1.DataSource = cmd.ExecuteReader();
GridView1.DataBind();
}
即使用参数化，而不是直接拼接sql语句，简单有效，能基本应对网站的一般安全要求。但是每个sql语句又要参数化，对于参数比较多的语句写起来比较麻烦。 ......
第一种：需要引用com ：microsoft.excel.11.0.
//生成Excel文件的代码
protected void ExportExcel()
{
Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbook wb = excel.Workbooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet); // 创建工作簿
Microsoft.Office.Interop.Excel.Worksheet ws = (Microsoft.Office.Interop.Excel.Worksheet)wb.Worksheets[1]; // 创建工作页
DataSet ds = GetData();
int iMaxRow = ds.Tables["rsData"].Rows.Count;
int iMaxCol = ds.Tables["rsData"].Columns.Count;
// 设置格式
ws.get_Range(ws.Cells[1, 1], ws.Cells[1, iMaxCol]).Font.Name = "黑体";
ws.get_Range(ws.Cells[1, 1], ws.Cells[1, iMaxCol]).Font.Bold = true;
ws.get_Range(ws.Cells[1, 1], ws.Cells[iMaxRow + 1, iMaxCol]).Borders.LineStyle = 1;
......
在ASP.NET应用程序常常会遇到需要从Excel文件中读取数据或将数据写入Excel的需求。一般来讲，在ASP.NET中读写Excel文件有四种解决方案。
1.1.1 使用OLE DB
使用OLE DB可以以查询数据库的方式来读取Excel文件，因为在某种程度上Excel表格可以看成是一张一张的数据表。其二者的主要区别在于所使用的数据引擎不一样。使用OLE DB访问Excel的要点是计算机上必须具有Microsoft Access Data Component 2.6(MADC2.6)以上版本，同时在连接字符串上必须声明“Extended Properties=Excel 8.0”，这里的指定Excel 版本号如果高于8.0可能会出错，所以一般来讲必须使用Excel 8.0。
然后其它的写法就和一般的访问数据库一样了，打开连接，填充数据集，再关闭连接即可。例如下面的实现代码：
//创建一个数据链接
string strCon = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = c:\\sample.xls;Extended Properties=Excel 8.0" ;
OleDbConnection myConn = new OleDbConnection ( strCon ) ;
string strCom = " SELECT * from [Sheet1$] " ;
myConn.Open ( ) ;
//打开数据链接，得到一个数据集
OleDbDataAdapter myCommand = new OleDbDataAd ......
最新文章 : asp.net