|
Hi everybody. Anyone help me.
I have a table in SQL 2000 with one of the colume is image data. But when I load this column to my Datagrid (in VB.Net, ASP.Net), I don't know how my Datagrid show the picture i inserted.
If someone know how to do this, Please help me. Thanks too much.
My email is: aeriscute@yahoo.com
Hanh Aeriscute
|
|
|
|
|
take new page page called image.aspx and write below code in its codebehind page.
protected void Page_Load(object sender, EventArgs e)<br />
{<br />
MemoryStream stream = new MemoryStream();<br />
SqlConnection connection = new<br />
SqlConnection(@"server=servername;database=DBname;uid=sa;pwd=ccc");<br />
try<br />
{<br />
connection.Open();<br />
SqlCommand command = new<br />
SqlCommand("select image_name from image", connection);<br />
byte[] image = (byte[])command.ExecuteScalar();<br />
stream.Write(image, 0, image.Length);<br />
Bitmap bitmap = new Bitmap(stream);<br />
Response.ContentType = "image/gif";<br />
bitmap.Save(Response.OutputStream, ImageFormat.Gif);<br />
bitmaps.Dispose();<br />
}<br />
finally<br />
{<br />
connection.Close();<br />
stream.Close();<br />
}<br />
}
Now in ur datagrid page just set src or imageurl of this page like this.
<datagrid id="" ...........="">
<columns>
<asp:templatefield>
<itemtemplate>
Best regards
Pathan
GOD HELP THOSE WHO HELP THEMSELF
|
|
|
|
|
try this:
http://aspalliance.com/articleViewer.aspx?aId=141&pId=
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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.......
|
|
|
|
|
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
|
|
|
|
|
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...
|
|
|
|
|
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.
|
|
|
|
|
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........
|
|
|
|
|
I have already replaced the frmBillingTabDetails with my form's Id.
Now the error comes when i click on the Link.
"Object Expected."
|
|
|
|
|
Please post the code......
|
|
|
|
|
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
|
|
|
|
|
U can read my reply......
|
|
|
|
|
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
|
|
|
|
|
Have u followed the steps properly???As its works on my Application.....Please do that....
|
|
|
|
|
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...
|
|
|
|
|
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...
|
|
|
|
|
Yes but not working. I don't know wats the problem?
anyway thanks for your kind reply
thanks
|
|
|
|
|
Thats ok but I think the problem will be with the folder location and the link which u have given......
|
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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......
|
|
|
|
|
You can go for brainbench certifications apart from microft certifications. They are free these days also.
Best Regards,
Apurva Kaushal
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
