LINQ to SQL, over ASP.NET, DataContext.GetTable trouble

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
    - Dataset and XML Hi Gurus, I have a very simple question. Please answer. Is it true that when we load Data into a Datasets from SQLServer it loads it in XML format? I am curious to know how it loads data. I appreciate any knowledge I gain. Thanks Mark Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145563
  - 2
    - ExecuteDynamicInsert Bug I'm trying to simulate an "ON INSERT" AND "AFTER INSERT" trigger in LINQ the code I use is this: partial void InsertEvent(Event instance) { Group group = new Group(); group.GroupId = Guid.NewGuid(); group.DateCreated = DateTime.Now; group.OwnerId = instance.OrganizerId; group.Name = instance.Title + " Event Group"; group.Description = instance.Description; group.Permission = 3; base.ExecuteDynamicInsert(instance); ///this will fail because the database is unable to check the constrain ///on groupEvent.EventId /// /// NewDataContext context1 = new NewDataContext(); GroupEvent groupEvent = new GroupEvent(); groupEvent.GroupEventId = Guid.NewGuid(); groupEvent.GroupId = group.GroupId; groupEvent.EventId = instance.EventId; context1.GroupEvents.InsertOnSubmit(groupEvent); context1.SubmitChanges(); } base.ExecuteDynamicInsert(instance); lock the table in which instance is inserted so the constraint groupEvent.EventId = instance.EventId; on sql cannot be verified and the insert of GroupEvent fail.... any idea on how to do it? Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145562
  - 3
    - Visual Studio 2008 SP1(beta) - ADO Entity Data Model template is not available. Hi All I want to try out this tutorial http://blogs.microsoft.co.il/blogs/bursteg/archive/2008/05/12/visual-studio-2008-sp1-ado-net-data-service-walkthrough.aspx with the new ADO Data Service (code name Astoria). When I hit step 2, I can't find any item template ADO.NET Entity Data Model. Has anyone seen this problem with their installation of VS SP1 beta. Cheers, tc Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145547
  - 4
    - How to move table definitions? What is the easiest way to move table definitions between various databases? For example: if I have a excel spreadsheet with column headers, how can I move the table definition (excel seems to be able to detected data types like dates and integers and strings) to MSAccess or SQL server or MySQL? I was going to interrogate the data set for the column types and use ADOX to create the table definitions. The data set won't give me primary key and foreign key information though. Is there an easier way? Thanks, Siegfried Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145546
  - 5
    - Best way to reinvent bulk insert? Which is more efficient: a long series of SQL INSERT statements or deserializing a dataset from XML and saving it to the table? If I fill a dataset with current sample data and serialize it to XML, can I expect to use that as a template to subsequently populate the table in the future? This way I can keep the XML under version control as well. What function to I call to save a deserialized data set to a table? We have been using bulk insert with sqlcmd but that is difficult to debug and is specific to SQL Server. Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145540
  - 6
    - LINQ vs. Traditional ADO .NET As I start learning LINQ (and say to myself it's about time they came up with a simple way to do querying of various data models) I am forced to wonder, with the new classes in LINQ to SQL in particular, if there is any performance impact of using things like DataContexts and tables, rather than the traditional Connection, Command, DataSet classes. I know that these LINQ classes map to the ADO .NET classes, but is there any additional overhead to using them? Also, since Strongly-Typed datasets used to be the way to go as a best practice, does LINQ (and its table classes) make them obsolete for certain purposes? Thanks, Scott Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145538
  - 7
    - Run multiple queries simultaneously with SQL Compact 3.5??? is it possible to have several queries in 1 query command (as far as i read on the Microsoft pages this should be possible but i don't succeed): in fact something like: ... string sql = string.Format(select * from A; select * from B;); ... Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145534
  - 8
    - How to move data from xls files to MSAccess to SQLServer tables I have a VB.NET program that will load a DataSet from Excel file and serialize it to XML. Is there a simple way to create a table defintion (using ADOX?) from the data set and then populate the table? Thanks, Siegfried Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145528
  - 9
    - How to translate ado into ado.net? I want to translate the following script into VB.NET. Does ADO.NET have that feature of ADO where it can read Excel? What would the connection string? What classes would I use: the System.data.oleDB or system.data.ODBC? Thanks, Siegfried ' ' ' Begin commands to execute this file using windows scripting host with bash ' cscript query.vbs 080604FastPropAdams.xlsx ' End commands to execute this file using windows scripting host with bash On Error Resume Next Const adOpenStatic = 3 Const adLockOptimistic = 3 Const adCmdText = &H0001 for kk = 0 to WScript.Arguments.Count-1 Wscript.Echo "begin " & kk & " = " & Wscript.Arguments.Item(kk) Set objConnection = CreateObject("ADODB.Connection") Set objRecordSet = CreateObject("ADODB.Recordset") objConnection.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & WScript.Arguments.item(kk) & ";Extended Properties=""Excel 8.0;HDR=Yes;"";" objRecordset.Open "Select * FROM [Sheet1$]", objConnection, adOpenStatic, adLockOptimistic, adCmdText call DumpFieldNames(objRecordset) call DumpRecordSet(objRecordset) next Wscript.Echo "end query " Wscript.Quit Sub DumpFieldNames(objRecordset) dim sFieldNames sFieldNames = "" sFieldTypes = "" For ii = 0 to objRecordset.Fields.Count -1 If sFieldNames = "" Then Else sFieldNames = sFieldNames & ", " sFieldTypes = sFieldTypes & ", " End If sFieldNames = sFieldNames & objRecordset.Fields.Item(ii).Name & "(" & objRecordset.Fields.Item(ii).Type & "/" & objRecordset.Fields.Item(ii).DefinedSize & "/" & objRecordset.Fields.Item(ii).ActualSize & ")" sFieldTypes = sFieldTypes & objRecordset.Fields.Item(ii).Type Next WScript.Echo sFieldNames WScript.Echo sFieldTypes End Sub Sub DumpRecordSet(objRecordSet) jj = 1 Do Until objRecordset.EOF ' Wscript.Echo objRecordset.Fields.Item("Name"), objRecordset.Fields.Item("Number") dim sFieldValues sFieldValues = "" For ii = 0 to objRecordset.Fields.Count -1 If sFieldValues = "" Then Else sFieldValues = sFieldValues & ", " End If sFieldValues = sFieldValues & objRecordset.Fields.Item(ii) Next WScript.Echo " <div><a href='#' onclick='AddPushpin("""&sFieldValues&""");'>Add pushpin "&sFieldValues&"</a></div>" WScript.Echo " <div><a href='#' onclick='Find("""&sFieldValues&""");'>go to "&sFieldValues&"</a></div>" objRecordset.MoveNext jj = jj + 1 if jj > 8 then exit do end if Loop End Sub Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145526
  - 10
    - sp_setapprole problem (using LINQ) We have an application that need to call set application role to give rights to the database objects. I call 'sp_setapprole' but it's running into error when I try to GetUser to checks if the change was successfully. Code: ExecuteCommand("sp_setapprole 'rolename', 'password'"); 'Select User_Name()' It returns the message: "SQL Error - A severe error ocurred on the current command. The results, if any, should be discarded" (twice) In Event Log: Event Type: Error Event Source: MSSQLSERVER Event Category: (2) Event ID: 18059 ... ... Description: The connection has been dropped because the principal that opened it subsequently assumed a new security context, and then tried to reset the connection under its impersonated security context. This scenario is not supported. See "Impersonation Overview" in Books Online. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. When I use connection string with Polling=false, it runs without error. But the set application role is ignored. Do you know what is the problem with executing the approle ? How can I work with setting application roles ? Thanks in advance Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145521
  - 11
    - Parameterized query & datetime2 I am using a query for a SqlDataAdaptor to populate the DataSet a table. I use SqlCommandBuilder to create Insert/Update/Delete query. Can parameterized query be used in such a case such as WHERE MyColumn = @MyParameter? For a datatime2 column, what is the format for query? string.Format("WHERE MyDatetimeColumn = '{0}'", myDatetime.ToString("yyyy-MM-ddTHH:mm:ss.fff")) only gives to the millisecond. How to be as accurate as ticks? Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145520
  - 12
    - BeginEdit/EndEdit doesn't update row I have the following code: Dim strContentInfo As String = "ContentID='" & CUID & "'" Dim drContentInfo As DataRow() = GlobalDataSet.Tables("PaidContent").Select(strContentInfo) <Some other stuff happens here to set NumPlays> drContentInfo(0).BeginEdit() drContentInfo(0).ItemArray(2) = NumPlays drContentInfo(0).EndEdit() drContentInfo(0).AcceptChanges() GlobalDataSet.AcceptChanges() However the values in the dataset or even the datarow are not changing. No errors. I stepped through it to see what was happening and I coud not find any problems. The HasErrors on the row is false, the RowError = "", but the RowState says "Unchanged". What is wrong here? TIA, -- Anil Gupte www.keeninc.net www.icinema.com www.wizo.tv Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145519
  - 13
    - Inserting Multi Table Dataset into Dataset Hi, I have a dataset with 6 relational datatables within it. I want to insert the data into corresponding tables within a SQL db. Is there a quick way of doing it instead of having to loop through each table inserting the record and the child datatables? Using C# .NET 2 and SQL Server 2005. Thanks! Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145518
  - 14
    - GridView LINQ double foreign key I can run the following query in LinqPad from u in UsersInRoles select new {u.ApplicationID, u.ApplicationRoles.Application.ApplicationName} However, <asp:LinqDataSource ID="LinqDataSource1" runat="server" ContextTypeName="ApplicationManagment.ApplicationsDataContext" TableName="UsersInRoles" StoreOriginalValuesInViewState="False"> </asp:LinqDataSource> <asp:Label ID="lblApplicationName" runat="server" Text='<%# Bind("ApplicationRoles.Application.ApplicationName") %>'></asp:Label> Parser Error Message: A call to Bind was not well formatted. Please refer to documentation for the correct parameters to Bind. Is the double link not allowed or wrong syntax in a GridView? The Primary Key on ApplicationRoles is on ApplicationID, RoleID (FK to UsersInRoles) The tables are Applications (description of application; PK ApplicationID) ApplicationRoles (the roles allowed in an application ) UsersInRoles (users in a role for an application) Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145513
  - 15
    - Need help with LINQ Query If I perform a simple select query in my project I'm able to fill my gridview with no problem. However, once I wonder over to an aggregated query were I sum two columns I run into tons of problems. I also could never get this to work with a dataset. Since I only had one table I opted to use only a datatable. Is that problematic? Can someone help me out please? Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim dt As New Data.DataTable Dim dr As Data.DataRow Dim LineIn As String Dim XQ Dim LIN Dim ZA Dim StreamReader As System.IO.StreamReader dt.Columns.Add(New Data.DataColumn("Date", GetType(Date))) dt.Columns.Add(New Data.DataColumn("UPC", GetType(Int64))) dt.Columns.Add(New Data.DataColumn("QTY_Sold", GetType(Integer))) dt.Columns.Add(New Data.DataColumn("QTY_OnHand", GetType(Integer))) dt.Columns.Add(New Data.DataColumn("Unit_Type", GetType(String))) StreamReader = IO.File.OpenText("txt.txt") While StreamReader.Peek <> -1 LineIn = StreamReader.ReadLine() If Mid(LineIn, 1, 2) = "XQ" Then XQ = Split(LineIn, "*") ElseIf Mid(LineIn, 1, 3) = "LIN" Then LIN = Split(LineIn, "*") Else ZA = Split(LineIn, "*") dr = dt.NewRow() dr("Date") = Mid(XQ(2), 5, 2) & "/" & Mid(XQ(2), 7, 2) & "/" & Mid(XQ(2), 1, 4) dr("UPC") = LIN(3) dr("QTY_Sold") = "0" dr("QTY_OnHand") = ZA(2) dr("Unit_Type") = ZA(3) dt.Rows.Add(dr) End If End While StreamReader.Close() 'SELECT DATE, UPC, SUM(QTY_Sold), SUM(QTY_OnHand), Unit_Type FROM dt Dim results As IEnumerable(Of DataRow) = Aggregate o In dt _ Group By UPC_Group = o.Field(Of Int64)("UPC") _ Into test = Sum(o.Field(Of Integer)("QTY_Sold")), test2 = Sum(o.Field(Of Integer)("QTY_OnHand")) DataGridView1.DataSource = results.CopyToDataTable() End Sub End Class Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145510
  - 16
    - Checking db connection for initialising Hi I am passing an sqlconnection optional parameter as below; Optional ByVal DBConn As SqlClient.SqlConnection = Nothing I have given it an initial value of nothing howee rwhe I try to test for nothing like; If DBConn = Nothing I get an 'Operator '=' is not defined for types 'System.Data.SqlClient.SqlConnection' and 'System.Data.SqlClient.SqlConnection' error. What am I missing and how can I check if a value was in fact passed for the optional parameter DBConn? Thanks Regards Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145502
  - 17
    - Accessing sql server from behind isa 2000 Hi My app am unable to access a remote sql server (hosted by our web host) from a sbs 2003 premium (with isa 2000). The app bombs with the error; An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) I have tried osql command and I get below results; C:\Documents and Settings\Administrator>osql -E -Stcp:mysqlserver.com [DBNETLIB]SQL Server does not exist or access denied. [DBNETLIB]ConnectionOpen (Connect()). Do I need to open any ports on ISA Server 2000? The sql server is accessible fine from a standalone pc that is not connected to sbs. Thanks Regards Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145501
  - 18
    - .net 3.5 setup bombs Hi When I try to install .net 3.5 framework on a windows 2003 sp1 server it bomb with the following info; AppName: setup.exe AppVer: 9.0.21022.8 AppStamp:47316ce5 ModName: sitsetup.dll ModVer: 9.0.21022.8 ModStamp:47316ce2 fDebug: 0 Offset: 000c3223 What is the problem and how can I fix it? Thanks Regards Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145498
  - 19
    - insert data in an access db with C# (update) I've got the problem that after doing an INSERT, I can't see the new records in my database. What can I force an UPDATE, before close the databse? Thanks. Now, I'm doing... String evento = "1"; String suceso = "actualizacion"; String fecha = System.DateTime.Now.ToString(); String usuario = "user"; OleDbConnection myConn = new OleDbConnection(TabStripApp.Properties.Settings.Default.onlydentConnectionString); String cadena="insert into Log (Tipo_evento,Suceso,Fecha,Usuario) values ('"+evento+"','"+suceso+"','"+fecha+"','"+usuario+"')"; OleDbCommand myComm = new OleDbCommand(cadena, myConn); myConn.Open(); myComm.ExecuteNonQuery(); myConn.Close(); Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145495
  - 20
    - SQL XML query and serialized DataSet Crosspost : microsoft.public.dotnet.framework.adonet, microsoft.public.dotnet.general, microsoft.public.sqlserver.programming FU2 : microsoft.public.dotnet.general Hello, Do you know a clever method to convert an xml query result (FOR XML RAW, ELEMENTS, XMLSCHEMA, ROOT') into an serialized System.Data.DataSet ? Thanks. -- Fred foleide@free.fr Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145483
  - 21
    - Error running sql command Hi I have below code; Cmd = New SqlCommand("SELECT * FROM MyTable01", DBConnectionRemote()) Reader = Cmd.ExecuteReader() While (Reader.Read()) ID = CInt(Reader.GetValue(Reader.GetOrdinal("ID"))) Dim delstr As String = "DELETE FROM MyTable02 WHERE [MyTable2].ID = " & ID.ToString Dim delCmd As New SqlCommand(delstr, DBConnectionRemote()) delCmd.ExecuteNonQuery() End While I am getting a 'System.InvalidOperationException: There is already an open DataReader associated with this Command which must be closed first' error on the delCmd.ExecuteNonQuery() statement. What is the problem and how can I fix it? Thanks Regards Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145481
  - 22
    - login/password C# and access. Hello again! I've got a typical problem validating a user/pass through an access database with C#. I tried with two functions, and both tell me that the resulting string is out of context. How could I solve it? Thanks. Boolean comprueba_loguin(String usuario,String password) { String prueba,cadena; OleDbConnection myConn = new OleDbConnection(TabStripApp.Properties.Settings.Default.onlydentConnectionString); OleDbCommand myComm = new OleDbCommand("select usuario,password from usuarios", myConn); myConn.Open(); OleDbDataReader myReader = myComm.ExecuteReader(); if (myReader.HasRows) { cadena = myReader.GetString(0); myReader.Close(); return true; } else { myReader.Close(); return false; } } Boolean comprueba_loguin2(String usuario, String password) { String prueba, cadena; String sqlquery= "select usuario,password from usuarios"; String ConnectionString = TabStripApp.Properties.Settings.Default.onlydentConnectionString; OleDbConnection con = new OleDbConnection(ConnectionString); OleDbCommand cmd = new OleDbCommand(sqlquery, con); con.Open(); cmd.ExecuteNonQuery(); object resultquery = cmd.ExecuteReader(); string resultado = resultquery.ToString(); con.Close(); return true; } Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145476
  - 23
    - Accent Insensitive DataTable.Select I have a DataTable with data in it. I use the Select method to "find" certain rows. The problem with this method is that it performs an Accent Sensitive filter on the data. I need Accent Insensitive: Andr=E9=3DAndr=E8=3DAndre. I tried setting the DataTable Locale to CultureInvariant but it doesn't solve my problem. I can't find any information on how to create an Accent Insensitive CultureInfo. I also see the DataTable has a private CompareInfo field but I can't access it. If anyone can provide any kind of pointers to possible solutions, I would appreciate it. Thanks. Joel Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145469
  - 24
    - how to get information of unique constriantant form ODBC With ADO I can get such information from access or sqlserver,but it doesn't work on ODBC,what is right way for ODBC? -- jtz Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145468
  - 25
    - Oracle Cursors with .Net Hi, I am having an argument with our DBA, he is under the impression that it is the .net api always opens a cursor. However I believe that Oracle always opens a cursor for any select statement. Can someone shed some light? Regardless of what the answer is, why is it that oracle relies so heavily on cursors? -Edward Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145466
- Next
  - 1
    - LINQ-to-SQL Previous values? I have implemented a solution where I use LINQ-to-SQL to map all my objects to SQL database. Now I want to create an automated history log of the main objects. Objects are changed on several places in the application so my intention was to call an AddHistory method everytime the Insert and Update methods of the DBML file are called. The basic idea works fine, but I run into some tricky problems on the details. What is the best way to obtain previous values of the object? I would like to log a descriptive text to make the user understand what has happened. My first try was to call the database just before the saving, to read current database values just before they are changed. I created a temporary datacontext object and used it to return the single object. Then I compared all relevant properties between the current object and the database version and logged every difference. It worked fine for all simple properties but for extended properties compiled from related tables I have some problems. With extended properties I mean lookup values related to other tables. I don't want to refer to integer values but rather the friendly names the user is used to! If the temporary datacontext is closed before values are read I can not read values from other tables. But if I keep the temporary datacontext alive it will block cascading updates on related objects in same table. Is it possible to create ReadOnly datacontext that will not block updates? A completely different approach would be to create a detached oldvalue collection inside the object from the beginning. Before saving the object it would be easy to compare saving values with previous. But extended properties need to be taken into account here as well! If I retrieve a big collection of objects I don't want to slow down the initial work by retrieving a lot of lookup values from other tables. In most cases they will probably not be used anyhow. Can I somehow INSIDE my partial class code detect when the PropertyChanging event is fired? When a property is going to change seems to be a good place to retrieve the previous values. Any help is appreciated. Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145465
  - 2
    - Deserialize DataSet cuase err:Permission denied I try ADO 2 with binary like that: ====================== on server i send ms to client ====================== ds.RemotingFormat = SerializationFormat.Binary Dim myFormatter As Runtime.Serialization.IFormatter = New _ Runtime.Serialization.Formatters.Binary.BinaryFormatter ms = New MemoryStream myFormatter.Serialize(ms, ds) ================ on client I got the ms ================ ms.Position = 0 ds.RemotingFormat = SerializationFormat.Binary Dim myFormatter As Runtime.Serialization.IFormatter = New _ Runtime.Serialization.Formatters.Binary.BinaryFormatter ds = myFormatter.Deserialize(ms) the last line cause err: "Permission denied: cannot call non-public or static methods remotely." Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145460
  - 3
    - how force ds.WriteXml to add column even for column with null? how force ds.WriteXml to add column even for column with null value? Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145450
  - 4
    - Problem running delete query on remote server Hi My app's connection is with an access database but I am running the below query to delete records on a remote sql server; DELETE [My Table].* FROM [ODBC;Driver=SQL Server;SERVER=mysqlserver.net;DATABASE=mydatabase;UID=myusername;PWD=mypassword].[My Table] WHERE [My Table].ID = 3 I am getting a 'Could not delete from the specified tables' error and explanation is 'In order to evaluate an indexed property, the property must be qualified and the arguments must be explicitly supplied by the user.'. The Insert and Select queries on the remote server work fine from within Access. Also as I can delete the records manually form the remote server I presume there are no permissions issues. What is the problem and how can I fix it? Detailed stack trace is given at the end below. Thanks Regards System.Data.OleDb.OleDbException was unhandled ErrorCode=-2147467259 Message="Could not delete from specified tables." Source="Microsoft JET Database Engine" StackTrace: at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at IV.clsStaffProcessSiteDB.ProcessStaffSiteDB() in C:\HS Comm Server 2008\HS Comm Server\clsStaffProcessSiteDB.vb:line 216 at IV.modMain.ProcessStaff() in C:\HS Comm Server 2008\HS Comm Server\modMain.vb:line 23 at IV.modMain.Process() in C:\HS Comm Server 2008\HS Comm Server\modMain.vb:line 115 at IV.frmHSCommServer.Events_Timer_Tick(Object sender, EventArgs e) in C:\HS Comm Server 2008\HS Comm Server\frmHSCommServer.vb:line 52 at System.Windows.Forms.Timer.OnTick(EventArgs e) at System.Windows.Forms.Timer.TimerNativeWindow.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.UnsafeNativeMethods.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.DoApplicationModel() at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.Run(String[] commandLine) at IV.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() InnerException: Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145448
  - 5
    - learning C# ; first problem with access, and datasets Hi!! I'm doing a form to make a login, so, user and pass.... and so on. The problem is that first of all, I check how many records are in the table, and later I would like to make a do/while. With count it shows always '0' records, and there's 1 record. I've got a dataset called usuarios, and with: int numero; numero = usuarios.Tables.Count; Form1 formulario1=new Form1(); formulario1.Show(); IT shows a message like this: The name 'numero' does not exist in the curent context. And I don't understand... Furthermore, in the Form1, I'm doing the same with other table, and it works fine. Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145446
  - 6
    - Interaction command and functions (tutorial) Reason of this project: The Microsoft.VisualBasic.Interaction class exposes many useful commands and methods that were available in Visual Basic like AppActivate, Beep, Callbyname... This tutorial shows how to work with some of them. Project details: 1- From VB 6.0 to VB .net 2.0 2- Useful interaction commands 3- Samples of interaction commands 1- From VB 6.0 to VB .net 2.0 There was several changes on VB .net (it's a big change and that's clear). Although in an effort to make the transition from VB 6 to VB 2005 as easy as possible, Microsoft has gathered most of the Visual Basic 6.0 commands and functions in the Microsoft.VisualBasic.dll assembly. Some of the commands and functions was deleted, other still the same and others changed to the .net syntax. For Example: VbCrlf which is used on VB 6.0 (as a separator) still alive on VB .net 2.0 but a new syntax is already available for use. ControlChars.crlf is the new method As you are using VB .net I recommend that use the new syntax, and I'm going to introduce some of the important change between the old and the new syntax. 2- Useful interaction commands VB 6.0 syntax contain many useful interaction commands and function like the Message Box for example. Those commands still alive but have been improved in the .net 2.0 version. Shell Function: The shell function runs an executable program, it works like the command line so you can use it as a command line. The shell function is capable of returning an integer indicating if the program still running or not. The shell function was expanded in the .net 2.0 version and supports an additional argument that enables you to specify whether to wait until the shelled program terminates with an optional timeout. Use of the function Shell (Application Path, Style, Wait, Timeout) Example: ' Run Notepad.exe and wait until the user terminates it. Shell ("notepad", AppWinStyle.NormalFocus, True) AppActivate Function: AppActivate is a cool function that may be helpful if you are developing application for Windows. Now let see how this works and what it do. The AppActivate function as it names, activate a currently running application. How it activates? Simply by giving the focus to the application Window. The function is quite useful and require only to know the windows caption! Use of the function AppActivate ( Title) or AppActivate (ProcessID) NB: You have to choose either to use the title or the processID and not both! Now let's see this example ' Activate the NotePad Window AppActivate("Untitled - Notepad") Now as we know those simple functions we can use them to build helpful projects and application. Now see the sample of the interaction commands. 3- Samples of interaction commands This sample is exactly a direct (little expanded) application of the two functions that we have studied together right now. There's only one sample and if you run it you'll get a window with 2 buttons. Each button introduce a sample for each function. The button caption let you distinguish them. The Shell sample: Run a notepad application and return a message if the NotePad was closed. If the timeout was exceeded (5 seconds), return a message that the NotePad still running The AppActivate: The following sample run a notepad with no focus and use AppActivate to give it the focus. So the sample use both of the functions Download the source code http://thedotnetsource.blogspot.com/2008/05/tutorial-7-interaction-commands-and.html The Zip file contains: -The sample source code -The readme.txt file -The tutorial.txt file Still have question: Go to our blog (http://thedotnetsource.blogspot.com). Select the tutorial post. Post a comment describing your problem. If you have a general question, we highly recommend the MSDN Forums as the best Dot Net forums in the net. Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145445
  - 7
    - Update Concurrency Error I have a seemingly straightforward Update Query that works fine in query analyzer. However, when I put it into code either by using an TableAdapter Object data source, or Manually, I get a concurrency error and I can't figure out why... here's the basic sql for the update (followed by my manual attempt to program it) UPDATE PPU.tbl_Users_Main SET ProvNUID = @ProvNUID, ProvID = @ProvID, ProvHC_ID =@ProvHC_ID, ProvName = @ProvName, [Alias] = @Alias, Role = @Role, Type = @Type WHERE (UserID = @Original_UserID) Yes, I realize the shortcoming of using the words 'Alias' and 'Type', but the designer unfortunately, named it this and most of the program has code that already works with it, so although I hate to keep using the names, I may have to. Here is the attempt to program it into an aspx page using a lnk button: Protected Sub lnkEditUpdateIns_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles lnkEditUpdateIns.Click Select Case Me.lnkEditUpdateIns.Text Case "Edit" Me.lnkEditUpdateIns.Text = "Update" Me.lnkNewCancel.Text = "Cancel" EnableUserBoxes(True) SaveRecordForCancel() Case "Update" Dim NV As New PCPUser Dim SR As New PCPUser NV = GetNewValues() SR = Session("ssCur") 'update the user and return any error message Select Case UpdateUser(NV, SR) Case DBResult.Success Me.lnkEditUpdateIns.Text = "Edit" EnableUserBoxes(False) Case DBResult.ConcurrencyError Me.lblInform.Text = "Concurrency error" Case DBResult.DatabaseError Me.lblInform.Text = "An Error occured in the database" End Select Case "Insert" Me.lnkEditUpdateIns.Text = "Update" End Select End Sub Private Function GetNewValues() As PCPUser Dim SR As New PCPUser SR.ProvNUID = Me.txtNUID.Text SR.ProvID = Me.txtProvID.Text SR.ProvHC_ID = Me.txtHC_ID.Text SR.ProvName = Me.txtProvName.Text SR.ProvAlias = Me.txtAlias.Text SR.Role = Me.cmbRole.SelectedValue SR.ProvType = Me.cmbType.SelectedValue Session("ssNew") = SR Return SR End Function Public Shared Function UpdateUser(ByVal NewUser As PCPUser, ByVal OldUser As PCPUser) As DBResult Dim cn As SqlConnection = GetVitalsConnection() Dim sSqlCommand As String = "UPDATE PPU.tbl_Users_Main " _ & "SET ProvNUID = @ProvNUID, ProvID = @ProvID, ProvHC_ID = @ProvHC_ID, ProvName = @ProvName, [Alias] = @Alias, Role = @Role, Type = @Type " _ & "WHERE (UserID = @Original_UserID)" cn.Open() Dim cmdUsers As New SqlCommand(sSqlCommand, cn) With cmdUsers.Parameters .AddWithValue("@ProvNUID", NewUser.ProvNUID) .AddWithValue("@ProvID", NewUser.ProvID) .AddWithValue("@ProvHC_ID", NewUser.ProvHC_ID) .AddWithValue("@ProvName", NewUser.ProvName) .AddWithValue("@Alias", NewUser.ProvAlias) .AddWithValue("@Role", NewUser.Role) .AddWithValue("@Type", NewUser.ProvType) .AddWithValue("@Original_UserID", OldUser.UserID) End With Try If cmdUsers.ExecuteNonQuery() > 0 Then UpdateUser = DBResult.Success Else UpdateUser = DBResult.ConcurrencyError End If Catch ex As Exception UpdateUser = DBResult.DatabaseError End Try cn.Close() cn.Dispose() cn = Nothing End Function Private Function SaveRecordForCancel() As PCPUser Dim SR As New PCPUser SR.ProvNUID = Me.txtNUID.Text SR.ProvID = Me.txtProvID.Text SR.ProvHC_ID = Me.txtHC_ID.Text SR.ProvName = Me.txtProvName.Text SR.ProvAlias = Me.txtAlias.Text SR.Role = Me.cmbRole.SelectedValue SR.ProvType = Me.cmbType.SelectedValue Session("ssCUR") = SR Return SR End Function Any suggestions? Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145441
  - 8
    - Datagrid doesn't see restrictions on datatypes Hi I have the following XML Schema <xs:element name="MotionParameters"> <xs:complexType> <xs:sequence> <xs:element name="FeedRateMAX" > <xs:simpleType> <xs:restriction base="xs:double"> <xs:minExclusive value="0.0"/> <xs:maxExclusive value="1000.0"/> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="PlungeRateMAX" type="xs:double" minOccurs="0" /> <xs:element name="TravelRateMAX" type="xs:double" minOccurs="0" /> <xs:element name="TravelRate" type="xs:double" minOccurs="0" /> <xs:element name="PlungeRate" type="xs:double" minOccurs="0" /> <xs:element name="FeedRate" type="xs:double" minOccurs="0" /> <xs:element name="JogSpeedMode" type="xs:integer" minOccurs="0" /> <xs:element name="SeekXYSpeed" type="xs:double" minOccurs="0" /> <xs:element name="SeekZSpeed" type="xs:double" minOccurs="0" /> <xs:element name="JerkGrate" type="xs:double" minOccurs="0" /> <xs:element name="AccelerationG" type="xs:double" minOccurs="0" /> <xs:element name="AccelMAX" type="xs:double" minOccurs="0" /> <xs:element name="JerkMAX" type="xs:double" minOccurs="0" /> <xs:element name="CentripetalG" type="xs:double" minOccurs="0" /> <xs:element name="BrakeG" type="xs:double" minOccurs="0" /> <xs:element name="ArcError" type="xs:double" minOccurs="0" /> <xs:element name="MinLength" type="xs:double" minOccurs="0" /> <xs:element name="CornerPause" type="xs:double" minOccurs="0" /> <xs:element name="StartPause" type="xs:double" minOccurs="0" /> <xs:element name="JerkFactor" type="xs:integer" minOccurs="0" /> <xs:element name="CentripetalAcceleration" type="xs:double" minOccurs="0" /> <xs:element name="LinearAcceleration" type="xs:double" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> I read the schema in using a dataset as in the following: dsMachineParameters = new DataSet("MachineParameters"); mydatagrid = new DataGrid(); mydatagrid.DataSource = dsMachineParameters; dataGridView1.Controls.Add(mydatagrid); try { dsMachineParameters.ReadXmlSchema(xmlSchemaPath); dsMachineParameters.ReadXml(xmlPath); mydatagrid.Controls.Clear(); } catch (Exception err) { MessageBox.Show(err.Message); return; } I am still able to set values outside the range I set for FeedRateMAX? How do I make the grid understand the restrictions I have put on this value? I still able to change this value in the grid outside of the range I have set. -- Don Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145440
  - 9
    - SQLParamter setting. Hi all, i am having query which is using in operator and there i want to pass integetvalue. say like select * from employee where empid in(1,2,3); here empid i have to pass dynamically so how will i use sqlparameter for this? please help me asap. thanks in advance. Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145436
  - 10
    - lookup combobox not triggering INotifypropertychanged VS2005 in a Windows form I have a databound lookup combobox that is setup in the usual manner with the Text, DisplayMember and ValueMember all set and bound to a data object. In the Windows form when I drop down the combo box and click on a value the SET method of dataobject that it is connected to is triggered, however if I type in the first letter of one of the drop down selections, the SET is never triggered and consequently when I save the object the DB is updated with the wrong value. What can I do about this? Regards, Rick Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145433
  - 11
    - Enterprise library 4.0 Hi Is it worthwhile using enterprise library 4.0 for logging, exception handling and data access? Currently I am doing all this myself and am wondering if it is worth recoding to standardise to Enterprise Library. Are others using the library as a matter of routine? Thanks Regards Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145427
  - 12
    - Handling Strings in SQL server how to pass a string having delimitors in sql server cause it is give an error while saving. for ge. Name="'D'Malo'" for this string it is giving an error. how to resolve this. -- Message posted via DotNetMonster.com http://www.dotnetmonster.com/Uwe/Forums.aspx/dotnet-ado-net/200805/1 Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145426
  - 13
    - SQLDataReader and Stored Procedure Problem Hi, SQL2005 and .Net 2.0 I=92m experiencing some strange behavior between a SQLDataReader and a Stored Procedure. I=92m populating the DR and DataTable like this: oDR =3D oCmd.ExecuteReader(CommandBehavior.CloseConnection) oDT1.Load(oDR) Everything works fine until I add a =93where=94 clause to the select statement in the SP at which point the DR and DT report that no records are returned. Now I know what you=92re thinking =93Well duh, your where clause is eliminating the records=94. However the SP, when run in the EM (SQL Server Management Studio) shows there are results. Both the EM and the SqlCommand are calling the SP using the same parameters as verified using a trace. Below are a few variations of the select statement. What is interesting is that in all cases the SP returned values in the EM, but only in the last case did the DR recognize results. /* EM Works =96 DR does not */ select ca.SYS_CITY as GROUP_NAME, s.* from #sales2 s inner join CUSTOMER_ADDRESSES ca on s.COMPANY_CODE =3D ca.COMPANY_CODE and s.GROUP_FIELD =3D ca.ADDRESS_CODE where ca.CUSTOMER_NUMBER =3D @CustomerNumber order by s.COMPANY_CODE, s.GROUP_FIELD, s.SA_PERIOD /* EM Works =96 DR does not For Debugging force the parameter to be a known good value */ set @CustomerNumber =3D =91300162=92 select ca.SYS_CITY as GROUP_NAME, s.* from #sales2 s inner join CUSTOMER_ADDRESSES ca on s.COMPANY_CODE =3D ca.COMPANY_CODE and s.GROUP_FIELD =3D ca.ADDRESS_CODE where ca.CUSTOMER_NUMBER =3D @CustomerNumber order by s.COMPANY_CODE, s.GROUP_FIELD, s.SA_PERIOD /* EM Works so does the DR Hard code the value in the where clause */ select ca.SYS_CITY as GROUP_NAME, s.* from #sales2 s inner join CUSTOMER_ADDRESSES ca on s.COMPANY_CODE =3D ca.COMPANY_CODE and s.GROUP_FIELD =3D ca.ADDRESS_CODE where ca.CUSTOMER_NUMBER =3D =91300162=92 order by s.COMPANY_CODE, s.GROUP_FIELD, s.SA_PERIOD Also, yes, SET NOCOUNT ON in included in the procedure. Any ideas? What am I missing here? Thanks. Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145422
  - 14
    - Does Windows Include the Jet OLE DB provider? I'm looking for a straight answer to this question: Does Windows automatically include the Jet OLE DB provider? I've found it very difficult to get an answer. I found two Microsoft articles which seem to address the question (http:// support.microsoft.com/kb/271908 and http://support.microsoft.com/kb/239114), but they are confusing and contradictory. When I search the Usenet, I find posts which say an up-to-date version of Windows automatically has Jet, but I also find posts which explain how to install it when it is missing. Can anyone give me a definitive yes or no? -TC P.S. Note that I've danced around this question with posts in several newsgroups. Please forgive me for cross-posting. Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145417
  - 15
    - Data Transfer Question I need to transfer on a frequent base (e.g. every 10 minutes or so will be a parameter that can be set) for reporting purposes a subset (subset of records of a subset of tables) of data from a MySql db (on a laptop/pc) to a Sql Server db (on a server) via te Internet. The number of records (or the size of the data) is not that much (maybe 5-10MB each time). During every data transfer the new records must be added, modified records chnaged and deleted records deleted on the server db. I thought using a web service to achieve this, is this a good solution or are there better alternative solutions (integration services on the laptop/PC would be no option, since I have to minimize the the software to be installed on the pc/laptop)? I suppose lost Internet connections or other errors that might happen can be tackled by using transaction? Thanks. Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145410
  - 16
    - Are parameter arrays possible in XSDs? (This is, in a way, related to a previous post.) When defining a procedure in VB, it is possible to pass an array of variable length to it, and then parse it for content. Is there any way to do something similar in an XSD query created in Visual Studio 2005? What I need to do is pass a list of uncertain length to the IN clause of an XSD query. i.e. Select * from table1 where key1 IN (list) (Judging from what I've read so far, this appears impossible but I thought I'd give this forum one last try. I suppose I could use a stored procedure but I'm not sure I want to go that route.) Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145409
  - 17
    - App wants to send report Hi An app which was working fine has started to bomb at start-up.. It prompts to send report to Microsoft. I have uninstalled and reinstalled the app and the .net 3.5 but no luck. The error seems to mention win32.componentmodel or some such. What could be the problem and how can I fix it? Thanks Regards Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145406
  - 18
    - Typed DataSet with independent data provider? Hello I have a project (class library) for data layer of my solution that uses Typed DataSet. I want the Typed DataSet to be independent of the data provider. Is it possible to use Typed DataSet while the data provider is identified in app.config or web.config? Regards Hamed Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145404
  - 19
    - Odd parameter/sytax problem I'm writing a Winforms Dot Net 2.0 program that has an XSD. I need to call a query with a list of key values so I created a query: SELECT * FROM Table1 WHERE (key1 IN (@parm1)) where key1 is a char field and the only key field. Now if I run this in the SQL Query analyzer like this, with literals: SELECT * FROM Table1 Where (key1 In ('Value1', 'Value2')) it runs fine and returns what I expect. (2 rows) If I call it from my program or run it in VS Query builder, it returns nothing. Is it even possible to use a parameter in this fashion? Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145398
  - 20
    - OleDbDataAdapter - merging 2 tables Hello, I am trying to plonk the entire contents of a dBase file into an Access table. I have scanned the dBase fields and created an empty Access table with the same field formats. I have also created oledb connections to both data sources. Below is my attempt at achieving this, which doesn't work. I've googled all day and had lots of clues but not found any code that works for me. I think I'm close but obviously missing something quite important. It would be much appreciated if anyone could tell me what it is? Private Sub test() Dim strquerySource As String = "Select * from dBaseFile" Dim strqueryDestination As String = "Select * from accessTable" Dim daSource As OleDbDataAdapter Dim daDestination As OleDbDataAdapter Dim tableSource As New DataTable Dim tableDestination As New DataTable daSource = New OleDbDataAdapter(strquerySource, cnDBASE) 'if line below is NOT used then no error but no update. 'if it IS used then get error as commented later. daSource.AcceptChangesDuringFill = False daSource.Fill(tableSource) 'to visually check data - ITS OK, displays all data Me.DataGridViewDBASE.DataSource = tableSource Me.DataGridViewDBASE.Refresh() 'destination daDestination = New OleDbDataAdapter(strqueryDestination, cnAccess) daDestination.Fill(tableDestination) 'to visually check data - ITS OK, just shows headers Me.DataGridViewAccess.DataSource = tableDestination Me.DataGridViewAccess.Refresh() 'ERROR - IF daSource.AcceptChangesDuringFill = False ' "Update requires a valid InsertCommand when passed DataRow collection with new rows." ' otherwisae no error but the Access table doesn't get updated. daDestination.Update(tableSource) End Sub Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145397
  - 21
    - dataset datetime null Hi Is it possible to enter an sql null value to a dataset datetime field? Mark Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145396
  - 22
    - Not getting characters >128 with Orclae client but gettign with OL Hi, I am retreiving the the recordset from the Oracle 10 g database through OracleClient in VB.NET 1.1. One of my columns in recordset is having the characters with Ascii code > 127. I am able to retrieve those characters using System.Data.OLEDB but when we using System.Oracle.OracleClient we are not able to see those characters and jsut givign the squares. Given below the code used with OLEDB adn Oracleclient. Please help. ASAP ------------------------------------------------------- With OLEDB code and it is working ---------------------------------------------------- r Public Function GetSysCodeSettings() As HybridDictionary 'Dim strConnectionString As String = ConfigurationSettings.AppSettings("connectionString") Dim strConnectionString As String = "Provider=MSDAORA;User ID=iwdev01;Password=iwu1dev01;Data Source=FESRPTD1.World" Dim myDataReader As OleDbDataReader Dim mySqlConnection As New OleDbConnection(strConnectionString) Dim SpecCharArray As New HybridDictionary Try Dim mySysCodeCommand As New OleDbCommand mySysCodeCommand.CommandText() = "{call sp_fetch_iwsc(?,{resultset 0, iwsc02_out})}" mySysCodeCommand.Connection() = mySqlConnection mySysCodeCommand.Parameters.Add(New OleDbParameter("in_tbl_nm", "MorningStarSpecCharSettings")) mySqlConnection.Open() myDataReader = mySysCodeCommand.ExecuteReader() While myDataReader.Read() SpecCharArray.Add(myDataReader("COL_C"), myDataReader("VAL_X")) End While Finally If (mySqlConnection.State = ConnectionState.Open) Then mySqlConnection.Close() End If End Try GetSysCodeSettings = SpecCharArray End Function -------------------------------------------------------- WITH ORACLECLIENT adn it is not working ----------------------------------------------------------- ''this method get syscode settings for special char Public Function GetSysCodeSettings() As HybridDictionary Dim strConnectionString As String = "Data Source=FESRPTD1.World;User ID=iwdev01;Password=iwu1dev01;" Dim myDataReader As OracleDataReader Dim mySqlConnection As New OracleConnection(strConnectionString) Dim SpecCharArray As New HybridDictionary Try Dim mySysCodeCommand As New OracleCommand mySysCodeCommand.CommandText = "sp_fetch_iwsc" ''(?,{resultset 0, iwsc02_out}) mySysCodeCommand.CommandType = CommandType.StoredProcedure mySysCodeCommand.Connection = mySqlConnection mySysCodeCommand.Parameters.Add(New OracleParameter("in_tbl_nm", "MorningStarSpecCharSettings")) mySysCodeCommand.Parameters.Add(New OracleParameter("iwsc02_out", OracleType.Cursor)).Direction = ParameterDirection.Output mySqlConnection.Open() myDataReader = mySysCodeCommand.ExecuteReader() While myDataReader.Read() SpecCharArray.Add(myDataReader("COL_C"), myDataReader("VAL_X")) End While Finally If (mySqlConnection.State = ConnectionState.Open) Then mySqlConnection.Close() End If End Try GetSysCodeSettings = SpecCharArray End Function I giving the both code for your reference. Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145395
  - 23
    - LINQ in Enterprise Library Hi, Will LINQ supports to query an Xml file. I believe it supports both sql server and oracle. And also will enterprise library latets version supports LINQ? Thanks Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145392
  - 24
    - error numbers which can be generated by ADO.Net (Not SQL Server) Suppose in the case when SQL server is not responding (e.g. TimeOut error), ADO.Net has to handle this exception and return a specific number, and as per my knowledge this number is generated by ADO.Net itself (not from SQL Server), is there any place where i can get these number and its detail definition. I am using .Net Framework 1.1 Quick help will highly appreciated. Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145388
  - 25
    - updating datasource using 3-tier architecture Hi, I am retrieveing the data from 2 table (MAster Detail) to the winform and displaying on winform in a grid view.User should have an uption to update the rows.So There is a button Update wen ever a person clicks that DataSource needs to be updated.What i did is in Winforms for displaying the data i have a dataset.So wenever user clicks the update button here is what i am doing: BindingContext[dsAdmin, "MasterMovie"].EndCurrentEdit(); BindingContext[dsAdmin, "Show"].EndCurrentEdit(); Adminshow as1 = new Adminshow(); dsAdmin2 = as1.updateData(dsAdmin); I am passing the whole dataset to dataaccess layer. In Data Access Layer: public DataSet UpdateData(DataSet ds2) { SqlCommand cmd1 = new SqlCommand("INSERT INTO [Show] ([TheatreID], [MovieID], [Date], [NumberOfShows], [ShowTimes])" + " VALUES (@TheatreID, @MovieID, @Date, @NumberOfShows, @ShowTimes)", conn); dashow1 = new SqlDataAdapter(cmd1); SqlCommandBuilder cmb = new SqlCommandBuilder(dashow1); DataSet ds7 = new DataSet(); ds7=ds2; dashow1.Update(ds7, "Show"); ds7.AcceptChanges(); return ds7; } In BusinessLogic Layer i am just capturing this and passing it to Winform. But wen i close the WinForm and relod the table data again..Its still showing the old Data not the updated one?I am not getting any error also.. Please let me know how to go about this... Thanks, Raghav Tag: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble Tag: 145386

Hi,

Working with LINQ to SQL over an ASP.NET application (VS2008, .NET 3.5)
while calling
"MyDataContextInstance.GetTable<MyTable>()"
it produces sometimes the following exception:
"an item with the same key has already been added"

I think is some trouble about concurrency or async calls
(MyDataContextInstance is an static variable).
Could it be a problem related to ASP.NET application lifecycle management?
or...
a LINQ to SQL (DataContext) bug not supporting concurrency?

Thanks in advance for your time.

Néstor Sánchez A.

Top

Re: LINQ to SQL, over ASP.NET, DataContext.GetTable trouble by Miha

Miha
Sat Jun 14 05:43:13 CDT 2008

DataContext isn't thread safe:
"Any public static (Shared in Visual Basic) members of this type are thread
safe. Any instance members are not guaranteed to be thread safe."
(from the docs).

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

"Néstor Sánchez A." <nestor.sanchez@akzio.cl> wrote in message
news:e3VPGBXzIHA.524@TK2MSFTNGP05.phx.gbl...
> Hi,
>
> Working with LINQ to SQL over an ASP.NET application (VS2008, .NET 3.5)
> while calling
> "MyDataContextInstance.GetTable<MyTable>()"
> it produces sometimes the following exception:
> "an item with the same key has already been added"
>
> I think is some trouble about concurrency or async calls
> (MyDataContextInstance is an static variable).
> Could it be a problem related to ASP.NET application lifecycle management?
> or...
> a LINQ to SQL (DataContext) bug not supporting concurrency?
>
> Thanks in advance for your time.
>
>
> Néstor Sánchez A.
>
>

Top