ASP.NET

problem with datetime datatype of sqlserver 2005 using asp.net

30-Mar-10 18:33

actually i'm able to bind adrotator and all data source controls using asp.net configure datasource wizard but the problem is that whenever i perform any updation in the database using these controls updation is performed in the database but the information displayed in the control is not refreshed.....i know how to do it with coding but is it possible to refresh the data in the controls through the wizard only....???

modified on Wednesday, March 31, 2010 9:52 AM

ships_agr30-Mar-10 18:30

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

30-Mar-10 18:30

i want to store only date in the datetime type field but if i only provide the date....it takes some time by default..i want to remove that time information....can anyone help me with that...???

test-0930-Mar-10 18:49

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

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

using javascript to create seat chart

Arindam Tewary30-Mar-10 21:15

Arindam Tewary

30-Mar-10 21:15

You might have 'hard coded' index of last row. Please check that. This could be the case. Laugh | :laugh:

Thanks,
Arindam D Tewary

ships_agr30-Mar-10 18:15

Re: using javascript to create seat chart

30-Mar-10 18:15

i'm new to asp.net...i don know all its technicalities.....i want to create a seat chart of some auditorium using javascript and enable and disable some of its seats....also allow user to select some of the seats without page reload(only the color of those seats may get changed....and i may be able to collect their seat numbers)
if anyone can help me with this or can tell me some other way to create such a user interactive seat chart...???

sashidhar30-Mar-10 23:34

sashidhar

30-Mar-10 23:34

Its better to use update panel other than Java script for seat chart

LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.

Re: using javascript to create seat chart [modified]

ships_agr31-Mar-10 3:48

Re: using javascript to create seat chart

31-Mar-10 3:48

hi....if you can please elaborate how can i use the update panel for the seat chart of a cinema hall as i'm not through with all the technicalities of asp.net....as i'm still studying it.

modified on Wednesday, March 31, 2010 12:27 PM

sashidhar31-Mar-10 19:39

sashidhar

31-Mar-10 19:39

First how You are trying to display the number of seats. are you trying to use the buttons or any control.
I suggest you the update panel because it will not refresh the whole page .

LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.

Re: using javascript to create seat chart

ships_agr1-Apr-10 3:32

Re: using javascript to create seat chart(i tried nd presenting the code here)

1-Apr-10 3:32

hi all....

i'm using html input button for this purpose....but i'm unable to retrieve the values in .cs file....what i want is to display arrangement of around 100 seats in a theatre...and would like user to select some seats whose color will change on clicking without reloading the page.....and in .cs file i may be able to retrieve the seat numbers...???
same seat chart as you would find one while booking tickets for a movie online....they ask you select seats of your choice....i wanna do the same thing....can anyone help me???

ships_agr1-Apr-10 5:21

Re: using javascript to create seat chart(i tried nd presenting the code here)

1-Apr-10 5:21

hi sashidhar.....

i tried to use the update panel.....i took an update panel.....and 5 buttons....took a session variable and incremented it on click event of each button.....it all worked but the problem now is if i refresh the page the value of session variable is not refreshed....counting starts from the last where the page was refreshed....i'm providing you the code....Have a look....!!!
The default.aspx File:
<body>
<form id="form1" runat="server">
<div>

<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<br />
<asp:Button ID="Button6" runat="server" onclick="Button6_Click" Text="cancel" />
<br />
<br />
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<br />
<br />
<br />
<asp:Label ID="Label1" runat="server" Text="Panel Created"></asp:Label>
<br />
<br />
<br />
<asp:Button ID="Button1" runat="server" BackColor="Aqua"
onclick="Button1_Click" Text="Button" />
<br />
<br />
<asp:Button ID="Button2" runat="server" BackColor="Aqua"
onclick="Button2_Click" Text="Button" />
<br />
<br />
<asp:Button ID="Button3" runat="server" BackColor="Aqua"
onclick="Button3_Click" Text="Button" />
<br />
<br />
<asp:Button ID="Button4" runat="server" BackColor="Aqua"
onclick="Button4_Click" Text="Button" />
<br />
<br />
<asp:Button ID="Button5" runat="server" BackColor="Aqua"
onclick="Button5_Click" Text="Button" />
</ContentTemplate>
</asp:UpdatePanel>

</div>
</form>
</body>

now the Default.aspx.cs File:
The code was given on click event of all buttons taken in update panel:

int i = Convert.ToInt32(Session["i"]);
i++;
Session["i"] = i.ToString();
Button3.BackColor = System.Drawing.Color.Red;
Label1.Text = "Refreshed at " + DateTime.Now.ToString();
Button3.Enabled = false;

ships_agr1-Apr-10 5:26