Syncing with remote db

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
 - How to create a DataView by a specified row(s)? How to create a DataView by a specified row or rows? That is to say, when a row( or rows) are specified, is it possible to create a DataView which just includes this row (rows)? If not possible, is it possible to create a DataView, which only includes the parent row, by a specified row and the parent relation name? As you know, in ADO.net, there is DataRowView method as the following: public DataView CreateChildView(DataRelation); Due to I have to bind a DataView to a DataGrid, so I have to solve this problem. Please help me. Thank you in advance. Ying LI Tag: Syncing with remote db Tag: 96232
 - 2
 - Oracle Stored Procs with Parameters We are connecting to an Oracle 8.1.7 database using System.Data.OracleClient. Executing SELECT statements is easy. Modifying data is a cinch. Calling Stored Procedures was no problem until I tried to call a stored procedure with parameters. Calling a stored procedure with parameters generates the error: {ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'SP_CUSTREV_BY_INDVD' ORA-06550: line 1, column 7: PL/SQL: Statement ignored}. In an attempt to fix the problem, I have been through the posts at many newsgroups including this one, but to no avail. I have no doubt that I am missing something obvious, but would appreciate any help that can be had. KS ----------Oracle Stored Proc Header----------------- PROCEDURE SP_CUSTREV_BY_INDVD ( p_Indvd_Type IN varchar2, p_Indvd_Id IN varchar2, p_OrderNme IN varchar2, p_SortType IN varchar2, p_DecisionCode IN varchar2, outlist OUT types.ref_cursor ) IS ---------------.net code----------------------- Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 'Put user code to initialize the page here Dim conn As New OracleConnection("User ID=ME_USER;PASSWORD=ME_PASS;Data Source=WELLSPRING") Dim ds As New DataSet Dim xcp As Exception Dim oda As OracleDataAdapter conn.Open() Dim Cmd As New OracleCommand Cmd.Connection = conn Cmd.CommandText = "ME_SCHEMA.SP_CUSTREV_BY_INDVD" Cmd.CommandType = CommandType.StoredProcedure Cmd.Parameters.Add(New OracleParameter("p_Indvd_Type", OracleType.VarChar)).Value = "TSO" Cmd.Parameters.Add(New OracleParameter("p_Indvd_Id", OracleType.VarChar)).Value = "T000066700" Cmd.Parameters.Add(New OracleParameter("p_OrderNme", OracleType.VarChar)).Value = "CustNme" Cmd.Parameters.Add(New OracleParameter("p_SortType", OracleType.VarChar)).Value = "ASC" Cmd.Parameters.Add(New OracleParameter("p_DecisionCode", OracleType.VarChar)).Value = "All" 'Result Set Cmd.Parameters.Add(New OracleParameter("io_cursor", OracleType.Cursor)).Direction = ParameterDirection.Output Try oda = New OracleDataAdapter(Cmd) oda.Fill(ds) Me.dgr.DataSource = ds.Tables(0) Me.dgr.DataBind() Catch xcp xcpMessage = xcp.Message.ToString End Try conn.Close() End Sub -- Kasabaarde Sumta Tag: Syncing with remote db Tag: 96222
 - 3
 - Inserts and the Identity field I am trying to run an insert statement against a table, and I get an error: "Can not insert explicit value for identity column in table "table name" when Identity_Insert is set to off." Now, in the set up of the table, when I populate it, I set the Column in the columns collection to be an identity field and I set it to true and all that. This message seems to imply that I need to set something on the SQL Server side, through the database, but I'm thinking I shouldn't have to do that. How do I get around this? Can I just set some property through the ADO.Net? If so, what am I missing? I looked through about four pages of old posts and didn't see anything similiar, but I'm sure this has come up, and I apologize if I'm asking somethign that's been addressed already. Thanks, Thad. Tag: Syncing with remote db Tag: 96218
 - 4
 - Can I Use IN or CONTAINS in the Query Builder 'Can I Use 'IN' or 'CONTAINS' in the QueryBuilder of the DataAdapter's Configuration Wizard? When I use those words they are treated as text. I am able to use 'LIKE'. I would like to use either 'IN' or 'CONTAINS' followed by a parameter value in the 'criteria' column of the Query Builder -- Michael Hockstein Tag: Syncing with remote db Tag: 96211
 - 5
 - Performace and large datasets Hi, I have a SQL table with over 100,000 records. I have a stored procedure that return this record set to me(vb.net client), and i then display these records in a grid. The problem is that dataset waits for all the data, before the grid control can populate with this data. Is there away to get the dataset to allow the grid control, to access the dataset, even though it is not yet fully populate with data from the SQL server Hope this makes sense Tag: Syncing with remote db Tag: 96207
 - 6
 - DataSet and DateTime ? How can I extract a DateTime value from a Dataset in Asp.Net page to a DateTime field in code behind ? Here is my c# code: 1. Dataset ds=new Dataset (read by MS/Data Application Block) and was successfully displayed on the Asp.Net Data grid control. 2. DateTime dt=Convert.ToDateTime(ds.Tables[0].Columns["DateHired"].ToString()); I got an exception saying that the source field contains invalid data. The date displayed fine on the grid. Thanks Tom Tag: Syncing with remote db Tag: 96202
 - 7
 - DataSet Update I'm trying to update a modified dataset into an Access DB. Everything seems to work okay and I've run AcceptChanges on the dataset, but the number of updated records is always zero! Any assistance would be greatly appreciated. I've included the update function from my code at the end of this message. TIA Brad public int UpdateDataSet(System.Data.DataSet ds, string strTableName) { int iRecordsUpdated = 0; //Count of records updated if (Connect()) //Open a connection to the DB { //Creat the Select Command object System.Data.OleDb.OleDbCommand objCommand = new System.Data.OleDb.OleDbCommand("Select * from MyUsers",Connection()); //Create the Data Adapter using the previously created command object System.Data.OleDb.OleDbDataAdapter DA = new System.Data.OleDb.OleDbDataAdapter(objCommand); //Creat the command builder object using the Data Adapter System.Data.OleDb.OleDbCommandBuilder cb = new System.Data.OleDb.OleDbCommandBuilder(DA); DA.InsertCommand = cb.GetInsertCommand(); //This is the default SQL insert command DA.DeleteCommand = cb.GetDeleteCommand(); //This is the default SQL delete command DA.UpdateCommand = cb.GetUpdateCommand(); //This is the default SQL update command iRecordsUpdated = DA.Update(ds); //Update the database with the modified data set Disconnect(); //Disconnect the database } return (iRecordsUpdated); //Return the number of records updated } Tag: Syncing with remote db Tag: 96196
 - 8
 - DataTable.Select Bug in .Net Framework 1.1 SP1 Once again I'm submitting a bug introduced with .Net Framework 1.1 SP1 that is breaking our application. We use DataTable.Select method all over our application. One of the places we use it is to filter some Entity information for permanent deletion from the database! We noticed that the code that worked perfectly for months stoped working with SP1 of .Net Framework 1.1 with information loss since there were database deletions! We use loads of filters like this one: "(HistoryStartDate >= #07/01/2004 00:00:00#) AND EntityId=7016 AND FieldId=70 AND Deleted=0" this worked perfectly without .Net Framework SP1 but not with SP1. We have put together a Test Harness (with source code) at: http://pwp.netcabo.pt/0434926301/ The sample default filter is the one specified above wich should return 0 rows when applied to the default sample data (TestData.XML - included with the Test Harness). The problem is that the Date part of the filter doesn't work properly and rows are returned. If you try to apply just the Date part of the filter to the same sample data no rows are returned (the expected result!). I have seen other threads reporting this problem but it seems like the guys at Microsoft aren't very concerned since there are no replies. If someone out there could help I would very mutch appreciate it. I tried everything I could remember but made no progress. This is a very serious problem for us. Thanks in advance. Tag: Syncing with remote db Tag: 96195
 - 9
 - Trap rowchanged on DataTable I have a datagrid with a datatable as datasource, what I want to do is add a timestamp to a row (in a DateTime field) each time a Quantity field is filled. I've tried it with the grdColStyle4.textbox.TextChanged addhandler but since I can fill this field both by entering it manual or double clicking it it's not working well... I want to use something like this but the rowupdated event never gets trapped if I use the datagrid: AddHandler MyTempOrderTable.RowChanged, New DataRowChangeEventHandler(AddressOf DataTableRow_Changed) Is there an alternative way to do this? Regards, Mike Tag: Syncing with remote db Tag: 96194
 - 10
 - editing in binding manager I need some help. Hopefully will be simple. Usually I have users edit data in a data grid and then I call the update routine if the dataset has changes. I have an instance where data is bound to text boxes on a form. If the user needs to edit the information in one or more of these text boxes, these edits are not being saved back to the database. If threw in an if statement (if ds.haschanges then update...) but when debugging it is seeing that the dataset does not have changes. So I take it that directly typing into a text box that is bound to a field in the dataset does not directly change that data and set that row to modified? What might I be doing wrong here? Thanks for the information. Brad Tag: Syncing with remote db Tag: 96193
 - 11
 - Crystal Report - From stored proc. to unbound fields Hi all, I'm actually filling a report created with CR, using a stored proc. The data is returned in an ouput parameter of ref cursor type, and retrieved from a dataset using ADO. To display the data on the report, i used unbound fields, as i have single values only. Meaning, my dataset has one row but with multiple columns, each of them, bound to my unbound fields. Those unbound fields were added to the Header section of the report, as they need to be displayed only once. That works perfectly, i bound them using this code from a class : FormulaFieldDefinitions fielddefs; fielddefs = myrpt.DataDefinition.FormulaFields; DataRow r = ds.Tables[0].Rows[0]; foreach(FormulaFieldDefinition f in fielddefs) { f.Text = r[f.Name].ToString(); } Reportviewer.ReportSource = myrpt; The name of each unbound field, has got the same name of the column name in my dataset. Ok, my question is, assuming i would now have several rows in my dataset, the data should normally be displayed in the details section. So , how to bind my unbound fields to the dataset in this case ? I've tried the SetDatasource method, but it didn't work. Any Idea ? Thanks, Mike Tag: Syncing with remote db Tag: 96189
 - 12
 - TimeStamp with DataTable Hi! I have DataGrid bound to DataTable. I create DataTable "on fly" when application start without database connection. I use datagrid only to create simple XML-file for other purposes. Question: DataTable contains "Time"-column, and I need to get time into it automatically of the moment, when user adds a new row into DataGrid, but how to do it? It can't be only something like dc.DefaultValue = DateTime.Now; because time is not then time of the moment when DataGrid row was added by user. I think this must be easy, but I don't get it yet. Here's some of my code, if needed... DataColumn dc; dc = new DataColumn("Time"); dc.DataType = typeof(DateTime); dc.DefaultValue = DateTime.Now; dt.Columns.Add(dc); ... if(dc.ColumnName.ToString() == "Time") { textColumn.Format = String.Format("G", textColumn.TextBox); textColumn.ReadOnly = true; } -- Thanks in advance! Mika Tag: Syncing with remote db Tag: 96186
 - 13
 - More efficient way required. Hi I need a very efficient solution to a problem that I am sure must be a fairly common one. I have a web application that is database driven. The behaviour of the web site is goverened by various database settings, for example font-type, font-size as well as access to functionality (this function switched on/off) etc. For sake of simplicity, let us assume that all this information is held in three tables with almost identical schema. The first table contains all the settings for the Company, the next contains any over-rides required by a specific Department, and the third table contains all the over-rides required by a specific User. 4 use-case scenarios: + User A uses the company default values; the specific values in the Department and User tables are 'NULL'. + User B uses his Department values to over-ride the values in the Company table (his user record has 'NULL' + User C uses her own values to over-ride both the Company and the Department values. + User D uses his own values to over-ride the Company values; Department record contains 'NULL' So, the scenario is that the UI demands to know (say) 10 parameters for a particular user. Some values are therefore likely to come from all three tables. So, what is the fastest/most scalable way to achieve this (using VB.Net, ADO.NET, SQL)? The information will be READ only at this stage. [I am extremely new to .NET (VB6 back-ground) and THINK that I require a DataReader object to be returned to the UI, though am happy to be advised on this.] In VB6, I guess that I would have done this by: + The UI calls the BL asking for a particular User's settings. + The BL calls the DL asking for a hierarachical recordset (data-shaped). This contains the User record, the Department record and the Company record. + The BL then iterates through the User record - for every 'NULL' value it looks in the Department record and (if that's NULL too) in the Company record. It then returns to the UI the "merged" results. Many thanks in advance! Griff Tag: Syncing with remote db Tag: 96174
 - 14
 - Crystal report - failed in changing the Logon information at runtime all, I am having issue changing the DB logon information at the runtime when loading non-typed Crystal Report file to .NET WinForm application. I checked the connection string values and confirmed they are all correct. The error message and partial codes are listed below, except I replace the db connection string variables with string values. The similar logics works fine in typed-report(of course, using report class instead of ReportDocument). Based on all the document and sample I have, I can't think of anything missing? Thanks for any help, Michael =========Exception Error Message ======= "Unhandled Exception: Log on failed. Exception Type: CrystalDecision.... Inner Exception: Type: System.Runtime.InteropServices.COMException Message: Logon failed. Error in File C:\Docume~1\.....\{D371789A....}.rpt Unable to connect: incorrect log on parameters Stack Trace: ..... " =========== partial codes ========== ReportDocument reportClass= new ReportDocument(); reportClass.Load(ReportFilePath); TableLogOnInfo logonInfo = new TableLogOnInfo(); foreach(Table table in reportClass.Database.Tables) { logonInfo = table.LogOnInfo; logonInfo.ConnectionInfo.ServerName = "localhost"; logonInfo.ConnectionInfo.DatabaseName = "TestDB"; logonInfo.ConnectionInfo.UserID = "sa"; logonInfo.ConnectionInfo.Password = "pswd"; // Apply the connection information to the table. table.ApplyLogOnInfo(logonInfo); } this.rptViewer.ReportSource = reportClass; Tag: Syncing with remote db Tag: 96171
 - 15
 - Setting a DateTime Parameter to DBNULL.Value I have a table with a DateTime column. I have a SQLDataAdapter which queries the table and then fills a TypedDataSet. The DataAdapter has a parameter value in the DateTime column. I want to find all the rows with nulls in this DataTime column. So, I set the ...SelectCommand.Parameters("Name of Parameter").Value = DBNULL.Value Even though I am certain there are rows with nulls in these columns, the query returns no rows. Is there a special way to look for nulls in DateTime columns? Michael -- Michael Hockstein Tag: Syncing with remote db Tag: 96169
 - 16
 - Dataset not populating Hi, I created a dataset by dragging a (SQL Server) stored procedure from the Servers pane. The dataset consists of three tables that are not linked (at least I do not enforce contraints). But when I try to populate the dataset by SqlClient.SqlDataAdapter.Fill(ds, tableName) I receive the following error: "Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints." Please note that the same code works fine for a different dataset, so there are no syntax errors. I have checked that all the fields that are not marked as minOccurs="0" return not Null values; I even tried to set minOccurs="0" for all fields in the dataset - same result. Please help.... Tag: Syncing with remote db Tag: 96164
 - 17
 - DataSet DataRelation I am attempting to add a second Data Relation from the code-behind. It only seems to be taking the first. anybody have an idea what I am doing wrong. System.Data.DataRelation dataRelation3; System.Data.DataColumn dataColumn5; System.Data.DataColumn dataColumn6; dataColumn5 = dsSports.Tables[2].Columns["CategoryID"]; dataColumn6 = dsSports.Tables[3].Columns["CategoryID"]; dataRelation3 = new System.Data.DataRelation("ParentChild3", dataColumn5, dataColumn6); dsSports.Relations.Add(dataRelation3); System.Data.DataRelation dataRelation4; System.Data.DataColumn dataColumn7; System.Data.DataColumn dataColumn8; dataColumn7 = dsSports.Tables[2].Columns["sportID"]; dataColumn8 = dsSports.Tables[3].Columns["sportID"]; dataRelation4 = new System.Data.DataRelation("ParentChild4", dataColumn7, dataColumn8); dsSports.Relations.Add(dataRelation4); Thanks in advance. Brian K. Williams Tag: Syncing with remote db Tag: 96163
 - 18
 - ExecuteReader Null exception in heavy traffic Hi, I have a created an application using web services and sql server. On my dev server, it's working, but when I switched to the production server with heavier traffic (100 users at the same time), I got this error: System.NullReferenceException: Object reference not set to an instance of an object. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteReader() at LiveSnapDotNet.server.database.BDSqlServer.executeSQLQuery(SqlCommand sqlCommand) Here's my code: /* Opens a connection, sets the connection with new SqlConnection() */ openConnection(); if (connection != null) { try { /* Sets the command properties */ sqlCommand.Connection = connection; sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.CommandText = "sp_getUsers" /* Executes it */ resultSet = sqlCommand.ExecuteReader(); } catch(Exception e) { ... } Why this error keeps occuring when there's many users? DO I have to increase the connection pool max size? Thanks for any help. Stephane Tag: Syncing with remote db Tag: 96162
 - 19
 - No 'New' accessable with Data Set I have a dataset in a class library and when I try to create a new table in another project that has a reference to that dataset I'm getting the error "Overload resolution failed because no 'New' is accessible." There are a bunch of different tables in this dataset and there are only two that I'm having this problem with. I can instantiate all other tables just fine. I have tried completely deleting this dataset and re-creating it and these tables still have the same problem. If I go into the code behind the dataset I can see that the constructor and some other properties are marked as "friend" and I can manually change them to "public" and it fixes the problem but this means that if I ever re-generate those particular tables I have to manuall fix it again. Is there any way to fix this? Tag: Syncing with remote db Tag: 96161
 - 20
 - Newbee question, how to navigate between records. Hi! I am realy new to this .NET ADO. Basicly i have a webform with fields that displays data, what i want to do is add two buttons next and previous, the names are obviously telling what the action should be :D What command should i issue and on what component to move to the next record? Also, what to send to update a record that has been edited. I am using C# and VStudio 2003, and the app is for the web, not an win.application Regards Martin Arvidsson Tag: Syncing with remote db Tag: 96155
 - 21
 - Help! SqlHelper.FillDataset & connections question Has anyone seen this error? I'll try to explain in English because the code sample would be too big, but I can attach code if necessary... In my SaveButton_onClick event, I retrieve values off of my asp.net page, then I call a stored procedure to save the values. This process always works great the first time. On subsequent clicks of the same button (sometimes I change the data, but sometimes it's the same), I will get an exception thrown that includes the text: "Additional Information: A connection pooling error has occurred". In my aspx.vb on_click event, I create a Transaction that's passed into the SqlHelper.ExecuteScalar function to call the proc. After the data has been saved, I do myTransaction.Transaction.Commit(), then myTransaction = Nothing. I've tried myTransaction.Transaction.dispose(), and a number of other combinations. I cannot figure out what line causes the error. I have set right before everything that works with the connection, and sometimes I get this exception thrown right when I click the button, as if it's having a problem on the postback. I'm also using quite a number of Datasets to populate my page in the first place. Using the MS Application Block for data access, I use SqlHelper.FillDataset to populate each of 10 datasets on the page. SqlHelper has a bunch of overloaded FillDataset methods, but we're using one of the ones that just passes in a connection string (rather than an actual connection). Do you know if SqlHelper.FillDataset closes the database connection before it returns to the caller? I cannot decide whether I should just be passing in the same connection (pre-opened) to the FillDataset method, or if passing in the conx string is better/worse. I'm convinced that somehow I've got too many database conx open, but I don't know exactly how. Other info: I know my conx string is consistent because it's hidden in a class, that uses the same conx string no matter what database function I'm calling. This is preventing me from testing locally, so any help is greatly appreciated!!! Tag: Syncing with remote db Tag: 96154
 - 22
 - hidng and showing rows on a datagrid Hello all, I have a datagrid that is bound to a database table using the designer. What I need to do is show or hide data on the grid via a button. e.g. "Show completed tasks" and "Hide Completed Tasks" How wold I go about doing this? Is there a function for the datagrid to be able to do this or would I have to connec to the db again and bind to a new query? cheers Tag: Syncing with remote db Tag: 96153
 - 23
 - How to position to row in DataView or DataTable Is it possible to position to a specific row in a DataTable or DataView? I have a DataGrid that displays either a detail view or a summary view and uses built-in paging. Both sets of data are from the same database table, the summary view is an aggregate (group by) with one less column than the detail view. When the user changes views, I execute the appropriate stored procedure and re-bind the results to the grid. The problem is I need to re-display the same page of records in the new view. In other words, if the record for company ABC was the first record displayed in the grid in one view, it needs to be the first record in the other view as well. Currently if the user has paged down to page 3 and changes views, they are back on page 1. Thanks for you help, Mark Tag: Syncing with remote db Tag: 96150
 - 24
 - Opening an XML Recordset in ADO.Net? Hi everyone, I was wondering: does ADO.Net have any methods for opening/reading ADO recordsets that have been persisted to XML? The ideal for me would be to open the contents of an XML recordset (that's been persisted to disk) in a DataTable of some sort. Thanks for pointing me in the right direction. -Jim Tag: Syncing with remote db Tag: 96147
 - 25
 - Wish List What I would like to see is a markup for database-aware classes. Something like... <Table("Customers")> Class Customer <Column("FirstName")> Property FirstName as String <Column("LsatName")> Property LastName as String End Class -- Jonathan Allen Tag: Syncing with remote db Tag: 96143
- Next
 - 1
 - Design issue with O/R mapping Hi. Im have asked for recommendation regarding the best production ready O/R mapping tools for .net. I got that. Since im an old, ok maybe not old, Java programmer patterns and developement with tiers is of great importance for me. I have a problem with the famours anti-pattern Tier leakage. In the Java world I used POJO´s (simple java classes) as value objects. These value objects was used for cayrring data between the tiers. So if i changed the persistence tier the rest of the code still relyed in the same POJO´s. Now with the .net O/R they all genereate eg. EmployeeEntity wich inherit from EntityBase2 (LLBL PRO). If I pass the object from my persistence layer to the business layer and down to the view I have just made a seriuos "maintaince bug" the "tier leakage". If i wanna use eg. the EntityBroker im so to say fucked. I have to refactor ALL and EVERY class witch depend on the EmployeEntity. Have anyone thougt about this and come up with an solution? Is the persistence tools wich can map PURE c# classes to realtionel classes as the Java Hibernate? And why have so few chosen this way of doing it? Is it hard to map eg. Customer c = new Customer(); // fill object adapter.SaveEntity(c); And go find what this Customer really maps to int the Database? Anders Jacobsen Tag: Syncing with remote db Tag: 96137
 - 2
 - Datacolumn.Expression and double Parent Hi all, I just managed to make "quasi-join" in the dataset (for displaying it in Windows Forms datagrid): Dataset1.Relations.Add("MyRelation",Table1.Id,Table2.T1Id) Dataset1.Tables!Table2.Columns.Add("ParentValue", _ GetType(String),"Parent(MyRelation).Value") Now I have a new problem: the parent table has another Parent, and I need to display one of its fields (Table3.Value2) Table3.Id <--> Table1.T3Id, Table1.Id <--> Table2.T1Id I've tried this: Dataset1.Relations.Add("MyRelation2",Table1.T3Id,Table3.Id) Dataset1.Tables!Table3.Columns.Add("ParentValue2", _ GetType(String),"Parent(MyRelation).Parent(MyRelation2).Value2") But it causes nothing but an exception. Any ideas? Michal. Tag: Syncing with remote db Tag: 96135
 - 3
 - como trabajar con apis de windows, en .net ? ¿Como se trabaja con las Api de Windows, utilizando C# .Net ? gracias... --------------------------------------------------------------------------- --------------------------------------------------------------------------- Utilizando .Net, como puedo obtener la dirección ip o el nombre del cliente remoto que está conectado por Terminal Service a un Servidor de Terminal ? En el Terminal Servide Manager me muestra el nombre del cliente remoto, o sea del equipo remoto, pero no se como obtenerlo utilizando C# .Net. gracias. Tag: Syncing with remote db Tag: 96132
 - 4
 - Need Help with binding 3 datalists with one sql statement This is a multi-part message in MIME format. ------=_NextPart_000_0008_01C4A497.6D9A4420 Content-Type: text/plain; charset="windows-1256" Content-Transfer-Encoding: quoted-printable Hi There, I have 3 nested datalists for which I have only one sql statement, = prevously I was trying to execute a sql statement inside the second = datalist in order to populate it, I have now modified my sql statment = include all of the data I need. What I would like to do is populate all = 3 datalists from the same sql statement. Can this be done? or should I = scrap the datalists altogether and use a datareader & and asp table = control? thanks in advance sample data +------------+------+------+-----------+--------+---------------+--------= --+ | qoh | size | shop | style | colour | colourdesc | = sizedesc | +------------+------+------+-----------+--------+---------------+--------= --+ | 0000000000 | 3 | 1 | 10475RIB1 | 2 | BLACK | XS = | | 0000000002 | 4 | 1 | 10475RIB1 | 2 | BLACK | S = | | 0000000000 | 5 | 1 | 10475RIB1 | 2 | BLACK | M = | +------------+------+------+-----------+--------+---------------+--------= --+ <asp:datalist id=3D"Datalist1" runat=3D"server" = repeatdirection=3D"Horizontal" Font-Name=3D"Verdana" Font-Size=3D"11pt" = HorizontalAlign=3D"Center" OnItemDataBound=3D"BuildqohGrid"> <ItemTemplate> <%# DataBinder.Eval(Container.DataItem, "sizedesc") %> </ItemTemplate> </asp:datalist> <asp:datalist id=3D"dtlistsColour" runat=3D"server" = Font-Name=3D"Verdana" Font-Size=3D"11pt" HorizontalAlign=3D"left" = Width=3D"100%" BorderStyle=3D"Solid" ItemStyle-Height=3D"20"> <ItemTemplate> <table> <tr> <td> <%# DataBinder.Eval(Container.DataItem, "colourdesc") %> </td> <td> <asp:datalist id=3D"dtlistqoh" RepeatDirection=3D"Horizontal" = runat=3D"server" Font-Name=3D"Verdana" Font-Size=3D"11pt" = HorizontalAlign=3D"Right" ItemStyle-VerticalAlign=3D"top" = ItemStyle-Width=3D"20"> <ItemTemplate> <%# DataBinder.Eval(Container.DataItem, "qoh") %> </ItemTemplate> </asp:datalist> </td> </tr> </table> </ItemTemplate> </asp:datalist> Private Sub Page_Load(ByVal sender As System.Object, ByVal e As = System.EventArgs) Handles MyBase.Load If Not IsPostBack Then RenderColours() End If End Sub Public Sub RenderColours() Dim myconnection As New OleDb.OleDbConnection() myconnection =3D common.connDB() Dim strColourSql As String =3D "select qoh, shopsales.size, = shopsales.shop, shopsales.style, shopsales.colour, co.colourdesc, = sz.sizedesc from shopsales inner Join shops on shopsales.shop =3D = shops.shop inner join colours co on shopsales.style =3D co.style and = shopsales.colour =3D co.colour inner join sizes sz on shopsales.style = =3D sz.style and shopsales.size =3D sz.size where shopsales.shop =3D 1 = and shopsales.style =3D '10475RIB1'" myconnection.Open() Dim myColourDataAdapter As New = OleDb.OleDbDataAdapter(strColourSql, myconnection) myColourDataAdapter.Fill(ds1) Datalist1.DataSource =3D ds1 Datalist1.DataBind() myconnection.Close() myColourDataAdapter.Dispose() myconnection.Dispose() End Sub Sub BuildqohGrid(ByVal sender As Object, ByVal e As = DataListItemEventArgs) If e.Item.ItemType =3D ListItemType.Item Or _ e.Item.ItemType =3D ListItemType.AlternatingItem Then 'Build the DataGrid Dim dg =3D CType(e.Item.FindControl("dtlistqoh"), DataList) ' dg.rer() Dim drvColour As DataRowView =3D CType(e.Item.DataItem, = DataRowView) Dim intColour As String intColour =3D CType(drvColour("colour"), Integer) Dim cnn As New OleDb.OleDbConnection() cnn =3D common.connDB() Dim cmd As New OleDb.OleDbCommand() cmd.CommandType =3D CommandType.Text cmd.CommandText =3D "select qoh,size from shopsales where = style=3D'10475RIB1' and shop=3D1 and colour=3D" & intColour & "" cmd.Connection =3D cnn cnn.Open() dg.DataSource =3D cmd.ExecuteReader dg.DataBind() 'Add the DataGrid to the 2nd Column ' e.Item.Controls.Add(dg) cnn.Close() cmd.Dispose() cnn.Dispose() End If End Sub Regards ------=_NextPart_000_0008_01C4A497.6D9A4420 Content-Type: text/html; charset="windows-1256" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Dwindows-1256"> <META content=3D"MSHTML 6.00.2800.1458" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY dir=3Dltr> <DIV>Hi There, I have 3 nested = datalists for=20 which I have only one sql statement,=20 prevously I was trying to execute a sql statement inside the second = datalist in=20 order to populate it, I have now modified my sql statment include all of = the=20 data I need. What I would like to do is populate all 3 datalists from = the same=20 sql statement. Can this be done? or should I scrap the datalists = altogether and=20 use a datareader & and asp table=20 control?  thanks in advance sample=20 data +------------+------+------+-----------+--------+---------------+= ----------+ |=20 qoh        | size | shop | style     | = colour |=20 colourdesc    | sizedesc=20 | +------------+------+------+-----------+--------+---------------+---= -------+ |=20 0000000000 |    3 |    1 | 10475RIB1 |     =  2=20 | BLACK         | XS       | | = 0000000002=20 |    4 |    1 | 10475RIB1 |      2 | = BLACK=20         | S        | | = 0000000000 |=20    5 |    1 | 10475RIB1 |      2 | = BLACK=20         | M      =20  | +------------+------+------+-----------+--------+-------------= --+----------+ <asp:datalist=20 id=3D"Datalist1" runat=3D"server"=20 repeatdirection=3D"Horizontal" Font-Name=3D"Verdana" Font-Size=3D"11pt"=20 HorizontalAlign=3D"Center"=20 OnItemDataBound=3D"BuildqohGrid"> <ItemTemplate> <%#=20 DataBinder.Eval(Container.DataItem, "sizedesc")=20 %> </ItemTemplate> </asp:datalist> <asp:datali= st=20 id=3D"dtlistsColour" runat=3D"server" Font-Name=3D"Verdana" = Font-Size=3D"11pt"=20 HorizontalAlign=3D"left" Width=3D"100%" BorderStyle=3D"Solid"=20 ItemStyle-Height=3D"20"> <ItemTemplate> <table> &= lt;tr> <td> <%#=20 DataBinder.Eval(Container.DataItem, "colourdesc")=20 %> </td> <td> <asp:datalist id=3D"dtlistqoh"=20 RepeatDirection=3D"Horizontal" runat=3D"server" Font-Name=3D"Verdana" = Font-Size=3D"11pt"=20 HorizontalAlign=3D"Right" ItemStyle-VerticalAlign=3D"top"=20 ItemStyle-Width=3D"20"> <ItemTemplate> <%#=20 DataBinder.Eval(Container.DataItem, "qoh")=20 %> </ItemTemplate> </asp:datalist> </td><BR= ></tr> </table> </ItemTemplate> </asp:datal= ist> Private=20 Sub Page_Load(ByVal sender As System.Object, ByVal e As = System.EventArgs)=20 Handles MyBase.Load         If Not IsPostBack=20 Then             = RenderColours()  =20       End If     End Sub   =   Public=20 Sub RenderColours()         Dim myconnection = As New=20 OleDb.OleDbConnection()         myconnection = =3D=20 common.connDB()         Dim strColourSql As = String =3D=20 "select qoh, shopsales.size, shopsales.shop, shopsales.style, = shopsales.colour,=20 co.colourdesc, sz.sizedesc from shopsales inner Join shops on = shopsales.shop =3D=20 shops.shop inner join colours co on shopsales.style  =3D co.style = and=20 shopsales.colour =3D co.colour inner join sizes sz on shopsales.style = =3D sz.style=20 and shopsales.size  =3D sz.size where shopsales.shop =3D 1 and = shopsales.style=20 =3D '10475RIB1'"        =20 myconnection.Open()         Dim = myColourDataAdapter=20 As New OleDb.OleDbDataAdapter(strColourSql, myconnection)   =  =20     myColourDataAdapter.Fill(ds1)       =  =20 Datalist1.DataSource =3D ds1        =20 Datalist1.DataBind()        =20 myconnection.Close()        =20 myColourDataAdapter.Dispose()        =20 myconnection.Dispose()     End Sub     = Sub=20 BuildqohGrid(ByVal sender As Object, ByVal e As = DataListItemEventArgs)  =20       If e.Item.ItemType =3D ListItemType.Item Or = _  =20              e.Item.ItemType =3D=20 ListItemType.AlternatingItem Then           =  =20 'Build the DataGrid             Dim dg = =3D=20 CType(e.Item.FindControl("dtlistqoh"), DataList)     =  =20       '  dg.rer()       =  =20     Dim drvColour As DataRowView =3D CType(e.Item.DataItem,=20 DataRowView)             Dim intColour = As=20 String             intColour =3D=20 CType(drvColour("colour"), Integer)       =  =20     Dim cnn As New OleDb.OleDbConnection()     =  =20       cnn =3D common.connDB()       =  =20     Dim cmd As New OleDb.OleDbCommand()     =    =20     cmd.CommandType =3D CommandType.Text     =    =20     cmd.CommandText =3D "select qoh,size from shopsales where=20 style=3D'10475RIB1' and shop=3D1 and colour=3D" & intColour & = ""  =20           cmd.Connection =3D cnn   =    =20       cnn.Open()           =  =20 dg.DataSource =3D cmd.ExecuteReader         =    =20 dg.DataBind()             'Add = the=20 DataGrid to the 2nd Column             = '=20 e.Item.Controls.Add(dg)             = cnn.Close()             = cmd.Dispose()  =20           cnn.Dispose()       =  =20 End If     End Sub</DIV> <DIV> </DIV> <DIV> </DIV> <DIV>Regards</DIV></BODY></HTML> ------=_NextPart_000_0008_01C4A497.6D9A4420-- Tag: Syncing with remote db Tag: 96122
 - 5
 - Finding SQL server Hello all, I have an (winforms) application that uses 3 different databases (MS SQLserver 2000) that may be located in 1 or more SQL servers. When run for the first time the user is presented a form where he can type in the name of the SQL server and the database. The user can then test the connection and save the configuration. Now I want to make things a little bit easier by presenting the user a list of available SQL servers and if possible database where he can choose from. How do I go about? Tia Jan Tag: Syncing with remote db Tag: 96120
 - 6
 - ODBC & OLEDB Hello, I am "trying (struggling) to" create an user interface with VB.NET that will allow me to connect to existing Acess databases through ODBC as well as OLEDB. Due to many reasons I do not wish to hard code the connection strings. I am using the Data Link API to obtain the connection strings at run time. The codes works fine with OLEDB to connect and run queries but with ODBC it generates a system error. I simply CANNOT figure out the following: 1. What is wrong with the ODBC connection string? 2. Why the same logic/code works with OLEDB and not with ODBC as the connection string is obtained in similar way? Thanks & Regards, Mark Please find my codes below: 'Getting the String Dim udl As String = Application.StartupPath & "\Data.udl" IO.File.Delete(udl) IO.File.Create(udl).Close() Process.Start(udl).WaitForExit() Dim sw As New IO.StreamReader(udl) sw.ReadLine() sw.ReadLine() Dim conn As String = sw.ReadToEnd sw.Close() 'Display the Connection String in a Text Box. txtConnection.Text = Conn Conn = (Conn.Trim) dt = New DataTable If InStr(Conn, "MSDASQL", CompareMethod.Text) = 0 Then Dim nwindConn As OleDb.OleDbConnection = New OleDb.OleDbConnection(Conn) nwindConn.Open() schemaTable = nwindConn.GetOleDbSchemaTable(OleDb.OleDbSchemaGuid.Tables, _ New Object() {Nothing, Nothing, Nothing, "TABLE"}) nwindConn.Close() Else MsgBox("ODBC Connection") Dim co1 As New Odbc.OdbcConnection(Conn.Trim) 'The code works fine till this point. It creates a system error in the next line. co1.Open() ' System Error is created here. Dim cm As Odbc.OdbcCommand = New Odbc.OdbcCommand("", co1) schemaTable = cm.ExecuteReader.GetSchemaTable co1.Close() End If The connection strings are: 1.) File Data Source Connection String: This One does not work DBQ=C:\DataTest.mdb;DefaultDir=C:\Documents and Settings\Administrator\My Documents\25 Test 1\Black\WindowsApplication1\bin;Driver={Microsoft Access Driver (*.mdb)};DriverId=25;FIL=MS Access;FILEDSN=C:\Program Files\Common Files\ODBC\Data Sources\ppp.dsn;MaxBufferSize=2048;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;Threads=3;UID=admin;UserCommitSync=Yes; 2.) Selected from DataSourceList: This one does not work: Provider=MSDASQL.1;Persist Security Info=False;Data Source=SOF8991S3A 3.) 'OLEDB STRING: This One works Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\DataTest.mdb;Persist Security Info=False Tag: Syncing with remote db Tag: 96116
 - 7
 - Further filter a DataRow Array Hi Everyone; I have applied a filter to a DataTable to return a DataRow array. I would like to apply a filter to this DataRow array to further limit the DataRows that I would like to work with. However DataRow does not support the Select method. How can I workaround this problem?? Ajit Goel Tag: Syncing with remote db Tag: 96110
 - 8
 - ODBC /OLEDB Connection Dear All, I am "trying (struggling) to" create an user interface with VB.NET that will allow me to connect to existing Acess databases through ODBC as well as OLEDB. Due to many reasons I do not wish to hard code the connection strings. I am using the Data Link API to obtain the connection strings at run time. The codes works fine with OLEDB to connect and run queries but with ODBC it generates a system error. I simply CANNOT figure out the following: 1. What is wrong with the ODBC connection string? 2. Why the same logic/code works with OLEDB and not with ODBC as the connection string is obtained in similar way? I am at the end of my patience and might end up doing something desperate. If any kind hearted person is listening --please help. Please find the codes below: Thanks & Regards, Mark 'Getting the Connection String Dim udl As String = Application.StartupPath & "\Data.udl" IO.File.Delete(udl) IO.File.Create(udl).Close() Process.Start(udl).WaitForExit() Dim sw As New IO.StreamReader(udl) sw.ReadLine() sw.ReadLine() Dim conn As String = sw.ReadToEnd sw.Close() 'Display the Connection String in a Text Box. txtConnection.Text = Conn Conn = (Conn.Trim) dt = New DataTable If InStr(Conn, "MSDASQL", CompareMethod.Text) = 0 Then Dim nwindConn As OleDb.OleDbConnection = New OleDb.OleDbConnection(Conn) nwindConn.Open() schemaTable = nwindConn.GetOleDbSchemaTable(OleDb.OleDbSchemaGuid.Tables, _ New Object() {Nothing, Nothing, Nothing, "TABLE"}) nwindConn.Close() Else MsgBox("ODBC Connection") Dim co1 As New Odbc.OdbcConnection(Conn.Trim) 'The code works fine till this point. It creates a system error in the next line. co1.Open() ' System Error is created here. Dim cm As Odbc.OdbcCommand = New Odbc.OdbcCommand("", co1) schemaTable = cm.ExecuteReader.GetSchemaTable co1.Close() End If ' The Exception occurs at Co1.Open() and the message is: 'An unhandled exception of type 'System.Data.Odbc.OdbcException' 'occurred in system.data.dll 'Additional information: System error. Tag: Syncing with remote db Tag: 96099
 - 9
 - Best way to populate webpages from multiple tables Hi, We are in the process of designing an ASP.NET app, where a user will enter some 'Customer ID' to be queried in the database. If the ID is valid, several stored procedures will be called to populate multiple webpages containing customer information. There isn't a one-to-one correlation between the stored procedure and a webpage. In other words, a webpage may have to refer to 1 or more DataTables to populate itself. Therefore, a DataTable that was used to populate webpage1 will need to be kept to populate webpage2. In order to make this process quick and efficient, we are trying to devise an effective scheme. Here are a couple of options we've come up with. I would highly appreciate it, if you folks can give your comments and/or suggestions on this matter. Option 1: Object Model. Create a CustomerInfo Object with the necessary properties, and populate it (using a DataReader)with the values returned by calling each of the stored procedure, store the object in a session variable, and use it to populate the webpages. Option 2: Store each of the DataTables returned from the stored procedures in DataSet, save the DataSet in a session variable, and use it to populate each of the webpages. So, my question are... Is it worth creating a Customer object (option1) to populate the various pages, or is it just better to use a DataSet (option2), despite the fact it will be larger in size? BTW, we are estimating the size of the Customer object to be ~8-10K. How much extra overhead will a DataSet add? Also, we will be hosting the app on a webfarm, so the session variables will be saved on SQL server. And the information is needed only once to populate the pages. There will approximately be 8 webpages showing customer info, and 7 stored procedures to be called. Again, I thank you for you help, and I look forward to your response. Tag: Syncing with remote db Tag: 96098
 - 10
 - No more H1B's. American jobs for American citizens. Election day is coming up. It is clear that the interestes of tech workers do not lay with either of the parties, therefore the best strategry for your interests is to punish the incumbent, George Bush. During the past 4 years 400,000 tech jobs have been lost. Despite this the govenment not only clings on to the discredited H1B program but is actually advocating for an increase in the number of foreigners to be brought over and take American jobs. It is absurd to argue that these are jobs that Americans cannot/willnot do. Americans are the best software developers in the world, are now and always have been. Name a single significant product or develope that ever came from India or China. Nonetheless, industry and ethnic advocates have hoodwinked American politicians and the gullible sheep that we refer to as mainstream media. Industry id not hoodwinked, they want their labor to be cheap, fearful and pliable. H1B's do nothing to advance the interestes of the vast majority of Americans, they only advance the interests of a miniscule minority of ethinic advocates (Indian, Chinese, Latin) and greedy entrepreuners who only care of their own fortune, not yours. Bush did not create this problem, but he has presided over it for 4 years, has done nothing and is inclined to make it worse. Punish Bush at the polls for his contempt of the American worker and his family. These worlds come from a life-long Republican. regards, Tag: Syncing with remote db Tag: 96097
 - 11
 - Datatable's Select and Compute methods I want to use a Datatable's SELECT and COMPUTE methods but I suspect that the app will not scale well if I do. If I have a key defined on a datatable and it is not the PrmaryKey, how do I force the app to use that key when executing a SELECT or COMPUTE method? Tag: Syncing with remote db Tag: 96096
 - 12
 - Design issues with O/R mapping Hi. Im have asked for recommendation regarding the best production ready O/R mapping tools for .net. I got that. Since im an old, ok maybe not old (only 27), Java programmer patterns and developement with tiers is of great importance for me. I have a problem with the famours anti-pattern Tier leakage. In the Java world I used POJO´s (simple java classes) as value objects. These value objects was used for cayrring data between the tiers. So if i changed the persistence tier the rest of the code still relyed in the same POJO´s. Now with the .net O/R they all genereate eg. EmployeeEntity wich inherit from EntityBase2 (LLBL PRO). If I pass the object from my persistence layer to the business layer and down to the view I have just made a seriuos "maintaince bug" the "tier leakage". If i wanna use eg. the EntityBroker im so to say fucked. I have to refactor ALL and EVERY class witch depend on the EmployeEntity. Have anyone thougt about this and come up with an solution? Is the persistence tools wich can map PURE c# classes to realtionel classes as the Java Hibernate? And why have so few chosen this way of doing it? Is it hard to map eg. Customer c = new Customer(); // fill object adapter.SaveEntity(c); And go find what this Customer really maps to int the Database? Anders Jacobsen Tag: Syncing with remote db Tag: 96093
 - 13
 - Where can I find the actual MDAC version installed ? Hi, Where can I find on my computer the version of MDAC that is installed ? tks Ed Tag: Syncing with remote db Tag: 96092
 - 14
 - merge on datasets from join queries I have lookup/record selection grids bound to datasets with lists based on join queries. Periodically, I want to update these datasets to reflect changes made by other users. It seems the dataset.merge on the original dataset with a dataset of the refreshed records just duplicates the records. Although the list is a main table with PK and the other tables in the join query are just lookup values (leaving only one record per PK), the dataset merge does not work. Is this possible or is the only way to "refresh" a dataset based on a joined table to loop through and update each field? Note, I do not want to just re-fill the original dataset as it is bound to a grid and so all the event firing and other binding operations would be more difficult to handle. Thanks. Glenn Tag: Syncing with remote db Tag: 96086
 - 15
 - retrieve values from .mdb Hi, I tried searching the internet but since I'm quite new to VB I can't seem to find a clear anwer to my question: I have a access .mdb database file and I want to use it in my application. I'm using visual studio 2003, so i guess I'm using the framework .Net v1.1 (?) Ho do I connect to a database file called er.mdb (no passwords yet on the db) and retrieve values from a table called "studies". If possible I would like them placed in listbox1. Thanks, Daniel Tag: Syncing with remote db Tag: 96080
 - 16
 - field truncates after 255 chars i am accessing a string value from an access db query that is longer than 255 chars. the problem: the field in the datareader only shows 255 chars. when i run the query in the access query window i get the entire string. the code is pretty simple: ... Dim cmd As New OleDbCommand( "sp_invoiceText", con ) cmd.CommandType = CommandType.StoredProcedure cmd.Parameters.Add( "@traID", value ) ' value is an Integer Dim dr As OleDbDataReader Dim strInvoice As String Try cmd.Connection.Open dr = cmd.ExecuteReader dr.Read strInvoice = dr(0) ... can someone PLEASE tell me how to fix this? Tag: Syncing with remote db Tag: 96071
 - 17
 - DataBoundLiteralControl difficulties when accessing the content of this object ( in this case a date/time string whose length is 20 characters ), the browser displays the corresponding date normally. however, when the fiels is empty it does not display anything. so what's the problem? i am trying to implement a decision structure that will depend on the value of the control: if it exist the do A, and if it is an empty string do B. the problem is that the "empty string" is not at all empty, even though nothing renders! in the course of debugging i found that the length of this "empty string" is 49 characters long, but i cannot see the characters, and have absolutely no idea what they are, how they got there, or what they are doing there. when a value is present (the regular 20-character date/time string), the length of the text is 69 characters. there are obviously 49 characters that are eluding me in any case, but i cannot create a dependable method based on the length without being certain that it will always be constant, and in doing that the first step is seeing the invisible characters. how can i see them? why are they there? can ui strip them away? i tried to trim them, but was unsuccessful. the code: Dim dblc As DataBoundLiteralControl, str As String dblc = CType( e.Item.Cells(6).Controls(0), System.Web.UI.DataBoundLiteralControl ) str = dblc.Text lblFeedback.Text = "Length = " & str.Length & ", Value = " & str ... Tag: Syncing with remote db Tag: 96070
 - 18
 - ADO Problem Hello, Need help with this: I am trying to connect to an existing Access Database via ODBC. My code is like this: It always generates a system error. What am I doing wrong? Any help much appreciated. ----------------------------------------------------------- 'Code in VB.net Dim conn As String = InputBox("Conn string?") Dim sql As String = InputBox("Sql string?") Dim dt As New DataTable Dim co As New Odbc.OdbcConnection(conn) co.Open() Dim dataadapter As New _ System.Data.Odbc.OdbcDataAdapter(sql, co) dataadapter.Fill(dt) dataadapter.Dispose() Me.DataGrid1.DataSource = d -------------------------------------------------------------------------------- Thanks & Regards Mark Tag: Syncing with remote db Tag: 96068
 - 19
 - ADO.NET connection problems Hello, Need help with this: I am trying to connect to an existing Access Database via ODBC. My code is like this: It always generates a system error. What am I doing wrong? Any help much appreciated. ----------------------------------------------------------- 'Code in VB.net Dim conn As String = InputBox("Conn string?") Dim sql As String = InputBox("Sql string?") Dim dt As New DataTable Dim co As New Odbc.OdbcConnection(conn) co.Open() Dim dataadapter As New _ System.Data.Odbc.OdbcDataAdapter(sql, co) dataadapter.Fill(dt) dataadapter.Dispose() Me.DataGrid1.DataSource = d -------------------------------------------------------------------------------- Thanks & Regards Mark Tag: Syncing with remote db Tag: 96067
 - 20
 - grouping data in an asp table control - novice question Hi There, I am using an asp table control to display some data, the fields I have are size,colour,qoh. I have the table structure that I would like to have below and I have been playing around with datasets and looping to write rows / etc I'm just having trouble displaying the data the way I want to. I did have a look at nested datalists, however I don't have the luxury of time at the moment and I would like to use this method as I'm new to asp .net as well. If someone could help me out with the code that would be fantastic, thanks in advance Joey !-- I need to display the data like this <table width="75%" border="1"> <tr> <td width="15%">size / colour</td> <td width="45%">xxs</td> <td width="13%">xs</td> <td width="9%">s </td> <td width="10%">m</td> <td width="8%">l</td> </tr> <tr> <td>blue</td> <td>2</td> <td>10</td> <td>2</td> <td>8</td> <td>9</td> </tr> <tr> <td>green</td> <td>3</td> <td>5</td> <td>4</td> <td>5</td> <td>7</td> </tr> </table> Dim dataArray(,) As String Dim i, j As Integer Dim myconnection As New OleDb.OleDbConnection() myconnection = common.connDB() Dim DS As DataSet = New DataSet() Dim strColourSql As String = SELECT qoh, shopsales.size,shopsales.shop, shopsales.style, shopsales.colour,co.colourdesc,sz.sizedesc FROM shopsales,shops JOIN colours co ON shopsales.colour = co.colour where shopsales.shop=1 and shopsales.style="'10475RIB1'" myconnection.Open() Dim myColourDataAdapter As New OleDb.OleDbDataAdapter(strColourSql, myconnection) myColourDataAdapter.Fill(DS, "shopsales") Dim rowCount As Integer = DS.Tables(0).Rows.Count Dim colCount As Integer = DS.Tables(0).Columns.Count ReDim dataArray(rowCount, colCount) For i = 0 To rowCount - 1 For j = 0 To colCount - 1 If DS.Tables(0).Rows(i).Item(j) Is DBNull.Value Then dataArray(i, j) = "" Else dataArray(i, j) = DS.Tables(0).Rows(i).Item(j) End If Next Next Dim r As TableRow Dim c As TableCell For j = 0 To colCount - 1 r = New TableRow() c = New TableCell() c.Controls.Add(New _ LiteralControl(DS.Tables(0).Columns(j).ColumnName)) c.VerticalAlign = VerticalAlign.Top c.Style("background-color") = "lightblue" r.Cells.Add(c) For i = 0 To rowCount - 1 c = New TableCell() c.Controls.Add(New LiteralControl(dataArray(i, j))) c.VerticalAlign = VerticalAlign.Top r.Cells.Add(c) Next i Table1.Rows.Add(r) Next j Tag: Syncing with remote db Tag: 96066
 - 21
 - Prameter of Decimal Type Change Precision (Bug) Hello everybody, Here is the bug I found after spending half a day debuging. Output parameters of Decimal type change precision after DBNull value is returned, causing inconsistent results of subsequent calls. Something to watch out for. Tomasz repro: using System; using System.Data; using System.Data.SqlClient; using System.Diagnostics; /// <summary> /// This is a repro of the bug found in ADO.Net /// It shows that the output parameter of Decimal type changes its precision /// after DBNull value is returned, causing inconsistent results of subsequent calls. /// </summary> public class ADONetOutputParameterBug { static void Main() { SqlConnection cn = new SqlConnection(); cn.ConnectionString = "data source=(local);Integrated Security=SSPI;"; SqlCommand cm = new SqlCommand("", cn); cn.Open(); SqlParameter pOut = cm.Parameters.Add("@outParam", SqlDbType.Decimal, 9); pOut.Direction = ParameterDirection.Output; pOut.Precision = 19; pOut.Scale = 4; // first call cm.CommandText = "select @outParam = cast(1.5 as decimal(19,4))"; cm.ExecuteNonQuery(); Trace.WriteLine("first call: " + pOut.Value.ToString()); Trace.WriteLine("output parameter scale: " + pOut.Scale); // second call - returns null value cm.CommandText = "select @outParam = null"; cm.ExecuteNonQuery(); // third call - the same command as for the first time cm.CommandText = "select @outParam = cast(1.5 as decimal(19,4))"; cm.ExecuteNonQuery(); Trace.WriteLine("second call: " + pOut.Value.ToString()); Trace.WriteLine("output parameter scale: " + pOut.Scale); } } Tag: Syncing with remote db Tag: 96065
 - 22
 - Login, Connections and Forms Hi, I've cross-posted this from the Windows Forms list ... I suppose the question is actually a ADO.NET questions ... but it is about using this in a Windows Forms context. I'm developing an Windows forms based app that will draw data from a SQL Server 2000 system, that is set to use SQL Authentication (i.e. connection string must pass uname:pword). Given that various forms will need to use a SQL connection to generate data for data grid's etc ... how can I pass this authentication information around the various forms? A solution is to start the application from a VB.NET class, that has a shared member with the connection string (set once the user completes the login) Or create a shared connection object? Should I create a new connection object for each form? I currently test whether the login credentials are correct by enclosing within a try..catch clause an attempt to open and close a connection, failure will indicate invalid details (or perhaps a dead SQL Server!) ... any improvements on this? I assume that when using the form designer in VS.NET that if I manually program the connection (i.e. outside the section of code written by VS.NET ) that I can point the adapters/datasets etc. to the required connection. There are a few questions here ... but I've not so far found any answers here, on Google or elsewhere :( ! Thanks in advance for help Tag: Syncing with remote db Tag: 96059
 - 23
 - Problem in .NetFramework 1.1 SP1 using the DataTable.Select method We detected a problem in .NetFramework 1.1 SP1 using the DataTable.Select method. The orginal filter we were using when we first came across that problem was: "EntityId = 7016 AND Deleted = 0 AND FieldId = 70 AND HistoryStartDate >= #07/01/2004 00:00:00#" Since then we tried almost everything and the results were disapointing: tried to change the date format (we were using InvariantCulture), changed the filter order, isolated each filter expression (we think in our case only the DateTime filter doesn't work). Then I tried some wild and more religious things, like cloning the original table and importing the rows (could be a cursor problem!) and some other stuff you usually try when you have no more ideas. None of them worked. We wrote a C# test harness that is available online at http://pwp.netcabo.pt/0434926301/. The Test Harness is loading data from TestData.XML. We included a doc with print screens of the filters we used and the results we obtained with and without the .Net Framework 1.1 SP1. Please help! Thanks in advance. Tag: Syncing with remote db Tag: 96054
 - 24
 - Two record bufffer and oneway data cursor Hello, I'm in planning phase for porting Report Manager to C sharp. http://reportman.sourceforge.net I need to know the necessary(and optimum) classes to build the data retrieve process of the reporting engine. The engine can't use a simple Fill and work with the full dataset because the result can contain millions of records (speed,memory etc..) Actually it's programmed in Delphi, it uses unidirectional querys, that is a TQuery (I think the most equivalent is IDataProvider) and a modified TClientDataset (I thik the equivalent is Dataset.DataTable) to maintain allways the last two accessed records (needed for data grouping). I'm new to C# and .Net, and any help and comments will be apreciated. Specially methods to access large number of records using little memory and in a fast way. Thanks Tag: Syncing with remote db Tag: 96052
 - 25
 - Question from the ADO.NET Team We are interested in hearing some opinions on a change we've been considering: Currently most classes in ADO.NET such connection, command, datareader, parameters, etc. inherit from MarshalByValueComponent, MarshalByRefObject or Component. This is actually not needed or useful (i.e. you can't actually use most of these through remoting directly) and it adds certain overhead that we'd like to remove. We believe that there is no actual reason for application code to depend on the fact that we inherit from those, but we don't want to make a change unless we're really sure that this is not an issue for existing applications. So the question is: is anyone depending on the fact that we inherit from those classes for your applications? If so, what's the scenario where that happens? Scenarios I can think of: - Do you rely on the fact that connection, command and adapter inherit from component? If so, would it be enough if we implement IComponent instead? - Do you directly expose any of the ADO.NET classes *directly* through remoting? The ADO.NET team would really appreciate your input in this matter. Feel free to either answer to the newsgroups or email me directly. Thanks in advance. btw - what's your opinion on us doing this kind of polls in the newsgroups? -- Pablo Castro Program Manager - ADO.NET Team Microsoft Corp. This posting is provided "AS IS" with no warranties, and confers no rights. Tag: Syncing with remote db Tag: 96043

Hi

We have an access db running on a windows 2003 server. The server is
connected to the internet via ADSL. I would like a windows mobile 2003 based
vb.net app to sync data from the server, ideally via gprs, from time to
time, the pda and the server have the same info. What is a good way to go
about doing the data sync between the pda and the server? Do we have to
upsize the server access db to sql server before it can sync with pda sql
server ce, or can we keep the access app as it is?

Thanks

Regards

Top

RE: Syncing with remote db by NoSpamMgbworld

NoSpamMgbworld
Wed Sep 29 10:09:03 CDT 2004

I would advise moving to MSDE (SQL Server personal) or SQL Server on the
server and then SQL CE on the model device (would have to be PocketPC
device). You can then use the built in capability of sync from SQL Server
(ie, replication).

Otherwise, your best bet is to add a timestamp column to every table in the
database. You can then add newer rows from the PDA and download newer master
rows based on the last time synced. This way, you are not comparing every bit
of data. This may end up with major re-architecture, depending on your app(s).

---

Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************

"John" wrote:

> Hi
>
> We have an access db running on a windows 2003 server. The server is
> connected to the internet via ADSL. I would like a windows mobile 2003 based
> vb.net app to sync data from the server, ideally via gprs, from time to
> time, the pda and the server have the same info. What is a good way to go
> about doing the data sync between the pda and the server? Do we have to
> upsize the server access db to sql server before it can sync with pda sql
> server ce, or can we keep the access app as it is?
>
> Thanks
>
> Regards
>
>
>

Top