Hi, trying to audit SQL in/out of SQL server from one of our apps which uses NHibernate. Tool I use is SQL Profiler. I noticed a lot of "SELECT" statements using "SQL:StmtCompleted" or "SQL:BatchCompleted" - however, I can't locate the expected UPDATE/DELETE. I do, however, notice a lot of "Un...

Hi ...I wish to populate a DataGrid from a DataReader through Code.My code is some thing like this ...**** CODE ' Buliding Query sql = "SELECT * FROM tbl_Tasks order by tid" ' Opening Connection openConnection() ' Making Command Object Dim cmd...

I try to do it in a simple example.File is present, opend. Data accessable.But no updates executed.And runtime errors are absent too ;_( OleDbConnection mConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=C:\\Tmp.mdb"); OleDbCommand cmd = new Ol...

Hi Everyone,I use the following code to connect to a sql server database and works just fine:dim strCnn as stringstrCnn="server=myServer;database=myDB,userid=myID;password=mypass;"Now I wanted to use variables for the different parameters, so I use the following code:dim strCnn as string, strServer...

Hey guys, we're trying to get a ref cursor back from a PL/SQL procedure, and the procedure function looks like this: PROCEDURE select_recall_history(p_doc_id IN VARCHAR2, p_recall_cv IN OUT recall_cur_typ)ISBEGINOPEN p_recall_cv forSELECT DOCUMENT_ID, DOCNO, documentID, to_char(PROCESS_DATE, &#...

Chennai IT Directory - Code: 0176A pack of excel containing IT Companies Executives IT Training Engineering CollegesFeatures: Contains Name, Company Name, Email, Address, Phone No, Fax, Executive Mobile No, URL Available as different Excel Files in one pack Available in excel Revision: 1....

Renaissance Technologies Offers Quality Database. The database provided goes through a refined filtration to check authenticity of the data. Renaissance Technologies database offering is listed below:1. Bangalore IT Database (Directory)2. Chennai IT Database (Directory)3. Hyderabad IT Database (Dir...

Hyderabad IT Directory - Code: 0177A pack of excel files containing IT Companies Executives IT Training Engineering CollegesFeatures: Contains Name, Company Name, Email, Address, Phone No, Fax, Executive Mobile No, URL Available as different Excel Files in one pack Available in excel File Size:...

Bangalore IT Directory - Code: 0178 IT Companies Executives Engineering Colleges Hardware Vendors IT Training Support Services Cyber Centers Branches Features: Contains Name, Company Name, Email, Address, Phone No, Fax, Executive Mobile No, URL Available as different Excel Files in...

Renaissance Technologies Offers Quality Database. The database provided goes through a refined filtration to check authenticity of the data. Renaissance Technologies database offering is listed below:1. Bangalore IT Database (Directory)2. Chennai IT Database (Directory)3. Hyderabad IT Database (Dir...

hello,i am very new to VC++.Net. i am getting lots of bugs while working withMsAccess Database. Here is my code fragment. i used the Connectionobject from toolbox. so the connection is ok. i am able to retrieve thedata. But i failed to modify (inserting, updating and deleting).DataSet *ds;OleDb::Ole...

Hi,I have an ADOCOMMAND to execute my stored procedure. My storedprocedure contains 6 parameters one of which is a msg which is set by a CString. pcmd->setParm("@cMsg", _variant_t((LPCSTR) m_cstrMsg));If my msg length is <= 128, the ADOCOMMAND executes without any problem. But if is > 128,...

I have the following procedure SET QUOTED_IDENTIFIER ON GOSET ANSI_NULLS ON GO/* ------------------ PROCEDURE: dbo.prc_TransOverride_upd Description: Updates a record In table 'dbo.prc_TransOverride_upd' ------------------ */CREATE PROCEDURE dbo.prc_TransOverride_upd(@Policy_Nbr...

I have an sql table that consist of three key constraints Policy_Nbr, Trans_CodeOrig, Trans_Eff_Date. Now I need to create a stored procedure that will handle violations on the table. What I mean here is that the old values(three key constraints) when I do an update on the table should be included i...

I have the following with an ado.net routine called. Public Sub DoModify() Dim bm As BindingManagerBase = Me.DataGrid1.BindingContext(Me.DataGrid1.DataSource, Me.DataGrid1.DataMember) Dim dr As DataRow = CType(bm.Current, DataRowView).Row Dim editform As New EditTransOverride(dr...

Hi,I am new to Database programming. In the disconnected mode of ADO .NET, programmers use DataSet and DataAdapter classes. Programmer can add DataTable to and remove DataTable from DataSet. But seems to me these changes cannot be passed to data source by using the DataAdapter calss. More specifical...

I am having some un-expected behavoir with some pretty simple/basic stuff. I am working with the MSSQL objects.I am creating a connection. Then creating a DataAdapter. I associate Select/Insert/Update/Delete commands with the DataAdapter. Then I Fill a newly create (ie blank) DataSet with the Ad...

Hi all!!The following code in an ASP.NET web service raises an exception "Object Reference is Not Set to an Instance of an Object".1. OracleDataAdapter da;2. DataSet ds;3. string sql = "Select * from " + ID;4. da = new System.Data.OracleClient.OracleDataAdapter(sql,"user id=<id>;data s...

Dear all,I'm creating a project about creating a web based query builder in which i need to complete this scenario:Like in the enterprise manager view option, whenever a user selects any column names in the table the query for it is automatically generated in the query box The same way in my p...

please remove this question, it was the double submit

A newbies question, sorry.Can some one please tell me if it is possible to know the current row in the dataset table (if this is a correct thing at all). I mean I have a win form with several controls that datasourced to the same table in the dataset. Then when I change the selected item in one cont...

I have a problem. I create a .net aplication whits connect to mysql server (4.1.18). I use .net connector 1.0.7. When i connect from windows xp client mashine it work propertly. But when it works on win 98 se client i have this error message "connection unexpectedly terminated". I dont know why this...

Hello to everyone,I have the following problem.I have one DataAdapter which executes a command in a MS access database.The DataAdapter is used to fill a dataset and this dataset is datasource of a datagrid.The problem is that in the cases that a cell is blank ,in the datagrid it appears to be null.I...

When making an application to run in a browser/server what name spaces can I use? Can I only use the System.Web namespace or can I use any of the .Net features? Will everything in the .Net framework run on a server? Some stuff in the System.Windows namespaces can't be used?

Hi,I want to create a one dimensional datatable with two columns.First column: description of second columnSecond column needs to contain something like pointers to other datatables.Which also means that during runtime I want to create new tables dependant on the received data, how do I name these?K...

Hello all,I hava a dataset filled from an OleDbAdapter.So far I have managed by using the following expression:mydataset->Tables->get_Item(0)->Rows->get_Item(x)->get_Item(y)to take the value in the x row ,y column.The above expression is an Object and I can use toString.The proplem is...

hi,<br/>wha is the diffrence between typed and untyped datasets?

I have a database in MS Access and i have created a windows form which uses Microsoft Jet 4.0 Provider to create with it an OLEDBconnection.When working locally everything is fast but when we tried to work remotely(having installed the database in a pc and connected through the LAN to it from anothe...

How do I receive all the relation from SQL Server database in code? <br/>(When I do FillSchema - the relations is not imported into the DataSet and I need to add them manually).

hi,<br/>how to get errors of dataset which had some errors occured during the updation to the database.<br/>what are the possible practice to avoid this sort of concurrency problems?

i have these 2 lines of code causing problem "object instance not set to an instance of an object vb.net" : dim frm2 as new frm2 frm2.DsGetAllQs.Clear() frm2.SqlDataAdapterGetAllQs.Fill(frm2.DsGetAllQs)i have frmStart, frm1, and frm2. In frmStart, i have...

hi! I want to check whether datatable is empty or not (no of records).. if datatable has no record, I'll show "no record" message. so I need to know no of records in datatable. plz tell me method of datatable for that. greate thanks!...

Hi,I am using visual studio 2003 to create a windows application. It has got a datetimepicker and it is bound to a datecolumn using its text property.I am using the following code to add a new record this.BindingContext[dsEDiary1,"Expenditure"].AddNew();But the problem is,when i try to save the reco...

If I remove some rows mdb file size will not change;<br/>There is compress command in MS Access.<br/>How I can make this operation from my program?<br/>Thanks,<br/>Alex.

Hi!I have installed MSDE 2000 in "Mixed Windows and SQL mode authentication with network access" .following is the command:setup.exe DISABLENETWORKPROTOCOLS=0 SAPWD="password" INSTANCENAME="TempInstance" SECURITYMODE=SQLThen I created the database TempDB in it.When I try to connect this database f...

Hello, I was wondering if Updating Multiple columns using one SQL statement is possible at all??Here is a sample of what I'm trying to do, and it's me a compiler error " two many character in character literal.string strUpdate = "UPDATE TranObjProperty, TranObjPropValue SET TranObjProperty...

Some time back I wrote a program in VB6 using DAO to recognize the version of an Access database. If the value was 3.0, it meant that the database was created using Access 97 and 4.0 would mean that the database was created using Access 2000 or more.The syntax looked like:Dim db As DAO.DatabaseSet d...

Hi all.The old DAO framework has methods to create new tables and adding columns in a database.You can say that the same thing was represented by ADOX in the ADO framework.But when looking at ADO.NET, I can not find anything similar.....In our apps, we conduct upgrades of the database dynamically wh...

hi...i've just started doin this vb.nte and the ado.net stuff..i have used the various tools that are provided by the .net framework for getting connected to the database...but my friends suggest that the odbc api's povide greater facility to deal with databases..since i'm new to .net...

what is the difference b/w using these two api's ...when OledbCommand can alse perform queries on thedatabase...<br/>and is it necessary to use OledbDataAdapter??

Hi gurus,<br/>Is there any code or way to make my web site returned among the top 5 when using a search engine?<br/>Please help.<br/>Regards...

how can i include tools that help me to do spelling corrections??

HiI am busy with a C# Windows application. I load data from a MS Access database into a DataSet. In my database the primary key is an AutoNumber field.When I load the data into the Dataset I add the following event handler to the my OleDBDataAdapter: adapter_MSAccess.RowUpdated += new OleDbRowUpdate...

i started my excel sheet from .net application... i further displayed the database values in this excel sheet...<br/>now is it possible to ensure that if i make any changes to this excel sheet the corrresponding updations take place in database also??

Is it possible to include a MySQL database with my VB.NET application?

Hi,I'm trying to load datatable contents into SQL database table.Both tables (table1 & Table 2) are in different databases.Database :SQL I coded as follows. Didn't work. at the same time not giving errors too.Me.SqlConnection1.Open() SqlDataAdapter2 = New SqlClient.SqlDataAdapte...

hi all,created sql server stored procedure for delete operation named deleteproc.CREATE PROCEDURE DeleteProc (@testId as char)AS DELETE FROM testmaster WHERE testId = @testidGOTable having 3 fields TestmasterTestid char(2)Testdesc char(30)Yearoftest char(4)Following is the errorUpdate requires a va...

I would like to insert records from one dataset to a second dataset. Both have the same schema. I need to do this using VB2005 and the 'Dataset Designer' rather than just coding it. I don't see how to 'link' the two.

I'm New to C#.natAnd I want to insert data from a C# interface to a MS Access DatabaseI coded a sample, but it gives en exception The sample C# file is attachedAnd a Win rar file containing the entire project is also attachedPlease help,It is Extremely Urgent.......

hi...i'm using MySql for my dayabase creation...in caseof microsoft access we get a database file created...this ensures that later we can easily transfer our application having MSAccess databaseto another machine. but how can i do this in case of mysql database.. please advice...