-
大小: 81KB文件類型: .rar金幣: 2下載: 0 次發(fā)布日期: 2021-05-13
- 語(yǔ)言: C#
- 標(biāo)簽:
資源簡(jiǎn)介
DataGridView中有文本框列,下拉框列,圖像列,鏈接列,卻沒(méi)有DateTime列,這里實(shí)現(xiàn)在編輯DataGridView時(shí)可以錄入DateTime類型數(shù)據(jù)。

代碼片段和文件信息
using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Text;
using?System.Windows.Forms;
using?System.Data.SqlClient;
namespace?CRMControlDemo
{
????public?partial?class?Form1?:?Form
????{
????????public?Form1()
???????{
????????????InitializeComponent();
????????????this.Load+=new?EventHandler(Form1_Load);
????????????dataGridView1.Scroll+=new?ScrollEventHandler(dataGridView1_Scroll);
????????????dataGridView1.ColumnWidthChanged+=new?DataGridViewColumnEventHandler(dataGridView1_ColumnWidthChanged);
????????????dataGridView1.CellClick+=new?DataGridViewCellEventHandler(dataGridView1_CellClick);
????????}
??????
????????//定義一個(gè)DateTimePicker控件
????????private?DateTimePicker?dTimePicker?=?new?DateTimePicker();
????????//定義一個(gè)DataSet
????????private?DataSet?ds;
???????
????????private?void?Form1_Load(object?sender?EventArgs?e)
???????{?
????????????//隱藏dTimePicker
????????????dTimePicker.Visible?=?false;
????????????dTimePicker.Format?=?DateTimePickerFormat.Custom;
????????????dTimePicker.CustomFormat?=?“yyyy-MM-dd?HH:mm“;
????????????
????????????//dataGirdView1控件數(shù)據(jù)綁定
????????????Data_Bind();
????????????//定義控件dTimePicker當(dāng)Text變更時(shí)委托于事件dTimePicker_TextChanged
????????????dTimePicker.TextChanged?+=?new?EventHandler(dTimePicker_TextChanged);
????????????//dataGridView1添加控件dTimePicker
????????????dataGridView1.Controls.Add(dTimePicker);
????????}
????????/**////?
????????///?dataGirdView綁定數(shù)據(jù)
????????///?
????????private?void?Data_Bind()
???????{
???????????ds?=?new?DataSet();
???????????string?constr?=?“server=.;database=Model;uid=sa;pwd=“;
???????????SqlConnection?con?=?new?SqlConnection(constr);
???????????SqlDataAdapter?ad?=?new?SqlDataAdapter(“Select?[name]?s.createdate?From?sysusers?s“?con);
???????????ad.Fill(ds);
???????????dataGridView1.DataSource?=?ds.Tables[0].DefaultView;
????????}
????????//事件dTimePicker_TextChanged當(dāng)dTimePicker當(dāng)Text變更時(shí)觸發(fā)
????????private?void?dTimePicker_TextChanged(object?sender?EventArgs?e)
???????{
????????????//把dTimePicker的Text值賦給dataGridView1選中的單元格值
????????????dataGridView1.CurrentCell.Value?=?dTimePicker.Text;
????????}
????????
????????private?void?dataGridView1_Scroll(object?sender?ScrollEventArgs?e)
???????{
????????????//當(dāng)dataGridView1滾動(dòng)條移動(dòng)時(shí)dTimePicker控件隱藏
????????????dTimePicker.Visible?=?false;
????????}
????????private?void?dataGridView1_ColumnWidthChanged(object?sender?DataGridViewColumnEventArgs?e)
???????{
????????????//當(dāng)dataGridView1的列寬改變時(shí)dTimePicker控件隱藏
????????????dTimePicker.Visible?=?false;
????????}
????????private?void?dataGridView1_CellClick(object?sender?DataGridViewCellEventArgs?e)
???????{
???????????//判斷選中行時(shí)日期類型
???????????//dt?=?ds.Tables[0];
???????????Type?t?=?ds.Tables[0].Columns[dataGridView1.CurrentCell.ColumnIndex].DataType;
???????????DateTime?d?=?DateTime.Now;
???????????if?(t?==?d.GetTyp
?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????文件???????3693??2011-10-18?11:12??ControlDemo\CRMControlDemo\CRMControlDemo.csproj
?????文件???????4008??2011-10-18?11:11??ControlDemo\CRMControlDemo\Form1.cs
?????文件???????2279??2011-10-18?10:57??ControlDemo\CRMControlDemo\Form1.Designer.cs
?????文件???????5814??2011-10-18?10:57??ControlDemo\CRMControlDemo\Form1.resx
?????文件????????473??2011-10-18?10:47??ControlDemo\CRMControlDemo\Program.cs
?????文件????????899??2011-10-14?16:01??ControlDemo\CRMControlDemo\Resources\active_close.png
?????文件???????1200??2011-10-14?14:40??ControlDemo\CRMControlDemo\Properties\AssemblyInfo.cs
?????文件???????3113??2011-10-14?16:01??ControlDemo\CRMControlDemo\Properties\Resources.Designer.cs
?????文件???????6211??2011-10-14?16:01??ControlDemo\CRMControlDemo\Properties\Resources.resx
?????文件???????1097??2011-10-14?14:40??ControlDemo\CRMControlDemo\Properties\Settings.Designer.cs
?????文件????????249??2011-10-14?14:40??ControlDemo\CRMControlDemo\Properties\Settings.settings
?????文件????????359??2011-10-18?11:12??ControlDemo\CRMControlDemo\obj\CRMControlDemo.csproj.FileList.txt
?????文件????????946??2011-10-18?10:57??ControlDemo\CRMControlDemo\obj\Debug\CRMControlDemo.csproj.GenerateResource.Cache
?????文件??????24576??2011-10-18?11:12??ControlDemo\CRMControlDemo\obj\Debug\CRMControlDemo.exe
?????文件????????180??2011-10-18?10:57??ControlDemo\CRMControlDemo\obj\Debug\CRMControlDemo.Form1.resources
?????文件????????180??2011-10-18?10:40??ControlDemo\CRMControlDemo\obj\Debug\CRMControlDemo.Form2.resources
?????文件??????52736??2011-10-18?11:12??ControlDemo\CRMControlDemo\obj\Debug\CRMControlDemo.pdb
?????文件???????1366??2011-10-18?10:40??ControlDemo\CRMControlDemo\obj\Debug\CRMControlDemo.Properties.Resources.resources
?????文件???????4608??2011-10-14?16:01??ControlDemo\CRMControlDemo\obj\Debug\TempPE\Properties.Resources.Designer.cs.dll
?????文件??????24576??2011-10-18?11:12??ControlDemo\CRMControlDemo\bin\Debug\CRMControlDemo.exe
?????文件??????52736??2011-10-18?11:12??ControlDemo\CRMControlDemo\bin\Debug\CRMControlDemo.pdb
?????文件??????41984??2005-11-11?22:25??ControlDemo\CRMControlDemo\bin\Debug\CRMControlDemo.vshost.exe
?????文件????????931??2011-10-14?14:40??ControlDemo\CRMControlDemo.sln
?????目錄??????????0??2011-10-18?11:12??ControlDemo\CRMControlDemo\obj\Debug\TempPE
?????目錄??????????0??2011-10-18?11:12??ControlDemo\CRMControlDemo\obj\Debug\Refactor
?????目錄??????????0??2011-10-18?11:12??ControlDemo\CRMControlDemo\obj\Debug
?????目錄??????????0??2011-10-18?11:12??ControlDemo\CRMControlDemo\bin\Debug
?????目錄??????????0??2011-10-18?11:12??ControlDemo\CRMControlDemo\Resources
?????目錄??????????0??2011-10-18?11:12??ControlDemo\CRMControlDemo\Properties
?????目錄??????????0??2011-10-18?11:12??ControlDemo\CRMControlDemo\obj
............此處省略6個(gè)文件信息
評(píng)論
共有 條評(píng)論