绑定的日期字段显示日期和时间 [英] Bound Date Field Displays With Date and Time

问题描述

  SQL Server中的一个字段定义为日期，但是当我将该字段绑定到文本框时，该字段显示为日期和时间.我如何显示日期部分?预先感谢您的答复.

 A field in SQL Server is defined as date, however when I bind the field to a textbox the field displays as date and time. How do I just display the date part? Thank you in advance for your response.

数据库中的字段:

表格上的字段:

这是我的代码，用于将表单上的字段绑定到数据表:

Here is my code to bind the fields on the form to the datatable:

私人

GetCOBNonHorizo​​nRecsForGrp()

voidGetCOBNonHorizonRecsForGrp()

       {

        {

        

         

          

           

           var dataSet = new DataSet(); */

            var dataSet = new DataSet();*/

          

           

);

DataSetcobNonHorizon = newDataSet("cobNonHorizon");

          

           

)；

DataTabledataTable = cobNonHorizon.Tables.Add("dataTable");

           sqlConnection1.Open();

            sqlConnection1.Open();

          

           

"， sqlConnection1);

SqlCommandcmd1 = newSqlCommand("Insurer_Select", sqlConnection1);

          

           

stringGroupName = cboGroups.Text;

           cmd1.Parameters.Clear();

            cmd1.Parameters.Clear();

           cmd1.Parameters.Add(

            cmd1.Parameters.Add(

SqlParameter ( " @ InsurerGroup"" ， GroupName));

newSqlParameter("@InsurerGroup", GroupName));

           cmd1.CommandType =

            cmd1.CommandType =

          

           

varda = newSqlDataAdapter(cmd1);

           da.Fill(cobNonHorizo​​n，

            da.Fill(cobNonHorizon,

);

"dataTable");

          

           

           txtPosition.Text =

            txtPosition.Text =

中的1个" + dataTable.Rows .Count.ToString();

"1 of "+ dataTable.Rows.Count.ToString();

          

           

           txtHICN.DataBindings.Clear();

            txtHICN.DataBindings.Clear();

           txtCCID.DataBindings.Clear();

            txtCCID.DataBindings.Clear();

           txtFN.DataBindings.Clear();

            txtFN.DataBindings.Clear();

           txtLN.DataBindings.Clear();

            txtLN.DataBindings.Clear();

txtPatRel.DataBindings.Clear();

txtPatRel.DataBindings.Clear();

           txtMSPEffDt.DataBindings.Clear();

            txtMSPEffDt.DataBindings.Clear();

txtMSPTermDt.DataBindings.Clear();

txtMSPTermDt.DataBindings.Clear();

           txtMSPCode.DataBindings.Clear();

            txtMSPCode.DataBindings.Clear();

           txtInsurerName.DataBindings.Clear();

            txtInsurerName.DataBindings.Clear();

           txtInsurerAddress.DataBindings.Clear();

            txtInsurerAddress.DataBindings.Clear();

           txtInsurerCity.DataBindings.Clear();

            txtInsurerCity.DataBindings.Clear();

           txtInsurerSt.DataBindings.Clear();

            txtInsurerSt.DataBindings.Clear();

           txtInsurerZip.DataBindings.Clear();

            txtInsurerZip.DataBindings.Clear();

           txtPolicyNum.DataBindings.Clear();

            txtPolicyNum.DataBindings.Clear();

           txtInsurerType.DataBindings.Clear();

            txtInsurerType.DataBindings.Clear();

           txtSourceCode.DataBindings.Clear();

            txtSourceCode.DataBindings.Clear();

           txtInsurerGrp.DataBindings.Clear();

            txtInsurerGrp.DataBindings.Clear();

           txtInsurerGrpName.DataBindings.Clear();

            txtInsurerGrpName.DataBindings.Clear();

           txtStatus.DataBindings.Clear();

            txtStatus.DataBindings.Clear();

           txtSourceCd.DataBindings.Clear();

            txtSourceCd.DataBindings.Clear();

           txtActEffDt.DataBindings.Clear();

            txtActEffDt.DataBindings.Clear();

           txtActTermDt.DataBindings.Clear();

            txtActTermDt.DataBindings.Clear();

           txtMSPStatus.DataBindings.Clear();

            txtMSPStatus.DataBindings.Clear();

           txtIKAEff.DataBindings.Clear();

            txtIKAEff.DataBindings.Clear();

           txtIKATerm.DataBindings.Clear();

            txtIKATerm.DataBindings.Clear();

           txtActInsurerName.DataBindings.Clear();

            txtActInsurerName.DataBindings.Clear();

           txtActPatientRel.DataBindings.Clear();

            txtActPatientRel.DataBindings.Clear();

           txtActInsurerAddress1.DataBindings.Clear();

            txtActInsurerAddress1.DataBindings.Clear();

           txtActMSPCode.DataBindings.Clear();

            txtActMSPCode.DataBindings.Clear();

           txtActPolicyNum.DataBindings.Clear();

            txtActPolicyNum.DataBindings.Clear();

           txtActInsurerGrp.DataBindings.Clear();

            txtActInsurerGrp.DataBindings.Clear();

           txtActInsurerGrpName.DataBindings.Clear();

            txtActInsurerGrpName.DataBindings.Clear();

           txtActInsurerType.DataBindings.Clear();

            txtActInsurerType.DataBindings.Clear();

           txtComments.DataBindings.Clear();

            txtComments.DataBindings.Clear();

           txtHICN.DataBindings.Add(

            txtHICN.DataBindings.Add(

，dataTable， ) ;

"Text", dataTable, "relHICN");

           txtCCID.DataBindings.Add(

            txtCCID.DataBindings.Add(

，dataTable， ) ;

"Text", dataTable, "relCCID");

           txtFN.DataBindings.Add(

            txtFN.DataBindings.Add(

，dataTable， ) ;

"Text", dataTable, "relSubscriberFirst");

           txtLN.DataBindings.Add(

            txtLN.DataBindings.Add(

，dataTable， ) ;

"Text", dataTable, "relSubscriberLast");

           txtPatRel.DataBindings.Add(

            txtPatRel.DataBindings.Add(

，dataTable， ) ;

"Text", dataTable, "relRelation");

           txtMSPEffDt.DataBindings.Add(

            txtMSPEffDt.DataBindings.Add(

，dataTable， ) ;

"Text", dataTable, "relMSPEffDate");

           txtMSPTermDt.DataBindings.Add(

            txtMSPTermDt.DataBindings.Add(

，dataTable， ) ;

"Text", dataTable, "relMSPTermDate");

           txtMSPCode.DataBindings.Add(

            txtMSPCode.DataBindings.Add(

，dataTable， ) ;

"Text", dataTable, "relMSPCode");

           txtInsurerName.DataBindings.Add(

            txtInsurerName.DataBindings.Add(

，dataTable， ) ;

"Text", dataTable, "relInsurerName");

           txtInsurerAddress.DataBindings.Add(

            txtInsurerAddress.DataBindings.Add(

，dataTable， ) ;

"Text", dataTable, "relInsurerAddress1");

           txtInsurerCity.DataBindings.Add(

            txtInsurerCity.DataBindings.Add(

，dataTable， ) ;

"Text", dataTable, "relInsurerCity");

           txtInsurerSt.DataBindings.Add(

            txtInsurerSt.DataBindings.Add(

，dataTable， ) ;

"Text", dataTable, "relInsurerSt");

           txtInsurerZip.DataBindings.Add(

            txtInsurerZip.DataBindings.Add(

，dataTable， ) ;

"Text", dataTable, "relInsurerZip");

           txtPolicyNum.DataBindings.Add(

            txtPolicyNum.DataBindings.Add(

，dataTable， ) ;

"Text", dataTable, "relPolicyNumber");

           txtInsurerType.DataBindings.Add(

            txtInsurerType.DataBindings.Add(

，dataTable， ) ;

"Text", dataTable, "relInsurerType");

           txtSourceCode.DataBindings.Add(

            txtSourceCode.DataBindings.Add(

，dataTable， ) ;

"Text", dataTable, "relSourceCode");

           txtInsurerGrp.DataBindings.Add(

            txtInsurerGrp.DataBindings.Add(

，dataTable， ) ;

"Text", dataTable, "relInsGroup");

           txtInsurerGrpName.DataBindings.Add(

            txtInsurerGrpName.DataBindings.Add(

，dataTable， ) ;

"Text", dataTable, "relInsurerGroupName");

           txtStatus.DataBindings.Add(

            txtStatus.DataBindings.Add(

，dataTable， ) ;

"Text", dataTable, "relOccuranceStatus");

           txtSourceCd.DataBindings.Add(

            txtSourceCd.DataBindings.Add(

，dataTable， ) ;

"Text", dataTable, "relActSource");

           txtActEffDt.DataBindings.Add(

            txtActEffDt.DataBindings.Add(

，dataTable， ) ;

"Text", dataTable, "relActMSPEffDate");

           txtActTermDt.DataBindings.Add(

            txtActTermDt.DataBindings.Add(

，dataTable， ) ;

"Text", dataTable, "relActMSPtermDate");

           txtMSPStatus.DataBindings.Add(

            txtMSPStatus.DataBindings.Add(

，dataTable， ) ;

"Text", dataTable, "relActMSPStatus");

           txtIKAEff.DataBindings.Add(

            txtIKAEff.DataBindings.Add(

，dataTable， ) ;

"Text", dataTable, "relIKAEffDate");

           txtIKATerm.DataBindings.Add(

            txtIKATerm.DataBindings.Add(

，dataTable， ) ;

"Text", dataTable, "relIKATermDate");

           txtActInsurerName.DataBindings.Add(

            txtActInsurerName.DataBindings.Add(

，dataTable， ) ;

"Text", dataTable, "relActInsurerName");

           txtActPatientRel.DataBindings.Add(

            txtActPatientRel.DataBindings.Add(

，dataTable， ) ;

"Text", dataTable, "relActRelation");

           txtActInsurerAddress1.DataBindings.Add(

            txtActInsurerAddress1.DataBindings.Add(

，dataTable， ) ;

"Text", dataTable, "relActInsurerAddress1");

           txtActMSPCode.DataBindings.Add(

            txtActMSPCode.DataBindings.Add(

，dataTable， ) ;

"Text", dataTable, "relActMSPCode");

           txtActPolicyNum.DataBindings.Add(

            txtActPolicyNum.DataBindings.Add(

，dataTable， ) ;

"Text", dataTable, "relActPolicyNumber");

           txtActInsurerGrp.DataBindings.Add(

            txtActInsurerGrp.DataBindings.Add(

，dataTable， ) ;

"Text", dataTable, "relActInsGroup");

           txtActInsurerGrpName.DataBindings.Add(

            txtActInsurerGrpName.DataBindings.Add(

，dataTable，

"Text", dataTable, "relActInsurerGroupName");

           txtActInsurerType.DataBindings.Add(

            txtActInsurerType.DataBindings.Add(

，dataTable， ) ;

"Text", dataTable, "relActInsurerType");

           txtComments.DataBindings.Add(

            txtComments.DataBindings.Add(

，dataTable， ) ;

"Text", dataTable, "relComment");

           currManager =(

            currManager = (

this .BindingContext [cobNonHorizo​​n.Tables [ ]]];

CurrencyManager)this.BindingContext[cobNonHorizon.Tables["dataTable"]];

         

          

         数据集dsPartC_NonHorizo​​n = new DataSet();

           DataSet dsPartC_NonHorizon = new DataSet();

          DataTable dataTable = dsPartC_NonHorizo​​n.Tables.Add("Insurer_Select");

           DataTable dataTable = dsPartC_NonHorizon.Tables.Add("Insurer_Select");

          sqlDataAdapter1.Fill(dsPartC_NonHorizo​​n，"Insurer_Select"); */

           sqlDataAdapter1.Fill(dsPartC_NonHorizon,"Insurer_Select");*/

          sqlConnection1.Close();

           sqlConnection1.Close();

       }

        }

推荐答案

我没有进入绑定从未使用过它.但是，如果您可以绑定到字符串变量，则可以使用IndexOf()和Substring()来操纵字符串变量的日期和时间，并从字符串变量中去除时间，然后使用 用于填充文本框的字符串变量.

I am not into the binding never used it. But if you can bind to a string variable, then you can manipulate the string variable for the date and time and strip off the time from the string variable by using an IndexOf() and Substring() and then use the string variable to populate the Textbox.

这篇关于绑定的日期字段显示日期和时间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！