i have this form, that the data is stored in a SQL db using Linq.
my question is, how can i add a column, that will have all the information about the sender, meaning IP address, browser, referrer etc.
the thing is is i want to store it in one field. i come from a php knowledge that has been long forgotten by me, but i still remember there was some serialize command, that you could run on an array and store it in a db, then when you want it back to an array you would just run deserialize command and it would go back to an array.
When a user logins, I want to be able to store all his profile information so I can display, for example, his email on different pages of my website, but I don't want to have to keep querying the database for every time I want to display his email. How would I go about doing this?
really new to the programming scene. writing a program so when i select an item from a drop down list i click the submit button and i want it to display the items selected from the database in a gridview. so in short i want to select an item click submit and i want it to display the information from the database.
i have a list of fields that i would store for all the user session. I thought to create a class, insert the information in it and store the class in the session but i'm not sure this is the best way to do it (performances, etc). I should have a list of these informations that i can display in views, i can delete and i can update. How could i do this?
while creating users/groups using web site administration tool, is there a way to configure it to store to a specific database rather than store to a Microsoft SQL 2005 Server Express Edition by default in the App_Data folder?
I need to know how to change aspnetdb to store profile information unique to each user so that I can restrict records in an sql table to only show that user's records.
So if I make a "companyID" int, identity column where would I put it?
Also, when I write the where clause to companyID = profile (companyID) would that work?
Our application lets the administrator create new users. Since the administrator is logged in, I have set Logincreateduser = false so that the administrator is not logged out even after creating the new user.
The problem is :I need the userid of the newly created user to store additional details of the user in another database table. I see that i can get the username using Createuserwizard1.username; but how do I get the userID?
How to add code to redirect my user on successful submit to my database.
Code...
Imports System.Data Imports System.Data.SqlClient Partial Class CPD_OnlineSurvey Inherits System.Web.UI.Page Public Sub UpdateOnlineSurvey(ByVal sender As Object, ByVal e As EventArgs) Using conn As New SqlConnection() conn.ConnectionString = ConfigurationManager _ .ConnectionStrings("wincts").ConnectionString Using cmd As New SqlCommand() cmd.CommandText = "update OnlineSurvey set IsSelected = " & _ "@IsSelected where QuestionId=@QuestionId" cmd.Connection = conn conn.Open() For Each item As ListItem In ChkOnlineSurvey.Items cmd.Parameters.Clear() cmd.Parameters.AddWithValue("@IsSelected", item.Selected) cmd.Parameters.AddWithValue("@QuestionId", item.Value) cmd.ExecuteNonQuery() Next conn.Close() End Using End Using End Sub End Class
I'm developing an ASP.NET application with Visual Studio 2008 SP1 and C#. I'm also using Sql Server 2008 SP1.I'm trying to add the tables created with the command aspnet_regsql -S (local) -E -A m to my own database.
If I run that command it will create a database (Aspnetdb database) with four tables. I want to know if there is a command that creates those tables in my own database (called myDatabase, for example).And, when the tables are created. How can I connect authentication to myDatabase?
I'm creating a website with ASP.net and I have a sign up page. The user has to enter a name and password in textboxex, and choose a location and reason for joining from dropdown lists. (There is a built in wizard for new user sign-up but I chose not to use it).I would like to save the information entered in a table in a database in the App_Data folder. How do I do this?
I have a online game (written in ASP) which i have finally decided to convert to ASP.NET. However i cannot seem to link the login ID's of users to their specific details in the database. I.E when Joe Bloggs logs in, he will be shown the team information for just his club, not every club. in ASP I use code similar to this below
[Code]....
im not convinced that is the right syntax to be using, but when i execute the code in Query Builder it is showing me the correct data (that i expect to see). So im wondering if there is something else im missing? Is there something extra that i need to be adding in Web.Config file or elsewhere?
I m trying to use the profile system to get information of the authenticated user form the data base, just like the session system : the user is authenticated then I set same variable with information of this user coming from data base !I am familiar with PHP so i m trying to do it like that !Also, i woul like to join my own data base and the asp.net membership database !
whats the exact use of static variables in overall programming in .net and for asp.net...
Recently i went for the interview where interviewer asked me 2 question which i was not sure for the same..
whats the use of session object, i said sessions are the server side object, they are used when you want to store user specific data at server side, then he asked what if i want to use static variables for the same, i was mum, can anyone tell me how asp.net will behave if i store the user specific information in static variables.If i use cookies which are the best option to store the data at client side (not sensitive one), but what if user has disabled cookies on his machine, will my application would crash.
I want to store the log information for website, is there is any inbuild component for that of free source code for that. I want to track the exception and other information that occure in my web site.
I am coming back to developing in .net and I want to use MVC3. I have a question about the best way to store data that will be used often by many users and not changed much. I would normally think to store and retrieve on a database but making calls everytime seems ineffecient. I would like to use cache with an sql dependency but not exactly sure how to do this on MVC3 and if it is the best way.
I'm using Google Maps v3 and I build in the server side a json collection of location data. So when I receive that, I iterate through that collection and create a marker object for each and every one of them.For each of these markers, I bind them with the click event, so when the user clicks on a marker in the map, it displays an infoWindow with data related to the associated location.I have an array to store all the location got from the server that holds the retrieved json objects and their corresponding marker.
The problem is that, even when I have an array that I can reference or iterate through, I need to not only get the marker object when the user clicks on them, but also the location object, that stores more information.I tried to mantain this array of objects and reference it from the calling object without success, because the function is called by the marker and not the location object. So I thought if it's possible to store more information in the google maps marker object like using a general purpose field.
i've got some problem reading excel files to store into sqlserver database. currently my code has a fileupload control and a button for me to save the excel file into a folder and read the data inside the excel file and write it into the sql database. The code works only if the excel sheet name is Sheet1.xlsx, however i tried upload a diff file named ImportUserFile.xlsx and it gave me the exception below. 'ImportUserFile$' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long. i have also tried other file names and it seemed only Sheet1.xlsx works.
Using SQL and C#. I have a gridview with a template field. I need to modify the some items in the gridview when the user selects a given record and store the values back in the database. ProjectID is the unique key in the database.Gridview is done as a table. How can I do it? Here is my grid view implementation.
