ASP.NET Discussion Boards

Re: Storing data from textboxes generated on runtime on button click that is also generated on runtime.

Lucky Sheikh5-Sep-07 0:22

5-Sep-07 0:22

hey don,t thanx in advance try it first
double click on button then fire the query to saving data in database table
ok byeeee

lucky

Urgent listbox values in Server side.

jayarajmrj4-Sep-07 21:26

jayarajmrj

4-Sep-07 21:26

I have moved the values from one listbox to another listbox by using Javascript. How can I reterive the values from the second listbox in server side ie., code behind? Because i will store the selected values in DB.

Re: Urgent listbox values in Server side.

Imran Khan Pathan4-Sep-07 21:38

Imran Khan Pathan

4-Sep-07 21:38

Looping through second Listbox.Item.Count and get selected values by using condition if listbox.Items[index].Selected is true then store them in DB

Best Regard
Pathan

---------------------------------------------------

Problem with Details View

haasini4-Sep-07 21:05

haasini

4-Sep-07 21:05

Hi All,

I have a Grid View which displays the product details using an SqlDataSource.I have an associated Details View through which I am inserting and editing Product Details using another SqlDataSource.The problem is whenever I insert a record into products the values are properly inserted and reflected in the grid but immediately after insertion, whenever i refresh the page the same record is getting inserted again.Why is it so?How wud I stop this.
Any small help in this regard wud be appreciated

Thanks
Haasini

Re: Problem with Details View

Imran Khan Pathan4-Sep-07 22:01

Imran Khan Pathan

4-Sep-07 22:01

Redirect the same page after inserting record

or

do not store Duplicate data in database using project Title or any other column name

Best Regard

---------------------------------------------------

Re: Problem with Details View

haasini5-Sep-07 1:19

haasini

5-Sep-07 1:19

Thanks a Ton Imran..
Its working perfectly fine.. Smile | :)

Regards
Haasini

how to get images in the child forms using Master page

Dhyanga4-Sep-07 20:17

Dhyanga

4-Sep-07 20:17

I have made one master page say master.aspx which is in the folder (ub/Forms/Common Forms/master.aspx) and has child form form1.aspx which is in the same folder(Forms/Common Forms/form1.aspx). I have included one image say image1.jpg which is in the folder(ub/images/common image/image1.jpg) in the master.aspx.Now when i run the form1.aspx, all the properties of master page comes except image1.jpg. The image1.jpg doesn't come.But when i take another child form say form2.aspx which is in the folder(/ub/form2.aspx),it shows all the properties of master.aspx including image1.jpg. But i want to show in form1.aspx...It's not working..Why so ??? How to solve it ?

suchitamanandhar@hotmail.com

Re: how to get images in the child forms using Master page

Michael Sync4-Sep-07 21:16

Michael Sync

4-Sep-07 21:16

maybe. try like that ../common image/image1.jpg (two dots)

OR

Use the full path (http://yoursite.com/ub/images/common image/image1.jpg)

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.

Re: how to get images in the child forms using Master page

Lucky Sheikh4-Sep-07 22:18

Lucky Sheikh

4-Sep-07 22:18

hey guy
take a contentpanel in ur form then
retreive the masterpage in ur form
images automatically display in ur form

lucky

How display like that in gridview?

indiaone4-Sep-07 20:08

indiaone

4-Sep-07 20:08

Hi.

From Database i m getting data in this format.

CAC PAT A 12/03/07
CAC PAT A 12/04/07
CAC PAT A 12/05/07
CMP CAT B 11/03/07
CMP CAT B 11/06/07
CMP CAT B 11/08/07
CPL AMT C 10/01/07
CPL AMT C 10/04/07
CPL AMT C 10/06/07

I want to display like that

CAC PAT A 12/03/07
12/04/07
12/05/07
CMP CAT B 11/03/07
11/06/07
11/08/07
CPL AMT C 10/01/07
10/04/07
10/06/07

How to do ?
Help me
Thanks

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

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