|
Hi there,
I am a newt to IIS and ASP.net.
So, I just wanted to know if we can install IIS 6.0 on Windows XP professional.
Thank you.
|
|
|
|
|
Yes you can.
Go to Control panel
Add or Remove Programs
Click the left side bar Add remove windows components
Select the check box for IIS.
Then click Next and follow the prompts.
You may need to re-install asp.net after IIS is installed. I have had some problems before if asp.net is installed before IIS.
Hope that helps.
Ben
|
|
|
|
|
Hi thanks for the time spent.
But I don't have an IIS 6.0 server with me. Do you have any idea where I can download it from, because even a lot of googling hasn't helped. And how do we install ASP.NET. Is it different from the .Net framework we install.
I really appreciate the time spent on this.
Thank you.
|
|
|
|
|
Did you check the control panel add remove program and then add remove microsoft components?
IIS should be there. It might prompt you for a XP Professional install disk, but that is the easiest way to install IIS.
If you have already installed the .net framework that is fine. asp.net is the programming language that is in Visual studio. so you would need a visual studio install.
Hope that helps.
Ben
|
|
|
|
|
Rubbish - that installs 5.x - 6.0 is from Win Server 2k3....
"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox
|
|
|
|
|
You mean to say that there is no way to install an IIS 6.0 on an XP Pro.
And the only way to install IIS 6.0 is to install an Win 2003 Server?
|
|
|
|
|
Not that I or any of my co-workers have found!
IIRC, you can get hold of 6 in a desktop OS, but only under
Vista...it's something to do with the concept of app pools under 6.0 I believe...
"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox
|
|
|
|
|
Hi there!
Please help me in this!
The error message when I try to run the asp.net application from the IIS server is this.
Server Error in '/Test' Application.
--------------------------------------------------------------------------------
Failed to access IIS metabase.
Thanx for the help.
|
|
|
|
|
Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'
i received this error when i upload the database to server (i don't know that server have aspnetdb or no )
what is this error and if the aspnetdb dose not exist how can i do ?
Thanks
|
|
|
|
|
|
The above html element refreshes the entire page.
But I dont want the entire page to get refreshed but only the adRotator control to get refreshed frequently.
Help me out
|
|
|
|
|
put the adRotator in a speared page
then place this page in a original page inside an ifream tag
When you get mad...THINK twice that the only advice
Tamimi - Code
|
|
|
|
|
My problem is solved.
ThankYou
|
|
|
|
|
Hi All,
Is there any integration between Asp.net and Webfocus reporting. Please help me out in webfocus reporting with Asp.net 2.0.
- Arif
|
|
|
|
|
I am connecting to an Oracle database using an OleDbConnection. I am using DataReader objects to get query results. However, this limits me to only having one reader open at a time, which is a problem for one of the operations I am doing.
I have a table with hierarhical data (only 3 levels deep) that I would like to parse through in a depth-first search. Each row in the table in the database has a Name and a ParentName, and I'm doing something like this:
oCmd1 = New OleDbCommand( "Select Name from tblTree where parentName='_top'", oCxn )
oRdr1 = oCmd1.ExecuteReader()
While oRdr1.Read()
sName1 = oRdr1("Name")
oCmd2 = New OleDbCommand( "Select Name from tblTree where parentName='" & sName1 & "'", oCxn )
oRdr2 = oCmd2.ExecuteReader()
While oRdr2.Read()
' do the third level, you get the idea
End While
oRdr2.Close()
End While
oRdr1.Close()
The problem is, it won't let me use oRdr2 while oRdr1 is open; and I can't close oRdr1 because it is still in the middle of cycling through the top-level items.
SO, my question is this: What is the PREFERRED way of dealing with this?
The options seem to be:
1) create a new DB connection for each level in the hierarchy
2) move to a different kind of object (DataSet?), instead of a DataReader
3) ??????.... some other option I haven't thought of?
I don't know which approach would be best, or if there are other approaches I'm not thinking of. Any help or advice is greatly appreciated.
Also, I apologize if this question would be better suited to a different forum. Please just let me know, and I'll take it there.
Thanks!
--- Greg Stevens
|
|
|
|
|
Or option 3 use .net 2.0 where you can have multiple result sets open. I am guessing that probably isn't an option for you. So if you are stuck in .net 1.1 then I would go with option 1. Just have multiple connections. Since web apps use application pools as long as your connection string for each of the connection objects is the same you will use connection pooling. So your connections shouldn't get too out of control. If this data isn't going to change too much and isn't too big, I would think seriously of using caching to help out.
Hope that helps.
Ben
|
|
|
|
|
Thank you for your reply.
My main worry is that this process will be called every time each page is loaded by every user. Does opening and closing three simultaneous connections on every page read incur bad performance hits if there are a large number of users?
Also, you say "I would think seriously of using caching to help out" but I'm not sure that I understand what you mean. Can you give me a two-sentence summary, or point me in the direction of a website / reference where I could find out more?
Thanks again!
|
|
|
|
|
There is a Cache object, that is similar to the Session or Application object. In this case your only options would be application or cache if you want the data to be the same across sessions (users). If the data is completely static and will not change, then you might want to just put it in the Application object. Otherwise you can put it in the Cache.
Here is a Microsoft help on cache:
http://msdn2.microsoft.com/en-us/library/system.web.caching.cache.add.aspx[^]
Hope that helps.
Ben
|
|
|
|
|
That does help -- thank you very much!
|
|
|
|
|
You don't mention what version of Oracle you're using, but the newer versions (9i and 10g, for sure... I think 8i) have built-in SQL extensions for dealing with hierarchical data. If you were to take advantage of them, it looks as if you may be able to reduce your processing down to a single query. Here are a couple of resources to get started with: You may also wish to consider using the System.Data.OracleClient[^] for your connectivity, rather then using raw OleDB. The backing technology is the same, but the Oracle Client has been optimized for Oracle. Oracle also provides its own Oracle Data Provider for .NET[^], if you are more comfortable with that.
Finally, for performance and security reasons, you may wish to consider moving your query into the database as a stored procedure. This will allow the DBMS to compile and cache the execution plan for your query, rather then having to figure it out each time you execute the SQL.
Hope that helps.
--Jesse
"... the internet's just a big porn library with some useful articles stuck in." - Rob Rodi
|
|
|
|
|
Below is test code to replicate the problem. I trying to add form controls to an ArrayList. In LinkButton1_Click, two textbox controls are added to ArrayList. No problem. But when i break this code into two separate LinkButtons, only one textbox will ever be added to ArrayList when both link buttons are clicked. The last textbox added will overwrite the first one added. The ArrayList.Add should not behave like this. What is going on? How should i make this work?
To store they control i am using an ArrayList.
public partial class Builder_Generator : System.Web.UI.Page
{
ArrayList _controls = new ArrayList();
TextBox _textBox = null;
protected void LinkButton1_Click(object sender, EventArgs e)
{
_textBox = new TextBox();
_textBox.Text = "first";
_textBox.ID = "first_Textbox";
Form_PlaceHolder.Controls.Add(_textBox);
_textBox = new TextBox();
_textBox.Text = "second";
_textBox.ID = "second_Textbox";
Form_PlaceHolder.Controls.Add(_textBox);
}
protected void LinkButton2_Click(object sender, EventArgs e)
{
_textBox = new TextBox();
_textBox.Text = "first";
_textBox.ID = "first_Textbox";
_controls.Add(_textBox);
}
protected void LinkButton3_Click(object sender, EventArgs e)
{
_textBox = new TextBox();
_textBox.Text = "second";
_textBox.ID = "second_Textbox";
_controls.Add(_textBox);
}
}
|
|
|
|
|
Hi,can anyone suggest me the simplest way of sorting a datagrid
|
|
|
|
|
|
Hi,
we can sort the data grid on column. i saw this few days back in one article.
you have tp set the AllowSorting property of the DataGrid to True. This property changes all of the column header text to hyperlinks. A click on the header text hyperlink causes a post-back and a call to the OnSortCommand event handler.
In datagrid control creation u have to set these properties:
AllowSorting as "True" and OnsortCommand as "SortCommand_OnClick"
In the OnSortCommand event handler you simply need to specify how the data should be sorted, recreate the data source and bind the data to the DataGrid. Currently creating the data source and the data binding are done in the BindData() method, so really all you need to do is specify how the data should be sorted before calling the BindData() method. In other words, redefine the SQL statement. Since the SQL statement is a page-level variable you have access to it in the OnSortCommand event handler.
u can write the OnSortCommand event handler.
\\ Sub SortCommand_OnClick(Source As Object, E As DataGridSortCommandEventArgs)
_sqlStmt = _sqlStmt & " ORDER BY " & E.SortExpression
BindData()
End Sub \\
hope this will give you some idea.
Thanks,
Rahithi Sharma
If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
|
|
|
|
|
1.Hi pls place u r connection string in place of my con string.
2.<asp:datagrid id="DataGrid1" runat="server" allowsorting="True" pagesize="5">
<pagerstyle mode="NumericPages">
3.paste this code in codebehind..
imports system.data.sqlclient
Dim conObj As New SqlConnection
Dim adpObj As New SqlDataAdapter
Dim dsObj As New DataSet
Dim sort As String
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
If Not Page.IsPostBack Then
bindGrid()
If sort = "" Then
sort = "name"
End If
End If
End Sub
Sub bindGrid()
Try
conObj = New SqlConnection("Data Source=B4B-2F-323-CK26;user id=sa;password=sa;Database=TEST")
conObj.Open()
adpObj = New SqlDataAdapter("SELECT * FROM Login", conObj)
adpObj.Fill(dsObj, "Login")
Dim dt As DataTable = dsObj.Tables("Login")
Dim dv As DataView = New DataView(dt)
dv.Sort = sort
DataGrid1.DataSource = dv
DataGrid1.DataBind()
Catch ex As Exception
Response.Write(ex.ToString())
End Try
End Sub
Private Sub DataGrid1_SortCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridSortCommandEventArgs) Handles DataGrid1.SortCommand
sort = e.SortExpression
bindGrid()
End Sub
End Class
|
|
|
|