|
i am using sql server 2005 express and i have one web site which is i have published and installed on machine but when connecting to sql server 2005 express getting error login failed mycomname/ASPNet user why not taking user name insted of aspnet how do i login my con string is as follws
<add name="EMSConnectionString" connectionString="Data Source=.\sqlexpress ;Initial Catalog=EMS;intigrated security=true" providerName="System.Data.SqlClient"/>
|
|
|
|
|
nikhil1234 wrote: why not taking user name insted of aspnet how do i login my con string is as follws
<add name="EMSConnectionString" connectionstring="Data Source=.\sqlexpress ;Initial Catalog=EMS;intigrated security=true" providername="System.Data.SqlClient">
Your web application is running in the context of the ASPNET user. Therefore, when you use integrated security you will log in with the credentials of the user that your process is running as. This is the correct functionality.
You must grant the appropriate access to the ASPNET user to the database.
Possibly the reason you did not see this when you were developing the web site is that Visual Studio has its own built in Web Server that uses your credentials. When you deploy to IIS you use the credentials IIS uses.
|
|
|
|
|
intigrated security=true
integrated security=true
Try that.
var question = (_2b || !(_2b));
|
|
|
|
|
It is true by default, so that typo would likely have been ignored.
|
|
|
|
|
Fair enough, I probably should have read the question first, but that typo kinda blinded me straight on.
And thanks, I didn't know Integrated security was true by default.
var question = (_2b || !(_2b));
|
|
|
|
|
hi
function window.onunload()
{
if (window.event.clientX < 0 && window.event.clientY < 0)
{
//call Session.Abandon()
}
}
in above funcion i am check browser closed button is press or not when button is press i want to close the session just like a Session.Abandon()(server side function). and second question is my project above 200 web form are there and every page redirect to another page so how can i used above code only single time
|
|
|
|
|
You can do one thing
if(window.event.clientX < 0 && window.event.clientY <0)
{
window.open("CloseSession.aspx", "OpenWindow_Close_Session",'left=12000,top=1200,width=10,height=1');
}
In CloseSession.aspx Page Load Do the server side task and make it self.Close();
protected void Page_Load(object sender, EventArgs e)
{
Session.Abandon();
string strPopupScript = "<script language="javascript">self.close();</script>";
Page.ClientScript.RegisterStartupScript(typeof(Page), "PopUpScript", strPopupScript);
}
Hope this will help you.
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
but sir i cannot put this code my above 200 web page
|
|
|
|
|
So you don't have master page ?
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
you don't have to. Another alternative is create web handler page (ashx page) put the functionality Abhijit provided in the ProcessRequest call it using ajax.
Yusuf
Oh didn't you notice, analogous to square roots, they recently introduced rectangular, circular, and diamond roots to determine the size of the corresponding shapes when given the area. Luc Pattyn[^]
|
|
|
|
|
Yup Excelent... That is the best option, if you don't have the master page you can simply do it using handler other wise write the same in master page. 
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
I am facing a unique problem (looks unique to me at least). I have a dropdown whose auto-postback is enabled. User can select a value from the dropdown to go to another page. But when the user comes back to original page by clicking the back button on the browser and clicks any button then on the post-back caused by the button, first the "SelectedIndexChanged" event handler of that dropdown is called then the "Click" event handler of this button is called. Hope I have explained the problem clearly.
Can anyone tell me what's going wrong and how to solve the issue?
|
|
|
|
|
Just put the code that you have written for redirect to different page of Dropdownlist SelectedIndexChanged.
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
I did the same but it is not working......looks like the browser is remembering the previous state of the page and so is causing the previous event to be raised in addition the present event..... I think I have to take help of javascript. Thank for the reply
|
|
|
|
|
om pr wrote: I did the same but it is not working....
 But I didn't suggested you to do any thing. I have just asked you to put those selected index change code.
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
Can you be a bit more elaborate. I did not understand what you want to suggest! 
|
|
|
|
|
om pr wrote: Can anyone tell me what's going wrong and how to solve the issue?
I suspect that what is happening is that when you go back the browser remembers the state of the controls when you originally left the page and sets them to those values. However, this time the value change for the drop down does not trigger a post back.
When you press the button the postback is triggered. The server then compares what is in the viewstate with what the controls now look like and raise events for any changes. Because it sees two changes (the drop down and the button click) those events are raised.
A possible route to solving the issue is to turn off the viewstate (which also means you won't get change events, although you will still get button click events) and detect the drop down change yourself rather than rely on ASP.NET.
|
|
|
|
|
Thanks for the reply Colin, I tried all possible options including disabling the viewstate as suggested by you but it all failed. I just managed to solve the issue with the help of javascript. Instead of sending the user to the next page via Response.Redirect on the index change of the dropdown, I am now doing the same with the help of simple javascript i.e. window.location.href. Thanks again for the reply, appreciate it!
|
|
|
|
|
What happens if the user has disabled javascript?
|
|
|
|
|
I our case this will not happen because whole site is javascript dependent. If it is disabled then nothing will work and moreover the site is for Intranet use and user of this site will not have the flexibility to turn the javascript setting of the browser on or off at will.
But this question still remains. What if the site were for general public on the Internet? In that case what could be the solution if even javascript could not solve it? Any idea!!
|
|
|
|
|
Is this happening only one one machine? Can you reproduce it on another machine.
Today, I spent 30 minutes on non-issue with my boss's machine. The browser had old cached copy and clearing the cache *fixed* the issue.
Yusuf
Oh didn't you notice, analogous to square roots, they recently introduced rectangular, circular, and diamond roots to determine the size of the corresponding shapes when given the area. Luc Pattyn[^]
|
|
|
|
|
<%@ Page Language="C#" MasterPageFile="~/Login.master" AutoEventWireup="true"
CodeFile="Login.aspx.cs" Inherits="Login" Title="Login"%>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
<table background="images\login.jpg" style="width:471px; height:350px; margin-top:60px; margin-left:auto; margin-right:auto; border-width:thick; border-style:solid; border-color:White;" border="3">
<tr><td>
<asp:TextBox class="gradient" id="username" runat="server" />
<input class="gradient" type="text" name="T9" size="20" />
<asp:TextBox class="gradient1" id="password" runat="server" TextMode="Password" />
<p><asp:ImageButton class="loginbutton" imageurl="images/signin.jpg"
ID="submitButton" Style =" left:685px; top:272px; position:absolute"
runat="server" Text="Login"
OnClick="LoginUser" /></p>
</td></tr>
</table>
</asp:Content>
I have written this code on my Login Page.
But on run mode this imagebutton,Textbox position is changing automatically.
What is wrong in my code?
Thanks,
|
|
|
|
|
The problem is with Layout of you application. If you have some times then just go through with GRIDLayout and FromLayout Desing of ASP.NET.
You can use proper CSS to Fix Them.
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
.loginbutton
{
border-style: none;
border-color: inherit;
border-width: 0;
height: 23px;
width: 88px;
position: fixed;
padding-top:2px;
top: 204px;
left: 676px;
}
I am using CSS...But same problem...
modified on Tuesday, April 14, 2009 8:33 AM
|
|
|
|
|
Hi all,
How I can convert this code to a WebMethod in WebService?
This code is here:
Protected Sub Submit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Submit.Click
Dim con As SqlConnection = New SqlConnection(WebConfigurationManager.ConnectionStrings("Articles").ConnectionString)
Dim cmd As SqlCommand = New SqlCommand("SELECT Title, Content FROM tblArticle", con)
con.Open()
Accordion1.DataSource = cmd.ExecuteReader
Accordion1.DataBind()
con.Close()
End Sub
I try to convert this code to webmethod But I couldn't convert it to a WebMethod for WebService and use it in Application.
How I can do this work?
Please help me,
Thank you
Hoda
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
