扫描二维码下载沐宇APP

沐宇

微信扫码使用沐宇小程序

沐宇

C#Dataset濡備綍瀹炵幇鏁版嵁缁戝畾

扬州沐宇科技
2024-06-25 23:01:47
c#

鍦–#涓紝鍙互浣跨敤DataSet瀵硅薄鏉ュ疄鐜版暟鎹粦瀹氥€侱ataSet鏄竴涓唴瀛樹腑鐨勬暟鎹紦瀛橈紝鍙互瀛樺偍鍜屾搷浣滄暟鎹€傝瀹炵幇鏁版嵁缁戝畾锛屽彲浠ユ寜鐓т互涓嬫楠よ繘琛岋細

  1. 浣跨敤DataAdapter瀵硅薄浠庢暟鎹簱涓幏鍙栨暟鎹紝骞跺皢鏁版嵁濉厖鍒癉ataSet涓€備緥濡傦細
string connectionString = "your_connection_string";
string query = "SELECT * FROM your_table";
SqlConnection connection = new SqlConnection(connectionString);
SqlDataAdapter adapter = new SqlDataAdapter(query, connection);
DataSet dataSet = new DataSet();
adapter.Fill(dataSet, "your_table");
  1. 灏咲ataSet涓殑鏁版嵁缁戝畾鍒版帶浠朵笂锛屼緥濡侱ataGridView鎴朙istBox銆傚彲浠ヤ娇鐢―ataSource灞炴€у皢DataSet缁戝畾鍒版帶浠朵笂锛屼緥濡傦細
dataGridView.DataSource = dataSet.Tables["your_table"];
  1. 鍦ㄦ帶浠朵笂鏄剧ず缁戝畾鐨勬暟鎹€傚湪绐椾綋鍔犺浇鏃讹紝鎴栬€呭湪闇€瑕佸埛鏂版暟鎹椂锛屽彲浠ヨ皟鐢―ataBind鏂规硶鏉ュ埛鏂版暟鎹紝渚嬪锛?/li>
dataGridView.DataBind();

閫氳繃浠ヤ笂姝ラ锛屽氨鍙互瀹炵幇浣跨敤DataSet鏉ヨ繘琛屾暟鎹粦瀹氥€傚湪瀹為檯涓紝鍙互鏍规嵁闇€瑕佽繘琛屾洿澶氱殑鏁版嵁鎿嶄綔鍜屾樉绀鸿缃€?/p>

扫码添加客服微信