Best Way To Update Database?

Mar 13, 2008

I use this code to update a field of my database. is there any better way(smaller, simpler)?

Dim DirId = 1Dim dbPath As String = Server.MapPath("Directory.mdb")

Dim ConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dbPathDim Connection1 As OleDb.OleDbConnection = New OleDb.OleDbConnection(ConnectionString)

Connection1.Open()Dim updateCmd As OleDbCommand = New OleDbCommand("UPDATE Users SET DirUsers = DirUsers + 1 WHERE DirId = " & DirId, Connection1)

updateCmd.ExecuteNonQuery()

Connection1.Close()

View 2 Replies


ADVERTISEMENT

Help Send An Personal Email From Database Mail On Row Update-stored PROCEDURE Multi Update

May 27, 2008

hi need help how to send an email from database mail on row update
from stored PROCEDURE multi update
but i need to send a personal email evry employee get an email on row update
like send one after one email


i use FUNCTION i get on this forum to use split from multi update

how to loop for evry update send an single eamil to evry employee ID send one email

i update like this


Code Snippet
:

DECLARE @id nvarchar(1000)
set @id= '16703, 16704, 16757, 16924, 17041, 17077, 17084, 17103, 17129, 17134, 17186, 17190, 17203, 17205, 17289, 17294, 17295, 17296, 17309, 17316, 17317, 17322, 17325, 17337, 17338, 17339, 17348, 17349, 17350, 17357, 17360, 17361, 17362, 17366, 17367, 17370, 17372, 17373, 17374, 17377, 17380, 17382, 17383, 17385, 17386, 17391, 17392, 17393, 17394, 17395, 17396, 17397, 17398, 17400, 17401, 17402, 17407, 17408, 17409, 17410, 17411, 17412, 17413, 17414, 17415, 17417, 17418, 17419, 17420, 17422, 17423, 17424, 17425, 17426, 17427, 17428, 17430, 17431, 17432, 17442, 17443, 17444, 17447, 17448, 17449, 17450, 17451'
UPDATE s SET fld5 = 2
FROM Snha s
JOIN dbo.udf_SplitList(@id, ',') split
ON split.value = s.na
WHERE fld5 = 3

now
how to send an EMAIL for evry ROW update but "personal email" to the employee



Code Snippet
DECLARE @xml NVARCHAR(MAX)DECLARE @body NVARCHAR(MAX)
SET @xml =CAST(( SELECT
FirstName AS 'td','',
LastName AS 'td','' ,
SET @body = @body + @xml +'</table></body></html>'
EXEC msdb.dbo.sp_send_dbmail
@recipients =''
@copy_recipients='www@iec.com',
@body = @body,
@body_format ='HTML',
@subject ='test',
@profile_name ='bob'
END
ELSE
print 'no email today'


TNX

View 2 Replies View Related

UPDATE SQL Statement In Excel VBA Editor To Update Access Database - ADO - SQL

Jul 23, 2005

Hello,I am trying to update records in my database from excel data using vbaeditor within excel.In order to launch a query, I use SQL langage in ADO as follwing:------------------------------------------------------------Dim adoConn As ADODB.ConnectionDim adoRs As ADODB.RecordsetDim sConn As StringDim sSql As StringDim sOutput As StringsConn = "DSN=MS Access Database;" & _"DBQ=MyDatabasePath;" & _"DefaultDir=MyPathDirectory;" & _"DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;" &_"PWD=xxxxxx;UID=admin;"ID, A, B C.. are my table fieldssSql = "SELECT ID, `A`, B, `C being a date`, D, E, `F`, `H`, I, J,`K`, L" & _" FROM MyTblName" & _" WHERE (`A`='MyA')" & _" AND (`C`>{ts '" & Format(Date, "yyyy-mm-dd hh:mm:ss") & "'})"& _" ORDER BY `C` DESC"Set adoConn = New ADODB.ConnectionadoConn.Open sConnSet adoRs = New ADODB.RecordsetadoRs.Open Source:=sSql, _ActiveConnection:=adoConnadoRs.MoveFirstSheets("Sheet1").Range("a2").CopyFromRecordset adoRsSet adoRs = NothingSet adoConn = Nothing---------------------------------------------------------------Does Anyone know How I can use the UPDATE, DELETE INSERT SQL statementsin this environement? Copying SQL statements from access does not workas I would have to reference Access Object in my project which I do notwant if I can avoid. Ideally I would like to use only ADO system andSQL approach.Thank you very muchNono

View 1 Replies View Related

Trigger To Update One Record On Update Of All The Tables Of Database

Jan 3, 2005

hi!

I have a big problem. If anyone can help.

I want to retrieve the last update time of database. Whenever any update or delete or insert happend to my database i want to store and retrieve that time.

I know one way is that i have to make a table that will store the datetime field and system trigger / trigger that can update this field record whenever any update insert or deletion occur in database.

But i don't know exactly how to do the coding for this?

Is there any other way to do this?

can DBCC help to retrieve this info?

Please advise me how to do this.

Thanks in advance.

Vaibhav

View 10 Replies View Related

Database Create ODBC Connections To Access Database Directly And Update Data?

Sep 10, 2012

We have a SQL database that uses Active Directory with Windows Authentication. Can users that are members of the Active Directory group that has read/write access to the SQL database create ODBC connections to access the database directly and update the data? They dont have individual logins on the server. They are only members of the Active Directory group that has a login?

View 1 Replies View Related

SQL Server 2008 :: How To Update The Database Physical File Location In Master Database

Mar 8, 2015

I had to to relocate the database log file and I issued an Alter database command but by mistake I put a space in the file name as below. The space is at the beginning file name. Now I am unable get the database loaded to SQL Server. The database has 2 replications configured, so deleting and re-attaching the database means the replication needs to be re-configured. Is there an alternative way to issue a command to update the database FILENAME ? Not sure if this can be edited in master database (sys files).

ALTER DATABASE [User_DB]
MODIFY FILE (NAME = User_DB_log, FILENAME = 'I:SQLLogs User_DB_log.ldf')
GO

View 1 Replies View Related

DB Design :: Buffer Database - Insert Information From Partners Then Make Update To Main Database

Oct 29, 2015

I actually work in an organisation and we have to find a solution about the data consistancy in the database. our partners use to send details to the organisation and inserted directly in the database, so we want to create a new database as a buffer database to insert informations from the partners then make an update to the main database. is there a better solution instead of that?

View 6 Replies View Related

Weekly Update Part Of Database With Data From Original Database

Mar 26, 2008

Hi!

I have an original database that I want to copy once to another database. Then I want to update the data weekly with the data of the original database. I don€™t change any tables or columns in that part of the database. Just some tables more in the €˜new€™ database (than the tables from the original database) with some references to the tables that have to be updated weekly.
How can I do this? (if you know what I mean... it's a sort of a datawarehouse where different sources come together.. that part that represents the original database is just a part of the datawarehouse. That part is exactly the same structure as the original database.)

Thanks,

Sandra

View 1 Replies View Related

How Can I Set A Update Trigger On A Table In Database A After A Record Had Been Updated From Another Database B?

Jan 22, 2008



Hi guys, may I know is it possible to create an update trigger like this ? Assuming there are two database, database A and database B and both are having same tables called 'Payments' table. I would like to update the Payments records on database A automatically after Payments records on database B had been updated. I can't use replication because both tables might having different records and some records are the same. Hope can get any assistance here, thank you.

Best Regards,
Hans

View 8 Replies View Related

Integration Services :: How To Insert / Update Table From Database 1 To Database 2

Oct 26, 2015

I am using two database server. Both are sql server. 

My task is :I want to insert data from server 1 table to server 2 table and update same when modified the existing data from server 1. is it possible to do the integration in single package.

I know to do insert and update seperately by ssis but need to do same with single task. 

View 5 Replies View Related

Failed To Update Database C:INETPUBWWWROOTAPP_DATAASPNETDB.MDF Because The Database Is Read-only.

Mar 4, 2006

I'm new to ASP.NET (I normally work with Windows Forms) and have installed the Club Website Starter Kit. I created an Administrators role and a user called "admin". When I run the project locally, everything works as it should - I can log in as admin and I can create new users.
I then copied the site to localhost (C:Inetpubwwwroot), but when I run the site from localhost, I can't log in (as admin or any other user); instead I get a message that says, "Your login attempt was not successful. Please try again."
Also, I can't create a new user. When I try, I get the following error:
Server Error in '/' Application.


Failed to update database "C:INETPUBWWWROOTAPP_DATAASPNETDB.MDF" because the database is read-only.
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.Data.SqlClient.SqlException: Failed to update database "C:INETPUBWWWROOTAPP_DATAASPNETDB.MDF" because the database is read-only.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:



[SqlException (0x80131904): Failed to update database "C:INETPUBWWWROOTAPP_DATAASPNETDB.MDF" because the database is read-only.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +857242
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734854
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +149
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +886
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +415
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +135
System.Web.Security.SqlMembershipProvider.CreateUser(String username, String password, String email, String passwordQuestion, String passwordAnswer, Boolean isApproved, Object providerUserKey, MembershipCreateStatus& status) +3612
System.Web.UI.WebControls.CreateUserWizard.AttemptCreateUser() +305
System.Web.UI.WebControls.CreateUserWizard.OnNextButtonClick(WizardNavigationEventArgs e) +105
System.Web.UI.WebControls.Wizard.OnBubbleEvent(Object source, EventArgs e) +453
System.Web.UI.WebControls.CreateUserWizard.OnBubbleEvent(Object source, EventArgs e) +149
System.Web.UI.WebControls.WizardChildTable.OnBubbleEvent(Object source, EventArgs args) +17
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +163
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102



Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
I figure there must be a simple(?) explanation and solution for this problem, and ideally, some sort of step-by-step procedure that new users to ASP.NET can follow to configure a site - such as one of the starter kits - to work correctly. I can honestly say that trying to get this working has been an extremely frustrating experience.
If someone could help me out, I would really appreciate it. I've been working on this for two days and feeling I have hit the wall.
Thanks in advance.
 

View 1 Replies View Related

Failed To Update Database C:INETPUB... Because The Database Is Read-only.

Mar 28, 2006

Hi there,I am getting a real problem with ASP.NET 2.0, all i am trying to do is run a recovert password (using the login controls) and i got the following error.Does anybody know how to fix this? I have tried the SSEUTIL answer here and it didn't work. http://forums.asp.net/909168/ShowPost.aspxI also ensured that Network Services user has READ/WRITE/EXECUTE premissions on the directory below and that each file isn't read only and also that it inherits ACL from the directory which it seems to do..Bit of strange one this, it isn't created (and i am not using) a beta version of VS 2005 Pro... but a full retail version.The PC is the local PC with IIS 5.1 and VS installed... it is the one i am using for developing.. I don't need to copy my files to the IIS directory below as that is where i have created it and open it in VS 2005 from there..I did read that if you use IIS 5.1 then the user should be ASPNET ... but i don't seem to have that use but a Network Services user...Any help or guidance would be really appreciated... i have come to a stop stage and can't get any further..Thanksian
Server Error in '/igdotcom' Application.


Failed to update database
"C:INETPUBWWWROOTIGDOTCOMAPP_DATAASPNETDB.MDF" because the database
is read-only. 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.Data.SqlClient.SqlException: Failed to update database
"C:INETPUBWWWROOTIGDOTCOMAPP_DATAASPNETDB.MDF" because the database
is read-only.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.

View 3 Replies View Related

How To Update Data From This Database To Orther Database ?

Jun 20, 2007

 
Please help me How to update data from this Database to orther Database ?
Thank

View 5 Replies View Related

Failed To Update Database Because The Database Is Read-only

Mar 31, 2008

hi
i am currently testing my website on IIS7, and first error is that:
Server Error in '/' Application.


Failed to update database "C:INETPUBWWWROOTAPP_DATAASPNETDB.MDF" because the database is read-only.
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.Data.SqlClient.SqlException: Failed to update database "C:INETPUBWWWROOTAPP_DATAASPNETDB.MDF" because the database is read-only.Source Error:



Line 109:
Line 110: conn.Open();
Line 111: SqlDataReader reader = command.ExecuteReader();
Line 112: reader.Close();
Line 113: command.Connection.Close();
i cheked on aspnet_Data folder to see if is read-only AND IT IS, but if i change it, the read-only property is setting up again. why?
thanks in advance

View 1 Replies View Related

Failed To Update Database Because The Database Is Read-only.

Dec 19, 2006

I am building a Windows Forms application in VS 2005, using C# and SQL Server 2005 Express as the backend.



When I try to accessd data from the db, it works with no problems.



When I try to insert/update/delete, I get the following error message



Failed to update database "DBNAME" because the database is read-only.



I am using a connection string with the following syntax:

"Data
Source=.SQLEXPRESS;AttachDbFilename=c:PATH_TO_DBdb.mdf;Database=MyDB;Integrated
Security=False;User Instance=False;User ID=USR;Password=PWD;"



I have made sure that the permissions on the DB are set (in Windows) so
that all users can modify. The user that is logging in to the DB has
status set to DBOWNER.



I have seen others experience the same problem - with ASP.net sites,
not Windows Forms sites (thus most of their solutions dont apply to me)



Any ideas on what is wrong and how I can get this to work?

View 9 Replies View Related

How Can I Update A SQL Database With An Access Database

Feb 14, 2008

I need to update an SQL database with an access database that is built on queries.  I need to do this nightly.
 
Can someone explain how to write the query for this and then I could add it to my nightly maintenance.
 
Thank you
Dee

View 10 Replies View Related

How Can I Update A SQL Database With An Access Database

Feb 14, 2008

I need to update an SQL database with an access database that is built on queries. I need to do this nightly.

Can someone explain how to write the query for this and then I could add it to my nightly maintenance.

Thank you
Dee

View 25 Replies View Related

How Can I Update A SQL Database With An Access Database

Feb 14, 2008


I need to update an SQL database with an access database that is built on queries. I need to do this nightly.

Can someone explain how to write the query for this and then I could add it to my nightly maintenance.

Thank you
Dee

View 9 Replies View Related

DataSet Rows Being Deleted, But After The Update , The Sql Database Is Not Updated. The Delete Rows Still In The Database.

Jun 4, 2007

 Stepping thru the code with the debugger shows the dataset rows being deleted.
 
After executing the code, and getting to the page presentation. Then I stop the debug and start the
page creation process again ( Page_Load ).    The database still has the original deleted dataset rows.
Adding rows works, then updating works fine, but deleting rows, does not seem to work.
 
The dataset is configured to send the DataSet updates to the database. Use the standard wizard to create the dataSet.
 
 
cDependChildTA.Fill(cDependChildDs._ClientDependentChild, UserId);        rowCountDb = cDependChildDs._ClientDependentChild.Count;               for (row = 0; row < rowCountDb; row++)        {           dr_dependentChild = cDependChildDs._ClientDependentChild.Rows[0];           dr_dependentChild.Delete();                      //cDependChildDs._ClientDependentChild.Rows.RemoveAt(0);           //cDependChildDs._ClientDependentChild.Rows.Remove(0);            /* update the Client Process Table Adapter*/          // cDependChildTA.Update(cDependChildDs._ClientDependentChild);      //     cDependChildTA.Update(cDependChildDs._ClientDependentChild);        }
        /* zero rows in the DataSet at this point */        /* update the Child  Table Adapter */       cDependChildTA.Update(cDependChildDs._ClientDependentChild);

View 1 Replies View Related

SQL Update Other Database

May 21, 2007

Hi Y'all,
First of all i want to say that i use c# and visual studio 2005.
I want keep an table in a central database up to date. Those data comes from other databases. I know how i can open connection to those 2.
How should my update statement look like and isn't there a better way than opening 2 databases?
Thanks for your suggestions!

View 10 Replies View Related

Update A Database

Feb 13, 2004

Hi

I am try to update a table in a SQL Server database, but an error keeps occuring.

The error is;

Invalid column name 'Returning'.
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.Data.SqlClient.SqlException: Invalid column name 'Returning'.

Source Error:


Line 41:
Line 42: MyConnection.Open()
Line 43: cmd.ExecuteNonQuery
Line 44: MyConnection.Close()
Line 45:


The code is;

Sub BtnSubmit_click(Sender As Object, e As EventArgs)

Dim MyConnection As SqlConnection = New SqlConnection("server=(local); trusted_connection=true; database=ExamResults")

Dim cmd As New SqlCommand("UPDATE tblStudent SET StudentStatus = " & ReturnForms.SelectedItem.Value & " WHERE (StudentID = " & context.user.identity.name & ") ", MyConnection)

MyConnection.Open()
cmd.ExecuteNonQuery
MyConnection.Close()

end Sub


Any help would be greatly appreciated thanks

View 2 Replies View Related

Update Database

Nov 15, 2004

Hi,

I have a id field in sql database which is of data type bigint. I need to update multiple records in this table. here is my code

sqlBuilder.Append("Update Jobs set Status='Approved' ")
sqlBuilder.Append("Where (ID IN (@SIDs))")

cmdSelect = New SqlCommand
cmdSelect.Connection = connDB
cmdSelect.CommandType = CommandType.Text
cmdSelect.CommandText = sqlBuilder.ToString()
cmdSelect.Parameters.Add("@SIDs", SqlDbType.VarChar, 1000).Value = strSIDsList
cmdSelect.Prepare()
cmdSelect.ExecuteNonQuery()


The value of strSIDsList is "27,29,30,90". I am getting error message "Error: Error converting data type varchar to bigint."

How can I solve this problem?

Thanks!

View 4 Replies View Related

SQL Cannot Update Database

Sep 12, 2007

Guys I have a big problem now. My company is using manual now. since our system failed to update our database. during validation our application gives a message which is successfully save but there's no changes happened. OUr program is working for 1 year and 5 months. Our database size is 4.72 GB and our memory is 1GB. Do you think our problem is inline with memory or the software we used?

View 11 Replies View Related

Trying To Update My Database...............

Jan 8, 2007



hello,

i use the following code to retrieve the contents of the table present in the sql server to be displayed on a datagridview.

SqlConnection sqlCN = new SqlConnection(connectionString);

sqlCN.Open();

string selectCommandText = "SELECT * from test2";

SqlCommand sqlCmd = new SqlCommand(selectCommandText, sqlCN);

sqlCmd.ExecuteNonQuery();

SqlDataAdapter sqlDA = new SqlDataAdapter(selectCommandText, sqlCN);

DataSet DS = new DataSet();

sqlDA.Fill(DS);

DataGridView1.DataSource = DS.Tables[0].DefaultView;



I use the cellContentClick event to modify the contents of dataGridView.

Is it possible for me to update the table directly ie., updating the adapter or table with the corresponding row index and column index so that it will be reflected in the database( if so pls give me a sample code ) or Do i need to retrieve all the values from the datagridview and need to use the sql update command.........

pls reply asap....



-Sweety

View 1 Replies View Related

Database Update Issues

Aug 30, 2006

I have a simple, one table, database to hold an internal telephone
directory.  All is working well, except for the update.  If I
edit a record, and for example, enter a value in a field that is blank,
and then update, nothing happens!  However, if i alter data that
was already in that field and update, the changes take effect!!Any help with this would be gratefully received, Thanks in advance,Vern. 

View 2 Replies View Related

Dataadpater Does Not Update Database

Sep 18, 2006

I hope someone can help me.  My dataadapter will not update my database.  Everything seems to work, and I get no errors of any kind.  But my database is not being touched.  I ran a sql profiler on it and there is no trace of my update.  I can retrieve data just fine, but I cannot get it to update with my onclick event.  Please just point me in the right direction, or any direction would also be cool.Thank you.Here is my code:using System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Data.SqlClient; public partial class WebAdmin_EditNews2 : System.Web.UI.Page{public SqlConnection conn = new SqlConnection("Data Source=vnadbms01;initial catalog=vnawebdev; " +"integrated security=true;persist security info=True;");  public SqlDataAdapter da = new SqlDataAdapter();public DataSet ds = new DataSet();public DataTable dt = new DataTable();   protected void Page_Load(object sender, EventArgs e){if (!IsPostBack){string MsgIDString = Session["MsgID"].ToString(); //Select Parameters:SqlParameter SQLPMsgID = new SqlParameter("@Msg_ID", SqlDbType.Int);SQLPMsgID.Direction = ParameterDirection.Input;SQLPMsgID.Value = MsgIDString;da.SelectCommand = new SqlCommand();//Set Select Commandsda.SelectCommand.Connection = conn;da.SelectCommand.CommandText = "Messages_select";da.SelectCommand.CommandType = CommandType.StoredProcedure;da.SelectCommand.Parameters.Add(SQLPMsgID); da.Fill(ds,"VNA_News");FormView1.DataSource = ds;FormView1.DataBind(); }}   protected void EditButton_Click(object sender, EventArgs e){ //Update parameters:Label sqlprmMsgID = (Label)FormView1.FindControl("Msglbl");SqlParameter SQLPMsgID2 = new SqlParameter("@Msg_ID", SqlDbType.Int);SQLPMsgID2.Direction = ParameterDirection.Input;SQLPMsgID2.Value = sqlprmMsgID.Text;TextBox sqlprmUsrID = (TextBox)FormView1.FindControl("User_IDTextBox");SqlParameter SQLPDeptID = new SqlParameter("@User_ID", SqlDbType.Int);SQLPDeptID.Direction = ParameterDirection.Input;SQLPDeptID.Value = sqlprmUsrID.Text;TextBox sqlprmDept= (TextBox)FormView1.FindControl("Dept_IDTextBox");SqlParameter SQLPUsrID = new SqlParameter("@Dept_ID", SqlDbType.Int);SQLPUsrID.Direction = ParameterDirection.Input;SQLPUsrID.Value = sqlprmDept.Text;TextBox sqlprmBody = (TextBox)FormView1.FindControl("Msg_bodyTextBox");SqlParameter SQLPMsgBody = new SqlParameter("@Msg_body", SqlDbType.Text);SQLPMsgBody.Direction = ParameterDirection.Input;SQLPMsgBody.Value = sqlprmBody.Text;TextBox sqlprmMsgTitle = (TextBox)FormView1.FindControl("Msg_TitleTextBox");SqlParameter SQLPMsgTitle = new SqlParameter("@Msg_Title", SqlDbType.VarChar);SQLPMsgTitle.Direction = ParameterDirection.Input;SQLPMsgTitle.Value = sqlprmMsgTitle.Text;TextBox sqlprmsts = (TextBox)FormView1.FindControl("stsTextBox");SqlParameter SQLPMsgsts = new SqlParameter("@sts", SqlDbType.Int);SQLPMsgsts.Direction = ParameterDirection.Input;SQLPMsgsts.Value = sqlprmsts.Text;TextBox sqlprmexpdat = (TextBox)FormView1.FindControl("Exp_DatTextBox");SqlParameter SQLPExpDat = new SqlParameter("@Exp_Dat", SqlDbType.DateTime);SQLPExpDat.Direction = ParameterDirection.Input;SQLPExpDat.Value = sqlprmexpdat.Text;  //Set Update Commands SqlConnection conn2 = new SqlConnection("Data Source=vnadbms01;initial catalog=vnawebdev; " +"integrated security=true;persist security info=True;");SqlDataAdapter dau = new SqlDataAdapter();dau.UpdateCommand = new SqlCommand();dau.UpdateCommand.Connection = conn2;dau.UpdateCommand.CommandText = "Messages_Update";dau.UpdateCommand.CommandType = CommandType.StoredProcedure;dau.UpdateCommand.Parameters.Add(SQLPMsgID2);dau.UpdateCommand.Parameters.Add(SQLPDeptID);dau.UpdateCommand.Parameters.Add(SQLPMsgTitle);dau.UpdateCommand.Parameters.Add(SQLPMsgBody);dau.UpdateCommand.Parameters.Add(SQLPMsgsts);dau.UpdateCommand.Parameters.Add(SQLPExpDat);dau.UpdateCommand.Parameters.Add(SQLPUsrID);dau.TableMappings.Add("VNA_News", "VNA_News"); dau.Update(ds, "VNA_News");

View 2 Replies View Related

Update Not Writing To Database

Sep 21, 2006

Hello, I am trying to update a few records in my table everything seems to work fine when I hit the submit button. But it does not acutally end up writing to the database... Can someone tell me if they see anything wrong with what I have for code? public void SaveData(){//declare sql connectionSqlConnection SQLConn = new SqlConnection();SQLConn.ConnectionString = base.m_CharterBase.GetSiteKey("EDCCConnectString");SqlCommand Cmd = new SqlCommand();//Open Connections SQLConn.Open();//Set command propertiesCmd.Connection = SQLConn;Cmd.CommandText ="Declare @ID as Int " +"UPDATE [TD_FSCL_PayPeriod] " + "Set [Quota] = @Quota, [LastChangeDate] = getdate(), [LastChangeID] = @LastChangeID, [LastChangeBy] = @LastChangeBy " + " where [ID] = @ID"; //Set parameter valueSqlParameter parmQuota = new SqlParameter();parmQuota.DbType = DbType.Int16;parmQuota.ParameterName = "@Quota";parmQuota.Value = txtQuota.Text; SqlParameter parmLastChangeID = new SqlParameter();parmLastChangeID.DbType = DbType.Int32;parmLastChangeID.ParameterName = "@LastChangeID";parmLastChangeID.Value = Master.curUser.User_ID;SqlParameter parmLastChangeBy = new SqlParameter();parmLastChangeBy.DbType = DbType.String;parmLastChangeBy.ParameterName = "@LastChangeBy";parmLastChangeBy.Value = Master.curUser.Domain_Login; //Add to parameters collectionCmd.Parameters.Add(parmQuota);Cmd.Parameters.Add(parmLastChangeID);Cmd.Parameters.Add(parmLastChangeBy); //Fire the queryCmd.ExecuteNonQuery();//Close ConnectionSQLConn.Close();}  protected void btnSubmit_click(Object sender, EventArgs e){// run save method and then clear methodSaveData();clear_page();}

View 2 Replies View Related

Unable To Update SQL Database

May 11, 2007

I'm using a formview to display, insert and update records and it appears to be working fine except when I try to update anything. It takes the update and goes back to diaply mode but the changes aren't reflected in the data for some reason. It's like I didn't change anything at all.
Here's the SQL statement and parameters (I put elipses in to shorten it of course):...
<body>
<% 'Response.Write(Request.UserHostName)%>
<form id="form1" runat="server">
<div align=center>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:BGHelpdeskConnectionString %>"
OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT RequestID, ReqDate, ReqGSN, ReqName ... FROM tblRequests ORDER BY RequestID DESC" ConflictDetection="CompareAllValues" DeleteCommand="DELETE FROM [tblRequests] WHERE [RequestID] = @original_RequestID AND [ReqDate] = @original_ReqDate AND [ReqGSN] = @original_ReqGSN AND ... [Other] = @original_Other AND [Comments] = @original_Comments" InsertCommand="INSERT INTO [tblRequests] ([ReqDate], [ReqGSN], [ReqName], ... [Other], [Comments]) VALUES (@ReqDate, @ReqGSN, @ReqName, ... @Other, @Comments)" UpdateCommand="UPDATE [tblRequests] SET [ReqDate] = @ReqDate, [ReqGSN] = @ReqGSN, [ReqName] = @ReqName, ... [Other] = @Other, [Comments] = @Comments WHERE [RequestID] = @original_RequestID AND [ReqDate] = @original_ReqDate AND ... [Other] = @original_Other AND [Comments] = @original_Comments">
<DeleteParameters>
<asp:Parameter Name="original_RequestID" Type="Int32" />
<asp:Parameter Name="original_ReqDate" Type="DateTime" />
<asp:Parameter Name="original_ReqGSN" Type="String" />
...
<asp:Parameter Name="original_Other" Type="String" />
<asp:Parameter Name="original_Comments" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="ReqDate" Type="DateTime" />
<asp:Parameter Name="ReqGSN" Type="String" />
<asp:Parameter Name="ReqName" Type="String" />
...
<asp:Parameter Name="Other" Type="String" />
<asp:Parameter Name="Comments" Type="String" />
<asp:Parameter Name="original_RequestID" Type="Int32" />
<asp:Parameter Name="original_ReqDate" Type="DateTime" />
<asp:Parameter Name="original_ReqGSN" Type="String" />
<asp:Parameter Name="original_ReqName" Type="String" />
...
<asp:Parameter Name="original_Other" Type="String" />
<asp:Parameter Name="original_Comments" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="ReqDate" Type="DateTime" />
<asp:Parameter Name="ReqGSN" Type="String" />
<asp:Parameter Name="ReqName" Type="String" />
<asp:Parameter Name="ReqPhone" Type="String" />
... etc
 And here's my formview:1 <asp:FormView ID="FormView1" runat="server" DataKeyNames="RequestID"
2 DataSourceID="SqlDataSource1" Width="800px" BackColor="Transparent" BorderStyle="None" OnItemInserting="FormView1_ItemInserting">
3 <EditItemTemplate>
4 <table id="Table4" cellpadding="10" cellspacing="5" class="Layout" language="javascript"
5 onclick="return TABLE1_onclick()" width="800">
6 <tr>
7 <td bgcolor="#93bde7" colspan="3" style="height: 20px; text-align: right">
8 <asp:ImageButton ID="ImageButton1" runat="server" CommandName="Update" ImageUrl="~/img/btn/check.gif"
9 ToolTip="Submit Form" />
10 <asp:ImageButton ID="ImageButton2" runat="server" CausesValidation="False"
11 CommandName="Cancel" ImageUrl="~/img/btn/x.gif" ToolTip="Cancel Request" /></td>
12 </tr>
13 <tr style="color: #000000">
14 <td rowspan="2" style="width: 400px; text-align: right" valign="top">
15 </td>
16 <td rowspan="2" style="width: 135px" valign="top">
17 Request Type:
18 <br />
19 <asp:RadioButtonList ID="RadioButtonList1" runat="server" SelectedValue='<%# Bind("ReqType", "{0}") %>'>
20 <asp:ListItem>Starter</asp:ListItem>
21 <asp:ListItem>Leaver</asp:ListItem>
22 <asp:ListItem>Mover</asp:ListItem>
23 <asp:ListItem>Ad Hoc</asp:ListItem>
24 </asp:RadioButtonList>
25 </td>
26 <td rowspan="2" style="text-align: right">
27 <img height="77" src="../img/CSBGLogoMed.jpg" width="226" /></td>
28 </tr>
29 <tr>
30 </tr>
31 </table>
32 <br />
33 <table id="Table5" cellpadding="10" cellspacing="5" class="Layout" language="javascript"
34 onclick="return TABLE1_onclick()" width="800">
35 <tr>
36 <td bgcolor="#93bde7" colspan="3" style="height: 20px">
37 </td>
38 </tr>
39 <tr>
40 <td rowspan="2" style="text-align: right; width: 264px;">
41 <asp:Label ID="Label6" runat="server" Text="Legal First Name:"></asp:Label>
42 <asp:TextBox ID="FirstNameTextBox" runat="server" Text='<%# Bind("FirstName") %>' Width="120px"></asp:TextBox>
43 <asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server" ControlToValidate="FirstNameTextBox">*</asp:RequiredFieldValidator><br />
44 <asp:Label ID="Label8" runat="server" Text="Known As:"></asp:Label>
45 <asp:TextBox ID="KnownAsTextBox" runat="server" Text='<%# Bind("KnownAs") %>' Width="120px"></asp:TextBox>
46 <asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server" ControlToValidate="KnownAsTextBox">*</asp:RequiredFieldValidator>
47 <br />
48 <asp:Label ID="Label10" runat="server" Text="Middle Name"></asp:Label>
49 <asp:TextBox ID="MiddleNameTextBox" runat="server" Text='<%# Bind("MiddleName") %>' Width="120px"></asp:TextBox> 
50  <br />
51 <asp:Label ID="Label12" runat="server" Text="Last Name:"></asp:Label>
52 <asp:TextBox ID="LastNameTextBox" runat="server" Text='<%# Bind("LastName") %>' Width="120px"></asp:TextBox>
53 <asp:RequiredFieldValidator ID="RequiredFieldValidator7" runat="server" ControlToValidate="LastNameTextBox">*</asp:RequiredFieldValidator>
54 <br />
55 <br />
56 <asp:Label ID="Label14" runat="server" Text="Global Short Name:"></asp:Label>
57 <asp:TextBox ID="GlobalShortNameTextBox" runat="server" Text='<%# Bind("GlobalShortName") %>' Width="120px"></asp:TextBox>    <br />
58 <br />
59 <asp:Label ID="Label16" runat="server" Text="Employment Type:"></asp:Label>
60 <asp:DropDownList ID="DropDown1" runat="server" SelectedValue='<%# Bind("EmpType") %>' Width=120>
61 <asp:ListItem Value="Employee ">Employee </asp:ListItem>
62 <asp:ListItem Value="Contractor">Contractor</asp:ListItem>
63 </asp:DropDownList><br />
64 <br />
65 <asp:Label ID="Label18" runat="server" Text="Contract Type:"></asp:Label>
66 <asp:TextBox ID="ContractTypeTextBox" runat="server" Text='<%# Bind("ContractType") %>' Width="120px"></asp:TextBox> 
67 <br />
68 <asp:Label ID="Label20" runat="server" Text="Agency:"></asp:Label>
69 <asp:TextBox ID="AgencyTextBox" runat="server" Text='<%# Bind("Agency") %>' Width="120px"></asp:TextBox> 
70 <br />
71 <br />
72 <asp:Label ID="Label22" runat="server" Text="Hire Date:"></asp:Label>
73 <asp:TextBox ID="StartDateTextBox" runat="server" Text='<%# Bind("StartDate") %>' Width="120px"></asp:TextBox> 
74 <br />
75 EndDate:<asp:TextBox ID="EndDateTextBox" runat="server" Text='<%# Bind("EndDate") %>' Width="120px"></asp:TextBox> 
76 </td>
77 <td rowspan="2" style="text-align: right; width: 222px;">
78 Existing Position
79 <asp:CheckBox ID="CheckBox1" runat="server" Checked='<%# Bind("ExistingPosition") %>' Width="120px" /><br />
80 Job Title:
81 <asp:TextBox ID="JobTitleTextBox" runat="server" Text='<%# Bind("JobTitle") %>' Width="120px"></asp:TextBox><br />
82 Department:
83 <asp:TextBox ID="DepartmentTextBox" runat="server" Text='<%# Bind("Department") %>' Width="120px"></asp:TextBox><br />
84 Site Location:
85 <asp:TextBox ID="SiteLocationTextBox" runat="server" Text='<%# Bind("SiteLocation") %>' Width="120px"></asp:TextBox><br />
86 <br />
87 Company Code:
88 <asp:TextBox ID="CompanyCodeTextBox" runat="server" Text='<%# Bind("CompanyCode") %>' Width="120px"></asp:TextBox><br />
89 Cost Center:
90 <asp:TextBox ID="CostCenterTextBox" runat="server" Text='<%# Bind("CostCenter") %>' Width="120px"></asp:TextBox><br />
91 <br />
92 Function Code:<br />
93 <asp:DropDownList ID="DropDown3" runat="server" SelectedValue='<%# Bind("FunctionCode") %>'>
94 <asp:ListItem Selected="True">Select one...</asp:ListItem>
95 <asp:ListItem>Commercial - Brand/Consumer Marketing</asp:ListItem>
96 <asp:ListItem>Commercial - Trade/Customer Marketing</asp:ListItem>
97 <asp:ListItem>Commercial - Marketing - Misc</asp:ListItem>
98 <asp:ListItem>Commercial - Sales - Account Mgmt</asp:ListItem>
99 <asp:ListItem>Commercial - Sales - Field Sales</asp:ListItem>
100 <asp:ListItem>Commerical - Sales - Misc</asp:ListItem>
101 <asp:ListItem>Commercial - Innovation/Activity Mgmt</asp:ListItem>
102 <asp:ListItem>Commercial - Licensing</asp:ListItem>
103 <asp:ListItem>Commerical - Franchise & Export</asp:ListItem>
104 <asp:ListItem>Commercial - Consumer Insight & Resch</asp:ListItem>
105 <asp:ListItem>Supply Chain - General</asp:ListItem>
106 <asp:ListItem>Supply Chain - QEHS (formerly Compliance)</asp:ListItem>
107 <asp:ListItem>Supply Chain - Manufacturing Indirect</asp:ListItem>
108 <asp:ListItem>Supply Chain - Distribution Indirect</asp:ListItem>
109 <asp:ListItem>Supply Chain - Procurement</asp:ListItem>
110 <asp:ListItem>Supply Chain - Manufacturing Direct</asp:ListItem>
111 <asp:ListItem>Supply Chain - Distribution Direct</asp:ListItem>
112 <asp:ListItem>Finance - Strategy</asp:ListItem>
113 <asp:ListItem>Finance - Finance</asp:ListItem>
114 <asp:ListItem>Finance - Business Process Support</asp:ListItem>
115 <asp:ListItem>Finance - Information Technology/RICS</asp:ListItem>
116 <asp:ListItem>Finance - SBS - General</asp:ListItem>
117 <asp:ListItem>Finance - SBS - HR</asp:ListItem>
118 <asp:ListItem>Finance - SBS - Finance</asp:ListItem>
119 <asp:ListItem>Finance - SBS - Customer to Cash</asp:ListItem>
120 <asp:ListItem>Finance - SBS - Corporate Services</asp:ListItem>
121 <asp:ListItem>Human Resources - Human Resources</asp:ListItem>
122 <asp:ListItem>Human Resources - Communications</asp:ListItem>
123 <asp:ListItem>Human Resources - External Affairs</asp:ListItem>
124 <asp:ListItem>Legal</asp:ListItem>
125 <asp:ListItem>Chief Executive's Committee</asp:ListItem>
126 <asp:ListItem>General Management</asp:ListItem>
127 <asp:ListItem>Science & Technology</asp:ListItem>
128 </asp:DropDownList>
129 </td>
130 <td rowspan="2" style="text-align: right">
131 <asp:Panel ID="Panel2" runat="server" Width="100%">
132 Manager:</asp:Panel>
133 <br />
134 <asp:Panel ID="Panel1" runat="server" DefaultButton="MgrNameButton" Width="100%">
135 <asp:TextBox ID="MgrNameTextBox" runat="server" Text='<%# Bind("MgrName") %>' Width="104px"></asp:TextBox>
136 <asp:Button ID="MgrNameButton" runat="server" Text="Check Name" OnClick="ValidateManager" CausesValidation="False" Font-Size="8pt" Width="72px" />
137 <asp:Label ID="MgrNameLabel" runat="server" Text="Label" Visible="False" Width="184px" Font-Size="8pt"></asp:Label></asp:Panel>
138 <br />
139  Phone:
140 <asp:TextBox ID="MgrPhoneTextBox" runat="server" Text='<%# Bind("MgrPhone") %>' Width="120px"></asp:TextBox><br />
141 Email:
142 <asp:TextBox ID="MgrEmailTextBox" runat="server" Text='<%# Bind("MgrEmail") %>' Width="120px"></asp:TextBox><br />
143 <br />
144 Alternate Manager Information:
145 <br />
146 Name:
147 <asp:TextBox ID="AltMgrNameTextBox" runat="server" Text='<%# Bind("AltMgrName") %>' Width="120px"></asp:TextBox><br />
148 Phone:
149 <asp:TextBox ID="AltMgrPhoneTextBox" runat="server" Text='<%# Bind("AltMgrPhone") %>' Width="120px"></asp:TextBox><br />
150 Email:
151 <asp:TextBox ID="AltMgrEmailTextBox" runat="server" Text='<%# Bind("AltMgrEmail") %>' Width="120px"></asp:TextBox><br />
152 <br />
153 HRAdmin:
154 <asp:TextBox ID="HRAdminTextBox" runat="server" Text='<%# Bind("HRAdmin") %>' Width="120px"></asp:TextBox></td>
155 </tr>
156 <tr>
157 </tr>
158 </table>
159 <br />
160 <table id="Table6" cellpadding="10" cellspacing="5" class="Layout" language="javascript"
161 onclick="return TABLE1_onclick()" width="800">
162 <tr>
163 <td bgcolor="#93bde7" colspan="2" style="height: 20px">
164 </td>
165 </tr>
166 <tr>
167 <td rowspan="2" style="width: 246px; text-align: right" valign="top">
168 ComputerType:
169 <asp:DropDownList ID="DropDownList2" runat="server" SelectedValue='<%# Bind("ComputerType") %>' Width=120>
170 <asp:ListItem Selected="True">Use Existing Computer</asp:ListItem>
171 <asp:ListItem>New Desktop Required</asp:ListItem>
172 <asp:ListItem>New Laptop Required</asp:ListItem>
173 </asp:DropDownList><br /> Laptop Bag:
174 <asp:CheckBox ID="CheckBox2" runat="server" Checked='<%# Bind("LaptopBag") %>' Width="120px" /><br />
175 Laptop Dock:
176 <asp:CheckBox ID="CheckBox3" runat="server" Checked='<%# Bind("LaptopDock") %>' Width="120px" /><br />
177 Monitor:
178 <asp:CheckBox ID="CheckBox4" runat="server" Checked='<%# Bind("Monitor") %>' Width="120px" /><br />
179 Printer Type:
180 <asp:TextBox ID="PrinterTypeTextBox" runat="server" Text='<%# Bind("PrinterType") %>' Width="120px"></asp:TextBox><br />
181 Long Distance:
182 <asp:CheckBox ID="CheckBox5" runat="server" Checked='<%# Bind("LongDistance") %>' Width="120px" /><br />
183 SSN5:
184 <asp:TextBox ID="SSN5TextBox" runat="server" Text='<%# Bind("SSN5") %>' Width="120px"></asp:TextBox><br />
185 SAP Midwest:
186 <asp:CheckBox ID="CheckBox6" runat="server" Checked='<%# Bind("SAPMidwest") %>' Width="120px" /><br />
187 SAP Southwest:
188 <asp:CheckBox ID="CheckBox7" runat="server" Checked='<%# Bind("SAPSouthwest") %>' Width="120px" /><br />
189 SAP Mirror:
190 <asp:TextBox ID="SAPMirrorTextBox" runat="server" Text='<%# Bind("SAPMirror") %>' Width="120px"></asp:TextBox><br />
191 SAP Approve:
192 <asp:CheckBox ID="CheckBox8" runat="server" Checked='<%# Bind("SAPApprove") %>' Width="120px" /><br />
193 Margin Minder:
194 <asp:TextBox ID="MarginMinderTextBox" runat="server" Text='<%# Bind("MarginMinder") %>' Width="120px"></asp:TextBox><br />
195 Nextel Type:
196 <asp:TextBox ID="NextelTypeTextBox" runat="server" Text='<%# Bind("NextelType") %>' Width="120px"></asp:TextBox><br />
197 MyCS:
198 <asp:CheckBox ID="CheckBox9" runat="server" Checked='<%# Bind("MyCS") %>' Width="120px" /><br />
199 Notes DB:
200 <asp:TextBox ID="NotesDBTextBox" runat="server" Text='<%# Bind("NotesDB") %>' Width="120px"></asp:TextBox><br />
201 Outlook Email:
202 <asp:CheckBox ID="CheckBox10" runat="server" Checked='<%# Bind("OutlookEmail") %>' Width="120px" /><br />
203 Dept Share:
204 <asp:TextBox ID="DeptShareTextBox" runat="server" Text='<%# Bind("DeptShare") %>' Width="120px"></asp:TextBox><br />
205 Share Point:
206 <asp:CheckBox ID="CheckBox11" runat="server" Checked='<%# Bind("SharePoint") %>' Width="120px" /><br />
207 EPM:
208 <asp:CheckBox ID="CheckBox12" runat="server" Checked='<%# Bind("EPM") %>' Width="120px" /><br />
209 CliqBook:
210 <asp:CheckBox ID="CheckBox13" runat="server" Checked='<%# Bind("CliqBook") %>' Width="120px" /><br />
211 VPN:
212 <asp:CheckBox ID="CheckBox14" runat="server" Checked='<%# Bind("VPN") %>' Width="120px" /><br />
213 Other:
214 <asp:TextBox ID="OtherTextBox" runat="server" Text='<%# Bind("Other") %>' Width="120px"></asp:TextBox><br />
215 </td>
216 <td colspan="1" rowspan="2" style="text-align: right" valign="top">
217 Comments:
218 <br />
219 <asp:TextBox ID="CommentsTextBox" runat="server" Height="367px" Text='<%# Bind("Comments") %>'
220 Width="486px" TextMode="MultiLine" BorderStyle="Solid" BorderWidth="1px"></asp:TextBox><br />
221 <br />
222 </td>
223 </tr>
224 <tr>
225 </tr>
226 <tr>
227 <td background="../img/csbanner.jpg" bgcolor="#93bde7" colspan="2" rowspan="1" style="text-align: left">
228 <asp:ImageButton ID="ImageButton3" runat="server" CommandName="Update" ImageUrl="~/img/btn/check.gif"
229 ToolTip="Submit Form" /> <asp:ImageButton ID="ImageButton4" runat="server" CausesValidation="False"
230 CommandName="Cancel" ImageUrl="~/img/btn/x.gif" />
231 </td>
232 </tr>
233 </table>
234 <asp:ValidationSummary ID="ValidationSummary1" runat="server" BackColor="Yellow"
235 DisplayMode="SingleParagraph" Font-Bold="True" HeaderText="Please fill in the fields indicated with a red asterisk (*)"
236 Width="800px" />
237 </EditItemTemplate>
238 <InsertItemTemplate>
239 ...
240 </InsertItemTemplate>
241 <ItemTemplate>
242 ...
243 </ItemTemplate>
244 </asp:FormView>
 

View 7 Replies View Related

Advice On The Best Way To Update A Database

Jun 17, 2007

Hi,Apologies if this has already been asked, but I couldnt find a thread that asked exactly what I wanted.Im making an administration panel for a site where you can change various settings, options, and categories that data can fall into. When editing, adding or deleting a record i COULD make a trip to the database every time, but this feels very inefficient as I understand that establishing the connection is usually the biggest performance hit when querying a database.An alternative plan is for me to simply record the changes made in the panel and have a "save" button. When this is clicked, ONE database connection would be opened and all the data would be saved/updated/deleted as necessary. However, this would involve several "for" loops while the connection is open.The question is; which method would you recommend and why? And does having several "for" loops while the connection is open nullify the advantage gained by only opening one connection?Any advice would be very much appreciated. Thank you  

View 2 Replies View Related

Update Trigger In Other Database

Jul 15, 2007

I am just a very beginner on using trigger. I get 2 databases A and B. When there is update on A, a trigger will be made on updating B.

here is the trigger i wrote

CREATE trigger update_master_add_charge on master_addition_charge
for update
as
update B.master_addition_charge
set
(acm_desc=?, curr_id=?, charge=?, acm_flag=?, void_flag=?)

the ? should be the value in A... but what shall i write on that?

Is my query correct?

Thanks

View 3 Replies View Related

Update Database With Textboxes

Aug 22, 2007

Hi
 I'm new to all of this. I have a database that holds customer information (fictitious) and i can select that data and display it in a set of textboxes. I also have an SQL command "UPDATE" that is designed to update the text field that i want to edit. However the problem i'm having is that it'll let me write the info in the textbox but as soon as i click my update button it just flashses and goes back to what it says before
 e.g. FIRST NAME: LEE      i enter TOM and then it reverts it back to LEE
  1
2 Partial Class Update
3 Inherits System.Web.UI.Page
4
5 Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
6 custIDTextBox.Text = Session("Label2")
7
8 Dim updatepage As System.Data.DataView = CType(SqlDataSource1.Select(DataSourceSelectArguments.Empty), System.Data.DataView)
9
10 For Each update As Data.DataRow In updatepage.Table.Rows
11
12 firstnameTextbox.Text = update.Item("First Name").ToString
13 lastnameTextBox.Text = update.Item("Last Name").ToString
14 addressTextBox.Text = update.Item("Address Line 1").ToString
15 townTextBox.Text = update.Item("Town").ToString
16 postcodeTextBox.Text = update.Item("Postcode").ToString
17 telephoneTextBox.Text = update.Item("Tel Number").ToString
18
19 Next
20
21 End Sub
22
23 Protected Sub updatebutton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles updatebutton.Click
24
25 'Dim parameters firstnameTextBox, lastnameTextBox, addressTextBox, townTextBox, postcodeTextBox, telephoneTextBox
26 'Dim UpdateParameters As QueryStringParameter
27
28 SqlDataSource1.Update()
29 SqlDataSource1.UpdateParameters.Add("@CustomerDetails", System.TypeCode.String)
30 'SqlDataSource1.UpdateParameters.Add("@Last Name", System.TypeCode.String)
31 'SqlDataSource1.UpdateParameters.Add("@Address line 1", System.TypeCode.String)
32 'SqlDataSource1.UpdateParameters.Add("@Town", System.TypeCode.String)
33 'SqlDataSource1.UpdateParameters.Add("@Postcode", System.TypeCode.String)
34 'SqlDataSource1.UpdateParameters.Add("@Tel Number", System.TypeCode.String)
35
36 'Label2.Text = ("Update successful")
37 End Sub
38 End Class
39

This is my SQL UPDATE command statement:
UPDATE CustomerDetails SET [First Name] = @firstnameTextBox, [Last Name] = @lastnameTextBox, [Address line 1] = @addressTextBox, Town = @townTextBox, Postcode = '@postcodeTextBox', [Tel Number] = '@telephoneTextBox' 
 
 

View 2 Replies View Related

Truncate And Update Sql Database Web From In ASP.NET 2.0

Sep 30, 2007

I have two very simple stored procedures that truncate (clear out) the rows of my 'Transactions' table, then import rows from another table into it, thus updating the table with the appropriate data.
I would like to call these two stored procedures from a web form - asp.net 2.0 web page, using 2 buttons or possibly 1 button if I could, but can't find any information on how to do this.
here is code for:
1.  my button for 'truncate'
<asp:Button ID="Truncate" runat="server" Text="Truncate" style="left: 45px; position: relative; top: -2px" Font-Size="8pt" /><br />
2.  my stored procedure for 'truncate'
ALTER PROCEDURE dbo.TruncateTrans
AS
SET NOCOUNT ON;
Truncate Table Transactions;
 
2.  my button click event and page load event handler for the web form;
 
Imports System.Data
Imports System.Data.SqlClientPartial Class Admin_Default
Inherits System.Web.UI.PageProtected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
End SubProtected Sub Truncate_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Truncate.Click
End Sub
End Class
 
Also, here is my other stored procedure called updateTransact.  how can i execute these using the web form and buttons?  or is there another way to do this?
 
ALTER PROCEDURE [dbo].[UpdateTransAct]
AS
BEGIN
SET NOCOUNT ON;
SELECT *
FROM Transactions INNER JOIN
UpdateTrans ON Transactions.TransID = UpdateTrans.TransID
INSERT INTO Transactions (Account, TransID, TransType, Transkind, Status, Amount, Transdate, Note, Ticker, TickerType, BaseDate, BasePrice, UnitPrice, Shares, UnitsPerContract, Commission, StopTypes, FixedValue, Strategy, WithHolding, SavUnitPrice, SavCommis, ReInvestDividends, ReInvestCapGains, StrategyType, OrderID, ReferenceID, Fees)
SELECT Account, TransID, TransType, Transkind, Status, Amount, Transdate, Note, Ticker, TickerType, BaseDate, BasePrice, UnitPrice, Shares, UnitsPerContract, Commission, StopTypes, FixedValue, Strategy, WithHolding, SavUnitPrice, SavCommis, ReInvestDividends, ReInvestCapGains, StrategyType, OrderID, ReferenceID, Fees
FROM UpdateTrans
WHERE (TransType= 'C' OR TransType='O')
ORDER BY TransDate
END
 
Any help would be appreciated.
Craig
 
 
 
 

View 3 Replies View Related

FAILED TO UPDATE DATABASE

Nov 16, 2007

Server Error in '/' Application.
--------------------------------------------------------------------------------

Failed to update database "D:EPM-MNLSITESERVICESAPP_DATAASPNETDB.MDF" because the database is read-only.
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.Data.SqlClient.SqlException: Failed to update database "D:EPM-MNLSITESERVICESAPP_DATAASPNETDB.MDF" because the database is read-only.

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:


[SqlException (0x80131904): Failed to update database "D:EPM-MNLSITESERVICESAPP_DATAASPNETDB.MDF" because the database is read-only.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +862234
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +739110
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1956
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +149
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +903
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +415
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +135
System.Web.Security.SqlMembershipProvider.ResetPassword(String username, String passwordAnswer) +2226
System.Web.Security.MembershipUser.ResetPassword(String passwordAnswer) +83
System.Web.Security.MembershipUser.ResetPassword(String passwordAnswer, Boolean useAnswer, Boolean throwOnError) +34
System.Web.UI.WebControls.PasswordRecovery.AttemptSendPasswordQuestionView() +352
System.Web.UI.WebControls.PasswordRecovery.AttemptSendPassword() +66
System.Web.UI.WebControls.PasswordRecovery.OnBubbleEvent(Object source, EventArgs e) +101
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +163
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:

Hi Team, I got the error message above, that i run my web application to my IIS Server and i update any record on this eg. i forgot my password, requestng my new password and after that i got the error message. that is read only database.

what can i do regarding this error message to modify and re run my web application operationally

thanks and regards

Ryan

View 2 Replies View Related







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