|
Are you looking to delete both the data and the structure on the SQL server?
If so, I believe you want the "DROP TABLE" SQL command.
|
|
|
|
|
drop table is used in mssql....but i want to do in codebehind file
|
|
|
|
|
I'm learning MVC.
So far I have customized the default sample app.
One thing that leave me baffled is...
In the samples app there 2 web config!!
~/web.config
~/Views/web.config
WTF?
Why 2? Which one does what? What's the point?
|
|
|
|
|
Super Lloyd wrote: In the samples app there 2 web config!!
~/web.config
~/Views/web.config
First thing, you can have multiple config files at different levels. One in root folder and one in other branch folder is perfectly Ok. At times, it is needed for folder configuration.
Out here, Views config is to configure views. It is there to block direct access to the view aspx pages that are supposed to be served only through controllers.
|
|
|
|
|
Thanks for the clarifications! 
|
|
|
|
|
|
Hi,
Currently working with virtual path provider class in loading a whole website from database, and off course you cannot replace the web.config as a rule. my problem is how could i load or move my application settings to the web.config?
|
|
|
|
|
So I have a program that was written in visual studio and goes through vb c# then to fortran to calculate values. I am trying to get this to run online and running into problems.
I first tried asp.net in vb where I created a new project and referenced the DLL's that were created by the original code, which only worked on the computer the original code was written on and would fail on my computer during the fortran transistion.
Stepping through the code did not solve anything either as when it cycled through the fortran code it would get to a certain part and fail. It gave me a chance to look at the disassembly because there was no actual error message and it had a file path in the problem area of the disassembly.
I have attached images of the problems I was getting during trying to solve this.
This error message appeared after running the asp.net program the first time before the browser popped up
http://i.imgur.com/kfUVKw7.jpg[^]
This error message appears after I have entered all the values in the input form and they get submitted to the code.
http://i.imgur.com/yaau5At.jpg[^]
I am wondering if it is an pathing error based from the second picture as the actual asp.net program was in my C:\users folder but the source file is saying C:\Data(which was the file structure for the computer the original code was written on) when it shouldn't need to go to C:\Data if all of the code is complied into dlls that are added as references.
I am now trying to implement it into python but am not getting as far, so if someone could help me out with the asp.net problem or have another way that this can be put online that would be greatly appreciated and I can also supply more information if it is needed.
|
|
|
|
|
Some comments on the ASP.NET error:
- Don't use
Catch ex As Exception; only catch the exceptions you're able to handle. - Don't use
Throw New Exception(...); always use a more specific exception type.
For example: Throw New InvalidOperationException(...). - If you're catching an exception and throwing a new exception, always pass the original exception to the
innerException parameter of the new exception. This will preserve the information about the original exception, which will make it much easier to debug.
Throw New InvalidOperationException(..., ex)
At the moment, all we know is that something within or called by your setPressureTemperature method has thrown an exception; we have no way of knowing what that exception was. - Once you've updated the code to pass the inner exception through, run your code again and look in the application event log. The full details of the exception should be logged there.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
I am building a website in which I need to show the price of items in different currencies depending on the country chosen by the user.The price has to be dynamically updated daily based on the exchange rate. How do I go about doing this in ASP.NET?
|
|
|
|
|
Deepa4 wrote: I need to show the price of items in different currencies depending on the country chosen by the user.
This suggests you to have a dropdown where user can select country and thus currency.
Based on the dropdown selection, get the latest data, convert anything that needs to be based on currency multiplier and then use the modified data as input for the page display.
Try out.
|
|
|
|
|
Hi,
Actually,I'm not using a dropdown list.The website is an international one in which there are different home pages for different countries.So,I want to show the images and prices of different watches on the website and the price should be updated dynamically depending on the exchange rate.So,how do I get the exchange rate values to do such a dynamic update?
|
|
|
|
|
Deepa4 wrote: The website is an international one in which there are different home pages for different countries.
Even then, there must be something that is driving the localization. Dropdown is just a way to know what country/currency. Whichever way you are chaning your homepage, based on the same paramter your data should be changed/driven.
|
|
|
|
|
|
I think you are looking to get the most recent exchange rate.
Check out: http://www.webservicex.net/ws/WSDetails.aspx?CATID=2&WSID=10[^]
You could write a small program that would invoke this webservice for the currencies you desire and store those rates in a lookup table which your drop-down list would be bound.
Good luck.
|
|
|
|
|
Hi guys,
I am getting a problem one of my web site. My site having login screen, user should login to do operations. so this site automatically time out on 20 min. because ISS ideal time default 20 min as i read in one of the article, and i got solution to make it '0' to never expire, but still my session expire on 20 min.
And another solution i have to make session state =60/what ever time i required but this is also not helping, me.
So please guide me the solution
How to make session values alive still user logout.
Thanks and regards
Vishwa
|
|
|
|
|
VishwaKL wrote: How to make session values alive still user logout.
Not advisable as you will be blocking sever memory and can be very bad when multiple people connect.
VishwaKL wrote: make it '0' to never expire, but still my session expire on 20 min
Session timeout is set in Web.Config file. Default is 20 min. Change it to as per need there and will be used by IIS. You can also have FormsAuthentication timeout if you are using FormsAuthentication.
Following is sample change in Web.Config file:
<system.web>
<authentication mode="Forms">
<forms timeout="55"/>
</authentication>
<sessionState timeout="60" />
</system.web>
|
|
|
|
|
I have a variable that is declared in a user control. It is the value of a drop down list in the user control. When I try to use it in an If statement on an aspx page it says that the variable is not declared. Is there a way to declare the variable on the aspx page or make it recognize that it is declared on the user control page?
I'm calling the code at the top of the aspx page
<%@ Register src="pType.ascx" tagname="pType" tagprefix="uc2" %>
I'm using the if statement
<%If pt.SelectedValue = "1" Then%>
\\do things
<%End If%>
In the control pt is defined by
<asp:dropdownlist id="pt" runat="server">
Thank you!
|
|
|
|
|
Hi,
have you tried like this.
say you have used the user control like below in aspx page.
<uc2:pType ID="pType1" runat="server" />
so, in your code behind of the aspx page,
dim pt as DropDownList = CType(pType1.FindControl("pt"), DropDownList)
If Not pt IsNothing Then
If pt.SelectedValue = "1" Then
End If
End If
hope it helps
Vande Matharam - Jai Hind
|
|
|
|
|
What do you want to do? You can always tie up the dropdown onchange (client side) or selectedchange (server) events to check the value and do some work.
|
|
|
|
|
I have a list of session ID
Session_Start
<pre lang="c#"> public static void Management_SessionUserDelete(string UserID)
{
System.Data.DataTable dt = (System.Data.DataTable)System.Web.HttpContext.Current.Cache["SesionList"];
for (int i = 0; i < dt.Rows.Count; i++)
{
if (UserID == dt.Rows[i]["UserID"].ToString())
{
System.Web.HttpContext.Current.Session.Remove(dt.Rows[i]["SessionID"].ToString());
dt.Rows[i].Delete();
break;
}
}
dt.AcceptChanges();
System.Web.HttpContext.Current.Cache["SesionList"] = dt;
}</pre>
Can be removed from the authentication code؟
--------------------------------------
Information session on how to get id
thanks
هـر جا چراغی روشنه از ترس تنها بودنه ای ترس تنهایی من ، اینجا چراغی روشنه
|
|
|
|
|
Your question does not make much sense. Can you please edit/rephrase and share more on what are you trying to do and where exactly are you stuck?
|
|
|
|
|
<pre lang="c#"> private static DataTable Management_DataTable()
{
System.Data.DataTable dt = new System.Data.DataTable();
dt.Columns.Add("SessionID", typeof(string));
dt.Columns.Add("UserID", typeof(string));
dt.AcceptChanges();
System.Web.HttpContext.Current.Cache["SesionList"] = dt;
return dt;
}
public static DataTable Management_SesionList()
{
try
{
if (((System.Data.DataTable)System.Web.HttpContext.Current.Cache["SesionList"]).Rows.Count == 0)
{
return Management_DataTable();
}
else
{
return (System.Data.DataTable)System.Web.HttpContext.Current.Cache["SesionList"];
}
}
catch
{
return Management_DataTable();
}
}
public static DataTable Management_SessionAdd(string SessionID)
{
if (Management_SesionList().Rows.Count == 0)
Management_SesionList();
System.Data.DataTable dt = (System.Data.DataTable)System.Web.HttpContext.Current.Cache["SesionList"];
for (int i = 0; i < dt.Rows.Count; i++)
{
if (System.Web.HttpContext.Current.Session.SessionID.ToString() == dt.Rows[i]["SessionID"].ToString())
{
return dt;
}
}
DataRow dr = dt.NewRow();
dr["SessionID"] = SessionID;
dr["UserID"] = "Null";
dt.Rows.Add(dr);
dt.AcceptChanges();
System.Web.HttpContext.Current.Cache["SesionList"] = dt;
return dt;
}
public static DataTable Management_SessionUserAdd(string UserID)
{
if (Management_SesionList().Rows.Count == 0)
Management_SesionList();
System.Data.DataTable dt = (System.Data.DataTable)System.Web.HttpContext.Current.Cache["SesionList"];
for (int i = 0; i < dt.Rows.Count; i++)
{
if (System.Web.HttpContext.Current.Session.SessionID.ToString() == dt.Rows[i]["SessionID"].ToString())
{
dt.Rows[i]["SessionID"] = System.Web.HttpContext.Current.Session.SessionID.ToString();
dt.Rows[i]["UserID"] = UserID;
dt.AcceptChanges();
break;
}
}
System.Web.HttpContext.Current.Cache["SesionList"] = dt;
return dt;
}
public static void Management_SessionUserDelete(string UserID)
{
System.Data.DataTable dt = (System.Data.DataTable)System.Web.HttpContext.Current.Cache["SesionList"];
for (int i = 0; i < dt.Rows.Count; i++)
{
if (UserID == dt.Rows[i]["UserID"].ToString())
{
System.Web.HttpContext.Current.Session.Remove(dt.Rows[i]["SessionID"].ToString());
dt.Rows[i].Delete();
break;
}
}
dt.AcceptChanges();
System.Web.HttpContext.Current.Cache["SesionList"] = dt;
}</pre>
How can I delete the entire session
I save my session in a datatable
هـر جا چراغی روشنه از ترس تنها بودنه ای ترس تنهایی من ، اینجا چراغی روشنه
|
|
|
|
|
<asp:Content ID="Content2" ContentPlaceHolderID="mainContent" runat="server">
<center>
<script type="text/javascript">
function EnableUpload() {
if (document.getElementById("<%=txtfirstname.ClientID %>").value != "" && document.getElementById("<%=txtlastname.ClientID %>").value != "" && document.getElementById("<%=txtemailid.ClientID %>").value != "" && document.getElementById("<%=txtpwd.ClientID %>").value != "" && document.getElementById("<%=ddlusertypeid.ClientID %>").SelectedIndex != 0) {
document.getElementById("<%=btnSubmit.ClientID %>").disabled = false;
}
else {
document.getElementById("<%=btnSubmit.ClientID %>").disabled = true;
}
}
</script>
<tr>
<td align="left">
</td>
<td align="left" class="message" style="padding-left:10px" colspan="3">* Fields are
mandatory</td>
</tr>
<tr>
<td align="left">
</td>
<td align="left" class="bgcolor" style="padding-left:10px">
First Name<asp:Label ID="Label1" runat="server" style="color: red;"
>*</asp:Label>
</td>
<td align="left" colspan="2">
<asp:TextBox ID="txtfirstname" runat="server" MaxLength="20"
onChange = "javascript:EnableUpload();"
></asp:TextBox>
<br />
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" Display="Dynamic"
ControlToValidate="txtfirstname"
ErrorMessage="Firstname is required" ForeColor="Red"
SetFocusOnError="True" ValidationGroup="submit"
></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td align="left">
</td>
<td align="left" class="bgcolor" style="padding-left:10px">
Last Name<asp:Label ID="Label2" runat="server" style="color: red;"
>*</asp:Label>
</td>
<td align="left" colspan="2">
<asp:TextBox ID="txtlastname" runat="server" MaxLength="20"
onChange = "javascript:EnableUpload();"
></asp:TextBox>
<br />
<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" Display="Dynamic"
ControlToValidate="txtlastname"
ErrorMessage="Lastname is required" ForeColor="Red"
SetFocusOnError="True" ValidationGroup="submit"
></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td align="left">
</td>
<td align="left" class="bgcolor" style="padding-left:10px">
Email Id<asp:Label ID="Label3" runat="server" style="color: red;"
>*</asp:Label>
</td>
<td align="left" colspan="2">
<asp:TextBox ID="txtemailid" runat="server" MaxLength="30"
onChange = "javascript:EnableUpload();"
></asp:TextBox>
<br />
<asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" Display="Dynamic"
ControlToValidate="txtemailid"
ErrorMessage="Email Id is required" ForeColor="Red"
SetFocusOnError="True" ValidationGroup="submit"
></asp:RequiredFieldValidator>
<asp:RegularExpressionValidator ID="RegularExpressionValidator1"
runat="server" ErrorMessage="RegularExpressionValidator"
ControlToValidate="txtemailid" Display="Dynamic" SetFocusOnError="True"
ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"
ValidationGroup="submit" ForeColor="Red"></asp:RegularExpressionValidator>
</td>
</tr>
<tr>
<td align="left">
</td>
<td align="left" class="bgcolor" style="padding-left:10px">
Password<asp:Label ID="Label5" runat="server" style="color: red;"
>*</asp:Label>
</td>
<td align="left" colspan="2">
<asp:TextBox ID="txtpwd" runat="server" MaxLength="20"
onChange = "javascript:EnableUpload();"
TextMode="Password"></asp:TextBox><br />
<asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server" Display="Dynamic"
ControlToValidate="txtpwd"
ErrorMessage="Password is required" ForeColor="Red"
SetFocusOnError="True" ValidationGroup="submit"
></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td align="left">
</td>
<td align="left" class="bgcolor" style="padding-left:10px">
UserType Id<asp:Label ID="Label4" runat="server" style="color: red;"
>*</asp:Label>
</td>
<td align="left" colspan="2">
<asp:DropDownList ID="ddlusertypeid" runat="server" MaxLength="10"
onChange = "javascript:EnableUpload();" AutoPostBack="True" ></asp:DropDownList>
<br />
<asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server" Display="Dynamic"
ControlToValidate="ddlusertypeid"
ErrorMessage="Usertype Id is required" ForeColor="Red"
SetFocusOnError="True" ValidationGroup="submit"
></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td align="center" colspan="4">
<asp:Button ID="btnSubmit" runat="server" Text="Submit"
ValidationGroup="submit" onclick="btnSubmit_Click" Enabled="False"/>
</td>
</tr>
</center>
</asp:Content>
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
dtusertype = conn.select_usertype();
if (dtusertype.Rows.Count > 0)
{
ddlusertypeid.Enabled = true;
ddlusertypeid.DataSource = dtusertype;
ddlusertypeid.DataValueField = dtusertype.Columns["UserType"].ToString();
ddlusertypeid.DataTextField = dtusertype.Columns["UserTypeID"].ToString();
ddlusertypeid.DataBind();
ddlusertypeid.Items.Insert(0, new ListItem("Select", "0"));
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
}
protected void ddlusertypeid_SelectedIndexChanged(object sender, EventArgs e)
{
}
till i fill all the textboxes the button is disabled.as soon as all the textboxes are filled the button is enabled.actually until i select any item other than "select" option button should be disabled.this is one pbm i am getting .the other pbm i am getting is i fill password textbox and i select one of the options for dropdownlist.as soon as item is selected password's textbox is becoming empty.why is this happening ....pls help me...
modified 21-Feb-13 3:21am.
|
|
|
|
|
Member 8701813 wrote: document.getElementById("<%=ddlusertypeid.ClientID %>").value != "")
Since you said, 'select' is displayed by default, change the above code to:
document.getElementById("<%=ddlusertypeid.ClientID %>").value != "select"
Since dropdown can have values 'select' or 6,7,8,9,10, any value other then select is ok.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
