How to Determine if a Record is Locked

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
    - Filling from inside a transaction? How can one fill a DataSet or DataTable from inside a transaction? I'm receiving an exception when the following Fill method is executed. DataTable dt = new DataTable(); OracleDataAdapter da = new OracleDataAdapter("SELECT * FROM dual", conn); da.Fill(dt); ### EXCEPTION ### Execute requires the Command object to have a Transaction object when the Connection object assigned to the Command is in a pending local transaction. The Transaction property of the Command has not been initialized. Tag: How to Determine if a Record is Locked Tag: 130772
  - 2
    - connection pooling My understanding of ADO.NET connection pooling as it relates to Sql Server is that once a connection is created and opened, behind the scenes ADO.NET adds this connection to a pool of connections with identical connection strings. If a connection is closed in code this does not necessarily mean that the connection is closed in the pool. Connections in the pool stay open based on some other set of parameters which I don't remember much about (neither the exact config settings, nor where the config settings are stored). I do remember that connections in the pool are gradually dropped off (perhaps down to a lower threshold) due to lack of use ... however , the key point is that in a highly scalable app such as a web app , opening a connection in code does not necessarily incur the total overhead. On opening a SqlConnection that has a connection string identical to an available connection in the pool with an identical connection string, the overhead is extremely low. Is the above generally true ? If so, where are the connection pooling config settings stored ? And how have things changed between SS2K and SS05 ? Tag: How to Determine if a Record is Locked Tag: 130766
  - 3
    - cannot debug on the webserver Seems to me that a lot of people have had this problem. I went through http://www.gotdotnet.com/team/csharp/learn/whitepapers/howtosolvedebuggerproblems.doc but none of the solutions worked. I'm still not able to debug my asp.net app. Any help is welcome... thanks, Tag: How to Determine if a Record is Locked Tag: 130763
  - 4
    - Access to the ADO.net Managed Provider 'SqlClientFactory' was denied in the data source with ID 'sdsNames' because of security settings. Anyone know what is causing this? I've just deployed a fairly basic site onto a Win 2003 server (ASP.NET 2.0, MS Sql Server 2005). Thanks! Tag: How to Determine if a Record is Locked Tag: 130756
  - 5
    - ExecuteXmlReader I have a table that has some data that is being read is a column with XML data. It is typed 'text' and the server is running 2000 so I don't have an option to type the column as XML. I would however like to use ExecuteXmlReader but I get an exception indicating that the data must be XML. How do I convince the client that it is XML data? My current query looks like: SELECT XMLSent FROM dbo.OutboundTable WHERE documentTransactionID=xxx AND OrderNumber='yyy' Right now I am doing ExecuteScalar to read the XML string in. It seems silly to read in a large chunk of "string" data, pass it to a MemoryStream, build an XmlReader, and then use that to build an XML document (specifically an XPath document because I want to do some XPath searches on the data). If I can get an XmlReader directly from the SQL query via ExecuteXmlReader it seems more efficient. Is this possible with the data structured as I indicated? I have looked at FOR XML but I have not had good luck yet. Any suggestions? Thank you. Kevin Tag: How to Determine if a Record is Locked Tag: 130754
  - 6
    - SqlCommand and multiple SQL statements Is the capability of System.Data.SqlClient.SqlCommand to execute more than one SQL statement (two SQL statements in CommandText separated by semicolon and just one Execute call) a supported feature that we can expect to continue to work in the future ? Arne Tag: How to Determine if a Record is Locked Tag: 130750
  - 7
    - Problem with Login control and web.config Hello everyone, I am desperate to solve this problem. I have built my website using Visual Web Developer. The website works perfectly fine when I test it on my computer. However it doesn't work when I upload to my website and test it over the internet. The website contains a simple login page and another page that is the destination page after logging in. The login page was built using a login control. This is my web.config file: /**********************************************************************/ <?xml version="1.0" encoding="utf-8"?> <configuration> <system.web> <compilation debug="true" /> <authentication mode="Forms" /> <customErrors mode="Off"/> </system.web> </configuration> /**********************************************************************/ I get an error on the login page, sometimes I get the following error: Could not load type System.Web.UI.WebControls.Login from assembly System.Web, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a. And sometimes I just get a question mark in the error field. Another problem is when I change the top of the web.config file <configuration> to the following <configuration xmlns=http://schemas.microsoft.com/.NetConfiguration/v2.0 > The error on the login page changes and specifies that I should set <customErrors mode="Off"/>. But I already have done that in the web,config file. Any help is much appreciated I am really struggling with this. Tag: How to Determine if a Record is Locked Tag: 130748
  - 8
    - Querying a join (Which method is better?) Hey folks, I have a quiz in my mind... When u have a query that u have 3 ou 4 tables involved (tables), I figure there r 2 solutions: 1) You write a SELECT for capturing fields in just one table, and then, based on values of FKs fields, u then go gathering information (always based on single SELECTs) in other tables. 2) You fire all in once 1 SELECT containing all the joins needed, bringing all the fields needed. Is 1st method so slower than second one? Currently I follow method 1, since my framework I created to abstract data access does not work with joins... Tag: How to Determine if a Record is Locked Tag: 130747
  - 9
    - Query Help - Distinct Row with Date Portion of a DateTime I have a table with a DateTime column and both the date and time portions of the field are used in the entries. But I want to write a query that'll do the following: Get a list of each distinct DATE from all of the rows of the DateTime column. So, for example, let's say the column is named "PurchaseDate", and some of the values look like: PurchaseDate 1/12/2006 3:25pm 1/12/2006 6:45pm 3/3/2006 12:05am 3/3/2006 1:22am I'd like the result of this query (for this example) to be a list as follows: DistinctDates 1/12/2006 3/3/2006 I know this is more of a SQL question than an ADO question but... help? Alex Tag: How to Determine if a Record is Locked Tag: 130739
  - 10
    - Vishual Studio.NET 2005 and Vishual Studio.NET 2003 I tried this code" Imports System.Windows.Forms " on VB 2005. My project type was class library. When I compile I had an error massage by saying that this type of code doesn't exists. But when I use the VB 2003 version My class library was sucssesfully compiled. Is there any coding differences between the two versions. Tag: How to Determine if a Record is Locked Tag: 130737
  - 11
    - Can't Use Typed Dataset from Class Library in .Net 2.0 - Help! I need to have several different applications on a multi-tiered system access a common data infrastructure. I'm trying to store a strongly typed dataset in a class library (dll) which contains resources common to all of the applications. I'm having problems. Right now I've got three projects in a solution. This is all .Net 2.0/C#. 1) asp.net web site. 2) win forms app 3) class library (dll) I've got a typed Dataset in the class library. The asp.net web site is able to reference the DLL and the contained Dataset without any problems. It works perfectly. The win forms app however is having problems. If I manually (programatically) add the data adapter then I can access the data, so I know the connections are good, but when I add it to the "data sources" menu and try to drag a gridview over to the web form, the only thing that shows up is a ClearBeforeFill check box... all of my table columns go away. To add the data source I'm going to Add New Datasource/object, browsing into the dll, and selecting the table data adapter for a specific table. I can see the table columns by adding the Dataset as the DataSource instead, but that doesn't get me anything since I need the adapter to do the work of actually getting the data... Has anybody else experienced this? How can I get my winforms app to properly use the Dataset? Thanks! Tag: How to Determine if a Record is Locked Tag: 130735
  - 12
    - Why do we serialize business objects ? Why do we serialize business objects? Tag: How to Determine if a Record is Locked Tag: 130734
  - 13
    - Adding new Strongly typed Row - BindingSource Errors This is a multi-part message in MIME format. ------=_NextPart_000_0006_01C6A26B.03227CB0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I am trying to add a new item to a table based on another item in the = same table. To do this I have the user click on the + button on the = navigator. A form is displayed where they enter the new primary key = information, tell it what type of templated Item to use and then press = ok. In the real world it is adding the row correctly to the database, = however I keep getting binding source errors whether it is positional = errors(no row at position 837) or invalid object errors(you can only add = the same item type to a binding list) depending on how I try rearanging my code it varies the error. Below is = the current itteration of my code. I have also had the = bindingsource_addnew function too ... Hope this is somewhat clear..... Private Sub ProductsBindingNavigatorAddNewItem_Click(ByVal sender As = System.Object, ByVal e As System.EventArgs) Handles = ProductsBindingNavigatorAddNewItem.Click Try fillProductInformation() Me.ProductsBindingsource.MoveLast() Catch ex As Exception End Try End Sub Fill Product information: Private Sub fillProductInformation() Try Me.Product =3D getProductData() If Not IsNothing(Product) Then Me.Products.AddProductsRow(Product) Me.ProductsTableAdapter.Update(Products) End If Catch ex As Exception End Try End Sub GetProductData: Private Function getProductData() As dsInvmgmtDataSet.ProductsRow Dim frm As New NewProductEntryForm Dim dlg As New DialogResult Try frm.ShowDialog() frm.Owner =3D Me dlg =3D frm.DialogResult If dlg =3D Windows.Forms.DialogResult.Cancel Then Return Nothing End If If frm.UseTemplate =3D True Then Product =3D getTemplateData(frm.TemplateProductCode) End If If frm.UseTemplate =3D False Then Product =3D getDefaultData(frm.NewProductCode, = frm.PrePackCheckBox.Checked) End If Catch ex As Exception End Try Return Product End Function Private Function getTemplateData(ByVal pluno As Integer) As = dsInvmgmtDataSet.ProductsRow Dim NewDataRow As dsInvmgmtDataSet.ProductsRow =3D = Products.NewProductsRow Dim Template As dsInvmgmtDataSet.ProductsRow Template =3D Me.Products.FindByPLUNo(pluno) NewDataRow =3D Template With NewDataRow .PLUNo =3D pluno .ProdCode =3D pluno .ItemNo =3D pluno .CustNo =3D 1 End With Return NewDataRow End Function Private Function getDefaultData(ByVal pluno As Integer, ByVal isPrePack = As Boolean) As dsInvmgmtDataSet.ProductsRow Dim NewDataRow As dsInvmgmtDataSet.ProductsRow =3D = Products.NewProductsRow Dim Template As dsInvmgmtDataSet.ProductsRow Try If isPrePack =3D True Then Template =3D = Products.FindByPLUNo(My.Settings.TrayPackDefaultProduct) Else Template =3D Products.FindByPLUNo(My.Settings.IcePackDefaultProduct) End If NewDataRow.ItemArray =3D Template.ItemArray.Clone With NewDataRow .PLUNo =3D pluno .ProdCode =3D pluno .ItemNo =3D pluno .CustNo =3D 1 End With Catch ex As Exception End Try Return NewDataRow End Function --=20 --Eric Cathell, MCSA ------=_NextPart_000_0006_01C6A26B.03227CB0 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.2873" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV>I am trying to add a new item to a table based on another item in = the same=20 table. To do this I have the user click on the + button on the = navigator. A form=20 is displayed where they enter the new primary key information, tell it = what type=20 of templated Item to use and then press ok. In the real world it is = adding the=20 row correctly to the database, however I keep getting binding source = errors=20 whether it is positional errors(no row at position 837) or invalid = object=20 errors(you can only add the same item type to a binding list)</DIV> <DIV> </DIV> <DIV>depending on how I try rearanging my code it varies the error. = Below is the=20 current itteration of my code. I have also had the bindingsource_addnew = function=20 too ...</DIV> <DIV> </DIV> <DIV>Hope this is somewhat clear.....</DIV> <DIV> </DIV> <DIV> </DIV> <DIV> </DIV> <DIV>Private Sub ProductsBindingNavigatorAddNewItem_Click(ByVal sender = As=20 System.Object, ByVal e As System.EventArgs) Handles=20 ProductsBindingNavigatorAddNewItem.Click<BR>  Try<BR> &nbs= p; fillProductInformation()<BR>   Me.ProductsBindings= ource.MoveLast()<BR>  Catch=20 ex As Exception</DIV> <DIV> </DIV> <DIV>  End Try</DIV> <DIV> End Sub</DIV> <DIV> </DIV> <DIV> </DIV> <DIV> </DIV> <DIV><STRONG>Fill Product information:</STRONG></DIV> <DIV>Private Sub=20 fillProductInformation()<BR>  Try<BR>   Me.Produ= ct =3D=20 getProductData()</DIV> <DIV> </DIV> <DIV>   If Not IsNothing(Product)=20 Then<BR>    Me.Products.AddProductsRow(Product)<BR>&n= bsp;   Me.ProductsTableAdapter.Update(Products)<BR> &= nbsp; End=20 If<BR>  Catch ex As Exception</DIV> <DIV> </DIV> <DIV>  End Try</DIV> <DIV> </DIV> <DIV> End Sub</DIV> <DIV> </DIV> <DIV> </DIV> <DIV><STRONG>GetProductData:</STRONG></DIV> <DIV>Private Function getProductData() As=20 dsInvmgmtDataSet.ProductsRow<BR>  Dim frm As New=20 NewProductEntryForm<BR>  Dim dlg As New DialogResult</DIV> <DIV> </DIV> <DIV>  Try<BR>   frm.ShowDialog()<BR> &nbsp= ; frm.Owner=20 =3D Me<BR>   dlg =3D frm.DialogResult</DIV> <DIV> </DIV> <DIV>   If dlg =3D Windows.Forms.DialogResult.Cancel=20 Then<BR>    Return Nothing<BR>   End=20 If<BR>   If frm.UseTemplate =3D True=20 Then<BR>    Product =3D=20 getTemplateData(frm.TemplateProductCode)<BR>   End = If</DIV> <DIV> </DIV> <DIV>   If frm.UseTemplate =3D False=20 Then<BR>    Product =3D = getDefaultData(frm.NewProductCode,=20 frm.PrePackCheckBox.Checked)<BR>   End = If<BR>  Catch ex=20 As Exception</DIV> <DIV> </DIV> <DIV>  End Try<BR>  Return Product</DIV> <DIV> </DIV> <DIV> End Function</DIV> <DIV> </DIV> <DIV> <STRONG>Private Function getTemplateData</STRONG>(ByVal pluno = As=20 Integer) As dsInvmgmtDataSet.ProductsRow<BR>  Dim NewDataRow = As=20 dsInvmgmtDataSet.ProductsRow =3D = Products.NewProductsRow<BR>  Dim=20 Template As dsInvmgmtDataSet.ProductsRow</DIV> <DIV> </DIV> <DIV><BR>  Template =3D=20 Me.Products.FindByPLUNo(pluno)<BR>  NewDataRow =3D = Template</DIV> <DIV> </DIV> <DIV>  With NewDataRow<BR>   .PLUNo =3D=20 pluno<BR>   .ProdCode =3D = pluno<BR>   .ItemNo =3D=20 pluno<BR>   .CustNo =3D 1<BR>  End With</DIV> <DIV> </DIV> <DIV>  Return NewDataRow</DIV> <DIV> </DIV> <DIV> End Function</DIV> <DIV> </DIV> <DIV> <STRONG>Private Function getDefaultData</STRONG>(ByVal pluno = As=20 Integer, ByVal isPrePack As Boolean) As=20 dsInvmgmtDataSet.ProductsRow<BR>  Dim NewDataRow As=20 dsInvmgmtDataSet.ProductsRow =3D = Products.NewProductsRow<BR>  Dim=20 Template As dsInvmgmtDataSet.ProductsRow</DIV> <DIV> </DIV> <DIV><BR>  Try<BR>   If isPrePack =3D True=20 Then<BR>    Template =3D=20 Products.FindByPLUNo(My.Settings.TrayPackDefaultProduct)<BR>  &= nbsp;Else<BR>    Template=20 =3D=20 Products.FindByPLUNo(My.Settings.IcePackDefaultProduct)<BR>  &n= bsp;End=20 If<BR>   NewDataRow.ItemArray =3D=20 Template.ItemArray.Clone<BR>   With=20 NewDataRow<BR>    .PLUNo =3D=20 pluno<BR>    .ProdCode =3D=20 pluno<BR>    .ItemNo =3D=20 pluno<BR>    .CustNo =3D 1<BR>   End=20 With<BR>  Catch ex As Exception</DIV> <DIV> </DIV> <DIV>  End Try</DIV> <DIV> </DIV> <DIV><BR>  Return NewDataRow</DIV> <DIV> </DIV> <DIV><BR> End Function</DIV> <DIV> </DIV> <DIV><BR>-- <BR>--Eric Cathell, MCSA</DIV></BODY></HTML> ------=_NextPart_000_0006_01C6A26B.03227CB0-- Tag: How to Determine if a Record is Locked Tag: 130725
  - 14
    - Access Date Format Hi guy, How can we make sure the date format that we pass in MS Access are constantly the format that we wish. I ask this is because My select statement work in some computer and some not. Even I have check the computer system date format there are same. What will effect the date format in MS Access. How to prevent this thing happen. I can't use access anymore if it work like that. Thanks in advance, With regards, Goh Tag: How to Determine if a Record is Locked Tag: 130722
  - 15
    - SQL connection timeout -- is it pretty useless or what? I'm trying to code a routine that will test the connection to a server and I would like to specific how long (aka timeout) the .Open() should wait before a timeout error is triggered. I've tried "connection timeout=10;" in the connect string, but that still doesn't timeout til 30 seconds have passed. I can't set the Connection.ConnectionTimeout as that is a read only property. So am I out of luck? Is there no way to quickly test a SQL connection in .NET 2.0? Operative being quickly as in I can define how long to wait? Please tell me I don't have to initiate a thread for the SQL connection and have the thread stop after xx seconds. There must be a more simple approach no?? VS 2005 is supposed to be RAD (rapid application development) not WAAD (work around application development). Thanks, Rob. Tag: How to Determine if a Record is Locked Tag: 130712
  - 16
    - How to set the SmallDateTime field I have a Table with a SmallDateTime field name OrderDate. I want to insert a record into this table, I use the SQL below: sSqlLogIns = "Insert Into hInfLog (OrderID, OrderDate) values ('{0}',{1}) "; sSqlLogIns = string.Format(sOrderID, DateTime.Now.ToString()); Was I use DateTime.Now.ToString() OK? or I must I use ToShortDateString() or others? Tag: How to Determine if a Record is Locked Tag: 130711
  - 17
    - DataView Filter Problem Running VB.Net I pass a datatable from a form.list to a form.item and use a dataview to show a selected row in text boxes. The row to show usesthe dataview's filter property with the selected row's row id. This works fine except for a row that has been added. The dataview correctly indicates the selected row and has a count of 1. However, the text boxes are showing a different row. The dataview's RowStateFilter is CurrentRows. Thanks. Tag: How to Determine if a Record is Locked Tag: 130706
  - 18
    - One table not updating after a few insertions Hello All, I'm having this problem which deals with 2 tables in a database. Both tables have a primary key set as an autonumber but also both tables are dependent on each other by having their primary key as a value in their tables. The problem is after a few insertions of records into the event table the rowcount always stays the same. When I open the event table a new row is present and the new autonumber is there. The new value of the 'headerid' from the HeadOrder table overwrites the previous 'headerid' record in the Event table. Could it be because of the autonumber? The eventid autonumber starts at 39 while the headerid autonumber starts at 49 and increments by 1. When the new row in the Event table 'eventid' reaches 46, the headerid overwrites the previous record of 55 and becomes 56 but the headerid at new row stays empty. Example of the table Event before new row is inserted EventID HeaderID 29 39 30 40 . . 45 55 after new row is inserted EventID HeaderID 29 39 30 40 . . 45 56 'The value of HeaderID is overwritten whereas it should of 46 been inserted in the next record here is the code where this happens: 'Fill required headerid to event table dbInventaire.Open() sqlstring = "select * from Event" updater2 = New OleDb.OleDbDataAdapter(sqlstring, dbInventaire) CmdBuilder = New OleDb.OleDbCommandBuilder(updater2) CmdBuilder.QuotePrefix = "[" CmdBuilder.QuoteSuffix = "]" updater2.UpdateCommand = CmdBuilder.GetUpdateCommand Try updater2.Fill(ds2, "Event") table2 = ds2.Tables.Item(0) row2 = table2.Rows(table2.rows.count - 1) 'Problem is in this line row2("HeaderID") = CInt(headeridx) updater2.Update(ds2, "Event") dbInventaire.Close() Catch ex As Exception MsgBox(ex.Message) dbInventaire.Close() EndTry I'm using VB.NET 2005 with ADO.NET and MS Access 2003. Tag: How to Determine if a Record is Locked Tag: 130704
  - 19
    - Combobox en vb.net con informacion del AS400 Hola Tengo un problema con una pantallita que estoy realizando, lo que quiero es cargar un combobox con informacion de una biblioteca del AS400 pero me marca un error, el siguiente: " La operacion de multiples pasos de OLE DB genero errores. compruebe los valores de estado de OLEDB si es posible. No se realizo ningun trabajo" El codigo que tengo para caragr el combobox es el sig: ---------------------------------------------------------------------------= ----------------------------------------------------------------- Private Sub llenarcombo_partner() Dim cnAS400 As New OleDbConnection("Provider=3D IBMDA400.DataSource.1; User ID=3DF48IE99;PWD=3DF48IE99;Data Source=3DS1028R0M;persist security info=3DFalse; SSL=3DDEFAULT; Transport Product=3DClient Access") Dim dadatos As New OleDbDataAdapter("select EDIV20F.O=D1PP0.PPPNBR, EDIV20F.O=D1PP0.PPNAME from EDIV20F.O=D1PP0 where EDIV20F.O=D1PP0.PPPTYP=3D'1'", cnAS400) Dim dsdatos As New DataSet Try dadatos.Fill(dsdatos, "EDIV20F.O=D1PP0") cboplanta.DataSource =3D dsdatos.Tables("EDIV20F.O=D1PP0") cboplanta.DisplayMember =3D dsdatos.Tables("EDIV20F.O=D1PP0").Columns("PPNAME").ToString cboplanta.ValueMember =3D dsdatos.Tables("EDIV20F.O=D1PP0").Columns("PPPNBR").ToString Catch ex As Exception MessageBox.Show(ex.Message) End Try End Sub ---------------------------------------------------------------------------= ---------------------------------------------------------- Si alguien me puede ayudar se los agradezco Saludos!! Karina Tag: How to Determine if a Record is Locked Tag: 130699
  - 20
    - DAAB is good????? I dont think so... I have just opened DAAB code and saw that, incredibly alll functions return only Sql objects. That means this App Block does not deal with Oracle or even other DB like MySQL. I dont understand who would use this... Tag: How to Determine if a Record is Locked Tag: 130698
  - 21
    - word document to appear from treeview how? greetings! I am new to this, so if I am in the wrong discussion group, I apologize. I would like to 1)use a treeview component (in Web Developer 05 Express) to make a Word document open up. Do I use the .COM component Microsoft Office Data Source control or something else? After reading the treeview documentation, it looks like I should write code on the "SelectedNodeChanged" event--is this correct? any suggestions on where I should go to look? thank you, julie Tag: How to Determine if a Record is Locked Tag: 130694
  - 22
    - ObjectSpaces is realy good? Hey, I have been using a tool for generating persisting classes (its called MyGeneration)...I not even use DAAB (I was rather creating my own DAAB). Now MS says ObjectSpaces is a good integrated O/RM tool, that will eliminate any needs for writing SQL queries...should I trust this ??? Cause, I am about to start a new huge project and wouldnt be happy to throw all away in the middle of the way if decision is not the right one.... What do u think about? Tag: How to Determine if a Record is Locked Tag: 130692
  - 23
    - ANN: C# Online.NET en Español PARA SER PUBLICADO INMEDIATAMENTE La primera referencia en Español en línea basada en la tecnología Wiki sobre C# y .NET se encuentra en C# Online.NET Dallas, TX ? Un nuevo concepto en referencias en línea para los lenguajes de programación de Microsoft .NET está siendo estrenado por primera vez por C# Online.NET?una nueva referencia en línea basada en la tecnología wiki. C# Online.NET ofrece documentación, tutoriales, y ejemplos de código para los lenguajes .NET empezando con C#. "Comparado con Java," dice Will Wagers, fundador de C# Online.NET, "hay una escasez de ayuda en línea para el lenguaje C#." C# Online.NET está enlistando a contribuyentes voluntarios para escribir artículos, tutoriales, y snippets de código en C# (fragmentos de código listos para ser usados). Estas ofertas tienen por objetivo alcanzar a todos los programadores y diseñadores de C# desde los principiantes hasta los arquitectos en el lenguaje. La tecnología Wiki permite que virtualmente cualquier persona que posea una conexión al internet pueda editar, ver y escribir documentación usando su navegador. "La ventaja de usar la tecnología Wiki de código abierto es que podemos recolectar la energía de los diseñadores de C# de todo el mundo para crear un mega-recurso para la comunidad de C#." La culminación de nuestro proyecto es crear la versión en Español de C# Online.NET. Debido a que hay proporcionalmente menos recursos disponibles sobre C# y .NET en Español, estamos muy contentos de que los hispano-hablantes ahora puedan tener acceso y puedan editar información en nuestro sitio. Si tu eres un hispano-hablante y te gustaría contribuir con el éxito de la tecnología .NET en los países de habla hispana, ayúdanos a desarrollar este recurso único escribiendo artículos o tutoriales, donando fragmentos de código en C# o traduciendo material en Inglés al Español. Contacto: C# Online.NET Sitio en Español: http://es.csharp-online.net/ Sitio en Inglés: http://www.csharp-online.net/ Weblog oficial: http://blog.csharp-online.net/ Foros de discución: http://forum.csharp-online.net/ [ ANN: C# Online.NET en Español ] [English version follows] FOR IMMEDIATE RELEASE First Spanish-Language, Wiki-based, Online C# and .NET Reference at C# Online.NET Dallas, TX ? A new concept in online references for Microsoft .NET programming languages is being pioneered by C# Online.NET?a new wiki-based, online C# and .NET reference. C# Online.NET offers documentation, tutorials, and C# source code examples for .NET languages beginning with the C# language. "Compared to Java," says Will Wagers, founder of C# Online.NET, "there is a dearth of online C# help." C# Online.NET is enlisting the aid of volunteer contributors to write articles, tutorials, and C# code snippets (ready-to-use fragments of C# source code). Offerings will target all C# programmers and developers from beginner to architect. Wiki software allows virtually anyone with an Internet connection to edit, view, and write documentation using their Web browser. "The advantage of using open source wiki software is that we can harness the energies of C# developers worldwide to create a mega-resource for the C# community." Our latest project is a Spanish language version of C# Online.NET. Because there are proportionally fewer C# and .NET resources available in Spanish, we are very excited that Spanish speakers can now access and edit information on our site. If you are a Spanish speaker and would like to contribute to the success of .NET in Spanish-speaking countries, help us develop this unique resource by writing articles or tutorials, by donating C# code fragments, or by translating English materials into Spanish. Contact: C# Online.NET Spanish site: http://es.csharp-online.net/ English site: http://www.csharp-online.net/ Official Weblog: http://blog.csharp-online.net/ Forums: http://forum.csharp-online.net/ [ ANN: C# Online.NET in Spanish ] Tag: How to Determine if a Record is Locked Tag: 130691
  - 24
    - Long running stored procedure I have a very long stored procedure "runMRP". approx 1000 lines and can runs for 30 minutes at Query Analyser. It runs sucessfully at query analyser with all the result. It runs successfully on osql. It runs fine from VB.Net program on small data set. (with less than few sec running time) It always crushes when I runs from VB.Net program with large data set. The Exception catch from VB.Net side (SQLException) is "Cursor is READONLY. The statement has been terminated.". The code is a simple data adaptor call: objCmd = objConn.CreateCommand objCmd.CommandText = "runMRP" objCmd.CommandType = CommandType.StoredProcedure objCmd.CommandTimeout = 0 objAdp.SelectCommand = objCmd objAdp.Fill(myDs) ' fail here I use VS 2005, .Net 2.0 and SQL Server 2000. 1. I have set the CommandTimeout to 0 (and at the SQL server side, I set the Query Timeout to 0), is there any other place that timeout could occur? 2. I have great difficulty to debug this problem. At VB.Net side, when I trace to objAdp.Fill line, it will pass to SQL Server to execute the command. I have no way to know what is going on. At the SQL Server side, I can't see what is going on. Is there any tools that can help? 3. Any suggestion to solve this problem? regards Locus Tag: How to Determine if a Record is Locked Tag: 130683
  - 25
    - Access Lock Remains after Connection Closed - OLE DB / Jet I am using a non-pooled OLE DB connection to add records to an access database. The database is an empty template database that is copied to the running application directory for a set of objects. For each objects a set of records are saved to the database, the database is stored elsewhere, and the clean template file is copied over the database in the application directory. I have been having random problems with corruption in this database and have been trying to track down the issue. In all of the databases that have been corrupt I have found records belonging to the object that was processed previously. This has led me to believe that the copy operation may not be completing or something is remaining in memory that is making access think it still has the records from the file that was overwritten. I have double and triple checked that the connection is being closed and have had other developers confirm that everything seems to be working as it is supposed to. I am checking that the connection state is open, closing and then disposing of the connection. However; the lock file is remaining after this has happened and remains still after the file is overwritten by the template to create a clean copy for the next object to be processed. I have used the LDB Viewer and confirmed that for each object that is processed, a user is showing up as accessing the database. I have tried explicitly turning off connection pooling by adding "OLE DB Services=-4;" to my connection string, but ths did not solve the problem. I am open to any suggestions. Thank you for any help that can be offered. -Mike Tag: How to Determine if a Record is Locked Tag: 130678
- Next
  - 1
    - Referencing another SQL Server database table I am a new user of Visual Basic Express / SQL Server 2005 Express editions. I am trying to write sql statements in an application database that reference tables in another database (same SQL server). Based on the prior posts that I've read, it would seem this is pretty straight forward by specifying a full database path prior to the table name. However, when I execute this SQL through ADO, I get an error message indicating an "invalid object name". Eaxmple: queryString = _ "SELECT * FROM BelvedereMasterApplicationDB.dbo.LOAN_DATA WHERE LOAN_NUM_BLVD<=2;" Dim command2 As New System.Data.SqlClient.SqlCommand(queryString, m_ConnString) Dim reader2 As System.Data.SqlClient.SqlDataReader = command2.ExecuteReader() Is there something that I'm missing? Thanks. Tag: How to Determine if a Record is Locked Tag: 130674
  - 2
    - Can VS2003 vb .net app connect to SQL Server 2005 Everywhere? I have Visual Studio 2003 VB .net application that currently access MS Access database. Does anybody know that if it is possible for these applications connect to SQL Server 2005 Everywhere thru adonet? Since VS2003 is using .net framework 1.1, and SQL Server 2005 everywhere uses .net framework 2.0, is this possible? Thanks Tag: How to Determine if a Record is Locked Tag: 130669
  - 3
    - Strange Problem. Unable to run stored procedure: I apologize if I am posting this to the wrong area. Here is my problem. I am running a .NET 2003 Windows service against Oracle 9i. This service is attempting to run a stored proc that inserts data into the DB. When it calls the proc it gets the following error. "Unable to run stored procedure: " It doesn't return the name of the procedure or an error number or anything useful. I know what proc it is calling but I have no idea what error it is actualy getting. I have tracked this all the way down into the ADO .NET oracle provider and I still see no error number. I have run this exact code against another instance of the database and I DO NOT get the error. So, one DB throws the error and one does not. Has anyone see this before? THanks. Mark. Tag: How to Determine if a Record is Locked Tag: 130665
  - 4
    - Datagrid Refresh Hi All, I hope someone can help me with this. I am working with real time data.Where on one end there is a desktop application & on the other hand a PDA both communicating with SQL Server 2000 database. Now my problem is that the datagrids(Infragistics UltraGrid in this case) on the desktop are taking alot of time to be refreshed.I would be glad for any suggestions regarding the performance issues. Thanks, Ritesh Tag: How to Determine if a Record is Locked Tag: 130659
  - 5
    - AutoGenerated TableAdapter and GenerateDbDirectMethods I have a typed dataset. It has a single datatable. I used the wizard in VS.Net 2005 to generate it. It is setup to do a Select from a database view in SQL Server. The view in question is updateable as it has an instead of trigger attached. But GenerateDbDirectMethods of true throws an error saying "The type of the database object does not allow to set GenerateDBDirect to true." Now I can understand why because it must look at the view SQL and see joins and assume its not updateable but we handle all that through triggers. If I can get the TableAdapter to generate my Update and Delete command it will work but the designer refuses to do that or allow me to override it's assumption that it's readonly. Has anyone else hit this problem? What is the work around? Tag: How to Determine if a Record is Locked Tag: 130654
  - 6
    - ADOX: Copy table structure with C#? Hello, I am working with an Access database file and want to create a new file with the same table structure. Creating the new file was no problem, also creating new tables with adjacent keys worked well. But copying the indexes is a pain. My testing table has 4 indexes and the code runs 4 times through the loop, just as expected. There is no error when try to append the Index to the new table. But the follwing code throws an exception "Index already exists" in the last line, in which I append the table to my catalog class. Am I doing something wrong? Do you have any ideas? Is there a more elegant way to copy a DB structure. Thank you in advance, Jens Hellmann --- Code --- private void copytable( string pTableName ) { ADOX.Column lNewCol; ADOX.Table lNewTable; ADOX.Table lSrcTable; ADOX.Key lNewKey; ADOX.Index lNewIndex; lNewTable = new ADOX.Table(); lNewTable.Name = pTableName; // Gets the ADOX.Table object where Name equals pTableName // This is the original table from the existing database. lSrcTable = getTablepTableName); // Copy Columns for (int i = 0; i < lSrcTable.Columns.Count; i++) { lNewCol = new ADOX.Column(); lNewCol.Name = lSrcTable.Columns[i].Name; lNewCol.Type = lSrcTable.Columns[i].Type; lNewCol.DefinedSize = lSrcTable.Columns[i].DefinedSize; lNewTable.Columns.Append(lNewCol, lNewCol.Type, lNewCol.DefinedSize); } // Copy Keys for (int i = 0; i < lSrcTable.Keys.Count; i++) { lNewKey = new ADOX.Key(); lNewKey.Name = lSrcTable.Keys[i].Name; lNewKey.Type = lSrcTable.Keys[i].Type; lNewTable.Keys.Append(lNewKey.Name,lNewKey.Type, lSrcTable.Keys[i].Columns[0].Name,"",""); } // Copy Indexes for ( int i = 0; i < lSrcTable.Indexes.Count; i++ ) { lNewIndex = new ADOX.Index(); lNewIndex.Clustered = lSrcTable.Indexes[i].Clustered; lNewIndex.IndexNulls = lSrcTable.Indexes[i].IndexNulls; lNewIndex.Name = lSrcTable.Indexes[i].Name; lNewIndex.PrimaryKey = lSrcTable.Indexes[i].PrimaryKey; lNewIndex.Unique = lSrcTable.Indexes[i].Unique; lNewTable.Indexes.Append( lNewIndex.Name, lSrcTable.Indexes[i].Columns[0].Name ); Debug.WriteLine( "SCHLEIFE i : " + i.ToString() ); } Catalog.Tables.Append(lNewTable); } Tag: How to Determine if a Record is Locked Tag: 130645
  - 7
    - VB 2005 newbie - Databinding Tag: How to Determine if a Record is Locked Tag: 130637
  - 8
    - Raccomandata on line Avendo visto il servizio di Raccomandata on line mi sono chiesto se sia possibile inviare in modo automatico una raccomandata direttamente dal software. Tipo pulsante invia raccomandata. Grazie FLAVIO Tag: How to Determine if a Record is Locked Tag: 130634
  - 9
    - VB.NET 2005 TableAdapter In VB.NET 2005, the ADO.NET provide TableAdapter for Developer eaily code the query and parameter query by "Query Builder". I can build a single parameter or multi parameters SQL Query by using "Query Builder" (WHERE ClientCode = @ClientCode ....etc) But how about if I wanna to build a programmatic SQL statament, say if the User select ClientCode and OrderType buttom on UI, I will processing the SQL statment as: WHERE ClientCode ... AND OrderType ....; if the User select ClientCode and OrderType and Status, the SQL statement now processing as: WHERE ClientCode ... AND OrderType .... AND Status ...... Is that anyway to code the above SQL by "Query Builder" in TableAdapter !? Tag: How to Determine if a Record is Locked Tag: 130626
  - 10
    - Permission denied error in Javascript Hi, I my web application, am using frames. <frameset name="aaframe" rows="190px,64.0%,45px" > <frame name="aframe" language="vb" src="../Top_page.aspx" frameBorder="0" noResize scrolling="no"> <frameset name="bframe" cols="25%,75%"> <frame name="rleft" src="../Aspx/Left_page.aspx"> <frame name="rright" src="../Aspx/Right_Page.aspx"> </frameset> <frame name="cframe" language="vb" src="../bottom_page.htm" frameBorder="0" noResize scrolling="no"> </frameset> Now, in Right Page when user presses on a button called "FullScreen", I change percentage of aaframe rows to "0%, * ,0%" by following code. function showFullScreen() { if (document.Form1.Image_FullScreen.title == "Switch to Full Screen") { parent.aaframe.rows = "0%,*,0%"; parent.bframe.cols = "25%,75%"; document.Form1.Image_FullScreen.title="Switch to Normal Screen"; document.Form1.Image_FullScreen.src="normalscreen.jpg" } else { parent.aaframe.rows = "190px,64.0%,45px"; parent.bframe.cols = "25%,75%"; document.Form1.Image_FullScreen.title="Switch to Full Screen"; document.Form1.Image_FullScreen.src="fullscreen.jpg" } } This maximises my page. The code works fine when the page loads for the first time. When the page reloads after some click event, I get a javascript error "Permission Denied". Can anyone hlpe me out whats the issue? Thanks, Tanmaya Tag: How to Determine if a Record is Locked Tag: 130622
  - 11
    - How to make a DataTable Independent I have a DataTable, it belong to a DataSet. How can I insert this DataTable to another DataSet? Tag: How to Determine if a Record is Locked Tag: 130616
  - 12
    - Questions about Excel Object Model I have been digging through MSDN and this group for solutions, but I'm just left with questions. Can I use the object model to create a XLS file from scratch on a machine that doesn't have Excel installed on it? Right now my solution is just creating an XML file formatted so excel can read it however I have to add a chart to one of the workbooks and I don't believe I can accomplish that through XLM. If anyone has a link to an example of this it'd be appreciated. Thanks, Tim Tag: How to Determine if a Record is Locked Tag: 130615
  - 13
    - ANN: C# Online.NET Summer 06 Contest FOR IMMEDIATE RELEASE C# Online.NET Summer 06 Contest Apress Publishing and C# Online.NET have joined forces to reward the most prolific contributors to C# Online.NET. Our contributors are all volunteers from around the Globe: They write articles, source code, and tutorials for the benefit of the C# and .NET communities. They manage to combine giving back with personal growth. And, we all benefit from their labors of love. Apress is making it possible to reward their, essentially, selfless contributions by donating 5 Grand Prizes. They will be welcome additions to any C# or .NET developer?s library. Each Grand Prize comprises a set of three current Apress titles: 1. Expert C# 2005 Business Objects, Second Edition 2. Pro C# 2005 and the .NET 2.0 Platform, Third Edition 3. Pro SQL Server 2005 So, read the rules--link on front page--for the C# Online.NET Summer 06 Contest and you may win these great titles from Apress for your personal IT library. C# Online.NET English site: http://www.csharp-online.net/ Spanish site: http://es.csharp-online.net/ Official Weblog: http://blog.csharp-online.net/ Forums: http://forum.csharp-online.net/ [ ANN: C# Online.NET Summer 06 Contest ] Tag: How to Determine if a Record is Locked Tag: 130611
  - 14
    - Index column in Dataset (or Datareader) !!!! When I put the a Select command result into a dataset (or datareader), I have to inform which column index I want to work with...thats pretty akward , since I have to know in advance exactly the order the column appears in Select command. It gets complicated if we r talking of 30 columns. In ancient VB, I would use Enums to help in this, is there any intelligent way in .NET to solve this topic? Thanks to all ! Tag: How to Determine if a Record is Locked Tag: 130604
  - 15
    - Enterprise Library (what should I use...) Hi, what is really worthwhile to use of Ent Library framework (e.g. Data Access Application Block) ? Who has used in practice ? Thanks a lot ! Tag: How to Determine if a Record is Locked Tag: 130599
  - 16
    - OleDbDataReader "Closed" Problem I've made some changes to the structure of my code around a bunch of my pages which access the database and now I'm getting a very occasional error at DataBind() time saying that my OleDbDataReader object is already closed. I'm working on debugging this but, in the mean time, I wanted to see if someone could explain to me *when* a DataReader object gets closed, because this comfuses me. I'm assuming that the DataReader object gets closed and becomes inaccessible when the Database Connection object is closed. Fine. But other their other circumstances when the DataReader gets closed even when the database Connection is still open? Alex Tag: How to Determine if a Record is Locked Tag: 130598
  - 17
    - ANN: SQLite ADO.NET 2.0 Provider v1.0.30.1 Released http://sqlite.phxsoftware.com Features: Written from scratch on VS2005 specifically for ADO.NET 2.0, implenting all the base classes and features recently introduced in the framework, including automatic transaction enlistment. Supports the Full and Compact .NET Framework, as well as native C/C++ development. 100% binary compatible with the original sqlite3.dll. Faster than Sql Mobile, has less than half the memory footprint too. Databases are 100% portable and are fully-contained. Completely portable across platforms, so just copy the file from the desktop to the Pocket PC to deploy it. Encrypted database support. Encrypted databases are fully encrypted (data and schema) and support both binary and cleartext password types. Extensive schema support. DbConnection.GetSchema(...) support includes the MetaDataCollections, DataSourceInformation, Columns, Tables, Views, ViewColumns, Catalogs, Indexes, IndexColumns and ForeignKeys keywords. Visual Studio 2005 Design-Time Support, works with all versions of VS2005, including all Express Editions. You can add a SQLite database to the Servers list, design queries with the Query Designer, drag-and-drop tables onto a Typed DataSet, etc. Single file redistributable. The core sqlite3 codebase and the ADO.NET wrapper are combined into one multi-module assembly. Binaries included for Itanium, x64, x86 and ARM processors. DbProviderFactory support. Full support for ATTACH'ed databases. Exposed as Catalogs in the schema. When cloning a connection, all attached databases are automatically re-attached to the new connection. Enhanced DbDataReader.GetSchemaTable() functionality returns catalog, namespace and detailed schema information even for complex queries. Named and unnamed parameters. Full UTF-8 and UTF-16 support, each with optimized pipelines into the native database core. Multiple simultaneous DataReaders (one DataReader per Command however). Full support for user-defined scalar and aggregate functions, encapsulated into an easy-to-use base class in which only a couple of overrides are necessary to implement new SQL functions. Full support for user-defined collating sequences, every bit as simple to implement as user-defined functions and uses the same base class. Full source for the entire engine and wrapper. No copyrights. Public Domain. 100% free for commercial and non-commercial use. Tag: How to Determine if a Record is Locked Tag: 130591
  - 18
    - DataTable internal index is corrupted?!?!?! Hi all, Some code of mine which has been working for well over nine months, in a recent build (with unassociated changes) has just stopped working. I have a DataTable, which belongs to a DataSet created in the designer. This is bound to a DataGridView to represent the data. I have a CSV file import routine, which parses through a CSV file, creates a new row and adds it like thus: DataSet1.MyTable.AddMyTableRow(newRow) This line now crashes out with the error: DataTable internal index is corrupted: '5'. Any ideas why?! I've tried surrounding the above statement with .BeginLoadData and .EndLoadData, with no success. Thanks in advance! Tag: How to Determine if a Record is Locked Tag: 130590
  - 19
    - typed DataRow Hi, I'm using VS2003 C# I'd like to use a typed dataRow in an iteration by using the TableRow property of the Dataset so that I can use the instance to directly access the col. for example: foreach (dsmyDataSet.myTableRow tr in dsmyDataSet.myTable) { TreeNode myNode = new TreeNode(tr.RowCol); } I get an error saying it denotes a field where a class was expected. Isn't the 'myTableRow' a class? How can I do this? Many thanks for input in advance Ant Tag: How to Determine if a Record is Locked Tag: 130576
  - 20
    - How to read OleDbSchemaGuid tables 1 record at a time ? Hi, if we have an OleDbConnection it is possible to retrieve a datatable containing information about the database fields using the statement (watch out line breaking): OleDbConnection.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Columns, New Object() {}) This however return a whole DataTable, which in some cases can be very large. For instance if you do it with SAP you receive over half million rows. My question: I would like to do the same operation programmatically and not using the statement GetOleDbSchemaTable. Possibly taking 1 record at a time, similarly to the DataReader mechanism. Can anyone suggest how to achieve that? -Tom Tag: How to Determine if a Record is Locked Tag: 130572
  - 21
    - kader Kader; soru:madem,her=FEey bir kader defterinde yaz=FDl=FD ve her=FEey ona g=F6re oluyor.o halde insanlar ni=E7in cehenneme gidiyor? cevap:evet her=FEey bir kader defterinde yaz=FDl=FD ve her=FEey ona g=F6re oluyor.ama,defterde yaz=FDl=FD oldu=F0u i=E7in o =FEey olmuyor. mesela;meteroloji uzman=FD,uydudan gelen foto=F0raflara bakarak gelece=F0i g=F6rebilmektedir.bir insan ne kadar y=FCkse=F0e =E7=FDkarsa hem g=F6r=FC= =FE alan=FD geni=FEler hemde gelece=F0i g=F6rebilir. uzman, uydudan g=F6r=FCyor ki,T=FCrkiye"nin bat=FDs=FDndan ya=F0mur bulutlar=FD geliyor.bulutlar=FDn h=FDz=FDn=FD ve y=F6n=FCn=FC hesapl=FDyarak,hemen defterine =FEunlar=FD yaz=FDyor,"yar=FDn t=FCrkiye bulutlu ve ya=F0=FD=FEl=FD olacak".bulutlar=FDn gelmesine bir g=FCn var.bir g=FCn sonra t=FCrkiye bulutlu ve ya=F0=FD=FEl=FD olsa;acaba meteroloji uzman=FD bir g=FCn =F6nced= en deftere,bu olay=FD yazd=FD=F0=FD i=E7inmi olaylar oluyor?yoksa uzman olaylar=FD uydudan =F6nceden g=F6rd=FCdemi yazd=FD. do=F0ru cevap;g=F6rd=FCde yazd=FD.yazd=FD=F0=FD i=E7in olaylar olmamakta,fa= kat olay=FDn =F6yle olaca=F0=FDn=FD =F6nceden g=F6r=FCp yazm=FD=FEt=FDr. Mesela;akl=FD ba=FE=FDnda bir ki=FEiyi, siz s=FDrt=FDn=FDza alsan=FDz,nereye gitmek istersen seni oraya g=F6t=FCrece=F0im deseniz,diyelim ki iki yol var biri,tehlikeli yol, =F6teki tehlikesiz yol.siz ba=FEtan o ki=FEiye uyar=FDda bulunarak her iki yolun durumunu anlatsan=FDz buna ra=F0men,o ki=FEi beni tehlikeli yoldan g=F6t=FCr dese,o tehlikeli yolda ba=FE=FDna bir kaza gelse ,size diyebilirmi ki,bak senin y=FCz=FCnden ba=FE=FDma bu kaza geldi diyemez.=E7=FCnk=FC kendi iradesiyle tehlikeli yolu se=E7mi=FEtir.g=F6t=FCren de=F0il,isteyen su=E7ludur.G=FC=E7 ve kuvvet yaln= =FDz Allah"tand=FDr.bunu fel=E7li hastalar daha iyi bilir.G=F6t=FCren Allah"t=FDr, fakat tehlikeli yolda gitmek isteyen,insan su=E7ludur. Hem insan ba=FE=FDbo=FE b=FDrak=FDlm=FD=FE da de=F0ildir. C=FCz-i iradesinden b= a=FEka kendisine ait g=FCnahlar=FD ve bor=E7lar=FD vard=FDr.sevaptaki hissesi ise pek azd=FDr.Kimin ve neyin sayesinde sevap i=FElemi=FEtir d=FC=FE=FCnmesi gerekir. Allah; birzaman gayet zengin bir ressam,sergi a=E7mak istemi=FE,fakat sahnenin gerisinde durmu=FE kendisini konuklara g=F6stermemi=FE.konuklara hert=FCrl=FC ikram=FD yapm=FD=FE.sergiyi gezen misafirler,harika resimlere bakm=FD=FElar,ne kadar g=FCzel resimler diyerek aralar=FDnda konu=FEurlarken birisi, ressam=FD g=F6remedi=F0i i=E7in, acaba bu resimler nas=FDl olmu=FEt= ur diye bir soru ortaya atm=FD=FE.bir k=FDs=FDm insanlar,bu resimler kendi kendine olmu=FEtur demi=FEler.bir k=FDs=FDm insanlar resimleri tabiiyyat kanunlar=FDn=FDn yapt=FD=F0=FDn=FD iddia etmi=FEler.bir k=FDs=FDm insanlar = ise resimleri,resmi meydana getiren,boya,f=FDr=E7a, tablo birlikte bu resmi kafa kafaya vermi=FEler meydana getirmi=FEtir demi=FEler.bir k=FDs=FDm insanlar ise,harika resimleri ancak bir ressam taraf=FDndan yap=FDlabilece=F0ini s=F6yleyerek,kendilerine ikramda bulunan ressam=FD i=E7eriden,alk=FD=FElar ile davet edip,kendisiyle tan=FD=FEm=FD=FE ve te=FEekk=FCr etmi=FEler.i=FEte biz o ressama Allah diyoruz.ressamdan fark=FD, ger=E7ek ve canl=FD resimler yaratmas=FDd=FDr. Resim,ressam=FDn bir parcas=FD olmad=FD=F0=FD gibi; ressam da, resmin bir par=E7as=FD de=F0ildir. Soru:Peki,Allah"=FD kim yaratm=FD=FEt=FDr?sorusu(=FEeytan=FDn insanlar=FD kand=FDrmak i=E7in sordu=F0u sorudur) genellikle insanlar=FDn kafas=FDn=FDn kar=FD=FEmas=FDna yol a=E7m=FD=FE,bu soruda tak=FDl=FDp kalm=FD=FElard=FDr. =DDnsanlar=FDn bu sorunun cevab=FDn=FD bulmaya =E7al=FD=FEmas=FD,nafiledir. Mesela; diyelimki bir saraya girmek i=E7in y=FCz kap=FD var,ama bir kap=FD kapal=FD ve saray=FDn sahibi ancak o kap=FDy=FD a=E7abilir ve anahtarda sadece ondad=FDr.D=FD=FEar=FDdan saraya girmeye =E7al=FD=FEan biri,a=E7=FDk doksandokuz kap=FDn=FDn herhangi birinden i=E7eri girebilir.Fakat kapal=FD kap=FDn=FDn =F6n=FCnde durup o kap=FDy=FD a=E7amay=FDnca,bu saraya girilemez diyemez,=C7=FCnk=FC di=F0er doksandokuz kap=FD a=E7=FDkt=FDr.Aynen =F6ylede,Allah"=FD kim yaratm=FD=FEt=FDr, sorusu farzedelim ki kapal=FD bir kap=FDd=FDr.O kap=FDn=FDn anahtar=FD sadece Allah"tad=FDr.Allah"a inanmak i=E7in doksandokuz kap=FD a=E7=FDkt=FDr.Ama inat edip,kapal=FD kap=FDn=FDn =F6n=FCnde durmak ve saray sahibini inkar etmek ve a=E7=FDk kap=FDdan saraya girmemek ak=FDl kar=FD de=F0ildir. Peki Allah yoksa,bu kainat=FD kim yaratm=FD=FEt=FDr? bu kainat nas=FDl olmu=FEtur?yani yukar=FDdaki harika resimler nas=FDl olmu=FEtur? sorusunun cevab=FDn=FD inat edenlerin vermesi gerekir. =DDlmin kap=FDs=FD Hz.Ali =FE=F6yle der,"Varsayal=FDm ki inanmayan inat edenlerin dedi=F0i gibi Allah,ahiret,cennet,hesap kitap, vs.yok.Ne inanana bir =FEey olur,nede inanmamakta inat edene.Ama ya varsa,"inanana yine bir =FEey olmaz ama inanmamakta inat eden; i=FEini =FEansa b=FDrakm=FD=FE olur ki buda ak=FDl kar=FD de=F0ildir. Tevekk=FCl ve dua; bir =E7if=E7i,evvela(=F6n=FEart);=FCr=FCn almak i=E7in,1-topra=F0=FDn=FD na= dasa koyacak,2-topra=F0=FDn=FD s=FCrecek,tohumu dikecek,3-sulayacak.vb.fiili dua edecek. Sonra; Allah"a ,=FCr=FCn vermesi i=E7in kavli(s=F6zl=FC) dua edecek.=C7=FCnk=FC bir afet gelir =FCr=FCn=FC al=FDp g=F6t=FCrebilir.Mesela;=C7ekirge ve sel afeti gibi.=DEartlardan birinin eksik olmas=FD,neticeye engeldir. Dua eden ki=FEi i=E7in o istedi=F0i, kendisi hakk=FDnda hay=FDrl=FD olup olmad=FD=F0=FDn=FD dua eden bilemez.O halde duam niye,ni=E7in kab=FCl edilmedi diye,=FCz=FClmemelidir. Mesela;Bir anne ve baba hi=E7bir zaman =E7ocu=F0unun k=F6t=FCl=FC=F0=FCn=FC istemedi=F0i i=E7in ,terbiyeye muhta=E7 =E7ocu=F0unun her istedi=F0ini de yapmaz .Bu imtihan d=FCnyas=FDnda,s=FDn=FDrl=FD ve kay=FDtl=FD oldu=F0umuz i=E7in her istedi=F0imizi elde edemeyiz,her istedi=F0imizi yapamay=FDz.Fakat her istedi=F0imizi elde edecek ve her istedi=F0imizi yapabilece=F0imiz bir yer vard=FDr ki o yere cennet derler. Her =FEeye muhta=E7 olan ki=FEinin , Samed olan Allah"=FDn kap=FDs=FDn=FD =E7almas=FD do=F0ru bir =FEeydir.Yanl=FD=FE olan, her=FEeye muhta=E7 bir ki=FEinin, kendisini hi=E7bir=FEeye muhta=E7 olmad=FD=F0=FDn=FD zannetmesi = ve dua etmemesidir. =DEeytan, =DEeytan"=FDn asl=FD cin olup ate=FEten yarat=FDlm=FD=FEt=FDr.=DDnsan=FDn apa=E7=FDk,bir d=FC=FEman=FDd=FDr.Mahlukat=FD,Allah"a d=FC=FEman etmek i=E7= in f=FDrsat kollar. Bu hayat=FD insanlar i=E7in cehenneme =E7evirmeye =E7al=FD=FE=FDr. =DDnsan, =FEeytan"dan herbak=FDmdan =FCst=FCnd=FCr.Fakat =FEeytan"=FDda hafife almamak gerekir.=C7=FCnk=FC Hz.Adem babam=FDz ile Hz.Havva annemizin cennetten =E7=FDkmas=FDna vesile olmu=FEtur.Biz =FEeytan=FDn inad=FDna,bu d=FCnyay=FD cennete =E7evirmek i=E7in =E7al=FD=FEmal=FDy=FDz. Sak=FDn sizi =FEeytan, Allah afedicidir diye yan=FDltmas=FDn.=C7=FCnk=FC, Allah af edicidir ama, kul hakk=FD hari=E7tir. =DEeytan,Allah"=FD inkar etmemektedir ama,O"na d=FC=FEman oldu=F0u,iman etmedi=F0i i=E7in ezeli ve ebedi olarak cehennemden =E7=FDkamayacakt=FDr. =DDnkar etmemek ayr=FDd=FDr,iman etmek ayr=FDd=FDr,hi=E7 inanmamak ise,hi= =E7mi hi=E7 ak=FDl kar=FD de=F0ildir.=DDnsanlar korku ile =FCmit aras=FDnda olmal= =FD. Acaba cennetlikmiyim, yoksa cehennemlikmiyim sorusunu merak etmek yerine, en k=F6t=FC ihtimali g=F6z =F6n=FCne alarak, tedbirimizi almak; daha ak=FDll=FDca bir i=FE olsa gerektir.Allah'tan ancak O"na iman etmeyenler,=FCmidini keser. Son nefese kadar,kimin ne olaca=F0=FD,(=FEeytan hari=E7)bizce mechuldur.Cennet ucuz olmad=FD=F0=FD gi= bi, cehennem dahi l=FCz=FCmsuz de=F0ildir. Din, Her semavi hak dinler,medeniyetin ve insan=FDn maddeten ve manen y=FCkselmesini,daha iyiye ve ileri gitmesini savunur. =DDslam,bir lokma bir h=FDrka felsefesine kar=FE=FDd=FDr.Yar=FDn =F6lecekmi=FE gibi, ahirete, hi=E7 =F6lmeyecekmi=FE gibi d=FCnyaya te=FEvik eder,=DDki g=FCn=FC ayn=FD= olan ziyandad=FDr,kom=FEusu a=E7 iken, tok yatan bizden de=F0ildir, haks=FDz yere bir insan=FD =F6ld=FCren,t=FCm insanl=FD=F0=FD =F6ld=FCrm=FC=FE gibidir, d=FC=FE=FCncesini savunur.Tek ilah vard=FDr. O ilah=FDn ad=FD Allah"d=FDr. Zerrece Allah"a iman=FD olan ve O"na d=FC=FEman olmayan herkez, hesaptan sonra cennete girecektir. =DDslam; Peygamberi Hz.Muhammed"tir,Kitab=FD Kuran-=FD Kerim"dir. Bir M=FCsl=FCman,hem =DDncile,hem Hz.=DDsa"ya, hem,Tevrata, hem Hz.Musa"ya yani t=FCm semavi kitap ve peygamberlere zaten inand=FD=F0=FD i=E7in din de=F0i=FEtirmesi, hi=E7mi hi=E7 ak=FDl kar=FD de=F0ildir. Namaz, Dininin dire=F0idir.Bir insan,Allah"=FDn benim namaz=FDma ihtiyac=FD yoktur,demesi,hasta birinsinin,doktara "ey doktor senin ilaca ne ihtiyac=FDn var demesine benzer ki,Allah"=FDn bizim namaz=FDm=FDza elbetteki ihtiyac=FD yoktur,bizim namaza ihtiyac=FDm=FDz vard=FDr.Bedenin havaya ve suya ihtiyac=FD oldu=F0u gibi, ruhunda manevi g=FDdaya ihtiyac=FD vard=FDr ki o g=FDdalardan biriside "Hu" kelimesidir.=DDnsanlar her nefes veri=FEte bilmeden,gayri ihtiyari "hu" derler.Hu ,Allah demektir.Asl=FDnda her =FEey Allah"=FD anmaktad=FDr.=DDnsan=FDn bu d=FCnyaya g=F6nderilmesinin sebebi ve hikmeti ,Allah"=FD tan=FDmak ,O"na dua ve ibadet etmektir. Hayat, Helal =FEekilde; =C7al=FD=FE=FDn=FDz,kazan=FDn=FDz,yiyiniz,da=F0=FDt=FDn=FDz,payla=FE=FDn=FD= z,ama israf etmeyiniz.Kara g=FCnler, ya=FEl=FDl=FD=F0=FDn=FDz ve ahiret i=E7inde,az=FDk ay=FDr=FDn=FDz. =DDlimin ,mal=FDn ve kuvvetin =F6nemini fark ediniz.Bunlar=FD insanl=FD=F0=FDn hayr=FD i=E7in ve helal bir =FEekilde kullan=FDn=FDz. =DEeytan=FDn,d=FCnyay=FD fesada veren ve insanlar i=E7in d=FCnyay=FD =E7ehenneme =E7eviren,sen =E7al=FD=FE ben yiyeyim ve ben tok olay=FDm ba=FEkas=FD a=E7l=FDktan =F6ls=FCn bana ne d=FC=FE=FCncesini ,ortadan kald= =FDrmak ve sosyal dengeleri kurmak i=E7in =E7al=FD=FEmak insanl=FD=F0a yap=FDlacak = en b=FCy=FCk hay=FDrlardan biri olsa gerektir. =DDlim, Bir zaman iki ayna var imi=FE,her iki aynada y=FCzlerini g=F6kteki g=FCne=FEe =E7evirmi=FE,aynalarda akseden,tecelli eden g=FCne=FEi , insanlar=FDn y=FCzlerine her iki ayna da =E7evirdi=F0inde, insanlar=FDn g=F6zlerini kama=FEt=FDrm=FD=FElar. Aynalardan biri gururlanarak ben insanlar=FDn g=F6zlerini kama=FEt=FDrd=FDm diye gururlanm=FD=FE ve kendisin= de bir =FEeyler oldu=F0unu tevehh=FCm, zan etmi=FE.Di=F0er ayna ise m=FCtevaz= =FD bir=FEekilde,asl=FDnda kendisinde bizatihi bir =FEey olmad=FD=F0=FDn=FD,g=F6kteki g=FCne=FE olmasa hi=E7bir=FEeye yaramad=FD=F0= =FDn=FD, =F6nceki aynaya s=F6ylemi=FE. =DD=FEte gururlu ayna, sihir ve b=FCy=FC gibi zararl=FD ilimler ile ilgilenip insanlar=FD kendisinin etkiledi=F0ini zanneden =FEeytan gibidir.Ama m=FCtevaz=FD ayna ise m=FCcize ve kerametin as=FDl sahibinin kendisi olmad=FD=F0=FDn=FD bilen ve faydal=FD ilimler ile ilgilenen bilge ki=FEidir.G=FDbta edilecek ki=FEi g=F6kteki g=FCne=FEin =FD= s=FD ve =FD=FE=FD=F0=FDna mazhar olan kendisini g=FCne=FE zannetmeyen ama g=FCne= =FEi g=F6steren, ki=FEidir.Bu aynalar=FDn en g=FCzelleri peygamberlere aittir.en k=F6t=FCleri ise =FEeytan ve =FEeytan gibilere aittir. =DEeytan ve =FEeytan gibi k=F6t=FC ki=FEilerin =FEerrinden Allah"a s=FD=F0=FDnmak gerektir.=C7=FCnk=FC insanlar=FD ve insanl=FD=F0=FD tesirleri alt=FDna alabilmekte ve aldatabilmektedirler.Her insan kabiliyeti nispetinde g=FCne=FEe mahzar olabilir ve olmal=FDd=FDrda. As=FDl olan aynay=FD insanl=FD=F0=FDn hayr=FDna kullanmak ve ayna oldu=F0unu hi=E7birzaman unutmamakt=FDr.Aynadan kas=FDt insan, g=FCne=FEten kas=FDt ise,Allah't=FDr. G=FCne=FE bize =FD=FE=FDk ve =FDs=FDs=FD ile =E7ok yak=FDnd=FDr,biz ise g= =FCne=FEe =E7ok uza=F0=FDz.Ama ayna vas=FDtas=FDyla,bir nebze g=FCne=FEin =F6zellikle= rini anlayabiliriz. Veya uzay meki=F0i ile g=FCne=FEin hakiki nuruna ve =FDs=FDs=FDna yakla=FEabiliriz onu yak=FDndan inceleyebiliriz ki,bunu mirac hadisesinde Hz.Muhammed bizzat refref'e binerek =E7ok k=FDsa bir zaman zarf=FDnda yapm=FD=FEt=FDr. Cenneti,cehennemi ve kainat=FDn yarat=FDc=FDs=FDn=FD g=F6rm=FC=FE,gidipte g=F6renmi var veya gidipte d=F6ne= nmi var sorusunuda cevaps=FDz b=FDrakmam=FD=FEt=FDr. Mesela, koca bir k=FCtlesi olan d=FCnyam=FDz=FD,vas=FDtas=FDz ve =E7ok s=FCratli bir=FEekilde g=F6t=FCren ve d=F6nd=FCren, bir insan=FD elbette ve evleviyetle daha h=FDzl=FD ve k=FDsa bir s=FCrede g=F6t=FCrmeye ve geri getirmeye muktedirdir ve aynen =F6ylede olmu=FEtur. =DDnsanl=FD=F0a faydal=FD bilgileri, tan=FDd=FDk,tan=FDmad=FDk,ba=FEkalar= =FD ile de payla=FE=FDn=FDz,yay=FDn=FDz. Ben bu bilgileri bilmiyordum,bana kimse =F6=F0retmedi diyen ki=FEinin hesab=FD; bilenden, bildi=F0i halde susandan ve hakikat=FD ve do=F0ruyu yaymayandan sorulacakt=FDr. Mal=FDn zekat=FD oldu=F0u gibi,ilminde zekat=FD ve kuvvetinde bir zekat=FD vard=FDr.Bilen ile bilmeyen bir de=F0ildir.=DDlim m=FCmin"in yiti=F0idir, nerede olursa al=FDr.=DDlim =C7in"dede olsa al=FDn=FDz.Hayatta,en hakiki mur=FEit ilimdir. Faydal=FD t=FCm ilimlerden istifade ediniz,ettiriniz. Be=FEikten mezara kadar ilim =F6=F0reniniz. Okuyunuz,okutunuz.Ne demi=FE yunus emre,'=DDlim ilim bilmektir, ilim kendin bilmektir,sen kendini bilmez isen ilim nice okumakt=FDr.' Ruh nedir; Ruh insan=FDn asl=FDd=FDr,kendisidir.Mahiyeti,bir =FEekli sureti ve =FEuuru olan bir kanundur, yer=E7ekimi kanunu gibi,ama yer=E7ekimi kanununun bir =FEekli, sureti ve =FEuuru yoktur.Fakat d=FCnyadaki i=FEleri yapabilmesi i=E7in, ruh"un elbisesi,bine=F0i mahiyetinde olan bedene ihtiyac=FD vard=FDr.Ruh katiyen bakidir,yani =F6l=FCms=FCzd=FCr. Ey insanlar, baki bir aleme gideceksiniz,o halde haz=FDrl=FDkl=FD olun.=D6l=FCm,ruhun bedenden =E7=FDkmas=FD daha =F6nce vefat etmi=FE olan sevgili anne ve baban=FDz=FDn = ve dostlar=FDn=FDz=FDn yan=FDna gitmektir. Mesela ;bir =FE=F6f=F6r nas=FDl arac=FDndan inince araba hi=E7bir i=FEe yaramaz ise,ruh"ta beden arac=FDndan inince, beden hi=E7bir i=FEe yaramaz.Kabre konan bedendir.Siz ise ruhsunuz.Ruh berzah alemine gitmektedir. =F6l=FCm yokluk ve hiclik de=F0ildir.Kim yok olmak isterki,Ezeli ve ebedi bir Allah"=FDn sevgili mahlukat=FDda ebedi olmal=FDd=FDr.Fakat mahlukat=FDn ebedili=F0i bizatihi de=F0il, Allah"=FDn dilemesiyledir. Ey insanlar ve cinler ezeli ve ebedi cennete girmek,ebedi ya=FEamak,her istedi=F0ini yapmak ve Allah'=FD g=F6rmek istemezmisiniz. Ey sevgili ruh,bunun i=E7in Allah'a =FE=FCkretmeli ve iman etmeli de=F0ilmisin. HULASA : Allah,birdir, hi=E7bir=FEeye ihtiyac=FD yoktur,ne birba=FEkas=FD O'nu yaratm=FD=FEt=FDr nede O'nun bir =E7ocu=F0u vard=FDr.O'nun e=FEi ve benzeri yoktur. Tag: How to Determine if a Record is Locked Tag: 130571
  - 22
    - How to insert a DataTable into a DataSet I have a standalnoe DataTable DataTable1, and a DataSet DataSet1. How can I insert DataTable1 into DataSet1? Tag: How to Determine if a Record is Locked Tag: 130569
  - 23
    - The Simplest Question of all Greetings, i have a sql text file, and i dont knw how to execute it in VS.net 2005 sql express! can anyone help!? thanks, Sharing makes All the Difference -- Sent via .NET Newsgroups http://www.dotnetnewsgroups.com Tag: How to Determine if a Record is Locked Tag: 130563
  - 24
    - Showing/Hiding Some Elements in JS Hi. I want to write a function that will show or hide a few elements on the client-side. The elements that I'm working with are, for example, an <asp:Label />. Let's say I have: <asp:Label id="SomeLB" runat="server" Text="Hi there" /> For the C# to generate my JavaScript, I know that I have to use the ClientID, and the one line I was using looked like: SomeLB.ClientID + ".visible=false;"; Got a JavaScript error so I tried... SomeLB.ClientID + ".style=\"visibility:hidden;\";"; What's the right way to do this? Alex Tag: How to Determine if a Record is Locked Tag: 130562
  - 25
    - How to generate automatic win-forms for SQL Server's tables? I need to build many data enter forms for SQL Server's tables. Is there any best methods to generate data forms from database table structure? Tag: How to Determine if a Record is Locked Tag: 130558

All,

I have set a transaction lock on an Sql Server 2005 database as below:
transaction = connection.BeginTransaction(IsolationLevel.RepeatableRead);

I keep the connection and transaction open while processing data (done
deliberately).

When I launch another application I can read the record that is locked but
cannot update the record (which is desired).

However the only way I know it is locked is by throwing an exception on the
write to the record (also had to wait for the timeout to occur).

Is there a way using ADO.NET to query if that record is locked?

Thanks in advance.

Top