I have the following code where i enable the user to insert their password to retrieve their username.
[Code]....
But nothing happens, it doesnt work. I want it to do the check and then do something. I am just testing with a label for the time being.
But why does this not work?
I have the following code where i enable the user to insert their password to retrieve their username.
[code]....
But nothing happens, it doesnt work. I want it to do the check and then do something. I am just testing with a label for the time being.
I have SQL Server Database Primary Data File.
I want to recover the data from that file in to my data base which has the empty tables.
I have Microsoft SQL Server Query File which contain the table structure.
I'm implementing a BLL layer and have a few questions. First, in my DAL, there is a contacts table, the select method is a sql query against a sql server 2000 database. The preview data returns everyting as expected. The query is
[Code]....
The BLL method is built like so
[Code]....
When using the BLL method to a gridview, the results of the subquery are not displayed. There are also other methods, each having a different where clause for ContactRole_ID and each is having the same issue of not displaying the subquery reult in the gridview. No error, but no data is displayed for the subquery either. Here is the templatefield of the gridview
[Code]....
Another item that is causing an error is in trying to update a record. Here is the DAL update method
[Code]....
And the BLL update method
[Code]....
The error says i have extra parameters, but have no clue where the extra parameters are being picked up. The error isObjectDataSource 'odsContacts' could not find a non-generic method 'UpdateContact' that has parameters: _ContactID, _Active, _ContactName, _Office, _VirtualOffice, _Pager, _Fax, _Home, _Cellular, _Email, _ContactRole_ID, Active, ContactRole_ID, ContactName, Office, Email, VirtualOffice, Pager, FAX, Home, Cellular.And the objectdatasource
[Code]....
I have a formview that is working fine for with the exception of the username is not inserting on a new record. The username is visible on login so I know that is working. I'm attaching my sql code as well as the code behind as I don't know what I'm missing.
[Code]....
SELECT DISTINCT TblSections.SectionID, TblSections.Description
FROM TblSections INNER JOIN
UMG.Users ON TblSections.SectionID = UMG.Users.SectionID
WHERE (TblSections.Description IS NOT NULL) AND (dbo.Users.LoginName = [@Session(UserName)])
ORDER BY TblSections.Description
I have problem in using Session name in the above BOLD WHERE clause.
I would like my website to fetch the data for username and password from a database in SQL server and authenticate that. I have used a login control in the website.
Presently I can assign username and passwords using the 'login control' from the website administration tool.
I've started some preliminary work on getting a Google-like search functionality into my app - ive never done anything like this before so i thought id be a good idea to run by what im thinking of doing at a high level
1) Using MS SQL 2008 w/ Full Text Search Enabled
2) ASP.NET MVC 2 app is using the Repository pattern, with Linq to SQL for data access I'd like for the user to put in one giant text search value, and the full text to do a search over multiple tables and return a mixed result (Employees, Organizations, Offices, etc)
3) I have a simple stored proc that does a Full Text Search on *one* table that looks like this:
[Code]....
4) My Linq to SQL datacontext calls this SP and which works well enough, i have no inflection or ranking going on but ill add that in later...
Q: How do i handle searching over *multiple* tables, doing some digging around it looks like Full-Text doesnt really allow for searches to span over more than one table - which kinda sucks..although ive seen some workarounds
Q: Is it ok to do a Full Text Search for every table i plan on searching through, and combining the results at the business layer (maybe using rank as sort)? I've heard of things like LUCENE but id really not like to do that at this time.
Is it safe to hard code username and password on backend code?
View 3 RepliesI am having issues implementing SqlSiteMapProvider using the Wicked Code article. I am using VB.NET and SQL Server 2008 - and the OnSiteMapChanged event is not firing (the SqlDepdencyCache just seems to simply be not working at all). The article states "You also need to run the ASP.NET worker process with dbo privileges for SQL Server 2005 cache dependencies to work automatically.)" I don't understand what this means. I know what the ASPNET user account is and that it runs aspnet_wp.exe which is basically the ASP.NET run time as I understand it. I know what DBO privs are on SQL. But my SQL and web servers are on different machines, and ASPNET is not a domain account. And it seems crazy to make it one to try to simply get the SqlDepdencyCache to work, and I have trouble believing everyone is doing this?Anyone have any clue what I'm missing here?
View 2 RepliesHow do I define @UserName in my function:
[Code]....
I believe "UserName" = Me.User.Identity.Name
but I don't know the proper way to add it to the function.
i am creating a simple login page with 2 text boxes and a button in C#.NET. I actually couting the number of rows matching the username and password entered and if count is greater than 0 i am redirecting them to a welcome page else i am directing them to
[Code]....
[Code]....
Im new to stored procedures so this may seem a stupid question. What i'm trying to do is create a procedure that checks if username and password match, if true then reset the failed password counter to '0'.
The problem i get is that it keeps prompting for a userID as a variable, see code:
[Code]....
I am trying to display a profile page on my website using the SQL Datasource_Selecting and when the page loads I get this error "An SqlParameter with ParameterName '@UserName' is not contained by this SqlParameterCollection."
The code is:
[Code]....
and the sql code is:
[Code]....
I am building an ASP.NEt application and I want the user to recover the password if needed. The problem is that I am getting the following error:
The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.7.0 Must issue a STARTTLS command first. 36sm3795467vws.6
I have set up my web confing like this:
[Code]....
[Code]....
i have 4 project in my solution, framework , domain objects,business objects and website ...but this morning website project couldnt be loaded... when i tried firsttime to open solution... "The solution file has been modified outside the enviroment" message seemed and press reload then error is project file is corrupted... how can it happen
View 2 RepliesI have a webpage which includes a telerik grid in ajax mode. The data for the grid is constructed in the controller action used to serve the view, and then stored in the session. 90% of the time its available to the ajax method used to populate the grid. And sometimes its not, which is odd. Some sort of race condition ?
[code]....
So if my session object is null, how can I recover - I guess I need the productModelId and Revision parameters from the original EditImage call. Are they available in the _EISelect in any way - its posted to, and the post contains nothing useful.
Oh to make this possibly harder, this page will be displayed via an inline frame.
Can the select command of a SqlDataSource be given by code in the code behind file. Also by calling the SqlDataSource.Select can the select statement be executed?
View 3 RepliesI want to bind an ObjectDataSource to a property in my asp page and I want to do it in the page's aspx code, not in code-behind. I've already done it in code-behind, as follows:
[Code]....
I'd prefer to get rid of the ugly code-behind and just do this in mark-up. Something like
[Code]....
This gives me a run-time error: Cannot create an object of type 'System.Object' from its string representation 'SelectedBook' for the 'DataSource' property.Is there a way of doing this declaratively and not in code-behind? Further, what if what I want is to actually use a child property of the property in question? For example, if my Book object has a ReaderComments collection, can I databind to it decaratively in the aspx mark-up?
I wnat to check "UserName" input with for the following conditions using C#, must Srating with alpha numeric character length is 6 to 15 chars do not use more than 5 numeric characters do not use any special characters.
View 2 RepliesDim queryString As String = "SELECT Presenter_Assignment_.username, Presenter_Assignment_.FirstName, Presenter_Assignment_.LastName, Presenter_Assignment_.SchoolName, Presenter_Assignment_.SchoolTalk, Presenter_Assignment_.Dates, Presenter_Assignment_.Time
FROM Presenter_Assignment_ INNER JOIN UserInformation ON Presenter_Assignment_.username = UserInformation.username WHERE ('@username' = username)
When I run a page with this statement, it pops up an error saying 'Ambiguous Column Name 'username'. Why is this so? ._.
I'm trying to make a dropdown list with data available based on the users login name. Heres what I have as my SQL Query in the SQLDataSource:
SELECT Client_Name, Client_ID FROM Client WHERE (Client_Name LIKE '%@Client_Name%')
So say if the login username is "User1" but the database client name is "User1 Steel" I want the dropdownlist to pull "User1 Steel" as the display and Client_ID as the value from the dropdown list.
i am trying to upload file to a server (72.16.10.156),
my code is in below,
my web application works succeffully when i run it from my code, ofcourse i log on to that server (172.16.10.156) with username and password, before running the web application.
but when i pulish my program an error is occured and that is because of user name and password, ofcourse it is right , because i did not set username and password in my code.
[Code]....
In Web.Config file,I have <identity userName="CTX_DOMAINldapuser" password="ldapPW" />How can pull these userName and password strings in C# behind code?
View 1 RepliesI need to pass the control parameter to Sql Datasource in code behind,
<asp:ControlParameter ControlID="DDL_RType" Name="rtype" PropertyName="SelectedValue"