91av视频/亚洲h视频/操亚洲美女/外国一级黄色毛片 - 国产三级三级三级三级

  • 大小: 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)論

相關(guān)資源