DateTime Filter Expression

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
    - Adding new object to Typed Data Set and return the primary key Hi, I have started using Typed Data Sets with VS2005 and so far so good, however I am having a problem with adding a row to a data table and returning the new Primary Key value. My data set has been auto generated from a DB table and has an auto generated Primary Key for the ID field. I create the row using ProjectsDataTable.NewProjectsRow() However the code that returns this Project Row does not persist the data table as it is a method on my singleton object. Once the new row has been populated with data I call an update method on the singleton which then creates a new table adapter. My problem is how to add this orphaned row to the database and return the Primary Key that the database creates for it. I have tried many of the different methods that are created by default in the TypedDataSet however so far the only one that works is the TableAdapter.Insert() method and this does not return the primary key. Method 1: DataAdapter.Update(myProjectRow) // fails I guess because the row has no connected DataTable Method 2: newDataTable = DataAdapter.GetData(); // returns eg a data table containing 4 rows. newDataTable.ImportRow(myRow); // data table still contains 4 rows no error generated. DataAdapter.Update(newDataTable); // does nothing as there is nothing to update Please does anyone have any insight into this or do i have to go back to the good old way of manually executing the SQL or dumping my data singleton and manually creating and persisting the data table for the form that creates the new project ? Another strange thing is that the if i return a project from the singleton (which does not persist the data table) then call the same update method ( on the singleton which creates a new data adapter) the updates are commited. Is something strange with the primary key going on ? Sudo Code Snippet: public class DataObject { private static DataObject this_Data; public static DataObject getInstance() { if (this_Data == null) this_Data = new Data(); return this_Data; } public TypedDataObjectProject newProject() { Projects.ProjectsDataTable db_ProjectsTable; DataLayer.ProjectsTableAdapters.ProjectsTableAdapter db_TableAdapter = new com.acet4data.DataPro.DataLayer.ProjectsTableAdapters.ProjectsTableAdapter(); Projects.ProjectsDataTable db_ProjectsTable2 = db_TableAdapter.GetData(); return db_ProjectsTable2.NewProjectsRow(); } public TypedDataObjectProject getProject() { Projects.ProjectsRow db_Project; DataLayer.ProjectsTableAdapters.ProjectsTableAdapter db_ProjectAdapter = new DataLayer.ProjectsTableAdapters.ProjectsTableAdapter(); Projects.ProjectsDataTable db_ProjectTable2 = db_ProjectAdapter.GetData(); db_ProjectAdapter.Dispose(); return db_ProjectTable2[0]; } public int updateProject(Projects.ProjectsRow Project) { int int_Return = 0; DataLayer.ProjectsTableAdapters.ProjectsTableAdapter db_ProjectAdapter = new com.acet4data.DataPro.DataLayer.ProjectsTableAdapters.ProjectsTableAdapter(); db_ProjectAdapter.Update(Project); db_ProjectAdapter.Dispose(); } } This works: ob_Prog = DataObject.getInstance().getProject(); ob_Prog.Name = "new value"; DataObject.getInstance().updateProject(ob_Prog); This Fails not with error but no new row is added: ob_Prog = DataObject.getInstance().newProject(); ob_Prog.Name = "new value"; DataObject.getInstance().updateProject(ob_Prog); Many thanks in advance for you help. Nic Tag: DateTime Filter Expression Tag: 136616
  - 2
    - Why can't the .NET Datagrid show datetime columns with time ? Hi, I am using .NET Framework 1.1 and VS.NET 2003 I am pulling a recordset from an ORACLE database into a Windows Forms form and displaying the data in a datagrid.. Trouble is, even though the data includes datetime fields, the datagrid absolutely refuses to display them at runtime in proper datetime format (just shows . I know the time information is there because I can export to csv and the time is in each field. I even got some code from Kelly in another thread to force datetime fields to be formatted properly like this: >>> CODE >>> Public Shared Sub Format(ByRef grd As DataGrid, ByRef dt As DataTable) Dim ts As New DataGridTableStyle() Dim tc As DataGridTextBoxColumn Dim dc As DataColumn For Each dc In dt.Columns tc = New DataGridTextBoxColumn() tc.MappingName = dc.ColumnName tc.HeaderText = tc.MappingName If dc.DataType Is GetType(System.DateTime) Then tc.Format = "MM/dd/yyyy hh:mm:ss" tc.Width = 125 End If ts.GridColumnStyles.Add(tc) Next grd.TableStyles.Clear() grd.TableStyles.Add(ts) grd.DataSource = Nothing grd.DataSource = dt <<< END CODE <<< Now, when I run this, several fields are identified as system.datetime and these get the special format. But nothing happens in the datagrid. Is there anything else I can do to show the time with the dates? thanks for any help or assistance Philip Tag: DateTime Filter Expression Tag: 136611
  - 3
    - MSAccess DB and DataSets - help Hi, I have VS.net 2005 express and I have created a new project. I made a new folder and added and existing MS Access DB (Maintenance.mdb). VS.net happily went and created a DataSet class for me (MaintenanceDataSet). My question is: How do I load the data from the Access DB so I can access it from the application? Thank you in advance. Tag: DateTime Filter Expression Tag: 136598
  - 4
    - Unicode and long data type I have an application where a limited amount of Unicode data is being inserted into a long data type field by an AIX program. I have written a dotnet program that copies the data from one domain to another with parameterized data. Everything works except for the Unicode data in the long field. My Characterset info is: NLS_CHARACTERSET US7ASCII NLS_NCHAR_CHARACTERSET AL16UTF16 Regional Settings are English (United States) A basic default U.S. installation of Windows. I do not have much control over the database. I have read that long data types do not support Unicode. Is there anyway I can insert Unicode data into a long data type from a dotnet program? Tag: DateTime Filter Expression Tag: 136595
  - 5
    - dataset question Hi I am a newbie in ado.net 2005. Is it possible to do a Group By in a dataset? thanks E. Tag: DateTime Filter Expression Tag: 136592
  - 6
    - Why can't I get the FormView control's Paging controls to show? I have tried everything I can think of, I have even tried copying examples from books and websites I have found, but every Formview control that I have tried to create does not show the Paging controls. The first record from the DataSource is displayed, but not the Paging controls. I have tried doing it with both automatically generated Paging controls as well as using the PagerTemplate, but neither one is displayed. What is the problem? Thanks. -- Nathan Sokalski njsokalski@hotmail.com http://www.nathansokalski.com/ Tag: DateTime Filter Expression Tag: 136591
  - 7
    - Reader ordinal problem Hi I am getting the System.IndexOutOfRangeException was unhandled error on the last line of below code; Cmd = New OleDb.OleDbCommand("SELECT [Last Staff Update From Site] FROM [Update Control]", LocalConn) Reader = Cmd.ExecuteReader() Console.WriteLine("{0}", Reader.GetOrdinal("[Last Staff Update From Site]")) What is the problem and how can I fix it? Thanks Regards Tag: DateTime Filter Expression Tag: 136588
  - 8
    - 36 Microsoft Certification Tutorials and Free Practice Exams 36 Microsoft Certification Tutorials and Free Practice Exams For complete Microsoft Certifications ebooks go to http://free-tech-ebooks.blogspot.com/search/label/Microsoft%20Certifications All the best !! Tag: DateTime Filter Expression Tag: 136582
  - 9
    - Have alternative to CommandDataBuilder? I realize that Microsoft not intend to fix problems of Commandbuilder: +not deal with SQL calculated fields +not deal with Identity field to retrieve it and also cannot be inherit! there someone wrote Alternative? Tag: DateTime Filter Expression Tag: 136577
  - 10
    - SqlCommand Parameters with SqlDbType and VarChar(MAX) If I have a field in MS SQL 2005 called "data" with type VarChar(MAX), how do I add a parameter using the syntax below if SqlDbType doesn't have a VarChar(MAX) type. If I use SqlDbType.VarChar will the value get truncated or is that what I should use? SqlCommand cmd = new SqlCommand(query, connection); cmd.Parameters.Add("@data", SqlDbType.VarChar).Value = largeTextData; Or am I supposed to use the size parameter? cmd.Parameters.Add("@data", SqlDbType.VarChar, 1000000).Value = largeTextData; Also how many characters does VarChar(MAX) hold? Tag: DateTime Filter Expression Tag: 136575
  - 11
    - Accessing sql server behind proxy Hi My app is running on a windows 2000 server with isa 2000 installed. How can it access an external sql server (using its ip) from within the isa 2000 firewall/proxy via code? Thanks Regards Tag: DateTime Filter Expression Tag: 136573
  - 12
    - HowTo Convert Array to Binary I have an array of an array of doubles and need to save this as a single byte array. Then save this byte array as a BLOB to an SQL 2005 database. Array allocation code shown below: Array myArray = Array.CreateInstance(System.Type.GetType("System.Double[]"), 3); Double[] dblArray1 = new double[4] { 23.56, 24.56, 25.56, 26.56 }; Double[] dblArray2 = new double[4] { 33.56, 34.56, 35.56, 36.56 }; Double[] dblArray3 = new double[4] { 43.56, 44.56, 45.56, 46.56 }; // Place above three double arrays in an myArray myArray.SetValue(dblArray1, 0); myArray.SetValue(dblArray2, 1); myArray.SetValue(dblArray3, 2); I have tried serialize the myArray object however the byte array is almost twice the length of the array of doubles: MemoryStream stream = new MemoryStream(); BinaryFormatter formatter = new BinaryFormatter(); formatter.Serialize(stream, dblArray1); BinaryReader reader = new BinaryReader(stream); reader.BaseStream.Position = 0; byte[] inputBytes = reader.ReadBytes((int)reader.BaseStream.Length); However the byte count of the byte array is almost doubled that of the array of doubles. inputBytes byte count is 175 should of been 96 bytes. Does anyone know a better way to save an Array of an Array of doubles to a byte array? Thanks in advance, Scott Tag: DateTime Filter Expression Tag: 136571
  - 13
    - TransactionScope Questions Hi! I have a couple of questions about TransactionScope... What exactly is the scope of a transaction? Is it only connections that are created in the actual code block where the TransactionScope is defined, or is it all connections created on the same thread as the TransactionScope? What is the performance like using a TransactionScope object for multiple consequetive connections to a single database as compared to using a standard ADO.NET transaction object? I'm guessing it would be slower... but by how much? Thx! Tag: DateTime Filter Expression Tag: 136569
  - 14
    - Add array of rows to datatable Hi, I need to add array of rows to datatable. Have I use for cycle? Because Datatable can add only one row into collection. Thanks. Tag: DateTime Filter Expression Tag: 136564
  - 15
    - SQL Concatenation (||), Query builder in VS 2005 Hi, I need concatenate values of two fields in select command, but if I use this select command in Query builder in VS I get error. I concatenate two string values using SQL concatenation operator (||). It's a bug in Query builder? I think.... Tag: DateTime Filter Expression Tag: 136560
  - 16
    - ExecuteXMLReader I have a Sql2000 Stored Proc. that returns the result in the form of XML. I am calling this SP in my .NET application(webservice) using ADO.net. Can you please suggest me if I should be using the ExecuteReader or ExecureXMLreader method? Also, what are the advantages of using ExecureXMLreader over ExecuteReader In my .NET application, I need to populate the xml returned by SQL SP in a XML document. Thanks. Rajiv Tag: DateTime Filter Expression Tag: 136559
  - 17
    - Firebird Upper function VS.NET 2005 - Firebird 1.5.3 - Firebird.Net data provider I'm trying to add a fill commandText like this to an FBDataTable in the database designer. Select <field list> from CONTACTS where ("UPPER"(NAME) like @Name) The database designer put the quotes around "Upper", not me. And I get this error: ________________________________________ Failed to update CommandText: The schema of data returned by your new command could not be retrieved. Schema of table "CONTACTS" was not changed and might not reflect data retrieved by your command. The database returned the following error: Dynamic SQL Error SQL error code = -804 Function unknown UPPER Can I use "Upper" in the form designer or is there some other way? Rick Tag: DateTime Filter Expression Tag: 136539
  - 18
    - There is no Original data to access when updating a DataTable with computed columns Hi all, this was driving me crazy! I've a datatable its related sqlDataAdapter, if I call the .Update method of the adapter everything is ok, but if I add a compute column to the DataTable (a columns computed via a DataRelation) I receive the "There is no Original data to access" Tag: DateTime Filter Expression Tag: 136536
  - 19
    - How to Insert the date function in asp.net to sql serevr i have 3 dropdown lists.from this dropdown list to { }{day[first dropdown list],month[second dropdown list],year [third dropdown list]. how insert the day,month,year to sql server databse EggHeadCafe.com - .NET Developer Portal of Choice http://www.eggheadcafe.com Tag: DateTime Filter Expression Tag: 136531
  - 20
    - DataTable. Foreign key does not works. Hello to all. I have simple form with DataGrid binded to DataTable. DataTable has foreign key to itself. When I'm deleting one row it's child rows stay in Table. (It deletes only parent row, not child). Here is code: DataTable TestTable = new DataTable("Test"); TestTable.Columns.Add("ID", typeof(Int32)); TestTable.Columns.Add("ParentID", typeof(Int32)); TestTable.Constraints.Add("PARENT_TO_ID", TestTable.Columns["ID"], TestTable.Columns["ParentID"]); DataRow TestRow = TestTable.NewRow(); TestRow["ID"] = 1; TestRow["ParentID"] = DBNull.Value; TestTable.Rows.Add(TestRow); TestRow = TestTable.NewRow(); TestRow["ID"] = 2; TestRow["ParentID"] = 1; TestTable.Rows.Add(TestRow); dataGrid1.DataSource = TestTable; Is it DataTable bug? Thanks in advance! Tag: DateTime Filter Expression Tag: 136530
  - 21
    - best practice for data display VS 2005 designing a WinForm. I have a typical CUSTOMER, ORDERS, ORDERDETAIL database. I want to show these related items on a winform with either textboxes or datagridview controls. If I use the dataset designer to create a strongly-typed DS it will bring into memory ALL the records in each table and then select a subset according to the relations I have set when the user selects a CUSTOMER. Of course, this is completely impractical when you have any quantity of rows in any of the tables since they cannot all be brought into memory. All the examples I see use the above approach for demonstration, but this doesn't seem practical in a real world app. So how do I do this right from the beginning? Do I create queries with a param for the relation between the parent and child table and then respond to a row change event? I'm confused since I don't see any demo apps that use this senario which surely must be quite common. Thanks for any guidance, Rick Tag: DateTime Filter Expression Tag: 136529
  - 22
    - RowChanged event fires after that the current cell is changed Hi all, I've a DataGrid wich DataSource is a DataTable declared with the "WithEvents" clause, I've write some code to handle the RowChanged event. My DataGrid has a boolean column (wich not allows null value) and a TextBox column with some decimal values, I wish that when a user checks the boolean column a TextBox in the form will display the computed sum of the rows "checked". But I have noticed that the RowChanged event fires when I change a row (doh!) but only after I've changed the current cell or after the grid has lost the focus. I want that when I check or uncheck a row, the textbox displayng the computed sum suddenly changes, is there a way to accomplish this? Tag: DateTime Filter Expression Tag: 136527
  - 23
    - MI5 Persecution: what people said (3927) From: aa1gha@zen.sunderland.ac.uk (gillian.hardy) Newsgroups: uk.misc,uk.legal,uk.politics,uk.politics.misc,uk.media Subject: Re: Read About "MI5 Persecution" on the Web! Date: Mon May 13 21:27:26 1996 : In article <Dr5sDI.50x.0.bloor@torfree.net>, bu765@torfree.net wrote: : |> This site is now running brilliantly. It will be updated with new : |> information regarding this case and is well worth including in your : |> bookmark file. For my sins I had a look and it's quite good actually. Nicely set out and presented. Didn't read it though, having read the rants a million times before. By the way, anyone noticed Chris Tarrant looking at you funny during Man O Man yet? Thought not... Gillian ------------------------------- From: franco@elea.demon.co.uk (Francis Devonshire) Newsgroups: uk.misc,uk.legal,uk.politics,uk.politics.misc,uk.media Subject: Re: Read About "MI5 Persecution" on the Web! Reply-To: franco@elea.demon.co.uk Date: Tue May 14 19:17:26 1996 In message <4na2d0$dho@leofric.coventry.ac.uk> Stephen Hopkins wrote: :Yes, I have to be honest: that page is one of the best examples of how to :present a long document on the Web that I've seen. Hopefully, frames will :become more and more prevalent and this style of presentation will become :the norm for long documents such as that. My html thingy doesnt seem to do frames so all I got was a blank page. Then again, maybe someone, somewhere doesn't want me to read it. BTW does 'troll' bring to mind a fishing lure (ie you are American), or an ogre type thing (ie you are European). I much prefer the image of the latter. +--------------------------------------------------------------------------+ | Francis Devonshire Titchfield, Hampshire, United Kingdom | +--------------------------------------------------------------------------+ ------------------------------- Newsgroups: uk.misc,uk.legal,uk.politics.misc,soc.culture.british From: duncan@yc.estec.esa.nl (Duncan Gibson) Subject: Re: MI5 Persecution: Bugging Date: Wed Jun 12 06:46:41 1996 Mike Corley <bu765@torfree.net> wrote: > Read about the MI5 Persecution on the Web Now, whatever you might think about the content, this is a very well designed and presented web page (if you use Netscape to look at it anyway - Mosaic couldn't handle it). This is my article, not my employer's, with my opinions and my disclaimer! -- Duncan Gibson, ESTEC/YCV, Postbus 299, 2200AG Noordwijk, The Netherlands Tel: +31 71 5654013 Fax: +31 71 5656142 Email: duncan@yc.estec.esa.nl 3927 -- Posted via a free Usenet account from http://www.teranews.com Tag: DateTime Filter Expression Tag: 136523
  - 24
    - MI5 Persecution: £20,000 Reward (3057) 20,000 Reward Offered to Expose the Conspiracy I am making a pledge for information directly leading to the exposing of the "BBC Newscaster Conspiracy". The exposing would specifically need to lead to a legally binding admission from Martyn Lewis or Michael Buerk of the BBC they they were watching me through the TV set. I would be happy (delighted, in fact) to pay GBP 20,000 sterling in reward for the above admission. -------------------------------------------------------------------------------- 3057 -- Posted via a free Usenet account from http://www.teranews.com Tag: DateTime Filter Expression Tag: 136522
  - 25
    - dataset fill brings all records? VS 2005 pro. I have a strongly typed dataset which I generate using the designer. From the xsd file I set the relations between the CONTACTS table to the ORDERS table to the ORDERITEMS table. Then I put some DataGridViews on the form and open. In the Load event of the form the Fill methods are used in the three tables. As I step through by line, I can see the CONTACTS (1500 rows) is pretty quick and the ORDERS (55,000 rows) is slower but the ORDERITEMS (5 million + rows) churns on and on until I run out of memory. If I leave out the ORDERITEMS datagridview, the form opens and the parent-child relations are good. It seems like the Fill method is taking ALL the rows from the DB and only displaying the subset I want based on CONTACT. I would have thought that it would only "hit" the DB when it had a record in the CONTACTS table as a parent. Do I have to setup my relations with a parameter to not retreive all rows from the DB, or is this what is happening? Rick Tag: DateTime Filter Expression Tag: 136519
- Next
  - 1
    - Paging controls won't show up when using FormView I have a very simple FormView control, but when I view the page it does not show the Paging controls, although it does show the data. Here is my code: <%@ Page Language="vb" AutoEventWireup="false" CodeBehind="FormViewTest.aspx.vb" Inherits="family.FormViewTest" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server"> </head> <body> <form id="form1" runat="server"> <asp:FormView ID="fviewTesting" runat="server" AllowPaging="true" PagerSettings-Visible="true"> <rowstyle HorizontalAlign="Center"/> <ItemTemplate> <asp:Image ID="imgPhoto" runat="server" BorderWidth="0px" ImageAlign="Middle" ImageUrl='<%# DataBinder.Eval(Container,"DataItem.filename","images/photoalbum/{0}") %>'/><br/> <asp:Label ID="lblPhotoCaption" runat="server" AssociatedControlID="imgPhoto" Text='<%# DataBinder.Eval(Container,"DataItem.caption") %>'/><br/> <asp:Label ID="lblPhotoDate" runat="server" AssociatedControlID="imgPhoto" Text='<%# DataBinder.Eval(Container,"DataItem.photodate","Photo taken on: {0:D}") %>'/> </ItemTemplate> </asp:FormView> </form> </body> </html> Partial Public Class FormViewTest : Inherits System.Web.UI.Page Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Dim photoalbum As New DataTable Dim dataadapterSelect As New System.Data.OleDb.OleDbDataAdapter("SELECT * FROM babyphotos ORDER BY photodate,filename", System.Configuration.ConfigurationManager.AppSettings("connectionstring")) dataadapterSelect.Fill(photoalbum) Me.fviewTesting.DataSource = photoalbum Me.fviewTesting.DataBind() End Sub Private Sub fviewTesting_PageIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles fviewTesting.PageIndexChanged Dim currfile As String = CType(Me.fviewTesting.DataItem, DataRowView)("filename").ToString() Dim photo As System.Drawing.Image = System.Drawing.Image.FromFile(MapPath("images/photoalbum/" & currfile)) CType(Me.fviewTesting.FindControl("imgPhoto"), Image).Width = photo.Width CType(Me.fviewTesting.FindControl("imgPhoto"), Image).Height = photo.Height CType(Me.fviewTesting.FindControl("lblPhotoDate"), Label).Text = CDate(CType(Me.fviewTesting.DataItem, DataRowView)("photodate")).ToLongDateString() End Sub End Class What am I doing wrong? Thanks. -- Nathan Sokalski njsokalski@hotmail.com http://www.nathansokalski.com/ Tag: DateTime Filter Expression Tag: 136513
  - 2
    - More efficient way of getting this aggregate data? Hi all, Our database contains daily data going back for years, which I need aggregated into weekly averages. I came up with the code below to get it, but I don't like it - mostly because hitting the the database with a couple thousand queries feels wrong somehow. Is there a way to somehow send a "bulk query" to the DB through ado.net, and receive the response in a "bulk" package? (No need to tell me about parametrizing the query.) Thanks for any ideas, cdj ================ private void GetWeeklyAverages(DateTime theLastMonday) { DateTime currMon = theLastMonday; DateTime currFri = currMon.AddDays(4); int i=0; int numZeroAvgsInARow = 0; while (i<2000 && numZeroAvgsInARow<10) { string strConn = "user id=ID;password=PASSWORD;data source=SOURCE"; OracleConnection dc_UAT = new OracleConnection(strConn); string avg = "0"; try { dc_UAT.Open(); string oracleTable = "TABLE"; string oracleSelectString = "select round(avg(DATA),5) from " + oracleTable + //variable " where indexid='" + "1" + //variable "' and as_of_date between '" + currMon.ToString("dd-MMM-yyyy") + "' and '" + currFri.ToString("dd-MMM-yyyy") + "'"; OracleCommand cmd = new OracleCommand(oracleSelectString, dc_UAT); avg = cmd.ExecuteScalar().ToString(); } catch(Exception ex) { MessageBox.Show(i.ToString() + ": " + ex.Message, "Error getting average"); } finally { if (dc_UAT != null) { dc_UAT.Close(); } } //Print out info txt_Output.Text += i.ToString() + ": " + currMon.ToString("MM/dd/yy") + " -" + currFri.ToString("MM/dd/yy") + "\t\t" + avg + Environment.NewLine; //Next week back currMon = currMon.AddDays(-7); currFri = currMon.AddDays(4); //Take care of loop vars if (avg == "0") { numZeroAvgsInARow++; } else { numZeroAvgsInARow = 0; } i++; } Tag: DateTime Filter Expression Tag: 136511
  - 3
    - Reading catalog of IBM DB2 hi all, i have a problem with returning all tables included in IBM DB2 database. i'm using OleDbConnection to connect to IBM DB2, aRds As DataTable = CType(aConn, OleDbConnection).GetOleDbSchemaTable(OleDbSchemaGuid.Tables, Nothing) this line returns datatable with no rows, but it's schema is right, and the connection string is right. plz, i need ur help very quickly.. thanx in advance.. Ola Tag: DateTime Filter Expression Tag: 136507
  - 4
    - setup master-detail tables VS.NET 2005 I'm not having an intuative experience trying to get the hang of how to setup a strongly typed master/detail relationshipe between tables. I have two tables CONTACTS with PK=IDNUM and ORDERS with a field CUSTNUM. Both tables have CommandStrings like "Select <field list> from TableName..." (neither has a where clause) In the visual designer for the xsd file I have set a relationship between CONTACTS->IDNUM and ORDERS->CUSTNUM. In a Windows form I have two DataGridView controls, one for each table. When I run the program, the Orders table never follows the Contact table when it scrolls. To me, setting the data relation should have resulted in the child table filtering its results based on the parent, but obviously not. What else do I need to do to get the child table to really be a child? Rick Tag: DateTime Filter Expression Tag: 136506
  - 5
    - Gridview deletion problem I created a form, a datasource (Product table from AdventureWorks) from the Data Sources tab, and dragged the Product table from the Data Source tab to the form's designer surface. This created a dataset, bindingsource, tableadapter and bindingnavigator. I placed the following code in the click event of the delete button on the bindingnavigator: Me.Validate() Me.ProductBindingSource.EndEdit() Me.ProductTableAdapter.Update(Me.AdventureWorksDataSet.Product) When running the app, I select a row and click the delete button on the navigator. It disappears. However, when I exit the app and re-enter, the row is still there. As another test, if I select the row again, and click the delete button, and click it once more, the row is actually deleted from the database. In debug I place a stop after the Validate method above. The underlying dataset shows false for HasChanges after the first click of the delete button and the selected row shows Unchanged for its RowState. However, after the 2nd click of the delete button, the dataset shows true for HasChanges and Deleted for the RowState associated with the row. What is wrong with my code? Thanks Tag: DateTime Filter Expression Tag: 136505
  - 6
    - UpdateRowSource.FirstReturnedRecord not working on .Net 2.0 using System.Data.OracleClient I have a project that has been upgraded from .Net 1.1 to 2.0 and I cannot get the UpdateRowSource.FirstReturnedRecord of the InsertCommand to work correctly using the OracleClient. It works correctly on 1.1 and the DataSet is updated correctly after a DataAdapter.Update, but although the insert happens to the database on 2.0, the DataSet is not updated. The InsertCommand is a PL/SQL stored procedure as follows PROCEDURE insert_orders ( p_b IN INTEGER, p_c IN VARCHAR, p_d IN NUMBER, p_e IN INTEGER, p_f IN INTEGER, p_g IN VARCHAR, p_h IN INTEGER, p_i IN VARCHAR, p_results OUT REF CURSOR) AS v_currentValue NUMBER; BEGIN -- Insert a row to orders table INSERT INTO orders ( b, c, d, e, f, g, h, i) VALUES ( p_b, p_c, p_d, p_e, p_f, p_g, p_h, p_i); -- Get the order_id of the inserted row using the sequence SELECT seq_id.currval INTO v_currentValue FROM dual; -- Get the inserted row as output OPEN p_results FOR SELECT id, b, c, d, e, f, g, h, i FROM orders WHERE id = v_currentValue; END insert_orders; The value of Id is populated during a Pre-Insert Trigger from an Oracle Sequence. Has anyone else encountered this problem? Many thanks Richard Tag: DateTime Filter Expression Tag: 136503
  - 7
    - Insert Command My data adapter will not create the INSERT Statement. It creates the Select, Update, Delete and table mappings though. Why is this? Tag: DateTime Filter Expression Tag: 136493
  - 8
    - DataRowVersion.Original and RowState quesions. I'm fairly new to ado.net, using SQL Server stored procedures, asp.net, and all that entails, so I'm sure I'm missing something simple and fundamental. Hopefully you can point it out to me. Ultimately the problem is I am getting an error: "There is no Original data to access." when trying to execute the following line: if (drCur["Contact", DataRowVersion.Original].ToString() != "") this.sqldaAddSite.UpdateCommand.Parameters["@Original_Contact"].Value = drCur["Contact", DataRowVersion.Original].ToString(); You ask a lot of questions as to why I'm doing this in the first place that I'm not sure I can answer and I'm sure down the road I'll find better methods. Still... The webform that is having this problem is almost identical in logic to one that works just fine. One difference I have noticed is that when I execute these 3 lines: this.sqldaAddSite.SelectCommand.Parameters["@SiteID"].Value = (string) Session["SiteID"]; this.sqldaAddSite.Fill(this.dsAddSite1); drCur = this.dsAddSite1.scs_GetSiteUpdate.Rows[0]; The rowstate of drCur is "Added" while on the webform that works it's "Unchanged". Both are using store procedures for select commands. Can anybody give me clues as to what's going on and what to do about it? Tag: DateTime Filter Expression Tag: 136487
  - 9
    - 29 Books and Tutorials for DotNET, C#, VB.NET and ASP.NET Hi here is a list of 29 Books and Tutorials for DotNET, C#, VB.NET and ASP.NET. Download fast at http://free-tech-ebooks.blogspot.com/ Tag: DateTime Filter Expression Tag: 136485
  - 10
    - Error trying to use Oracle Procedure Hello All I'm trying to use the DBMS_DATAPUMP.OPEN procedure but it keeps failing with this message: 1) Exception Information ********************************************* Exception Type: Oracle.DataAccess.Types.OracleNullValueException Message: Invalid operation on null data Number: -2502 Source: Oracle Data Provider for .NET Data: System.Collections.ListDictionaryInternal TargetSite: Int32 get_Length() HelpLink: NULL StackTrace Information ********************************************* at Oracle.DataAccess.Types.OracleString.get_Length() at Oracle.DataAccess.Client.OracleParameter.GetBindingSize_Char(Int32 idx) at Oracle.DataAccess.Client.OracleParameter.PreBind_Char() at Oracle.DataAccess.Client.OracleParameter.PreBind(OracleConnection conn, IntPtr errCtx, Int32 arraySize) at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery() at DAO.OracleConcreteFactory.ExecuteNonQuery(DAORequest request) in F:\Sunit\CSharpFiles\Scripts\DAO The procedure signature as per Oracle docs is: DBMS_DATAPUMP.OPEN ( operation IN VARCHAR2, mode IN VARCHAR2, remote_link IN VARCHAR2 DEFAULT NULL, job_name IN VARCHAR2 DEFAULT NULL, version IN VARCHAR2 DEFAULT 'COMPATIBLE' compression IN NUMBER DEFAULT KU$_COMPRESS_METADATA) RETURN NUMBER; In code I do this: _conRequest.Command = "DBMS_DATAPUMP.OPEN"; _conRequest.CommandType = CommandType.StoredProcedure; _conRequest.AddParameter("operation",OracleDbType.Varchar2, "EXPORT", ParameterDirection.Input); _conRequest.AddParameter("mode", OracleDbType.Varchar2, "SCHEMA", ParameterDirection.Input); _conRequest.AddParameter("remote_link", OracleDbType.Varchar2, OracleString.Null, ParameterDirection.Input); _conRequest.AddParameter("job_name", OracleDbType.Varchar2, "EXP_TEST", ParameterDirection.Input); _conRequest.AddParameter("version", OracleDbType.Varchar2, "LATEST", ParameterDirection.Input); _conRequest.AddParameter("jobhandle", DBDataType.DBInteger, null, ParameterDirection.ReturnValue); I think it fails when trying to evaluate the remote_link parameter. Any hints are greatly appreciated. Sunit Tag: DateTime Filter Expression Tag: 136469
  - 11
    - OleDbException.ErrorCode lookup The OleDbException.ErrorCode is supposed to be an HRESULT. What scope of errors this HRESULT maps to. I tried: catch (OleDbException ex) { string test = ex.Errors[ex.ErrorCode].Message; } However, ErrorCode is a negative int and the indexer expects an unsigned int, and HRESULTS shouldn't be negative(using the Convert namespace for ToUint32 gives me an exception on trying to convert errorcode). I am getting an error which indicate an object not found, and the named object is a table name referred to in a query. So I'm thinking that this error code applies to all cases where a table does not exist, or it might be broader and apply to other types of failures. In order to make my error message specialized for the error code, I'd like to identify what scenarios it may apply to. My hope was the Errors[errorCode].Message would give me a better idea of the scope of the ErrorCode. So what do I need to do to find out what scenarios would produce this ErrorCode. If I craft an informative error message to display to the user, right now it would read as "Table " + tablename + " does not exist in the database." but if I do this based on errorCode, then I'm afraid the errorCode may be produced in other situations where the error message is not necessarily true. So what would be a good process for manually looking up these error codes? I have the Error lookup utility from VS6 but it doesn't like the negative int values. This particular one is -2147217865 but I would really like to have a process for doing this in the future. I haven't worked much with HRESULTS in previous languages either, so take it easy on me if I sound ignorant. Thank in advance. Tag: DateTime Filter Expression Tag: 136467
  - 12
    - ADO.net Orcas Samples Install Problem I installed the August CTP, after the LINQ Preview. Everything installs correctly. I opened the solution in VS2005 and built it, everything compiled. I mapped a virtual directory to the installation folder of the webapp sample (on my machine - 'C:\Program Files\Microsoft SDKs\ADO.NET vNext CTP\Samples\CSharp\WebAppSample') The first time I try to access the sample it takes a long time, then errors out to this : An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) Source Error: Line 78: using(var con = new System.Data.SqlClient.SqlConnection(sqlb.ConnectionString)) { Line 79: try { Line 80: con.Open(); Line 81: } Line 82: catch(System.Data.SqlClient.SqlException ex) { Source File: c:\Program Files\Microsoft SDKs\ADO.NET vNext CTP\Samples\CSharp\WebAppSample\Global.asax Line: 80 Stack Trace: [SqlException (0x80131904): An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +173 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +199 System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) +345 System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +159 System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +406 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +184 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +193 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +502 System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +27 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +49 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +89 System.Data.SqlClient.SqlConnection.Open() +160 ASP.global_asax.InitSample() in c:\Program Files\Microsoft SDKs\ADO.NET vNext CTP\Samples\CSharp\WebAppSample\Global.asax:80 [Exception: Failed to open an initial database connection. This initial connection is used to attach the sample database to the SQL Server instance if it's being used for the first time. There are two common reasons for this: 1) you do not have a SQL Server default instance (e.g. you're running SQL Server Express or you installed a named instance). To fix this simply update the server name in the connection string (in the web.config file). 2) If you're using SQL Server Express, by default the service runs under the NETWORK SERVICE account which doesn't have permissions to write to the Program Files directory. That might be the cause of this error. To fix the issue, open Windows Explorer, go to the '\Program Files\Microsoft SDKs\ADO.NET vNext CTP\Samples\Data' directory and add NETWORK SERVICE with read-write permissions to it. Actual error message: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)] ASP.global_asax.InitSample() in c:\Program Files\Microsoft SDKs\ADO.NET vNext CTP\Samples\CSharp\WebAppSample\Global.asax:105 ASP.global_asax.Application_Start(Object sender, EventArgs e) in c:\Program Files\Microsoft SDKs\ADO.NET vNext CTP\Samples\CSharp\WebAppSample\Global.asax:12 -------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210 Upon page refresh the error message changes to this : Value cannot be null. Parameter name: connectionString Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.ArgumentNullException: Value cannot be null. Parameter name: connectionString Source Error: Line 32: /// Initialize a new Northwind object. Line 33: /// </summary> Line 34: public Northwind(string connectionString) : Line 35: base(connectionString, "NorthwindLib.Northwind") Line 36: { Source File: c:\Program Files\Microsoft SDKs\ADO.NET vNext CTP\Samples\CSharp\NorthwindLib\obj\Debug\NorthwindLib.Model.cs Line: 34 Stack Trace: [ArgumentNullException: Value cannot be null. Parameter name: connectionString] System.Data.ADP.CheckArgumentNull(T value, String parameterName) +23 System.Data.Objects.ObjectContext.CreateMapConnection(String connectionString, String defaultContainerName) +39 System.Data.Objects.ObjectContext..ctor(String connectionString, String defaultContainerName) +16 NorthwindLib.Northwind..ctor(String connectionString) in c:\Program Files\Microsoft SDKs\ADO.NET vNext CTP\Samples\CSharp\NorthwindLib\obj\Debug\NorthwindLib.Model.cs:34 Products.Page_Load(Object sender, EventArgs e) in c:\Program Files\Microsoft SDKs\ADO.NET vNext CTP\Samples\CSharp\WebAppSample\Products.aspx.cs:24 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +34 System.Web.UI.Control.OnLoad(EventArgs e) +99 System.Web.UI.Control.LoadRecursive() +47 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061 -------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210 It seems the problem is that the connection string isn't being set at all, judging by the second error mentioning it is null. I have SQL server express, do I need to attach the northwind DB to use it, or am I better off with a full SQL Server install. If the latter, do I need to do anything special on install or config to get the Northwind DB from the samples to work? Thanks for the help, looking very forward to playing with the samples. Tag: DateTime Filter Expression Tag: 136466
  - 13
    - Reading a single field from table Hi I need to run a simple select query like below; select field1 from mytable where id = 123 and assign the returned value of field1 to a variable. What is an easy way to do this? Thanks Regards Tag: DateTime Filter Expression Tag: 136459
  - 14
    - Fill-Method changing DBNULL-values to other values Hi, i am writing a small interface to import some data from one database to an other database. unfortunately is the data in the source not very "nice". you have boolean-columns and those boolean-columns have as a default value DBNULL. it wouldn't be a problem if there was one boolean field, i would have a if (table.iscolumnNull()) but i have about 70 boolean fields and only ONE is true all others are false. that means i have many of those ifs already if (table.column1) { } else if (table.column2) the problem is, i don't want to have a structure like this: if (table.column1IsNull()) { if (table.column1){} } else if (table.column2IsNull()) .... I hope you can see where I am going. So I think there must be a possibility to change the DBNULL-values within the fill-method of the table-adapter. something like select case when column1=null then column1=false else column1 endcase from foreigntable i have tried to write such a statement but it didn't work out. If somebody had some hint, that'll be great! Greetings Chris Tag: DateTime Filter Expression Tag: 136456
  - 15
    - Creating Multi-directory Sites Using Multiple Projects In A Solution I have a Visual Studio Solution that contains multiple ASP.NET Projects. I do not want to put all of the pages (*.aspx files) in the root directory of my site, because that would be very disorganized. However, I am having trouble getting any projects other than the one that I place in the root directory to work. What extra steps do I need to take to place a project in a directory other than the root? I am using a webhosting service (hostway.com), so if there are any changes that need to be made on the server I need to know exactly what they are so that I can either request them for my site or make them by logging into my account. If anyone can help me with this or knows of a website that gives good instructions on doing this, I would appreciate it. Thanks. -- Nathan Sokalski njsokalski@hotmail.com http://www.nathansokalski.com/ Tag: DateTime Filter Expression Tag: 136453
  - 16
    - Creating a new dataprovider I'm fairly new to ADO.NET, I've written a couple client/server applications that use the factory pattern in ADO.NET to work with MSSQL and Oracle databases. Beyond that I'm fairly green. My quest is to create a new community opensource project that consists of an ADO.NET dataprovider to communicate with Windows Installer ( .MSI ) databases. Currently you have to P/Invoke to the MSI SDK API's for opening databases, creating fiews, fecting records, accessing records and so on and so on. I'd like to create a framework class that I can share that is very ADO.NET friendly ( as much as applies to the limitd abilities of an MSI database package ). My goal is to create a framework for creating MSI applications/utilities/tools much easier to design and develop. Can anyone reccomend some good reading on how to go about this? I'm guessing that there are a bunch of interfaces to derive from and implement but I thought I'd ask for a point in the right direction instead of spending alot of time in the sand traps. Thanks, Chris Tag: DateTime Filter Expression Tag: 136444
  - 17
    - Timeout problem with SS2K, VS03 I'm working with SS2000 on Server2003, Visual Studio 03 on XP and getting a timeout issue that I cannot identify the source of. The specific message is "General error getting subscriptions" (or other table) "Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached." There's quite a bit of code so rather than try to post the whole lot I'm going to try to describe it, basically when this happens there's multiple classes and forms running (basically it's a form editing a related entity from a main form, each with multiple classes). After editing data in the subclass, the code saves to the database within a transaction, the transaction is committed and the connection is closed cleanly and all appears to be well. Occasionally, however, after editing and saving from the subform I get the above message and once that happens, I cannot seem to connect to the database until I close that copy of the application. What I've tried to figure out so far; initially I believed the error message that the pool max size was reached. This does not appear to be true; the timeout only effects this instance of the application, I can connect with other applications or other instances of the same application with no problem. So unless the pool is something within the scope of the application, the message is incorrect. When I look at sp_who2 for blocking, none shows. When I trace my calls to the server with sql profiler, the queries never reach the server, which (I believe) indicates that it's a problem with the application rather than a server setting. It's almost as if the connection string stops working but we get that from app.config so I don't see how it could change from one call to the next. Similarly, waiting a few minutes and trying the same search again from the application makes no difference. Because the 'timeout' appears indefinite, rather than just a long running query, I don't believe tweaking timout settings will help. The queries take at most a few seconds when it's working, yet once I hit the exception not even the shortest query will run. I tried to reduce the number of connections used, and initially that seemed to help, but not eliminate the error. But the number I'm dealing with is ridiculously small, I pass the connection by reference to the subclasses so I went from using 3 total to using only 2. Searching the web I found that if I have SQL Debugging enabled that would cause the error, sure enough in this project I did have it enabled so I disabled it and thought that I had fixed the problem. But after a day or so the problem cropped up again, and SQL Debugging is still disabled. So everywhere I turn appears to be a blind alley; it's does not appear to be the connection pool, it's definitely not a long running query and it's not a connection or connections being left open that I can see. SQL Debugging is not enabled and I'm running out of places to look for the source of this problem. Has anyone else seen this type of timeout error? If not does anyone have any idea where I can look from here? Thanks for listening; David Craig ABC-Clio. Tag: DateTime Filter Expression Tag: 136443
  - 18
    - Webmethod to save data to SQLServer I have a Webservice written in C# that provides data to both a web browser through ASP.net and to a VC++ client. I have been able to retrieve data from SQLServer and passing to my C++ client as XML without a problem using the SqlDataAdaptor and the DataSet. I am a bit confused how to save data to SQL Server from my client. I figured if I could create a DataSet, I could save it to the database. I wrote a WebMethod that takes a string (the XML) as input, reads that string using an XMLReader, then creates a DataSet from that reader. [WebMethod] public Boolean SaveStaff(string sStaffXML) { XmlReaderSettings settings = new XmlReaderSettings(); settings.ConformanceLevel = ConformanceLevel.Fragment; settings.IgnoreWhitespace = true; settings.IgnoreComments = true; XmlReader reader = XmlReader.Create(sStaffXML, settings); // Create a new DataSet. DataSet staffDataSet = new DataSet("Staff DataSet"); // Read the XML document into the DataSet. staffDataSet.ReadXml(reader); // Close the XmlTextReader reader.Close(); SqlDataAdapter dataAdapter; SqlConnection conn; conn = new SqlConnection("Server =localhost;uid=stmUser;pwd=mypw;database=STMDB"); string cmdString = "SELECT * FROM Staff"; // NOT SURE IF I NEED THIS! dataAdapter = new SqlDataAdapter(cmdString, conn); dataAdapter.Update(staffDataSet); return true; } Is this the right approach? I also wasn't sure exactly how to build the XML string so that I can pass it into the DataReader and then let .NET do its magic. Do I need to use an XSD file? Can I just emulate the XML that .NET passes to the client when it calls a data retrieval method that returns XML with Staff records in it? Are there any good articles about how to do this. most of the stuff out there about using web services use examples of retrieving data, not saving it. Regards, -Rob Tag: DateTime Filter Expression Tag: 136440
  - 19
    - GridView timeout - how to raise it? I have GridView1 attached to a SqlDataSource1 (everything done automatically via VS2005). The problem occurs after launching the page because timeout is risen. The question is how to increase the timeout limit using properties of SqlDataSource1 or GridView1 objects? Best Regards Dariusz Tomon Tag: DateTime Filter Expression Tag: 136438
  - 20
    - TableAdapter.Update not working but no exception thrown Hi I can't figure this one out. I'm using TableAdapters quite successfully with the rest of my app but I have one where the insert just doesn't work when the TableAdapter.Update(TypedDataTable) is called. When I set the break point on the method I can see that it initializes the adapter in the DataSet.Designer.cs file. Can someone suggest how I can work out what's going wrong? I've recreated the table adapter in the xsd wizard page but it's always the same. No exception is thrown but the update method is definitely called and the insert stored procedure works too. The code is ScsDataSet.NotificationEmailsDataTable notifyTbl = new ScsDataSet.NotificationEmailsDataTable(); ScsDataSet.NotificationEmailsRow notifyRow = notifyTbl.NewNotificationEmailsRow(); // account.AccountID retrieved from another TA update notifyRow.AccountID = account.AccountID; notifyRow.CreateDate = DateTime.Now; notifyRow.ModifyDate = DateTime.Now; notifyRow.NotifyType = 0; notifyRow.Email = email.Trim(); notifyRow.IsLogin = true; // row is populated above ok NotificationEmailsTA.Update(notifyTbl); // notifyRow.EmailID == 0 and the record is not inserted if (notifyRow.EmailID == 0) throw new ApplicationException("NotificationEmailsTA not inserting"); Thanks Andrew Tag: DateTime Filter Expression Tag: 136433
  - 21
    - How to get field size from DataSet Hi, I dont know how to get the orginal DB column size from the dataset. Can anyone please show me the code for this? Many thanks Doug. Tag: DateTime Filter Expression Tag: 136426
  - 22
    - Which are valid options for System.Data.DataColumn.DataType? Hello all, I am a bit puzzled about the data type of the type of a System.Data.DataColumn in ADO.NET. When I try to Add a column to a data table, there are 5 overloads and one of them has the following hint: 2 of 5 Add(ColumnName As String, type As System.Type, expression As String) As System.Data.DataColumn type: The System.Data.DataColumn.DataType of the new column. Now I am confused and I am afraid I am missing a major OO concept. I would have hoped for a picklist to choose a System.Type from. Why is this not available? Also, where do I have to look to find out valid options? System.Type seems to be an abstract type. Could any type that inherits from System.Type be passed as the second parameter to Add. If not so, why does ADO.NET ask for a System.Type? Explanations would be appreciated. Tag: DateTime Filter Expression Tag: 136424
  - 23
    - Problem running query in code Hi I am using the below code to run a sql on an underlying access table; insStr = "INSERT INTO [Web Site Action Queue] ( Action, [Client ID], [Operator], Request_Date ) " & _ "VALUES (""Modify Client"", 93, ""Administrator"", Now())" Dim insCmd As New OleDbCommand(insStr, dbConContacts) insCmd.ExecuteNonQuery() I get a 'Syntax error in INSERT INTO statement.' error on the last line. But if I run the same query as below directly in access it works fine. INSERT INTO [Web Site Action Queue] ( Action, [Client ID], [Operator], Request_Date ) VALUES ("Modify Client", 93, "Administrator", Now()) What is the problem and how can I fix it? Thanks Regards Tag: DateTime Filter Expression Tag: 136414
  - 24
    - DataAdapter Fill Method Query Hi All, I have a SQL Server stored procedure that return the results of two select statements e.g. SELECT * FROM first_table SELECT * FROM second_table The first_table has lots and lots of rows, so I only want to return the first 100 from any start point. However, in the second table I want to return all rows. I have used a DataAdapter to fill a dataset, and implemented the overload that allows you supply a DataSet, Start Record, Max Records and Source Table. If I specify a start record and a maximum number of records, will this record criteria apply to the first SELECT, the last SELECT or BOTH? Landers Tag: DateTime Filter Expression Tag: 136413
  - 25
    - Dataset.Merge ..... Accepts changes I am trying to use Dataset.Merge BUT the new dataset has its state according to the source dataset. I would like that state in the new dataset is amended or added according to if it is amended or added in the new dataset!!! Evan Tag: DateTime Filter Expression Tag: 136411

Hi, is there anyway of selecting rows with a particular date but ignoring
the time within a date time column?

something like...
DataTable.Select("DateTimeColumn".Date = '28/12/06')

?

thanks in advance for any advice.

Sharat Koya

Top

Re: DateTime Filter Expression by sdfsdfds

sdfsdfds
Mon Jan 22 07:44:26 CST 2007

I did think that I could select a date between "27/12/06 23:59:59" and

"28/12/06 23:59:59".

Or could this work as a neater solution and does it depend upon culture?

DataTable.Select("DateTimeColumn.Date = #28/12/06#") ??

"sdfsdfds" <sdfsdsdf@sddfs.com> wrote in message
news:ucgqAhiPHHA.3944@TK2MSFTNGP06.phx.gbl...
> Hi, is there anyway of selecting rows with a particular date but ignoring
> the time within a date time column?
>
> something like...
> DataTable.Select("DateTimeColumn".Date = '28/12/06')
>
> ?
>
> thanks in advance for any advice.
>
> Sharat Koya
>

Top