I am currently learning .net and am building my first real website using .net.I was just wondering if people considered it ok to use the generated membership UserId in the query string? and also to use this as a foreign key in a database to link relevant information to this user?
View 3 RepliesI've spent a couple of hours trying to find the answer to this, and although there are tutorials all over the 'net none of them work for me (or I am too n00b to understand what they're telling me.I'm creating users in asp.net using Membership. What I want to do is add the generated UserId to a column in a custom table I've created, to link the stuff in the custom table with the user created in aspnet_Users.
[Code]...
I want to count length of a userId and change the string to that many asterisks. I also want to take the account number and replace all characters except the last 4 XXXX.
View 2 RepliesI created a Query in a database in Access. I want to attach it to a DataGridView in VB2010. I then went to VB and connected to a Database. Then I dragged a DataGridView onto the form. Up came a pop-up menu. I Clicked on Choose Datasource, Add a DataSource,clicked on all the next buttons, selected Tables and Views checkboxes and clicked finish.In the next view up pops a menu that lists my Database and it's tables, but not the created Query. The Query does exist in the Database and I am accessing the correct version.
View 3 RepliesI have created a SELECT FROM WHERE query to perform a search here is my code:
SELECT EmployeeID, DepartmentID, Forename, Surname, Role, Email, Telephone, Extension, Mobile, Photo FROM Employees
WHERE (Forename = ? or ? = '') and (Surname = ? or ? = '') and (Role = ? or ? = '')
I have then put the folllowing code to rung the query within my form:
Me.EmployeesTableAdapter.FillByName(Me.myDataSet.Employees, Me.ForenameTextBox.Text, Me.ForenameTextBox.Text, Me.SurnameTextBox.Text, Me.SurnameTextBox.Text, Me.RoleTextBox.Text, Me.RoleTextBox.Text)
When i search by forename or surname it works fine but when i search by role i get this error..oledbException occured No value given for one or more required parameters.
I have a field that I display via: String.Format({0:c},amount) This produces the string "$28.28" However, when I try to convert back to a decimal amount, I get an incorrect format exception: amount = Decimal.Parse(amount.Text, NumberStyles.Currency) I also tried it with NumberStyles.AllowCurrencySymbol with the same results. I verified that the value in amount.Text is "$28.28". Am I missing something? Shouldn't these two operations use the same currency symbol and formats?
View 2 RepliesEvery LINQ example I have seen for VB.NET anonymous types claims I can do something like this:
[code]...
Now when I go to iterate through the collection(see example below), I get an error that says "Name "x" is not declared. For Each x in Infos It's like VB.NET doesn't understand that Infos is a collection of anonymous types created by LINQ and wants me to declare "x" as some type. (Wouldn't this defeat the purpose of an anonymous type?) I have added the references to System.Data.Linq and System.Data.DataSetExtensions to my project. Here is what I am importing with the class:
[code]...
I need to get the userId of the logged in user in ASP.net, I can use
System.Web.HttpContext.Current.User.Identity.Name
to get the name, but how do I get the userID?
I tried (GUID) and Membership.GetUser as I found, but none seem to work.
I'm creating a web project for one of my uni modules using Visual studio 2010. I'm using asp.net membership and have all of my sql-server tables set up correctly (I'm pretty sure).I have a form that I have created myself that inserts into the database using sqlDataSource.insert(). I had some problems initially with not being able to insert any data into the table at all, but I have cleared that up.My problem now is that I need to insert the currently logged in user's userID into one of the columns of the table. But every time I hit the submit button, I am told I cannot insert null values in the userID column.
I can retrieve the userID using this snippet:
Dim userID As String
Dim memUser As MembershipUser
[code].....
I want to set username & password in a website, like [URL] and want to submit the page.
This should be done automatically when i click a button on the simple form in VB.net.
I'm using following code, but its not working:
Dim objIE As SHDocVw.InternetExplorer
objIE = CreateObject("InternetExplorer.Application")
objIE.Visible = True
[Code]....
i'm currently making an app that needs to run a query between two dates. this app will run automatically, so i need to put the dates as today and yesterday, essentially.
[Code]...
Private Sub txtname_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles txtname.TextChanged
myConnection.Open()
[CODE]...
I want to four digit code like Abneesh than first query finding max of A and second string take string A than code generate like A001----------A999
Using the following code, a user inputs a date into a textbox control and then clicks a button. A new record is created in table [rms_Report] and then I retrieve the ID of the record that was just added. I pass this ID onto page "CreateReport.aspx" via a response.redirect and query string.
I need to retrieve the UserId of the currently logged in user and insert it into table [rms_Report]. I need this to occur after the new record is inserted, but obviously before the response.redirect. I know how to retrieve the UserId, but I'm not sure how to incorporate into the other code.
ASPX
<asp:SqlDataSource ID="ReportDataSource" runat="server"
OnInserted="ReportDataSource_Inserted"
ConflictDetection="CompareAllValues"
[Code].....
I have a computer on a network and via windows forms i want to confirm someones userID and password to log them into another system.
View 1 RepliesI have developed an Access database and would like to display userid from the user table on the welcome form.
View 1 RepliesI need to access (windows apps) the file with a specific account (file located on a share) something like this: Dim myFileInfo as FileInfo=New FileInfo(FileName) ,UserID,Password.
View 4 RepliesHow to get userID of current user logged in from server using asp.net vb?
View 2 RepliesI have this string
mainString="/MyApp/ViewPage.aspx?userId=admin&password=1&id=975"
I am getting value in mainString using this code
Dim mainString As String = Request.QueryString("dest")
And I have two sting variables
1)strTempUsername
2)strTempPassword
In these variables I want to store userId and password values from mainString.
So for this requirement how I write logic in code
Dim arrArray() As String
'/MyApp/ViewPage.aspx?userId=admin&password=1&id=975"
strIndexq = mainString.IndexOf("?") ' Check QuestionMark Exist or not in mainString
If strIndexq > 0 Then
Dim strTemp As String
[Code] .....
Here I am getting userId and password but in this code I will get problem when after ? if userId and password starts wit capital letters and password maybe contain characters like "1&a"
And after getting userid and password. I want to remove userid and password from mainstring. So I want mainstring look like:
"/MyApp/ViewPage.aspx?id=975"
I have one table here with a list of UserIDs, Users, and ClientCodes.Each user can be assigned a client code to view that client's data else where.Right now I have to change it for everyone via SQL Server and actually going into the table manually, but I'm trying to make a simple little program that will let the user change it themselves.All I need is a textbox that pulls the user based on a certain UserID from the table, and a drop down list that will not only show the current ClientCode they're set to, but allow me to change it and save that change to the table in the database.What's the best way to go about this? I tried using the wizards but I guess that's not the best way to go about it.I have it displaying the correct user and their current ClientCode but that's about it.
View 14 RepliesI am trying to change the "logon as" userid and password for a service on a remote machineMy user is a domain admin Here is the code I am using...
Dim wmiScope As ManagementScope
Dim wmiConOpts As New ConnectionOptions
wmiConOpts.Impersonation = ImpersonationLevel.Identify
[code].....
i have a login form in a banking project.i set a userid and password for this login form and i did the code accordingly,it works good.In my form there are two fields namely:Userid and Password and a button named Login.
But i cant get any idea about what to do when the user wants to create their own userid and password?
I think i need to add a few more buttons to enable the user to create their own userid and password but i cant get the idea......i need some help.
Again,if i allow the user to create their own userid and password then anyone can use my project by creating a new account.........
Hence i am totally confused how to go with this.I need some urgent discussion so that i can get through this problem.
Not sure exactly what I need to do to make this work, so my description may be lacking at first.Essentially I am writing a program launcher that recreates itself each time on load. It pulls the data regarding the tabs and buttons from an SQLite database and builds itself dynamically at run time. I get my problem when I pass the tab name through to the function that creates the buttons. I need the name to pull the right set of buttons from the database and I then tried to use the name to place the buttons on the right tab when I create them, but the debugger calls it a null reference because it doesn't point correctly to the tabpage that I'm trying to make it point to (at least that is what I'm guessing). Any ideas on how to make this work right?
[Code]...
I'm trying to create a function-scripter like program. There is a button, a treeview, and 2 textbox's. TextBox1 is where you enter the name you want to give you're function, and TextBox2 is where you input the actual script of the function you are creating. When you press the button, it creates a Treenode in the treeview with the name of what the user put in Textbox1. how do I bind whatever was in Textbox2 to THAT Treenode?
View 1 RepliesI've created two forms of which two separate datasets/tableadapters were created by adding a datasource and dragging and dropping the fields onto my form.I was testing the program using a db that was located on my local drive. Well after publishing the app to the users machines, I noticed that the binded information was still being pulled from my local machine and not the database that the user is working off of.I've set the connection modifier properties for both tableadapters to Public, and I have written the following attempting to change the connection strings:
Private Sub btnSaveSettings_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSaveSettings.Click
Dim pap As New frmPap
My.Settings.dbLocation = txtSettings.Text
[code]....
My program creates a array of numbers as entered by a user and then finally adds them up. The form should be able to display the numbers typed in by the user. I know how to put one of these numbers into separate labels and could display each number that way but I wanted to know if there is a simple way to display the string that is created as a list in perhaps a read only text box or similar?
View 6 RepliesI make a query in coding. But I got conversion error.My query is below
Dim strSelect As String = ""
strSelect = "SELECT " & _
"Description As [Desc], " & _
[code].....
Exception error is like
Conversion from string "iif(CurCons = 0, " to type 'Double' is not valid
Actually, in my report, i wanna show if it's zero then '-'. If i set it in this string.I got another error like below The provider could not determine the Decimal value. For example, the row was just created, the default for the Decimal column was not available, and the consumer had not yet set a new Decimal value.
From da.Fill
Dim cmd As New OleDbCommand(strDynamic, m_DBConn)
Dim da As New OleDbDataAdapter(cmd)
da.Fill(ds, "tblCur")
1. i added a datagrid at runtime on a form. i want to bind a datasource to the datagrid in a button's click event handler, but the datagrid doesn't seem to be visible anywhere else outside the form load event where it is declared. how can i find the datagrid control?
2. and another beginner question.. how to i declare a string that spans multipe lines? i tried with the + operator like in c#, but it doesn't work.
Design a form, which contain a TEXTBOX control that accept a UserID input, with a CommandButton control to perform a validation based on the criteria listed below. Display a Message on whether the UserID is Valid.
Criteria:
The UserID must contains SIX digits follow by a single character, limit the entry to a maximum of seven characters only.
The postfix character of the UserID is derived from the summation of all the six digits divided by seven and using the remain as followed:
Remain
Character
0
A
[Code].....
i need to set up membership for my first website, as i was told i have followed the following steps:1. website --> ASP .NET configuration2. select teh security tab If my admin tool works fine , then it should display the following
1. users - allows to create and manage users2. Role - enable roles3. Access rules - create and manage access rules But my security tab doesnt display those otpions instead it displays an error as:
Code:"There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.
The following message may help in diagnosing the problem: An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error number is 1802 and the SqlException message is: CREATE DATABASE failed. Some file names listed could not be created. Check related errors. Cannot create file 'C:VBWEBSITESMEMBERSHIP1APP_DATAASPNETDB_TMP.MDF' because it already exists. Change the file path or the file name, and retry the operation. Creating the ASPNETDB_dbd9891837cf479eab2e5e8a5e483986 database... "
Then i followed it's instructions, clicked on choose datastore and configured the provider, according to the web admin tool the "single provider" passed the test.
Then i closed the adin tool and restarted it. but still the above error occurs. How can i fix this? PS: this happens even when i disable the firewall!
I'm having issues using the membership.createuser method. My code is below, I get a null exception as runtime. [code]
View 3 Replies