MSDE Database Not Updating

Aug 18, 2005

I'm trying to build a record update form and I'm
going off the "Build Your Own ASP.NET Website" book. I'm not getting
any compilation errors; the database just doesn't update.

void Update(Object s, EventArgs e) {
    SqlConnection upConn = new SqlConnection(
        "Server=****\netsdk; database=CLASSIFIEDS; User ID=****; Password=****;");
    SqlCommand upCmd;
    upCmd = new SqlCommand("UPDATE CLASSIFIEDUSER SET
ITEMHEADLINE=@ITEMHEADLINE, ITEMDESCRIPTION=@ITEMDESCRIPTION,
CONTACTNAME=@CONTACTNAME, EMAIL=@EMAIL, HOMEPHONE=@HOMEPHONE,
WORKPHONE=@WORKPHONE, CELLPHONE=@CELLPHONE, BUILDING=@BUILDING,
ROOM=@ROOM, PRICE=@PRICE WHERE ID=@ID", upConn);
    upCmd.Parameters.Add("@ITEMHEADLINE", headline.Text);
    upCmd.Parameters.Add("@ITEMDESCRIPTION", description.Text);
    upCmd.Parameters.Add("@CONTACTNAME", contact.Text);
    upCmd.Parameters.Add("@EMAIL", email.Text);
    upCmd.Parameters.Add("@HOMEPHONE", home.Text);
    upCmd.Parameters.Add("@WORKPHONE", work.Text);
    upCmd.Parameters.Add("@CELLPHONE", cell.Text);
    upCmd.Parameters.Add("@BUILDING", building.Text);
    upCmd.Parameters.Add("@ROOM", room.Text);
    upCmd.Parameters.Add("@PRICE", price.Text);
    upCmd.Parameters.Add("@ID", Request.QueryString["id"]);
    upConn.Open();
    upCmd.ExecuteNonQuery();
    upConn.Close();
   
    Response.Redirect("preview.aspx?id=" + Request.QueryString["id"]);
}

The Response.Redirect works so I'm thinking there must be an SQL syntax error or something but I can't see it.

View 16 Replies


ADVERTISEMENT

Migrating From Sql2000 MSDE Database To Sql2005 Express - Attach Database Errors

Apr 23, 2006

I have a medical records system, SoapWare v4.90, that uses MSDE (SQL2000) databases. Due to the 2gb limitation, I am trying to migrate over to SQL 2005 (Standard or Express) which I have heard works fine. The SoapWare has a datamanager that allows me to log in to the MSDE instance, detach the SoapWare databases from msde (as well as do backups, etc) which I can confirm are detached.

Then I log back into a SQL2005 database instance using the datamanager and try to attach the database. This is what their pictured instructions demonstrate. However, I get the following error:


Database 'sw_charts' cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery.


Of course, some of the entries will be read only, since doctors have to sign off the charts and are not allowed to subsequently change them.  But I should still be able to switch over to sql 2005?!?!?!?


Or... is there a way to attach the databases to SQLExpress manually?

Help pls?

View 1 Replies View Related

Updating A Production Database With Back Up Of Development Database

May 11, 2007

Can someone provide a step by step tutorial for this? I'd like to safely update a database that is used for a website without much or any downtime.

View 1 Replies View Related

Updating Online SQL 2005 Database From Local Database

Jan 30, 2007

I have my first small SQl Server 2005 database developed on my localserver and I have also its equivalent as an online database.I wish to update the local database (using and asp.net interface) andthen to upload the data (at least the amended data, but given thesmall size all data should be no trouble) to the online database.I think replication is the straight answer but I have no experience ofthis and I am wondering what else I might use which might be lesscomplicated. One solution is DTS (using SQL 2000 terms) but i am notsure if I can set this up (1) to overwrite existing tables and (2) notto seemingly remove identity attributes from fields set as identities.I know there are other possibilities but I would be glad of advice asto the likely best method for a small database updated perhaps onceweekly or at less frequent intervals,Best wishes, John Morgan

View 3 Replies View Related

Updating A Table On My Hosted Database From A Local Database

Aug 1, 2007

Hi,

How do I insert data that I have collected in a local database onto a table on my online ie hosted database which is on a different server?

At the moment I am just uploading all the data to the hosted DB but this is wasting bandwith as only a small percentage of data is actually selected and used.

I thought that if i used a local DB and then update the table on my hosted DB this would be much more efficient, but I am not sure how to write the SQL code to do this!

Do I do some kind of

INSERT INTO sample_table

SELECT xxx

FROM origanal_table



Or is it more complicated than this?

Thanks

View 6 Replies View Related

Transferring Data From MSDE Database To SQL 2000 Database

Jul 23, 2005

Hi all,Here is my situation.I have an application that uses SQL 2000. The client has a programthat uses MSDE. The client MUST have the MSDE version of the Database.What I have done is to create a SQL 2000 Database that is exactly likethe MSDE version. What I wish to do, is at regularly scheduledintervals, update the SQL 2000 Data with the newest MSDE Data.On my clients server, they have both MSDE and SQL 2000 installedthe msde has a user name and password to access it, whereas the SQL2000 uses authenticated mode to access it.What I'm trying to do is to write a bunch of SQL Queries, that I canrun that will copy over the new Data, but I'm having problems accessingthe msde database in query analyzer from the SQL DatabaseCan anyone give me hints on the best way to try thisThanksScott

View 1 Replies View Related

Updating Sql Database From Linked Access Database

Jul 1, 2004

I got thrown into a new project that is going to require me to update an SQL server database tables from an Access table on the backend of an Oracle database on another server. At the end of each day the Access dabase will be updated from the Oracle database.

What I need to do, is when the Access database is updated I need to have the table in the SQL database automaticaly updated. When a new record is added to the Access table I need the new record added to the SQL table. When a record is deleted in the Access table I need to keep that record in the SQL table and set a field to a value (such as 0). And when a record is updated in Access, have it updated in SQL.

Needless to say this is a bit out of my area and not sure how to accomplish this.

Any help is greatly appreciated.

View 2 Replies View Related

Updating Sql 2000 Database From Sql 2005 Database

Jul 27, 2006

i have sql 2005 installed on my personal machine, but our server has sql 2000 on it. the structure of my database was made on the server, but i'm not sure how to update the server copy from my local copy. when i try to export my data from my local machine to the server (or import from my local machine to the server), i get pre-execute errors.

roughly every other week, i'll need to be able to update the server version from my local version, so i'm trying to find the most efficient method. what is the best way to update a 2000 database from a 2005 database? it doesn't matter if i append or overwrite, but i do use identity fields. the error i get when trying to use the import/export wizard is:



- Pre-execute (Error)



Messages

Error 0xc0202009: Data Flow Task: An OLE DB error has occurred. Error code: 0x80040E21.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".
(SQL Server Import and Export Wizard)


Error 0xc0202025: Data Flow Task: Cannot create an OLE DB accessor. Verify that the column metadata is valid.
(SQL Server Import and Export Wizard)


Error 0xc004701a: Data Flow Task: component "Destination 3 - ReleaseNotes" (202) failed the pre-execute phase and returned error code 0xC0202025.
(SQL Server Import and Export Wizard)

View 4 Replies View Related

Attach Database To SQL2005 From Old MSDE Database

Apr 22, 2006

I have a medical records system, SoapWare v4.90, that uses MSDE (SQL2000) databases. Due to the 2gb limitation, I am trying to migrate over to SQL 2005 (Standard or Express) which the company says works fine. The SoapWare has a datamanager that allows me to log in to the MSDE instance, detach the SoapWare databases from msde (as well as do backups, etc) which I can confirm are detached.

Then I log back into a SQL2005 database instance using the datamanager and try to attach the database. This is what their pictured instructions demonstrate. However, I get an error:


Database 'sw_charts' cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery.

Or... is there a way to attach the databases to SQLExpress manually?

Help pls?

View 3 Replies View Related

Updating The Database

Mar 7, 2007

Hi All:

Appreciate your efforts in answering queries of so many newbees!I hope to find answering my query..I
have created a logon screen to which i have also given the option of
changing the password ... Now below is the code for updating the new
password given by the user ....Imports System.Data.SqlClient     Dim con As New SqlConnection("server=sys2;initial catalog=kris;integrated security=SSPI")    Dim cmd As New SqlCommand("select * from u_login", con)      Dim dr As SqlDataReader    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load    End Sub    Private Sub btnUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSubmit.Click        con.Open()        dr = cmd.ExecuteReader        While dr.Read()            If dr(0) = txtEmail.Text And dr(1) = txtoldpwd.Text Then                Dim NewPwdStr As String = txtnewpwd.Text                Dim OldPwdStr As String = txtoldpwd.Text                Dim sqlstr As String = "Update U_Login set pwd = ('" & NewPwdStr & "') Where pwd = '" & OldPwdStr & "'"                Dim cmd1 As New SqlCommand("sqlstr", con)                                        cmd1.ExecuteNonQuery()                Response.Write(" Password Changed ... Please login again")            End If        End While        dr.Close()        con.Close()    End Sub The above code although doesnt
throw any error however it shows a blank screen and doesnt even update
the new password. Can you plz help me understand what could possibly be
wrong in my code n why is that am getting the blank screen. Your help will be highly appreciated!Thanks,Brandy

View 6 Replies View Related

Updating A Sql Database From Asp.net

May 25, 2005

Im sorry for how simple this question is im.. brand new at this.I am trying to write a program that will take information entered in 4 txt fields on a webform and populate a sql database with them with a submit button..   Eventually its going to be a updateable phone list for my department but for now im just trying to get the submit button to work.  More then anything i just need a good resourse to read up on it. Thankyou Adam

View 2 Replies View Related

Updating The Database

Nov 15, 2003

At present I am working on a school project. the project was installed few months back. database is MSsql server.
Because of some new things i had to change few tables, add few columns and add few tables also. Now My problem is that the school is already having the data which they don't want to be disturbed . So I want My structure and their data.

:confused: :(
Please Help Me.

View 4 Replies View Related

Updating The Database

Jul 20, 2005

I'm having a difficult time calling UPDATE when my 'WHERE" clause calls ID,which is numeric and the primary key. I found that I can do a SELECT justfine with "WHERE ID".. Is there something special about UPDATE that i'm notgetting? I've searched the internet but it appears that what I'm doingshould work.Any help would be greatly appreciated.if (modcustomer == "relate"){var modid1 = Request.Form ("modid1");var modid2 = Request.Form ("modid2");var relationship = Request.Form ("relationship");var comments = Request.Form("comments");SqlString = "UPDATE Customer SET Relationship = ' " + relationship + " 'WHERE ID = " + modid1;connection.Execute (SqlString);}thanks,Debbie EhrlichReliable Software - Developers of Code Co-op®, Server-less version controlfor distributed teams www.relisoft.com

View 3 Replies View Related

Updating Database

May 17, 2006

Can someone please tell me what I am missing... I am trying to update a record with information a user types into a textbox. I am not getting any errors even when in DEBUG mode. But yet the Data is not getting updated.

Any Help would be very much appreciated.

T

CODE:

Protected Sub bUpdateSlsNum_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles bUpdateSlsNum.Click

Dim myCommand As SqlCommand

Dim myConnection As SqlConnection

myConnection = New SqlConnection("Server=.SQLEXPRESS;AttachDbFilename=|DataDirectory|CustomerInfo.mdf;Integrated Security=True;User Instance=True")

Dim UpdateCmd As String = "UPDATE CustomerSalesNum SET WorkSheetID=@WorkSheetID, Price=@Price, Freight=@Freight, Setup=@Setup, " _

& "Injection=@Injection, Wheels=@Wheels, Security=@Security, SubTotal=@SubTotal, DocFee=@DocFee, TradeInAllow=@TradeInAllow, TaxAmount=@TaxAmount, SalesTax=@SalesTax, " _

& "TradeLienBal=@TradeLienBal, Other=@Other, PAQuote=@PAQuote, TitleFee=@TitleFee, DownPay=@DownPay, Total=@Total WHERE [WorkSheetID]= '" & "@" & lblRWorkSheetID.Text & "'"

myCommand = New SqlCommand(UpdateCmd, myConnection)

myCommand.Parameters.Add(New SqlParameter("@WorkSheetID", Data.SqlDbType.NVarChar))

myCommand.Parameters("@WorkSheetID").Value = lblRWorkSheetID.Text

myCommand.Parameters.Add(New SqlParameter("@Price", Data.SqlDbType.NVarChar))

myCommand.Parameters("@Price").Value = tbUPPRice.Text

myCommand.Parameters.Add(New SqlParameter("@Freight", Data.SqlDbType.NVarChar))

myCommand.Parameters("@Freight").Value = tbUPFreight.Text

myCommand.Parameters.Add(New SqlParameter("@Setup", Data.SqlDbType.NVarChar))

myCommand.Parameters("@Setup").Value = tbUPSetup.Text

myCommand.Parameters.Add(New SqlParameter("@Injection", Data.SqlDbType.NVarChar))

myCommand.Parameters("@Injection").Value = tbUPInjection.Text

myCommand.Parameters.Add(New SqlParameter("@Wheels", Data.SqlDbType.NVarChar))

myCommand.Parameters("@Wheels").Value = tbUPWheels.Text

myCommand.Parameters.Add(New SqlParameter("@Security", Data.SqlDbType.NVarChar))

myCommand.Parameters("@Security").Value = tbUPFactorySec.Text

myCommand.Parameters.Add(New SqlParameter("@SubTotal", Data.SqlDbType.NVarChar))

myCommand.Parameters("@SubTotal").Value = tbUPSUBT.Text

myCommand.Parameters.Add(New SqlParameter("@DocFee", Data.SqlDbType.NVarChar))

myCommand.Parameters("@DocFee").Value = tbUPDOCFee.Text

myCommand.Parameters.Add(New SqlParameter("@TradeInAllow", Data.SqlDbType.NVarChar))

myCommand.Parameters("@TradeInAllow").Value = tbUPTIA.Text

myCommand.Parameters.Add(New SqlParameter("@TaxAmount", Data.SqlDbType.NVarChar))

myCommand.Parameters("@TaxAmount").Value = tbUPTAX.Text

myCommand.Parameters.Add(New SqlParameter("@SalesTax", Data.SqlDbType.NVarChar))

myCommand.Parameters("@SalesTax").Value = tbUPSALETAX.Text

myCommand.Parameters.Add(New SqlParameter("@TradeLienBal", Data.SqlDbType.NVarChar))

myCommand.Parameters("@TradeLienBal").Value = tbUPTILB.Text

myCommand.Parameters.Add(New SqlParameter("@Other", Data.SqlDbType.NVarChar))

myCommand.Parameters("@Other").Value = tbUPOther.Text

myCommand.Parameters.Add(New SqlParameter("@PAQuote", Data.SqlDbType.NVarChar))

myCommand.Parameters("@PAQuote").Value = tbUPPAQuote.Text

myCommand.Parameters.Add(New SqlParameter("@TitleFee", Data.SqlDbType.NVarChar))

myCommand.Parameters("@TitleFee").Value = tbUPTitle.Text

myCommand.Parameters.Add(New SqlParameter("@DownPay", Data.SqlDbType.NVarChar))

myCommand.Parameters("@DownPay").Value = tbUPDownPay.Text

myCommand.Parameters.Add(New SqlParameter("@Total", Data.SqlDbType.NVarChar))

myCommand.Parameters("@Total").Value = LBLUTOTAL.Text

myCommand.Connection.Open()

Try

myCommand.ExecuteNonQuery()

ShowMessageBox(Me, "ATTENTION: Customer Data has been Updated.")

bUpdateSlsNum.Enabled = False

Catch ex As SqlException

If ex.Number = 2627 Then

ShowMessageBox(Me, "ERROR: A record already exists with " _

& "the same primary key")

Else

ShowMessageBox(Me, "ERROR: Could not add record")

End If

End Try

myCommand.Connection.Close()

MVMain.ActiveViewIndex = -1

End Sub

View 6 Replies View Related

Updating SQL Database

Feb 9, 2008

Hi,

I have designed a Contacts application, where I store all the Contacts in a SQL Database.

Now, I am deploying this application using Visual Studio 2005 Setup and Deployment project.


I might need the update the database with additional Columns etc at a later stage.

How, can I update the SQL Database after it has been deployed on a client computer?


Please assist

Thanks

View 8 Replies View Related

App_Data Database Not Updating.

Mar 21, 2007

This is a weird problem. I added a database to the app_data folder, but when I make updates and then run some reports the updates aren't shown. The database is updated, cause queries show the updates and I inspected the database. The updates however, aren't being reflected when I run the reports.

View 5 Replies View Related

Problems Updating Database

Mar 26, 2007

I have a web project created with VS2005 that is connected to a database on an SQL Server.  I've created a data diagram on the SQL Server and created a matching dataset in my project.  The data diagram has the 'enforce relationship...' and cascade textboxes checked for the table relationships.  My dataset has 'both relation and foreign key constraint' checked with the rules all set to cascade.  The code creates a table adapter then does the tableadapter.Update.  The data gets added to my main table, but not to any of the child tables.  Any ideas on what could be causing this?
Thanks,Rhonda 

View 4 Replies View Related

Updating Site/Database Once It Is Already In Use

Mar 28, 2007

I am wondering how some of you update your database once it is already been in use.  So take for example you have a few tables and users can enter data into the site.  Now suppose you either add tables to the db or you add fields to an existing table.  I am using sql express 2005 and just want to copy the db over with the copy website but it would overwrite any data users entered.Is there any easy solutions or suggestions for this.Thanks 

View 1 Replies View Related

Updating SQL Database - Using DataTable

Jan 8, 2008

I am quite new to ASP.net 2.0. I have had plenty of experience using ADO.net in standard windows applications.
In my app I am opening a connection to an SQL database and I am creating a DataTable without a DataSet:
Shared m_cnADONetConnection As New System.Data.SqlClient.SqlConnection
Shared m_daDataAdapter As System.Data.SqlClient.SqlDataAdapter
Shared m_rowPosition As Integer
Shared m_dtContacts As New System.Data.DataTable
I am initializing everything and filling my DataTable when the Page first Loads if it isnt a postback.Protected Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Form1.Load
If Not Page.IsPostBack Then
m_rowPosition = 0
m_cnADONetConnection.ConnectionString = "Data Source=.SQLEXPRESS;AttachDbFilename=C:First ASP DatabaseApp_DataMyFirstDatabase.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
m_cnADONetConnection.Open()m_daDataAdapter = New System.Data.SqlClient.SqlDataAdapter("Select * From Books", m_cnADONetConnection)m_cbRefillCommand = New System.Data.SqlClient.SqlCommand
m_daDataAdapter.Fill(m_dtContacts)
Me.ShowCurrentRecord()
End IfEnd Sub
The Me.ShowCurrentRecord Sub assigns the values of the current record(row) in the DataTable via (m_rowPosition) to TextBox controls on the form:
I also have record navigation buttons on my form: << < > >> Moving me from record to record (row to row) by incrementing or decrementing m_rowPosition
All is good! I am able navigate the DataTable and the textboxes change their text properties accordingly from record to record.
The only other control on my form is a button which I'm coding its click event to save changes that I made to the current row (record) by changing the values in the textboxes then clicking save.
 Here is my code:Protected Sub ButtonSave_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles ButtonSave.Click
If m_dtContacts.Rows.Count <> 0 Then
m_dtContacts.Rows(m_rowPosition).BeginEdit()m_dtContacts.Rows(m_rowPosition)("Title") = TBTitle.Text
m_dtContacts.Rows(m_rowPosition)("Author") = TBAuthor.Textm_dtContacts.Rows(m_rowPosition)("YearPublished") = TBYearPublished.Text
m_dtContacts.Rows(m_rowPosition)("Price") = TBPrice.Textm_dtContacts.Rows(m_rowPosition)("LastReadOn") = TBLastReadOn.Textm_dtContacts.Rows(m_rowPosition)("PageCount") = TBPageCount.Text
m_dtContacts.Rows(m_rowPosition).AcceptChanges()
m_dtContacts.Rows(m_rowPosition).EndEdit()
m_dtContacts.AcceptChanges()
m_daDataAdapter.Update(m_dtContacts)
End Sub
After I click save I can navigate through my records and back to the one I just changed and updated and all is well. The changes were made in the table.
However, when I close the page and exit out of Visual Web Developer and reopen the database: THE CHANGES WERENT UPDATED!!!
 This worked all the time in VB2005.net when developing a standard windows app.
Can I use the same approach I was using in my code above or am I missing something. 
 
I have read and searched all over and what I'm thinking is that my UpdateCommand, InsertCommand, DeleteCommand, SelectCommand are empty.
Do I have to do it this way?
 
 
 
 
 
 
 

View 1 Replies View Related

Urgent !! Updating DataBase

Jan 19, 2004

Hello all
Can any one help me in updateing the dataBase with the updated datset through the DataGrid
i am able to get the updated dataset from the data Grid but i dont know how to update the database with that
kindly help

View 1 Replies View Related

Error When Updating Database

Oct 28, 2004

Hi all,
I'm getting an error when updating my database. The connection is fine and the dropdown menu is good also so i think it's the way i've formed my sql string. Here's the line i think i'm having probs with:


SQLString = "UPDATE project_descriptions SET " & _
"lecturer_name = '" & Replace(LecturerName.Text,"'","''") & "'," & _
"project_title = '" & Replace(ProjectTitle.Text,"'","''") & "', " & _
"Project_description = '" & Replace(ProjectDescription.Text,"'","''") & "'," & _
" WHERE project_code = '" & ProjectCode.SelectedItem.Value & "'"


Can anyone rearrange it so i stop getting an error?

Here's my code. if it helps.


<%@ Import Namespace="System.Data.OleDb" %>

<SCRIPT language="VB" runat="server">

Dim DBConnection As OleDbConnection
Dim DBCommand As OleDbCommand
Dim DBReader As OleDbDataReader
Dim SQLString As String

Sub Page_Load

If Not Page.IsPostBack Then

'-- Load drop-down list with item numbers
DBConnection = New OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source=C:finalyearproject2projectallocation.mdb")
DBConnection.Open()
SQLString = "SELECT project_code FROM project_descriptions ORDER BY project_code"
DBCommand = New OleDbCommand(SQLString, DBConnection)
DBReader = DBCommand.ExecuteReader()
ProjectCode.DataSource = DBReader
ProjectCode.DataTextField = "project_code"
ProjectCode.DataValueField = "project_code"
ProjectCode.DataBind()
DBReader.Close()
DBConnection.Close()


End If

End Sub

Sub SelectRecord (Src As Object, Args As EventArgs)

DBConnection = New OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source=C:finalyearproject2projectallocation.mdb")
DBConnection.Open()
SQLString = "SELECT * FROM project_descriptions WHERE " & _
"project_code = '" & ProjectCode.SelectedItem.Value & "'"
DBCommand = New OleDbCommand(SQLString, DBConnection)
DBReader = DBCommand.ExecuteReader()
DBReader.Read()
LecturerName.Text = DBReader("lecturer_name")
ProjectTitle.Text = DBReader("project_title")
ProjectDescription.Text = DBReader("project_description")
DBReader.Close()
DBConnection.Close()
UpdateButton.Visible = True

End Sub


Sub UpdateRecord (Src As Object, Args As EventArgs)

'-- CHECK FOR VALID RECORD ---
Dim ValidRecord As Boolean = True

'-- Check for missing Project Title
If ProjectTitle.Text = "" Then
ProjectTitleMessage.Text = "Missing Project Title"
ValidRecord = False
End If

'-- Check for missing Lecturer Name
If LecturerName.Text = "" Then
LecturerNameMessage.Text = "Missing Lecturer Name"
ValidRecord = False
End If

'-- Check for missing Project Description
If ProjectDescription.Text = "" Then
ProjectDescriptionMessage.Text = "Missing Project Description"
ValidRecord = False
End If




If ValidRecord = True Then

'-- UPDATE A RECORD --
Try
DBConnection = New OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source=C:finalyearproject2projectallocation.mdb")
DBConnection.Open()


SQLString = "UPDATE project_descriptions SET " "lecturer_name = '" & Replace(LecturerName.Text,"'","''") & "'," "project_title = '" & Replace(ProjectTitle.Text,"'","''") & "', " "Project_description = '" & Replace(ProjectDescription.Text,"'","''") & "'," " WHERE project_code = '" & ProjectCode.SelectedItem.Value & "'"
DBCommand = New OleDbCommand(SQLString, DBConnection)
DBCommand.ExecuteNonQuery
DBConnection.Close()
UpdateMessage.Text = "Record updated"
Catch
UpdateMessage.Text = "Update problem. Record not changed. " & SQLString
End Try

End If

End Sub


</SCRIPT>

<html>
<head>


<style>
.head {font-family:arial; font-size:12pt; font-weight:bold; width:560px;
border:outset 1 #F0F0F0; padding:2pt; background-color:#990000;
color:#FFFFFF; text-align:center}
.box {font-family:arial; font-size:8pt; line-height:9pt; width:200px;
height:20px; overflow:auto}
.right {text-align:right}
.center {text-align:center}
table {font-family:arial; font-size:8pt; line-height:9pt; width:560px;
background-color:#F9F9F9; border-collapse:collapse}
th {font-family:arial; font-size:8pt; line-height:14pt;
font-weight:bold; text-align:center; vertical-align:bottom;
background-color:#990000; color:#FFFFFF}
td {font-family:arial; font-size:8pt; line-height:9pt;
vertical-align:top}
</style>
</head>

<body>
<form runat="server">

<div class="head">Project Update</div>

<table id="UpdateTable" border="1" rules="rows">
<tr>
<th> Project Code: </th>
<td><asp:DropDownList id="ProjectCode" runat="server"/>
<asp:Button Text="Select" OnClick="SelectRecord" runat="server"/>
</td>
<td></td>
</tr>
<tr>
<th> Lecturer Name: </th>
<td><asp:TextBox id="LecturerName" runat="server"
Columns="40"
MaxLength="50"/></td>
<td><asp:Label id="LecturerNameMessage" runat="server"
ForeColor="#FF0000"
EnableViewState="False"/></td>
</tr>

<tr>
<th> Project Title: </th>
<td><asp:TextBox id="ProjectTitle" runat="server"
Columns="40"
MaxLength="50"/></td>
<td><asp:Label id="ProjectTitleMessage" runat="server"
ForeColor="#FF0000"
EnableViewState="False"/></td>
</tr>

<tr>
<th> Project Description: </th>
<td><asp:TextBox id="ProjectDescription" runat="server"
TextMode="MultiLine"
Columns="45"
rows="3"/></td>
<td><asp:Label id="ProjectDescriptionMessage" runat="server"
ForeColor="#FF0000"
EnableViewState="False"/></td>
</tr>

</asp:Panel>

</table>
<br>
<asp:Button id="UpdateButton" runat="server"
Text="Update Record"
Visible="False"
OnClick="UpdateRecord"/>
<asp:Label id="UpdateMessage" runat="server"
ForeColor="#FF0000"
EnableViewState="False"/>
</form>
</body>
</html>

View 4 Replies View Related

Updating Database Via Webpage

Oct 11, 2006

Hello

I am happy with my mySQL install. I can quite happily created tables and fill them with initial data using mySQL Client

What I want to do now is via a web browser be able to add data to various tables etc. I need to make the web entering part of it as simple as possible for the users.

Cheers

View 3 Replies View Related

SQL Database Tables Are Not Updating

Jun 27, 2007

Although the codes get correctly compiled and executed the tables on the database are not getting updated. I also used the execute sql command manually but it also doesnt work.
:-(
What to do?

View 3 Replies View Related

Database Updating Problem

Nov 24, 2007

Hai to All

I am preparing a desktop application in Visual Basic 2005 with SQL Server 2005(working with Local Database). Regarding application, my client wants to install the same application in office and also in his laptop to work at home. It means the database is installed into two different locations. If any new records are inserted from multiple tables in desktop, then how can i update the data in the laptop, and vice-versa.
My client wants if he work in his laptop at home and bring back the database in his USB. then how can i update the data in the desktop. Even i want to check whether new records has been added in USB database.

Please give me solution for my problem. If possible, please write a code for me.

Is there any possible solution directly with SQL Server 2005 alone?

I am eagerly waiting for your reply.

Thanks.


Yours
Kashif Chotu

View 1 Replies View Related

SQL Express Not Updating Database

Apr 3, 2006

I recently converted a program I made in C# from Access to Sql Server Express and I noticed something odd.

Anytime I update or insert data into the database, it only sticks around until the program closes. I can insert new records but as soon as the program quits, the inserts are gone.

Is this a bug or is there something else I need to do?

View 7 Replies View Related

Updating The Database From The Dataset

Jul 22, 2007

I am having the oddest problem. I can update the data in the dataset, but when I use the update command, or try to do a update manually it will not save the values back to the database.



public void insrtnewtime()

{

int begintime = 00;

int endtime = 23;

int countr;

int _minz;

do

{

begintime = begintime + 1;

string string_begintime_representation = begintime.ToString("00");



//now I have a valid string representations

int _year = 2007;

int _month = 1;

int _day = 1;

int _hour = int.Parse(string_begintime_representation);

_minz = 00;

//need to account for 60 minutes



do

{

//now I need to get a real nice representation to be shown for the visual display

DateTime temptime = new DateTime(_year, _month, _day, _hour, _minz, 0);

//Now I need to strip out just the time, and send it to my stored proc

string stringnewtime_rep_visual = temptime.ToString("t");

string stringnewtime_rep_visual24 = temptime.ToString("HH:mm");



this.tbl_strt_tmesTableAdapter.insrt_strt_times(stringnewtime_rep_visual24, stringnewtime_rep_visual);



_minz += 5;

}

while (_minz < 60);

countr = begintime;

} while (countr < endtime);

this.tbl_strt_tmesTableAdapter.Fill(this.lesson_plannerDataSet.tbl_strt_tmes);

try

{

tbl_strt_tmesTableAdapter.Update(lesson_plannerDataSet.tbl_strt_tmes);//this should save the values

}

catch (Exception e)

{

MessageBox.Show(e.Message);

}









}





the table adapter update, should send the values to the database, but for some reason, it is not. i can see the existing values from the database, along with my new values that i added in my loop, but those values are not being sent to the database when I invoke the update command on the data adapter.

Any help will be greatly appreciated. I am making this program for my wife who is a school teacher.

View 1 Replies View Related

How Do I Upload A MSDE Database

Sep 26, 2006

Downloaded and installed MSDE and just finished creating a
website using the Community Starter Kit.  I'm used to working with Access
Databases and this is my first experience with anything SQL.  Can someone
provide my with some guidance as to what I need to do to upload the MSDE
Database to a server.  Can I just upload the files like an Access Database
or is this more involved.  Thanks for you help.

View 5 Replies View Related

MSDE Database Connections

Nov 13, 2003

I'm using Visual Studio.Net enviroment, i have SQL desktop Engine installed and everything is working great. I have a problem that whenever i create a new database connections i can NOT delete it. I know that i have to select the node containing the connection and then press the DEL Key, but it seems that the delete option is not valid!

Any Suggestion?

View 3 Replies View Related

No Northwind Database In My MSDE...

Apr 6, 2004

OK

I've loaded MSDE and its running OK

I've run config.exe to install the sample .net databases,

......but I cannot find northwind or anyother db on the server!


I've never done any db work befor so may be I'm being a bit of a tit!!! sorry in advance if i am...

stuart

View 3 Replies View Related

New To .net MSDE (database) Question ??

Dec 24, 2004

Hi, I am new to .net, I installed .net sdk and framework.
now I downloaded MSDE and installed it, I got this directory : C:MSDERelA
but when I double click in the setup file nothing happened, please help me on what should I do .
thanks

View 1 Replies View Related

Connection To The Database On MSDE

Mar 10, 2005

Hi,

I installed MSDE and the sample databases with it. They work fine.

Well I am using the server explorer of visaula studio standard 2002. I can see all the sample databases there and connect to them as well.

1.
--------------------------------------------------------------------
Now i created a new database named "testDb" and in a similar fashion i am using windows login thingy.

When i write my connection string in the program now it doesnt work

string connectionStr =@"Server=IMRANNetSDK;" + "Integrated Security=SSPI;" + "Connection Timeout=7;" + "Database=testDB;";

If i replace my Database clause to Northwind it works absolutely fine.

The ERROR it gives is:

Cannot open database requested in login 'testDB'. Login fails. Login failed for user 'IMRANASPNET'.

Why is this happenning? :(.

============================================

2.
-------------------------
How can i configure the MSDE to use the SQL Authentication.
It doesnt allow me to do that?

Thanx Heaps,
Imran

View 2 Replies View Related

Using An MSDE Database In Both ASP And ASP.NET Question

May 13, 2005

I'm running Windows 2003 .NET server (1
year trial) and I have the latest version of MSDE installed. I have
WebMatriX II installed.
I want to create an MSDE database I can use with a DSN so can use in .ASP or APS.NET.
I've successfully created a test
database (in Webmatrix II) via Windows Authentication security and have
created a DSN via ODBC/Windows Authentication security but don't know
how to access in ASP or ASP.NET web page.
All the SQL databases I use in .ASP have a DSN, User, Password as connection parameters. I want to continue this process.
I ran the command list: setup
SAPWD=**secret** SecurityMode=SQL after setting up MSDE SP3. I log into
the server as "Administrator" with a password.
Question:
1. What am I supposed to use as a ID and
Pass if I want to setup a MSDE database in WebMatrix II using SQL
Server authentication? Everything I try fails. I was never asked to
provide a beginning ID and Pass for SQL(MSDE) Server.
2. What does the connection string look
like to access the database in ASP.NET for Windows Authentication
security? Like this: ConnectionString= "server='localhost';
trusted_connection=true; database='ichapter_test'".
3. What would it look like in .ASP?
Thanks in advance!
JurekWorks
 

View 1 Replies View Related

Access To MSDE Database

Jul 27, 2005

HiI am just starting my first .NET project using the web matrix and an MSDE database.  I am pretty much at the limit of my knowledge - all very interesting.  I have some data in an Access spreadsheet (6 columns and 365 rows) which in the past I have copied and pasted into an Access database table.  How do I get it into a MSDE database table?  This process does not need to be automated/programmed as I will only have to do it once a year.  Any ideas on the easiest way forward would be much appreciated.Thanks in advance.Mike

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved