Please if u can, solve my prob as quick as possible. - ASP.NET Discussion Boards

Storing & retrieving swf file from sql server

Tarun Dudhatra29-Oct-07 0:30

29-Oct-07 0:30

Hi friends, I am developing one application. In our application there are two types of multimedia object like Image and flash object. And I want to save it into sql server 2005 I can save image into database and also retrieve it successfully. But I cannot save and retrive swf object to and from database can anybody help me.

Thanks

Re: Storing & retrieving swf file from sql server

N a v a n e e t h29-Oct-07 0:39

N a v a n e e t h

29-Oct-07 0:39

Swf files are similar like any other files. What is the content type you given when sending this to page, what problem you are facing when fetching the data ?

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

My Website | Ask smart questions

Re: Storing & retrieving swf file from sql server

Tarun Dudhatra29-Oct-07 0:44

Tarun Dudhatra

29-Oct-07 0:44

Ya that I know when we store image it will store as a binary and when we store swf file it will store like binary only. But the mail problem is that how can we retrieve it

I want to convert this 3 line only.

Response.ContentType = "image/jpeg"; // 1
Response.ContentType = "application/x-shockwave-flash"; // Done

System.Drawing.Image image = RetrieveImage(id, tname);

image.Save(Response.OutputStream, System.Drawing.Imaging.ImageFormat.Jpeg);

How can we change this two line for shockwavw object

Re: Storing & retrieving swf file from sql server

N a v a n e e t h29-Oct-07 0:51

N a v a n e e t h

29-Oct-07 0:51

TarDuk wrote:
System.Drawing.Image image = RetrieveImage(id, tname);

image.Save(Response.OutputStream, System.Drawing.Imaging.ImageFormat.Jpeg);

Assume you have the byte array in b[]. Response.BinaryWrite(b); ?

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

My Website | Ask smart questions

Re: Storing & retrieving swf file from sql server

Tarun Dudhatra29-Oct-07 0:58

Tarun Dudhatra

29-Oct-07 0:58

private System.Drawing.Image RetrieveImage(string id,string tname)
{
System.Drawing.Image image = null;
strcon = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"];
Con = new SqlConnection(strcon);
Con.Open();
Cmd = new SqlCommand("SELECT imgimage FROM latework where imgid='" + id + "'", Con);
Cmd.CommandType = CommandType.Text;
SqlDataReader Dr = Cmd.ExecuteReader();

if (Dr.Read())
{
byte[] imageData = (byte[])Dr[0];
MemoryStream memStream = new MemoryStream(imageData);
image = System.Drawing.Image.FromStream(memStream);
}
return image;
}

This is my code to retrive an Image ok now can u do something?
Thanks

Re: Storing &amp; retrieving swf file from sql server

N a v a n e e t h29-Oct-07 1:02

N a v a n e e t h

29-Oct-07 1:02

TarDuk wrote:
if (Dr.Read())
{
byte[] imageData = (byte[])Dr[0];
MemoryStream memStream = new MemoryStream(imageData);
image = System.Drawing.Image.FromStream(memStream);
}
return image;
}

Replace this with

byte[] imageData = (byte[])Dr[0];
Response.ContentType = //as you set
Response.BinaryWrite(imageData)

TarDuk wrote:
private System.Drawing.Image RetrieveImage(string id,string tname)

If this function is in your page, make it as void. If it is in a class, you won't get access to Response object until you pass it to the class

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

My Website | Ask smart questions

Re: Storing &amp; retrieving swf file from sql server

Tarun Dudhatra29-Oct-07 1:11

Tarun Dudhatra

29-Oct-07 1:11

Thanks a lot
N a v a n e e t h I will try with that code and tell u later ok thanks again.

Please if u can, solve my prob as quick as possible.

Tutul Biswas29-Oct-07 0:29

Tutul Biswas

29-Oct-07 0:29

All job is done in asp.net 2.0

I have a link in main page to open a popup window, in which I have a gridview filled with data from database. Now the prob is, how can I access the hole gridview from the popup to the main page, the main page is already opened. I want the popup to close as I want to go to the main page with gridview from the popup.

The popup is opened using javascript.

Regards
Tutul Biswas

Re: Please if u can, solve my prob as quick as possible.

InsDev29-Oct-07 0:37

InsDev

29-Oct-07 0:37

you want the gridview of the main page to popup . if yes just pass the condition as u fill the gridview on the main page and fill that same in popup.

Devjit Das

Re: Please if u can, solve my prob as quick as possible.

Imran Khan Pathan29-Oct-07 1:04

Imran Khan Pathan

29-Oct-07 1:04

Tutul Biswas wrote:
as I want to go to the main page with gridview

Take gridview in your hand and go to main page. Laugh | :laugh:

Tutul Biswas wrote:
how can I access the hole gridview from the popup to the main pag

No need to access hole gridview.
just store dataset in session and use in main page

bEst rEgard
pAthan

please don't forget to vote on the post that helped you.

Re: Please if u can, solve my prob as quick as possible.

Tutul Biswas30-Oct-07 2:29

Tutul Biswas

30-Oct-07 2:29

If I do so using response.redirect then the main page will open into popup.
But I want the popup will close and the gridview will transfer to main page.

Regards
Tutul Biswas

clear the datagrid value in asp.net [modified]

ps.srinivasan29-Oct-07 0:26

ps.srinivasan

29-Oct-07 0:26

hi friends
How to delete or clear the data grid value in asp.net,At the time of post Back

Re: clear the datagrid value in asp.net

John-ph29-Oct-07 0:37

John-ph

29-Oct-07 0:37

Do you mean that Datagird retains the Data during post-back which you don't want?

Regards
- J O H N -

Re: clear the datagrid value in asp.net

ps.srinivasan29-Oct-07 0:41

ps.srinivasan

29-Oct-07 0:41

yes frnd
thnx for advance

Re: clear the datagrid value in asp.net

John-ph29-Oct-07 0:54

John-ph

29-Oct-07 0:54

If the Viewstate is enabled then the DataGrid will persist the Data during postback. if you want to clear the DataGrid then set the Datasource property to Nothing and do a DataBind.

DataGrid.DataSource = Nothing<br />
DataGrid.DataBind()

Regards
- J O H N -

Re: clear the datagrid value in asp.net

ps.srinivasan29-Oct-07 1:03

ps.srinivasan

29-Oct-07 1:03

frnd
i wrote this code in form load
DataGrid1.DataSource = Nothing
DataGrid1.DataBind()

but not working.if i refresh the form the old data also added with new data.
plz give some other solution

Re: clear the datagrid value in asp.net

John-ph29-Oct-07 1:15

John-ph

29-Oct-07 1:15

I guess this is the only way to clear the DataGird. How is it possible to display the Old Data when you set the DataSource property to Nothing?. I guess there is something terribly wrong with your system. How about this alternative...

DataGrid1.Visible = False

If this alternate is also not suitable for you requirement then just put a breakpoint in each event and function in your page and do a step-wise execution and try to trace and fix the problem.

Regards
- J O H N -

Re: clear the datagrid value in asp.net

ps.srinivasan29-Oct-07 2:13

ps.srinivasan

29-Oct-07 2:13

hi frnd
DataGrid1.Visible = False
or
datagrid1.datasource = nothing
datagrid1.databind ()
these coding is working i not deny that, but if u refresh the form the old data also coming, ur coding is tempraverly hide the data not deleting the data, plz give some other solution.

Re: clear the datagrid value in asp.net

John-ph29-Oct-07 2:50

John-ph

29-Oct-07 2:50

I really couldn't get what exactly the problem is....

ps.srinivasan wrote:
the old data also coming

What do you mean by this? There is nothing called old data or new data in DataGrid. Whatever Data that you Bind to the DataGrid will be shown. Did you try to trace the Code?

ps.srinivasan wrote:
ur coding is tempraverly hide the data not deleting the data

Are you talking about page caching?

Regards
- J O H N -

Re: clear the datagrid value in asp.net

ps.srinivasan29-Oct-07 19:09

ps.srinivasan

29-Oct-07 19:09

many many thnx frnd
ur code is working
"datagrid1.datasource=nothing
datagrid1.databind()"
this code is working perfectly,i declared DATASET variable in global, so that time is not worked,that is mine mistake,thnx for replay,

Re: clear the datagrid value in asp.net

InsDev29-Oct-07 0:39

InsDev

29-Oct-07 0:39

Just refresh ur grid as the condition u like. u will immediately get ur desire result.

Devjit Das

Re: clear the datagrid value in asp.net

ps.srinivasan29-Oct-07 0:45

ps.srinivasan

29-Oct-07 0:45

sorry frnd i dont know how to refresh data grid in asp.net plz give idea.

Re: clear the datagrid value in asp.net

InsDev29-Oct-07 0:49

InsDev

29-Oct-07 0:49

Just use the condition which u bind with grid or use to delete grid row. which one u like or easy for u.

Devjit Das.

Roles

SreejithAchutan29-Oct-07 0:24

SreejithAchutan

29-Oct-07 0:24

creating permission to a particular role manager to access a page .the roles will be created by user and how he set to access a .aspx page using c#.that means in webcofig file we can set rol;es to acces a particular page to a role manager.if an afministrator creates a user and set permision to access a page.how is it possible

Problem on Page.User.Identity.Name

Pandiarajan R T29-Oct-07 0:12

Pandiarajan R T

29-Oct-07 0:12

i am not able to see the user id. When i debugged it Page.User.Identity.Name was returning null string.

What is actually the problem. What should i do to get rid of it.

Pandi

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