SQL Server :: What Happens To Web Apps When Make Changes To By Database?
Jul 23, 2010
I have a web application which a group of people have been using for some time and it relies on a DAL
in which there a numerous relationships and links to a SQK2K8 database SPROCS.
The SQL db has a group of unrelated tables adn only primary keys.
A DBA wants to add the relations at the database level and create several secondary keys on some of the tables.
I am trying to think how this will affect my current app ?
Will I still be able to use my DAL as is ?
Or will this call for a rewrite of all the methods for each data table ?
This was not a consideration when the application was created because we didn't think that we would be using it long term.
View 2 Replies
Similar Messages:
Sep 26, 2010
I need to make a backup file(.bak) of a database(.mdf)
I learned I need to use MS SQL Server management studio Express to do so, but I can't figure it out how.
I don't know how to connect to the database using this program. In the "Connect to Server" dialogue window, I am supposed to choose a server name from the dropdown list, but nothing comes up. What am i doing wrong?
View 3 Replies
Sep 26, 2010
I need to make a back up file(.bak) from my database (.mdf)
I learned that i need to use Ms SQL Server management studio express. I can't figure out how to connect to the database. looks like I need to select a server type, but nothing comes up for me to select. The databse was made using visual developer 2008 ms sql server, so i thought something like "SQl Server 2005 or 2008" comes up, but it didn't.
View 2 Replies
Aug 9, 2010
How can I do if I want there is a server certificate between web application IIS and web services??
Do I need to go to the Public CA??
View 1 Replies
Dec 18, 2010
I have created a simple application to edit data in an access database using gridview but its not working , the results are shown correctly , but when i click update nothing happens..
Here is my code
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1" EnableModelValidation="True" DataKeyNames="id" >
<Columns>
<asp:CommandField ShowEditButton="True" />
<asp:BoundField DataField="id" HeaderText="id" InsertVisible="False"
SortExpression="id" />
<asp:TemplateField HeaderText="NAME" SortExpression="NAME">
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("NAME") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%# Bind("NAME") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="FATHER_NAME" HeaderText="FATHER_NAME"
SortExpression="FATHER_NAME" />
<asp:BoundField DataField="MOTHER_NAME" HeaderText="MOTHER_NAME"
SortExpression="MOTHER_NAME" />
<asp:BoundField DataField="CLASS" HeaderText="CLASS" SortExpression="CLASS" />
<asp:BoundField DataField="gram" HeaderText="gram" SortExpression="gram" /
<asp:TemplateField HeaderText="Remark" SortExpression="Remark">
<EditItemTemplate>
<asp:DropDownList ID="PS" runat="server" SelectedValue='<%# Bind("Remark") %>'>
<asp:ListItem>PASS</asp:ListItem>
<asp:ListItem>FAIL</asp:ListItem>
<asp:ListItem>APPEARED</asp:ListItem>
<asp:ListItem>NOT APPEARED</asp:ListItem>
<asp:ListItem></asp:ListItem>
</asp:DropDownList>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("Remark") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="CompareAllValues"
ConnectionString="<%$ ConnectionStrings:ConnectionString2 %>"
ProviderName="<%$ ConnectionStrings:ConnectionString2.ProviderName %>"
UpDatecommand = "update [REGULAR] set [NAME] = ?, [FATHER_NAME]=?, [MOTHER_NAME]=?, [CLASS]=?, [gram]=?, [Remark]=? where [id] = ?"
SelectCommand="SELECT [id], [NAME], [FATHER_NAME], [MOTHER_NAME], [CLASS], [gram], [Remark] FROM [REGULAR] WHERE (([CLASS] = ?) AND ([SCHCD] = ?))">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList3" Name="class"
PropertyName="SelectedValue" Type="String" />
<asp:ControlParameter ControlID="DropDownList1" Name="schcd"
PropertyName="SelectedValue" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
View 1 Replies
Aug 10, 2010
I want to make spider charts like this one: [URL] I want to know can I prepare it using reporting service 2008? I am using sql server 2008 as the database and working with Visual studio 2008.
View 4 Replies
Jun 5, 2010
First off, I am just getting started with ASP.NET so I expect this is something that I am doing.
i am trying to make a connection to a MS SQL database on my local machine.
I have the following in web.config
[code]....
View 4 Replies
Sep 29, 2010
I have a local database which is updated regularly. Now I need a good way to reflect the local database changes into the remote sql server. Both the server have same database structure.
All the above pocess should work automatically from the local database server because I need to update the remote one so that the website visitor can get the updated results in the morning.I need a detailed description/ procedure to accomplish the work.
View 3 Replies
Sep 29, 2010
how we can make database with ASP.NET in net page ?
View 1 Replies
Apr 18, 2012
I have this code, that i use to get data from a database.
Code:
Using connection As OleDbConnection = New OleDbConnection(ConfigurationManager.ConnectionStrings("MyConnStr").ConnectionString)
Using command As OleDbCommand = New OleDbCommand("select * from TableTest", connection)
command.Connection.Open()
Using reader As OleDbDataReader = command.ExecuteReader(CommandBehavior.CloseConnection)
While reader.Read()
[Code]..
how can i add 2 sql statsment to that code !?
First of all i need to know is an record is in the db. and if its in the db i need to know if status is activ or notactiv
"select * from TableTest where email = 'test@tester.dk'" if this is OK, then i need to know if Status is "activ" or "notactiv"
how do i do that and how do i response.write one thing if email is not in the db, and another thing if the email is in the db and the status is activ and a 3. response.write if its in the db and the status is notactiv.
BTW do i need to add a reader.close() between the end.while and end.using !?
View 4 Replies
Sep 15, 2010
the format of how to make and analyse database documentation.
View 1 Replies
Jan 19, 2011
how make the class for database activities and it can be used in code behind
coz i want avoid the connection opening, closing activities, insert,update etc methods in code behind frequently.
the class should include connection open and closing method, passing values to stored procedures etc.
How should we construct it?
View 8 Replies
Dec 31, 2010
I have a website in asp.net4.0 with database in sqlexpress 2008 and host it On server with DotNetPanel.but I get error 500 when i try to view it.the problem is my web.config surely.but i can't find the mistake,thus I set custom error to off.but yet iI couldn't found the problem.the bold texts represents the codes that i have added to text.my site don't haveany security or don't use the roles and other.
<?xml version="1.0"?>
<!-- For more information on how to configure your ASP.NET application, please visit http://go.microsoft.com/fwlink/?LinkId=169433 --> <configuration>
<connectionStrings>
<add name="connection" connectionString="Server=serverAddress;Database=DBname;Uid=username;Password=password;" />
<add name="ConnectionString" connectionString="Server=serverAddress;Database=DBname;Uid=username;Password=password;" /> </connectionStrings>
<system.web>
[code]...
View 4 Replies
Mar 4, 2011
I'm trying to make a login Form for my Databse so I can restrict access to the Database. However I constantly get an Invalid Username error when I try to log in. I have copied the Login template from VS 2010 and editted so it should use my own models.
View 3 Replies
Oct 15, 2010
I have an ASP.NET app running on a webserver. A third party is created another app in PHP which needs to send data to my app for processing. Initially it was assumed that the PHP app would be deployed elsewhere so we agreed that the communication would occur over the internet via HTTP (over SSL). My app would simply use a generic handler (ashx) file to recieve the data and send confirmation back.
Now it seems that the PHP app might be deployed on the same machine as my app. I like the fact that using HTTP (as opposed to say direct database access), the PHP app needs to know nothing at all about how my app works. But using the public internet seems silly for communication between two apps on the same machine. If the PHP app simply used a localhost address, would this ensure that all the data stays within the machine? Is there a better way to do this?
View 4 Replies
Jan 17, 2011
I'm starting to plan an architecture for a big web application, and I wanted to get suggestions and/or recommendations on where to begin and which technologies and/or frameworks to use.The application will be an Intranet-based web site using Windows authentication, running on IIS and using SQL Server and ASP.NET. It'll need to be structured as a main/shell application with sub-applications that are "pluggable" based on some configuration settings.
View 3 Replies
Jun 18, 2010
I'm starting to think about and develop an architecture for a big web application, and I wanted to get suggestions and/or recommendations on which technologies and/or frameworks to use.The application will be an Intranet-based web site using Windows authentication, running on IIS and using ASP.NET. It'll need to be structured as a main web application with sub-web applications. Essentially, the entire scope is a composite browser-based, Intranet application that is composed of discrete, functionally complete modules or sub-applications.
View 2 Replies
May 27, 2010
I am an ASP.NET newbie and I am trying to design an OpenID/SSO system for an internal web application. The web application is pretty simple and the authentication is currently being managed by a database with usernames and passwords. I want to replace the existing accounts stored in the database with Google Apps accounts.
I have downloaded the latest DotNetOpenAuth-3.4.3.10103 package and got the OpenIdRelyingPartyWebForms sample up and running on IIS. I have built my own login page using just a OpenIdButton object that points to a development Google domain.
The button seems to work fine in FireFox, at least it is forwarding me to the Google Apps login, but nothing happens when I load the same page in IE. When I click the Google button, nothing happens, zip. The same is true for the Yahoo button in the login.aspx page given in the sample.
Here is the .aspx code I am using...
[code]....
View 2 Replies
May 28, 2010
I'm wondering why I can send sms messages from any one of my email accounts. But if I create a web app that sends emails, the email/message won't get to my phone. Why is that? Do all email providers use SMS gateways?
View 7 Replies
Jun 15, 2010
I have written an application that basically gathers up a bunch of text and numerical data from the client PC and stores it as an object. Right now I'm implementing XML serialization so that the file can be saved.
The issue is now, how do I get this data to the server? I have a server running IIS 7 setup but I don't quite understand the ASP.net life cycle, so I'm not sure how to implement the receiving app.
View 5 Replies
Sep 30, 2010
Multithreading in dotnet apps?
View 3 Replies
Jun 13, 2010
I have downloaded and installed the .net package from [URL]..What should i do to start developing application..how to make database...
View 7 Replies
Feb 26, 2010
VWD 2008 Express. Visual Basic.
I know how to create an AccessDataSource on my aspx page and how to use the datasource to populate gridviews, etc. But I want to know how I can programmatically populate a dataset by querying an Access database. How do I make queries to an Access database programmatically?
View 8 Replies
Nov 29, 2010
I am working on a project. Completed conceptual model of Database is done in EntityFrameWork. Database is not created yet. Should I make a dummy Records with dummy repository and go on development without creating database and once all done than just created the DB and turn dummy repositories to live? . Is it right decision or should I start making database to work with it from the start?
View 1 Replies
Jan 28, 2010
I want to make my queries better but have been un-able to find a resource out there which lays out when a query is shipped of to the db.
DBContext db = new DBContext();
Order _order = (from o in db
where o.OrderID == "qwerty-asdf-xcvb"
select o).FirstOrDefault();
String _custName = _order.Customer.Name +" "+_order.Customer.Surname;
Does the assignment of _custName need to make any request to the database?
View 2 Replies
