Re: Change Date to its equivillant in Gregorian - ASP.NET Discussion Boards

Re: How display like that in gridview?

varshavmane4-Sep-07 20:10

varshavmane

4-Sep-07 20:10

Use ItemDataBound Event of GridView.

Re: How display like that in gridview?

indiaone4-Sep-07 20:32

indiaone

4-Sep-07 20:32

thanks for reply

can you explain it

thanks

Re: How display like that in gridview?

Sathesh Sakthivel4-Sep-07 20:37

Sathesh Sakthivel

4-Sep-07 20:37

Try this is the code which i used for it.

private void DG_ItemDataBound(object o, DataGridItemEventArgs e)<br />
    {        <br />
        // apply custom formatting to data cells<br />
        if (e.Item.ItemType == ListItemType.Item<br />
            || e.Item.ItemType == ListItemType.AlternatingItem)<br />
        {<br />
            // set formatting for the category cell<br />
            TableCell cell = (e.Item.Controls[0] as TableCell);<br />
            cell.Width = new Unit("120px");<br />
            cell.Style["border-right"] = "2px solid #666666";<br />
            cell.BackColor = System.Drawing.Color.LightGray;<br />
            <br />
            // set formatting for value cells<br />
            for(int i=1; i<e.Item.Controls.Count; i++)<br />
            {<br />
                cell = (e.Item.Controls[i] as TableCell);<br />
                <br />
                // right-align each of the column cells after the first<br />
                // and set the width<br />
                cell.HorizontalAlign = HorizontalAlign.Right;<br />
                cell.Width = new Unit("90px");<br />
                <br />
                // alternate background colors<br />
                if (i % 2 == 1)<br />
                    cell.BackColor <br />
                      =  System.Drawing.ColorTranslator.FromHtml("#EFEFEF");<br />
<br />
                // check value columns for a high enough value<br />
                // (value >= 8000) and apply special highlighting<br />
                if (GetCellValue(cell) >= 8000)<br />
                {<br />
                    cell.Font.Bold = true;<br />
                    cell.BorderWidth = new Unit("1px");<br />
                    cell.BorderColor = System.Drawing.Color.Gray;<br />
                    cell.BorderStyle = BorderStyle.Dotted;<br />
                    cell.BackColor = System.Drawing.Color.Honeydew;<br />
                }<br />
                                      <br />
            }                    <br />
            <br />
        }<br />
        <br />
        // apply custom formatting to the header cells        <br />
        if (e.Item.ItemType == ListItemType.Header)<br />
        {<br />
            foreach (TableCell cell in e.Item.Controls)<br />
            {<br />
                cell.Style["border-bottom"] = "2px solid #666666";<br />
                cell.BackColor=System.Drawing.Color.LightGray;<br />
            }<br />
        }<br />
                <br />
    }

It is an Example only try it with your specs.

SSK.

Re: How display like that in gridview?

N a v a n e e t h4-Sep-07 22:48

N a v a n e e t h

4-Sep-07 22:48

Exactly copied from this[^]. Shame on you

My Website | Ask smart questions

Re: How display like that in gridview?

varshavmane4-Sep-07 20:47

varshavmane

4-Sep-07 20:47

Item Data Bound is the event which is fired before u bind the GridView Control, so either u can fire a query where u will get the ID and Different dates and then match that ID with the e.Row.Cells[0].Text and do something like this:

e.Row.Cells[1].Text= //Put all the different date in a string variable separated by

Before this u will have to write the above code in this if statement:

if (e.Row.RowType == DataControlRowType.DataRow)
{
}

I am not sure about the syntax. But u can get it.
Hope u understood the code.

Re: How display like that in gridview?

Lucky Sheikh4-Sep-07 22:23

Lucky Sheikh

4-Sep-07 22:23

hey guy first of all where u want to display the format in crystal or other if in crystal report make a group go to group insert group select the datatable column name it will be work.
byeeeeeeeee

lucky

Change Date to its equivillant in Gregorian

samerh4-Sep-07 19:27

samerh

4-Sep-07 19:27

Is it possible that i enter a date in other format than Gregorian and upon tab for example change it to its equivillant in Gregorian.
thanks

Re: Change Date to its equivillant in Gregorian

Sathesh Sakthivel4-Sep-07 19:28

Sathesh Sakthivel

4-Sep-07 19:28

Yes.

SSK.

Re: Change Date to its equivillant in Gregorian

samerh4-Sep-07 19:37

samerh

4-Sep-07 19:37

Can you please tell me how?
Thanks

How to play video based on some value?

n_gchaitra4-Sep-07 19:16

n_gchaitra

4-Sep-07 19:16

Hi ,
i am using the following code in html to play videos in media player. But i want to give the filename based on the value present in radiobuttonlist. But how to do this? I am confused. Any help ?

<object id="mediaplayer" classid="clsid:22D6F312-B0F6-11D0-94AB-0080C74C7E95" style="width: 216px; height: 168px">
<param name="FileName" value="funny.wmv" />

Chaitra N

Re: How to play video based on some value?

Michael Sync4-Sep-07 20:05

Michael Sync

4-Sep-07 20:05

<a href = "http://www.killersites.com/mvnforum/mvnforum/viewthread?thread=3602#18305" rel="nofollow">http://www.killersites.com/mvnforum/mvnforum/viewthread?thread=3602#18305</a>

<pre>
<script type="text/javascript">
function play(media){
document.getElementById('mediaplayer').innerHTML=
'<object classid="clsid:22d6f312-b0f6-11d0-94ab-0080c74c7e95"'
+'type="application/x-oleobject" width="320" height="285">'
+'<param name="showControls" value="false">'
+'<param name="fileName" value="'+media+'">'
+'<embed type="application/x-mplayer2" width="320" height="285"'
+'showcontrols="false" src="'+media+'"><\/embed><\/object>'
}
</script>

Add this to the CSS:

#mediaplayer {
width: 320px;
height: 285px;
background: #000;
}

And put this in the html where you want the videos to play and menu:

<div id="mediaplayer"></div>
<ul id="menu">
<li><a onclick="play("<b>mymovie1.wmv</b>");return false" href="">Movie 1</a></li>
<li><a onclick="play("<b>mymovie2.wmv</b>");return false" href="">Movie 2</a></li>
</ul></pre>

<b>Note that OBJECT tag won't work on Firefox. </b>

Edit: Text editor is really bad for posting code..

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you. Smile | :)

Re: How to play video based on some value?

n_gchaitra4-Sep-07 21:25

n_gchaitra

4-Sep-07 21:25

Hi Michael,

The code i sent is working fine but i want it to get displayed based on the title present in bulletedlist.

See I am storing the path of the video files in my database. I am using the following code to retrieve the path of the file. What I am finding difficult is to assign that path to the " filename " of the mediaplayer object

Protected Sub Show_Products(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.BulletedListEventArgs) Handles BulletedList1.Click
Dim SQLString As String = "SELECT filepath FROM pictures WHERE title = '" & BulletedList1.Items(e.Index).Text & "'"
Dim dr As Data.SqlClient.SqlDataReader
Dim comm As New Data.SqlClient.SqlCommand(SQLString, dbconn)
If dbconn.State <> ConnectionState.Open Then
dbconn.Open()
End If
Dim str As String
dr = comm.ExecuteReader
While dr.Read
str = dr.Item(0)
End While
dr.Close()
str = str
End Sub

Validation for date with leap year

samerh4-Sep-07 19:12

samerh

4-Sep-07 19:12

Hi all,
i need a validation rule for date dd/MM/yyyy that applies rule of leap year.
thanks

Re: Validation for date with leap year

Sathesh Sakthivel4-Sep-07 19:19

Sathesh Sakthivel

4-Sep-07 19:19

Try with this code

TWO STEPS TO INSTALL VALIDATE DATE:

1. Copy the coding into the HEAD of your HTML document
2. Add the last code into the BODY of your HTML document -->

<br />
<HEAD><br />
<br />
<SCRIPT LANGUAGE="JavaScript"><br />
<br />
<!-- This script and many more are available free online at --><br />
<!-- The JavaScript Source!! http://javascript.internet.com --><br />
<!-- Original:  Torsten Frey (tf@tfrey.de) --><br />
<!-- Web Site:  http://www.tfrey.de --><br />
<br />
<!-- Begin<br />
function check_date(field){<br />
var checkstr = "0123456789";<br />
var DateField = field;<br />
var Datevalue = "";<br />
var DateTemp = "";<br />
var seperator = ".";<br />
var day;<br />
var month;<br />
var year;<br />
var leap = 0;<br />
var err = 0;<br />
var i;<br />
   err = 0;<br />
   DateValue = DateField.value;<br />
   /* Delete all chars except 0..9 */<br />
   for (i = 0; i < DateValue.length; i++) {<br />
	  if (checkstr.indexOf(DateValue.substr(i,1)) >= 0) {<br />
	     DateTemp = DateTemp + DateValue.substr(i,1);<br />
	  }<br />
   }<br />
   DateValue = DateTemp;<br />
   /* Always change date to 8 digits - string*/<br />
   /* if year is entered as 2-digit / always assume 20xx */<br />
   if (DateValue.length == 6) {<br />
      DateValue = DateValue.substr(0,4) + '20' + DateValue.substr(4,2); }<br />
   if (DateValue.length != 8) {<br />
      err = 19;}<br />
   /* year is wrong if year = 0000 */<br />
   year = DateValue.substr(4,4);<br />
   if (year == 0) {<br />
      err = 20;<br />
   }<br />
   /* Validation of month*/<br />
   month = DateValue.substr(2,2);<br />
   if ((month < 1) || (month > 12)) {<br />
      err = 21;<br />
   }<br />
   /* Validation of day*/<br />
   day = DateValue.substr(0,2);<br />
   if (day < 1) {<br />
     err = 22;<br />
   }<br />
   /* Validation leap-year / february / day */<br />
   if ((year % 4 == 0) || (year % 100 == 0) || (year % 400 == 0)) {<br />
      leap = 1;<br />
   }<br />
   if ((month == 2) && (leap == 1) && (day > 29)) {<br />
      err = 23;<br />
   }<br />
   if ((month == 2) && (leap != 1) && (day > 28)) {<br />
      err = 24;<br />
   }<br />
   /* Validation of other months */<br />
   if ((day > 31) && ((month == "01") || (month == "03") || (month == "05") || (month == "07") || (month == "08") || (month == "10") || (month == "12"))) {<br />
      err = 25;<br />
   }<br />
   if ((day > 30) && ((month == "04") || (month == "06") || (month == "09") || (month == "11"))) {<br />
      err = 26;<br />
   }<br />
   /* if 00 ist entered, no error, deleting the entry */<br />
   if ((day == 0) && (month == 0) && (year == 00)) {<br />
      err = 0; day = ""; month = ""; year = ""; seperator = "";<br />
   }<br />
   /* if no error, write the completed date to Input-Field (e.g. 13.12.2001) */<br />
   if (err == 0) {<br />
      DateField.value = day + seperator + month + seperator + year;<br />
   }<br />
   /* Error-message if err != 0 */<br />
   else {<br />
      alert("Date is incorrect!");<br />
      DateField.select();<br />
	  DateField.focus();<br />
   }<br />
}<br />
//  End --><br />
</script><br />
<br />
</HEAD><br />
<br />
<!-- STEP TWO: Copy this code into the BODY of your HTML document  --><br />
<br />
<BODY><br />
<br />
<CENTER><br />
<FORM name="datecheck"><br />
<TABLE border="0" width="60%"><br />
    <TR><br />
  	<TD><br />
    Enter Date (Use European format shown at right)<P><br />
  	<INPUT type="text" name=testdat size='10' maxlength="10" onblur="check_date(this)"><br />
  	<INPUT type= "submit" name="button" value="Press to Validate"><p><br />
	(Date is validated after leaving the field.)<br />
    </TD><br />
    <TD><br />
  	ddmmyy (171201)   or <BR><br />
  	ddmmyyyy (17122001) or <BR><br />
  	ddXmmXyy (17-12-01 or 17y12q01 ... ) or <BR><br />
  	ddXmmXyyyy (17.12.2001 or 17,12,2001 ...) <br><br />
  	where "X" is any sign not in 0..9, i.e. "-" or "/"<p><br />
  	</TD><br />
    </TR><br />
</TABLE><br />
</FORM><br />
</CENTER><br />

Hope this will help you.

SSK.

Re: Validation for date with leap year

Lucky Sheikh4-Sep-07 22:27

Lucky Sheikh

4-Sep-07 22:27

heyyyyy
just apply the condition leap year is in four year
so if a >= 4 then leap year
else not a leap year
byeee

lucky

Urgent Listbox to listbox by using javascript

jayarajmrj4-Sep-07 19:04

jayarajmrj

4-Sep-07 19:04

I have two listboxes ,one of the listbox data is populate in database. And I have two buttons Add and Remove.

Once I click the add the button , the selected items is populated in another list box by using Javascript.

Similarly Remove also.
Give the javascript code or suitable link for the above scenrio

Re: Urgent Listbox to listbox by using javascript

varshavmane4-Sep-07 20:12

varshavmane

4-Sep-07 20:12

Use the Following code:

function f_optionMove(s_from, s_to)
{
var e_from = document.getElementById(s_from), e_to = document.getElementById(s_to);//test_form.elements[s_from],e_to = document.forms['test_form'].elements[s_to];
if (!e_from.name)
return alert ("Error: selectbox with name '" + s_from + "' can't be found.");
if (!e_to.name)
return alert ("Error: selectbox with name '" + s_from + "' can't be found.");
var n_moved = 0;

for (var i = 0; i < e_from.options.length; i++)
{
if (e_from.options[i].selected)
{
var name = e_from.options[i].text;
var ID = e_from.options[i].value;
e_from.options[i] = null;
e_to.options[e_to.options.length] = new Option (name,ID);
n_moved++;
}
}
if (n_moved)
e_from.options.length = e_from.options.length;
else
alert("You haven't selected any options");
}

function f_optionMoveAll(s_from, s_to)
{
var e_from = document.getElementById(s_from), e_to = document.getElementById(s_to);
if (!e_from.name)
return alert ("Error: selectbox with name '" + s_from + "' can't be found.");
if (!e_to.name)
return alert ("Error: selectbox with name '" + s_from + "' can't be found.");
var cntDesc = e_from.options.length;
var cntSource = e_to.options.length;
for (var i = 0; i < cntDesc; i++)
{
var name = e_from.options[i].text;
var ID = e_from.options[i].value;
e_to.options[cntSource] = new Option (name,ID);
cntSource++;
}
e_from.options.length = 0;
}

<

table border="0" cellpadding="0" cellspacing="0" style="width: 100%">

<asp:listbox id="lstsource" runat="server" selectionmode="Multiple">




	< asp:ListBox ID ="lstdestination" runat="server" SelectionMode ="Multiple">

Re: Urgent Listbox to listbox by using javascript

jayarajmrj4-Sep-07 21:23

jayarajmrj

4-Sep-07 21:23

how can i store the values in the 'lstdestination' listbox. Suppose i select the three values from the lstsource. How can i reterive the three values in server side ie., Code behind.

Re: Urgent Listbox to listbox by using javascript

varshavmane4-Sep-07 21:34

varshavmane

4-Sep-07 21:34

What is the exact functionality u want, please explain that so that I can give u the proper suggestion.

Re: Urgent Listbox to listbox by using javascript

codelinks4-Sep-07 21:54

codelinks

4-Sep-07 21:54

hi found this in codeproject

http://www.codeproject.com/useritems/Listbox_or_combo_box.asp

winnie

Change the GridView Row Control on Mouse over

varshavmane4-Sep-07 18:21

varshavmane

4-Sep-07 18:21

Hi All,

I need to show textbox control in gridview row on mouse over (any other event as I am not sure which event should I capture) and on mouse out it should be a normal row.

Next on Mouse over if I change the value of the textbox then its should change the value of all the dependent textbox, like we have in excel ie; if I have the 10 in A1 cell and 15 in B1 cell and C1 is the sum of A1 and B1 then if I change the value of any of the cells (A1 or B1) then it automatically reflects in C1.

Finally I need to write this in XML file as I dont want to update my Database with this new values.
Please help me...

Thanks in advance...

Grid View

seemamltn4-Sep-07 14:09

seemamltn

4-Sep-07 14:09

When I do UsersDataTable it gives me following error

The type or namespace name 'UsersDataTable' could not be found (are you
missing a using directive or an assembly reference?)

Label2.Text = "Total Record count in the gridview above= " +
((UsersDataTable)e.ReturnValue).Count.ToString();

seema

Re: Grid View

Christian Graus4-Sep-07 14:57

Christian Graus

4-Sep-07 14:57

I've never heard of that type, where do you expect it to come from ? Or do you just mean DataTable ? You can use the debugger to find out what type e is.

Have you considered using real variable names, or are you entering a code obsfucation contest ?

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Re: Grid View

N a v a n e e t h4-Sep-07 18:04

N a v a n e e t h

4-Sep-07 18:04

seemamltn wrote:
When I do UsersDataTable it gives me following error

What is UsersDataTable ? Is it a datatable instance ? Check you are using namespace System.Data

My Website | Ask smart questions

Re: Grid View

Herman<T>.Instance5-Sep-07 2:15

Herman<T>.Instance

5-Sep-07 2:15

Don't you need UsersDataTable.Rows.Count (if UsersDataTable is the ID of your GridView) ?

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.