上传控件的使用:指定目录,默认大小4M;HTML控件,转换为服务器控件;
string destDir =Server.MapPath("./Upload");
string fileName =System.IO.Path.GetFileName (File1.PostedFile.FileName);
string destPath =System
外部控件的引用:.net下开发的控件; 原先开发的COM组件;
树控件的引用;ExpandLevel默认展开的层;SelectExpands属性,单击展开;
TAB控件的引用;(选项卡)tabstrip+multipage
自定义用户控件的使用:同普通页面的制作;提供公共属性;
类的操作:
数据库操作: SqlConnection objConn = new SqlConnection();//建立连接;
SqlCommand objCommand = new SqlCommand();//建立对象;
SqlDataReader bojReader =new SqlReader();
ExecuteScalar objExecute = new ExecuteScalar();//首记录
建立连接:string connectString ="data source=.;initial catalog=XXX;user id=sa;password=; Pooling=true; max pool size=100"
SqlConnection objConn = new SqlConnection(connectString);
objConn.Open();
Response.Write("ok");
objConn.Close();
string cmdText="sql 语句"
SqlCommand objCommand = new SqlCommand(comText,objConn);
objCommand.ExecuteNonQuery();
SqlDataReader objReader = objCommand.ExecuteReader();
while(objReader.Read())
{
Response.Write(objReader["UserName"].ToString());
}
SqlCommand objCommand = new SqlCommand("myTest",objConn); //myTest为存贮过程名
objCOmmand.Commandtype = CommandType.StoredProcedure;
objCommand.Paameteres.Add("@UserName","XXXX");
objCommand.Paameteres.Add("@ReturnValue",SqlDbtype.INT,4);
objCommand.Parameters["@ReturnValue"].Direction = ParameterDirection.Output;
objCommand.Paameteres.Add("@ReturnValue1",SqlDbtype.INT,4);
objCommand.Parameters["@ReturnValue1"].Direction = ParameterDirection.Output;
objCommand.ExecuteNonQuery();
Response.Write(objCommand.Parameters["@ReturnValue"].Value.ToString;
Response.Wreit("--");
Response.Write(objCommand.Parameters["@ReturnValue1].Value.ToString());