ASP.NET

Re: Displaying Binary data with Response.Write() [modified]

3-Aug-07 22:24

What is your question ? Why don't you look up a column to read your binary data ?

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

ASPnoob3-Aug-07 22:54

ASPnoob

3-Aug-07 22:54

Basically I'm doing what you've suggested last week. First I stored the mime types of each binary file in a field called DocType in my database. So if an image file is stored in the Resumes field it would have a mime type of "image/gif" etc. Then after I connect to the database I use the datareader to read the data then put the data into a byte array. Then I use the following two lines to determine the name of the file to be displayed and to determine its content type.

'Resumes is the field in the database table that holds the documents
               Response.AddHeader("Content-Disposition", "attachment;filename=Resumes")

               'DocType is the field that holds the mime types
               Response.ContentType = DirectCast(AD("DocType"), String)

I have a typo in my code and its "filename=ResType" I've already changed that to Resume. Don't you run away after giving just a vague response Christian 'cause I really need your help lol. When a list item is selected its suppose to show a file but its not working, I'm very frustrated right now. Thanks for replying

-- modified at 5:29 Saturday 4th August, 2007

Re: Displaying Binary data with Response.Write()

Christian Graus4-Aug-07 0:45

Out of memory or system resources problem

4-Aug-07 0:45

Yeah, but when you fille the buffer variable, you don't use a column name to get to the data in question, you just do a read on the row itself.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

pjc*3-Aug-07 22:14

pjc*

3-Aug-07 22:14

Hi,

I have made a small application which process Mail Items (Notes Items) and save its properties in database. I have used outlook object model.It is working fine but for one message it gives an error as below.

"Cannot open this item.Out of memory or system resources. Close some windows or programs and try again."

Even this message also can't be open in outlook. I don't want this error comes while processing.So I don't want to process this message from my application. Is there any property of the message from which I can detect that it can't be processed? If any one knows please reply.

Thanks,
Pavan

Image gallery

Vipin.d3-Aug-07 21:28

3-Aug-07 21:28

hi,
I am using MS .NET 1.1
i want to create an image gallery ..

which control should i use to do this??

means i want to show 5 images in first row and next 5 in second and so on...

All I ever wanted is what others have....
CrazySanker

Christian Graus3-Aug-07 21:30

3-Aug-07 21:30

I'd just create a base control, have a collection of images, and draw them myself.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Vipin.d3-Aug-07 22:37

3-Aug-07 22:37

hi ,
Thanx for ur reply
I know, how to create a custome control.I created and used it in .net 2.0 .
But this is first time time I am trying in .NET 1.0.Here a use a class to create a custome control and try to register it in my web page.

But I am failed to register it.

I used this line of code to register in my web page

<br />
<%@ Register TagPrefix="Mcntrl" Namespace="comedia.MediaPlayerControl">

but i didnt get this control inside my body tag.

i tried like this

<br />
  <Mcntrl:MediaPlayerControl ID="MyMediaPlayer" runat="server"> </Mcntrl:MediaPlayerControl><br />

but it show error creating control in design view.

wat should i do.
There is no compliation error.
And I created it in .Net 2.0 and it works Fine.

Expect ur help or any links.
Thankx

All I ever wanted is what others have....
CrazySanker

Christian Graus4-Aug-07 0:44

4-Aug-07 0:44

OK, sorry, I didn't spot that this was the ASP.NET forum. A repeater is the way to do this. You can use a repeater to build a control that builds a table, and that adds the tr tag for a new row after a specific number of images. Of course, they need to exist as files and then you can show them in IMG tags.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Vipin.d4-Aug-07 1:25

4-Aug-07 1:25

Hi,
I use a datagrid .the code is look like..

<br />
<br />
	<asp:TemplateColumn><br />
																								<ItemStyle HorizontalAlign="Center" Width="10%" VerticalAlign="Top"></ItemStyle><br />
																								<ItemTemplate><br />
																									<asp:Image Width="70" Height="70" ImageUrl='<%#ShowImage(Convert.ToString(DataBinder.Eval(Container.DataItem, "EmployeeImage").ToString() ))%>' Runat=server ID="Image1"/><br />
																								</ItemTemplate><br />
																							</asp:TemplateColumn><br />
																							<asp:TemplateColumn HeaderText=" Name And Designation"><br />
																								<HeaderStyle HorizontalAlign="Center"></HeaderStyle><br />
																								<ItemStyle Font-Size="8pt" HorizontalAlign="Justify" Width="38%" VerticalAlign="Top" BackColor="#FFFFCC"></ItemStyle><br />
																								<ItemTemplate><br />
																									<br />
																										<%#DataBinder.Eval(Container.DataItem, "EmployeeName")%><br />
																									<br />
																									<br><br />
																									<%#DataBinder.Eval(Container.DataItem, "Designation")%><br />
																									<br><br />
																									<%#DataBinder.Eval(Container.DataItem, "EmailAddress")%><br />
																									<br><br />
																									Mob: <%#DataBinder.Eval(Container.DataItem, "MobileNo")%><br />
																								</ItemTemplate><br />
																							</asp:TemplateColumn><br />
<br />

In repeater, i draw a table in item template.. but how i fix after five image it ll go to next row..
in rpeater it will gro horizontally..

can you help me???

All I ever wanted is what others have....
CrazySanker

sulabh20203-Aug-07 21:47

3-Aug-07 21:47

Hi buddy,
if u aware of Grid viw control than its the best thing to disply the images as u want.
Try and if u face problem i m the solution

Hello Forum
Always be in touch to help about the topic ASP.NET

Vipin.d3-Aug-07 22:40

3-Aug-07 22:40

Hi Friend,

Thankx for ur reply.
I am not sure, is it Grid view control is available in .NET 1.0??

All I ever wanted is what others have....
CrazySanker

Christian Graus4-Aug-07 0:46

4-Aug-07 0:46

Nope. A DataGrid is, but you'd need five images per row to make that work. A repeater is better.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Vipin.d4-Aug-07 2:45

4-Aug-07 2:45

hi ,
Now I got the trick
Thank You very much

All I ever wanted is what others have....
CrazySanker

Database Connectivity !!

shweta@syscom3-Aug-07 20:23

shweta@syscom

3-Aug-07 20:23

Hi,

I am using Visual studio 2005 and I want database connectivity.
I tried connectin to SQL Server 2005 but was unable to do so. I even tried connectin to MS Acces but was not able to do so.

Please let me know how to connect to database using ASP.NET(C#) 2.0.

Thanks a lot!! Frown | :(

SHWETA!!

Christian Graus3-Aug-07 21:20

Re: Database Connectivity !! [modified]

3-Aug-07 21:20

You say you tried, what did you try ? There are hundreds of samples online showing how to connect to a DB, we need to know what you tried, and what went wrong, to give you more focused help than you can get from a google search.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

manowj3-Aug-07 21:21

manowj

3-Aug-07 21:21

Hi,

Try this.

In Web.config file
<appSettings>
<add key="conn" value="Server=<ServerName>;Integrated Security=no;User ID=;PWD=;database=" />
</appSettings>

In Code-behind File

using System.Data.SqlClient;
string ConnectionString =System.Configuration.ConfigurationSettings.AppSettings["conn"];
SqlConnection Sconn=new SqlConnection(ConnectionString);
Sconn.Open();

-- modified at 3:42 Saturday 4th August, 2007

Regards,
Manowj

Christian Graus3-Aug-07 21:30

Re: Database Connectivity !! [modified]

3-Aug-07 21:30

I'm guessing that may work if using the default DB on the same machine. Perhaps.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

sulabh20203-Aug-07 21:52

3-Aug-07 21:52

Hi shweta, well what i guess abou you is , u r new to this field.
may i ask u that r u working for noida branch.

well this is ur ans for connectivity.
string connect= "Server=Server_path;Database=ABC;User=user;Password=Password";

SqlConnection con = new SqlConnection(connect);

try it and make me know.

Hello Forum
Always be in touch to help about the topic ASP.NET

Christian Graus3-Aug-07 22:01

3-Aug-07 22:01

Why is your connection string not in resources ? Why do you create two connection objects in this code ?

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

sulabh20203-Aug-07 22:07

3-Aug-07 22:07

plz look the code properly than question.

I have taken one connection object
and another a simple strin to pass on this object as credentials of server where to connected to.

Hello Forum
Always be in touch to help about the topic ASP.NET

Christian Graus3-Aug-07 22:22

3-Aug-07 22:22

OK, so long as you're asking

public SqlConnection con = new SqlConnection();
string connect= "Server=Server_path;Database=ABC;User=userassword=Password";

con = new SqlConnection(connect);

I assume that public means that con is a member variable. Otherwise, it's an error.

You create a new object at the point of declaring the variable.

You assign a string to the connection string, although you don't expose it in any way ( which is not wise )

Then you use this string to create a new connection object ( your second ), meaning that the first one is never used, and if this is a member variable, as it seems to be, it means that you have a member object, but you recreate it, every time you use it.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

sulabh20203-Aug-07 22:37

3-Aug-07 22:37

Also we can use our common sense while declaring the variables.

What i ans for the connectin doesnt mean that this is the exact and only ans for this post, its a Hint of doing.

And one who needs toimplement this can use its little mind according to its need.

For ur graet information i always use this as staic and defined under one class, so every time u have to declare the connection string.

Hello Forum
Always be in touch to help about the topic ASP.NET

Christian Graus3-Aug-07 22:47

3-Aug-07 22:47

sulabh2020 wrote:
What i ans for the connectin doesnt mean that this is the exact and only ans for this post, its a Hint of doing.

OK, well, I pointed out some bad practises in your code, you rejected the claim. It seems that you accept it now ?

sulabh2020 wrote:
so every time u have to declare the connection string.

It is always better to expose your connection string in a config file.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )