inline classes support in enterprise services

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Ado
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - SqlParameter for IN-Clausel (int values)? Hi Ng, i have a sucking problem...... select * from test where nId IN (1, 2, 3) Now i want to execute this with an sqlcommand and more interesting with an sqlParameter: sqlCommand.CommandText = select * from test where nId in (@IN-Values)"; I first tried: SqlParameter sqlParameter = new SqlParameter("@Values", "1, 2, 3"); Exeption: Syntax error converting the nvarchar value '1, 2, 3' to a column of data type int This is very logical. But how can i do? I then tried to use an int32 array or an arraylist with int values: int[] test = new Int32[] {1, 2, 3}; ArrayList test2 = new ArrayList(); test2.Add(1); test2.Add(2); SqlParameter sqlParameter = new SqlParameter("@Values", test); SqlParameter sqlParameter = new SqlParameter("@Values", test2); This didn't work, too. I cannot give an array or arraylist to a parameter as value. How can i resolve my problem? I don't want to do without sqlparameter and i only want ONE sqlparameter! Is it impossible? Thanks, Roland Tag: inline classes support in enterprise services Tag: 118384
  - 2
    - System.Data.OracleClient requires Oracle client software version 8 I can't seem to connect to my Oracle DB. I have Oracle 9.2 installed on another server to which I have mapped my local drive 'u' to. I have u:/ora92_oem in my path. I have reset the permissions for 'Authenticated Users' on the Oracle home directory. But I still get the above error. If I install Oracle 9.2. client locally then I can connect just fine. Is there some reason that I cannot use the Oracle client from another server? Thanks for your help, AGoodwin Tag: inline classes support in enterprise services Tag: 118383
  - 3
    - running SQL Scripts from VB.Net - is OSQL the best way? I have written a VB.Net application which, on start up, creates a database by running numerous .SQL files using the OSQL utility. This is the code i'm using in VB.Net to run the scripts: Dim proc As New Process proc.StartInfo.UseShellExecute = True proc.StartInfo.FileName = "osql" proc.StartInfo.Arguments = " -E -i C:\SQLScript.SQL" proc.StartInfo.WindowStyle = ProcessWindowStyle.Normal proc.Start() I checked the proc.ExitCode value, but unfortunately, this doesn't seem to tell you whether the script ran successfully or not. It always returns a 0, which indicates success. Can anyone tell me if there is a way which i could run the script from VB.Net and work out if there were errors or not? Thanking you in advance! Tag: inline classes support in enterprise services Tag: 118382
  - 4
    - TableAdapter Designer generates weird update and delete procedures Hi, I am impressed by the work you have done to simplify creation of DAL components. I especially like TableAdapters. However, I have found out that when you generate a TableAdapter in the TableAdapter Designer it creates a bit weird update and delete (SQL) procedures. Whenever a collumn is nullable it generates special parameters to signal that a given collumn should be null. It has a name which looks like this: @IsColumnNameNull but its type is the same as the type of the underlying column , instead of just making it of type int. The generated adapter code (C#) declares it as of type int, which makes it all work. But this way the SQL Server must convert the parameter value to int (0 or 1) because it compares it to 1 or 0. I think this is a bit worhtless. Tag: inline classes support in enterprise services Tag: 118380
  - 5
    - ODBC .Net Data Provider not working on production web server OK, I have a solution that works fine on my laptop and my desktop. When I tried to move the solution to the production server, I keep getting the error message ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Although, we did download and install the driver from http://www.microsoft.com/downloads/details.aspx?FamilyID=6ccd8427-1017-4f33-a062-d165078e32b1&displaylang=en The kicker is that it works fine from my laptop, which during testing, acts as the web server. The solutions is backend VB.Net, although I don't see that the code has much to do with it. Any suggestions? Tag: inline classes support in enterprise services Tag: 118377
  - 6
    - Webservices + oracle connection problem Hi, i have windows xp sp2 & visual .net 2003 and asp 1.1 iis 5.1 and oracle 10.1 and when i try to connect to database by webservice OCIEnvCreate error occures. While connecting with console application or windows application goes without any problems. I gave permission to bin directory (oci.dll). I tried to use other version of oci.dll and it didn't help. Thank for any advise. Tag: inline classes support in enterprise services Tag: 118373
  - 7
    - Cint(null) Hi I have code that stores integer data from the control to the database. (I am using Option Strict). The problem is when I try to do the code below, I get that the string is not properly formatted because there is no value. Each page has a lot of variables. Is there a way to solve that problem without having to have an IF block for each variable? myNewRow("score1") = CInt(SCORE1.Text) Thanks W Tag: inline classes support in enterprise services Tag: 118372
  - 8
    - What wrong with this simple code snippit? Hi all, Whats wrong with the below code? On every loop it seems to be jumping 3 sometimes 4 records. As you can see the SQL query is asking for all records with no filters. I want to loop each record as I asked. Is there something with wrong with my code? Thanks in adavnce, Steve. string str_SQLLayoutsPound = "SELECT * FROM Layouts";. OleDbCommand obj_SQLLayoutsPound = new OleDbCommand( str_SQLLayoutsPound, obj_SourceConn ); OleDbDataReader obj_ReaderLayoutsPound = obj_SQLLayoutsPound.ExecuteReader();. while( obj_ReaderLayoutsPound.Read()) { string str_CurrentRecord = obj_ReaderLayoutsPound["Name"].ToString(); } -- Message posted via DotNetMonster.com http://www.dotnetmonster.com/Uwe/Forums.aspx/dotnet-ado-net/200509/1 Tag: inline classes support in enterprise services Tag: 118368
  - 9
    - Question about isolation level using OracleClient library Hi, all, When I use OracleClient library to connect with Oracle Database and set transaction's isolation level to serializable level, it should can prevent phantom read from happening. But unluckily the phantom read happens. And if I use ODBC library to do all the same things as above, the phantom read will not happen. It is very confusing, and I looked for related infomation in internet, and got none. Would anybody help me and tell me why? BTW, the version of .Net Framework is 1.1, and the both versions of the oracle server and client are 9.2.1.0. Thank you in advance. Tag: inline classes support in enterprise services Tag: 118367
  - 10
    - serviced components and shared methods how does the enterprise services infrastructure treat shared (static ) declared methods? does the class the shared method is declared inside it must be serviced component in order for the method to get transaction services? because instance of the class does not have to exist and even if exist, not related to the method call. TIA. Tag: inline classes support in enterprise services Tag: 118364
  - 11
    - Does ExecuteReader allow you to return a record name? Hi all, I''ve created an OleDbDataReader that will contain the number of records that the used SQL query will return. I'm then using a while loop to loop while the OleDBDataReader object has records. I would like to know does the OleDbDataReader contain the actual information on each record i.e. the fields in the database and their values? Or does the ExecuteReader command only contain the number of records present from the used SQL query and no more? Or am I going the completely wrong way about it?? I need to use the 'Name' field's value of the current OleDbDataReader record in a following (not present in code snippit) code block. I using an Access 2000 database. Thanks in advance, Steve. OleDbDataReader obj_ReaderLayoutsPound = obj_SQLLayoutsPound.ExecuteReader(); while( obj_ReaderLayoutsPound.Read()) { // Is there a property of the OleDbDataReader that will contain the information of each record? string str_CurrentRecord = obj_ReaderLayoutsPound.ToString(); } -- Message posted via DotNetMonster.com http://www.dotnetmonster.com/Uwe/Forums.aspx/dotnet-ado-net/200509/1 Tag: inline classes support in enterprise services Tag: 118363
  - 12
    - Howto obtain the credentials from a SqlConnection object Hi all, In the ConnectionString property you can set the UserName and Password to be used for the SqlConnection as well as the DataSource and Initial Catalog (and some more possible values). There are properties on the SqlConnection object which return the DataSource and the Database provided in the ConnectionString but there are no such properties for the UserName and Password. I'm creating a class which is using DTS object to generate an Excel file and I would only like to provide a SqlConnection object, a CommandText and a CommandType to the class. The DTS Connection2 object has separate properties for Datasource, Catalog, UserID and password. Now I have to provide the UserName and Password as separate parameters to the class because I can't derive them from the SqlConnection object. Parsing the ConnectionString seems a bit tricky because you can provide the username with different keywords like: "uid" or "User Id', the same goes for password. And I don't know if there are more possible keywords. Does anybody know a way to to achieve what I want? TIA, Friso Wiskerke Tag: inline classes support in enterprise services Tag: 118362
  - 13
    - How to retrive schema bound with a SELECT statement columns? Hi , We are developing an application in C# to compare data retrieved by two SELECT queries. User Input for data comparision is two valid SELECT statements which returns data. Before starting the data comparison, i would like to validate the data type of all the columns which are listed in the select statment are same. For example i've the following two queries Query 1: SELECT t1.Col2, t2.Col3, t4.Col5 FROM ....... Query 2: SELECT A.Id, B.Name, C.Age FROM ..... Now i want to verify the selected columns from both the queries are having same data types and column length before extracting data for comparision. i.e i want to make sure that data type and column lenght of t1.Col2 is equal to A.Id t2.Col3 is equal to B.Name t4.Col5 is equal to C.Age. I tried working with DataAdapter.FillSchema but i'm not able to get proper information requried for validation. Most of the SQL data types are being mapped to Sytem.String and for data types i'm not able to get exact length. So i'm not able to differentiate the underlaying datatypes. please help me in validating the data types and length of colunms which are selected in the query? Regards, Gopi Can you please tell me how to retrieve schema associated with a query? Here is the sample query for which i want to know DATATYPE, LENGTH of every column which i'm selecting in the query. SELECT Tbl2.Name, Tbl3.Age, Tbl1.ID, Ttb2.DOB FROM Table1 Tbl1, Table2 Tbl2 WHERE Tbl1.Key = Tbl2.Table1Key Thanks in advance for spending your valuable time to look in to this problem. I would be very much thankfull to you if you help me to write SQL script( or C# code) to get the schema bound with the query. Regards, Gopinath M Tag: inline classes support in enterprise services Tag: 118361
  - 14
    - project with serviced components and non services components i have a project and i want few of my components to be services. but other classes i don't declare as serviced. should this cause any problem? and what if a seviced object calls a non services object (that might call another serviced component), can this cause problems? TIA for any info on the subject. Tag: inline classes support in enterprise services Tag: 118359
  - 15
    - serviced component question i have a vb.net class that Implements IDisposable. now i want to make that class services, so i make it inherits servicedComponent. now i get this error message: sub 'Dispose' shadows an overridable method in a base class. To override the base method, this method must be declared 'Overrides'. now that's OK, i can declare the sub as overrides, but should i take anything else into consideration? like calling the base.dispose inside my function. must I? TIA. Tag: inline classes support in enterprise services Tag: 118357
  - 16
    - Help me in Specifying Connection string to SQL server 2000 running on remote machine Hi All I am dealing a project in ASP.NET in which I have to establish a connection to SQL Server 2000 database,where the database was located on a remote system. For this I have used SQLConnection object and specified the connetion string.But when it comes to establish a connection its giving me the Error that I. Connection string : workstation id=localhost;packet size=4096;user id=sa;data source=192.168.0.106;persist security info=False;initial catalog=db Error : System.Data.SqlClient.SqlException: Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection. then I have inserted one new attribute 'Network = dbmssocn' and modified the connection string as below II. Connection string : workstation id=localhost;packet size=4096;user id=sa;data source=192.168.0.106;Network=DBMSSOCN;persist security info=False; initial catalog=db then I got the below Error when try to establish a connection. Error : System.Data.SqlClient.SqlException: SQL Server does not exist or access denied Note: 1. Here the client machine has VS.NET and IIS installed on it and the SQL Server 2000 is running on a remote machine but both are in the same "Workgroup network". 2.The authentication mode of the SQL Server 2000 is Mixed Authentivation(SQL Server and Windows) 3.Firewall is also enabled on the remote machine where the SQL Server 2000 is ruuning, 4.Both Client and Server running on Windows Xp OS with SP2 installed. Hence,I am requesting you people to help in specifying the correct connection string(I mean where I have done the mistake)so that I can establish a connection. 5.One more issue is that its working fine when as desktop application(i.e, I am able to extablish connection from a desktop application done in VB.NET,but wasn't working in web application.)Please let me know my mistake...........as I have gone through so many forums and didn't find solution for this. Thanks in advance Vighneswar Tag: inline classes support in enterprise services Tag: 118356
  - 17
    - Oracle timestamp precision Hello sirs, I have this SQL statement: DELETE FROM EMODPRODUTOS WHERE (CdProduto = 105) AND (DtUltAlteracao = to_timestamp('28/09/2005 21:50:13,141233')) But it's not working........ I get: ORA-01830: date format picture ends before converting entire input string I need a where clause with a timestamp value with this precision... Can oracle handle this? I appreciate any information. Tag: inline classes support in enterprise services Tag: 118354
  - 18
    - ADO.NET AddNew EndCurrentEdit & "Column 'Appt_ID' does not allow nulls" SOLVED I see this question asked in different ways both in this newsgroup and on bulliten boards, I just stumbled on the fix. What I had was basically correct, but missing one line. In the Update button, after this: Me.BindingContext(DsAppointments1, "Appointments").EndCurrentEdit() THIS is required to write the data back to the DB: OleDbDataAdapter1.Update(DsAppointments1) The .net help implied that EndCurrentEdit() wrote to the DB, and didnt mention updating the adapter where it should have been mentioned. I tweaked the code a bit in other areas, the final code I'm using for the ADD and UPDATE buttons follows: btnADD_click... REM move to the last record Call btnLast_Click(Nothing, Nothing) REM Access the DataTable object Dim myTable As DataTable = DsAppointments1.Appointments() REM confirm properties for Primary Key are properly set myTable.Columns("Appointment_ID").ReadOnly = False myTable.Columns("Appointment_ID").AutoIncrement = True REM Clear the text boxes of their current record data Me.BindingContext(DsAppointments1, "Appointments").AddNew() btnUPDATE_click... REM Tell VB youre done editing Me.BindingContext(DsAppointments1,"Appointments").EndCurrentEdit() REM Tell VB to write the data you added to the DB OleDbDataAdapter1.Update(DsAppointments1) One FYI: column numbers, such as myTable.Columns(0).AutoIncrement = True At least seem less reliable in .net than they were in VB 6 Tag: inline classes support in enterprise services Tag: 118351
  - 19
    - deadlocks and datareaders We are reguarly getting deadlock errors on a page when it calls SqlDataReader.Read(). If DataReaders are read only, forward only 'firehoses', why would this be causing deadlocks? What can be done to resolve the problem? ************************************************** Error description ************************************************** Message: Transaction (Process ID 160) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Source: .Net SqlClient Data Provider Stack Trace: at System.Data.SqlClient.SqlDataReader.Read() Tag: inline classes support in enterprise services Tag: 118347
  - 20
    - Related Tables in Different Databases; how to query Database1 contains a table of people with addresses (sql Server) Table: People MasterID MasterName MasterAddress1 etc. DataBase2 Contains a table of people and the property they own. (msAccess -> imported from the sqlServer but detached) Table Property PropertyID MasterID PropertyDescription, etc. I can easily put together oledbdataadaptors to fill a common dataset (dataset1) with: People Table and Property Table My task is to generate a table/view something like SELECT Property.PropertyDescription, People.MasterName, People.MasterAddress FROM Property INNER JOIN People ON Property.MasterID = People.MasterID; I'm at a loss as to what Ado.net widget, and/or process to use to do this. It would be easy if they came from the same database (they sorta do but we can't go there) ;>. The only approach I can dream up is to create a temp table in one of the databases of the data from the other then do a query, but for several reasons, I would like to find a more 'elegant' way to do this. Ed Warren. Tag: inline classes support in enterprise services Tag: 118340
  - 21
    - update call not working My update method is not working, I am getting An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll Additional information: System error. Don't know why. Please help! using System; using System.Data.OleDb; using System.Data; using System.Data.SqlClient; using System.Data.SqlTypes; namespace ConsoleApplication1 { /// <summary> /// Summary description for SQLdataUpload. /// </summary> public class SQLdataUpload3 { public SQLdataUpload3() { //declare datasets System.Data.DataSet OnviaDS = new System.Data.DataSet(); System.Data.DataSet RawImport = new DataSet(); { //connect to excel file and fill data set OleDbConnection MyConnection = new OleDbConnection("Provider=Microsoft.Jet. OLEDB.4.0;Data Source=C:\\OnviaData\\OnviaData;Extended Properties=Excel 8.0") ; MyConnection.Open(); OleDbCommand MyCommand = MyConnection.CreateCommand(); MyCommand.CommandType = CommandType.Text; MyCommand.CommandText = "Select * From [Sheet1$]"; OleDbDataAdapter MyAdapter = new OleDbDataAdapter(); MyAdapter.SelectCommand = MyCommand; MyAdapter.Fill(RawImport,"ewm_onvia_import"); MyConnection.Close(); //connect to SQL database and fill data set with existing data SqlConnection MySqlConnection = new SqlConnection ("uid=sa;password=;Persist Security Info=False;Initial Catalog=db_work2;Data Source=devsvr1;Packet Size=4096;Workstation ID=QED_IT4;"); MySqlConnection.Open(); SqlCommand ExistingData = MySqlConnection.CreateCommand(); SqlDataAdapter SDA = new SqlDataAdapter(); SDA.SelectCommand = ExistingData; ExistingData.CommandType = CommandType.Text; ExistingData.CommandText = "SELECT * FROM ewm_onvia_import"; SDA.Fill(OnviaDS,"ewm_onvia_import"); SqlCommand OnviaInsert = MySqlConnection.CreateCommand(); SDA.InsertCommand = OnviaInsert; OnviaInsert.CommandType = CommandType.Text; //insert updated dataset back into SQL database and table ewm_onvia_import OnviaInsert.CommandText = "INSERT INTO ewm_onvia_import(Publish Date, Sector,Info Type,Onvia Ref Num"+ "Project Num,Project Name,Owner,Location,State,Zip Code,County, Submittal Date,Contact Name,Phone"+ "Minimum Price,Maximum Price,Plan Price,Pre Bid,URL,Categories,Scope)"+ "SELECT (Publish Date,Sector,Info Type,Onvia Ref Num"+ "Project Num,Project Name,Owner,Location,State,Zip Code,County, Submittal Date,Contact Name,Phone"+ "Minimum Price,Maximum Price,Plan Price,Pre Bid,URL,Categories,Scope)"+ "VALUES(@Publish Date,@Sector,@Info Type,@Onvia Ref Num,@Project Num, @Project Name,@Owner,@Location,"+ "@State,@Zip Code,@County,@Submittal Date,@Contact Name,@Phone"+ "@Minimum Price,@Maximum Price,@Plan Price,@Pre Bid,@URL,@Categories, Scope)"; //add parameters OnviaInsert.Parameters.Add("@Publish Date", SqlDbType.DateTime,8, "Publish Date"); OnviaInsert.Parameters.Add("@Sector",SqlDbType.VarChar,20,"Sector"); OnviaInsert.Parameters.Add("@Info Type",SqlDbType.VarChar,20,"Info Type") ; OnviaInsert.Parameters.Add("@Onvia Ref Num",SqlDbType.Int,4,"Onvia Ref Num"); OnviaInsert.Parameters.Add("@Project Num",SqlDbType.VarChar,255,"Project Num"); OnviaInsert.Parameters.Add("@Project Name",SqlDbType.VarChar,255, "Project Name"); OnviaInsert.Parameters.Add("@Owner",SqlDbType.VarChar,255,"Owner"); OnviaInsert.Parameters.Add("@Location",SqlDbType.Text,16,"Location"); OnviaInsert.Parameters.Add("@State",SqlDbType.VarChar,255,"State"); OnviaInsert.Parameters.Add("@Zip Code",SqlDbType.VarChar,255,"Zip Code") ; OnviaInsert.Parameters.Add("@County",SqlDbType.VarChar,255,"County"); OnviaInsert.Parameters.Add("@Submittal Date",SqlDbType.DateTime,8, "Submittal Date"); OnviaInsert.Parameters.Add("@Contact Name",SqlDbType.VarChar,255, "Contact Name"); OnviaInsert.Parameters.Add("@Phone",SqlDbType.VarChar,255,"Phone"); OnviaInsert.Parameters.Add("@Mimimum Value",SqlDbType.VarChar,255, "Minimum Value"); OnviaInsert.Parameters.Add("@Maximum Value",SqlDbType.VarChar,255, "Maximum Value"); OnviaInsert.Parameters.Add("@Plan Price",SqlDbType.VarChar,255,"Plan Price"); OnviaInsert.Parameters.Add("@Pre Bid",SqlDbType.DateTime,8,"Pre Bid"); OnviaInsert.Parameters.Add("@URL",SqlDbType.VarChar,255,"URL"); OnviaInsert.Parameters.Add("@Categories",SqlDbType.Text,16,"Categories") ; OnviaInsert.Parameters.Add("@Scope",SqlDbType.Text,16,"Scope"); OnviaInsert.Parameters["@Onvia Ref Num"].SourceVersion=DataRowVersion. Original; foreach(DataRow dr in RawImport.Tables["ewm_onvia_import"].Rows) { //insert rows into ewm_onvia_import dataset from RawImport DataRow drw = OnviaDS.Tables["ewm_onvia_import"].NewRow(); drw[0]= dr[0]; drw[1]= dr[1]; drw[2]= dr[2]; drw[3]= dr[3]; drw[4]= dr[4]; drw[5]= dr[5]; drw[6]= dr[6]; drw[7]= dr[7]; drw[8]= dr[8]; drw[9]= dr[9]; drw[10]= dr[10]; drw[11]= dr[11]; drw[12]= dr[12]; drw[13]= dr[13]; drw[14]= dr[14]; drw[15]= dr[15]; drw[16]= dr[16]; drw[17]= dr[17]; drw[18]= dr[18]; drw[19]= dr[19]; drw[20]= dr[20]; OnviaDS.Tables["ewm_onvia_import"].Rows.Add(drw); } SDA.Update(OnviaDS,"ewm_onvia_import"); MySqlConnection.Close(); } } } } Tag: inline classes support in enterprise services Tag: 118337
  - 22
    - DateTime parse I know I need to use the parse method of the DateTime but am unsure where or exactly how to do it. I am trying to update a SQL database with an unspecified amount of data and am passing in several columns whose datatype is of type DateTime. Below is my code. using System; using System.Data.OleDb; using System.Data; using System.Data.SqlClient; using System.Data.SqlTypes; namespace ConsoleApplication1 { /// <summary> /// Summary description for SQLdataUpload. /// </summary> public class SQLdataUpload3 { public SQLdataUpload3() { //declare datasets System.Data.DataSet OnviaDS = new System.Data.DataSet(); System.Data.DataSet RawImport = new DataSet(); { //connect to excel file and fill data set OleDbConnection MyConnection = new OleDbConnection ("Provider=Microsoft.Jet. OLEDB.4.0;Data Source=C:\\OnviaData\\OnviaData;Extended Properties=Excel 8.0") ; MyConnection.Open(); OleDbCommand MyCommand = MyConnection.CreateCommand(); MyCommand.CommandType = CommandType.Text; MyCommand.CommandText = "Select * From [Sheet1$]"; OleDbDataAdapter MyAdapter = new OleDbDataAdapter(); MyAdapter.SelectCommand = MyCommand; MyAdapter.Fill(RawImport,"ewm_onvia_import"); MyConnection.Close(); //connect to SQL database and fill data set with existing data SqlConnection MySqlConnection = new SqlConnection ("uid=sa;password=;Persist Security Info=False;Initial Catalog=db_work2;Data Source=devsvr1;Packet Size=4096;Workstation ID=QED_IT4;"); MySqlConnection.Open(); SqlCommand ExistingData = MySqlConnection.CreateCommand(); SqlDataAdapter SDA = new SqlDataAdapter(); SDA.SelectCommand = ExistingData; ExistingData.CommandType = CommandType.Text; ExistingData.CommandText = "SELECT * FROM ewm_onvia_import"; SDA.Fill(OnviaDS,"ewm_onvia_import"); SqlCommand OnviaInsert = MySqlConnection.CreateCommand(); SDA.InsertCommand = OnviaInsert; OnviaInsert.CommandType = CommandType.Text; //step through each row if RawImport dataset foreach(DataRow dr in RawImport.Tables["ewm_onvia_import"]. Rows) { //insert updated dataset back into SQL database and table ewm_onvia_import OnviaInsert.CommandText = "INSERT INTO ewm_onvia_import (Publish Date, Sector,Info Type,Onvia Ref Num"+ "Project Num,Project Name,Owner,Location,State,Zip Code,County, Submittal Date,Contact Name,Phone"+ "Minimum Price,Maximum Price,Plan Price,Pre Bid,URL, Categories,Scope)"+ "SELECT (Publish Date,Sector,Info Type,Onvia Ref Num"+ "Project Num,Project Name,Owner,Location,State,Zip Code,County, Submittal Date,Contact Name,Phone"+ "Minimum Price,Maximum Price,Plan Price,Pre Bid,URL, Categories,Scope)"+ "FROM [RawImport]"+ "VALUES(@Publish Date,@Sector,@Info Type,@Onvia Ref Num,@Project Num, @Project Name,@Owner,@Location,"+ "@State,@Zip Code,@County,@Submittal Date,@Contact Name,@Phone"+ "@Minimum Price,@Maximum Price,@Plan Price,@Pre Bid, @URL,@Categories, Scope)"; //add parameters OnviaInsert.Parameters.Add("@Publish Date", SqlDbType. DateTime,8, "Publish Date"); OnviaInsert.Parameters.Add("@Sector",SqlDbType.VarChar,20, "Sector"); OnviaInsert.Parameters.Add("@Info Type",SqlDbType.VarChar, 20,"Info Type") ; OnviaInsert.Parameters.Add("@Onvia Ref Num",SqlDbType.Int, 4,"Onvia Ref Num"); OnviaInsert.Parameters.Add("@Project Num",SqlDbType. VarChar,255,"Project Num"); OnviaInsert.Parameters.Add("@Project Name",SqlDbType. VarChar,255, "Project Name"); OnviaInsert.Parameters.Add("@Owner",SqlDbType.VarChar,255, "Owner"); OnviaInsert.Parameters.Add("@Location",SqlDbType.Text,16, "Location"); OnviaInsert.Parameters.Add("@State",SqlDbType.VarChar,255, "State"); OnviaInsert.Parameters.Add("@Zip Code",SqlDbType.VarChar, 255,"Zip Code") ; OnviaInsert.Parameters.Add("@County",SqlDbType.VarChar, 255,"County"); OnviaInsert.Parameters.Add("@Submittal Date",SqlDbType. DateTime,8, "Submittal Date"); OnviaInsert.Parameters.Add("@Contact Name",SqlDbType. VarChar,255, "Contact Name"); OnviaInsert.Parameters.Add("@Phone",SqlDbType.VarChar,255, "Phone"); OnviaInsert.Parameters.Add("@Mimimum Value",SqlDbType. VarChar,255, "Minimum Value"); OnviaInsert.Parameters.Add("@Maximum Value",SqlDbType. VarChar,255, "Maximum Value"); OnviaInsert.Parameters.Add("@Plan Price",SqlDbType. VarChar,255,"Plan Price"); OnviaInsert.Parameters.Add("@Pre Bid",SqlDbType.DateTime, 8,"Pre Bid"); OnviaInsert.Parameters.Add("@URL",SqlDbType.VarChar,255, "URL"); OnviaInsert.Parameters.Add("@Categories",SqlDbType.Text, 16,"Categories") ; OnviaInsert.Parameters.Add("@Scope",SqlDbType.Text,16, "Scope"); OnviaInsert.Parameters["@Onvia Ref Num"]. SourceVersion=DataRowVersion. Original; //insert rows into ewm_onvia_import dataset from RawImport DataRow drw = OnviaDS.Tables["ewm_onvia_import"].NewRow() ; drw[0]= "@Publish Date"; //error occurs after the above line drw[1]= "@Sector"; drw[2]= "@Info Type"; drw[3]= "@Onvia Ref Num"; drw[4]= "@Project Num"; drw[5]= "@Project Name"; drw[6]= "@Owner"; drw[7]= "@Location"; drw[8]= "@State"; drw[9]= "@Zip Code"; drw[10]= "@County"; drw[11]= "@Submittal Date"; drw[12]= "@Contact Name"; drw[13]= "@Phone"; drw[14]= "@Minimum Value"; drw[15]= "@Maximum Value"; drw[16]= "@Plan Price"; drw[17]= "@Pre Bid"; drw[18]= "@URL"; drw[19]= "@Catgories"; drw[20]= "@Scope"; OnviaDS.Tables["ewm_onvia_import"].Rows.Add(drw); SDA.Update(OnviaDS,"ewm_onvia_import"); } MySqlConnection.Close(); } } } } Tag: inline classes support in enterprise services Tag: 118333
  - 23
    - Business objects and class' w/ member DataSets I'm designing my data access needs and have a couple of questions. First of all, I can't get a straight answer what a "business object" is. I typically create classes to represent my database tables, are those "business objects"? Is it more typical to pass the business objecs to the DAL methods or have the business objects generate correct SQL and pass commands to the DAL? I'm thinking of trying out a new type of business object where I encapsulate a DataSet or DataTable in my object. Something like: <code> class BCustomer { private DataSet m_rawData; public string CustomerName { get{ return m_rawData.Tables[0].Rows[0][0]; } // assuming this is the index to the customer name? set{ m_rawData.Tables[0].Rows[0][0] = value; } // ditto } } </code> This gives me strong typing and the flexibility of the DataSet/Table Is this common? Anything I should know? THANKS! Tag: inline classes support in enterprise services Tag: 118331
  - 24
    - Oracle and .NET I'm trying to use Microsoft Data Access Application Blocks to connect to an Oracle database with no luck. I cannot find any resources if this can be done. The only examples I found was using Oracle Client for .NET. Is it possible to connect to Oracle 9i Database using Data Access Application Blocks? How? Tag: inline classes support in enterprise services Tag: 118330
  - 25
    - ADO.net 2.0, beta 2, how to get data from 2 tables, not parent-chi in ADO.net 2.0 beta 2 I know how to do the parent-child type. 1. drag a DataGrid control in a window form, get a datasource from table cust. 2. drag table cust onto the DataGrid. 3. in the data window, right-click the dataset, select configure.. adding table o. 4. drag the child table onto the DataGrid control. comment: With this way, I build this without a coding. I believe it is MVC style. I do not know the steps to join two relational tables into one ADO table.Please advise. Thanks. Peter Tag: inline classes support in enterprise services Tag: 118329
- Next
  - 1
    - About the bind event If I put a GridView and a DataSource in a web form I found in the page_load event, can find the Items of Gridviw. I think the binding is occur after Page_load. But any one can know the actual event when the datasource is auto bind? Tag: inline classes support in enterprise services Tag: 118328
  - 2
    - DataGridView: Index -1 does not have a value Hi, I'm using the DataGridView in VB.NET 2.0. The DataSource is a Generic List of a custom class0: lstMyPersonnes = New List(Of clsPersonne). When I add a new clsPersonne to lstMyPersonnes, and rebind the lstMyPersonnes to my DataGridView.dataSource, it shows the new record in the DataGridView as it should be. But when I click on a cell of that row, I suddenly got this error: "Index -1 does not have a value"... Does anybody has any idea how to get around this problem? Thanks a lot in advance, Pieter PS: I'm using the RC of Visual Team Suite. The whole exception: System.IndexOutOfRangeException was unhandled Message="Index -1 does not have a value." Source="System.Windows.Forms" StackTrace: at System.Windows.Forms.CurrencyManager.get_Item(Int32 index) at System.Windows.Forms.CurrencyManager.get_Current() at System.Windows.Forms.DataGridView.DataGridViewDataConnection.OnRowEnter(Data GridViewCellEventArgs e) at System.Windows.Forms.DataGridView.OnRowEnter(DataGridViewCell& dataGridViewCell, Int32 columnIndex, Int32 rowIndex, Boolean canCreateNewRow, Boolean validationFailureOccurred) at System.Windows.Forms.DataGridView.SetCurrentCellAddressCore(Int32 columnIndex, Int32 rowIndex, Boolean setAnchorCellAddress, Boolean validateCurrentCell, Boolean throughMouseClick) at System.Windows.Forms.DataGridView.OnCellMouseDown(HitTestInfo hti, Boolean isShiftDown, Boolean isControlDown) at System.Windows.Forms.DataGridView.OnCellMouseDown(DataGridViewCellMouseEvent Args e) at System.Windows.Forms.DataGridView.OnMouseDown(MouseEventArgs e) at System.Windows.Forms.Control.WmMouseDown(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.DataGridView.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg) at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.Unsaf eNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData) at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context) at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context) at System.Windows.Forms.Application.Run(ApplicationContext context) at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.OnRun( ) at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.DoAppl icationModel() at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.Run(St ring[] commandLine) at Ghost.My.MyApplication.Main(String[] Args) in 17d14f5c-a337-4978-8281-53493378c1071.vb:line 81 at System.AppDomain.nExecuteAssembly(Assembly assembly, String[] args) at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args) at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly() at System.Threading.ThreadHelper.ThreadStart_Context(Object state) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() Tag: inline classes support in enterprise services Tag: 118326
  - 3
    - This simple ADO.NET connection is causing errors - HELP!!!! Hi all, What wrong with the below snippit of code? I believe I've called the this function correctly and besides all the errors (immediately below) are pointed to this snippit of code. Thanks in advance, Steve. } expected Invalid token '(' in class, struct, or interface member declaration Invalid token '(' in class, struct, or interface member declaration Invalid token '(' in class, struct, or interface member declaration Invalid token '(' in class, struct, or interface member declaration Type or namespace definition, or end-of-file expected public class cls_ConvertThreeDatabases { public void ConvertDatabases(string str_Source, string str_Destination) { public string str_SourcePath = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source = " + str_Source ; public string str_DestinationPath = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source = " + str_Destination ; OleDbConnection obj_SourceConn = new OleDbConnection (str_SourcePath); OleDbConnection obj_DestinationConn = new OleDbConnection (str_DestinationPath); obj_SourceConn.Open(); obj_DestinationConn.Open(); obj_Destination.Close(); obj_Source.Close(); return; } } -- Message posted via DotNetMonster.com http://www.dotnetmonster.com/Uwe/Forums.aspx/dotnet-ado-net/200509/1 Tag: inline classes support in enterprise services Tag: 118321
  - 4
    - Help with adding stuff to a database please Im just converting an app to .net (using VB) and I decided to use ado.net also, rather than sticking with plain ado. I have got my queries running fine with datareaders, but I'm having a little trouble inserting records. I dont really want to use an SQL command as single quotes in strings often cause headaches, so I have the code below. I get an exception of "Object reference not set to an instance of an object" at the line marked with * and checking my debug, workTable is still "nothing". Any clues or am I completely off track here! Thanks James. Dim MyDataSet As New DataSet Dim Adapter As New SqlDataAdapter Adapter.SelectCommand = New SqlCommand("SELECT * FROM msg", DBConn) Adapter.Fill(MyDataSet) Dim workTable As New DataTable workTable = MyDataSet.Tables.Item("msg") * Dim workRow As DataRow = workTable.NewRow workRow("msg_client") = client workRow("msg_username") = username workRow("msg_message") = Message workRow("msg_recipient") = CStr(Recipient) workRow("msg_submittime") = Now() workRow("msg_status") = 0 workTable.Rows.Add(workRow) Adapter.Update(MyDataSet) Tag: inline classes support in enterprise services Tag: 118320
  - 5
    - OleDbSchema Guid hi i am using OleDbSchemaGuid to display the schema information of a database when i use OleDbSchemaGuid.Procecdures method it returns a data table containing all procedures as well as functions.. but i am not able to separately get the list of procedures and the list of functions....i need those details separately... how do we do it using OleDbSchemaGuid?????? Avinash Tag: inline classes support in enterprise services Tag: 118319
  - 6
    - Where are DataSets Stored?? This Point has always make me confuse Sure that DataSet is in the RAM but where in the RAM the Server or the Client Shall be Very Kind of you if any one can take a lill of there time to let know this Topic clear to me.. Thanks Dudes ;) Tag: inline classes support in enterprise services Tag: 118314
  - 7
    - There is already an open DataReader associated with this Connection which must be closed first". Hi All! i am using the oledb connection to connect Oracle database. I use the code for connectiong to datawindow as Public sqlca As Sybase.DataWindow.AdoTransaction Public con as oledb.oledbconnection 'con as oracle connection con.open() sqlca = New Sybase.DataWindow.AdoTransaction(con) sqlca.BindConnection() The connection and data aretrieved fine. At one part of time i get the error as "There is already an open DataReader associated with this Connection which must be closed first". if i use sqlca.unbindconnection() and do some database activities using oledbdataadapter and dataset. but i didn't use any datareader. When i bind the connection to sqlca as sqlca.bindconnection() i get the above error. Is there any datareader used by Sybase.DataWindow.AdoTransaction? Note: The database is in remote. retrival from clsong and opening connection takes a long time. How can i solve it without reconnecting to the database? Thanks in Advance S. Viswanathan Tag: inline classes support in enterprise services Tag: 118312
  - 8
    - ADO.NET AddNew EndCurrentEdit & "Column 'Appt_ID' does not allow nulls" Having spent a lot of time Googling over the last 2 days, this seems like a common problem, but I havent run into any answers: My VB.Net front end loads data from an Access database successfully, and navigation works fine. However, I cannot add a record. Code is as follows: In my Add New Record button: REM move to last record Call btnLast_Click(Nothing, Nothing) REM clear text boxes, prepare for new record Me.BindingContext(DsAppointments1, "Appointments").AddNew() In my Update button: REM commit to adding new record Me.BindingContext(DsAppointments1, "Appointments").EndCurrentEdit() When that last line of code fires, I get the following error (I know this must be starting to look familiar to experienced coders): -------------- "An unhandled exception of type 'System.Data.NoNullAllowedException' occurred in system.data.dll Additional information: Column 'Appt_ID' does not allow nulls." -------------- Appt_ID is the primary key and is set to autonumber in the Access database. I have tried too many things to even mention here, but I cannot get this to work. I'm sure someone out there has gotten it to work, and I'd love to know how. :-) Also, a curiosity. What is the VB.Net equivelent of: Adodc1.Recordset.Fields(0).Value Thanks, Tony Tag: inline classes support in enterprise services Tag: 118309
  - 9
    - Need help with productDataSource.SelectParameters This is a multi-part message in MIME format. ------=_NextPart_000_000B_01C5C393.0065D650 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Does anyone knows how to assign the value of a textbox to = productDataSource.SelectParameters when a button is clicked? I'm using = VS 2005 and all the code I've found on the web are samples of dropdown = lists with code in the aspx page. Heres the subroutine where I'm stuck. Protected Sub btnSearch_Click(ByVal sender As Object, ByVal e As = System.EventArgs) Handles btnSearch.Click Dim search As String Dim productDataSource As New ObjectDataSource productDataSource.TypeName =3D "Customers" productDataSource.SelectMethod =3D "getItem" productDataSource.SelectParameters =3D ???????? End Sub ------=_NextPart_000_000B_01C5C393.0065D650 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2900.2722" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DVerdana size=3D2>Does anyone knows how to assign the = value of a=20 textbox to productDataSource.SelectParameters when a button is=20 clicked?   I'm using VS 2005 and all the code I've found on = the web=20 are samples of dropdown lists with code in the aspx page.</FONT></DIV> <DIV><FONT face=3DVerdana size=3D2></FONT> </DIV> <DIV><FONT face=3DVerdana size=3D2>Heres the subroutine where I'm=20 stuck.</FONT></DIV> <DIV><FONT face=3DVerdana size=3D2></FONT> </DIV> <DIV><FONT face=3DVerdana size=3D2></FONT> </DIV> <DIV><FONT face=3DCourier size=3D2>    Protected Sub=20 btnSearch_Click(ByVal sender As Object, ByVal e As System.EventArgs) = Handles=20 btnSearch.Click<BR>        Dim search = As=20 String<BR>        Dim = productDataSource As=20 New ObjectDataSource<BR>       =20 productDataSource.TypeName =3D=20 "Customers"<BR>       =20 productDataSource.SelectMethod =3D=20 "getItem"<BR>       =20 productDataSource.SelectParameters =3D ????????<BR>    = End=20 Sub</FONT></DIV></BODY></HTML> ------=_NextPart_000_000B_01C5C393.0065D650-- Tag: inline classes support in enterprise services Tag: 118305
  - 10
    - Trying to debug a connection issue I'm getting an "Unknown connection option: user" error when trying to The connection string block in the dataConfiguration.config file looks like: <instances> <instance name="Instance1" type="Sql Server" connectionString="Connect_String1" /> </instances> <connectionStrings> <connectionString name="Connect_String1"> <parameters> <parameter name="database" value="databasename" isSensitive="false" /> <parameter name="user" value="xxx" isSensitive="false" /> <parameter name="password" value="yyy" isSensitive="false" /> <parameter name="server" value="server.domain.com" isSensitive="false" /> </parameters> </connectionString> </connectionStrings> The code that causes the error is: db = DatabaseFactory.CreateDatabase("Instance1"); A weird thing is that this (code and config file) appear to work fine from my development machine, but fails on the server hosting the webservice. If I point my consuming application to the server, it fails with the same error, but I can't debug it there. Any pointers on debugging this would be appreciated. -- Clint Tag: inline classes support in enterprise services Tag: 118303
  - 11
    - Error loading package Hi vs2005 RC. When I try to add a new data connection to a winform app. I get this message 'Package Load Failure, Package 'Smart Device Configuration Package' has failed to load properly...'. How can I fix it? Thanks Regards Tag: inline classes support in enterprise services Tag: 118301
  - 12
    - Problem with Framework Hi vs2005 rc. When I try to add a connection to a winform project, I get the error 'An unexpected error occurred in the .Net Framework Data Provider for SQL Server Mobile Edition. Please contact the provider vendor to resolve this problem.'. How can I fix this? Thanks Regards Tag: inline classes support in enterprise services Tag: 118299
  - 13
    - How to capture sql command text when DbDataAdapter's Update is cal Hi, We are having a major debugging problem here and would like to take advices from anyone. In our app, we need to update our dataset using DbDataAdapter against Oracle database. Once we have issues, like invalid data or something like that, the update will fail but only with limited returned message. It would be extramly helpful if we could somehow capture the SQL text that built by the ADO.Net, right before or after the Update is called. Is there a way to do that? Thanks Feng Tag: inline classes support in enterprise services Tag: 118298
  - 14
    - Sending email from within a WebService (sorry for the dual post here and the webservice NG. I meant to send to both at the same time) I have a method which sends email to & from a specific account. All was working fine until the server was upgraded to an AD/DNS server. Now the email never goes through. I can run the same code from an exe and it works fine. MailMessage mail = new MailMessage(); mail.Body = msg; mail.From = emailfrom; mail.To = emailto; mail.Subject = "Test."; mail.Fields["http://schemas.microsoft.com/cdo/configuration/smtpauthenticate"] = 2; mail.Fields["http://schemas.microsoft.com/cdo/configuration/smtpserver"] = "mail.mydomain.com"; mail.Fields["http://schemas.microsoft.com/cdo/configuration/smtpserverport"] = 25; mail.Fields["http://schemas.microsoft.com/cdo/configuration/sendusername"] = "sender@mydomain.com"; mail.Fields["http://schemas.microsoft.com/cdo/configuration/sendpassword"] = "******"; SmtpMail.SmtpServer = "mail.mydomain.com"; SmtpMail.Send(mail); Does the service need to be granted a certain permission? Tag: inline classes support in enterprise services Tag: 118295
  - 15
    - Working with different kinds of databases Hi, How can I make my application work with SQL Server, Oracle, MySql, etc? _dino_ Tag: inline classes support in enterprise services Tag: 118290
  - 16
    - Event for Field Change I am a Delphi programmer who is excited about converting to .Net (however still novice in .Net), and I need your help to understand some data manupulation concepts. I am using I have a typed DataGrid bound to an access database, which has a table with 2 datetime fields: Date1 and Date2. I added an unbound column to the grid called ELAPSED, which will diplay the difference in days between the 2 dates. So the grid looks like this: DATE1 DATE2 DIFF ------------------------------------------ __/__/____ __/__/____ 999 days __/__/____ __/__/____ 999 days __/__/____ __/__/____ 999 days __/__/____ __/__/____ 999 days __/__/____ __/__/____ 999 days I wrote a method to calculate the difference in days (using TimaSpan), and I want to run this method for each row, as it's been "filled" from the database. Additionally, I want this method to be run as I change DATE1 or DATE2 in the grid, so that the it reflects the correct difference in days. Please help me to achieve this, explaining in what event(s) I should place the call to my method. PS: In Delphi I would put it in the TField's OnChange event... Thank you very much!!!!! - Gus Tag: inline classes support in enterprise services Tag: 118289
  - 17
    - Multiple DataViews on the same DataTable appear to interact I have a DataTable that is being maintained in a Model class. I also have a View class which creates a DataView from the DataTable that the Model passes it. The view class then has methods to filter the contents of the DataView so that the user can narrow down the list to the items they are interested in. This all works fine as long as I only have a single instance of the View class, however whenever I create a second instance of the view class and have it make its DataView use the same DataTable I find that any filter applied to the DataView in one window is also applied to the DataView in the other form. Can anyone explain this to me? It seems that as long as I am using 2 independant DataViews (dim dv as new DataView(model.GetTable()) they shouldn't interact. TIA Ron L Tag: inline classes support in enterprise services Tag: 118284
  - 18
    - Microsoft.Practices.EnterpriseLibrary.Data manifest mismatch I built the Microsoft (June 2005) Enterprise Library as strong named assemblies. In a Web application called ConfigTest, I use the Data Access Application Block. When the application starts and the code that uses the enterprise library is executed, I get the following error page: Server Error in '/ConfigTest' Application. ---------------------------------------------------------------------------- ---- The located assembly's manifest definition with name 'Microsoft.Practices.EnterpriseLibrary.Data' does not match the assembly reference. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.IO.FileLoadException: The located assembly's manifest definition with name 'Microsoft.Practices.EnterpriseLibrary.Data' does not match the assembly reference. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Assembly Load Trace: The following information can be helpful to determine why the assembly 'Microsoft.Practices.EnterpriseLibrary.Data' could not be loaded. === Pre-bind state information === LOG: DisplayName = Microsoft.Practices.EnterpriseLibrary.Data, Version=1.1.0.0, Culture=neutral, PublicKeyToken=null (Fully-specified) LOG: Appbase = file:///c:/inetpub/wwwroot/ConfigTest LOG: Initial PrivatePath = bin Calling assembly : (Unknown). === LOG: Policy not being applied to reference at this time (private, custom, partial, or location-based assembly bind). LOG: Post-policy reference: Microsoft.Practices.EnterpriseLibrary.Data, Version=1.1.0.0, Culture=neutral, PublicKeyToken=null LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET Files/configtest/2f32983c/f9a353e7/Microsoft.Practices.EnterpriseLibrary.Dat a.DLL. LOG: Attempting download of new URL file:///C:/WINDOWS/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET Files/configtest/2f32983c/f9a353e7/Microsoft.Practices.EnterpriseLibrary.Dat a/Microsoft.Practices.EnterpriseLibrary.Data.DLL. LOG: Attempting download of new URL file:///c:/inetpub/wwwroot/ConfigTest/bin/Microsoft.Practices.EnterpriseLibrary.Data.DLL. WRN: Comparing the assembly name resulted in the mismatch: PUBLIC KEY TOKEN Stack Trace: [FileLoadException: The located assembly's manifest definition with name 'Microsoft.Practices.EnterpriseLibrary.Data' does not match the assembly reference.] System.Type.GetType(String typeName, Boolean throwOnError) +0 Microsoft.Practices.EnterpriseLibrary.Configuration.Transformer.XmlSerialize rTransformer.Deserialize(Object section) Microsoft.Practices.EnterpriseLibrary.Configuration.ConfigurationBuilder.Rea dConfiguration(String sectionName) Microsoft.Practices.EnterpriseLibrary.Configuration.ConfigurationContext.Get Configuration(String sectionName) Microsoft.Practices.EnterpriseLibrary.Data.DatabaseConfigurationView.GetData baseSettings() Microsoft.Practices.EnterpriseLibrary.Data.DatabaseConfigurationView.GetData baseProviderData(String instanceName) Microsoft.Practices.EnterpriseLibrary.Data.DatabaseProviderFactory.GetConfig urationType(String instanceName) Microsoft.Practices.EnterpriseLibrary.Configuration.ConfigurationFactory.Cre ateInstance(String configurationName) Microsoft.Practices.EnterpriseLibrary.Data.DatabaseProviderFactory.CreateDat abase(String instanceName) Microsoft.Practices.EnterpriseLibrary.Data.DatabaseFactory.CreateDatabase(St ring instanceName) ConfigTest.WebForm1.Button1_Click(Object sender, EventArgs e) System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePo stBackEvent(String eventArgument) +57 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain() +1292 ---------------------------------------------------------------------------- ---- Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET Version:1.1.4322.2032 I even changed the version of the common, configuration, and data (Microsoft.Practices.EnterpriseLibrary) assemblies to 1.2.0.0 before running this application. The assemblies are stored in the bin folder under the virtual folder for the web app (not in the GAC, but I even tried that and got the same results - they can be stored in the GAC so they definitely are strong named assemblies). The references in VS.NET show these assemblies (common, configuration, and data) as version 1.2.0.0 and they are copied local to the web app (copied to its bin folder). I can't figure out why the Pre-bind state information is referencing Version=1.1.0.0. Any ideas on how to fix this problem? I was able to use these assemblies as "weakly named", but they are used in a work project by an assembly that is strongly named, so I needed to make them that way as well. Thanks! Tag: inline classes support in enterprise services Tag: 118283
  - 19
    - vs2005/sql server 2005 tutorial Hi I am looking for a step by step tutorial on how to do a winform database app using parameterised stored procedures. Any suggestions would be appreciated. Thanks Regards Tag: inline classes support in enterprise services Tag: 118280
  - 20
    - How to merge multiple datarows within a single dataset Hello all, I wonder how to merge multiple datarows within one single dataset? I have a dataset which contains one table, in this table, for example, there are 10 records, where rec#1 - 5 have the same content in column(0) and rec#6-10 have the same content in column(0), now I want to concatenate another column(1) for records that have same content in column(0). that is, the new dataset should have only two record: rec1's column(1) contains the text from previous rec1-5, and rec2's contains previous rec6-10 Can anyone tell me how to do it? I believe there should be a simple way. Thanks in advance. Tag: inline classes support in enterprise services Tag: 118279
  - 21
    - DataRow index within a DataRowCollection Is there anyway to determine the index of a DataRow within a DataRowCollection? I am using the Find() method of the DataRowCollection on my table to get me the record I am looking for, but it is returning a DataRow object and not the index of the object. Is there another way to find this? All I can find is Find()and Contains(). Thank you, Brian Tag: inline classes support in enterprise services Tag: 118278
  - 22
    - VS2005 Dataset Designer - dataenvironment hell reborn or a reliable tool? I have been reading about the new data features in VB 2005, and while the DataSet Designer promises to reduce development time, it also looks very much like the VB6 DataEnvironment which, for me at least, was a source of much grief which went away when I replaced it with straight ADO code, as well as being rather inflexible when changes are required. Can anybody tell me if the time saved writing less code with the DataSet Designer is going to just be postponed to support and bug fixes or is it really time saved creating reliable apps? Tag: inline classes support in enterprise services Tag: 118274
  - 23
    - can a menu on a base form be inherited and shown on another form? can a menu on a base form be inherited and shown on another form? How can i do this? Tag: inline classes support in enterprise services Tag: 118270
  - 24
    - Displaying Select columns(windows forms app) This is really stumping me. I have a dataset where I compute certain columns because I need to reorganize the data to a certain format, but I need to take the new columns and put them into a new dataset. I have a custom control where a user performs some actions and it combines certain columns or at least creates a new one with a name I can use. What I need is to bind a dataset to a grid with only the computed columns. I thought I would create a new DS and merge it with the doctored one, but no go, empty values with only the column headers. How do I get a dataset to be created from only certain columns in another dataset? Thanks in advance!! Paul Huff paul@postnexusinc.com Tag: inline classes support in enterprise services Tag: 118269
  - 25
    - copy query result to different DB Hi I 've got 2 databases on 2 different SQL servers. I need to copy the result of a stored procedure on SQL1 into a table in a database of SQL2. What would be the most efficient way of doing this. I'm slightly concerned about performance, since the query result can easily be 500000 records. Any suggestions? thanks Sue Tag: inline classes support in enterprise services Tag: 118257

is there a lack in the support of enterprise to inline classes?

i have a class and inside the class definition is defined another class.
the 2 classes are inheriting ServicedComponent.
in the com+ catalog (MMC) it is shown as Assembly.NS.classA+ClassB

in runtime i get error - cannot load type (ClassB) - the internal type
although it declared as public.

why?

10x.

Top