|
Hi Chris, thanks for answering. You said it can't be done but I've found the answer. The following code is what I have found
Dim PictureID As Integer = Convert.ToInt32(Request.QueryString("PictureID"))
'Connect to the database and bring back the image contents & MIME type for the specified picture
Using myConnection As New SqlConnection(ConfigurationManager.ConnectionStrings("ImageGalleryConnectionString").ConnectionString)
Const SQL As String = "SELECT [MIMEType], [ImageData] FROM [Pictures] WHERE [PictureID] = @PictureID"
Dim myCommand As New SqlCommand(SQL, myConnection)
myCommand.Parameters.AddWithValue("@PictureID", PictureID)
myConnection.Open()
Dim myReader As SqlDataReader = myCommand.ExecuteReader
If myReader.Read Then
Response.ContentType = myReader("MIMEType").ToString()
Response.BinaryWrite(myReader("ImageData"))
End If
myReader.Close()
myConnection.Close()
End Using
This is what i wanted to do, all I wanted was to retrieve mime type and binary file from the database dynamically. Now I just need to make it work with text doc and write the output to the browser.
-- modified at 17:39 Sunday 5th August, 2007
|
|
|
|
|
As per the requirement of my development i have to draw a bar chart from ASP.net data grid or any other control that binds data.Can anyone please suggest the code for the same.
Malay Mukherjee
|
|
|
|
|
You can't. You can draw a chart from the data source, the grid is another view of hte data. You can write your own code using SVG, or, more likely, GDI+. Or you can buy a library, like Dundas Charts, or look over the web for a free one.
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 )
|
|
|
|
|
As per the requirement of my development i have to export the data fetched from an SQL select statement to MS Excel Worksheet through asp.net2.0. Can anyone please suggest the code for the same.
Malay Mukherjee
|
|
|
|
|
ASP.NET is irrelevant, as your web tier won't do this. So, it's all done by your codebehind, and the code is the same either way. The easiest way to put data in Excel is to write it as a CSV file ( comma seperated values ). Excel will turn these into columns. Otherwise, you can interop with Excel to do something more fancy.
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 )
|
|
|
|
|
Hello All, Can someone help me with this:
I need to convert http URL of my website page to https (to achieve secure payment pages), Can you please suggest what i need to add to web.config to achieve this functionality. Thanks
Kaliem
|
|
|
|
|
You need to configure IIS for this ( just google, the main thing is you need to create a dummy certificate for testing ). your other issue is, you must always use full, not relative, URLs to navigate away from the HTTPS part of your site, otherwise, it will stay HTTPS
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 )
|
|
|
|
|
Hi there
I would like to use a expanding panel on my page which looks just like the tabs at the top of mozilla or IE7, except that it runs down the page instead of across the top, and when a tab is selected it opens left to right, as if coming out of the left side of the screen. Preferably when it opens it should give a similar effect to the AJAX collapsable panel with a fade smooth fade in and out, or for those of you who have seen the XBOX360 interfaces tabbing system, then similar to that. The AJAX panel unfortunately only moves up and down. Does anyone have any code which they have used before to accomplish something similar or have a link to a tool which can provide this feature???
Any help would be greatly appreciated as I am out of ideas of where to look, or what to search for.
Thanks...
Dev
|
|
|
|
|
Good Evening sir's...
sir im using two dropdownlists with CascadingDropDown .Everything is working fine but after i changed slectedIndex in first dropdownlist ,data is getting populated to 2nd dropdownlist but it is staying in disable mode .. How can i make it to enable maode ... please help me
|
|
|
|
|
Hi
I am developing an web site in ASP.NET using c#.
Site run fine when number of users are limited say 9 to 10.
When we open 3 browser from 4 to 5 pc for testing purpose then in some browser it some css files or js doesn't get downloaded.Also it gives Time Error for Session means get Session get killed.
If there is any setting IIS or in Web.config file to increase connection pooling,please reply.
Swapnil Bhavsar
|
|
|
|
|
Sounds like you have bandwidth issues. So long as you're not using SQL Server Express Edition, there's no generic reason for you to have this issue that can be solved in code or in your config.
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 )
|
|
|
|
|
hi everybody, first offall i would like to thank evry body in this group.
i have a problem in java scrpt.
now i am developing a web application which is having three froms lets say
form1.
form2.
and form3
and java sceipt file named jscript1
i have use one java script for validation the input.
i have written to the coding in jave script.and also it is waorking but only for form1. not for other two forms.
can u tell how can i acess the same script in other two forms inorder to validate the input..
biswa007
|
|
|
|
|
Just by including the js in all the forms.
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 )
|
|
|
|
|
Make sure you include the javascript file in your page, which I guess you already have done so...
Then.. in your jscript1 function. When you do the validaction to check the input, did you pass in the form name?
Example, if you have such code: form1.txtTextBox.value = "xxx"; Then you need to make sure in your form2 and form3, you have the same form name, "form1".
Eliz.K
http://www.oin1.com/Technical/JavaScript/CommonlyUsedFunction.htm
|
|
|
|
|
Hello All,
I am trying to integrate blogs in my application but iam getting an error
The error what iam getting is mentioned below
It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS.
Please help me in fixing this error
Thanks & Regards
Taha Ali
|
|
|
|
|
It means you have an asp.net app in a subdirectory, and like the error says, you need to configure a virtual directory at that subdir level in IIS
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 )
|
|
|
|
|
Hi,
Case:
1) Datagrid Bound columns generated at runtime and populated from the dataset.
2) Datagrid contains a select button. When the select button is pressed a new report is generated.
Language: Visual Studio 2.0, ASP.Net, C#
Problem: During the first page_load grid is populated properly but when it is postback Datagrids items and cells are not visible in the select buttons itemcommand method.
By referring the articles in the google i came to know that i should not be using page_load, instead i should call the method in the initializecomponent() , but since i am working on .Net 2.0 it does not have initializecomponent method. I have also tried PreLoad and its not working.
Please find below my sample code so that u get a better idea.
--Sample Code Starts Here
protected void Page_PreLoad(object sender, EventArgs e)
{
if (!IsPostBack)
{ getdata(); }
.....
}
public virtual void grdvwCheckbox_ItemCommand(object s, DataGridCommandEventArgs e)
{
if (e.CommandName == "Select")
{
e.Item.BackColor = System.Drawing.Color.Wheat;
DataGrid dg = (DataGrid) s;
.........
}
}
public void getdata()
{
DataSet ds = new DataSet();
string rptDetails;
rptDetails = txtRptDetails.Text;
GridReports objBO = new GridReports();
ds = (DataSet)objBO.GridData(rptDetails);
grdvwCheckbox.AutoGenerateColumns = false;
foreach (DataColumn c in ds.Tables[0].Columns)
{
grdvwCheckbox.Columns.Add(CreateBoundColumns(c));
}
...................
}
--Sample Code Ends Here
Hope this helps u to help me.
If u have any working sample code in .Net 2.0 where Bound columns are created at runtime and ItemCommand event is fired then please forward it to me.
A quick reply will be really helpful.
Please feel free to revert in case of any clarification.
Thanks!
|
|
|
|
|
If it is not working on preload, try Init
protected void Page_Init(object sender, EventArgs e)
{
Initialize your control here
}
|
|
|
|
|
Thanks for your reply,
It is not working with Init. If u have any working sample code in .Net 2.0 where Bound columns
are created at runtime and ItemCommand event is fired then it might help.
Regards,
Anees
|
|
|
|
|
Anees Mitha wrote: It is not working with Init.
It will if you remove postback checking. Remove !IsPostBack when calling getData();
|
|
|
|
|
Great show sir, it does work. Thanks.
But the only problem now is that for every ItemCommand event it will make a round to the database which will be very costly in my case where the reports are huge. So apart from this is there any other way round to achieve the same results.
Anyways i really appreciate your help and support. Thanks a ton.
Regards,
Anees
|
|
|
|
|
Anees Mitha wrote: it will make a round to the database which will be very costly in my case
You can cache the dataset. This will avoid round trip to server
|
|
|
|
|
|
I created a class which checks session and redirects to login page. My class looks like this. This class inherits Page class to get access to session object.
public class CAuthentication:System.Web.UI.page
{
public CAuthentication()
{
if ( Session["login"] == null )
Response.Redirect("expired.aspx");
}
}
My ASPX.CS looks like
public partial class MyPage:CAuthentication
{
}
This is not working. I am getting error "session can't be used inside a class". What is wrong here ? Normally codebehind file used to inherit System.Web.UI.Page, Instead of this I inherited this in my CAuthentication class. Where I am going wrong ?
|
|
|
|
|
Please check it with HttpContext.Current.Session["login"].
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
