ASP.NET

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

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

Tarun Dudhatra29-Oct-07 0:44

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

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

Tarun Dudhatra29-Oct-07 0:58

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

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

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

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

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.

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

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

John-ph29-Oct-07 0:37

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 -

ps.srinivasan29-Oct-07 0:41

29-Oct-07 0:41

yes frnd
thnx for advance

John-ph29-Oct-07 0:54

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 -

ps.srinivasan29-Oct-07 1:03

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

John-ph29-Oct-07 1:15

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 -

ps.srinivasan29-Oct-07 2:13

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.

John-ph29-Oct-07 2:50

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 -

ps.srinivasan29-Oct-07 19:09

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,

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

ps.srinivasan29-Oct-07 0:45

29-Oct-07 0:45

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