Below is my pieces of code.
Code:
Public Class DalOleDb
Public Class DalOleDb
Private _dss As DataSet
Private _daa As OleDbDataAdapter
Private _cnn As OleDbConnection
Private _cmd As OleDbCommand
Private _drr As
mnarewec
Last Activity: Sep 4 '09, 02:39 AM
Joined: Nov 8 '07
Location:
-
VB.NET Execute Multiple SQL Statements using OleDb command
I would like to execute multiple SQL Statement using OleDB command but its coming up with error " Characters found after end of statement"
Below is my pieces of code.
... -
How to convert SQL 2005 Pivot to MS Access SQL
Team here is my SQL Pivot view. I want to convert to MS Access View. Please assist
...Code:USE [cpss] GO /****** Object: View [dbo].[qryRptGateOpener2] Script Date: 10/17/2008 20:41:23 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[qryRptGateOpener2] AS SELECT * FROM (SELECT year(datereceived) AS [Year], alo.branchcode, (((sum(R.qualityscore))
-
Thanks
I want to capture user, time, values before the update, values after the update, of each record that was updated into the dB. Therefore, 3 months down the line I would want to find out who deleted the record, I can pin point the user who did it to the record.
When doing the Update, Delete, and Insert on a single record at a time then it is easier. However, I want to find out how when using DGV and Dataset I can capture... -
C#-App: Audit trail of records updated using DGV bound to a dataset.
Hi Team
I am instructed to keep an audit trail of when a record is updated/deleted/ or inserted.
The user is using a datagridview to update tables which is bound to a dataset.
. How can I capture these audit trail individually by still using datagridview and the dataset update method?
Your help will be greately appreciated.
Marsh -
Thank you so much for all your reply. I will speak with the Management see how we go from there.Leave a comment:
-
Is MS Visual Studio 2005 NET Professional is obsolete?
Hi all
We are starting to migrate our apps from VB6 to .NET. I asked my local software vendor and he said MS 2005 Net Pro is Obsolete.
Is this true?
We just had a course in VS 2005 so we though starting with VS 2005 is best for us instead of 2008 .NET framework.
Please advice. -
Thanks jeffstl
Much appreciated. It works and truly helpsLeave a comment:
-
ASP.NET Create HTML page on the fly based on dB table
Hi all
I am newbie to ASP.NET am facing this problem.
I search the web but I can't seem to find an example of code where I can generate an html file on the fly.
I am reading through a table tblData and perform some calculations, if the calculations fails then I insert the record to a seperate table tblErrors.
At the end of the caculation, I want to read the tblErrors and output its contents [fields]...Last edited by jhardman; Feb 23 '08, 04:31 AM. Reason: moved to .Net forum. ASP forum is for "classic" ASP -
They are all public methods.
Marsh...Leave a comment:
-
C# Multi-Project single solution namespace problem
I have three projects DAL,BOL,UIL they are all in one solution.
The default and the ONLY for namespace project DAL is pacsoft.DAL project BOL is pacsoft.BOL and project UIL is pacsoft.UIL
Now I add a BOL project reference to UIL project and the 'using' statement in the top of UIL class. However I can't see the methods in the Intellisence.
Please assist.
Marsh -
Actually this works.
The input Parameters are actually, properties of the class (i.e. fields of the table). THerefore, eventhough the parameters (properties) are added before the values are being known, when the properties are set later on the parameters values changes and so it works...Leave a comment:
-
Yes you're correct. Right After I post this I found out when I expand the Outlook reference to see its components. Thanks anyway....Leave a comment:
-
Thanks. Yep the Refence for each controls members really helped i.e. MSDN.
lol
Rei MasiLeave a comment:
-
The type or namespace name 'OutLook' could not be found
The type or namespace name 'OutLook' could not be found (are you missing a using directive or an assembly reference?)
Actually I am trying to follow an example shown in the article:
http://support.microso ft.com/kb/895940
but its giving the above error eventhought I add the Reference Microsoft Outlook 11.0 Object library.
I am using VS 2005 Professional Edition.
Here is my code:... -
Visual Studio 2005 IDE for C# class & Methods as in VB
Forgive me if this is a silly question.
I am looking for the option where you can set so that like in VB you can see the methods of controls you design on the form when you view its code.
For example in VB if you have a button1 on the form in the design mode. When you in the code mode (Press F7) you will see two drop downs. One for the class and one for the method. If I select the Button1 class in class drop down List... -
Yes it is. I am using VS 2003...Leave a comment:
-
VB.NET adding command parameters dynamically
Hi folks,
I want to create a procedure where by it will take a sqlcommand, a string, and property.
I want to use this procedure to add parameters to my sql command of type stored procedures since I have a lot parameters to pass into the store procedure.
Here is current my procedure to call store procedure to insert a record:
[CODE=vbnet]Public Function AddPreviousAddr ess() As Integer
Try... -
Thanks so much mrlister. It works....Leave a comment:
-
mnarewec replied to VB.NET SQL stored procedure: procedure has no parameters and arguments were suppliedin .NETI resolved problem me selft
Public Function GetMatterNumber ()
Try
objADO = New clsADO
cnCPSS = New SqlConnection(o bjADO.CxnStr)
cnCPSS.Open()
cmdCPSS = New SqlCommand("Aut omateMatterNumb er", cnCPSS)
cmdCPSS.Command Type = CommandType.Sto redProcedure
cmdCPSS.Paramet ers.Add("@nextM tr",...Leave a comment:
-
C#.NET SQL :'CommandType' does not exist in the current context
I got a compile error here !
using System;
using System.Data.Sql Client;
using System.Data.Sql ;
using System.Collecti ons.Generic;
using System.Text;
namespace PacSoft
class clsUDC
{
//clsADO objADO;
//SqlCommand cmd;
//SqlConnection cnn;
void AddUDC(string sys, string type, string code, string desc)
...
No activity results to display
Leave a comment: