Hi all, I am using C# for ASP.NEt 2003. I would like to know if there is any easy method to update a database with about 100 fields in it. At present, I pass all the values of the controls on the web form to the stored procedure as parameters like :- myCommand.Parameters.Add("@CustomerID", SqlDbType.Int).Value = txtCustomerID.text Like this, I add all 100 parameters. Is there any easy method to do it using a class or any other methods? Thanking you in advance, Tomy
I don't have much experience with writing Sql, which is why i'm not sure. But basically, I have a MSSQL 2005 Database that a person can list a property with, and if the property listing expires by date, the user can relist the listing. The records on the search function are automatically sorted by date, and I want the relisted records to update the datecreated.
I added "DateCreated" to the relisting storedprocedure to change DateCreated to todays date, but I am guessing. Specials = @Specials, ExpirationDate = @ExpirationDate ,DateCreated = GetDate(), DateApproved = @DateApproved, This seems to work, but I just wanted to check to make sure it's in the proper format. Thank you Daniel Meis
I develop with SQL Server 2000 at work. Because I occasionally work athome I also have SQL Server there.Although the data is not all that important, occasionally I make changesto the structures of the tables in my database at work. (n.b. The wholedatabase is well under 20 MB)I was wondering about a quick and convenient method to communicate thosechanges home. I can't use networked replication because of thefirewalls at each end. (Maybe I could, but I don't know how.)Is there any quick and easy way to transfer table structure updates fromhere to home? I have CD-RW available at each end.It would be acceptable, but not necessary to backup/restore the entiredatabase. I'm more interested in a one-button type of solution, ratherthan an "efficient" method.-- Rick
I'm wondering if theres some easy/simple way of getting what would be the connection string if say I was using visual studio? I'm just tired of having to fiddle with a db connection string because i've missed a letter or a comma.
the first line works, but the 2nd line doesn't. I need just the CompanyKey as the table name. Help appreciated. sqlcreate = "CREATE TABLE Company_" + CompanyKey + " (UserID VARCHAR(50), First_Name VARCHAR(50), Last_Name VARCHAR(50), Title VARCHAR(50), Division VARCHAR(50))" sqlcreate = "CREATE TABLE " + CompanyKey + " (UserID VARCHAR(50), First_Name VARCHAR(50), Last_Name VARCHAR(50), Title VARCHAR(50), Division VARCHAR(50))"
Hi, I just have a Dataset with my tables and thats it I have a grid view with several datas on it no problem to get the data or insert but as soon as I try to delete or update some records the local machine through the same error Unable to find nongeneric method... I've try to create an Update query into my table adapters but still not working with this one Also, try to remove the original_{0} and got the same error... Please help if anyone has a solution
The Folowing code is not working anymore. (500 error)
Set objRS = strSQL1.Execute strSQL1 = "SELECT * FROM BannerRotor where BannerID=" & cstr(BannerID) objRS.Open strSQL1, objConn , 2 , 3 , adCmdText If not (objRS.BOF and objRS.EOF) Then objRS.Fields("Exposures").Value =objRS.Fields("Exposures").Value + 1 objRS.update End If objRS.Close
The .execute Method works fine
strSQL1 = "UPDATE BannerRotor SET Exposures=Exposures+1 WHERE BannerID=" & cstr(BannerID) objConn.Execute strSQL1
My manager is interested in knowing if there is a way to update our website's SQL database using a method with excel, similar to importing.
The person who was previously in my position had imported a few hundred new products into the database with an excel spreadsheet.
Now, we would like to make updates such as a price changes or similar adjustments to a number of the products in the database. We could use a web interface, but ours requires us to find each product individually and it takes too much time. I told him that it would probably be necessary to write an SQL statement to update the tables, but we're also interested in maintaining the integrity of the database and are worried about loosing data due to a typo. Is it possible to export the db contents to an excel file, make changes, and then merge those changes into the existing database? I have tried and failed, so I am wondering if any experienced users could help me out.
Also, is there some kind of phpmyadmin for MS SQL? A free, open source alternative would be best.
I have one field organization_operating_name that is on two tables vendor andvendor_locI want to update the vendor name to the vendor_loc nameI tried this but get errors...update vendor_locset organization_operating_name = vendor.organization_operating_namewhere organization_operating_name like 'DO NOT%'Server: Msg 107, Level 16, State 3, Line 1The column prefix 'vendor' does not match with a table name or alias nameused in the query.vendor is a valid table name...so I must be missing something.jeff--Message posted via http://www.sqlmonster.com
Hello,I have 2 ways of updating data I'm using often1) via a cursor on TABLE1 update fields in TABLE22) via an some of variables ...SELECT @var1=FLD1, @var2=FLD2 FROM TABLE1 WHERE FLD-ID = @inputVARUPDATE TABLE2SET FLDx = @var1, FLDy = @var2WHERE ...Now I have a system with 2 databases and I need to update table DB2.TABbased on data in DB1.TAB. Instead of using 1 of the 2 ways I normally use,I thought it would be much easier to get the required data immediately fromDB1.TAB in the update-statement of DB2.TAB ... but the way to do thatconfuses me. I've checked books online and a lot of newsgrouppostingsgiving good information but still I keep getting errors like this ...The column prefix 'x.ADS' does not match with a table name or alias nameused in the query.while executing the following statement ...UPDATE DB2.dbo.TABSETFLD1 = x.FLD1,FLD2 = x.FLD2,...FROM DB1.dbo.TAB x, DB2.dbo.ADSWHERE DB2.dbo.TAB.REFID = x.IDOFTAB1 AND DB2.dbo.TAB.IDOFTAB2 =@InputParameterSo in DB2.TAB I have a field REFID reffering to the keyfield IDOFTAB1 oftable DB1.TABAND I only want to update the row in DB2.TAB with the unique keyfieldIDOFTAB2 equal to variable @InputParameterDo you see what I'm doing wrong?--Thank you,Kind regards,Perre Van Wilrijk,Remove capitals to get my real email address,
I have a column of values in one table that needs to be updated based on an adjustment factor in another table. The table which contains the adjustment factors is built with the following column names.
RangeBeg RangeEnd Factor
The factor is determined depending on where the value falls in the range. I have been trying to do an sql script with no luck. Any Help would be appreciated.
Hi All, i want to use sqldatasource with controlparameters.there are some textboxes and a dropdownlist on my page.i can easily insert and delete records on database table by using these controls as controlparameters by sqldatasource insert() and delete() method but updating fails.i use try catch block to see the error but no errors found.And also update() method returns 1 that indicates that it worked fine but when i look into the database i see that the record is not updated.i am stucked and surprised.any ideas please? Thanks
I have a gridview and a dataset. When I start my application I see the results in my gridview. When I clic on edit and chanche some value and click on update it wil give me this error:ObjectDataSource 'ObjectDataSourcePersoon' could not find a non-generic method 'Update' that has parameters: naam, tussenvoegsel, achternaam, adres, woonplaats, telefoonnummer, original_id, Original_naam, Original_tussenvoegsel, Original_achternaam, Original_adres, Original_woonplaats, Original_telefoonnummer. Does someone know whats the problem??
Hi guys,I followed the ASP.net official tutorial to create a DAL & Business Logic Layer (http://www.asp.net/learn/dataaccess/tutorial02cs.aspx). I have a table with a int ID field. I wish to write a function to add a new entry into this table but have the ID field auto-increment.The ID field is set as the Identity Column and has a Identity Increment & Seed of "1". If I manually go to the table and insert a new record leaving the ID value null it automatically increments. But if I create a C# function to add a new entry I get an error saying that the ID field can't be Null. Is there any way to use the Update method as shown on line 14 below to add a new entry but with it automatically incrementing? I did create a function called InsertDevice that simply inserts the other fields using a SQL INSERT and it auto-increments fine, just wondering if there is a way to do it using the DataTable and the Update method? Thanks for any help!!! 1 public bool AddDevice(string make, string model) 2 { 3 //cannot have the same device entered twice! 4 if (Adapter.FillDeviceCountByMakeModel(make, model) == 1) 5 return false; 6 7 RepositoryDataSet.DevicesDataTable devices = new RepositoryDataSet.DevicesDataTable(); 8 RepositoryDataSet.DevicesRow device = devices.NewDevicesRow(); 9 10 device.make = make; 11 device.model = model; 12 13 devices.AddDevicesRow(device); << Error thrown Here! 14 int rows_affected = Adapter.Update(devices); 15 16 return rows_affected == 1; 17 }
I'm new on this forum, but, I'm a experienced programmer. I wanna solve this problem (if you can helpme....), recently, I'm trying to migrate an old SQL 7 to the new SQL 2005 server enterprise edition, I have no problem to import the data, users, stored procedures, etc. and all work fine, I can connect troght ODBC from the others computers, including some older pentium 1 mmx 200 mhz. with WIN98 (yes!).
My problem is an legacy VB6 application that work (well fine) with SQL7 server, but, when i change the odbc of the desktops systems to the new 2005 SQL server and run this legacy application hi recibe this error: (english translation from spanish language)
[ODBC SQL Server Driver][SQL Server] The table to be modified is not included on this cursor or these can't be modified throught this cursor.
I have look on the source code of the legacy application, and someone of the segment's that causes error is:
Public Function ConsultaCamara(sRutOP As String, _ sRut1 As String, _ strConsulta As String, _ Tipo As String, _ chk As CheckBox, _ Timer1 As Timer, _ LbAviso As Label) As Long '---------------------------- Dim rsCACH, rsCACH_upd0, rsCACH_upd1, rsCACH_upd2 As ADODB.Recordset Dim CmCACH As ADODB.Command Dim lPendiente As Boolean Dim lActivo As Boolean Dim strSQL1, strSQL_upd0, strSQL_upd1, strSQL_upd2 As String Dim StrWHE As String Dim DameTiempo As Integer Dim snombre As String Dim sMsgEstado As String Dim sAviso_Inicial As String Dim cNum As String Dim cDig As String ... ... ... 'Defino el string de consulta strSQL1 = " SELECT RUTOPERADOR, " & _ " IDCAMARA, " & _ " RUTCONSULTADO, " & _ " ESTADO, " & _ " CANCON, " & _ " CADENACONSULTA, " & _ " FINGRESO, " & _ " FULCONSINT, " & _ " ULTRUTOP " & _ " FROM BOLETIN " & _ " WHERE RUTCONSULTADO = '" & sRut1 & "'" & _ " AND (ESTADO = 'PE' OR ESTADO = 'AC' )"
Set rsCACH = CreateObject("ADODB.Recordset") rsCACH.ActiveConnection = cn rsCACH.CursorType = adOpenKeyset rsCACH.LockType = adLockOptimistic rsCACH.Open strSQL1 If rsCACH.EOF Then 'No hay registro antiguo o en consulta, creo uno para consultar sMsgEstado = "NO Existen datos ES REGISTRO NUEVO" & vbCr rsCACH.AddNew ConsultaCamara = GeneraID() rsCACH.Fields("IDCAMARA") = ConsultaCamara rsCACH.Fields("RUTOPERADOR") = sRutOP rsCACH.Fields("RUTCONSULTADO") = sRut1 rsCACH.Fields("ESTADO") = "PE" rsCACH.Fields("CANCON") = 1 rsCACH.Fields("CADENACONSULTA") = strConsulta rsCACH.Fields("FINGRESO") = GetDateTime() 'Format(Date, "Short Date") rsCACH.Fields("FULCONSINT") = GetDateTime() 'Format(Date, "Short Date") rsCACH.Fields("ULTRUTOP") = sRutOP rsCACH.Update <----- here's launches the error ... ... ...
I'm creating my first Report Model and I've managed to get through it, but if I select the "Update model statistics before generating" in the "Report Model Wizard", I get this error:
"Specified method is not supported"
(It would be a little less frustrating if it actually HAD specified the method <s>)
Like the subject says, I'm using strongly typed datasets. I'm using to designer to create the datasets and the methods. I can select and insert, but I can't update or delete. I right click on the adapter bar and select Add Query. I sleect 'Use SQL Statements'I select 'Update' (or 'Delete')I get a sql statement pane containing the word 'Update' ('Delete') and asking 'What data should the table load?'I can click on next, but anything else gives me errors. I'd list them, but I'm clearly doing something wrong and it's probably obvious. Diane
Hi,I am trying to write a method which needs to call a stored procedure and then needs to get the response of the stored procedure back to the variable i declared in the method. private string GetFromCode(string strWebVersionFromCode, string strWebVersionString) { //call stored procedure } strWebVersionFromCode = GetFromCode(strFromCode, "web_version"); // is the var which will store the response.how should I do this?Please assist.
I have to implement some logic in a view and I don't know how to do it. Let me outline the logic:
- I'm working with a view where records represent participant activities. - Some participants can have numerous activities. - Each activity has a start date and an activity code. - Only records with activity code 23 or 33 appear in the view currently.
What I need to do is NOT include records where the participant has another activity with code 26 (from another table, the one the current view is derived from) which has the same start date as the activity 23/33 record in the view currently. Also, this should only be implemented if the start date is the first start date (minimum start date for that participant).
I've noticed that there are a lot of questions on this forum, but not as many thank you's. I'm far from a DBA (more of a simple, small town, one stop shop), but have learned tons of information from reading your posts. I certainly appreciate everyone's willingness and excitment to contribute to the SQL community. So here's to you...thank you!
What am i doing wrong with this im tired and for the life of me it wont work Cheers Phil
if (Select sum(Unitprice*qtysold) from #DataExport_tmp where recordtype = 'L'group by transref )<> select Totalcost from #DataExport_tmp where recordtype = 'T' BEGIN PRINT 'no good' end
i use windows vista and installed visual net 2005 and sqlserver 2005 but i have some proplem: my step: 1.open vs net 2005 2.make one project 3.make one button 4.get data->datagridview 5.choose add data source 6.choose new data---> this step then choose microsoft sql server 7.typing servername 8.choose attach a database file and choose browe.. 9.link to folder have database(.dbf) but i have worked them very much but not run for me i dont know why it is like that
"login faild"or you dont have permission to pen this filecontact the file ower or an administrator to obtain permissio
pls help me i very need for learning
my Y!M: phok28a@yahoo.com pls contact me and help me
