Database

FirstPrevNext

Re: Why update statement in a Stored Procedure is Slow ? sreejith ss nair25-Sep-05 18:42 sreejith ss nair 25-Sep-05 18:42  I don't think simple update will be slow in stored procedure while comparing Queary statement. If you could post the stored procedure code block then we could able to help you out. Sreejith Nair [ My Articles ] Connect two Access Databases vtalau25-Sep-05 15:21 vtalau 25-Sep-05 15:21  My problem is that I don't know how to connect between two databases of MS.Access on two computers. DataSet fill problems Dan Neilsen25-Sep-05 12:08 Dan Neilsen 25-Sep-05 12:08  Hi Guys, What I have is a system that has a single table in a sql dbase and the entire contents of this table are dumped into a dataset via sqldataadapter.fill. Changes to this dataset can be sent back to the dbase fine using the sqldataadapter.update method without any problem as well. Where I am having problems is in the case that a second user adds rows (or alters existing data) in the database, I cannot seem to get this updated data to syncronize with my client's dataset. I am obviously doing something wrong here and I cannot seem to find an example that shows this. Can anyone please give me an example of how to do this? I have wasted a lot of time on something I am sure is very simple. Any help is much appreciated. Re: DataSet fill problems miah alom25-Sep-05 12:53 miah alom 25-Sep-05 12:53  ADO.NET uses disconnected model. In multi user scenario it is not advisable to keep the data in the client side using DataSet. You must use update data in the database as and when needed, i.e. on demand. Re: DataSet fill problems Dan Neilsen25-Sep-05 13:04 Dan Neilsen 25-Sep-05 13:04  So you are saying that at each syncronization I should do the following? - Update the dbase with any changes using the update method. - Empty the dataset - Re-download the entire table contents using the fill method ot the dataset This seems like an awful lot of work downloading for no reason (especially when the table has over 7000 lines). Is there no way to update the dataset contents with changes that have been made in the dbase. The table has an "id" column containing a unique id and a "datemask" column containing a datetime of the rows last update. Can this not be used to determine concurrancy? Re: DataSet fill problems miah alom25-Sep-05 14:29 miah alom 25-Sep-05 14:29  No I am not saying that you should do the synchronization by calling update method. What I am trying to say is that DataSets do not fit well in this scenario. Typically, a screen has a refresh button in this case. And the user presses the button to refresh the data in the data pane which is generally stored in a DataSet. Consider the case when the table has 700000 lines, then what will happen. DataSets are designed to handle low transactional small data. Re: DataSet fill problems Dan Neilsen25-Sep-05 14:41 Dan Neilsen 25-Sep-05 14:41  ok, If datasets are not the best method, what storage method would I use? Probably best if I explain what I am trying to do... Currently I have a php/javascript contacts management system that runs on my companies intranet that I wrote and it currently has approx 7000 contacts in it. The idea of this system is to be a C# application that does exactly the same as the php version but, faster and easier to use. Now, a lot of my users are not local to the dbase server so I was trying to do the following: - Use dataset that syncronizes back to the sql server at regular intervals - Dump dataset to xml & schema for offline content, which would then load locally...and update from dbase server (To save long load times on startup and allow offline editing) I am fairly new to ADO.NET so I must admit to not knowing all the options available. Re: DataSet fill problems miah alom26-Sep-05 3:43 miah alom 26-Sep-05 3:43  DataSets are very heavy. You chould use instead create your own classes to hold and manipulate the the data. The data should be fetched from the database(synchronization) on demand. One question: Why is the client not connecting to the database directly instead on refreshing periodically? If you want to do this in the database side, When you select data from table, you put a lock using the below statement: select * from table holdlock then other users have to wait for this transaction to be completed for update. You can even use isolation level 2 (repeatable read) to keep the consistency. Re: DataSet fill problems Dan Neilsen26-Sep-05 11:50 Dan Neilsen 26-Sep-05 11:50  The reason that I am not designing the system with direct dbase access is that the system will need to be used in offline situations where the user does a syncronization and then goes out on site with a laptop. The user can make changes offline and then, we he/she gets back online, can syncronize. This was the other reason I was looking at datasets due to their ability to dump to xml and schema (and import from same) which I was using for offline cache. I may look into have a table on the dbase that records all changes to any other of the dbase tables hence, rows updated since the last update could be downloaded easily. This might be a way to handle it. Attaching database to SQL server Imtiaz Murtaza25-Sep-05 8:02 Imtiaz Murtaza 25-Sep-05 8:02  Friends, I want to attach a database to SQL server without using Enterprise Manager or query. I have my database file *.mdf in certain directory of my computer. I want to attach it with my SQL server. Is there any way i can attach using regisrty or any file entry or programatically? Imtiaz -- modified at 14:04 Sunday 25th September, 2005 Re: Attaching database to SQL server Dave Kreskowiak25-Sep-05 16:49 Dave Kreskowiak 25-Sep-05 16:49  What are you talking about, "attach a Jet database to SQL Server"? What does this mean? What do you want this to do? SQL Server doesn't really understand Jet databases. You can import the database, but not all the "stored procedures" as Jet understands the concept anyway. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome Change Grid Colum order using Mouse Ammar Ben Hadj Amor25-Sep-05 1:47 Ammar Ben Hadj Amor 25-Sep-05 1:47  hi, i am trying to change DataGrid colum order by using the mouse (Drag and Drop). How can i proceed. thanks Re: Change Grid Colum order using Mouse miah alom25-Sep-05 7:09 miah alom 25-Sep-05 7:09  http://www.codeproject.com/cs/miscctrl/ColumnReorderDataGrid.asp http://www.codeproject.com/cs/miscctrl/ElvinDataGridEx.asp CRYSTAL REPORTS AND JOIN SQL Member 120841225-Sep-05 1:20 Member 1208412 25-Sep-05 1:20  Hi All I have been stuck on this problem for a week and read every example on the web I have 2 tables and I have generated a SQL Join Statement that fills a dataset I display this in a datagrid and all is ok However when I attempt to push this to the crystal reports object I get a cross join which does not have any of the criteria applied The code I execute to generate the dataset is as follows. Two tables concerned are CustomerInvoices and CustomerAccounts PK of CustomerInvoices is: UniqueInvoiceID PK of CustomerAccounts is: UniqueInvoiceID and PaymentNumber Its like a parent- weak entity relationship 1 invoice many accounts sqlstr = " SELECT CustomerInvoices.InvoiceID , CustomerInvoices.CustomerID , " +" CustomerInvoices.CustomerName , CustomerAccounts.DateOfPayment , CustomerAccounts.Payment , " + _" CustomerAccounts.PaymentMethod " + _" FROM CustomerAccounts INNER JOIN " + _" CustomerInvoices ON CustomerAccounts.UniqueInvoiceID = CustomerInvoices.UniqueInvoiceID " Dim Sqladapter As SqlDataAdapter connection = createDatabaseConnection() dim receivablesDataSet = New DataSet("DATASETNAME") Sqladapter = New SqlDataAdapter(sqlstr, connection) Sqladapter.MissingSchemaAction = MissingSchemaAction.AddWithKey Sqladapter.Fill(receivablesDataSet ) Dim newForm As New GenericCrystalViewerForm Dim rpt As New CrystalReport2 rpt.SetDataSource(myDataSet) GenericCrystalReportViewer.ReportSource = rpt I dont want to use XML as it gives me an error saying I have a Invalid Key Node and its driving me crazy All I want to use is the simple setDataSource method. By the way I have used all combinations such as rpt.Database.Tables(1).SetDataSource(myDataSet.Tables(0)) with no luck at all In summary: Instead of getting 95 rowsfor example I am getting 65000 rows which looks like a crossjoin I would appreciate any help please Thanks Touraj How to Create DSN by APIs? shoaibnawaz24-Sep-05 11:02 shoaibnawaz 24-Sep-05 11:02  How to Create DSN by APIs in VB6? Shoaib Nawaz Re: How to Create DSN by APIs? miah alom25-Sep-05 7:06 miah alom 25-Sep-05 7:06  You need to call methods on ODBCCP32.dll SQLConfigDataSource Option Explicit Private Const ODBC_ADD_DSN = 1 ' Add data source Private Const ODBC_CONFIG_DSN = 2 ' Configure (edit) data source Private Const ODBC_REMOVE_DSN = 3 ' Remove data source Private Const ODBC_ADD_SYS_DSN = 4 ' Add a new system data source. 'ODBC_CONFIG_SYS_DSN: Modify an existing system data source. 'ODBC_REMOVE_SYS_DSN: Remove an existing system data source Private Const vbAPINull As Long = 0& ' NULL Pointer Private Declare Function SQLConfigDataSource Lib "ODBCCP32.DLL" (ByVal hwndParent As Long, ByVal fRequest As Long, ByVal lpszDriver As String, ByVal lpszAttributes As String) As Long Public Function AddODBCDSN() Dim strDriver As String Dim strAttributes As String Dim intRet As Long 'since i do not have SQL Server installed.... strDriver = "Microsoft Access Driver (*.mdb)" 'Set the attributes delimited by null. 'See driver documentation for a complete 'list of supported attributes. 'You should use this 'strDriver = "SQL Server" strAttributes = "SERVER=SomeServer" & Chr$(0) strAttributes = strAttributes & "DESCRIPTION=Test DSN" & Chr$(0) strAttributes = strAttributes & "DSN=DSN_TEMP" & Chr$(0) strAttributes = strAttributes & "DATABASE=c:\test.mdb" & Chr$(0) 'strAttributes = strAttributes & "UID=" & Chr$(0) 'strAttributes = strAttributes & "PWD=" & Chr$(0) 'To show dialog, use Form1.Hwnd instead of vbAPINull. intRet = SQLConfigDataSource(vbAPINull, ODBC_ADD_SYS_DSN, strDriver, strAttributes) If intRet Then MsgBox "DSN Created" Else MsgBox "Create Failed" End If End Function Max(NumberFieldName) in SQL Server shoaibnawaz24-Sep-05 10:59 shoaibnawaz 24-Sep-05 10:59  Does Max(NumberFieldName) works in SQL Server? If no then why?? Shoaib Nawaz Re: Max(NumberFieldName) in SQL Server Luis Alonso Ramos24-Sep-05 11:38 Luis Alonso Ramos 24-Sep-05 11:38  Yes, it works. SELECT MAX(Count) FROM MyTable WHERE Date < #1/1/2005# -- LuisR Luis Alonso Ramos Intelectix - Chihuahua, Mexico Not much here: My CP Blog! The amount of sleep the average person needs is five more minutes. -- Vikram A Punathambekar, Aug. 11, 2005 convert interbase database file into sql server database briju24-Sep-05 0:04 briju 24-Sep-05 0:04  convert interbase database file into sql server database My question is that through interbase database i have text file and again i want to convert that file in sql server database or any ms-access database is it possible so what r the steps..... plz reply soon.. brijesh convert interbase database file into sql server database My question is that through interbase database i have text file and again i want to convert that file in sql server database or any ms-access database is it possible so what r the steps..... plz reply soon.. brijesh Formatted emails from SQL Server Member 230181723-Sep-05 20:59 Member 2301817 23-Sep-05 20:59  I am sending emails from SQL Server database. I used sp_send_cdosysmail stored procedure to send emails. I have to pass SMTP Server for this procedure.It works sometime for same SMTP Server name, it does not work sometime. Plz suggest solution for this. Regards Venkat M create/update tbl in MS Access rmarma23-Sep-05 10:17 rmarma 23-Sep-05 10:17  would appreciate any assistance re creating a table in a MS Access database and filling it with data stored in a dataset thanks Re: create/update tbl in MS Access rmarma23-Sep-05 10:18 rmarma 23-Sep-05 10:18  sorry I'm coding in vb.net 2003 Re: create/update tbl in MS Access Yulianto.23-Sep-05 17:42 Yulianto. 23-Sep-05 17:42  Re creating, could you be more specific? There's a lot about this in the web. You just need to look. <italic>Work hard, Work effectively. Re: create/update tbl in MS Access rmarma25-Sep-05 23:06 rmarma 25-Sep-05 23:06  I would like my program to read data from an excel spreadsheet into a data set then manipulate the data and then create a new table in a MS Access database and populate the table with data from the dataset without using ADOX. I cant find examples of a table being filled with a dataset that has data from a different source. any urls (that may assist) would be appreciated Thanks how can i have the record number in query m.rastgar23-Sep-05 7:14 m.rastgar 23-Sep-05 7:14  i have a table with just only 1 column(its type is int) and when i make a query on it i need to have the RECORD NUMBER for every record in resault of query. on the other hands, the query should have two culomns: record number column, the Sumation of table field. i cant have identity column for that table. the table should have only 1 column. sample: table data: 1000 3000 5000 query data: 1 1000 2 3000 3 5000 my DBMS is SQL Server 2000 please help me with this problem. Thanks Rastegar

Last Visit: 31-Dec-99 18:00     Last Update: 2-May-24 23:56 Refresh ᐊ Prev1...2028202920302031203220332034203520362037 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.