C#.NET Excel文件数据导入SQL Server数据库完整代码 C#asp.net 将客户端的Excel数据导入到GridV...
\u6c42asp.net(c#)\u5c06execl\u6587\u4ef6\u6570\u636e\u5bfc\u5165sql server\u6570\u636e\u5e93\u4e2d\u7684\u6e90\u7a0b\u5e8fif (excelhelper.DownLoadFile(FilePath, excelhelper.GetExcelDownLoadPath(this) + FileName, out error))
{
Business.Module.CM.BLL.tblcmbase_Server_Temp tblcmbase_Server = new Business.Module.CM.BLL.tblcmbase_Server_Temp();
if (tblcmbase_Server.ImportExcelData("\u4fe1\u606f\u8868", excelhelper.GetExcelDownLoadPath(this) + FileName,fileupload1.DocIDValue , out error))
{
Utinity.ClientScriptHelper.WriteAlertSaveSuccess(this);
}
else
{
Utinity.ClientScriptHelper.WriteAlert(this, "\u5bfc\u5165\u4fe1\u606f\u51fa\u9519\uff01\u9519\u8bef\u4fe1\u606f\uff1a" + error);
}
}
public bool ImportExcelData(string TableName, string Path, string FileAttID, out string error)
{
error = "";
try
{
Utinity.ExcelRWHelper _excel = new Utinity.ExcelRWHelper();
Microsoft.Office.Interop.Excel.ApplicationClass app = new Microsoft.Office.Interop.Excel.ApplicationClass();
app.Visible = false;
Microsoft.Office.Interop.Excel.WorkbookClass workbook = (Microsoft.Office.Interop.Excel.WorkbookClass)app.Workbooks.Open(Path, //Environment.CurrentDirectory+
Missing.Value, true, Missing.Value,
Missing.Value, Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value,
Missing.Value, Missing.Value, Missing.Value,
Missing.Value, Missing.Value);
object missing = Type.Missing;
Microsoft.Office.Interop.Excel.Sheets sheets = workbook.Worksheets;
Microsoft.Office.Interop.Excel.Worksheet datasheet = null;
bool isExcel = true;//\u5224\u65ad\u5bfc\u5165\u6587\u4ef6\u662f\u5426\u6b63\u786e
foreach (Microsoft.Office.Interop.Excel.Worksheet sheet in sheets) //\u53d6\u51fa\u6307\u5b9a\u7684sheet
{
if (sheet.Name == TableName)
{
datasheet = sheet;
isExcel = false;
break;
}
}
if (isExcel)
{
error = "\u5bfc\u5165Excel\u6587\u4ef6\u6709\u8bef,\u8bf7\u91cd\u65b0\u5bfc\u5165!";
return false;
}
app.Quit();
app = null;
System.Data.DataTable tbServer = _excel.ReadExcelData(Path, TableName);
for (int i = 0; i < tbServer.Rows.Count; i++)
{
if (tbServer.Rows[i][2].ToString() != "" && !tbServer.Rows[i][2].ToString().Equals("{}"))
{
decimal tempdecimal = decimal.Parse("0.00");
if (tbServer.Rows[i][6] == DBNull.Value || tbServer.Rows[i][6].ToString() == "")
{
error = "\u7b2c" + (i + 2).ToString() + "\u884c\u8bbe\u5907\u5e8f\u5217\u53f7\u4e0d\u80fd\u4e3a\u7a7a\uff01\u8bf7\u68c0\u67e5excel\u6587\u4ef6\u6570\u636e\u683c\u5f0f\uff01";
return false;
}
if (tbServer.Rows[i][7] == DBNull.Value || tbServer.Rows[i][7].ToString() == "")
{
error = "\u7b2c" + (i + 2).ToString() + "\u884c\u4e3b\u673a\u540d(hostname)\u4e0d\u80fd\u4e3a\u7a7a\uff01\u8bf7\u68c0\u67e5excel\u6587\u4ef6\u6570\u636e\u683c\u5f0f\uff01";
return false;
}
}
}
DAL.tblcmbase_Server_Temp tblcmbase_Server = new DAL.tblcmbase_Server_Temp();
//\u5bfc\u5165\u4e34\u65f6\u8868
tblcmbase_Server.InsertTempData(tbServer);
//\u6570\u636e\u5bf9\u6bd4
tblcmbase_Server.CompTempData(Framework.Assistant.Utility.GetGUID(), FileAttID, Utinity.User.CurrentUserName());
return true;
}
catch (Exception ex)
{
error = ex.ToString();
return false;
}
}
public string GetExcelDownLoadPath(System.Web.UI.Page page)
{
return ConfigurationManager.AppSettings["ExcelDownLoadPath"] == null ? page.Request.PhysicalApplicationPath : ConfigurationManager.AppSettings["ExcelDownLoadPath"];
}
public bool DownLoadFile(string SourceFilePath, string TargetFilePath, out string error)
{
error = "";
WebClient client = new WebClient();
client.Credentials = CredentialCache.DefaultCredentials;
try
{
client.DownloadFile(SourceFilePath, TargetFilePath);
return true;
}
catch (Exception ex)
{
error = ex.ToString();
return false;
}
}
#region \u8fde\u63a5Excel \u8bfb\u53d6Excel\u6570\u636e \u5e76\u8fd4\u56deDataSet\u6570\u636e\u96c6\u5408
///
/// \u8fde\u63a5Excel \u8bfb\u53d6Excel\u6570\u636e \u5e76\u8fd4\u56deDataSet\u6570\u636e\u96c6\u5408
///
/// Excel\u670d\u52a1\u5668\u8def\u5f84
/// Excel\u8868\u540d\u79f0
///
public static System.Data.DataSet ExcelSqlConnection(string filepath, string tableName)
{
string strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filepath + ";Extended Properties='Excel 8.0;HDR=YES;IMEX=1'";
OleDbConnection ExcelConn = new OleDbConnection(strCon);
try
{
string strCom = string.Format("SELECT * FROM [Sheet1$]");
ExcelConn.Open();
OleDbDataAdapter myCommand = new OleDbDataAdapter(strCom, ExcelConn);
DataSet ds = new DataSet();
myCommand.Fill(ds, "[" + tableName + "$]");
ExcelConn.Close();
return ds;
}
catch
{
ExcelConn.Close();
return null;
}
}
#endregion
#region \u5bfc\u5165\u7684execl
protected void Button2_Click(object sender, EventArgs e)
{
SqlConnection cn = new BSqlDataProvider().GetSqlConnection();
cn.Open();
if (FileUpload1.HasFile == false)//HasFile\u7528\u6765\u68c0\u67e5FileUpload\u662f\u5426\u6709\u6307\u5b9a\u6587\u4ef6
{
Response.Write("alert('\u8bf7\u60a8\u9009\u62e9Excel\u6587\u4ef6') ");
return;//\u5f53\u65e0\u6587\u4ef6\u65f6,\u8fd4\u56de
}
string IsXls = System.IO.Path.GetExtension(FileUpload1.FileName).ToString().ToLower();//System.IO.Path.GetExtension\u83b7\u5f97\u6587\u4ef6\u7684\u6269\u5c55\u540d
if (IsXls != ".xls")
{
Response.Write("alert('\u53ea\u53ef\u4ee5\u9009\u62e9Excel\u6587\u4ef6')");
return;//\u5f53\u9009\u62e9\u7684\u4e0d\u662fExcel\u6587\u4ef6\u65f6,\u8fd4\u56de
}
string filename = FileUpload1.FileName; //\u83b7\u53d6Execle\u6587\u4ef6\u540d DateTime\u65e5\u671f\u51fd\u6570
string savePath = Server.MapPath(("~\\upfiles\\") + filename);//Server.MapPath \u83b7\u5f97\u865a\u62df\u670d\u52a1\u5668\u76f8\u5bf9\u8def\u5f84
FileUpload1.SaveAs(savePath); //SaveAs \u5c06\u4e0a\u4f20\u7684\u6587\u4ef6\u5185\u5bb9\u4fdd\u5b58\u5728\u670d\u52a1\u5668\u4e0a
DataSet ds = ExcelSqlConnection(savePath, filename); //\u8c03\u7528\u81ea\u5b9a\u4e49\u65b9\u6cd5
DataRow[] dr = ds.Tables[0].Select(); //\u5b9a\u4e49\u4e00\u4e2aDataRow\u6570\u7ec4
int rowsnum = ds.Tables[0].Rows.Count;
if (rowsnum == 0)
{
Response.Write("alert('Excel\u8868\u4e3a\u7a7a\u8868,\u65e0\u6570\u636e!')"); //\u5f53Excel\u8868\u4e3a\u7a7a\u65f6,\u5bf9\u7528\u6237\u8fdb\u884c\u63d0\u793a
}
else
{
for (int i = 0; i < dr.Length; i++)
{
string spdm = dr[i]["\u5546\u54c1\u4ee3\u7801"].ToString();//\u65e5\u671f excel\u5217\u540d\u3010\u540d\u79f0\u4e0d\u80fd\u53d8,\u5426\u5219\u5c31\u4f1a\u51fa\u9519\u3011
string jijie = dr[i]["\u5b63\u8282"].ToString();
string boduan = dr[i]["\u6ce2\u6bb5"].ToString();
string s_chan = dr[i]["\u751f\u4ea7\u5546"].ToString();
string f_shi = dr[i]["\u65b9\u5f0f"].ToString();
string c_ku = dr[i]["\u4ed3\u5e93"].ToString();
string insertstr = "insert into AA_ANSD values('"+spdm+"','"+jijie+"','"+boduan+"','"+s_chan+"','"+f_shi+"','"+c_ku+"')";
SqlCommand cmd = new SqlCommand(insertstr, cn);
try
{
cmd.ExecuteNonQuery();
}
catch (MembershipCreateUserException ex) //\u6355\u6349\u5f02\u5e38
{
Response.Write("alert('\u5bfc\u5165\u5185\u5bb9:" + ex.Message + "')");
}
}
Response.Write("alert('Excle\u8868\u5bfc\u5165\u6210\u529f!');location='CMT_Entry.aspx?CMD=0'");
}
cn.Close();
}
#endregion
\u5feb\u7ed9\u5206 \u554a
在日常的项目中，Excel，Word，txt等格式的数据导入到数据库中是很常见
这里将分为.net导入Sql Server，Oracle数据库和WinForm导入Sql Server，Oracle数据库。
实现的基本思想：
1，先使用FileUpload控件fuload将Excel文件上传到服务器上得某一个文件夹。
2，使用OleDb将已经上传到服务器上的Excel文件读出来，这里将Excel文件当做一个数据库来读。在联系数据库语句中，Data Source就是该文件在服务器上得物理路径
3，将第二步中读出的数据以DataTable对象返回。
4，遍历DataTable对象，然后到Sql Server数据库中查询，是否存在该条数据。如果存在，可以做更新，或者不做处理；如果不存在，则插入数据。
注意：在遍历DataTable的时候，可是使用dt.Rows[i]["Name"].ToString();Name为Name列的表头，所以Excel中列的顺序就无关紧要了。当然，前提是你知道Excel里列中各表头的名字。如果Excel中列的顺序固定，即可按下面代码中的方式进行。
添加的引用：
using System;
using System.Data;
using System.Data.OleDb;
using System.Data.SqlClient;
using System.IO;
using System.Text;
using System.Web;
using System.Web.UI;
private DataTable xsldata()
{
if(fuload.FileName == "")
{
lbmsg.Text = "请选择文件";
return null;
}
string fileExtenSion;
fileExtenSion = Path.GetExtension(fuload.FileName);
if(fileExtenSion.ToLower() != ".xls" && fileExtenSion.ToLower() != ".xlsx")
{
lbmsg.Text = "上传的文件格式不正确";
return null;
}
try
{
string FileName = "App_Data/" + Path.GetFileName(fuload.FileName);
if(File.Exists(Server.MapPath(FileName)))
{
File.Delete(Server.MapPath(FileName));
}
fuload.SaveAs(Server.MapPath(FileName));
//HDR=Yes，这代表第一行是标题，不做为数据使用 ，如果用HDR=NO，则表示第一行不是标题，做为数据来使用。系统默认的是YES
string connstr2003 = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath(FileName) + ";Extended Properties='Excel 8.0;HDR=Yes;IMEX=1;'";
string connstr2007 = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Server.MapPath(FileName) + ";Extended Properties=\"Excel 12.0;HDR=YES\"";
OleDbConnection conn;
if(fileExtenSion.ToLower() == ".xls")
{
conn = new OleDbConnection(connstr2003);
}
else
{
conn = new OleDbConnection(connstr2007);
}
conn.Open();
string sql = "select * from [Sheet1$]";
OleDbCommand cmd = new OleDbCommand(sql, conn);
DataTable dt = new DataTable();
OleDbDataReader sdr = cmd.ExecuteReader();
dt.Load(sdr);
sdr.Close();
conn.Close();
//删除服务器里上传的文件
if(File.Exists(Server.MapPath(FileName)))
{
File.Delete(Server.MapPath(FileName));
}
return dt;
}
catch(Exception e)
{
return null;
}
}
protected void Btn_Export_Excel_To_DB_Click(object sender, EventArgs e)
{
try{
DataTable dt = xsldata();
//dataGridView2.DataSource = ds.Tables[0];
int errorcount = 0;//记录错误信息条数
int insertcount = 0;//记录插入成功条数
int updatecount = 0;//记录更新信息条数
string strcon = "server=localhost;database=database1;uid=sa;pwd=sa";
SqlConnection conn = new SqlConnection(strcon);//链接数据库
conn.Open();
for(int i = 0; i < dt.Rows.Count; i++)
{
string Name = dt.Rows[i][0].ToString();//dt.Rows[i]["Name"].ToString(); "Name"即为Excel中Name列的表头
string Sex = dt.Rows[i][1].ToString();
int Age = Convert.ToInt32(dt.Rows[i][2].ToString());
string Address = dt.Rows[i][3].ToString();
if(Name != "" && Sex != "" && Age != 0 && Address != "")
{
SqlCommand selectcmd = new SqlCommand("select count(*) from users where Name='" + Name + "' and Sex='" + Sex + "' and Age='" + Age + "' and Address=" + Address, conn);
int count = Convert.ToInt32(selectcmd.ExecuteScalar());
if(count > 0)
{
updatecount++;
}
else
{
SqlCommand insertcmd = new SqlCommand("insert into users(Name,Sex,Age,Address) values('" + Name + "','" + Sex + "'," + Age + ",'" + Address + "')", conn);
insertcmd.ExecuteNonQuery();
insertcount++;
}
}
else
{
errorcount++;
}
}
Response.Write((insertcount + "条数据导入成功！" + updatecount + "条数据重复！" + errorcount + "条数据部分信息为空没有导入！"));
}
catch(Exception ex)
{
}
}
Excel.Application app = new Excel.Application();
app.Visible = true;
try
{
object obj = System.Reflection.Missing.Value;
Excel.Workbooks wb = app.Workbooks;
Excel._Workbook iwk = wb.Add(obj);
Excel._Worksheet sheet = (Excel._Worksheet)(iwk.ActiveSheet);
app.Caption = "Excle的标题";
//添加列
for (int i = 0; i < this.dataGridView的控件名.Columns.Count; i++)
{
sheet.Cells[1, i + 1] = this.dataGridView的控件名.Columns[i].HeaderText;
}
//添加行
for (int i = 0; i < this.dataGridView的控件名.Rows.Count; i++)
{
for (int j = 0; j < dataGridView的控件名.Columns.Count; j++)
{
sheet.Cells[i + 2, j + 1] = this.dataGridView的控件名.Rows[i].Cells[j].Value.ToString();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
用法：先把Excle.dll 复制在你的项目的bin\Debug文件下：在右击工具箱->选择项(I)... -> 显示"选择工具箱项" -> COM组件 -> 选择Excle就可以了
一.数据库向导本来就可以这样导入,在Excel建的字段，必须在table表中也得有字段.然后在SQL右键点击table表中的导入数据.选择Excel数据类型,就可以了
二:
protected void Button1_Click(object sender, System.EventArgs e)
{
string XLS_Path="";
string XLS_Name = MakeFileName();
string fileExtName = "";
if(File1.PostedFile.ContentLength >0)
{
try
{
fileExtName = File1.PostedFile.FileName.Substring(File1.PostedFile.FileName.LastIndexOf("."));
if(fileExtName!=".xls"||fileExtName.Length<1)
{
Response.Write( "<script language=javascript>alert('数据导入失败.可能是文件格式或路径不正确！！！');</script>");
return;
}
File1.PostedFile.SaveAs(Server.MapPath("../uploadexcel/")+XLS_Name+fileExtName);
XLS_Path =Server.MapPath("../uploadexcel/")+ XLS_Name+fileExtName;
}
catch(Exception ex)
{
Response.Write(ex.ToString());
}
}
else
{
Response.Write( "<script language=javascript>alert('请选择文件后再上传！！！');</script>");
return;
}
string ConStr=System.Configuration.ConfigurationManager.AppSettings["ConnString"];
SqlConnection Conn=new SqlConnection(ConStr);
string mystring="Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = '"+XLS_Path+"'"+";Extended Properties=Excel 8.0";
OleDbConnection cnnxls = new OleDbConnection (mystring);
OleDbDataAdapter myDa =new OleDbDataAdapter("select * from [Sheet1$]",cnnxls);
DataSet myDs =new DataSet();
try
{
myDa.Fill(myDs);
}
catch
{
Response.Write( "<script language=javascript>alert('数据导入失败,请检查！！');</script>");
return;
}
if(myDs.Tables[0].Rows.Count<=0)
{
Response.Write( "<script language=javascript>alert('文件中可能没有数据，请检查后重新导入！');</script>");
return;
}
int []zjid=new int[myDs.Tables[0].Rows.Count];
string strSql = "";
string CnnString="Provider=SQLOLEDB;"+ConStr;
OleDbConnection conn =new OleDbConnection(CnnString);
OleDbCommand myCmd =null;
整个数据库？
只是某个表而已吧。
绛旓細c鏄瓧姣嶇鍙枫C锛堝ぇ鍐欙級 銆乧锛堝皬鍐欙級鏄嫳鏂囧瓧姣嶉『鏁扮涓変釜锛屼縿璇瓧姣嶉『鏁扮19涓備緥濡傦細鑻辫鍗曡瘝cloud鍜屸滆嫃鑱斺濈殑淇勮缂╁啓小小小袪鐨勭涓涓瓧姣嶅氨鏄痗銆傝捣婧愶細锛1锛夊瓧姣岰鐨勪骇鐢熷彲鑳芥槸鐢变簬涓涓姇鎺锋鐨勭鍙凤紝鍍忓湪鍙ゅ焹鍙婄殑璞″舰鏂囧瓧閲岋紝骞跺緢鏃╁嚭鐜板湪闂棌鐨勪功闈㈠綋涓-澶х害鍦ㄥ叕鍏冨墠1500骞寸殑瑗垮鍗婂矝銆傦紙...
绛旓細鏁板绗﹀彿c鍙充笂瑙掓槸1鍙充笅瑙掓槸4鐨勬剰鎬濇槸鏁板涓殑缁勫悎锛屽彸涓嬭鐨4琛ㄧず鎬讳綋涓暟锛屽彸涓婅鐨1琛ㄧず鎶藉彇涓暟锛屼笖浠4涓噷闈㈡娊鍙栦竴涓紝C¹₄=4梅1=4銆傜粍鍚堬細涓鑸湴锛屼粠n涓笉鍚岀殑鍏冪礌涓紝浠诲彇m锛坢鈮锛変釜鍏冪礌涓轰竴缁勶紝鍙綔浠巒涓笉鍚屽厓绱犱腑鍙栧嚭m涓厓绱犵殑涓涓粍鍚堛傛墍鏈夎繖鏍风殑缁勫悎鐨勬绘暟...
绛旓細c++鐨勫叿浣撳惈涔夊涓嬶細C++鏄C璇█鐨勭户鎵匡紝瀹冩棦鍙互杩涜C璇█鐨勮繃绋嬪寲绋嬪簭璁捐锛屽張鍙互杩涜浠ユ娊璞℃暟鎹被鍨嬩负鐗圭偣鐨勫熀浜庡璞＄殑绋嬪簭璁捐锛岃繕鍙互杩涜浠ョ户鎵垮拰澶氭佷负鐗圭偣鐨勯潰鍚戝璞＄殑绋嬪簭璁捐銆侰++鎿呴暱闈㈠悜瀵硅薄绋嬪簭璁捐鐨勫悓鏃讹紝杩樺彲浠ヨ繘琛屽熀浜庤繃绋嬬殑绋嬪簭璁捐锛屽洜鑰孋++灏遍傚簲鐨勯棶棰樿妯¤岃锛屽ぇ灏忕敱涔嬨侰++涓嶄粎鎷ユ湁...
绛旓細鏁板绗﹀彿c鍙充笂瑙掓槸1鍙充笅瑙掓槸4鐨勬剰鎬濇槸鏁板涓殑缁勫悎锛屽彸涓嬭鐨4琛ㄧず鎬讳綋涓暟锛屽彸涓婅鐨1琛ㄧず鎶藉彇涓暟锛屼笖浠4涓噷闈㈡娊鍙栦竴涓紝C¹₄=4梅1=4銆傜粍鍚堬細涓鑸湴锛屼粠n涓笉鍚岀殑鍏冪礌涓紝浠诲彇m锛坢鈮锛変釜鍏冪礌涓轰竴缁勶紝鍙綔浠巒涓笉鍚屽厓绱犱腑鍙栧嚭m涓厓绱犵殑涓涓粍鍚堛傛墍鏈夎繖鏍风殑缁勫悎鐨勬绘暟...
绛旓細鍖栧涓C琛ㄧず鐗╄川鐨勯噺娴撳害锛堟懇灏旀祿搴︼級锛屾槸涓绉嶅父鐢ㄧ殑婧舵恫娴撳害鐨勮〃绀烘柟娉曪紝涓烘憾娑蹭腑婧惰川鐨勭墿璐ㄧ殑閲忛櫎浠ユ贩鍚堢墿鐨勪綋绉備互涓婇潰鍏紡涓紝C(B)浠ｈ〃婧惰川鐨勭墿璐ㄧ殑閲忔祿搴︼紝n(B)浠ｈ〃婧惰川鐨勭墿璐ㄧ殑閲忥紝V浠ｈ〃婧舵恫鐨勪綋绉傛憾娑叉祿搴﹀彲鍒嗕负璐ㄩ噺娴撳害锛堝璐ㄩ噺鐧惧垎娴撳害锛夈佷綋绉祿搴︼紙濡傛懇灏旀祿搴︺佸綋閲忔祿搴︼級鍜岃川閲-浣撶Н...
绛旓細c鐨勫ぇ鍐欏瓧姣嶆槸C銆傚崰鍥涚嚎鏍肩殑涓牸锛屾敞鎰忚鐣欏嚭涓涓己鍙ｏ紝涓嶈灏佷綇銆26涓瓧姣嶈嫳璇ぇ灏忓啓鍒嗗埆涓篈a銆丅b銆丆c銆丏d銆丒e銆丗f銆丟g銆丠h銆両i銆丣j銆並k銆丩l銆丮m銆丯n銆丱o銆丳p銆丵q銆丷r銆丼s銆乀t銆乁u銆乂v銆乄w銆乆x銆乊y銆乑z銆備功鍐欒嫳璇瓧姣嶆椂瑕佹寜鐓у瓧姣嶇殑绗旂敾鍜屽瓧姣嶅湪涓変釜鏍间腑鎵鍗犳嵁鐨勪綅缃功鍐欙紝鍚屾椂姣忎釜瀛楁瘝閮...
绛旓細c鍦ㄧ埍鎯呯殑鍚箟鏄粈涔,鐢ㄥ悇绉嶅悇鏍风殑绗﹀彿鏉ヤ唬鏇挎垜浠兂瑕佽〃杈剧殑鐪熷疄鎰忔濇槸鎴戜滑瀵逛竴浠芥劅鎯呯殑鍚搫琛ㄧず,涓栭棿涓囩墿瀛樺湪鐨勬剰涔夊氨鏄垜浠祴浜堢殑鍐呮兜,涓嬮潰鍒嗕韩c鍦ㄧ埍鎯呯殑鍚箟鏄粈涔堛 c鍦ㄧ埍鎯呯殑鍚箟鏄粈涔1 C鎸囩殑鏄幇鍦ㄦ祦琛岀殑C鍨嬬埍鎯呰銆 C鍨嬬埍鎯呰 鈥淐鍨嬬埍鎯呰鈥濇寚鐨勬槸瀵圭幇浠ｇ埍鎯呭叧涓绉嶆柊鐨勫畾涔夈傚湪鐖辨儏涓,鏈夎繘鏈夐銆...
绛旓細琛屾斂绾у埆鐨勮娇杞C杞︼紝鎴栫О涓 Execuive锛屼篃灏辨槸琛屾斂绾у埆鐨勮娇杞︼紝鎺掗噺涓鑸槸2.4鍒3.2鍗囷紝杩欎釜绾ц溅鐨勬帓姘旈噺鍙珮鍙綆銆傞氬父鏈 A銆 B銆 C銆 D绛夌骇杞︼紝鍚勫浗鏍囧噯涓嶅悓锛屾垜鍥芥洿娌℃湁缁熶竴鐨勬爣鍑嗭紝鍥犱负寰峰浗姹借溅棣栧厛涓庢垜鍥藉悎璧勫苟鍗犻浜嗕竴瀹氬競鍦猴紝鍥犳寰峰浗姹借溅澶氶噰鐢ㄥ痉鍥藉垎绾ф硶锛氭牴鎹痉鍥芥苯杞﹀垎绾ф爣鍑嗭紝A0銆丄00绾...
绛旓細涓銆佷富浣撲笉鍚 1銆C璇█锛氭槸涓闂ㄩ潰鍚戣繃绋嬬殑銆佹娊璞″寲鐨勯氱敤绋嬪簭璁捐璇█锛屽箍娉涘簲鐢ㄤ簬搴曞眰寮鍙戙2銆丆++锛氭槸C璇█鐨勭户鎵匡紝瀹冩棦鍙互杩涜C璇█鐨勮繃绋嬪寲绋嬪簭璁捐锛屽張鍙互杩涜浠ユ娊璞℃暟鎹被鍨嬩负鐗圭偣鐨勫熀浜庡璞＄殑绋嬪簭璁捐銆備簩銆佷紭鍔夸笉鍚 1銆丆璇█锛氳兘浠ョ畝鏄撶殑鏂瑰紡缂栬瘧銆佸鐞嗕綆绾у瓨鍌ㄥ櫒銆侰璇█鏄粎浜х敓灏戦噺鐨勬満鍣...
绛旓細m>n銆傛帓鍒楃粍鍚c鐨勫叕寮忥細C(n,m)=A(n,m)/m!=n!/m!(n-m)!涓嶤(n,m)=C(n,n-m)銆(n涓轰笅鏍,m涓轰笂鏍)銆備緥濡侰(4,2)=4!/(2!*2!)=4*3/(2*1)=6,C(5,2)=C(5,3)銆傛帓鍒楃粍鍚坈璁＄畻鏂规硶锛欳鏄粠鍑犱釜涓夊彇鍑烘潵锛屼笉鎺掑垪锛屽彧缁勫悎銆侰(n锛宮)=n*(n-1)*...*(n-m+1)/m...
