ASP.NET

Re: problem with datetime datatype of sqlserver 2005 using asp.net

30-Mar-10 18:49

You cannot store only date in datetime datatype.. But you can retrieve date from datetime.. search google for this..

Arindam Tewary30-Mar-10 19:25

Arindam Tewary

30-Mar-10 19:25

Though you store the datetime in database, while taking data out of database(using select query) you have lots of ways so that you can discard the 'time' part of it.

EXAMPLE
---------------

SELECT CONVERT(VARCHAR,GETDATE(),101)

For more options please check the CONVERT function in sql server.
It should be fine that database allows user to store date and time both. Smile | :)

Hope it helps,

Thanks,
Arindam D Tewary

Re: problem with datetime datatype of sqlserver 2005 using asp.net

Dinesh Mani30-Mar-10 20:16

Dinesh Mani

30-Mar-10 20:16

As others have pointed out, you have no way to store only the date part in date time field. You have to store only datetime or store the date in a string field. Doing the later would hinder you if you wish to do data manipulation based on the date value.

Now if you try to store only the date in a datetime column, the db by default would add 00 hrs as the default time value [correct me if I'm wrong].

Now you can easily remove the time part in the query using CONVERT(VARCHAR,[date column],101). But doing so would put extra load on your query and reduce its performance.

The best way to deal with it is to get the datetime value to the application and apply formatters to remove the time part from the datetime value. All that you need to do is to set the format string for the control that is going to display the value and you would be done.

HTH!

Re: problem with datetime datatype of sqlserver 2005 using asp.net

ships_agr31-Mar-10 3:50

ships_agr

31-Mar-10 3:50

hi....thanks for your reply
i've used all those functions to retrieve date from the field...but i just thought that if we would be able to save date only then how cool it would be.....anyways thanks for your reply

repeater control

test-0930-Mar-10 18:26

30-Mar-10 18:26

Hi..
I creatd some dynamic textboxes in repeater control.. Had a button to add textboxes.. and link button to delete the rows from db..
im deleting the rows from repeater based on id in the table...upto this its working fine. But when i click on add button to add more rows and if i want to delete those rows, as they dont have any id in table how do i delete those rows..

Arun Jacob30-Mar-10 20:02

30-Mar-10 20:02

where you are keeping the newly added object?or in other words do u have any persisting DataSource object for repeater?

test-0930-Mar-10 20:10

30-Mar-10 20:10

the values in the added text boxes if required they are inserted into db.. But before inserting if i need to delete them how can i...

Arun Jacob30-Mar-10 20:12

30-Mar-10 20:12

test-09 wrote:
the values in the added text boxes if required they are inserted into db.. But before inserting if i need to delete them how can i...

when clicking new row button how you are adding rows to repeater?Do u have any persisting object in code behind?Have tried deleting by index of the repeater item?

test-0930-Mar-10 20:19

30-Mar-10 20:19

this is how im adding new row...

private void adddescription()
   {
       int rowIndex = 0;


             if (ViewState["CurrentTable"] != null)
             {
                 //DataTable dtCurrentTable = (DataTable)ViewState["CurrentTable"];
                 dtDesc = (DataTable)ViewState["CurrentTable"];
                 DataRow drCurrentRow = dtDesc.NewRow();
                 if (dtDesc.Rows.Count > 0)
                 {
                     for (int i = 1; i <= dtDesc.Rows.Count; i++)
                     {
                         //extract the TextBox values
                         TextBox box1 = (TextBox)Rptdescription.Items[rowIndex].FindControl("TextName");
                         TextBox box2 = (TextBox)Rptdescription.Items[rowIndex].FindControl("TextDate");
                         TextBox box3 = (TextBox)Rptdescription.Items[rowIndex].FindControl("TextDescript");
                         drCurrentRow = dtDesc.NewRow();
                         drCurrentRow["RowNumber"] = i ;
                         ViewState["RowNumber"] = drCurrentRow["RowNumber"];
                         Label1.Text = ViewState["RowNumber"].ToString();
                         dtDesc.Rows[i - 1]["DescriptionName"] = box1.Text;
                         dtDesc.Rows[i - 1]["Date"] = box2.Text;
                         dtDesc.Rows[i - 1]["Description"] = box3.Text;
                         rowIndex++;
                     }
                     dtDesc.Rows.Add(drCurrentRow);
                   //  ViewState["CurrentTable"] = dtDesc;
                 }
                 else
                 {
                     dtDesc = (DataTable)ViewState["CurrentTable"];
                     // dtDesc = (DataTable)ViewState["CurrentTable"];
                     DataRow descRow = dtDesc.NewRow();
                     //  descRow["ProjectID"] = dtDesc.Rows.Count + 1;
                     descRow["DescriptionName"] = "";
                     descRow["Date"] = "";
                     descRow["Description"] = "";
                     dtDesc.Rows.Add(descRow);
                   //  ViewState["CurrentTable"] = dtDesc;
                 }
             }
             Bindrepeater();
   }

Arun Jacob30-Mar-10 20:23

30-Mar-10 20:23

Okay.Delete button is in the repater.right?then in the delete button click event you'll get the item index and using that item index delete that object from the viewstate and rebind repeater.is that makes sense?

test-0930-Mar-10 20:46

30-Mar-10 20:46

im losing the values in textboxs on postback.... i cant check which row im deleting correctly as the values go on postback...

int iddelete;
        iddelete = ToInt(e.CommandArgument.ToString());
        if (iddelete!=0)
        {
            //code....
         }
        else
        {

            int count = e.Item.ItemIndex;
            
           // count = Convert.ToInt32(ViewState["RowNumber"]);
           //DataTable dtdelete = (DataTable)ViewState["CurrentTable"];
          //  count = dtdelete.Rows.Count - 1;
            dtdelete.Rows[count].Delete();
            dtdelete.AcceptChanges();
            Rptdescription.DataSource = dtdelete;
            Rptdescription.DataBind();

           }

Arun Jacob30-Mar-10 20:53

30-Mar-10 20:53

test-09 wrote:
im losing the values in textboxs on postback...

Which values you are loosing?ItemIndex is enough to delete it from ViewState?Is this code working?whats the difficulty you are facing in the above code?
If you are saying about entered values in textboxes, then save that values to the persisting object before rebinding the repeater.

test-0930-Mar-10 21:03

30-Mar-10 21:03

the last row is deleting if i click on delete of any row... what may be problem