ASP.NET, SQL Server, WPF, C#, VB.NET

CENTRAL ÚNICA DE VENDAS 
 
10 Marcas de ratreadores, Compare e Compre. 
 
Rastreador de Veículo 
 
Rastreadores de Veículos 
 
Rastreador GPS 
 
Rastreadores GPS 
 
Rastreador Ituran 
 
Rastreadores Ituran 
 
Rastreador Portátil 
 
Rastreadores Portáteis. 
 
Assistência 24 Horas 
 
Visite agora mesmo nosso site. 
 
http://tel011-50523122.vila.bol.com.br/ 
 
Graber - Teletrim - Tele Trim - Ituran - 
 
Rastreadores gps , Localizadores, Bloqueadores 
 
Graber - Teletrim - Tele Trim - Ituran - 
 
Ra ...

-- 
 
hgeron

MSXML5 is confusing. 
 
There should be a simple way, once the DOM is accessed 
 
in an Access module (VB and ADO) to 
 
locate the root node and walk thru each and every 
 
node, element, and attribute... but I have not been able 
 
to figure out the MSXML keywords. 
 
1. Set the DOM 
 
2. find how many nodes 
 
3. for each node ; msgbox the node 
 
4. find how many elements 
 
5. for each element ; msgbox the element 
 
6. find how many attributes 
 
7. for each attribute ; msgbox the attribut ...

my debugger is saying that the ConnectionString property has not been 
 
initialized. when I try to open the connection. My goal is to loop through an 
 
arraylist of objects (OrderModel) and insert a record each time. What am I 
 
missing here? 
 
using (SqlConnection conn = new 
 
SqlConnection(ConfigurationManager.AppSettings["myConnectionString"])) 
 
{ 
 
int counter = 0; 
 
SqlCommand cmd = conn.CreateCommand(); 
 
cmd.Connection.Open(); 
 
foreach (OrderModel ord in NewOrders) 
 
{ 
 
cmd ...

Hi, 
 
Many of my projects in VB currently uses MDAC 2.1. In one of the future 
 
versions, it is decided to use one of the latest versions of MDAC. ie. 
 
MDAC 2.8 
 
One thing I am still unclear about is that, many of the VB projects 
 
have a reference to MDAC 2.1 and would these all need to be updated to 
 
MDAC 2.8 and if so, does changing this reference have any adverse 
 
impact on operation of the software? 
 
Kindly let me know your valuable opinions and suggestions. 
 
Thanks in advance. 
 
sreeraj

I am interested in using strong typed datasets, but I am having some 
 
difficulty with some things and was hoping for a little clarification. 
 
I am using VS 2005 (.net 2) and I start off by creating a Dataset to my 
 
project called MyDataset.xsd. 
 
In my Dataset I added a TableAdapter called Products, which resulted in 
 
the creation of a TableAdapter named ProductsTableAdapter and a 
 
DataTable named Products. 
 
So far so good. 
 
What I thought strongly typed datasets would allow me to ...

I am calling a stored procedure (SP) from Excel, which uses a cursor to 
 
process records and inserts them into other tables. The problem is that the 
 
SP does not return an error back to Excel, when it encounters a Foreign Key 
 
Violation (error level 16). 
 
The ADODB.Connection object does not contain any errors after the SP call: 
 
There is no ADODB.Error in the Errors collection of my connection object, 
 
although I know there were errors! 
 
When I run the SP from SQL Query Analyzer,  ...

I don't even know if I'm in the correct forum for this question, but here 
 
goes.... 
 
Simply put, I want to import data from a .csv file into a Sql table.  The 
 
table already exists in the Sql database and I simply want to dump the data 
 
there. 
 
The file can have the first record as a header record or not: 
 
"Code","Part Number","Price" 
 
"MMM","XYZ23","21.95" 
 
or without header as: 
 
"MMM","XYZ23","21.95" 
 
I have everything working properly, or at least how I want it to work for ...

Hello! 
 
I'm currently working on a Delphi-Application which needs access to 
 
different databases. I found a nice component for using ADO, but i fail to 
 
access the SQL Express server. 
 
The server was installed when i installed Visual C# Express and is usable in 
 
the Visual C# IDE without any problems. 
 
The Delphi-ADO-component uses the official MS-dialog to choose db-provider 
 
and database. The access to a mdb-database works perfect, so i suppose, that 
 
the component works correc ...

Hi, 
 
We have a stored procedure that returns some statistical information to a 
 
VB6 application for display via ADO. SQL Server is version 2000 SP4 and is 
 
clustered (2 nodes) 
 
The stored procedure structure is as follows: 
 
Create procedure upLstXYZ 
 
( @Parm varchar(5) 
 
) 
 
as 
 
begin 
 
set nocount on 
 
select 'Result col 1' as Heading, dbo.fn1(@Parm) as Value 
 
union all 
 
select 'Result col 2', dbo.fn2(@Parm) 
 
union all 
 
select 'Result col 3', dbo.fn3(@Parm) 
 
union al ...

I am cleaning-up a Web application in for someone. Is there a login screen 
 
which requests a UserName and Password. There is no field validation as such 
 
in the login screens, so it is possible to put in as a username "';delete * 
 
from user" which would then be passed as arguments to the SQL query "select 
 
userid from user where 
 
user='<username>' and password='<password>'. Since there are a number of 
 
data fields across the application, does anyone know of a sinple way to clean 
 
an SQL statement. 
 
Thanks, 
 
Rich...

Hello Everybody. I have a Visual C++ app, it reads a SLQ database using ADO, 
 
when the Windows user is admin or power it works fine, but, if the user is 
 
not admin/power ADO can't start, how can I solve this? 
 
Thanks in advance, 
 
William GS

Dim adocon As New ADODB.Connection 
 
Dim AdoRs As New ADODB.Recordset 
 
adocon.Open "Provider......;pwd=" & me.text1.text 
 
adocon.execute "Insert into LocalTable (x,y,z) values (SELECT x1,y1,z1 
 
from   [MS 
 
Access;DATABASE=" & Left(Drive1.Drive, 2) & "\MappedDB.mdb;Pwd='" & 
 
text1.text  & 
 
"'].[MappedTable]" 
 
Error not a valid password 
 
should i use Adox or jet.oledb?

ADO 2.7, SQL Server 2005 
 
We have not changed our code. When migrating from SQL Server 2000 to 2005 we 
 
immediately noticed the following database update pattern start to fail in a 
 
number of areas. 
 
1. A new record is added to a recordset (The record contains an Identity 
 
column) 
 
2. The recordset is posted back to the database (RS.UpdateBatch) 
 
3. A value is changed at the UI 
 
4. The recordset is again posted back to the database 
 
5. > Boom < The BatchUpdate fails - Source ...

I need to transform a data table that would eventually be exported, E.g. 
 
The original table is as follows:  ID     fName     lName 
 
1     Alex         Smith 
 
2     Joe          May 
 
I need it in this "format":  ID       1         2 
 
fName Alex     Joe 
 
lName Smith   May 
 
The column names of the transformed table don't matter. 
 
I have the following code that sort of does it: 
 
private DataTable TransformTable(DataTable dt) 
 
{ 
 
DataTable dtnew = new DataTable(); 
 
// Add the ...

Hello, 
 
I'm trying to understand how ADO TimeOut works really. 
 
I have an component to sets command timeout on 30'', I invoke an complex sp 
 
who implements severals querys and updates (using eventually temporal tables). 
 
Sometimes, I execute that sp and receive the response 2 minutes later 
 
(timeout in 30 seconds). 
 
Using the query analizer I detect that in messages tab, a lot or (1 row 
 
affected) 
 
So, I use SET NOCOUNT ON to don't receive that messanges.  When I execute 
 
the s ...

Hello 
 
I had several SQL scripts, that I used to launch from batch file using isql. 
 
Now I had to move the code from scripts to stored procedures to be able call 
 
them using ADO.NET. What I miss now is the output from SP generated by PRINT 
 
commands (it is what you can see in Query Analyzer in Messages tab, next to 
 
Grids tab if you have chosen Results to Grid). 
 
I haven't found any appropriate method or event on SQLCommand, so I have 
 
only idea to store messages to temporary table ...

I am using System.Data.Oledb, I have oracle function that return the result 
 
as REF Cursor: 
 
CREATE OR REPLACE PACKAGE GET_EMPLOYEES AS 
 
TYPE T_CURSOR IS REF CURSOR; 
 
FUNCTION GetEmployees (userID_in IN VARCHAR2 := NULL) RETURN T_CURSOR; 
 
....... 
 
How to get the result back ? 
 
I've tried: 
 
Oledbconnection cn = new oledbconnection("provider=MSDAORA...... 
 
oledbdataapater da = new oledbdataapater("EMPLOYEES.GetEmployees", cn); 
 
da.selectcommand.add("userID_in", oledbtype.varcha ...

VB6 - ADO 2.7: 
 
Here's the bottom line: When saving a Recordset in XML Format, and then 
 
subsequently Opening a new recordset from the XML DOM, vbCRLF is converted 
 
to vbCR. Bummer. Any way to prevent this? 
 
I've boiled down the problem to one row, one column and two lines of code. 
 
I have a one column recordset. The name of the column is Text. It has one 
 
row. The Text column contains the value (with embedded carriage returns): 
 
Line 1 
 
Line 3 
 
This string is *14* characters l ...

Dear all, 
 
I was wondering if there is an automatic api for adding a section to the 
 
DbProviderFactories (machine.config) or is it necessary to add it via 
 
System.Configuration. In this case, is there any potential security issue ? 
 
Moreover, I use gacutil in order to register my components is it can be done 
 
by a wizard or any other stuff? 
 
Thanks in advance 
 
Yann

Hi 
 
I am currently using vb6 sp5, ActiveX Data Objects 2.5 Library for an access 
 
2000 database file I created. I included partial code (but the most important 
 
code) and where I am running into a problem is the check to see if the record 
 
count is equal to 0.  The problem is when the program gets to the if 
 
statement below it hangs for a long time, considering at the time I was 
 
stepping through the code it had 844,821 records. Now I know I can just skip 
 
the check for the record  ...

Hi, 
 
I'm using ADODB to connect to a SharePoint document library.  I can load a 
 
treeview control perfectly, and I can also create directories and copy files 
 
from Excel forms to SharePoint by adding a new record. 
 
However, if I delete a folder on SharePoint while the Excel file is open, 
 
the treeview is not updated, even though the treeview control in the form is 
 
rebuilt after a clear().  If I close Excel and reopen it, the treeview does 
 
reflect the removed directory. 
 
Also, i ...

I was trying to insert 3Gb binary file to oracle 10g BLOB Field using ADO.Net 
 
The application uses  Oracle Transaction . 
 
Now I have tried to read the file using following code (C#) 
 
string filePath = aFilePath ; 
 
FileStream fls = new FileStream(aFilePath,fileMode.open,FileAccess.Read); 
 
byte[ ] blob = new byte[fls.length] ; // here I am Getting the error 
 
fls.Read(blob,0,System.Convert.ToInt32(fls.Length)); 
 
The error was Arithmetic operation overflow . 
 
After that tried  to de ...

In the MSDN article 
 
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acadvsql.asp, 
 
there is a segment between the topics "User-Level Security" and "Advanced 
 
Data Manipulation Language" on privileges that can be granted or revoked. 
 
One privilege is CREATEDB, which applies to Databases, and "Allows a user to 
 
create a new database." 
 
My question is: How do I create a new, empty Access database programatically 
 
(in C# or [worse case] VB.NET)? 
 
We oft ...

Hi, 
 
I am still using ADO 2.7 to connect to either an MS Access or MS SQL Server 
 
database.  I have a client that is asking about 'encryption for the database 
 
connection from client to server'.  I am not passing any encryption 
 
parameters in the connection string of ADO. 
 
Does anyone know what default encryption is used by ADO 2.7? 
 
I am guessing none? 
 
Thanks for your time, 
 
Regards, 
 
Duncan