473,795 Members | 2,443 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

CommandType.Sto redProcedure - where defined ?

what using . . . . statement do I need to get this value
(CommandType.St oredProcedure) defined ?

even when I have defined the using statements:

using System;
using System.Data.Sql Client;
using System.Data.Com mon;
using System.Data.Ole Db;
using System.Data.Sql Types;

I still get a compilation error message:

The type or namespace name 'CommandType' could not be found (are you missing
a using directive or an assembly reference?)

thanks,

peteZ
Nov 15 '05 #1
2 10334
using System.Data;
"PeteZ" <pe***@aol.co m> wrote in message
news:Ou******** ******@TK2MSFTN GP11.phx.gbl...
what using . . . . statement do I need to get this value
(CommandType.St oredProcedure) defined ?

even when I have defined the using statements:

using System;
using System.Data.Sql Client;
using System.Data.Com mon;
using System.Data.Ole Db;
using System.Data.Sql Types;

I still get a compilation error message:

The type or namespace name 'CommandType' could not be found (are you missing a using directive or an assembly reference?)

thanks,

peteZ

Nov 15 '05 #2
doh !

(thanks)
"Daniel O'Connell" <on******@comca st.net> wrote in message
news:aQR3b.3009 08$YN5.206546@s ccrnsc01...
using System.Data;
"PeteZ" <pe***@aol.co m> wrote in message
news:Ou******** ******@TK2MSFTN GP11.phx.gbl...
what using . . . . statement do I need to get this value
(CommandType.St oredProcedure) defined ?

even when I have defined the using statements:

using System;
using System.Data.Sql Client;
using System.Data.Com mon;
using System.Data.Ole Db;
using System.Data.Sql Types;

I still get a compilation error message:

The type or namespace name 'CommandType' could not be found (are you

missing
a using directive or an assembly reference?)

thanks,

peteZ


Nov 15 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1016
by: Amol | last post by:
Hello, I am developing an apllication in which i want to change the values of datagrid checkbox column according to parameter passed to the query. But the problem is that, at first time when i usedto send the parameter values it shows me the result ok for first time.But as i change the value of the parameter (taken from textbox on button click) it doesn't show me the appropriate values(not checking the checkboxes appropriately). I am...
9
2207
by: Frank | last post by:
Hi, imagine there's a WEB application reading data from an Oracle database to visualize in using DataGrids in the clients browser. Yes, sounds simple, just create OracleConnection + OracleCommand + DataAdapter, bind a DataGrid to the DataAdapter, that's it. Problem with that approach might be the hardcoded CommandString of the OracleCommand. Whenever somebody requests query string changes you have to adapt the C# code, to recompile and...
1
7119
by: Chris | last post by:
Hi, this code is for stored procdure: comd = New SqlCommand() comd.Connection = connection comd.CommandText = "mysp" comd.CommandType = CommandType.StoredProcedure My question: i also saw when choosing the comd.CommandType in VWD: "TableDirect". What's the purpose of this and how to use it?
2
3035
by: anoopgopal007 | last post by:
Hi friends... I have one problem... I am using C#, and CrystalReport9. In my project I used StoredProcedure with one input parameter. My Problem: I would like to load my report. But It seems lot of errors....
3
17230
by: mnarewec | last post by:
I got a compile error here ! using System; using System.Data.SqlClient; using System.Data.Sql; using System.Collections.Generic; using System.Text; namespace PacSoft class clsUDC
1
1322
by: baburk | last post by:
Hi All, We all are creating Select statement both in View and StoredProcedure In view it virtually links to tables. What is the difference. Thanks in advance
1
1438
by: phanimadhav | last post by:
Hello friends,I have one small doubt.Acually myclient asking by using tableAdapetr call the MySQL procedures.How to call the MySQL storedprocedure in TableAdapter.In the Table adapter contain one options is AddQuery.Actually i am using that option.But i am not getting the createStoreprocedure option(means its not visiblemode).Iam using the existing storedprocedure but i am not getting procedureslist in the ComboBox.So any one please help me .Its...
2
1277
by: Tony Johansson | last post by:
Hello! I just wonder when you use StoredProcedure will you then use DataSet ? In the example that I have seen is the DataSet not used is this normal ? //Tony
1
2103
by: thesti | last post by:
hi, is there anyway to know whether a INSERT/UPDATE/DELETE stored procedured was executed successfully? for example, if i have the following StoredProcedure: create procedure sp_add_employee @userid int, @password varchar(20)
0
9672
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9519
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10438
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10164
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10001
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9042
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6780
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
4113
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3727
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.