DataSource Controls :: Determine If A User Already Exist ?
Mar 6, 2010[Code]...
View 12 Replies[Code]...
View 12 Repliesdynamic SQL determine if Table exist?
View 1 RepliesI'm trying to update a record in a Gridview and I keep getting an optimistic concurrency error... but the site is still in development, so another user cannot be updating the same record.
It's a simple two-column table (only 8 rows so far) - I removed the primary key and thought that might help clear-up the issue I'm having with trying to update that field, but it didn't help.
how I can see more information about why the e.AffectedRows is returning zero? I have a feeling that it may be a permissions issue... because it always seems to be a permissions issue.
I had something like this on another project, but it only errored in my development environment and worked perfectly in the production environment. I seem to lose file permissions occasionally after I back-up a site in my development environment.
I have a table(ShiftCalendar) that lists a letter and a datetime:
Shift Date
A 3/2/2010 8:00:00 AM
B 3/2/2010 8:00:00 PM
I can run a select query that looks like this:
SELECT Shift
FROM ShiftCalendar
WHERE (Convert(nvarchar(10), GETDATE(), 101 = Convert(nvarchar(10), Date, 101))
This will return both values, but I need to to check the time of day to determine which Shift to return. I have been messing around with the IF ESLE and CASE but I can't find a way to tell the select statement what the time of day is.
I created a PageLoad event, so when the page opens it fills all the fields from a DataSource control. However, the problem is that if the DataSource control is empty (the row does not exist yet) it gives me an error. How do I check that if DataSource Control has a row of data or not?
View 5 Repliesi am bulding something for myself in asp.net and SQL but am having a few problems. I will list them below and see what happens :)Please note that i have a lbl control permantly on my pages which is set in the master page, this is what displays my messages.example = message.text = "Please insert your name"1. I have a data table that calls a table with its values. its basicly 4 ddl's(day, month, date & year) select what date then search. Mon Mar 21 2010
SEARCH(btn)
" SqlExeption was unhandled by user code "
this is basicly because the table doesnt exist. How do i tell asp to return a message if the the table doesnt exist in sql server.
I have restored a database from the .bak file on live server.But it keeps creating error in log and I checked it through sql server 2005
management tool . I found the folloing error :"the activate proc[dbo].[procname] running on queue databasename.dbo. storedprocedurename output the following 'Cannot execute as the database prinicpal "dbo"
does not exist,this type of principal cannot be impersonated,or you do not have permission".
And the log file size is increasing with a great pace and I need to delete the log files mannualy as it reaches the size of 90gb in few days.
But if I restore the same .bak on my local system then it does not create the same error log.
I am inserting a record and want to set the value for a foreign key but I am getting an error - I initally thought that it would insert it if it didn't exist but I must be wrong and want to confirm that I need to check all values and make a record for them if they don't exist... here's what I am trying to do - does his make sense?
var newAllPart = new Part();
newAllPart.PartNumber = partNumber;
newAllPart.Manufacturer.ManufacturerName = partManufacturer; // error here if the Manufacturer doesn't exists already
newAllPart.PartType.PartTypeName = partType;
newAllPart.Category.CategoryName = partCategory;
newAllPart.DateCreated = DateTime.Now;
newAllPart.UserCreated = userCreated;
newAllPart.Package.PackageName = partPackage;
newAllPart.Statuse.StatusName = partStatus;
localDB.Parts.InsertOnSubmit(newAllPart);
localDB.SubmitChanges();
I am new to LINQ, but learning Quickly. I get this error "Error 1 The name 'DetailsView1' does not exist in the current context C:UsersUserdocumentsvisual studio 2010WebSitesDursoftHRAGeneral.aspx.cs 40 9 C:...DursoftHR" for the code behind listed below:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class AGeneral : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
viewCompanyInfo();
}.......
"The name 'DetailsView1' does not exist in the current context" is the error I get.
I get the above error using this code. What am I missing?
[Code]....
I have detailed view and a grid view, the DetailedView does the inserting into the Grid view. On my table( Ussing SQL Server), i have a username and year and allocation. What do i do so that when an allocation is given to a user for a year that already exit, it refuses.
View 9 RepliesI am trying to write a function that can be called to run a stored procedure. I pass the stored procedure name, followed by as many parameters as I need to run the procedure. I am able to do this by using the params keyword, so my function looks something like this;
[Code]....
How can I determine what the data type of the parameter is? Maybe I need to alter the string[] part, above?
I have some tables in my project.. 'proof' is the final table where application registration is confirmed. i have to check whether the user register number is exists in proof table or not., then user should not be able to login by using their register no and email id....I t should display message as ' ur reference no and email id' is already submitted.
View 1 RepliesI want to show user already exist erroe in user create wizard but user create wizard is disaply in pop up so after click create user button ot shows error user already exist and pop got closed how i can show error on popup or how can skip postback so clicking on button it will not close popup???
View 6 RepliesOn our company we have a intranet site which uses ASP classic to authenticate users before accesing the site. This site was working before but suddenly i throws an error which limits the users in accessing the intranet site. I made a debugger page in order to know the error of the application and it showed me this error [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. On my local machine the page is accessible on my (IIS server) the connectionstring in the web server and in my localhost are the same. I just can't figure out what's causing this problem.
View 2 RepliesHow can I determine where a user came from when they land on my webpage.Did they come from a google link?Did they user a favorites link?Did they type in the url?
View 4 RepliesI have a user control which I call like this:
<MyNamespace:MyControl runAt="server" ID="foo" /> Is there any way I can determine the ID parameter at run-time and pass it in?
<asp:HyperLink
ID="hyper1"
runat="server"
NavigateUrl='<%#string.Format("~/PLayer.aspx?ID={0}&Type={1}",Eval("arrange_by_id"),Eval("value"))%>'><%# Eval("value")%></asp:HyperLink>
I've implemented this string format in my NavigateUrl to pass a dynamic querystring depending on the clicked item!
but you see the first part in the string format where it says "~/PLayer.aspx" i want the user control to automatically change this part according to where it's placed!
Ok so I am working on a control that when the user comes from a specific website then it will be a certain action. What would be the easiest way to do this?
View 3 RepliesI have Membership, Profile and Role providers setup for my .NET MVC website. I would like to say: this Role has access to that Page. How do I 'inject' this code to the RoleProvider? Or do I have to override it somehow? Any leads?(Roles are stored in the default ASP.NET SqlRoleProvider, Pages are stored in a seperate SQL database).
View 2 RepliesI need to check if an authenticated user is authorized to access a directory. I have done this before with a base class library method, I just cannot remember what class it's part of or what it's name was. I think the method was a static method and the class may have had the word Utility in it's name, but I just can't remember or find it on the net. BUT I KNOW I HAVE USED IT! The method definition was something like:
bool SomeTypeWithTheWordUtilityInTheNamePossibly.VerifyUserIsAuthorized(Principal user, string virtualPath)
I'm not using a roles provider in this application and I'm not planning to.
Im working on a website where users can log into a members area, inside this area they will be able to communicate with other members.
In order to keep an accurate list of who is online and who is not, I would need to update a IsOnline field in my database when they log on and when they exit my website..
The login part is easy, but how can I determine if someone is leaving my website to go to another, or closing the browser.
I'm building several user controls (ASCX) for my website and several of them are very similar in what they do. (As a side note, I must create unique UC's even if they're similar because I'm creating widgets for the new Telligent Community themeing system). For example, two of them are different but use the same front-end code to create a 2 or 3 tab panel where you can click a tab and it changes the data below. I have a single JS file to handle these tabs and the animations. I'm currently dynamically adding my JS file reference to the <head> from the user controls' code via:
Literal jsFile = new Literal();
jsFile.Text = string.Format("<script src="{0}"></script>", "/community/themes/test/js/tabbedCallout.js");
Page.Header.Controls.Add(jsFile);
If I have both of these controls on a page though, both will add this JS file reference. How can I do a check to see if it is already added from another control?
I am in a situation that i cant solvecos i am new to VB.net. I have a page with both a Detail and Grid view. The Detalview does the inserting to display it on the grid view. My table(Using SQL Server) has 3 field Username, Month and Allocation. I want to give an allocation to a user, but if the user already has one for that month, i want it to cancel.
View 2 RepliesI found lots of sites telling me how to put a database into single user mode, but how can I determine what mode a database is currently in?
View 2 Replies