what should be the database schema for online account opening form with joint account holders and every participants (in a joint account) have seperate contact and personal detials.
View 1 RepliesWhen I created table on the shared SQL server on hosting server using management studio, I right click mouse on the table, it pops up create table. However, the table schema is my user name but not dbo. I wnat to create table with dbo schema.
View 2 Repliesi am having a database in mysql and i want to use that database schema in my project using sql server. i have a Nhibernate c#do code generated by mysql. how can i use that code.
View 1 Replieshow to create schema like below for my database... and why it usefull
dbo.Employees.EmployeeNumber,
dbo.Employees.LastName + ', N' +
dbo.Employees.FirstName AS [Full Name],
dbo.Employees.HourlySalary,
dbo.TimeSheets.TimeSheetCode, dbo.TimeSheets.Week1Monday,
dbo.TimeSheets.Week1Tuesday, dbo.TimeSheets.Week1Wednesday,
dbo.TimeSheets.Week1Thursday, dbo.TimeSheets.Week1Friday,
dbo.TimeSheets.Week1Saturday, dbo.TimeSheets.Week1Sunday,
dbo.TimeSheets.Week2Monday, dbo.TimeSheets.Week2Tuesday,
dbo.TimeSheets.Week2Wednesday, dbo.TimeSheets.Week2Thursday,
dbo.TimeSheets.Week2Friday, dbo.TimeSheets.Week2Saturday,
dbo.TimeSheets.Week2Sunday
FROM dbo.Employees INNER JOIN dbo.TimeSheets
I have a SQL Server 2008 DB with many tables filled with data and I used SQL Server Management Studio to generate a SQL dump by using the Script Wizard : Tasks -> Generate Scripts -> Script All objects in the selected database and also selecting the option to Script Data. I made sure to change the value of "Script for Server Version" to "SQL Server 2008". Then I created a new DB and ran the SQL dump on the new DB to generate an identical copy of the old DB. Then I assigned permissions to my default user to the new DB. Then I changed the connection string on my ASP.NET application to use the new DB. But when I run it, it throws the following exception -
Server Error in '/myapp' Application. The 'System.Web.Security.SqlMembershipProvider' requires a database schema compatible with schema version '1'. However, the current database schema is not compatible with this version. You may need to either install a compatible schema with aspnet_regsql.exe (available in the framework installation directory), or upgrade the provider to a newer version. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Configuration.Provider.ProviderException: The 'System.Web.Security.SqlMembershipProvider' requires a database schema compatible with schema version '1'. However, the current database schema is not compatible with this version. You may need to either install a compatible schema with aspnet_regsql.exe (available in the framework installation directory), or upgrade the provider to a newer version.
Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:.........................
count user online when opening the asp.net website.
View 4 RepliesI've got an ASP.NET website, and its connecting to a database I've created on SQL Server 2k8 and I'm using windows integrated security on my connection string between asp.net and SQL Server. What account should I give permissions to my database inside SQL Server? Should I give NT AUTHORITYNETWORK SERVICE permission to my database? Right now, I right clicked the network service account, and went to properties, and then I checked my database under "users mapped to this login:" and then in the "database role membership for" diaglogue I then selected public and db_owner. Is that right?
View 1 RepliesI am developing a simple online DBMS to browse my database online.... the main concern for me is to clear everything from the PC when the user disconnect so no body can go and click (Back) on the browser and see the pages if the user forgot to close it.. what I have done so far is :
[Code]....
I am sure this is not enough.. am I right? so what else I should include there?
My question is the same as my subject: how to put asp.net website with sql server database online.
I've never done this on my own before so can anyone explain it?
Where can i put it online and so on..
bob3s
In some sites specially online shops, users can pay from thier bank account or cridit card.how can we implement online payment. what is the proccess of online payment? is there any API or Dll for this.
View 4 RepliesI want to merge a software with a website.I have no source code of software, but i want to the database of online data and offline data will automatically synchronize. I have only control over website, online database and offline database.. Is it possible, if yes how?
[code]....
but when i feed data in offline database, online database automatically updated.
Here i want to export my data from local sql server 2000 DB to online sql server 2008 DB.
View 6 Repliesconnecting my database to the online server. My server is seekdotnet. But I had been receiving this error code Cannot open database "database.bak" requested by the login. The login failed. Login failed for user '219_nypmecom'.
View 1 RepliesI designed SqlExpress database for online store ( Asp.net).And these is tables
Department Table:
dep_Id (PK)
dep_name
dep_description
I'm a little frustrated here. I have turned the default database offline then used windows explorer to copy the database to another location but when I tried to take the database online again this error came out:
Cannot open user default database. Login failed. Login failed for user 'Zephere-pcephere(JuLian Yong)'. (Microsoft SQL Server, Error: 4064) The cause is that the default database is set offline, How do I bring it back online agian?
My website is working but when I host it up, the connection are all screw up. Is it because my connectionString are all linked via SqlDatasource and is for local files only? Whats the coding that I need to put in so that my site will connect to the database via accessing the web.config or server?
View 11 Repliesi am new to asp.net i am trying to open a new form from an existing form by pressing a button. the second form should open inside first form only just by clicking in form 1.
View 4 RepliesI was just wondering if anyone has ever had to port the schema across? Are there any experts that could pitch their opinions on the achievability of this (mad) idea? I'm using the IBM Migration Toolkit and as expected its throwing a bunch of translation errors some of which were relatively easy to solve (vendor specific function calls for example) and some will take quite a while to pin down and work round.... however this is not my main concern.
If completed I expect I am going to have to basically rework all the System.Web.Profile/Roles/Membership namespace classes etc to work round the SQL limitations of informix (i.e. IDS11.x SQL server doesnt have a DEFAULT (newguid()) so that would have to be put into the calling method) (and any MVP comments really as I can slap my boss round with the weight after he ludicrously agreed to this project for a client without doing any research...)
Creating a system with web front end and SQL backend (microsoft obviously). I have tried using the asp.netsqlprovider but i can;t as i am only allowed one database on the server, so i then tried to update my current database with the triggers to input the schema into the already existing database.Next step i create my own table with two simple fields of username and password and try and authenticate that way, i can't get that to work either.
I ahve limited permissions on the network as i am a University Student. I really don't know what to do. Never had to create a log on system before and i thought it would be far simpler than this. I ahve used Microsoft's sqlprovider schema before and it worked fine. I have also authenticated via IIS and AD too before. I can't do any of those two in this instance it seems.I need an alternative for logging in users, if needs be in can be crude. I also still need to have some kind of two different views too for logged in users and not logged in users, but that can change if needs must.Don't let me down people, haha. Think this posts in the correct place, i could not find another one i thought could be more relevant.
m stuck at one place...i want to tranfer data from one database-1 to another database-2...both databases are for different web application.
Currently i am doing the same using dataset..but the problem is that when Large amount of data is coming in dataset so during the tranfer of data server gives me a Time out Error.
And another thing i am not want to utillise a server memory because there is Lacs of data into the Database for migrate.
I am trying t use a drop down box which is bound to some data to navigate to a ne form to show somemore data about the selected value. I have tried an event in the selectd index changed
Dim xx
As
Integer
xx = DropDownList1.SelectedValue
Response.Redirect("~/frm_customergeneric.aspx?org_id=xx")
but when I change the value on the dropdosn it does not go into thi event.
Trying to open up a form in a new window while passing some values. It is working, but it is client side (My ASP co-worker finally grabbed the reigns and implemented a bit of his ASP magic to open the form and transfer the values.) But it's so messy, and I hate the fact that I have been bested by old technology.
I was doing this client side before, using window.open and transfering the variables in the URL, but I was getting flack for doing that. So I looked at alternatives and found session variables, which you set server side. So now we want to open the form. I tried the following (individually): Response.Redirect("OtherForm.aspx") and Server.Transfer("OtherForm.aspx") Which replaced the original form in the open window instead of a new window.
I spent a lot of time searching for a solution but the answer keeps coming back to "Just inject some JavaScript to open your form." Is there no "normal" way to open a form in ASP.NET. In any case I guess the real question I would like to ask is what is the best way to open a child form from a parent form?
I want to extract data from pdf form to sql server database. But I don't know how do achieve it?
View 1 RepliesIn my asp.net 2008 project, I am using the login controls... In the local sql server, there are all the necessary tables and stored procedures which the system creates for the relevant login controls. All working fine. I notice in the webconfig file there is an entry under connections, i.e.:
<add name="LocalSqlServer" connectionString="Data Source= ...
Now I would like to put the project into the Dev server. What do I do in terms
1- putting my web project into the Dev machine so that we can test it on the Dev server?
2- how do I put the login database schema into Dev? Is it just a matter of restoring my local DB into Dev?...
I have a project in VS2008.Net3.5 with a Module1, form1 and form2.
[CODE]
Imports Microsoft.VisualBasic
Module Module1
Public frm1 As form1
Public frm2 As form2
Sub Main()
frm1 = New form1
frm2 = New form2
Application.run(frm1)
End Sub
'A menu sub
Private Sub menuGotoSpecification_Click(ByVal sender As Object, ByVal e As System.EventArgs) _
Handles menuGotoSpecification.Click
frm2.Show()
End Sub
End Module
Public Class form1
Private Overrides Sub Show()
LoadData()
MyBase.Show()
End Sub
End Class
Public Class form2
Private Overrides Sub Show()
LoadData()
MyBase.Show()
End Sub
Private Sub btnDone_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDone.Click
frm1.show()
frm1.refresh()
Me.Hide()
End Sub
End Class[/CODE]
Question:
At the beginning I am opening form1 from sub Main(). Now from the menu I am openning form2. In form2 I am clicking Done button to hide form2 and go back to form1. It works fine in the 1st trial. Keeping form1 open for the 2nd time, I opened form2 from the menu. Now when I Click the Done button 2nd time it just hides up everything. Form1 does not show UP. It just exits the whole application. But in my btnDone event, I have frm1.show().