Binding Checkboxes to MySQL

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
    - Oracle Read/Write I am having an issue where I have a Data reader which contains the records to process and I loop thru this data reader until all rows are processed. Within that loop, I have a call to an Oracle stored procedure which, among other things, deletes the row which is being used by the data reader. I have ensured that the update process is performing a commit after the update. When all of the data reader records are processed, the process loops back and re-executes the data reader, as additional records could have been created in my update process (within the loop described above). Every time I re-execute the code to re-populate the Datareader, I have exactly the same number of records in that data reader as when I first started. It is acting as if the commite was not functioning (but I know that this is not the case). Why do the same records show up again in the datareader if they were deleted within the looping process which processes that datareader? Rather then looping through the records one by one, I changed the stored procedure to do the looping stated above and call it in my program and it works just fine. I was wanting to do it transaction by transaction, if I could, but that process does not seem to see the updates which are made. Any ideas? Thanks in advance for your assistance!!!! Tag: Binding Checkboxes to MySQL Tag: 127113
  - 2
    - Return a parameter count from a SQL Stored Procedure I would like to use ADO.Net to connect to a Stored Procedure in SQL Server and return a count of parameters from it. I was able to do this using ADO and VB 6 using the following code: ' m_objConn is a database connection Set m_objCmd2.ActiveConnection = m_objConn m_objCmd2.CommandText = "TestSP" m_objCmd2.CommandType = adCmdStoredProc 'Assign to var m_iSPCount = m_objCmd2.Parameters.Count When I try it with VB.Net, my count is always 0 m_objConn.Open() Dim objCMD As SqlCommand = New SqlCommand() objCMD.Connection = m_objConn objCMD.CommandText = "TestSP" objCMD.CommandType = CommandType.StoredProcedure 'Assign to var Dim icount As Integer = objCMD.Parameters.Count Does anyone know how to retrieve a count of parameters from a Stored Procedure? Tag: Binding Checkboxes to MySQL Tag: 127112
  - 3
    - ContextSwitchDeadlock was detected I am getting a Message Box displayed in which the error message is: "The CLR has been unable to transition from COM context 0x1b0538 to COM context 0x1b06a8 for 60 seconds. The thread that owns the destination context/apartment is most likely either doing a non pumping wait or processing a very long running operation without pumping Windows messages. This situation generally has a negative performance impact and may even lead to the application becoming non responsive or memory usage accumulating continually over time. To avoid this problem, all single threaded apartment (STA) threads should use pumping wait primitives (such as CoWaitForMultipleHandles) and routinely pump messages during long running operations." This is happening mostly when I go into debug mode and I am stepping thru the code, but it also happens when I have a long running query or a process which itterates through the file and takes long then 60 seconds to complete. How can I get this error/dialog box to go away? The dialog box indicates that the message is being generated via "MDA" (Managed Debugging Assistant) and if I click on the link, it provides information as to disable, but I don't think I want to disable. I would seem that I should have parameter which I can set to allow the dialog box to not be triggered after XXX seconds. I do not see any parameter for doing that... Tag: Binding Checkboxes to MySQL Tag: 127111
  - 4
    - Will sql express 2005 and Studio 2003 work together? Will sql express 2005 and Studio 2003 (.net 1.1) work together? I can not find a definitive statement on the Microsoft site and need to change a 1.1 app and wish to use the newer 2005 express. I know that I will need to load both the 1.1 and 2.x framework on the system, but this is not a big issue at this point. Thanks Tag: Binding Checkboxes to MySQL Tag: 127110
  - 5
    - <<< Connection Problem with SQL Server + C#.Net on Local Area Network >>> hi all, i m new on Sql and i have a project related to C# and Sql. i have to do a project which must work on LAN, and there must be only one database file on main computer(Server Computer) and other computers(client computers) must connect database on main computer. i m preparing my project on my personal computer(it is called MYCOMP) and doing connection with wizard. then it doesnt work on other computers(works only my personal computer). when i done connection with wizard .Net create a connection code like below.... // sqlConnection1 // this.sqlConnection1.ConnectionString = "workstation id=MYCOMP;packet size=4096;integrated security=SSPI;data source=MYCOM" + "P;persist security info=False;initial catalog=migros"; i think, because of taking my computer's name in connection string it doesnt work on other computers... what can i do for this problem :(((((((( please write me a solution as soon as possible...( i have only 15 days to hand over and still couldnt start to write my codes, otherwise i cant graduate....) PLEASE HEEEEEEEEEEEEEEEELP !!!!!!! thnks for now...... Tag: Binding Checkboxes to MySQL Tag: 127108
  - 6
    - Number Formats I want to display numbers with a comma between every 3 digits, with no decimal places. I've tried Const conFORMAT As String = "###,###,###" Me.CashTextBox.Text = Format(drEconomy("Cash"), conFORMAT) Which displays fine in general. For example: 999,817 will come out fine However, if the value is zero, then the text box will be empty. Is there a different format I can use to get 0 to displayed correclty? Thanks Vayse Tag: Binding Checkboxes to MySQL Tag: 127106
  - 7
    - DataSet.HasChanges question - get a collection of columns changed? Hello, I'm wondering if it's possible in .NET 1.1 to enumerate a list of individual columns that are changed when a datarow has been flagged as changed. After I update the row back to the database, I also need the ability to write logging information regarding which specific fields the user has changed. Thanks in advance for any suggestions. Andre Ranieri Tag: Binding Checkboxes to MySQL Tag: 127104
  - 8
    - DataTable performance Just a question on performance. I'm building an .Net2 web application. At present we've got very few users and the web app flies along. All the data access is performed through a DAL and most of the data is return through DataTables. All code is in C# and all data access without exception is in the following style: <code> private DataTable myDataTable() { using (SqlConnection conn = new SqlConnection(mySQLConnection)) { DataTable dt = new DataTable(); SqlCommand cmd = new SqlCommand(mySp, conn); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = cmd; da.Fill(dt); return dt; } } </code> Is this preferable over using DataSets? Or would I be better off using DataReaders? Tag: Binding Checkboxes to MySQL Tag: 127094
  - 9
    - Insert Statement somtimes works I'm doing an Insert from ODBC dataset into an OLE access table, the Insert for multiple rows doesn't work, but if I do an Insert using the commented out statement below it works just fine. What is wrong with the code to insert from ODBC multiple rows??? Dim oOleDbConnection As OleDb.OleDbConnection Dim objCommand As New OleDb.OleDbCommand Dim sConnString As String = _ "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=C:\Documents and Settings\My Documents\Visual Studio Projects\MAX Data Interface\Lot Table.mdb;" & _ "User ID=Admin;" & _ "Password=" oOleDbConnection = New OleDb.OleDbConnection(sConnString) oOleDbConnection.Open() 'start a loop here and loop thru and update access For i = 0 To DataSet1.Tables(0).Rows.Count - 1 Next Try For Each rowX As DataRow In DataSet1.Lot_Tracking_Hist.Rows 'sSQL = "INSERT INTO [LotTrackingHistory] (PRTNUM_72) Values ('insertdataOK')" ' this worked with button click sSQL = "INSERT INTO [LotTrackingHistory] (PRTNUM_72) Values (" & rowX.Item("PRTNUM_72").ToString & ")" Next With objCommand .Connection = oOleDbConnection .CommandText = sSQL .CommandType = CommandType.Text .ExecuteNonQuery() End With 'Count the number of entries and display them 'icount = (objCommand.ExecuteNonQuery()) ' MessageBox.Show(icount) oOleDbConnection.Close() oOleDbConnection = Nothing Tag: Binding Checkboxes to MySQL Tag: 127093
  - 10
    - How to connect to Sql Express by ip address? Good day! Is anybody know how to connect to remote Sql Express by IP address from C# program (main question is how to build connection string)? I have to use Ip address instead of server name. I make some tests and when I use server name then I can connect, when (in connection string) I replace server name by server's Ip address I catch exception. Tcp/ip is enabled... Thank you! Best regards, Max Tag: Binding Checkboxes to MySQL Tag: 127091
  - 11
    - Article on DataBinding in Windows form using VB.Net Hi All, See this link http//www.vkinfotek.com/databinding.com for Article on DataBinding in Windows form using VB.Net. Regards Bhar Tag: Binding Checkboxes to MySQL Tag: 127090
  - 12
    - Serialize a dataset as xml How can I serialize a dataset as XML and send it back to the browser? I would like to avoid a web method. -- Arne Garvander Certified Geek Tag: Binding Checkboxes to MySQL Tag: 127087
  - 13
    - Hiding child rows in a datagrid Hi, Is there any way of hiding child tables/rows in a windows form datagrid. I'm using Vb.net and Visual Studio 2003. thanks in advance alan Tag: Binding Checkboxes to MySQL Tag: 127084
  - 14
    - Using OleDb with Enterprise Library 1.1 or 2.0 Hi all, i know that the EL can be used with SQL, Oracle or DB2 database and i know a MySql connectot for this great pattern. But i would like to use it even with OleDb provider. Could someone tell me if is there an Helper for OleDb and Enterprise Library ??? Thanks in Advance Stefano Tag: Binding Checkboxes to MySQL Tag: 127077
  - 15
    - Convert Dataset with Tables with Relations to Flat view Hi I have a dataset with 2 tables and Relations What is the best way to flatten the 2 files to a new table or xml or file I can loop thru table1 and get the childrows or I can do an Xpath on the xml but not sure how to get relation from xsd or Is there another alternative??? Currently Table1 2000 10,000 2001 12,000 Table2 2000 mustang 2,000 2000 corvet 4,000 What I want 2000 10,000 mustang 2,000 2000 12,000 corvet 4,000 Thanks <?xml version="1.0" standalone="yes"?> <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"> <xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true"> <xs:complexType> <xs:choice minOccurs="0" maxOccurs="unbounded"> <xs:element name="vfffg"> <xs:complexType> <xs:sequence> <xs:element name="ID" type="xs:string" minOccurs="0" /> <xs:element name="Sum_x0020_of_x0020_CarCost" type="xs:double" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="e1"> <xs:complexType> <xs:sequence> <xs:element name="ID" type="xs:string" minOccurs="0" /> <xs:element name="CarYear" type="xs:string" minOccurs="0" /> <xs:element name="Sum_x0020_of_x0020_CarCost" type="xs:double" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="e2"> <xs:complexType> <xs:sequence> <xs:element name="ID" type="xs:string" minOccurs="0" /> <xs:element name="CarYear" type="xs:string" minOccurs="0" /> <xs:element name="CarModel" type="xs:string" minOccurs="0" /> <xs:element name="Sum_x0020_of_x0020_CarCost" type="xs:double" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> </xs:choice> </xs:complexType> <xs:unique name="Constraint1"> <xs:selector xpath=".//vfffg" /> <xs:field xpath="ID" /> </xs:unique> <xs:unique name="e1_Constraint1" msdata:ConstraintName="Constraint1"> <xs:selector xpath=".//e1" /> <xs:field xpath="ID" /> <xs:field xpath="CarYear" /> </xs:unique> <xs:keyref name="e1" refer="e1_Constraint1"> <xs:selector xpath=".//e2" /> <xs:field xpath="ID" /> <xs:field xpath="CarYear" /> </xs:keyref> <xs:keyref name="e0" refer="Constraint1"> <xs:selector xpath=".//e1" /> <xs:field xpath="ID" /> </xs:keyref> </xs:element> </xs:schema> Tag: Binding Checkboxes to MySQL Tag: 127072
  - 16
    - Sorting a Dataset table Hi, I need to export the contents of a DataTable in a Dataset to a text file in a particual row order. I guess I need to use the DefaultDavaView but I think I am doing something wrong since traversing the rows in the table doesn't show them in the correct order. Thanks Jeronimo Bertran Tag: Binding Checkboxes to MySQL Tag: 127060
  - 17
    - Navigation using ODP.net Dear All, i have establish a connection to Oracle 10g using ODP.net , i could populate data in a listbox/combo box, but i need to display these data in one by one , i mean navigation using |< < > >| these buttons , plshelp me blw is the code i'm using to populate data in combo/list box ----------------------------------------- dbconnection.getConnection() ' connection string written in a module calling her e Dim conn As New OracleConnection(oradb) Dim exp As Exception Try conn.Open() Dim sql As String = "select EMPNO,ENAME,mgr from emp where 1 =1 " Dim cmd As New OracleCommand(sql, conn) cmd.CommandType = CommandType.Text Dim dr As OracleDataReader = cmd.ExecuteReader() While dr.Read() ListBox1.Items.Add(dr.Item(1)) End While conn.Close() conn.Dispose() Catch exp MsgBox(exp.Message.ToString) End Try Tag: Binding Checkboxes to MySQL Tag: 127059
  - 18
    - ASC-DESC Hi, The Asc or Desc functions work well on the sql server, but when I try to use the parameters collection through ASP.NEt . The SQL statements doesn't execute the same way. Ex: I'm trying to sort months say as 1-Jan,2-Feb etc. on ASP page I get is as 1 Apr, 8 Aug etc. The sql stmt ends ass ORDER BY month(date) DESC & works well. Thanks. Tag: Binding Checkboxes to MySQL Tag: 127058
  - 19
    - DBNULL In the UI, there are some optional field but in the DB I want tto store NULL instead of empty string. Do I check for empty string for these values in the business layer when I am going thru each row in the datatable for Data Validation. Thanks Tag: Binding Checkboxes to MySQL Tag: 127057
  - 20
    - eMoovie - a new company - we need sponsors Hello ! We are eMoovie, a young swiss start-up based in Geneva. We developed SICMovie, a novel technology for VOD security. This technology is not a DRM but a DRT (Digital Rights Tatoo). The goal of DRT is not to control the customer's use of the downloaded movie but to give him responsibilities over the use of the file, and thus to unite copyright and private copy right (Fair use) in one system. We need capital from sponsors and private investors in order to continue our development. Please visit our website: http://www.emoovie.com eMoovie Team Tag: Binding Checkboxes to MySQL Tag: 127055
  - 21
    - Help connecting to Access DB from web service I am creating a web service that returns data from an Access 2000 database using VS2005. The Access database is located on a different server than where the web service is running. The Access database is also opened by a different desktop application running on various workstations on the network. While developing / debugging the web service is hosted on my development machine using the 'ASP.NET Development Server' that is included with VS2005. When deployed it is being host with IIS. I am using the following connection string: Provider=Microsoft.Jet.OLEDB.4.0;Data Source="\\slo-science1\data\PBI Chem data\PBIChemDatabase.mdb" If the database has NOT opened by any of the workstations running the desktop application then the web service runs correctly on both my development machine as well as on the IIS server. If the database has been opened by any of the workstations running the desktop application the web service runs correctly ONLY on my development machine and fails on IIS with the following error: System.Data.OleDb.OleDbException: Could not use ''; file already in use. What are the differences between the 'ASP.NET Development Server' and IIS that would effect how a web service opens a remote Access database? Does anyone know how what settings can be changed so that the web service runs correctly on IIS? Thanks in advance, Jeff Richardson Tag: Binding Checkboxes to MySQL Tag: 127054
  - 22
    - ODBC DataSet to Update Ole Access Table I have a dataset that shows data from an ODBC connection and want to insert that data into an access data base. I'm able to create the record lock on the access table, but am unable to get any data inserted from the dataset to the access table. Below is the coding that I have so far. I've struggled with this for about 2 weeks. This is VB.net. Any guidence is truly welcomed. RickN Private Sub btnLoadAccess_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLoadAccess.Click Dim sSQL As String Dim icount As Integer Dim i As Integer Dim ds1 As DataSet1 ' create connection and create the command Dim oOleDbConnection As OleDb.OleDbConnection Dim objCommand As New OleDb.OleDbCommand Dim sConnString As String = _ "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=C:\Documents and Settings\Rick Nicholson\My Documents\Visual Studio Projects\MAX Data Interface\Lot Table.mdb;" & _ "User ID=Admin;" & _ "Password=" oOleDbConnection = New OleDb.OleDbConnection(sConnString) oOleDbConnection.Open() 'start a loop here and loop thru and update access For i = 0 To DataSet1.Tables(0).Rows.Count - 1 Next Try 'working sql from pervasive or access...what ever 'INSERT INTO table_name (column_name1, column_name2,...)VALUES (value1, value2,....) ' try this insert into "LotTrackingHistory"("PRTNUM_72") values ('333333') For Each rowX As DataRow In ds1.Lot_Tracking_Hist().Rows sSQL = "INSERT INTO LotTrackingHistory (PRTNUM_72) Values (" & rowX.Item("PRTNUM_72").ToString & ")" Next With objCommand .Connection = oOleDbConnection .CommandText = sSQL .CommandType = CommandType.Text .ExecuteNonQuery() End With 'Count the number of entries and display them 'icount = (objCommand.ExecuteNonQuery()) ' MessageBox.Show(icount) oOleDbConnection.Close() oOleDbConnection = Nothing Catch End Try End Sub End Class Tag: Binding Checkboxes to MySQL Tag: 127051
  - 23
    - Large Upload to SQL - Async? Is there any possible way to upload a file into an image field in SQL Server asynchronously? Our users upload a lot of large files into a SQL Server, and we have no way of showing them progress. ADO had an "AppendChunk" method, but it doesn't look like .Net has anything similar. This seems like a big oversight to me... Tag: Binding Checkboxes to MySQL Tag: 127049
  - 24
    - How to set in XSD Shema, column not to allows DBNulls? Column has property AllowDbNull to set is it allowed or not to add DbNull. How to set this property in XSD Schema in design time? My object is to make an int field required... Thanks Tag: Binding Checkboxes to MySQL Tag: 127046
  - 25
    - deleted rows I have a strongly typed dataset 'A' with a Customer datatable and data. I create a new instance of the same dataset ('B') and import rows into the 'B' Customer datatable from dataset 'A' Customer datatable. I delete a row in dataset 'B' Customer datatable and now want to mark the row as deleted in dataset 'A' customer datatable. How can I do that? I thought I could loop through the Customer B rows, find rows with row state = deleted, find them in Customer A and delete them. However, this process throws an exception that the deleted row is inaccessible. Any suggestions. Thanks, Rick Tag: Binding Checkboxes to MySQL Tag: 127044
- Next
  - 1
    - Is it possible to add DataRelation on Individual tables? Hello I have two tables that do not belong to DataSet. They are individual. Is it posible to create DataRelation Or ForeignKey in this situation? I tried but on: childTable.ParentRelation.Add(dataRelation) got Null Exception. Thanks Milan Tag: Binding Checkboxes to MySQL Tag: 127041
  - 2
    - Delete using GetChanges I'm using DataSet that fills data from a filestore (filenames, size, a DelMe bool coln, etc). Now I want to delete rows which have DelMe set to true. Since I'm using a DataAdapter here, which would be the best way to delete rows that have DelMe=true; Currently I do this. DataRow[] changes = parentTable.Select(null, null, DataViewRowState.ModifiedCurrent); Then I loop and set each to row.Delete() and finally call AcceptChanges() to remove them from the table. Is there a more efficient way to select and delete. ? thanks Sunit Tag: Binding Checkboxes to MySQL Tag: 127033
  - 3
    - <%><%><%><%>HOW TO BE FUNNY!<%><%><%><%> You too can learn to be funny in just 7 days flat: http://www.ExpertHumor.com/HowToBeFunny.htm *** Free account sponsored by SecureIX.com *** *** Encrypt your Internet usage with a free VPN account from http://www.SecureIX.com *** Tag: Binding Checkboxes to MySQL Tag: 127028
  - 4
    - IndexOutOfRangeException - Index was outside the bounds of the array. We are encountering an extremely odd issue. We process incoming files for customers and output text files to produce printed material. Then an XML file containing the fields of the original file along with all fields necessary to produce the output text files are saved as an XML file. If an individual's printed material is destroyed in the process of fulfillment, we must reproduce the output for them. We do this by reading the XML file back into a dataset and re-outputting the text files. The XML file (and hence the datatable in the dataset) have a LOT of fields/columns (some have over 1000). We discovered that if a column is added to the datatable at the end of the columns collection, AND is later referred to in a SELECT clause to return a row collection, AND then large amounts of columns are removed and then added back into the columns collection, the following error is thrown: System.IndexOutOfRangeException - Index was outside the bounds of the array. We also discovered that if we added the column referred to in the SELECT clause at the BEGINNING of the columns collection (which was not easy) the error did NOT occur. However, this is simply side-stepping the bigger issue. I have sample code that will duplicate this behavior, but that and the XML is too long to post. Is there some way to post this code and XML? This is running on .NET 1.1 framework. Any light that could be shed on this issue would be greatly appreciated. Thank you. Tag: Binding Checkboxes to MySQL Tag: 127026
  - 5
    - OLEDB: UpdateCommand fails Hi, can anyone help me with the following. MS Access 2002 database, Northwind, Customer table. In VB.NET using a datagrid and a dataset to fill the datagrid. I'm trying to insert, update and delete records in the datagrid. Inserts and deletes are working fine, but the updates are failing and I can't find out why. Looks strange to me because I'm using inserts, updates en deletes in the same way. My Code: Sub GridSaveDatagrid() Dim cmdUpdate, cmdInsert, cmdDelete As OleDbCommand Dim MySql_Insert, MySql_Update, MySql_Delete As String Try mDbConn.Open() 'Deletes MySql_Delete = "DELETE FROM Customers WHERE CustomerID = @CustomerID" cmdDelete = New OleDbCommand(MySql_Delete, mDbConn) cmdDelete.CommandType = CommandType.Text With cmdDelete.Parameters .Add("@CustomerID", OleDb.OleDbType.VarChar, 5, "CustomerID") End With mDa1.DeleteCommand = cmdDelete 'Updates MySql_Update = "UPDATE Customers " & _ "SET CompanyName = @CompanyName, ContactName = @ContactName, " & _ " City = @City, PostalCode = @PostalCode " & _ "WHERE CustomerID = @CustomerID" cmdUpdate = New OleDbCommand(MySql_Update, mDbConn) cmdUpdate.CommandType = CommandType.Text With cmdUpdate.Parameters .Add("@CustomerID", OleDb.OleDbType.VarChar, 5, "CustomerID") .Add("@CompanyName", OleDb.OleDbType.VarChar, 40, "CompanyName") .Add("@ContactName", OleDb.OleDbType.VarChar, 30, "ContactName") .Add("@City", OleDb.OleDbType.VarChar, 15, "City") .Add("@PostalCode", OleDb.OleDbType.VarChar, 10, "PostalCode") End With mDa1.UpdateCommand = cmdUpdate 'Inserts MySql_Insert = "INSERT INTO Customers (CustomerID, CompanyName, ContactName, City, PostalCode) " & _ "VALUES (@CustomerID, @CompanyName, @ContactName, @City, @PostalCode)" cmdInsert = New OleDbCommand(MySql_Insert, mDbConn) cmdInsert.CommandType = CommandType.Text With cmdInsert.Parameters .Add("@CustomerID", OleDb.OleDbType.VarWChar, 5, "CustomerID") .Add("@CompanyName", OleDb.OleDbType.VarChar, 40, "CompanyName") .Add("@ContactName", OleDb.OleDbType.VarChar, 30, "ContactName") .Add("@City", OleDb.OleDbType.VarChar, 15, "City") .Add("@PostalCode", OleDb.OleDbType.VarChar, 10, "PostalCode") End With mDa1.InsertCommand = cmdInsert 'Update de Customer table. Dim updTable As DataTable = mDs.Tables("Customer") mDa1.Update(updTable.Select(Nothing, Nothing, DataViewRowState.Deleted)) mDa1.Update(updTable.Select(Nothing, Nothing, DataViewRowState.ModifiedCurrent)) mDa1.Update(updTable.Select(Nothing, Nothing, DataViewRowState.Added)) Catch ex As Exception Console.WriteLine(ex.Message) Stop Finally If Not mDbConn Is Nothing Then mDbConn.Close() End Try End Sub Tag: Binding Checkboxes to MySQL Tag: 127025
  - 6
    - Data components design question Hi all, I'm new to .NET but have quite a long experience as OO developer. I've been reading lots of documentation in order to get started with the SDK. First I started with on-line documentation about ADO.NET and now I am actually using the Microsoft Patterns and Practices document "Designing Data Tier Components and Passing Data Through Tiers" as a guide to develop my Data Access Logic Components. This document, as well as others, states that in a distributed anvironment each DALC should manage the connection towards its own data store. My questions are: 1) So, is it correct that such an approach invalidates the idea of a global connection for the whole application (example: a single Connection class instance that can be passed to each DALC constructor in the application)? Or this is true just for distributed applications? Would it be better to use a distributed oriented approach if I want to build a scalable, reusable solution? 2) Should the DALC know everything about the data store type? I mean, imagine I want to build a helper class for my DALC which would incapsulate methods needed to provide the right type of objects (Sql/OracleCommand, Sql/OracleDataAdapter and so on) to the DALC in order to accomplish a multiple db platforms implementation? Then I should tell the DALC, at a certain point in its lifecycle, (let's assume during its creation/initialization => in its construcytor code) which type of data store should be used (Sql Server, Oracle etc.). In a traditional approach, this would usually be implemented as a property read from the client application registry or something like that, and passed to the the DALC constructor. Now, if the DALC does manage the connection on its own who tells it which data store type should be used? And how? Am I taking it wrong if I think to read this option from a config file placed into the DALC phisical location? Or, again, am I thinking it wrong as in a distributed environment a single DALC "hides" its data store to all the callers and then it can be fixed at complie time? Hope I pointed out my doubts, and thanks in advance for any answers. Cheers, baba. Tag: Binding Checkboxes to MySQL Tag: 127024
  - 7
    - >@>@>@>@>GET MORE CHICKS............LEARN GUITAR............. Chicks dig guitar players. So get more chicks! Learn how to play guitar! http://www.ExpertHumor.com/LearnGuitar.htm *** Free account sponsored by SecureIX.com *** *** Encrypt your Internet usage with a free VPN account from http://www.SecureIX.com *** Tag: Binding Checkboxes to MySQL Tag: 127023
  - 8
    - <><><><><><><>The Net's #1 Joke e-Book!<><><><><><><><> That's Comedy - Over 460 Pages of Little Snickers, Medium-Sized Chuckles, and Great Big Belly Laughs: http://www.ExpertHumor.com/That'sComedy.htm *** Free account sponsored by SecureIX.com *** *** Encrypt your Internet usage with a free VPN account from http://www.SecureIX.com *** Tag: Binding Checkboxes to MySQL Tag: 127022
  - 9
    - AllowDBNull in DataTables I use a data adapter to fill a DataTable (that contains no row or columns) with data from a table in my SQL Server Express database. The columns that the DataAdapter creates in my DataTable all have the correct datatype but each is created so that AllowDBNull = True. However, the table in the SSE Database has columns where NULLs are not allowed. Any idea why this information isn't making it from teh database to the DataTable? Whats more, if I try and change the change the columns in the DataTable myself after the Fill() method is called, setting AllowDBNull = True seems to have no effect. Why would this be? TIA Tag: Binding Checkboxes to MySQL Tag: 127021
  - 10
    - SqlDataReader Function From a VB6 refugee All, I'm trying to create a DataReader Function to call from within my class to open a simple datareader. I have thoroughly read the Data Access Patterns and practices and do not believe in using canned code right off the bat. I want to rebuild the canned code so I understand it, then I may use it or use my own understood version. The error message is in Error Text: Message="Invalid attempt to Read when reader is closed." '===================== This is call to function =================== Dim dr As SqlDataReader = Create_SQL_DataReader("20060213") While dr.Read() !!! Errs here End While '===================== End call to function =================== Shared Function Create_SQL_DataReader(ByVal sDate As String) As SqlDataReader Dim SQLConn As New SqlConnection(sConn) Using SQLConn ' This Builds SQL String into "s" and uses passed in param "sDate" Dim s As String = BuildShiftSQL(sDate) Dim Cmd = New SqlCommand(s, SQLConn) SQLConn.Open() Dim iDr As SqlDataReader = Cmd.ExecuteReader() Return iDr s = String.Empty SQLConn.Close() SQLConn.Dispose() End Using End Function Error Text: System.InvalidOperationException was unhandled Message="Invalid attempt to Read when reader is closed." Source="System.Data" StackTrace: at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) at System.Data.SqlClient.SqlDataReader.Read() at WindowsApplication1.dataReaderDataSetForm.Main() in C:\Data\VBExpress\Parts\Parts\Form1.vb:line 20 at System.AppDomain.nExecuteAssembly(Assembly assembly, String[] args) at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args) at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly() at System.Threading.ThreadHelper.ThreadStart_Context(Object state) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() Tag: Binding Checkboxes to MySQL Tag: 127015
  - 11
    - ODP .net Dear All, i have establish a connection to Oracle 10g using ODP.net , i could populate data in a listbox/combo box, but i need to display these data in one by one , i mean navigation using |< < > >| these buttons , plshelp me blw is the code i'm using to populate data in combo/list box ----------------------------------------- dbconnection.getConnection() ' connection string written in a module calling her e Dim conn As New OracleConnection(oradb) Dim exp As Exception Try conn.Open() Dim sql As String = "select EMPNO,ENAME,mgr from emp where 1 =1 " Dim cmd As New OracleCommand(sql, conn) cmd.CommandType = CommandType.Text Dim dr As OracleDataReader = cmd.ExecuteReader() TextBox1.Text = dr.Read() MsgBox("1") ListBox1.Items.Add(dr.Item(1)) conn.Close() conn.Dispose() Catch exp MsgBox(exp.Message.ToString) End Try ------------------------------------------------ Tag: Binding Checkboxes to MySQL Tag: 127011
  - 12
    - Problem in creating sql database in visual web developer 2005 express Hi, When I go to Add New item->Sql database-> click ADD i get the following error.I also get the same error when i open the security page on web site admininstration tool. "There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store. The following message may help in diagnosing the problem: An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error number is 1802 and the SqlException message is: CREATE DATABASE failed. Some file names listed could not be created. Check related errors. An unexpected error occurred while checking the sector size for file 'U:\VISUAL STUDIO 2005\WEBSITES\APP9\APP_DATA\ASPNETDB_TMP.MDF'. Move the file to a local NTFS volume, where the sector size can be retrieved. Check the SQL Server error log for more information. Creating the ASPNETDB_1e007377194340a4850801591429f1bc database" Please help me-- Thanks Tag: Binding Checkboxes to MySQL Tag: 127009
  - 13
    - ObjectDataSource field binding to DataSet does not work I built a dataset with 11 tables and their relationships using the data set builder. I removed all the table adapters: the intention is to use the Enterprise Library to load the data, and to do the updates. That side of things works fine. The plan is to use ObjectDataSource to bind web controls to the tables in the data set. Unfortunately the data source does not show any of the fields in the table I am returning. The class I am linking to the data source has a bunch of parameter-less methods to return each of the tables in the data set. These are strongly typed, but the signature of my method is GetCompany(), returns DataTable, and I specify it as the Select method. I have verified that the method is called at run-time, but the details view does not appear, even with a manual bound field. How do I bind do a table in a dataset? Tag: Binding Checkboxes to MySQL Tag: 127004
  - 14
    - How to synchronise, grid and dataset update ??? Dear all, I have a strange behaviour when updating a grid. I will try to explain clearly: I have a CustDataSet object fill with customer information like Name, Firstname, Country, adress That Custdataset contains all my customer information. Then I have a web page on which my user can select only customers from a particular country. For that i create a Dataview object from CustDataset. I set the RowFilter to get only the desired country. Then I bind that DataView to my DataGrid. If CustDataset contains information from that country, then they get properly displayed in the grid. At this stage, my user is able to edit records from that dataGrid bind to DataView or Add a new entry. For edition an Edit, Upadate template column has been added and in the EditCommand event I have following code : dgLabData.EditItemIndex = e.Item.ItemIndex dgLabData.DataSource = dataView dgLabData.DataBind() Then my user gets text box field to update data directly from grid. When pressing the Updade link, current records need to be update and store in custDataset. In the grid UpdateCommand I retrive cells value as follow: newData(0) = CType(e.Item.Cells(1).Controls(0), TextBox).Text newData(1) = CType(e.Item.Cells(2).Controls(0), TextBox).Text newData(2) = CType(e.Item.Cells(3).Controls(0), TextBox).Text dgLabData.EditItemIndex() = -1 dgLabData.DataSource = dataview dgLabData.DataBind() After this I did not get display any changes made, or new row added but always the previous initial state. How to synchrosise changes made in the dataGrid, dataview, dataset object in order that it reflect changes when DataBind is called ?? I am lost, thnaks for your help serge Tag: Binding Checkboxes to MySQL Tag: 127003
  - 15
    - <%><%><%><%>HOW TO BE FUNNY!<%><%><%><%> You too can learn to be funny in just 7 days flat: http://www.ExpertHumor.com/HowToBeFunny.htm *** Free account sponsored by SecureIX.com *** *** Encrypt your Internet usage with a free VPN account from http://www.SecureIX.com *** Tag: Binding Checkboxes to MySQL Tag: 126999
  - 16
    - >@>@>@>@>GET MORE CHICKS............LEARN GUITAR............. Chicks dig guitar players. So get more chicks! Learn how to play guitar! http://www.ExpertHumor.com/LearnGuitar.htm *** Free account sponsored by SecureIX.com *** *** Encrypt your Internet usage with a free VPN account from http://www.SecureIX.com *** Tag: Binding Checkboxes to MySQL Tag: 126998
  - 17
    - Amnesty for illegal immigrants will not happen this time..................... Our politicians lead the league in all talk, no action. Is blowing us some sunshine good enough? Read what The Expert thinks: http://www.ExpertHumor.com/ *** Free account sponsored by SecureIX.com *** *** Encrypt your Internet usage with a free VPN account from http://www.SecureIX.com *** Tag: Binding Checkboxes to MySQL Tag: 126997
  - 18
    - Will illegal immigrants get deported?.........Of course not..................... Our politicians just wanted to blow us some sunshine. Get the details from The Expert: http://www.ExpertHumor.com/ *** Free account sponsored by SecureIX.com *** *** Encrypt your Internet usage with a free VPN account from http://www.SecureIX.com *** Tag: Binding Checkboxes to MySQL Tag: 126995
  - 19
    - Illegal Immigration, the Non-Issue of the Week?????????????? The way our politicians rushed to talk about illegal immigration this week, maybe they thought it came with a free lunch. They won't do anything about it, but it will get them some money. The Expert provides the details at: http://www.ExpertHumor.com/ *** Free account sponsored by SecureIX.com *** *** Encrypt your Internet usage with a free VPN account from http://www.SecureIX.com *** Tag: Binding Checkboxes to MySQL Tag: 126994
  - 20
    - can't connect to sql server using ip number My code: Dim IP As String IP = "192.168.0.169" SqlConnection1.ConnectionString = "workstation id=xxxxx;integrated security=SSPI;Data Source=" & IP & ";persist security info=False;initial catalog=adp1SQL" The error occurs when I use the IP address instead "mshome". when IP="MSHOME" the code runs smoothly. while in the development stage, this project is only instaled in the PC where MSDE 2000 is installed. Could this be the problem? Tag: Binding Checkboxes to MySQL Tag: 126991
  - 21
    - changing key field in Data Form Wizard form I created a form using the Data From Wizard. It lets me change and update all the fields except the primary key. When I modify the pk textbox, it throws this exception: "Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints." The row count on the form in incremented by 1 and everything is messed up until I restart the application. Any ideas? Thanks. Tag: Binding Checkboxes to MySQL Tag: 126988
  - 22
    - IndexOutOfRangeException - Index was outside the bounds of the arr We are encountering an extremely odd issue. We process incoming files for customers and output text files to produce printed material. Then an XML file containing the fields of the original file along with all fields necessary to produce the output text files are saved as an XML file. If an individual's printed material is destroyed in the process of fulfillment, we must reproduce the output for them. We do this by reading the XML file back into a dataset and re-outputting the text files. The XML file (and hence the datatable in the dataset) have a LOT of fields/columns (some have over 1000). We discovered that if a column is added to the datatable at the end of the columns collection, AND is later referred to in a SELECT clause to return a row collection, AND then large amounts of columns are removed and then added back into the columns collection, the following error is thrown: System.IndexOutOfRangeException - Index was outside the bounds of the array. We also discovered that if we added the column referred to in the SELECT clause at the BEGINNING of the columns collection (which was not easy) the error did NOT occur. However, this is simply side-stepping the bigger issue. I have sample code that will duplicate this behavior, but that and the XML is too long to post. Is there some way to post this code and XML? This is running on .NET 1.1 framework. Any light that could be shed on this issue would be greatly appreciated. Thank you. Tag: Binding Checkboxes to MySQL Tag: 126986
  - 23
    - Concurrency violation trying to update a table in SQL Server I have an intermittent error where I get the following exception: "Error: Concurrency violation: the UpdateCommand affected 0 records." Here are the steps I follow: Create SQLConnection Set connection string of the connection. Open connection Create SQL Data Adapter with the connection and a simple select statement including an indexed column Create SqlCommandBuilder on this adapter Fill DataTable with the Adapter Loop through each datarow and based on contents of a field, possibly update another field in the same row Call If Not tbl.GetChanges Is Nothing Then adapter.Update(tbl) This last step is where the error occurs. I am the only user of the system so there are no concurrency issues. When I tried to run profiler while executing, the problem went away and I no longer seem to be able to reproduce this problem on that machine. Any help would be appreciated. Thanks in advance, Boris Zakharin Tag: Binding Checkboxes to MySQL Tag: 126985
  - 24
    - How to loop through rows of strongly typed dataset table In vb.net 1.1 I could do this: Dim ds As dsEquip = GetDataset() Dim dr As dsEquip.tbEquipRow For Each dr In ds.tbEquip.Rows 'Do something Next now in c# 2.0 I'm trying to do the same thing like this: dsEquip ds = oData.PersonGetRecShort(); foreach (dsEquip.tbEquipRow dr in (dsEquip.tbEquipRow)ds.tbEquip.Rows) { } I get a compile error saying: Error 1 Cannot convert type 'System.Data.DataRowCollection' to 'ClientDataLayer.dsEquip.tbEquipRow' F:\Data\Sample Projects\WWF\myFormState\BusinessLayer\Persons_BLL.cs 53 63 BusinessLayer Using c# 2.0, what's the correct way to loop through all the rows in ds.tbEquip.Rows? Thanks. Tag: Binding Checkboxes to MySQL Tag: 126983
  - 25
    - XML string to SqlDataReader for SQL Server 2005 CLR Stored Procedure I need some help getting an xml string into a SqlDataReader and I am stuck. (I admit I'm no guru at this stuff.) I can easily get it into a DataSet object, but the SqlContext.Pipe.Send() method needs a SqlDataReader object as a parameter. (I don't want to send it as an XML string.) Here is my method so far...any clues and code samples would be greatly appreciated...I'm a visual learner. =) [Microsoft.SqlServer.Server.SqlProcedure] public static void GetAPList2() { // allow https access System.Net.ServicePointManager.CertificatePolicy = new AirWave.TrustAllCertificatePolicy(); string webURL = "https://webservice.somesite.com/ap_list.xml?id=47"; CredentialCache sec = new CredentialCache(); sec.Add(new Uri(webURL), "Basic", new NetworkCredential("*****", "*****")); WebClient client = new WebClient(); client.Credentials = sec; string pageHTML = Encoding.UTF8.GetString(client.DownloadData(webURL)); Byte[] pageData = client.DownloadData(webURL); string pageHtml = Encoding.ASCII.GetString(pageData); DataSet xmlDS = new DataSet(); XmlTextReader rdr = new XmlTextReader(pageHTML, XmlNodeType.Document, null); xmlDS.ReadXml(rdr); SqlDataReader dr = /* STUCK HERE!???? */ SqlContext.Pipe.Send(dr); } Tag: Binding Checkboxes to MySQL Tag: 126982

Ref: WinXP, MySQL 5.0, C#

How to bind a CheckBox to a Boolean column (TINYINT(1)), or to any type
of MySQL column for that matter?

Thanks,
Jim

Top

Re: Binding Checkboxes to MySQL by Cor

Cor
Tue Apr 04 01:47:42 CDT 2006

Jwitt,

I do not know if the TinyInt(1) is the same as the Bool column in SQLServer.

If that is the case than you have to bind the Value property from the
checkbox while most start with doing it to the Text property.

I hope this helps,

Cor

"jwitt" <baytecheng@yahoo.com> schreef in bericht
news:OZZeK24VGHA.4424@TK2MSFTNGP15.phx.gbl...
> Ref: WinXP, MySQL 5.0, C#
>
> How to bind a CheckBox to a Boolean column (TINYINT(1)), or to any type of
> MySQL column for that matter?
>
> Thanks,
> Jim

Top