changing the connection for a strongly typed dataset

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 and .NET Hello, I have an SP, which is calling from .NET code using ODP. In that SP i have few update table statement followed by Insert statement and then delete statement. When I am executing its not updating the table. means the code flows are: Update <statement> Update <statement> Update <statement> Insert <statement> Commit Delete <statement> Commit In this scenario, update statements are not working. do i need to put commit after every update statement. Cheers, Prasanta Tag: changing the connection for a strongly typed dataset Tag: 145165
  - 2
    - Oracle and .NET Hello, I have an SP, which is calling from .NET code using ODP. In that SP i have few update table statement followed by Insert statement and then delete statement. When I am executing its not updating the table. means the code flows are: Update <statement> Update <statement> Update <statement> Insert <statement> Commit Delete <statement> Commit In this scenario, update statements are not working. do i need to put commit after every update statement. Cheers, Prasanta Tag: changing the connection for a strongly typed dataset Tag: 145164
  - 3
    - Problem with oracle transaction Hello, I have an SP, which is calling from .NET code using ODP. In that SP i have few update table statement followed by Insert statement and then delete statement. When I am executing its not updating the table. means the code flows are: Update <statement> Update <statement> Update <statement> Insert <statement> Commit Delete <statement> Commit In this scenario, update statements are not working. do i need to put commit after every update statement. Cheers, Prasanta Tag: changing the connection for a strongly typed dataset Tag: 145163
  - 4
    - SqlParameter with size=0 I used the SqlDataAdapter Configuration Wizard to generate a new SqlDataAdapter. I used Sql statements and typed a simple "select * from table1" for the sql. In the generated code all the SqlParameters had size=0. WHY? I have done this in the past, very recently in fact, with no problem. I tried this on 2 different PCs and using different tables on different database servers. Same result. Tag: changing the connection for a strongly typed dataset Tag: 145162
  - 5
    - TransactionScope and Concurrency? With the typical example of implementing calls that leverage TransactionScope (via a using code block) - would this be "safe" for asp.net web apps? I am finding some conflicting opinions on the net about this issue. Because transaction enlisting is inherent by all calls in the code that executes (within the using block), would User A's rollback cause User B's to rollback too if they both hit at the same time? Tag: changing the connection for a strongly typed dataset Tag: 145160
  - 6
    - If I have a gridview with edit buttons, how do I show dropdowns in I have a gridview that allows the user to edit rows by clicking on an EDIT button for each row. I notice that in EDIT mode I get checkboxes for some fields, and textboxes for others. But I would like to have a dropdownlist in some cases. I would have to prefill that dropdown list with allowed values. How do I do that? Thanks, Marvin Tag: changing the connection for a strongly typed dataset Tag: 145159
  - 7
    - Transaction Isolation Level Hello, Is the following code handled different in .NET 1.1 and .NET 2.0? public SqlTransaction BeginTransaction() { return this.BeginTransaction(IsolationLevel.Unspecified, null); } It seems that running this code and starting a transaction under 2.0 we run into locking issues if more than one transaction should be opened at the same time, while running on 1.1 there are no problems. Does it make a different to use IsolationLevel.Unspecified there? Any hint would be great. Thanks! Best Regards, Andreas Pfanner Tag: changing the connection for a strongly typed dataset Tag: 145153
  - 8
    - Binding RadioButtonList to a SQL bit column through SQLDataSource Hi. This seems like it should be easy but its driving me nuts... I have a radio button list like so... <asp:RadioButtonList ID="controlName" runat="server"> <asp:ListItem Value="'True'" Text="Y" /> <asp:ListItem Value="'False'" Text="N" /> </asp:RadioButtonList> I have a SQLDataSource setup to insert this field into a microsoft sql table. The data source line for this field is... <asp:ControlParameter ControlID="controlName" Name="PARAM_NAME" PropertyName="SelectedValue" Type="Boolean" /> And my param in the sql stored proc is... @PARAM_NAME BIT The insert keeps failing however. It is passing in "True" or "False" to the bit param which I believe is the problem. I tried passing in "T"/"F", "1"/"0", etc.... but can't get anything to work. I believe what I need to pass in is a 1 or 0 (ints, not strings), however the way I understand it is the ListItem Value can only be a string. Is there a way to do this? Thanks! Tag: changing the connection for a strongly typed dataset Tag: 145137
  - 9
    - Typecasting without knowing the cast Hi I have a data row variable which could be for any of a number of tables in my apps. How can I type cast the variable to correct type at runtime? I know I can get the type description using MyRow.ToString but don't know how to use this to typecast MyRow variable. I need this to write a generic SUB that can deal with rows of any table type. Thanks Regards Tag: changing the connection for a strongly typed dataset Tag: 145135
  - 10
    - Provider Speakeasy Business DSL: 3 for Free DSL for your business - Order now and get free hardware, free installation, and a free month of service. Speakeasy also provides US- based, 24/7 support. Sign up today. http://www.ogogo123sina.cn/Dsl-Providers.htm Tag: changing the connection for a strongly typed dataset Tag: 145132
  - 11
    - .NET Library for ORACLE backup & restore function Hi, i'm searching for a .NET library for backup & restore a ORACLE database simluar to 'Microsoft.SqlServer.Management.Smo'. Is that possible, i didn't found anything about this problem. Many thanks for any help Marco Tag: changing the connection for a strongly typed dataset Tag: 145130
  - 12
    - Handling data update errors with multiple tables Hi Its easy to trap errors such as concurrency error when a single table is involved with code similar to this; Try Me.MytblAdpater.Update(DS.Mytbl) Catch dbcx As Data.DBConcurrencyException HandleConcurrencyException(dbcx.Row) End Try How does one handle concurrency exception with an AdpaterManager where multiple tables are involved in statement like; Me.TblAdapterManager.UpdateAll(DS) In particular how does one know which table or tables and row/rows are in error? Thanks Regards Tag: changing the connection for a strongly typed dataset Tag: 145128
  - 13
    - How do you make a dataset when you cannot use a database for it? I have a challenge on my job: to make a gridview that depends on a dataset that is not from a database. The reason for this is that there are two gridviews plus some other data that have to be saved to a database all at once. To simplify a little, at the top of the form, the user enters two numbers which describe how many rows each grid has to have. (He also enters some other data). I guess he would click on a submit button once he has those numbers. Then he has to enter all the data in the all the rows for the 2 grids. The grid rows should have EDIT and DELETE buttons. At the end of all this, he enters a password and clicks on a submit button. Only after he does all this can I save the grid information (and the 2 numbers and the other data) to databases. So it seems to me that I can't have each grid with a datasource of a database, because it would be showing what it retrieves with its SELECT statement, which at the start of the data-entry would be no rows at all. The original setup I had was that the user would fill out a row of textboxes and checkboxes, and then he would hit a submit button, and the data would be added to a database, and the grid would reflect the new row added. I repeated this method for the 2nd grid. But I was told that I should have an all-or-nothing operation - either all the grids and other data are submitted (with a password), or nothing is. Is there a way to do this? Thanks, Marvin Tag: changing the connection for a strongly typed dataset Tag: 145127
  - 14
    - Problem remoting to SQL Server from a Vista Machine I have a C# .net app that connects remotely to a SQL Server 2005 database on a Windows 2003 server machine sitting in Chicago. It connects through a VPN. Everything works fine when I run the app from a machine running XP Pro SP 2. When I try to run the same app, no modifications, from a Vista Business machine and from a Vista Ultimate machine, (so I am assuming it's a Vista issue) I get the error [DBNETLIB] ConnectionOpen (Connect()).] SQL Server does not exist or assess denied. It is not the SQL Server, because it works from the XP machine. It is not TCP/IP on the Vista machines because I can do everything else, connnect to internet, connect through VPN etc. As it is happening on more than one machine running Vista and not the XP, that is why I am assuming it is a Vista Problem. I can connect to the SQL Server on the Chicago machine by using SQL Server Management Studio Express. That seems to narrow it down to a ado.net issue. I am using the .net 3.5 framework. Any suggestions? BillG Tag: changing the connection for a strongly typed dataset Tag: 145126
  - 15
    - cEldmDrxbyviKDBZ WEILPJ f81tpvn7894323ndrx Tag: changing the connection for a strongly typed dataset Tag: 145125
  - 16
    - cEldmDrxbyviKDBZ WEILPJ f81tpvn7894323ndrx Tag: changing the connection for a strongly typed dataset Tag: 145124
  - 17
    - Connect to BindingSource with DataMember I've tried to set a BindingSource DataSource property to a DataSet with many tables. Now I try to connect two DataGridView to the same BindingSource, but using two different DataMember (one with the name of one table and the other with another). Everything is working, the two DataGridView controls are rendering well. Everyone has its own cursor, I can change the data and all. The problem is that if I want to use the properties and methods of the BindingSource object I can't specify which table I'm referring to... For example, if I write bs.Position++; which cursor table is going to move? No one actually, as I have already tried...But why can't I specify the which table I want to manage from the BindingSource if the BindingSource is actually capable of working with multipled set of data? Am I supposed to use a single BindingSource object for each table of the database? Thank you for your help cold Tag: changing the connection for a strongly typed dataset Tag: 145117
  - 18
    - Can this be made generic? Hi I have below code which updates table tblClients and handles concurrency violation if needed. Is there a way to make the code generic so for example another table's name can be passed to the SUB? Thanks Regards Private Sub UpdateDatabase() Try Me.tblClientsTableAdapter.Update(Me.ContactsDataSet.tblClients) Catch dbcx As Data.DBConcurrencyException HanldeConcurrency(dbcx.Row, ContactsDataSet.tblClientsRow) End Try End Sub Tag: changing the connection for a strongly typed dataset Tag: 145107
  - 19
    - Add WHERE Clause Dialog Box Doesn't Support Object Source? When configuring a data source for the GridView, I can access the Add WHERE Clause dialog box, which allows me to filter the results based on a particular column's relationship to any of a number of different data sources (cookies, control, form, etc.). However, what I'd really like to do is tie it to a static property of one of my application's classes. Does anyone know why this option does not appear to be supported, or if there's any workaround? Thanks. -- Jonathan Wood SoftCircuits Programming http://www.softcircuits.com Tag: changing the connection for a strongly typed dataset Tag: 145106
  - 20
    - null value in xml translates to empty string in dataset after ReadXML I am importing data in a XML document into a SQL Server database. Null data in the XML document is represented like this: <elementname /> But when I load the XML document into a dataset, it becomes an empty string, which generates an error when I insert the data into the database for datetime fields. I load the data into a XMLTextReader, read it into a dataset, and send it to the database: XMLTextReader xr = new XMLTextReader (filename.xml); DataSet ds = new DataSet(); ds.ReadXML(xr); SQLDataAdapter da = new SQLDataAdapter(); //configure InsertCommand... da.Update(ds); When I look at the data in the dataset, null values in elements become empty strings "". I get: "Failed to convert parameter value from a String to a DateTime." Tag: changing the connection for a strongly typed dataset Tag: 145100
  - 21
    - Tableadapter record count Hi I am using the below statement; Me.MyTableAdapter.Fill(Me.MyDataSet.tblMyTable) How can I now check the record count of the data table and specifically if the record count returned by fill is not 0? Thanks Regards Tag: changing the connection for a strongly typed dataset Tag: 145094
  - 22
    - Sample app Hi I am coming from a vba/access/vb database development background. I however find db development in .net daunting and have so far not been able to find a good example to learn how to do winform database apps in .net well. I am looking for example of a 1-many database app that is written well enough but purely in terms of being able to work in a multi-use environment of a relatively small number of users. If the example can avoid bells and whistles like WCF for the time being to for simplicity sake then great. I wonder if you have such an example in mind somewhere and can provide a link for that? I am on VS2008. Many Thanks Regards Yahya Usman Tag: changing the connection for a strongly typed dataset Tag: 145092
  - 23
    - Excel and OleDbDataAdapter. How can i ignore blank columns Hi, I have an application, that needs to import excel spreadsheets into a SQL Server database. I am using an OleDBDataAdapter to load (fill) the data into a Dataset. This works fine, when the spreadsheet is formatted correctly. Occasionally, person sending us the file, will put the data starting in column B, not column A. This fails our checks on column count. They also have started in the third row, which messes up the column headings. I Get F1 -F6 for the column headers and only three of the six actual column heading are read in (as data). The other three column headings are read in as blanks. Also occasionally, an extra blank column after the data gets read in. Well it looks blank in the spreasheet, but I'm assuming they have done something to it. Is there an easy way for me to get the DataAdapter to ignore blank columns and rows? At the moment, I'm (in my opinion) quite rightly rejecting the file, but I would like my application to be more fault tolerant and intellegent. Rollasoc Tag: changing the connection for a strongly typed dataset Tag: 145091
  - 24
    - BindingSources, BindingNavigators and direct navigation... Hi there: I dragged several fields from a Data Source to a form in the designer. It created several TextBoxes and a BindingNavigator bound to a BindingSource which DataSource is the DataTable containing those fields. Now I'm able to navigate through the table to next, previous, last, ... Here's the problem: I want the TextBoxes show a specific row in the DataTable, say a row with the Name field = "J Lo" (in a DataTable "People"), without having the user navigating through several rows up until he finds this one. How do I position the BindingSource to that specific row, if I don't know it's relative position in the DataTable bound to the BindingSource?. The DataTable doesn't have a CurrencyManager as the BindingSource does, and the BindingSource doesn't have a Find method to locate specific rows. Please help... -- Rafael Soteldo Tag: changing the connection for a strongly typed dataset Tag: 145089
  - 25
    - TransactionScope and DataTables Here is the situation: A DataTable has contains rows with all rowstates in it. A Table Adaptor.Update is performed that is wrapped in a TransactionScope. An error occurs and the complete is not called. All is well on the Server, all rows are backed out. My DataTable is not so well. Some look like they have been updated and have a rowstate of unchanged. The rest of the rows starting with the first row that had an error have the rowstate they had from before the update. Does anyone have an idea of how to handle the data in the datatable after the rollback of the transaction? Tag: changing the connection for a strongly typed dataset Tag: 145088
- Next
  - 1
    - Inserting into csv files using Jet and System.Data.OleDb I'm trying to insert data into a csv file using System.Data.OleDb but I'm unable to insert rows with character fields bigger that 255 characters. the code: const String INSERT_STATEMENT = "insert into [table#csv] (SmallStr, BigStr) values (@SmallStr, @BigStr)"; OleDbConnection oConn = new OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source=c:\\db\ \;Extended Properties=\"text;HDR=YES;\""); oConn.Open(); OleDbCommand oCmd = new OleDbCommand(INSERT_STATEMENT, oConn); OleDbParameter oParam = null; oParam = new OleDbParameter("SmallStr", OleDbType.VarChar, 255); oParam.Value = "0123456789"; oCmd.Parameters.Add(oParam); oParam = new OleDbParameter("BigStr", OleDbType.LongVarChar, 1024); oParam.Value = "012345678901234567890123456789012345678901234567890123456789012345"+ "678901234567890123456789012345678901234567890123456789012345678901234567890123"+ "456789012345678901234567890123456789012345678901234567890123456789012345678901"+ "23456789012345678901234567890123456789"; //260 characters oCmd.Parameters.Add(oParam); oCmd.ExecuteNonQuery(); The above does work if i change the BigStr param to 255 chars or less. I've tried playing around with putting status.ini files into the folder in various configurations but nothing seems to help. I'm hoping though that it is possible to get more than 255 characters into a text file using OleDb and Jet. If anyone could help me with this I would be very greatful, spent ages trying to get it right. Thanks in advance :-) Tag: changing the connection for a strongly typed dataset Tag: 145084
  - 2
    - Limit rows in a DataView to those used in a relation with RowFilter? I have a simple DataSet with two tables, ParentTbl and ChildTbl. They each have a ChildId column. They are joined by a relation ParentTbl_ChildId which associates the ChildId column with ParentTbl as the parent and ChildTbl as the child. This DataSet is not based on a database (it is saved to and loaded from XML files) so SQL queries are not an option. I need a DataView on ChildTbl which is limited to those rows involved in a ParentTbl_ChildId relation. I have been trying to achieve this with the RowFilter property, but have been struggling to define the appropriate expression. Some of the variations I have attempted are: m_filteredView->RowFilter = L"NOT(NULL = (Parent(ParentTbl_ChildId1).ChildId1))"; //The view just ends up being empty m_filteredView->RowFilter = L"Count(Parent(ParentTbl_ChildId1).ChildId) > 0"; // Throws SyntaxErrorException with "Syntax error in aggregate argument: Expecting a single column argument with possible 'Child' qualifier." m_filteredView->RowFilter = L"ChildId IN(Parent(ParentTbl_ChildId1).ChildId1)"; //Throws EvaluateException with "Only constant expressions are allowed in the expression list for the IN operator." Is this even possible? Can anyone suggest an expression that might work? Tag: changing the connection for a strongly typed dataset Tag: 145083
  - 3
    - DataGridView Hi All, I have been searching everywhere but I am totally stumped. Can anyone PLEASE help. I am using VB.Net 2005 edition and have a DataGridView (DGV)on my form. The DGV is NOT bound to anything as I want the user to input their values. Once they have finished I THEN want to save the values in the DGV to a MS Access table. How do I do this? My DataGridView is called DGV1 and my table is db1.mdb. I would KILL for any example code you may be able to pass my way. THANK YOU Tag: changing the connection for a strongly typed dataset Tag: 145081
  - 4
    - Underscore ("_") prefix added to my Column Name I manually created a DataTable in a Typed DataSet using the DataSet designer in VS 2008 Pro. One of the Column names is "IN". When referencing this table in VB.Net 2008, the IntelliSense did not show the column "IN" but it did show a column "_IN'. If I tried to reference this column in code using "tablenameRow.IN" I got the build error: "'IN' is not a member of 'app.DataSet.tableRow". If I reference it with "tablenameRow._IN" then I don't get the build error. I have several other 2-letter-capitalized column names in this table such as: "'LT', 'PI' and 'MA'". These other column names show up in intellisense and can be referenced without the "_" prefix. Can someone tell me what's going on? Thanks -- Robert Scarborough Integrated Visual Systems Tag: changing the connection for a strongly typed dataset Tag: 145076
  - 5
    - Trapping nulls for SequetialAccess I have a group of records in a set - usually 5-10 rows. For example ProviderPanel would have several elements. I do this so I can handle the formatting of each value on a case by case basis. A typical scenario would be that before writing any records to either labels or a class, I should try to 'trap' any possible nulls before trying to set them to a variable. This only works with SequentialAccess in a DataReader So, cn.Open() dr = cmd.ExecuteReader(CommandBehavior.SequentialAccess) Do While dr.Read Select Case strGroupLevel Case "PCP" strMeasure = iif( dr("MeasureID") is DBNull.Value, "", (dr("MeasureID") lPerform = iif(isnumeric(dr("Perform"), dr("Perform"),0) Case "......." End Select But if I do this --- I get the ordinal error - "Tryinng to read from ordinal 1 ...etc. I suppose this is because I am doing a 'double-take' on the column with my IIF statment? And it can't read it because it's on to the next column already? Anyhow, how can I go about trapping nulls if I use SequentialAccess in a Reader. Tag: changing the connection for a strongly typed dataset Tag: 145073
  - 6
    - ado.net entity framework newby question Hi, I have downloaded and installed beta 3 of Ado.net entity framework and played with this a little bit and it's quite cool - I can query the database and get the objects etc. The only thing I can't dig to is how to actually create custom attributes in the classes that the framework has generated for me. For example, say, I have a simple table: UserId, UserName, UserAge and I want a custom properry, say, IsOld that will be calculated at runtime, something like public bool IsOld{ get{ if (UserAge > 90){return true;} else {return false;} } } how do I do this? Thanks for all your comments! Tag: changing the connection for a strongly typed dataset Tag: 145072
  - 7
    - Direct navigation to specific rows in a DataSource... Hi there: I need to get the position of a given Row to navigate directly to it, in a form that has a BindingNavigator and several TextBoxes showing each rows details... I dragged the fields from the Data Sources window to the form in the designer, which created the BindingNavigator attached to a BindingSource. As far as I know, the BindingSource lets you move to the first, next, to a position, previous and last row of a DataTable, so, what if I need to navigate directly to a row that has a specific value in a field (for instance, "Carl" in the field "Name" in the DataTable "People"). I suppose I should get the row position within the DataTable attached to the BindingSource, and then set the BindingSource.Position to that position. But how ca I do that?, the DataTable doesn't expose a property that shows the relative position of each row in the table. Moreover, what if the DataSource is a DataView with filters set, how do I get the position of that given row within this DataView? Please, need help... Thanks in advance..., Rafael Soteldo Tag: changing the connection for a strongly typed dataset Tag: 145068
  - 8
    - LINQ with Datetime Hi, How can I use a date string to test a date in a LINQ query. Below is a query in Northwind Many thanks for any help Ant NorthwindDataContext db = new NorthwindDataContext(); var resultSet = from o in db.Orders where o.OrderDate >= Convert.ToDateTime("20080601") select o; Tag: changing the connection for a strongly typed dataset Tag: 145066
  - 9
    - OleDb delays commits and unlocks? I've seen other posts with similar problems, but no solutions. I have two hair-pulling dilemmas that have been frustrating me for months now. Is there no solution? (C#.NET, Framework 2.0, Jet OleDb 4.0) The general goal is to read one MDB file and copy relevant info into another MDB file (copied from an empty template), replacing the old file with the new file. DataAdapters are used only to read (or re-read) the data from the file into the in-memory DataTable. All data INSERTs and UPDATEs are done with OleDbCommand.ExecuteNonQuery(). Problem 1: To retain the original version of the file, the process requires two rename operations. The first renames the original file. The second renames the new file to have the original file's name. Half the files I process do this OK. The other half fail on one of the renames, claiming that the file is still locked by another process. Checking the directory just prior to the rename attempt confirms that the corresponding LDB file still exists when the rename fails and doesn't exist when it succeeds. I've gone so far as to put all the data copying into a separate Main and invoking it with a Process.Start() so that the locking process has to be terminated before I attempt the rename. No dice. Aaaaargh! Problem 2: In the last-called method of the copy process, one new record is written to each of two empty tables. After that, a message is written to a log file, the method returns, and the OleDbConnection is closed. All of that occurs in about a dozen lines of code. This works almost all the time, except on one of my test files. With that file, the first inserted row appears in the output mdb file, but the second one does not! There is nothing particularly unusual about this file; other test files have identical structures. The tables involved are new tables, not present in the source data file, and every test file requires that these two rows be created. No errors are reported by the INSERTs or any other statement; it just doesn't get committed to the table. Double-Aaaaargh!! Tag: changing the connection for a strongly typed dataset Tag: 145059
  - 10
    - Books recommendations please Hi I need to develop winform database applications and wondering is these two books will get me there; Data Binding with Windows Forms 2.0: Programming Smart Client Data Applications with .Net http://www.amazon.co.uk/Data-Binding-Windows-Forms-2-0/dp/032126892X/ref=wl_it_dp?ie=UTF8&coliid=I2L84GECRS6E6P&colid=399925I1FY0N8 Windows Forms 2.0 Programming http://www.amazon.co.uk/Windows-Forms-Programming-Chris-Sells/dp/0321267966/ref=wl_it_dp?ie=UTF8&coliid=I1RY8RDOG4LBP1&colid=399925I1FY0N8 I already have Bill's 'Hitchhiker's guide to VS and SQL Server'. Any additional recommendations would be appreciated too. Basically anything that will get me off your backs. Thanks Regards Tag: changing the connection for a strongly typed dataset Tag: 145053
  - 11
    - typed dataset Hi all, I need to make a typed dataset cause i import a dataset from foxpro I use this code Dim oDbcommand As New SqlDataAdapter(Sql, Conn_SqlServer) oDbcommand.MissingSchemaAction = MissingSchemaAction.AddWithKey oDbcommand.Fill(Me.DataSet, Me.TableName) My Problem is vs 2005 or Framework 2.0 don"t return the well definition a numeric field (from sql server 2000) the xsl returned for the numeric Field <xs:element name="cli_pricemin" type="xs:decimal" minOccurs="0" /> for the string field <xs:element name="cli_email" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> I would like to have the maxlength and the decimal, for the numeric field , pricemini <xs:maxLength value="10" /> Have you an Idea ? Olivier Tag: changing the connection for a strongly typed dataset Tag: 145047
  - 12
    - Connection works but returns no records Hi, I have been studying the books (2 ADO.NET and 1 VB.NET) and still can't work out why the records in the database aren't being read. >>>> Dim sConString As String = "Data Source=. \SQLEXPRESS;AttachDbFilename=""C:\Active Access Library\FigaroNET \Figaro\Figaro\FigaroData.mdf"";Integrated Security=True;Connect Timeout=30;User Instance=True" Dim conDivisions As New SqlConnection(sConString) conDivisions.Open() MessageBox.Show(conDivisions.State.ToString()) Dim sCompanySelect As String = "SELECT * FROM Entities.tbl1_company" Dim daCompanies As New SqlDataAdapter(sCompanySelect, conDivisions) Dim dsCompanies As New DataSet() Dim intCompanies As Integer intCompanies = daCompanies.Fill(dsCompanies, "Companies") MessageBox.Show("Found " & intCompanies & " records.") dsCompanies.Clear() conDivisions.Close() <<<< I get an "Open" message from the first MessageBox.Show, and 0 from the second, even though there are some records in Entities.tbl1_company. Thanks for any help, Ray Tag: changing the connection for a strongly typed dataset Tag: 145045
  - 13
    - Rado Ladies Watches Crysma R41762713 - AA - Replica Watch Fake Rado Ladies Watches Crysma R41762713 - AA - Replica Watch Fake Rado Ladies Watches Crysma R41762713 - AA Link : http://www.watchesprice.net/Replica-Rado-12198.html Replica Watches Home : http://www.watchesprice.net/ Replica Rado Brands : http://www.watchesprice.net/Rado-Replica.html Replica Rado Ladies Watches Crysma R41762713 - AA --- one of best selling replica watches, it is crafted in high quality, please click image 'buy now' to buy this chic but inexpensive replica to save you a lot of money . Rado Ladies Watches Crysma R41762713 - AA Description: no Rado Ladies Watches Crysma R41762713 - AA Details: Brand: Rado Band material: Yellow Plated Bracelet Case material: Yellow Plated 23mm Dial color: Black with Diamonds Movement type: Quartz Water-resistant to 30 meters Thank you for choosing www.watchesprice.net as your reliable dealer of quality waches including Rado Ladies Watches Crysma R41762713 - AA . we guarantee every watch you receive will be exact watch you ordered. Each watch sold enjoy one year Warranty for free repair. Every order from aaa-replica-watches is shipped via EMS, the customer is responsible for the shipping fee on the first order, but since the second watch you buy from our site, the shipping cost is free. Please note that If the total amount of payment is over $600(USD), the customer is required to contact our customer service before sending the money in case failed payment. If you have any other questions please check our other pages or feel free to email us by service@watchesprice.net. Cheapest Rado Ladies Watches Crysma R41762713 - AA The Same Rado Series : Rado Ladies Watches Crysma R41764103 - AA : http://www.watchesprice.net/Replica-Rado-12199.html Rado Men's DiaMaster watch #R14343163 : http://www.watchesprice.net/Replica-Rado-12200.html Rado Men's Diamaster Watch #R14470151 : http://www.watchesprice.net/Replica-Rado-12201.html Rado Men's DiaMaster watch #R14341173 : http://www.watchesprice.net/Replica-Rado-12202.html Rado Women's DiaMaster watch #R14342173 : http://www.watchesprice.net/Replica-Rado-12203.html Rado Women's DiaMaster watch #R14344163 : http://www.watchesprice.net/Replica-Rado-12204.html Rado Women's Diaqueen Watch #R23411152 : http://www.watchesprice.net/Replica-Rado-12205.html Rado Women's Diaqueen Watch #R23428902 : http://www.watchesprice.net/Replica-Rado-12206.html Rado Women's Diaqueen Watch #R23445102 : http://www.watchesprice.net/Replica-Rado-12207.html Rado Women's Diaqueen Watch #R23446102 : http://www.watchesprice.net/Replica-Rado-12208.html Rado Men's Watches DiaStar R18570103 - AA : http://www.watchesprice.net/Replica-Rado-12209.html Rado Men's Watches DiaStar R18565253 - AA : http://www.watchesprice.net/Replica-Rado-12210.html Tag: changing the connection for a strongly typed dataset Tag: 145043
  - 14
    - Citizen Chronograph Blue Dial (Women's Watch) - Replica Watch Fake Citizen Chronograph Blue Dial (Women's Watch) - Replica Watch Fake Citizen Chronograph Blue Dial (Women's Watch) Link : http://www.watchesprice.net/Replica-Citizen-6169.html Replica Watches Home : http://www.watchesprice.net/ Replica Citizen Brands : http://www.watchesprice.net/Citizen-Replica.html Replica Citizen Chronograph Blue Dial (Women's Watch) --- one of best selling replica watches, it is crafted in high quality, please click image 'buy now' to buy this chic but inexpensive replica to save you a lot of money . Citizen Chronograph Blue Dial (Women's Watch) Description: Citizen Women's Eco-Drive Watch . Water resistant. Date indicator at between 4 and 5 o'clock position. Chronograph. Eco-Drive 150 day power reserve. Blue dial. Leather strap. Stainless steel case. # FA2020-02A FA2020 #. Citizen Chronograph Blue Dial (Women's Watch) Details: Watches-Price Sales Rank: #46746 in Watches Brand: Citizen Eco-Drive Dial color: Blue Thank you for choosing www.watchesprice.net as your reliable dealer of quality waches including Citizen Chronograph Blue Dial (Women's Watch) . we guarantee every watch you receive will be exact watch you ordered. Each watch sold enjoy one year Warranty for free repair. Every order from aaa-replica-watches is shipped via EMS, the customer is responsible for the shipping fee on the first order, but since the second watch you buy from our site, the shipping cost is free. Please note that If the total amount of payment is over $600(USD), the customer is required to contact our customer service before sending the money in case failed payment. If you have any other questions please check our other pages or feel free to email us by service@watchesprice.net. Cheapest Citizen Chronograph Blue Dial (Women's Watch) The Same Citizen Series : Citizen Chronograph Green Dial (Women's Watch) : http://www.watchesprice.net/Replica-Citizen-6170.html Citizen Chronograph Leather Strap (Women's Watch) : http://www.watchesprice.net/Replica-Citizen-6171.html Citizen Ciena Eco-Drive Ladies Watch EG2100-55E : http://www.watchesprice.net/Replica-Citizen-6172.html Citizen Eco Drive Ladies Stilleto (Women's Watch) : http://www.watchesprice.net/Replica-Citizen-6173.html Citizen Eco Drive Ladies Stilleto (Women's Watch) : http://www.watchesprice.net/Replica-Citizen-6174.html Citizen Eco Drive Ladies Stilleto (Women's Watch) : http://www.watchesprice.net/Replica-Citizen-6175.html Citizen Eco Drive Ladies Stilleto (Women's Watch) : http://www.watchesprice.net/Replica-Citizen-6176.html Citizen Eco Drive Ladies Stilleto (Women's Watch) : http://www.watchesprice.net/Replica-Citizen-6177.html Citizen Eco Drive Ladies Stilleto (Women's Watch) : http://www.watchesprice.net/Replica-Citizen-6178.html Citizen Eco Drive Ladies Watch EW0230-57H : http://www.watchesprice.net/Replica-Citizen-6179.html CITIZEN Eco Drive Women's Black Dial 2-Hand Watch SY2030-54E : http://www.watchesprice.net/Replica-Citizen-6180.html Citizen Eco-Drive Alarm (Women's Watch) : http://www.watchesprice.net/Replica-Citizen-6181.html Tag: changing the connection for a strongly typed dataset Tag: 145042
  - 15
    - Patek Complicated Chronograph Men's Watch 5960P - Replica Watch Fake Patek Complicated Chronograph Men's Watch 5960P - Replica Watch Fake Patek Complicated Chronograph Men's Watch 5960P Link : http://www.watchesprice.net/Replica-Patek-Philippe-18262.html Replica Watches Home : http://www.watchesprice.net/ Replica Patek Philippe Brands : http://www.watchesprice.net/Patek-Philippe-Replica.html Replica Patek Complicated Chronograph Men's Watch 5960P --- one of best selling replica watches, it is crafted in high quality, please click image 'buy now' to buy this chic but inexpensive replica to save you a lot of money . Patek Complicated Chronograph Men's Watch 5960P Description: The Patek Complicated Chronograph Men's Watch is a Automatic watch with a Platinum case and Matt dark brown alligator bracelet. The color of the dial is Anthracite with a Sapphire cover. The case diameter is 40.5 mm and water resistant up to 25 m / 82 ft. Patek Complicated Chronograph Men's Watch 5960P Details: Brand: Patek PhilippeDial Color : PurpleClasp : Purple LeatherWater Resistant : 25m/80ftCase Material : PlatinumMovement : AutomaticCase Diameter : 5960PDial Color : PurpleCrystal : Scratch Resistant SapphireGender : Mens Thank you for choosing www.watchesprice.net as your reliable dealer of quality waches including Patek Complicated Chronograph Men's Watch 5960P . we guarantee every watch you receive will be exact watch you ordered. Each watch sold enjoy one year Warranty for free repair. Every order from aaa-replica-watches is shipped via EMS, the customer is responsible for the shipping fee on the first order, but since the second watch you buy from our site, the shipping cost is free. Please note that If the total amount of payment is over $600(USD), the customer is required to contact our customer service before sending the money in case failed payment. If you have any other questions please check our other pages or feel free to email us by service@watchesprice.net. Cheapest Patek Complicated Chronograph Men's Watch 5960P The Same Patek Philippe Series : Patek Complicated Annual Calendar 18 kt Rose Gold Men's Watch 5396R : http://www.watchesprice.net/Replica-Patek-Philippe-18263.html Patek Philippe Twenty~4 Ladies Watch 4910/11R : http://www.watchesprice.net/Replica-Patek-Philippe-18264.html Patek Philippe Twenty~4 Mini Watch 4908/11R : http://www.watchesprice.net/Replica-Patek-Philippe-18265.html Patek Philippe Aquanaut Mens Watch 5065A : http://www.watchesprice.net/Replica-Patek-Philippe-18266.html Patek Philippe Calatrava 18kt Yellow Gold Mens Watch 5127-1J : http://www.watchesprice.net/Replica-Patek-Philippe-18267.html Patek Philippe Calatrava 18kt Rose Gold Mens Watch 5127R : http://www.watchesprice.net/Replica-Patek-Philippe-18268.html Patek Philippe Calatrava Travel Time Platinum Mens Watch 5134P : http://www.watchesprice.net/Replica-Patek-Philippe-18269.html Patek Philippe Calatrava Perpetual Calendar 18kt White Gold Mens Watch 5140G : http://www.watchesprice.net/Replica-Patek-Philippe-18270.html Patek Philippe Calatrava 18kt White Gold Mens Watch 5196G : http://www.watchesprice.net/Replica-Patek-Philippe-18271.html Patek Philippe Calatrava 18kt Rose Gold Mens Watch 5196R : http://www.watchesprice.net/Replica-Patek-Philippe-18272.html Patek Philippe Calatrava 18kt Yellow Gold Mens Watch 5196J : http://www.watchesprice.net/Replica-Patek-Philippe-18273.html Patek Philippe Twenty~4 Diamond Ladies Watch 4910-10A-10 : http://www.watchesprice.net/Replica-Patek-Philippe-18274.html Tag: changing the connection for a strongly typed dataset Tag: 145041
  - 16
    - Saving Data with DataAdapter to Jet DB I am trying to save changes to a dataset using the dataAdapters update method to an Access 2003 DB, therefore I'm using an OleDbDataAdapter to accomplish this. I am using a For/Next loop to change a single column of data in the dataTable, & I know this works. The problem arises when I try to write the changes to the Access DB, nothing happens but the code process properly. I use virtually the same code set in another project writing to a SQL server DB & that works just fine. Is there some issue with OLEDB & Jet that this does not work or that i must do something different? Just for laughs I included a code snipit of what i'm doing. Try Conn.Open() daVoters.Update(dsCommittee, "Voters") Conn.Close() dsCommittee.AcceptChanges() Catch ex As OleDb.OleDbException Conn.Close() MessageBox.Show("There was an error updating the Database" & vbCr & vbLf & ex.Message, "Prep Data", MessageBoxButtons.OK, MessageBoxIcon.Error) End Try BTW I can do this by writing each change to the DB as I change it in the datatable, but this requires me to open & close the connection nearly 1/2 million times (there are over400,000 records in the DB) Thanks Gary Tag: changing the connection for a strongly typed dataset Tag: 145037
  - 17
    - SqlCommandBuilder DeriveParameters Ouput Arg gets wrong direction First, I am using the Enterprise Library DatabaseFactory to get a Database object. I have traced the issue down to the SqlCommandBuilder DeriveParameters method. Given a stored procedure args: CREATE PROCEDURE UpdDept ( @KeyDepartmentIdentifier UNIQUEIDENTIFIER, @KEYTimestamp BINARY(8), @NewName NVARCHAR(50), : : @OutTimeStamp BINARY(8) ) Wheh I call the Database.DiscoverParameters (aka - SqlCommandBuilder.DeriveParameters) the @OutTimeStamp DbPArameter (SqlParameter) has its direction set to InputOutput. SQL procedure parameters are either input or output. InputOut is not defined (SQL 2005). Why is the direction set to InputOutput? This requires that I initialize the output parameter. JM Tag: changing the connection for a strongly typed dataset Tag: 145034
  - 18
    - Brand Watches Seiko Wrist Watches-Seiko 5 Automatic Mechnical Brand Watches Seiko Wrist Watches-Seiko 5 Automatic Mechnical Self- Winding Watch Blue Stainless Steel Water Resistant Men Watch Model SNKA39K1 Discount, Replica, Fake Browse our Seiko Wrist Watches-Seiko 5 Automatic Mechnical Self- Winding Watch Blue Stainless Steel Water Resistant Men Watch Model SNKA39K1 replica watches, which is sure the watch you are looking for at low price. There are more high quality designer watch replicas for selection Seiko Wrist Watches-Seiko 5 Automatic Mechnical Self-Winding Watch Blue Stainless Steel Water Resistant Men Watch Model SNKA39K1 Link : http://www.watches-brand.com/Replica-Seiko-13560.html Brand : Seiko ( http://www.watches-brand.com/Seiko-Replica.html ) Model : Seiko Wrist Watches-Seiko 5 Automatic Mechnical Self-Winding Watch Blue Stainless Steel Water Resistant Men Watch Model SNKA39K1 Description : <p>Japan 21 Jewels Automatic Self-Winding Movement. Stainless Steel Case and Band with Push Button Deployment Clasp. Day/Date Display with Spanish Option. See-Thru Screwdown Caseback. Water Resistant - 30 meters</p> Sale Price : $ 210.00 Seiko Wrist Watches-Seiko 5 Automatic Mechnical Self-Winding Watch Blue Stainless Steel Water Resistant Men Watch Model SNKA39K1 Details : <ul> <li>Watches-Price Sales Rank: #13997 in Watches </li> <li>Brand: Seiko</li> <li>Band material: stainless-steel</li> <li>Case material: stainless-steel</li> <li>Dial color: Blue</li> <li>Dial window material: Hardlex</li> <li>Movement type: automatic-self-wind</li> </ul> Seiko Wrist Watches-Seiko 5 Automatic Mechnical Self-Winding Watch Blue Stainless Steel Water Resistant Men Watch Model SNKA39K1 is new brand replica, join thousands of satisfied customers and buy your Seiko with total satisfaction. A watches-brand.COM 30 Day Money Back Guarantee is included with every Seiko Replica Series for secure, risk- free online shopping. watches-brand.COM does not charge sales tax for the Fake Seiko Wrist Watches-Seiko 5 Automatic Mechnical Self-Winding Watch Blue Stainless Steel Water Resistant Men Watch Model SNKA39K1. All of our replica watches are shipped via EMS to worldwide. Normally it takes 3days to prepare the fake watch you ordered and 5-10days to transmit depending on the different destination.We pay for the free shipping cost for total quantity over 20 pcs. The EMS tracking NO. will be sent by email when an order is shipped from our warehouse. No more other charges from watches-brand.com such as the tax. If you have any other questions please check our other pages or feel free to email us by sales@watches-brand.com. The Same Replica Seiko Watches Series : Seiko Wrist Watches-Seiko 5 Automatic Mechnical Self-Winding Metal Bracelet Silver Dial Men's Water Resistance SNXS75K : http://www.watches-brand.com/Replica-Seiko-13561.html Seiko 5 Men's Automatic Green Dial with Green Nylon Strap Watch : http://www.watches-brand.com/Replica-Seiko-13562.html Seiko Men's Sports Automatic (Made in Japan) Watch # SKZ211J1 : http://www.watches-brand.com/Replica-Seiko-13563.html Seiko Men's 5 Sports Automatic Watch #SNZ309K : http://www.watches-brand.com/Replica-Seiko-13564.html Seiko Wrist Watches-Seiko 5 Automatic Mechanical Self-Winding Date Day Silver-White Dial Stainless Steel Water Resistance Men's Watch SNK601K1 : http://www.watches-brand.com/Replica-Seiko-13565.html Seiko Automatic Black Dial (Men's Watch) : http://www.watches-brand.com/Replica-Seiko-13566.html Seiko Men's 5 Automatic Two Tone Stainless Steel Watch #SNXJ90 : http://www.watches-brand.com/Replica-Seiko-13567.html Seiko Men's 5 Sports Watch #SNK031K : http://www.watches-brand.com/Replica-Seiko-13568.html Seiko Men's Automatic (Made in Japan) Watch # SNKC47J1 : http://www.watches-brand.com/Replica-Seiko-13569.html Seiko Wrist Watches-Seiko 5 Automatic Mechnical Self-Winding Date Day Men's Gold Tone Watch SNXA06K : http://www.watches-brand.com/Replica-Seiko-13570.html Brand Watches Seiko Wrist Watches-Seiko 5 Automatic Mechnical Self- Winding Watch Blue Stainless Steel Water Resistant Men Watch Model SNKA39K1 Discount, Replica, Fake Tag: changing the connection for a strongly typed dataset Tag: 145033
  - 19
    - Brand Watches Audemars Piguet Edward Piguet Diamond 18kt White Gold Brand Watches Audemars Piguet Edward Piguet Diamond 18kt White Gold Black Ladies Watch 77206BC.ZZ.D001CR.01 Discount, Replica, Fake Browse our Audemars Piguet Edward Piguet Diamond 18kt White Gold Black Ladies Watch 77206BC.ZZ.D001CR.01 replica watches, which is sure the watch you are looking for at low price. There are more high quality designer watch replicas for selection Audemars Piguet Edward Piguet Diamond 18kt White Gold Black Ladies Watch 77206BC.ZZ.D001CR.01 Link : http://www.watches-brand.com/Replica-Audemars-Piguet-19131.html Brand : Audemars Piguet ( http://www.watches-brand.com/Audemars-Piguet-Replica.html ) Model : Audemars-Piguet-77206BC.ZZ.D001CR.01 Description : 18kt White Gold Case. Black Leather Strap. Black Dial With 4 Diamonds. Diamond Bezel. Deployment Clasp. Scratch Resistant Sapphire Crystal. Manual Winding Movement. Water Resistant At 20 meters (60 feet). Audemars Piguet Edward Piguet Diamond 18kt White Gold Black Ladies Watch 77206BC.ZZ.D001CR.01 Sale Price : $ 210.00 Audemars Piguet Edward Piguet Diamond 18kt White Gold Black Ladies Watch 77206BC.ZZ.D001CR.01 Details : <ul><li>Brand: Audemars Piguet</li><li>Gender : Ladies</li><li>Dial Color : Black</li><li>Bezel : Diamond</li><li>Clasp : Black Leather</ li><li>Water Resistant : 20m/60ft</li><li>Case Material : 18kt White Gold</li><li>Movement : Manual Winding</li><li>Crystal : Scratch Resistant Sapphire</li></ul> Audemars Piguet Edward Piguet Diamond 18kt White Gold Black Ladies Watch 77206BC.ZZ.D001CR.01 is new brand replica, join thousands of satisfied customers and buy your Audemars Piguet with total satisfaction. A watches-brand.COM 30 Day Money Back Guarantee is included with every Audemars Piguet Replica Series for secure, risk- free online shopping. watches-brand.COM does not charge sales tax for the Fake Audemars Piguet Edward Piguet Diamond 18kt White Gold Black Ladies Watch 77206BC.ZZ.D001CR.01. All of our replica watches are shipped via EMS to worldwide. Normally it takes 3days to prepare the fake watch you ordered and 5-10days to transmit depending on the different destination.We pay for the free shipping cost for total quantity over 20 pcs. The EMS tracking NO. will be sent by email when an order is shipped from our warehouse. No more other charges from watches-brand.com such as the tax. If you have any other questions please check our other pages or feel free to email us by sales@watches-brand.com. The Same Replica Audemars Piguet Watches Series : Audemars Piguet Edward Piguet 18kt White Gold Black Mens Watch 25987BC.OO.D002CR.01 : http://www.watches-brand.com/Replica-Audemars-Piguet-19132.html Audemars Piguet Edward Piguet Diamond 18kt White Gold Black Mens Watch 25946BC.ZZ.D001CR.01 : http://www.watches-brand.com/Replica-Audemars-Piguet-19133.html Audemars Piguet Edward Piguet 18kt White Gold Black Mens Watch 15121BC.OO.A002CR.01 : http://www.watches-brand.com/Replica-Audemars-Piguet-19134.html Audemars Piguet Edward Piguet 18kt White Gold Black Mens Watch 15015BC.OO.D001CR.01 : http://www.watches-brand.com/Replica-Audemars-Piguet-19135.html Audemars Piguet Millenary Steel Mens Watch 25897ST.O.1136ST.01 : http://www.watches-brand.com/Replica-Audemars-Piguet-19136.html Audemars Piguet Millenary Diamond 18kt White Gold Ladies Watch 79351BC.ZZ.1137BC.01 : http://www.watches-brand.com/Replica-Audemars-Piguet-19137.html Audemars Piguet Millenary Steel Brown Mens Watch 26150ST.OO.D084CU. 01 : http://www.watches-brand.com/Replica-Audemars-Piguet-19138.html Audemars Piguet Millenary 18kt Rose Gold Mens Watch 15051OR.OO.1136OR. 01 : http://www.watches-brand.com/Replica-Audemars-Piguet-19139.html Audemars Piguet Millenary 18kt White Gold Mens Watch 15051BC.OO.1136BC. 01 : http://www.watches-brand.com/Replica-Audemars-Piguet-19140.html Audemars Piguet Millenary 18kt Yellow Gold Black Mens Watch 14908BA.OO.D001CR.01 : http://www.watches-brand.com/Replica-Audemars-Piguet-19141.html Brand Watches Audemars Piguet Edward Piguet Diamond 18kt White Gold Black Ladies Watch 77206BC.ZZ.D001CR.01 Discount, Replica, Fake Tag: changing the connection for a strongly typed dataset Tag: 145032
  - 20
    - Datatable beginners question: Merge and row deletions... Hi! I'm trying to use merge in order to apply differences to a table. However, I can't seem to get the hang of it. Here's the short version: I got two data tables, one containing one row and one containing no rows. What I'd hoped to do was to merge the empty one into the non-empty one and get a roe deleted event and a deleted row. Is this possible? Maybe I'm missing something simple here? This is my code: using System; namespace DataSet { class Program { static void Main(string[] args) { // Init System.Data.DataTable Old = new System.Data.DataTable("T"); System.Data.DataTable New = new System.Data.DataTable("T"); // Add columns Old.Columns.Add("X", typeof(System.Int32)); New.Columns.Add("X", typeof(System.Int32)); //Making good Old.AcceptChanges(); New.AcceptChanges(); //Add Row to Old System.Data.DataRow R=Old.NewRow(); R["X"]=0; Old.Rows.Add(R); Old.AcceptChanges(); //Merge Old.Merge(New); Old.AcceptChanges(); //Check foreach (System.Data.DataRow Row in Old.Rows) {Console.WriteLine(Row["X"].ToString()+"/"+Row.RowState.ToString());} } } } Lots of Greetings and thanks! Volker -- For email replies, please substitute the obvious. Tag: changing the connection for a strongly typed dataset Tag: 145028
  - 21
    - how to extract value from LINQ query? Is it possible to extract a single value from the results of a LINQ query with out iterating over the results. For example I have a table in SQL Server: tblExample Type int <--this is a key field Descr nvarchar(5) I would like to get the description (Descr) field something like this in C#: string Description = from Example in db.tblExample where Example.Type = 1 select Example.Descr; I know this query returns an IQueryable and the above query won't compile because of type mismatch. Is there a way to get the string from the database field using a LINQ query? Thanks Tag: changing the connection for a strongly typed dataset Tag: 145026
  - 22
    - How to gei Last ID When I write new record with INSERT INTO i need to get ID (Autonumber, key of this table) from this, just written record. How to do that in ASP.NET (VB or C#) and SQL Server? Thanks Tag: changing the connection for a strongly typed dataset Tag: 145023
  - 23
    - OracleDataReader in Enterprise Library 3.1 I am trying to convert my code from straight ADO.NET to the Enterprise Library 3.1 Data Access App Block. It's mostly straightforward, but I ran into a problem with datareaders. The OracleDatabase.ExecuteReader method only returns an IDataReader object, which is mostly okay, except that IDataReader does not implement HasRows. I hoped that I could get past that by casting the IDataReader to an OracleDataReader, but when I try that, I get an InvalidCastException (Unable to cast object of type 'Microsoft.Practices.EnterpriseLibrary.Data.Oracle.OracleDataReaderWrapper' to type 'System.Data.OracleClient.OracleDataReader'). Is this a bug in the Enterprise Library, because this behavior doesn't appear to make sense. I believe I read that this cast works for the SqlDataReader, but I haven't tried that yet. Any ideas? Tag: changing the connection for a strongly typed dataset Tag: 145021
  - 24
    - Problems with LINQ and CLR Stored Procedure Hi all, I'm having a bit of a problem with Linq and a CLR Stored Procedure. I'm just trying to fill a gridview with a simple query that depends on multiple (one to n) search terms. The sproc is as follows: ALTER PROCEDURE [dbo].[CMS_Pages_Search] @searchString varchar(500) AS BEGIN SET NOCOUNT ON EXEC clr_CMS_Pages_Search @searchString END This works fine (returning a dataset from SQL Management Studio). The VB Procedure is as follows: Protected Sub btnSearch_Click(ByVal sender As Object, ByVal e As System.EventArgs) Dim db As New migkbDataContext grdResults.DataSource = db.CMS_Pages_Search(txtKeywords.Text.Trim) grdResults.DataBind() Dim iRowCount As Integer = grdResults.Rows.Count If iRowCount > 0 Then ResultMessage1.ShowSuccess("Search returned " & iRowCount & " results") Else ResultMessage1.ShowFail("No records found for search " & txtKeywords.Text.Trim) End If End Sub From the cms_Pages_Search call, there is no Intellisense to specify ToList etc. The code generated from the *.dbml designer file is trying to return an Integer (not what I want): <FunctionAttribute(Name:="dbo.CMS_Pages_Search")> _ Public Function CMS_Pages_Search(<Parameter(DbType:="VarChar(500)")> ByVal searchString As String) As Integer Dim result As IExecuteResult = Me.ExecuteMethodCall(Me, CType(MethodInfo.GetCurrentMethod,MethodInfo), searchString) Return CType(result.ReturnValue,Integer) End Function End Class When the btnSearch_Click sub is executed, when attempting to bind the grid to the datsource, the message "Data source is an invalid type. It must be either an IListSource, IEnumerable, or IDataSource." is displayed. Anyone have any ideas what's going on or ideas to work around this? Regards Jules Tag: changing the connection for a strongly typed dataset Tag: 145020
  - 25
    - Problem with ADOMD.NET and Pentaho (XMLA) Dear NG, I use ADOMD to programmatically access MS Analysis Service. In collaboration with the MS SQL Server works well. I wish to use in my project next to the MS Analysis also Pentaho Analysis Services. Since both do XMLA support it shouldn't be a problem. Problems occur, however, when I try to query ADOMD Pentaho to get more than three dimensions. I have inspected the XMLA, which exchanged and found that the ADOMD client requestes another (axis) format , if more than 2 dimensions are requested and Pentaho can unfortunately not answer in this required format . my question is now whether someone ever had this issue, and whether and how it has solved. Maybe there is a possibility that the ADOMD his client requests in a different format.Otherwise, is there any chance to get Pentaho to understand the different format (axis) without a lot of implementing? Maybe there is even an adapter somewhere. I would be grateful for any tip. Best Regards, Yvette Tag: changing the connection for a strongly typed dataset Tag: 145019

How can I change the connection used by a strongly typed dataset?
I have a strongly typed dataset which connects to a development database.
I want to change the connection string for production to point to the
production database.
Thanks

Bill

Top

Re: changing the connection for a strongly typed dataset by William

William
Thu May 01 17:24:27 CDT 2008

I setup an alias using the SQL Server Configuration Manager to point to my
dev system and do the same on the target system to point to the production
database. (see Chapter 9).

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________
"BillE" <belgie@datamti.com> wrote in message
news:OhLYFS8qIHA.3508@TK2MSFTNGP03.phx.gbl...
> How can I change the connection used by a strongly typed dataset?
> I have a strongly typed dataset which connects to a development database.
> I want to change the connection string for production to point to the
> production database.
> Thanks
>
> Bill
>

Top