DataSource Controls :: Store Members And Newsletter Subscribers In Database?
May 18, 2010
On a website I'm building user's can subscribe to newsletters by entering their email address into a form and submitting. This will then add them to a 'Newsletter_Subscribers' table in the database.
Users can also sign-up to the website by entering their username/password/email details. They also have the option of subscribing to the newsletter. If they choose to do this then their email address is added to the 'Newsletter_Subscribers' table.
However, I wish to make the data more consistent rather than storing the email address into two different unrelated tables in the database.
Has anyone tackled this issue before, and what is the best way to go about storing this information?
One idea I had was to have a 'Users' table, a 'Users.Members' table and a 'Users.Subscribers' table. All three would have a relating UserID column, with the email address stored in the 'Users' table but I'm not sure this is the best method as I would also wish to store the Username/Password in the 'Users' table in case we had a 'Users.Advertisers' table for example.
View 3 Replies
Similar Messages:
May 12, 2010
I am sending an HTML newsletter to various subscribers.
I created two alternate views: Text/Html and Text/Plain
In Outlook the email looks fine but in GMail I don't get the Html version.
If I remove the Text/Plain version then the HTML version is displayed.
[code]....
View 1 Replies
Aug 9, 2010
Has the following simple code to insert the users in my newsletter.But how do you delete it again?
[Code]....
View 1 Replies
Mar 25, 2010
Is it better to store images directly in a database or to just store the name of the file in the db and display that file? I would think that just storing the filename of the image would keep the db size low...
View 1 Replies
Feb 4, 2010
I have a table which contain products, I want each record in the table to have an image. I've created the field with the datatype image. How to I manually add image to the table ?
View 5 Replies
Feb 23, 2010
What data type in SQL should i use to store an XML file? And how do i do it?
View 5 Replies
Apr 15, 2010
I want to store value like 01,02,03 in database but whenver i do so the database transfor those figures into 1,2,3. The field is Int Type.
View 4 Replies
May 14, 2010
I am trying to store data from an XML file to a table in my database, but I keep getting the same error.
This is my code from the cs file:
[Code]....
And this is my error:
Violation of PRIMARY KEY constraint 'PK_Areas'. Cannot insert duplicate key in object 'dbo.Areas'.
The statement has been terminated.
In my XML file I have both existing rows and new rows for the database table. I'm guessing I have to do something to sort out the the rows that are not already in the database, but so far I have been unsuccessful to figure this out.
View 1 Replies
Mar 19, 2010
my problem is my asp.net and C#.net application should read flat files(.txt,.doc) from folder automatically and read the data from file and stored into database
my file like this :
BNK20100312APPHU6658994 // BNK,20100312(date),Ap,PHU6658994 So we have to store these..
BNK20100312APPRU5104220
BNK20100312APPRU5761800
BNK20100312APPZU3739288
BNK20100312APPZU4454037
BNK20100312APESU2552894
BNK20100312APAXU4302543
BNK20100312APCKU1613369
View 1 Replies
Jun 15, 2010
I am selecting time from dropdownlist. and want to convert it in datetime and store it in database. When I am converting it to Datetime using following statement.
DateTime start_Time = Convert.ToDateTime(start_ts);
but it is showing as : date:12:00:00AM
View 7 Replies
Mar 27, 2011
I need to store time in database and then show in using gridview.I wonder how to store and show data so that user will see correct datetime depanding on his timezone?
View 6 Replies
Jan 31, 2011
I have to create a simple application which scans, displays and stores the info from a barcode. I have been able to sort the scanning and display part of this application but I need to know how to store the infromation entered into a textbox to a database and then be able to display the stored data as a list at a later stage.E.G. Once the "STORE" button is clicked, the information/text within the textbox is stored to a database. Once the "VIEW STORED DATA" button is clicked, the stored information in the database is displayed as a list.I am a complete beginner when it comes to creating web applications using asp.net. Also, the type of database to use (i.e. sql, wamp.etc) and how to link it to my application is also puzzling.
View 1 Replies
Feb 5, 2010
I use a calendar to pick a date that I want to store in my MSSQL Database. I use the form format, like 2010-01-27 (european date format) with no time info. What MS SQL Date-type should I store this date in?
View 4 Replies
Apr 19, 2010
I am trying to make a routine system(school, college) where i will use three text field as input1> Class start time(input: 8:00 AM) // when school/college will start.2> Class ending time(input: 1:00 PM) // when all of my class will finish3> Duration of class(input: 1.5(hour))// class hourdesired output: A class routine where time(hour) will be shown in row and Day(e.g, sunday,monday) will be shown in column.questions:
1> how i'll take the input as time:hour from text field?2> how i can save the calculated time in database for use in other page?
View 3 Replies
Jun 16, 2010
Is it a good idea to create a document managament system that stores all kinds of documents inside sql server database. This will have infrastructure to accomodate all kinds of applicartions..
View 2 Replies
May 4, 2010
i am developing a MLM software and i have to give downline summary..
so i have to get the count of downline by left and right...
View 12 Replies
Feb 1, 2010
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.
[Code]....
View 1 Replies
Mar 8, 2010
i'm making a application for a newslettersystem. The only thing i want yet is to subscribe to a elecronic newsletter, but the record to subscribe isn't inserting. What do i do wrong?
[Code]....
and the vb code
Protected Sub btn_verwerken(ByVal sender As Object, ByVal e As System.EventArgs)
Dim strConnectie As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & Server.MapPath("~/App_Data/nieuwsbrief.mdb")
Dim Connectie As New OleDbConnection(strConnectie)
Try
Connectie.Open()
Dim strSQL As String = "INSERT INTO TBL_Subscribers(Email, SubscribeDate, ActivateDate, UnsubscribeDate) VALUES (@Email, @SubscribeDate, @ActivateDate, @UnsubscribeDate)"
Dim command As New OleDbCommand(strSQL, Connectie)
command.Parameters.AddWithValue("@Email", Emailadres.Text)
command.Parameters.AddWithValue("@SubscribeDate", DateTime.Now)
command.ExecuteNonQuery()
Connectie.Close()
Response.Write("inserted")
Catch ex As Exception
MsgBox(ex.Message.ToString, MsgBoxStyle.Exclamation, "BCT")
End Try
End Sub
View 5 Replies
Apr 28, 2010
Our site has a page for maintenance of existing members (e.g. adding / changing roles, etc.)This page currently uses a gridview to show a complete list of all members, based on GetMembers() method to populate it.However, as the number of users has grown to several hundred, it has become difficult to locate a particular user by paging through several pages.Is there a way to narrow down this list, maybe with a filtering textbox, so that as you start typing into that textbox, only members whose name contains the typed characters will show up in the gridview?
View 8 Replies
Nov 11, 2010
Its related to datatable in gridview store in session and then session retrive and store to database. basically i am using gridview here creating new row for button click and these row adding untill user's last entry then submit all these entry to database. so i want to use session variable to store this data temporarily and after final entry user click on submit button and all data shold be save in db.
View 9 Replies
Feb 14, 2011
I use MS Visual Web Developer 2008 Express edition with VB and SQL Server Express.I have an SQL database of over 300 club members details which contain(amongst other things) the following details:Forename, Surname, Email address, Full postal addressI want to send an email to each member showing their forename, Surname, and postal address so that they can confim that these are correct.
View 6 Replies
Jul 8, 2010
I have a web form which will send bulk email to our site suscribers, they maybe hundreds or even thousands.Is System.Net.Mail optimal for this purpose?
View 18 Replies
Mar 30, 2013
i wnat to sechdule message on asp.net. Like if i create a messge reminder to registerd members so they recive messge on paricular date time.
View 1 Replies
Feb 8, 2010
I had a little problem with the value that one of my SPs returns. In my SP, I create some temporary tables to store certain data from multiple tables and contains some queries for an advanced calculationBut precisely yesterday, the value that the SP returns was incorrect. I tried to look at the SP and the data again and everything was OK, but not the result from the SP.And what the heck!!..today the value is totally right ...I truly have no idea what's wrong with the SP..Is there anyone knows what the root of cause is?
View 4 Replies
May 3, 2010
i have follwing column in databse Name,age,Education,Intrest,MyImage(optional field)
i want to store the follwing info in databse using linq to sql, i know how to store other type of data then image, how to store image with above information keep in mind that image is optional...
View 4 Replies
