ASP.NET

Christian Graus14-Nov-07 23:30

14-Nov-07 23:30

This is a sure sign that your overall design is broken, because it's working when your code can assume that the client is the server.

Christian Graus - Microsoft MVP - C++

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Prateek G14-Nov-07 22:59

Prateek G

14-Nov-07 22:59

If you are using Response.AppendHearder("Content-Disposition"........) remove it, it will be open in same window and will not give you any popup. Add all the content to Response.BinaryWrite(byte[],offset,count);

Sunil Wise14-Nov-07 23:19

Sunil Wise

14-Nov-07 23:19

Mr.Prateek G could u please tell me how to use Response.BinaryWrite method what are the values i have to give for the attributes byte, offset and count
i have never used this Response.BinaryWrite method
i am getting only the path and filename

uploading and retrive image

Prateek G14-Nov-07 23:40

Prateek G

14-Nov-07 23:40

Try this
string sourceFile = "C:\\Documents and Settings\\PrateekGupta\\Desktop\\pref.xml";

Response.ClearContent();
Response.ClearHeaders();
Response.ContentType = "application/octet-stream";
FileInputStream filIpStrm = null;
MemoryStream ms = new MemoryStream();
filIpStrm = new FileInputStream(sourceFile);
sbyte[] buffer = new sbyte[1024];
int len = 0;
while ((len = filIpStrm.read(buffer)) >= 0)
{
byte[] bbuffer = new byte[1024];
System.Buffer.BlockCopy(buffer,0,bbuffer,0,1024);

ms.Write(bbuffer,0,1024);
}

Response.OutputStream.Write(ms.ToArray(), 0, Convert.ToInt32(ms.Length));

filIpStrm.close();

Response.End();

let me know if it will work for u...

Krishna Varadharajan14-Nov-07 21:54

Re: uploading and retrive image

14-Nov-07 21:54

Hi,

I want to uploading a image and retrive, i uploaded but in database its storing like binary data, so iam not getting my image in output. Iam using mssql.

Can u pls help me

krishna

krishna

Christian Graus14-Nov-07 22:38

PDF storing in Temporary Folder [modified]

14-Nov-07 22:38

OK, you have a few problems here

1 - binary data is how you want to store it, you just need to turn that data back into an image, which you do by putting it into a memory stream and building an Image out of that.
2 - because you're using ASP.NET, any images you store in the database can only be served inside a page if you feed them out through a HTTPhandler. A far easier approach is to store the images in your file system and store the path to them in SQL Server.

Shajeel14-Nov-07 21:26

Shajeel

14-Nov-07 21:26

Hi,

I have ASP.NET application in which i am showing some reports in pdf format. Application is login based some have rigths to see the report while some don't. Problem is whenever someone opens reports they are getting stored in Client Temporary folder. Any solution. I cannot change client setting.

I have asked another question in ADO.NET forum, if anyone can give answer to that one too. Here is the link
http://www.codeproject.com/script/comments/forums.asp?forumid=1725&noise=1&mpp=50&select=2319646#xx2319646xx[^]

Last modified: 60mins after originally posted --

Regards
Shajeel

code to logout on window close

rockz...14-Nov-07 21:24

rockz...

14-Nov-07 21:24

I want to call my web application logout page on window close.what code should I write in javascript.

Re: code to logout on window close

Christian Graus14-Nov-07 21:28

Re: code to logout on window close [modified]

14-Nov-07 21:28

You can't, the window is going to close before the redirect occurs. The only way to get a message to the server when the window closes is to use AJAX.

Sonia Gupta14-Nov-07 21:43

Sonia Gupta

14-Nov-07 21:43

in body tag add the onbeforeunload function

funciton abc()<br />
{<br />
if(confirm('navigate to logout'))<br />
            {<br />
                location.href('logout.aspx');<br />
                return false;<br />
            }<br />
<br />
}

Hope this will help u.

-- modified at 3:52 Thursday 15th November, 2007

Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1

storing image

Krishna Varadharajan14-Nov-07 20:48

14-Nov-07 20:48

Iam want to store image in mssql db, i stored its storing like <binary data="">

can u give solution for this

krishna

Krishna Varadharajan14-Nov-07 20:49

14-Nov-07 20:49

storing like Binary data

krishna

Christian Graus14-Nov-07 21:18

14-Nov-07 21:18

Funny enough, the first google hit for 'SQL Server Image' is an artice on this site.

http://www.codeproject.com/useritems/imaging.asp[^]

Krishna Varadharajan14-Nov-07 21:41

14-Nov-07 21:41

Can u pls give the code in mssql....

krishna

N a v a n e e t h14-Nov-07 21:51

N a v a n e e t h

14-Nov-07 21:51

krishnavaradharajan wrote:
mssql....

MSSQL ? It stores the image as byte format. Choose image datatype.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

Krishna Varadharajan14-Nov-07 21:59

14-Nov-07 21:59

Yes i have given image as a data type....your previous code in oracle as asked u to give in sql.

krishna

Christian Graus14-Nov-07 22:36

ON CLICK EVENT IN Data grid

14-Nov-07 22:36

It shouldn't actually matter. And Oracle uses SQL. I think you mean SQL SERver, which is T-SQL.

ps.srinivasan14-Nov-07 20:28

ps.srinivasan

14-Nov-07 20:28

I have a requirement: If i click on a datagrid(cell),the data's corresponding to that particular data grid has to be displayed in a text box('s). I mean, if i click a roll number, corresponding data's like marks, class etc has to be displayed in a text box. Please suggest me a solution ASAP.

Re: ON CLICK EVENT IN Data grid

Christian Graus14-Nov-07 20:33

Re: ON CLICK EVENT IN Data grid

14-Nov-07 20:33

You need to insert javascript so that the data is in a div, and it's click event calls code that transfers it's value into the textbox.

Ravi_2114-Nov-07 20:50

Ravi_21

14-Nov-07 20:50

datagrid have the propery e.item(0).text=textbox1.text write it hope it works

Can i get a data in comma delimited format using query.

Sasmi_Office14-Nov-07 20:08

Sasmi_Office

14-Nov-07 20:08

Dear Friends,

Confused | :confused:

I have facing a problem in which i want data in delimited format
For Example,
Database: Northwind
Table: Products
Data Input:
ProductID CategoryID
1 1
1 2
1 3

Output:
ProductID CategoryID
1 1,2,3

i want this data in my View, can it possible please guide me.
Thanks in Advanced.

Sasmi

Re: Can i get a data in comma delimited format using query.

Sun Rays14-Nov-07 21:46

Sun Rays

14-Nov-07 21:46

Hi,
u can check this post.

http://www.thescripts.com/forum/thread143935.html[^]

Thanks,
Sun Rays

Re: Can i get a data in comma delimited format using query.

Sun Rays14-Nov-07 23:31

Sun Rays

14-Nov-07 23:31

Hi,
U can use this Store procedure to get your goal..

SET ANSI_WARNINGS OFF<br />
Declare @ono varchar(50)<br />
DECLARE My_Cursor CURSOR FOR<br />
SELECT distinct ProductID<br />
FROM Products<br />
<br />
drop table tmp<br />
create table tmp(ono varchar(50),allname varchar(50))<br />
<br />
OPEN My_Cursor<br />
<br />
FETCH NEXT FROM My_Cursor into @ono<br />
WHILE @@FETCH_STATUS = 0<br />
BEGIN<br />
DECLARE @MyList varchar(100)<br />
set @MyList = null<br />
SELECT  @MyList = COALESCE(@MyList + ', ', '') + <br />
   CAST(CategoryID AS varchar(5))<br />
FROM Products where ProductID = @ono<br />
insert into tmp(ono,allname) values(@ono,@MyList)<br />
    FETCH NEXT FROM My_Cursor into @ono<br />
END<br />
<br />
CLOSE My_Cursor<br />
DEALLOCATE My_Cursor<br />
<br />
select * from tmp<br />
<br />

Thanks,
Sun Rays

image upload problem

saravanan0514-Nov-07 19:51

saravanan05

14-Nov-07 19:51

hi friends

i upload the image

by default i wrote the stored procedure,the image does not store the original name in database..it store LGO1,LGO2 like this.

my problem is i upload the file .i got image name like this ballLGO1.gif,imageLGO2.gif...

how i remove ball in ballLGO1.gif

regards
saravanan

Known Is Drop.Unknown Is Ocean

Re: image upload problem

Christian Graus14-Nov-07 20:01