i have a file named print.aspx. There is a link over the print file named friendly print. Behind the link i coded as <a href="print.aspx?mode=print"> As u can c that whent the link is clicked it is redirected to the same page. I want to retrive the querysting value and want to give the if statement like:
if (print==mode) then
{<link href="style1.css" rel="stylesheet"/>}
else
{<link href="style2.css" rel="stylesheet"/>}
I have a SQL statement as below
SELECT [Motor]
,[Time]
FROM [logger].[dbo].[motor]
WHERE day([Time]) = day(getdate())
ORDER BY [TIME]
This is a very basic table that gives me the status of a motor at a given time. All i want is a select statement that will give me the latest result if possible. I can get it so it gives all of todays results but if i could get it that it only displays the latest result that would be great.
I have two sections of users data on my site, customers and employees, each one has a UserID that is FK to the UserID from aspnet_Users table.
I have a table that stores User messages
Looks Like This:
[URL]
It Has a FromUserID and ToUserID
Because Employees are Identified through EmployeeID and Customers are identified through CustomerID, I needed to use UserID's so Employees can leave messages for employees and Customers and Customers can leave messages to employees and other Customers 1-2 and 2-1
My Quandry is this, How Do I retrieve the information if the UserID might be a Customer or Might be an Employee, when the UserID could be from one of two tables
ie
How Would I Write?
SELECT wms.FromUserID, ed.FirstName, ed.LastName FROM ed INNER JOIN wms ON wms.FromUserID = ed.UserID
OR SELECT wms.FromUserID, cd.FirstName, cd.LastName FROM cd INNER JOIN wms ON wms.FromUserID = cd.UserID
How Do I Check to See? Do I Use IF EXISTS?
How to select the month only from the dateTime datatype in sqlserver Express database to asp.net/c# dropdownlist?
View 3 RepliesIam inserting ,updating in one DBfunction .i want to retrieve identityvalue when in insert.for that am adding select SCOPE_IDENTITY() in insert statement.how i can i get this value??
public int funAddEdit_rtblIncidentTypesDB(clsCM_Inc_IncidentTypesData objData, int actiontype)
{
string qry = "";
if (actiontype == 1)
qry = "INSERT INTO _rtblIncidentType (cDescription,iEscGroupID,bAllowOverride,bRequireContract,iIncidentTypeGroupID,iWorkflowID,bAllowOverrideIncidentType,bPOIncidentType,cDefaultOutline) VALUES ('" + objData.cDescription + "'," + objData.iEscGroupID
+ ",'" + objData.bAllowOverride + "','" + objData.bRequireContract + "'," + objData.iIncidentTypeGroupID + "," + objData.iWorkflowID + ",'" + objData.bAllowOverrideIncidentType + "','" + objData.bPOIncidentType + "','" + objData.cDefaultOutline + "'); select
SCOPE_IDENTITY() ";
else if (actiontype == 2)
qry = "UPDATE _rtblIncidentType SET cDescription='" + objData.cDescription + "' WHERE idIncidentType=" + objData.idIncidentType;
int result = SqlHelper.ExecuteNonQuery(clsHelper.ConnectionString.ToString(), CommandType.Text, qry);
return result;
}
if i exceute the above query individually,it returns iddentity value,,bt unable to retireve the value in codebehind.
I access querystring values in each content page's pageload method to get Username and Id. Is there a way I access the querysting values from Masterpage's pageload method and each content page goes to Masterpage to get those values without creating any other local variables in content pages? I know this can be done with Session's or view state but I was thinking to reduce redundancy of accessing query string in each content page.
View 3 RepliesI want to test the request.querystring value in itemtemplate.
I want it like
<ItemTemplate>
if(request.querystring["name"]=='abc')
Qty*Price;
else
Qty
</ItemTemplate>
I have create a masterpage and add content page include user (firsname,lastname,password,new password,confirm new password adn etc..)detail update field. i try to give a client side validation all the function work,but in confirm password its not hide wen give a correct password.. anybody give correct solution..code are below..
[Code]....
have a very important issue,i have three Stored Procedures Sp1,Sp2 and Sp3 .the first one (Sp1) will execute the second one (Sp2) and save returned data into @tempTB1 and the Second one will execute the third one (Sp3) and save data into @tempTB2.if I execute the Sp2 it will works and it will returned me all my data from the Sp3 ,but the problem is in the Sp1, when i execute it it will display this Error:INSERT EXEC statement cannot be nested I tried to change the place of execute Sp2 and it display me another error:Cannot use the ROLLBACK statement within an INSERT-EXEC statement.
View 4 RepliesI am having trouble with this I have 3 Data tables i use over and over again which are cached I would like to write a LINQ statement which would do the following is this possible?
T-SQL VERSION:
SELECT P.[CID],P.[AID]
,B.[AID], B.[Data], B.[Status], B.[Language]
FROM MY_TABLE_1 P
JOIN
(
SELECT A.[AID], A.[Data], A.[Status], A.[Language] FROM MY_TABLE_2 A
UNION ALL
SELECT B.[AID], B.[Data], B.[Status], B.[Language] FROM MY_TABLE_3 B
) B on P.[AID] = B.[AID]
WHERE B.[Language] = 'EN' OR B.[Language] = 'ANY' AND B.STATUS = 1 AND B.[Language] = 'EN' OR B.[Language] = 'ANY' AND B.STATUS = 1
Then i would like it to create a result set of the following
Results:
|CID|AID|DATA|STATUS|LANGUAGE
[Code]....
i have written this code in a Class for enter date in data base using gridview And following code is written in aspx.cs page on button click but i do not know what value pass in st.insert(..........)
[Code]....
I have created one application where user has to submit data. I want to give the shortcut to button.
For Example if user click A1 it should save the data
i want that only sign in user can only see the page .other user cannot see befor sign in?
View 1 Repliesi have created 5 pages which are back-end and should be accessible only to sitre admin that is me. how do i do it?
View 3 RepliesI am new to Asp.net MVC. How to give validations for my forms.
View 2 Repliesmy table has an address. below my table im displaying a map. i have a button show map. i would like to give a parameter to that button to load the address from the query and display it on the map. how can i achieve that. here is my code and button.
protected void Button2_Click(object sender, EventArgs e)
{
map.Visible = true;
}
this is the button code. here is the code from my address.
zooaddress.Text = zo.Address;
My global.asax is not being triggered on errors on my production server..It's works fine on my dev server but I can't figured out why. my app is using asp.net 4.xxxx and iis6. I've read on web about PrecompiledApp.config but I don't see that anywhere on dev or rod..what are some things to look for..also, On my dev server the error is written cleanly to eventlog but on prod I get message below. The description for Event ID ( 0 ) in Source ( Application ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: ........
View 5 RepliesI have trouble sending mail out ..it comes with no errors,
[Code]....
IBecuase if they the UrlReferrer is my applicatin then i want them to allow access to a file.Otherwise not.I know the urlReferrer is null if you go directly to the link, but thats not possible.In my test solution it works great, but if i put it online i got null values, sometimes he gives a value but mosly its null...
View 5 RepliesCODE
<div class="navheader">
<ul class="navuseraccess">
<li><a runat="server" id="mnuAccount" href="AccountSettings.aspx">My Account</a></li>
</ul>
</div>
CSS
[code]....
What I'm trying to do is add a new listitem-anchor but want it to display beneath the existing one, and not next to it. So I'm guessing I'm going to have to move the existing one up a bit, then add a new one beneath it.
how to give read only access to the xml file in c#?
View 1 Repliesin my web application i want to give theme or css dynamically sal for example there are 5 radiobuttons each with some different theme user will choose any one and than that theme should apply to his page.i don't want give class name dynamically i want to give entire theme dynamically.
View 2 RepliesI have deployed my website in ftp server.now i need to upload image to my database and place images in upload folder. while uploading images i'm getting the below error.
Access to the path 'd:hostingmystieproductImagesvaara.jpg' is denied.
Description:
An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code.
Exception Details:
System.UnauthorizedAccessException: Access to the path 'd:hostingmysiteproductImagesvaara.jpg' is denied.
ASP.NET is not authorized to access the requested resource. Consider granting access rights to the resource to the ASP.NET request identity. ASP.NET has a base process identity (typically {MACHINE}ASPNET on IIS 5 or Network Service on IIS 6) that is used if the application is not impersonating. If the application is impersonating via <identity impersonate="true"/>, the identity will be the anonymous user (typically IUSR_MACHINENAME) or the authenticated request user.
To grant ASP.NET access to a file, right-click the file in Explorer, choose "Properties" and select the Security tab. Click "Add" to add the appropriate user or group. Highlight the ASP.NET account, and check the boxes for the desired access.
How to give style in Crystal Report
i have a database column.(SQL column)
[code]....
I have a asp.net website. For that site, i want to give RSS feed for my users. How can i do that?. I want a basic tutorial for this.
View 1 Replies
