SQL Server/Access Import Issue - Database Discussion Boards

Re: Extreme performance issues (SQL Server 2000/ADO.NET/C#)

Jon Rista14-Sep-04 14:26

14-Sep-04 14:26

Hmm....I think I am more confused about the situation now than before. Why would adding a transaction to the process in QA increase the processing time by so much? Originally it took a minute, after adding the transaction it took much longer.

Anyway, I'm adding SET NOCOUNT ON in each sp. I'll play with table locking and see how it helps. I don't think I've run into any deadlock situations, since the queries are all run sequentially, one after the other, and there are currently no other processes happening on the server.

Working with a database

Britnt714-Sep-04 2:17

Britnt7

14-Sep-04 2:17

I am trying to make an address book and am having trouble with certain steps.
Does anyone know where I could find a good example to add, delete,
find, edit, save, and undo changes to an access database? This is my first time creating a project with a database and am having trouble with the concept. An example would be once a user fills in all the text boxes with their info and clicks the save button, do I have to update and add rows to my dataset first and then update the database? That is the confusing part for me. Even just a small example would be great for me to get the overall concept and build on it from there. I am using VB.Net.
Thanks Smile | :)

Beginner in ASP.Net and VB.Net

How to display message when record is not found?

DotNet13-Sep-04 23:00

DotNet

13-Sep-04 23:00

How to display message when the process cannot find the record in the database?

I'm using SQL database.

Please help.

Thanks.

Re: How to display message when record is not found?

Colin Angus Mackay14-Sep-04 2:52

Colin Angus Mackay

14-Sep-04 2:52

DotNet wrote:
How to display message when the process cannot find the record in the database?

That depends on what technology you are using. What is accessing you SQL Server? Or do you just want a message to appear in the Query Analyser?

"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell

Not getting the response you want from a question asked in an online forum: How to Ask Questions the Smart Way!

Re: How to display message when record is not found?

DotNet14-Sep-04 2:59

DotNet

14-Sep-04 2:59

Just a simple datagrid and textbox and search button.

When you enter ID in the textbox,
if the ID is not in the table,
then a label1.visible = true or a prompt message will pop-up.

How to write the condition part when the datagrid is blanked (no data)?

Re: How to display message when record is not found?

Steven Campbell14-Sep-04 4:35

Steven Campbell

14-Sep-04 4:35

label1.Visible = (myGrid.Items.Count > 0);, called sometime after the DataBind().

my blog

Re: How to display message when record is not found?

DotNet14-Sep-04 4:56

DotNet

14-Sep-04 4:56

How can I counter check it when I enter some ID, let's say, ID - P0002 is not in the database. So the datagrid will invisible.

Then, label1.visible = true.

The initial part, I don't understand.
Please help.

SQL Server/Access Import Issue

Ossmer13-Sep-04 21:45

Ossmer

13-Sep-04 21:45

When importing an Access database to SQL Server all the date fields get offset by several days (its uniform but irritating). The formats were changed to long and everything else looks great. Any changes made to the dates after the import continue to reflect the offset. Any suggestions?

Thanks in advance...

Eagles may soar but weasels don't get sucked into jet engines.

New data row in data set- without disturbing IIS !

aBaste13-Sep-04 20:58

aBaste

13-Sep-04 20:58

Hi,

I’m a new to asp.net.
I have module01 to create & fill data adapter and another module02 to add a new data row to data set.

(module02…)
Dim dRow As DataRow = xSet.Tables(0).NewRow
dRow("Login_name") = "Baste"
dRow("pws") = "sindhu"
xSet.Tables(0).Rows.Add(dRow)

Since I put this code inside a command button, button_click submits the page to IIS, which I want to avoid.

Is it possible to execute module2 without submitting the page, if answer is “no”, do a client computer need to maintain consistent connection with IIS while adding a new row in a data set ?so what is disconnected model ? please explain

Advance Thanks

Re: New data row in data set- without disturbing IIS !

Steven Campbell14-Sep-04 8:13

Steven Campbell

14-Sep-04 8:13

When you write ASP or ASP.NET, you are writing server-side code, i.e. the code that you write will execute on the server. If you want to run client-side code, then you have to write that in JavaScript.

In terms of ADO.NET, the disconnected nature of datasets refers to the idea that the data is available after the connection to the database has been closed. It has nothing to do with IIS.

my blog

OdbcDataAdapter OR OleDbDataAdapter

Salil Khedkar13-Sep-04 2:54

Salil Khedkar

13-Sep-04 2:54

I am designing a new application and I don't want to confine it to a specific database system. So when I want to choose a Data adapter in C#.NET, my options are OdbcDataAdapter OR OleDbDataAdapter. Can anybody explain me the different between the two or give me a link where I can learn abut the difference?

Re: OdbcDataAdapter OR OleDbDataAdapter

David Salter13-Sep-04 3:33

David Salter

13-Sep-04 3:33

OleDBDataAdapter is optimized for OleDB data sources, whereas OdbcDataAdapter is optimized for ODBC data sources, so I suppose it depends on which you are using.

The following link form MS gives a bit more info.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon/html/vbcondataadapters.asp[^]

store your internet favourites online - www.my-faves.co.uk

Re: OdbcDataAdapter OR OleDbDataAdapter

Salil Khedkar13-Sep-04 20:43

Salil Khedkar

13-Sep-04 20:43

No, I am sorry. The information with the MSDN page is not sufficient. I have already gone through that.

It just tells me the following difference:
- The OleDbDataAdapter object is suitable for use with any data source exposed by an OLE DB provider.
- The OdbcDataAdapter object is optimized for accessing ODBC data sources.

But does not explain in scenarios where both OLE and ODBC providers are available (e.g. MS SQL Server and Oracle) what should I go for. What are the merits/demerits of each etc.

Re: OdbcDataAdapter OR OleDbDataAdapter

David Salter14-Sep-04 10:59

David Salter

14-Sep-04 10:59

Supposedly OleDb is faster thsn Odbc because it has to go through fewer layers between your application and database.

In my experience however, this hasn't been the case - they appear to be equal, with the Odbc giving better support for Oracle (although Oracle now provide ODP.NET which should adjust things).

If you google for OLEDB v's ODBC, you'll see several discussions of this sort.

http://www.google.co.uk/search?q=OleDB+vs+ODBC&hl=en&lr=&ie=UTF-8&start=0&sa=N

store your internet favourites online - www.my-faves.co.uk

Re: OdbcDataAdapter OR OleDbDataAdapter

cmk14-Sep-04 15:58

cmk

14-Sep-04 15:58

I'm pretty sure the original OLE DB used to call the ODBC drivers.
Now i think both are developed in parallel - neither depends on the other.

I had always heard/thought the opposite, ODBC is a simpler C API design that has fewer layers. I tend to believe this as i've seen internal COM calling diagrams - i can't believe it is a thinner API.

I still consider ODBC to be a cleaner/faster interface, but OLE DB is more abstract - it allows connections to excel spreadsheets, text files, ...

I tend to still use ODBC for most projects. The only place i'm actually using OLE DB right now is for WinCE development - and that's because it doesn't support ODBC.

...cmk

Save the whales - collect the whole set

Re: OdbcDataAdapter OR OleDbDataAdapter

Salil Khedkar14-Sep-04 20:19

Salil Khedkar

14-Sep-04 20:19

Hey thanks Davey... This will help! Rose | [Rose]

Re: OdbcDataAdapter OR OleDbDataAdapter

Salil Khedkar14-Sep-04 22:32

Salil Khedkar

14-Sep-04 22:32

Thanks guys. I got some amount of info but it mainly described the concept behind OLEDB and ODBC technologies, like:

ODBC is Open Data Base Connectivity, which is a connection method to data sources and other things. It requires that you set up a data source, or what's called a DSN using an SQL driver or other driver if connecting to other database types. Most database systems support ODBC.
OLE is Object Linking and Embedding. OLEDB is partly distinguished from OLE itself, now called
"automation".

OLEDB is the successor to ODBC, a set of software components that allow a "front end" such as GUI
based on VB, C++, Access or whatever to connect with a back end such as SQL Server, Oracle, DB2,
mySQL etal. In many cases the OLEDB components offer much better performance than the older ODBC.
OLEDB is a different type of data provider that came about with MS's Universal Data Access in 1996 and does not require that you set up a DSN. It is commonly used when building VB apps and is closely tied to ADO. It works with COM, and DCOM as of SQL 7.0.

However my quetion is more related with the .NET classes provieded for the same. If I don't want to get tied to a specific database, what is the better choice: OdbcDataAdapter OR OleDbDataAdapter in terms of performance and scalability?

RowUpdated event,, info ????

Md Saleem Navalur13-Sep-04 2:44

Md Saleem Navalur

13-Sep-04 2:44

Hi,

Iam using OleDbCommand to insert/update data in the database (SQL 2000).

IS it possible to handle "RowUpdated event" without using OleDbDataAdapter ??

Are there any other methods for handling the updated row event ?

I Need this to get the value of an Auto increment field.

Any help will be greatly appreciated.

Thanx
saleem

CDaoDatabase connect string in Windows XP

olis12-Sep-04 5:34

olis

12-Sep-04 5:34

Hello.

I try to Open CDaoDatabase object in Windows XP (the user has the Excel
2000), and I use the "Excel 8.0" connect string. It returns the following
error "Couldn't Find Installable ISAM". BUT the same code works in Windows
2000. I tried the "Excel 9.0" and "Excel 10.0", but without success...

CDaoDatabase* p_daoDB = NULL;

p_daoDB = new CDaoDatabase;
p_daoDB->Open(_T("SCCardOS.XLS"), // file name
FALSE, // exclusive
FALSE, // read only
_T("Excel 8.0;")); // connect string

I found the post with the same problem, but without solution ;(
I need some tips for solving...

Thank you in advance.

Reporting Service

architechnology.de11-Sep-04 5:00

architechnology.de

11-Sep-04 5:00

In the used Dataset (e. g. 'Dataset1') we have some colums with GUIDs /DSNs.

Within the Report-Layout we want to render the related Values to these GUIDs (e.g. the name to an Adress-GUID), which are kept in another table (e.g. 'adresses').

For example, we used the FoxPro-Report Engine in earlier times and there was a Command named 'SEEK', which pointed the cursor to en other destination! Is there something comparable in Reporting Service or how does it work the best way?

Thanks in advance for help !

Why I Can't update table (dbf)

delemur11-Sep-04 3:29

delemur

11-Sep-04 3:29

Hi. (Firstly, sorry for my English)
I have a set of .dbf files (tables) in directory
I want to work with this files as database with ADO.NET
(c#)
I have no problem when reading data, but I can't change it.
For example, i have a file "test.dbf" in folder "d:\db".
The test.dbf is a table with 2 columns
- CODE (number[4])
- NAME (character[20])
The table has a one record (0,"joan")
I need to add a new record to this table (1,"alex")

Code:

<br />
string TableName		= "test";<br />
string SelectString		= "SELECT * FROM " + TableName;<br />
string DirectoryName	= @"d:\db";<br />
string ConnectString	= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +<br />
	DirectoryName + ";Extended Properties=dBase 5.0;";<br />
<br />
OleDbConnection myConn			= new OleDbConnection(ConnectString);<br />
OleDbDataAdapter myDataAdapter	= new OleDbDataAdapter();<br />
myDataAdapter.SelectCommand		= new OleDbCommand(SelectString, myConn);<br />
<br />
myConn.Open();<br />
<br />
DataSet ds = new DataSet();<br />
myDataAdapter.Fill(ds, TableName);<br />
<br />
DataTable t = ds.Tables[TableName];<br />
<br />
//code to modify data in DataSet here<br />
DataRow dr = t.NewRow();<br />
dr["CODE"] = "1";<br />
dr["NAME"] = "alex";<br />
t.Rows.Add(dr);<br />
<br />
myDataAdapter.Update(ds, TableName); // ERROR OCCURS HERE<br />
myConn.Close();<br />

When I run "Update" method of OleDbAdapter
error occurs.

"Update requires a valid InsertCommand when passed DataRow collection with new rows."

I asked about this problem in russian forums many times,
but nobody can answer me exactly.
I understatnd that I have to specify the InsertCommand of OleDbDataAdapter but how I have to do it I don't.

Could you answer me, what "InsertCommand" must be or (it would be better) give an examle.
Thank you.

Re: Why I Can't update table (dbf)

sreejith ss nair11-Sep-04 23:50

sreejith ss nair

11-Sep-04 23:50

hi,

Here you are trying to update your data table with out any update command.

Suppose if you want to call like this

DataRow dr = t.NewRow();
dr["CODE"] = "1";
dr["NAME"] = "alex";
t.Rows.Add(dr);

myDataAdapter.Update(ds, TableName); // ERROR OCCURS HERE
myConn.Close();

You need to mention the update command. Other wise
it won't update the data.
So first define an update command for your data adapter.
This is also true for Delete, insert etc.

**************************
S r e e j i t h N a i r
**************************

Writing ActiveX Controls

DustinMiles10-Sep-04 11:33

DustinMiles

10-Sep-04 11:33

Are there any good resources out there for learning how to write ActiveX Controls? I am looking primarily for ones dealing with VC++ or C# (although from what I've read, traditional ActiveX isn't possible in managed code, only with .NET Framework installed on the client machine). I have searched a good amount on the web, but have been unsuccessful thus far in finding anything too useful to the Beginner.

Thanks.

Re: Writing ActiveX Controls

Steven Campbell10-Sep-04 18:37

Steven Campbell

10-Sep-04 18:37

This is not really the best forum for this question, but I'll answer as best I can...

By far the easiest language to develop ActiveX controls in is VB6.

You are correct that it is not possible to develop ActiveX controls in managed code (at least without some unsupported hacks). There are .NET equivalents though, both on the ASP.NET side and the WinForms side.

my blog

Is there a performance difference?

Marc Clifton10-Sep-04 8:13

Marc Clifton

10-Sep-04 8:13

between:

SELECT * FROM
Blah1 as T1
INNER JOIN
Blah2 as T2
ON T1.ID=T2.ID
INNER JOIN
Blah3 as T3
ON T1.Id=T3.ID ;

vs.

SELECT *
FROM Blah1 as T1 ,Blah2 as T2,Blah3 as T3
WHERE T1.ID=T2.ID AND T1.ID=T3.ID ;

I've never really understood the advantage of the first syntax, and I'm always using the second syntax.

Marc

MyXaml
Advanced Unit Testing

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