ASP.NET

Re: How to load an image data from SQL Server 2000 to Datagrid!!!

20-Mar-07 21:50

try this:
http://aspalliance.com/articleViewer.aspx?aId=141&pId=

code-frog20-Mar-07 21:55

code-frog

20-Mar-07 21:55

Here is this: http://www.codeproject.com/aspnet/CPImageGallery.asp[^]

It doesn't show the part about dumping it into a datagrid but I believe that is the easier of the tasks involved. It's a fully functioning application and you should readily be able to customize it.

how to make a Calendar through javascript

MissionSuccess20-Mar-07 20:06

20-Mar-07 20:06

Respected Gurus
I want to make a calendar through javascript.
it should not be any third party control because it may create problem when i will upload my project on the server.

It should not be machine dependent.
plz give me some code......
or any link where i can get some code....

Any solution

Ajay

varshavmane20-Mar-07 20:15

20-Mar-07 20:15

U can search for any Javascript calender control u will get many js files which u can use.If u didnt get then I can provide u.......

MissionSuccess20-Mar-07 20:28

20-Mar-07 20:28

I have already found a BasicDatePicker Control,which has a .js file.
Its working fine on my local PC.But cannot find that .js file on the server and giving error.

I have given that .js file.still same error.

also tell me whether bin folder is the root folder for any web application or not.

Ajay

varshavmane20-Mar-07 20:40

20-Mar-07 20:40

Use this js file.Copy this code in Calender.js file and make a js folder on root and save this js file there.Then u need to add the js file link syntax I have given below.Finally u have to add the selected date in the textbox this also I have given.
1:Save as Calender.js

var ele;
var selDay, selMonth ,selYear;

var parentWin;
var iYear;
var incyear ;
var newWin;

function funcClose(strDate)
{
var arr_date = strDate.split('/');
if (arr_date.length != 3)
{
}
else
{
if(arr_date[0]>=1 && arr_date[0]<=9)
arr_date[0] = 0 + arr_date[0];
if(arr_date[1]>=1 && arr_date[1]<=9)
arr_date[1] = 0 + arr_date[1];
}
strDate = arr_date[0]+'/'+arr_date[1]+'/'+arr_date[2];
ele.value = strDate
newWin.close()
}

function GetNoOfDaysInAMonth(iMonth ,iYear)
{
var intDays

switch (iMonth)
{
case "1":
intDays= 31
break;

case "2" :
if (((iYear % 4 == 0) && (iYear % 100 != 0)) || (iYear % 400 == 0))
intDays = 29
else
intDays = 28
break;

case "3":
intDays = 31
break;

case "4":
intDays = 30
break;

case "5":
intDays = 31
break;

case "6" :
intDays = 30
break;

case "7" :
intDays = 31
break;

case "8":
intDays = 31
break;

case "9":
intDays = 30
break;

case "10":
intDays = 31
break;

case "11":
intDays = 30
break;

case "12":
intDays = 31
break;
}

return (intDays)
}

function FillMonthCombo()
{
//document.frm.cboMonth.appendChild.nodeValue ="<option>Jan</option>"
}

function incYear()
{
//incyear = parseInt(incyear) + 1
//Build_calendar()
}

function decYear()
{
//incyear = parseInt(incyear) - 1
//Build_calendar()
}

function Calendar()
{

var TotalDays;
var strCalendar;
var strStartDay;
var intCnt;
var intDays;
var vsCnt;
var i;

ele = arguments[0]

if (ele.value !="")
var currentDate = new Date(ele.value);
else
var currentDate = new Date();

selDay = currentDate.getDate()
selMonth = currentDate.getMonth()
selYear = currentDate.getFullYear()
if(newWin!=null)
newWin.close();
newWin = window.open("","Calendar","height=250,width=300,left=200,top=200");
parentWin = window.opener
newWin.document.write ('<html><title>Select Date</title><head><link href="../css/G_CSS1024.css" rel="stylesheet" type="text/css"></head>')
newWin.document.write ('<body><table align=center valign=top border=0 cellspacing=0 cellpadding=0 width=100%><tr><td><img src=../images/gr_head.gif width=100% height=26></td></tr><tr><td align=center class=frmTxt><form name="frm">')
newWin.document.write ('<font class=bold>Month :</font><select Class="inputtxt" name=cboMonth onchange="window.opener.Build_calendar()">')

vsSel =""
if (parseInt(selMonth) == 0)
vsSel = " selected"
newWin.document.write ('<option value="1" ' + vsSel + ' >Jan</option>')

vsSel =""
if (parseInt(selMonth) == 1)
vsSel = " selected"

newWin.document.write ('<option value="2" ' + vsSel + '>Feb</option> ')

vsSel =""
if (parseInt(selMonth) == 2)
vsSel = " selected"

newWin.document.write ('<option value="3" ' + vsSel + '>Mar</option> ')
vsSel =""
if (parseInt(selMonth) == 3)
vsSel = " selected"

newWin.document.write ('<option value="4" ' + vsSel + '>Apr</option> ')
vsSel =""
if (parseInt(selMonth) == 4)
vsSel = " selected"

newWin.document.write ('<option value="5" ' + vsSel + '>May</option> ')
vsSel =""
if (parseInt(selMonth) == 5)
vsSel = " selected"

newWin.document.write ('<option value="6" ' + vsSel + '>Jun</option> ')
vsSel =""
if (parseInt(selMonth) == 6)
vsSel = " selected"

newWin.document.write ('<option value="7" ' + vsSel + '>Jul</option> ')
vsSel =""
if (parseInt(selMonth) == 7)
vsSel = " selected"

newWin.document.write ('<option value="8" ' + vsSel + '>Aug</option> ')
vsSel =""
if (parseInt(selMonth) == 8)
vsSel = " selected"

newWin.document.write ('<option value="9" ' + vsSel + '>Sep</option> ')

vsSel =""
if (parseInt(selMonth) == 9)
vsSel = " selected"
newWin.document.write ('<option value="10" ' + vsSel + '>Oct</option>')

vsSel =""
if (parseInt(selMonth) == 10)
vsSel = " selected"
newWin.document.write ('<option value="11" ' + vsSel + '>Nov</option>')

vsSel =""
if (parseInt(selMonth) == 11)
vsSel = " selected"
newWin.document.write ('<option value="12" ' + vsSel + '>Dec</option>')

newWin.document.write ('</select> ')
newWin.document.write ('<font class=bold>Year :</font><select Class="inputtxt" name=cboYear onchange="window.opener.Build_calendar()"> ')
for (intCnt = 1900 ; intCnt < 2050 ;intCnt ++)
{
if(parseInt(selYear) == parseInt(intCnt))
newWin.document.write ('<option value= ' + intCnt + ' selected >' + intCnt +' </option>')
else
newWin.document.write ('<option value= ' + intCnt + '>' + intCnt +' </option>')
}
//document.write ('<option value=2001>2001</option>')
//document.write ('<option value=2002>2002</option>')
//document.write ('<option value=2003>2003</option>')
newWin.document.write ('</select><br><img src=../images/blank.gif height=4>')
newWin.document.write ('<div id="CalID"></div><br><div id=curDate style="background-image:url(../images/gr_head.gif);"></div>')
newWin.document.write ('</form></td></tr></table></body></html>')
iYear = newWin.document.frm.cboYear.value
incyear =iYear
var dtm = new Date();
newWin.curDate.innerHTML ="Today's Date is "+ dtm.toDateString() ;
Build_calendar ()
}

function Build_calendar ()
{
iMonth = newWin.document.frm.cboMonth.value
iYear = newWin.document.frm.cboYear.value
//iYear = incyear
var strDate = new Date(iMonth + "/1/" + iYear )
strStartDay = strDate.getDay ()

TotalDays = GetNoOfDaysInAMonth (iMonth,iYear)
strCalendar = "<table width=100% cellpadding=1 cellspacing=1 border=0 ><tr><td colspan=7 class='Data_hd' width='100%'>" + newWin.document.frm.cboMonth[newWin.document.frm.cboMonth.value-1].innerText + " " + iYear + "</td></tr>"
strCalendar = strCalendar + "<tr align=center><td class='bold'>Sun</td><td class='bold'>Mon</td><td class='bold'> Tue</td><td class='bold'>Wed</td><td class='bold'>Thu</td><td class='bold'>Fri</td><td class='bold'>Sat</td></tr>"
strCalendar = strCalendar + "<tr align=center>"

for (intCnt = 1 ;intCnt <= strStartDay;intCnt++)
{
strCalendar = strCalendar + "<td class=frmTxt> </td>"
}

intDays = 1

for (intCnt = strStartDay; intCnt < 7 ;intCnt++)
{
strDateVal = iMonth + "/" + intDays + "/" + iYear
if (parseInt(selDay) == parseInt(intDays))
strCalendar = strCalendar + "<td class=Today><a href=# onclick=window.opener.funcClose('"+ strDateVal + "')>" + intDays + "</a></td>"
else
strCalendar = strCalendar + "<td class=frmTxt><a href=# onclick=window.opener.funcClose('"+ strDateVal + "')>" + intDays + "</a></td>"
intDays = intDays + 1
}

strCalendar = strCalendar + "</tr><tr align=center>"

vsCnt=0

for (i=intDays ; i<= TotalDays ; i++)
{
strDateVal = iMonth + "/" + i + "/" + iYear
if (vsCnt == 7)
{
vsCnt =0
strCalendar = strCalendar + "<tr align=center>"
}

if (parseInt(selDay) == parseInt(i))
strCalendar = strCalendar + ("<td class=Bold><a href=# onclick= window.opener.funcClose('"+ strDateVal +"')>" + i + "</a></td>")
else
strCalendar = strCalendar + ("<td class=frmTxt><a href=# onclick= window.opener.funcClose('"+ strDateVal +"')>" + i + "</a></td>")
vsCnt = vsCnt + 1
}

strCalendar = strCalendar + "</table>"
newWin.CalID.innerHTML = strCalendar

}

2:Put this in Head tag
<script language="javascript" type="text/javascript" src="../js/Calender.js"></script>

3:this is the textbox where u want the selected date.

<A onclick="javascript:Calendar(frmBillingTabDetails.GI_txtReceivedDate)" href="#">
<input name="GI_txtReceivedDate" type="text" class="text" id="GI_txtReceivedDate" style="width: 120px" maxlength=8 readOnly Runat="server">
<IMG height="22" src="../images/show-calendar.gif" width="22" align="absMiddle" border="0" alt="Pick Received Date"></A>

Hope this will help u.Please let me know if u have any problem...

MissionSuccess20-Mar-07 21:15

20-Mar-07 21:15

thanks for the code
i follow your instructions.

Problems are--

1.cannot see any image(i think u have not given the image thats why?)
2.when i m going to click on the image it shows the error

'frmBillingtabDetails' is undefined.

varshavmane20-Mar-07 21:29

20-Mar-07 21:29

was just think that I forgot to tell u about the frmBillingtabDetails, it is nothing but the form name which there at
<form id="frmBillingTabDetails" runat="server">
and regarding Image u cal take any calender imageand replace the link of src in img tag
<IMG height="22" src="UR IMAGE LINK" width="22" align="absMiddle" border="0" alt="Pick Received Date">

Hope now it works........

MissionSuccess20-Mar-07 21:41

20-Mar-07 21:41

I have already replaced the frmBillingTabDetails with my form's Id.
Now the error comes when i click on the Link.
"Object Expected."

varshavmane20-Mar-07 21:46

20-Mar-07 21:46

Please post the code......

Sebastian T Xavier20-Mar-07 21:26

20-Mar-07 21:26

Hi,

I have gone through this code snippet and tried to implement in one sample appln. i am using asp.net 2.0.

I got an error like this "frmBillingTabDetails is undefined". Then i replaced frmBillingTabDetails with Default(thats the name of page<default.aspx>). Again it showed the same error.

will you help me!

Sebastian

varshavmane20-Mar-07 21:30

20-Mar-07 21:30

U can read my reply......

Sebastian T Xavier20-Mar-07 21:42

20-Mar-07 21:42

Thanks for ur reply. I have made that change. now the id of the form has been changed. Again it shows an error like "Object Expected".

then what should i try? Pls help..

Thanks once again

sebastian

varshavmane20-Mar-07 21:45

20-Mar-07 21:45

Have u followed the steps properly???As its works on my Application.....Please do that....

MissionSuccess20-Mar-07 21:52

20-Mar-07 21:52

1.First of all i copy and paste the javascript code in a javascript file name it Calendar.js and save it in E:\Inetpub\wwwroot\js.

My project is in E:\Inetpub\wwwroot\

2.Now Add

in head section.

3.and then

inside the form tag.my form's Id is frmBillingTabDetails.

Is it Ok sir...

varshavmane20-Mar-07 21:57

20-Mar-07 21:57

What is ur Project Name???
u have to create js folder in E:\Inetpub\wwwroot\URProjectName\js

and then change src in
<script language="javascript" type="text/javascript" src="../js/Calender.js"></script>

Hope this will work...

Sebastian T Xavier20-Mar-07 21:55

20-Mar-07 21:55

Yes but not working. I don't know wats the problem?

anyway thanks for your kind reply

thanks

varshavmane20-Mar-07 21:59

20-Mar-07 21:59

Thats ok but I think the problem will be with the folder location and the link which u have given......

Sebastian T Xavier21-Mar-07 0:16

21-Mar-07 0:16

You can try the following link

http://www.codeproject.com/useritems/aspnet-yahoouicalendar.asp[^]

Best Regards

Sebastian

data grid

yogendu20-Mar-07 19:58

yogendu

20-Mar-07 19:58

hi i am using vb as codebehind in asp.net. can you please let me know how to
view data in datagrid using oracle in asp.net..

thanks

Re: data grid

N a v a n e e t h20-Mar-07 20:01

N a v a n e e t h

20-Mar-07 20:01

yogendu wrote:
how to
view data in datagrid using oracle in asp.net..

1. Create oracle connection
2. Get data in some dataset or reader
3. Set this dataset as grids datasource and bind the grid.

For oracle connection and execution see oracleclient namespace.

printf("Navaneeth!!")

www.w3hearts.com

ASP.NET Certification

varshavmane20-Mar-07 19:16

Re: ASP.NET Certification

20-Mar-07 19:16

Hi All,

Can anyone please give me some help in ASP.NET Certification.I need some papers or any good study material....Please

Thanks in advance......

_AK_20-Mar-07 22:23

_AK_

20-Mar-07 22:23

You can go for brainbench certifications apart from microft certifications. They are free these days also.

Best Regards,
Apurva Kaushal

Re: ASP.NET Certification

varshavmane20-Mar-07 22:32