ASP.NET中自定义控件的创建和使用

                case SortType.LastName:

                    strType="LastName";

                    break;

                case SortType.Title:

                    strType="Title";

                    break;

                case SortType.TitleOfCourtesy:

                    strType="TitleOfCourtesy";

                    break;

                default:

                    strType="undefine";

                    break;

            }

            switch(psortStyle)

            {

                case SortStyle.asc:

                    strStyle="asc";

                    break;

                case SortStyle.desc:

                    strStyle="desc";

                    break;

                default:

                    strStyle="undefine";

                    break;

            }

            sql="select * from Employees order by "+ strType + " " + strStyle;

            SqlConnection con=new SqlConnection("server=accp-lzh;uid=sa;pwd=sasa;database=Northwind");

            SqlCommand cmd=con.CreateCommand();

            cmd.CommandType=CommandType.Text;

            cmd.CommandText=sql;

            SqlDataAdapter ada=new SqlDataAdapter();

            ada.SelectCommand=cmd;

            DataSet ds=new DataSet();

            con.Open();

            ada.Fill(ds,"Employees");

            con.Close();

            return ds;

        }

    }

}

2、  保存

上一页  [1] [2] [3] [4] [5]  下一页

Copyright ＠ 2007-2012 敏韬网(敏而好学，文韬武略--MinTao.Net)（学习笔记） Inc All Rights Reserved.
闵涛 E_mail:admin@mintao.net(欢迎提供学习资源)

鄂公网安备 42011102001154号

站长：MinTao ICP备案号：鄂ICP备11006601号-18