|
Thanks. I wasn't going to create a master table for code values but in the end that seems best. That way I can keep the program logic smaller and it helps document the whole code system too.
A severed foot is the ultimate stocking stuffer.
- Mitch Hedberg
|
|
|
|
|
the follow is my way to solve it.
i can code a public method in the cs code..
public string getCompele(string strValue)
{
string strReturn = "";
switch (strValue)
{
case "A":
strReturn = "Active";
break;
case "B":
strReturn = "Expired";
break;
case "C":
strReturn = "Locked";
break;
case "D":
strReturn = "Unknown";
break;
}
return strReturn;
}
in the aspx code, i can use the method to get what i want,like this.
<asp:label id="Label2" runat="server" text="">]]>' style="width: 119px;"
i don't sure if this way can help you.
Study...
|
|
|
|
|
Thanks for the reply to this one. I went with the other solution posted, but this helped me understand the binding mechanism a lot better. Up until now we've done everything programmatically here. Thanks.
A severed foot is the ultimate stocking stuffer.
- Mitch Hedberg
|
|
|
|
|
Hi all,
I'm busy with a site in ASP.NET 3.5 (Visual Web Developer Express 2008).
The idea that I'm busy with is when I create a new user that will have access to the site to create a unique login for them in to the database at the same time, so when the user logs into the site the SQL connection string will be generated for that user to access the database.
As the first time I am attempting something like this I thought I will ask CP for they views regarding this... will it work or is it just a waist of time?
The main reason that I want to do this is to have an audit table that will track any and all changes made on the database, but I want to set it up on the database self (via triggers or something) so when a change made it logs the user, table, column, prev value and new value etc.
This is for when the users phones and says that it used to work and all of a sudden by some unknown mysterious force it is no longer working or changed by itself.....
Anyways, back to the question....
So I started the site using DAL, BLL and then the design tier, can I use a default connection string to build my DAL and BLL and then at run time just change the connection string to use the appropriate connection string details that should be used by that user??
Any suggestions, help, comments will be appreciated
Thanks in advance
No matter how long he who laughs last laughs, he who laughs first has a head start!
|
|
|
|
|
If you are going to create SQL Users when the user first uses your site, what SQL account will create the users?
What I would do is create an application user (sql log in) for your application that only has access to stored procedures. Pass a UserId as a variable to your stored procedures and use that UserId for auditing.
Then set security so you are the only person who can modify the database or tables outside of the stored procedures which have auditing logic built in.
I didn't get any requirements for the signature
|
|
|
|
|
Only the admin user can create users on the site, so they will have their own sql user already created. When he/she creates a new user on the site it will create the sql users as well.
The site is going to be a back end tracking system for a company, so it won't be visible to the general public (have access to it)
No matter how long he who laughs last laughs, he who laughs first has a head start!
|
|
|
|
|
With Visual Studio 2003, all I have to do is:
1. Select New Project from menu.
2. Select "ASP.NET Web Application".
With 2005 I am totally and hopelessly lost. I tried "New Web Site" and had the following two problems:
1. It creates a website on a different port (not the default 80).
2. I can't see the new web site in IIS.
3. Where did the binary (dll) go? Even after I set "Output Folder" to be a specific folder and rebuilt the project, the dll is nowhere to be found.
|
|
|
|
|
By default VS2005 does things a little differently but you can download[^] and install an add-on to get things back to what you are used to.
If you choose to use the Web Site option and want ot use IIS you can choose HTTP in the location dropdown on the New Web Site dialog box.
|
|
|
|
|
Hi,
I know this is lame but im out of practice so please help.
I have a SqlDataSource that i need to access and use in the CS file. Im so used to using as getting the data as a repeater as follows, that i cant remember how to do it as a Dataset / table
protected void getTitle()<br />
{
SqlDataReader reader = (SqlDataReader)<br />
SqlDataSource1.Select(DataSourceSelectArguments.Empty);<br />
<br />
if (reader.Read())<br />
{<br />
Label1.Text = "<h1>" + reader["title_New"] + "</h1>";<br />
<br />
}<br />
<br />
reader.Close();<br />
}
So please help me grab info from the DataSource and use it as a Dataset in the codebehind.
Thanks!!!!
|
|
|
|
|
private static DataSet SelectRows(DataSet dataset,
string connectionString,string queryString)
{
using (SqlConnection connection =
new SqlConnection(connectionString))
{
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = new SqlCommand(
queryString, connection);
adapter.Fill(dataset);
return dataset;
}
}
I didn't get any requirements for the signature
|
|
|
|
|
Hi all,
I'm working on a website that allows users to download audio files, the problem is that when i use a regular link with href=fileURL, this usually plays the audio file using the installed audio player. I want a method to force download dialog box to open. (Also i don't want to put the audio in .zip file and so on...)
Thanks.
|
|
|
|
|
# string strRequest = Request.QueryString("file");
# //-- if something was passed to the file querystring
# if (strRequest != "") {
# //get absolute path of the file
# string path = Server.MapPath(strRequest);
# //get file object as FileInfo
# System.IO.FileInfo file = new System.IO.FileInfo(path);
# //-- if the file exists on the server
# if (file.Exists) {
# //set appropriate headers
# Response.Clear();
# Response.AddHeader("Content-Disposition", "attachment; filename=" + file.Name);
# Response.AddHeader("Content-Length", file.Length.ToString());
# Response.ContentType = "application/octet-stream";
# Response.WriteFile(file.FullName);
# Response.End();
# //if file does not exist
# }
# else {
# Response.Write("This file does not exist.");
# }
I didn't get any requirements for the signature
|
|
|
|
|
thanks very much. It works fine. But for regular download only, i.e if i have Download Accelerator installed it always download the ".aspx" page not the audio files. any ideas?
|
|
|
|
|
Hi
I am trying to call a Java applet from aspx link. Can anyone give me any ideas or resources!!!
Please help me on this.
Thanks
Aruna.G
|
|
|
|
|
use applet tag, give jar file name on Archive
and on link button call the java script function
|
|
|
|
|
Its been a year that i have used .NET for development, and now am back to it again.
Now, the problem is that I need to work on an application developed on the .NET 2.0 framework, and am wondering which MS IDE to use with it
should i use:
- Visual Studio 2005
- Visual Studio .NET Professional
- Visual Studio .NET 2003
- Visual Studio 2008
I dont have the MSDN subscription for VS .NET 2005
HELP!
------------------------------------
Vision is the ability to see the invisible
|
|
|
|
|
Use VS 2008.
You can target development on any framwork.
I didn't get any requirements for the signature
|
|
|
|
|
ToddHileHoffer wrote: You can target development on any framwork.
Not quite, with VS 2008 you can target from 2.0 upwards.
|
|
|
|
|
Hi
I have a screen that needs to limit the comments field to 450 charaters. I have set the Maxlength to 450 but it still allows the user to carry on typing. I have also tried using a javascript function but it is causing a server script error on this screen.
The record is then submitted and sent via workflow to an approver but when the approver wants to approve it an error message appears saying that the string has been truncated and the statement terminated. Any idea on how to prevent this error?
How do I limit the input?
J9
|
|
|
|
|
are you using textmode:multiline as it doesn't work for this
you could try a custom validator for the textbox and set the limit to 450
|
|
|
|
|
if the textbox is muilti rows, the maxlenth is invalid..
so you can use the javascript ...
can you show the javascript error on your screen?
Study...
|
|
|
|
|
I'm trying to get all hostnames for a server. Let me explain from the beginning. I'm creating a website about the countries of the world that will run on a web farm. We have a subdomain for each country e.g. us, uk, australia .. etc .. we're going to assign those subdomains to different servers in the farm, for example, one server can have those domain names, us.oursite.com, uk.oursite.com, australia.oursite.com, newzealand.oursite.com .. another server could have those subdomains norway.oursite.com, sweden.oursite.com, finland.oursite.com .. etc. Now basically what I'm trying to do is that, I want the servers to able to detect their own subdomains at startup. In the previous example, the server that has the us.oursite.com, uk.oursite.com, australia.oursite.com, newzealand.oursite.com domain names, should be able to get those names at startup (in application.start()), how sould this be possible?
Any suggestions are very much appreciated...
|
|
|
|
|
Hello all,
I am a newbie to the AJAX programming techniques. I want to update my database as per choice made by the user and inform him/her about the same if the updation has been done successfully. The platform is ASP.NET
Following is my implementation:
The file containing following two javascript functions has been included in my ASPX file.
This function (i.e. submitValue) is called on the button click and the parameter (i.e. value) is the data I want to update on my database. The function "getXmlHttp()" in bold is returning the required XMLHttpRequest object by using the suitable method as per the browser detected. As I want to inform the user on the same page so the variable "requestURL" passed in the open() function contains the URL of the same page with updated querystring.
function submitValue(value)
{
try
{
//Create the XMLHttpRequest object.
xmlHttp = getXmlHttp();
//Call the function to process the response from the server
xmlHttp.onreadystatechange = stateChanged;
//Send request to the server
var requestURL = location.href+"&q="+value;
xmlHttp.open('GET',requestURL,true);
xmlHttp.send(null);
}
catch(e)
{
alert("Error : Sending request");
}
}
Following javascript function which is called above is used to process the server response.
function stateChanged()
{
try
{
if (xmlHttp.readyState==4 ||xmlHttp.readyState=='complete')
{
var retValue;
retValue = xmlHttp.responseText;
if(retValue=="0")
document.getElementById("divRateInfo").innerHTML = "Rating submition failed. Try again.";
else
document.getElementById("divRateInfo").innerHTML = "Rating successfully submited!";
}
}
catch(e)
{
alert("Error : Processing response");
}
}
Finally following is the code behind written on the corresponding ASPX.CS file. The method is called on the page load.
private void SaveRating()
{
try
{
if (Request.QueryString["q"] != null)
{
int nUserRate = Convert.ToInt32(Request.QueryString["q"].ToString());
SqlParameter[] sqlParam = new SqlParameter[2];
sqlParam[0] = new SqlParameter("@rate", SqlDbType.Int);
sqlParam[0].Value = nUserRate;
sqlParam[1] = new SqlParameter("@id", SqlDbType.Int);
sqlParam[1].Value = Convert.ToInt32(this.Request.QueryString["id"].ToString());
object strInfo = SqlHelper.ExecuteScalar(ConfigurationSettings.AppSettings["ConnectionString"], CommandType.StoredProcedure, "sp_UpdateRating", sqlParam);
Response.Expires = -1;
Response.Write(strInfo.ToString());
}
}
catch (Exception objExcep)
{
Response.Expires = -1;
Response.Write("0");
}
}
Everything works as per expectation, even my database is getting updated perfectly but the "responseText" property in the function "stateChanged()" above is returning the code for my ASPX page instead of just 0 or 1 as expected.
O my god the post has become so long but I wanted to make myself clear. Can anyone suggest any solution? Please help!
|
|
|
|
|
Hi dear,
Ur code is perfect for xmlhttp,
may be there is some bug in the page where u r getting response.. try debug the code by direct opening the url with passed parameters u now can easily trace the bug if any..
Hello Forum
Always be in touch to help about the topic ASP.NET
|
|
|
|
|
Hai,
Any one know how to Place a Record No in Cross-Tab
Thanx
If you have an apple & I have an apple and we exchange our apples, then each of us will still have only one apple but if you have an idea & I have an idea and we exchange our ideas, then each of us will have two ideas!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
