Data Grid View And Database

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Winforms
- 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
    - ClickOnce project with App_Data subfolder Hi, We have a big .NET 2.0 Windows Application (WinForm) project which has an App_Data subfolder in it. Now we want to deploy that WinForm app using ClickOnce with Web deployment strategy. Our problem is once the project is published on the Web server, there is no way the App_Data can be accessed by ClickOnce because ASP.NET 2.0 prevents all access to App_* directories. So when we click on the "Install" button of ClickOnce, it always fails with a message like "Could not download http://<server_name>/.../App_Data/... This is a big problem to us because this application has the "App_Data" directory hard-coded at many places (poor implementation :-(). Could you please help to advise us if there is any way to work around this issue? Thank you very much for your help. Regards, Nhu Tag: Data Grid View And Database Tag: 98255
  - 2
    - Restricted User running Windows App accessing "ProgramFiles" folde Hello, We have a windows application which needs to update the files through the autoupgrade process on start. Application is installed under "Program Files" directory. Now when a restricted user runs the application, the update of the files fails as Restricted user doesn't have access to "Program Files" folder. First of all if anyone has had similar problems, any suggestions, pointers to overcome the restricted user access to programFile folder issue??? We thought of a solution to create a windows service to be installed by the administrator which will be running all the time and which does the upgrade of the files upon notification from the application through a custom command. But same problem persists for the restricted user running the application. Inspite of windows service running as an administrator it cannot create or update files under "ProgramFiles" folder because the restricted user is logged in. Any help will be highly appreciated. Regards Vinay Kant Tag: Data Grid View And Database Tag: 98254
  - 3
    - accept button in user control Hi, I'm trying to assign a default button to the text box in my user control, so some action is done on enter key press. Only solution I can imagine is to filter keydown event. Thaks for ideas. Tag: Data Grid View And Database Tag: 98253
  - 4
    - .net help on windows xp I have an application that was written in C# and works fine on windows 2000. We have started to upgrade our software to windows XP Pro and the application no longer works. The error I get is "Application has generated an exception that could not be handled" "Process id=0xffc (4092), Thread id=0xff0 (4080)". Does anyone know why this thing would not run now? Tag: Data Grid View And Database Tag: 98249
  - 5
    - Databinding on DataGridBoolColumn I'm newbie on winform and datagrid I have a DataGrid with a DataGridBoolColumn. The DataGrid is binded to a DataTable. The DataTable is the resultset of SQL query "SELECT UserName, Enabled FROM siteuser" and the Enabled field is a integer type that 1 means enabled while non-1 means disabled. I want the DataGridBoolColumn is checked if the Enabled is 1 while keep unchecked if it's not. How can I do that? Here is my snippet: DataGridTableStyle tableStyle = new DataGridTableStyle(); tableStyle.MappingName = "Siteuser"; DataGridTextBoxColumn textColumn = new DataGridTextBoxColumn(); textColumn.MappingName = "UserName"; textColumn.HeaderText = "User Name"; tableStyle.GridColumnStyles.Add(textColumn); DataGridBoolColumn boolColumn = new DataGridBoolColumn(); boolColumn.MappingName = "Enabled"; boolColumn.HeaderText = "Enabled"; boolColumn.AllowNull = false; tableStyle.GridColumnStyles.Add(boolColumn); this.dataGrid1.TableStyles.Add(tableStyle); this.dataGrid1.DataSource = dataTable; Tag: Data Grid View And Database Tag: 98247
  - 6
    - What aspx stands for? Hi, asp means Active Server Pages what does aspx stands for ? Regards Micheal Tag: Data Grid View And Database Tag: 98244
  - 7
    - Embedded .NET Control and Unmanaged Code Delay I have a .NET application running in the sandbox (itâ??s an embedded .NET control in a web page). When it tries to access an unmanaged DLL or ActiveX control for the first time there is a long (2 minute) delay. During the delay the CPU is essentially idle. After the initial delay we are able to use the DLL as expected. The web page is in a zone that has full trust. Thanks, Brad Tag: Data Grid View And Database Tag: 98242
  - 8
    - Listview SelectedIndexChange How would you prevent duplicate firing when changing from 3 selected items to 1? I am going to try use another event... Tag: Data Grid View And Database Tag: 98241
  - 9
    - FileNotFound Exception for OnHover after FileOpen.ShowDialog Hi, I have a program that has a row of buttons that use MouseEnter/MouseLeave to change between two different colored images. I also have other images that I pull from the filing system. Since I have several thousands pictures of product, putting the images in an ImageList is out of the question as that would make the EXE file insanely huge and eat up tons of resources. My problem is I am trying to avoid having to type the full path of the images (C:\Program Files\etc) so that no matter where a user installs the program, and no matter the drive letter/name, it will work correctly. Everything works fine until I open the Save or Open Dialog box, and then when an image is pulled from the file system it throws up a 'File Not Found Exception'. Code: private void btnSave_Click(object sender, EventArgs e) { fileSave.ShowDialog(); } private void btnSave_MouseEnter(object sender, EventArgs e) { btnSave.Image = System.Drawing.Image.FromFile(@"Images\Main\save- oj.jpg"); } private void btnSave_MouseLeave(object sender, EventArgs e) { btnSave.Image = System.Drawing.Image.FromFile(@"Images\Main\save- blu.jpg"); } Any idea on how I can get around this problem? -- Message posted via http://www.dotnetmonster.com Tag: Data Grid View And Database Tag: 98239
  - 10
    - MDI w/ Form Maximized - all Child windows repaint - looks sloppy Hi All, I am using Windows Forms (C#.NET) in MDI mode. My 'View' is set to 'Maximized', but when I switch from Form-to-Form I am seeing all of the other Forms repainting (as non-maximized windows), and it looks very sloppy. Right now I am just doing BringToFront( ) on a Form that already exists (maybe this is why everything repaints like it does?). All I want to do is show the Form 'Maximized', and not have any of the other Forms repaint. Is there a way I can do this? SteveH Tag: Data Grid View And Database Tag: 98231
  - 11
    - Problem with images in ListView Anyone knows how to add images to any given location in a ListView? Consider the example code given under the ListView class in the MSDN library (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemwindowsformslistviewclasstopic.asp). The code generates a ListView with 4 colums and 3 rows (in additon to the column heading) . At the end of the code example a bitmap image is added to the cell elements in the first colums by using the .Images.Add() method (ref cited code at the bottom of my reply). My question is: How can the bitmap images be added to the ListView elements other than in the first column, that is, where the example code displays the integers 2,3,5,6,8 and 9? ================================== private void CreateMyListView() { // Create a new ListView control. ListView listView1 = new ListView(); listView1.Bounds = new Rectangle(new Point(10,10), new Size(300,200)); // Set the view to show details. listView1.View = View.Details; // Allow the user to edit item text. listView1.LabelEdit = true; // Allow the user to rearrange columns. listView1.AllowColumnReorder = true; // Display check boxes. listView1.CheckBoxes = true; // Select the item and subitems when selection is made. listView1.FullRowSelect = true; // Display grid lines. listView1.GridLines = true; // Sort the items in the list in ascending order. listView1.Sorting = SortOrder.Ascending; // Create three items and three sets of subitems for each item. ListViewItem item1 = new ListViewItem("item1",0); // Place a check mark next to the item. item1.Checked = true; item1.SubItems.Add("1"); item1.SubItems.Add("2"); item1.SubItems.Add("3"); ListViewItem item2 = new ListViewItem("item2",1); item2.SubItems.Add("4"); item2.SubItems.Add("5"); item2.SubItems.Add("6"); ListViewItem item3 = new ListViewItem("item3",0); // Place a check mark next to the item. item3.Checked = true; item3.SubItems.Add("7"); item3.SubItems.Add("8"); item3.SubItems.Add("9"); // Create columns for the items and subitems. listView1.Columns.Add("Item Column", -2, HorizontalAlignment.Left); listView1.Columns.Add("Column 2", -2, HorizontalAlignment.Left); listView1.Columns.Add("Column 3", -2, HorizontalAlignment.Left); listView1.Columns.Add("Column 4", -2, HorizontalAlignment.Center); //Add the items to the ListView. listView1.Items.AddRange(new ListViewItem[]{item1,item2,item3}); // Create two ImageList objects. ImageList imageListSmall = new ImageList(); ImageList imageListLarge = new ImageList(); // Initialize the ImageList objects with bitmaps. imageListSmall.Images.Add(Bitmap.FromFile("C:\\MySmallImage1.bmp")); imageListSmall.Images.Add(Bitmap.FromFile("C:\\MySmallImage2.bmp")); imageListLarge.Images.Add(Bitmap.FromFile("C:\\MyLargeImage1.bmp")); imageListLarge.Images.Add(Bitmap.FromFile("C:\\MyLargeImage2.bmp")); //Assign the ImageList objects to the ListView. listView1.LargeImageList = imageListLarge; listView1.SmallImageList = imageListSmall; // Add the ListView to the control collection. this.Controls.Add(listView1); } ====================================== PS This question was previously posted as "Cannot add bitmap to ListView other than in first column" in microsoft.public.dotnet.languages.csharp, however due to missing replies I'm hoping someone here can give me an answer. Tag: Data Grid View And Database Tag: 98230
  - 12
    - How can I determine when scroll bars become visible for a form? I have an MDIParent window. And I can`t catch the moment when scroll bars become visibe. this.VScroll and this.HScroll are always return false. Thanks in adv Serg. Tag: Data Grid View And Database Tag: 98229
  - 13
    - Drag and Drop Image from IE Hi, Does anyone know how to drag and drop an Image from IE onto a control? I have been looking at it appears to work two-fold. 1 - An image without a link comes across as a link to the images in IE's cache (FileDrop); 2 - An image with a link comes across as an OLE object with data available in the follow formats: UntrustedDragDrop FileGroupDescriptor FileGroupDescriptorW FileContents UniformResourceLocator Does anyone know how to get either the image's location or data into a usable form when the D&D is the OLE object? Many thanks, James Kent Tag: Data Grid View And Database Tag: 98225
  - 14
    - What does the KeyPressEventsArgs handle property do? I am trying to understand exactly what the handle property of the KeyPressEventsArgs does. I thought I could set it to false to prevent a key from being included into a textbox. For example, if I wanted only numbers in my textbox and the user pressed an alpha character key, then I would set the handle property to false and it would be as if the KeyPress event never occurred thus negating the keystroke. However, what I am seeing is the pressed key still ends up in my textbox. I read on MSDN that if the handle is set to false, the operating system uses a default process to handle the event which is what I figure is putting the keystroke into the textbox. Is this true or am I misreading what happens? If it is true, what does setting the handle property to false actually do? -Thanks Tag: Data Grid View And Database Tag: 98221
  - 15
    - Kind of event overriding I have an object that works with an external treeview (myObject.TreeView = formTreeView) On myObject.TreeView = formTreeView assigment an AftreSelect event is being attached inside the object code. The problem is that formTreeView may have its AfterSelect event that will be executed before myObject AtferSelect when I want it to be executed after. But how to do it? MH Tag: Data Grid View And Database Tag: 98216
  - 16
    - Permit Single Instance of Form What is a generally accepted method used to ensure that one instance, at most, of a form can be opened? Thanks Tag: Data Grid View And Database Tag: 98211
  - 17
    - Determine running from IDE Hi, I would like to write a line of code which will get used in several debugging points, to look like this.. If app.Mode = IDE then Stop Else End Or if Stopped ended an EXE mode that would be good. Application.StartupPath? Tag: Data Grid View And Database Tag: 98209
  - 18
    - Making my winform appear smoothly I have a winform containing a TabControl with multiple TabPages. Each TabPage in turn contains several controls (Labels, TextBoxes ...). Now, when I load my form or switch TabPages, the controls within the form do not appear in a smooth manner, i.e, I see the outlines of the controls first for a fraction of a second and then the form is drawn completely. Is there a way to correct this - to make my form and its controls appear simultaneously? Thanks. Tag: Data Grid View And Database Tag: 98208
  - 19
    - Editable Datagridview and dataset Hi, I am using typed dataset to bind to a datagrid. Data set have Id,Name,Date,UserID ,UserName columns. Id is Primary key and UserID is foreign key, so I am not showing it to user. The datagridview has Allow new ,allow delete properties enabled, so that User can enter values in it. I have column autogenerate property false and added ID,Name,UserName columns added at design time. Now question is, when I add a new row in datagridview, after entering value for Name column, when i hit Enter Key, it shows me error that UserID can not be null. Could some one give me idea how to populate UserID value if its not displayed on the datagrid. My goal is to use typed dataset to update data in database using data adaptor. Please guide me how to solve above problem. If the question is confusing, please let me know, I will try to explain further. Thanks in advance. Hiten Tag: Data Grid View And Database Tag: 98201
  - 20
    - Dialog and variables Hello, I am looking for some infomation about dialogs and passing / sharring variables best practices. Q1 - What is the best way to pass variables to a dialog form from a main form? Constructor, properties? Q2 - What is the best way to pass the updated variables back to the main form? Properties, Events? Q3 - What is the best way to the main form to be notified when the dialog has its close / save button clicked? ShowDialog, Trigger an event, and have the main form read the public properties and close the dialog? Also any references to docs would be a big help. Thanks, Shawn Tag: Data Grid View And Database Tag: 98200
  - 21
    - Able To Have Generic User Controls in .net 2.0? / Winforms and Generics Hey All, I'm wondering if I'm able to have create generic user controls in .net 2.0 much like one can create generic classes. I would like to do this so that I can handle a set a types derived from the same base type within a user control Consider the following scenario: * I create a base user control that contains a generic <ItemType>. * Note: there exists a where clause referencing a specific base type (see code below). * Displays info associated to base class via specific methods. * I derive another user control from this base control with a concrete type * Derived control now displays info associated with the concrete type. Please let me know the following: * If this is possible * If you have done this, what caveats exist * Point me to any online references about the topic Cheers, peter Code ============================= == BASE USER CONTROL == namespace GenericWinformTest { public partial class UserControl1<ItemType> : UserControl where ItemType : Animal, new() { internal Animal itype; public UserControl1() { InitializeComponent(); itype = new ItemType(); } private void talk_Click(object sender, EventArgs e) { this.textBox1.Text = itype.talk(); //talk } }//end class }//end namespace == Derived user control == namespace GenericWinformTest { public partial class dog : UserControl1<type.Dog> { public dog() { InitializeComponent(); } }//end class }//end namespace Tag: Data Grid View And Database Tag: 98199
  - 22
    - My.Settings fails in MyApplication_Startup sub (VB.NET 2005) Hi, I am building an application where I use a splash screen when loading the application and I have a setting in My.Settings to control if the splash screen should be shown or not. My problem is that when I try to check this setting in MyApplication_startup sub it seams like the settings are not loaded or something because the setting is set to True but when it reads it from the startup sub its False. Any clue? / Mikael VB.NET 2005 Tag: Data Grid View And Database Tag: 98198
  - 23
    - Making a menu disappear upon a toolstriptextbox keypress event? Suppose I have a main menu on my form. after clicking a few menu items with sub menus, you eventually come across a toolstriptextbox. You enter an id number and press the enter button. The keypress event of the toolstriptextbox verifies that enter was pressed, and loads data onto the form based on the id you entered. This all works well aside from one problem... the expanded menu, from the main menu, to the sub menus, to the textbox, are all still on the screen. How can I make the menu collapse or dissappear? Thanks, Mike Tag: Data Grid View And Database Tag: 98195
  - 24
    - Why does my datagrid only show from the first tab? I have a page with a DataGridView on a tab control. When that tab is the first tab in the collection, the DataGridView shows up correctly when I bind to my data. However, if I move that tab to not be the first one, the DataGridView never shows up. Moving the tab back results in everything being ok again. I do not understand why this is. Can someone please help me? Thanks. Tag: Data Grid View And Database Tag: 98193
  - 25
    - Making Dates with .NET .NET / Making Dates As with any other .NET data structure, you have to create an instance of the DateTime value type before you can use it. DateTime has seven different constructors, although three of them are just duplicates of some others with an extra parameter (a Calendar parameter used for globalization). So really there are only four constructors. Those constructors allow you to initialize a DateTime structure: =B7 To a 64-bit integer value representing a number of ticks =B7 To a specified year, month, and day =B7 To a specified year, month, day, hour, minute, and second =B7 To a specified year, month, day, hour, minute, second, and millisecond For example, this code initializes a DateTime to October 27, 1961 at 8:47 am: C# DateTime MyDate =3D new DateTime(1961, 10, 27, 08, 47, 00); VisualBasic Dim MyDate as DateTime =3D new DateTime(1961, 10, 27, 08, 47, 00) .NET Parsing Dates DateTime has two static methods that will parse a string to create a DateTime value. DateTime.Parse attempts to parse a valid date and time out of the string that's passed to it. The string must contain the representation of a date and time in one of the formats described in the DateTimeFormatInfo object that is initialized for the current culture. DateTimeFormatInfo contains information about different date formats like month/year, short and long date/time patterns, weekday and month name abbreviations, and other things that describe the myriad ways that dates and times can be formatted. Parse tries very hard to make sense of the string that's passed to it in order to create a valid DateTime value. It ignores leading and trailing white space, and unrecognized characters if possible, and it fills in missing information with the corresponding current date and time values. Parse will throw a FormatException, though, if it's unable to decipher the string you send to it. Overloaded versions of DateTime.Parse let you specify an object that implements the IFormatProvider provider to describe the expected date format. The other static method that parses strings to make DateTime values is called ParseExact. For this method to succeed, the string that you pass to it must exactly match the format that you specify in the IFormatProvider parameter. The program below illustrates how to use the Parse and ParseExact methods to read dates and times. C# public static void Main() { DateTime MyDate =3D new DateTime(1961, 10, 27, 08, 47, 00); Console.WriteLine(MyDate.ToString()); DateTime NewDate; NewDate =3D DateTime.Parse("10/27/61 08:47"); Console.WriteLine(NewDate.ToString()); NewDate =3D DateTime.Parse("10/1961"); Console.WriteLine(NewDate.ToString()); NewDate =3D DateTime.Parse("27 October 1961 8:47 pm"); Console.WriteLine(NewDate.ToString()); IFormatProvider format =3D new System.Globalization.CultureInfo("fr-FR", true); string[] expectedFormats =3D {"g", "G", "f", "F"}; // This is DD/MM/YYYY format NewDate =3D DateTime.ParseExact( "27/10/1961 08:47:00", expectedFormats, format, System.Globalization.DateTimeStyles.AllowWhiteSpaces); Console.WriteLine("Parsed DD/MM/YY: {0}", NewDate.ToString()); try { NewDate =3D DateTime.ParseExact( "10/27/1961", expectedFormats, format, System.Globalization.DateTimeStyles.AllowWhiteSpaces); Console.WriteLine(NewDate.ToString()); } catch (Exception e) { Console.WriteLine(e.Message); } } VisualBasic Public Shared Sub Main Dim MyDate as DateTime =3D new DateTime(1961, 10, 27, 08, 47, 00) Console.WriteLine(MyDate.ToString()) Dim NewDate as DateTime NewDate =3D DateTime.Parse("10/27/61 08:47") Console.WriteLine(NewDate.ToString()) NewDate =3D DateTime.Parse("10/1961") Console.WriteLine(NewDate.ToString()) NewDate =3D DateTime.Parse("27 October 1961 8:47 pm") Console.WriteLine(NewDate.ToString()) Dim format as IFormatProvider =3D _ new System.Globalization.CultureInfo("fr-FR", true) Dim expectedFormats as String() =3D {"g", "G", "f", "F"} ' This is DD/MM/YYYY format NewDate =3D DateTime.ParseExact( _ "27/10/1961 08:47:00", _ expectedFormats, _ format, _ System.Globalization.DateTimeStyles.AllowWhiteSpaces) Console.WriteLine("Parsed DD/MM/YY: {0}", NewDate.ToString()) Try NewDate =3D DateTime.ParseExact( _ "10/27/1961", _ expectedFormats, _ format, _ System.Globalization.DateTimeStyles.AllowWhiteSpaces) Console.WriteLine(NewDate.ToString()) Catch e as Exception Console.WriteLine(e.Message) End Try End Sub The only real tricky part here is the string array passed as the second parameter to ParseExact. This array specifies the formats that the method should try to match when parsing the string. In the code above, I used the general formats (short date with short or long time), and full formats (long date with short or long time). If the string to be parsed doesn't match one of those formats, then ParseExact throws a FormatException exception. See the official documentation for the DateTimeFormatInfo class for a complete list of format characters and patterns. .NET Date Calculations Last updated Jun 16, 2005. The DateTime value type has methods and properties that let you mangle dates in many fun and interesting ways. Properties such as Date, DayOfWeek, Hour, and Ticks let you get information about specific attributes of the DateTime value. All of the properties, by the way, are read only. There is no way to set the Month property on a DateTime value. There are methods that let you add years, months, days, hours, minutes, seconds, and milliseconds to dates; and methods that will convert DateTime values to other date formats like a Windows FileTime or an OLE Automation date. See the official documentation for full information on those methods. DateTime also provides overloads for the comparison operators so you can write things like: if (yourBirthDate < myBirthDate) Console.WriteLine("You're older than I am"); If you're writing in Visual Basic, of course, you don't have access to the overloaded operators so you'd need to use the Compare or CompareTo method, like this: If yourBirthDate.CompareTo(myBirthDate) < 0 Then Console.WriteLine("You're older than I am") End If The overloaded subtraction operator lets you subtract one date from another to obtain the difference in time between the two dates. The returned value is expressed in a TimeSpan: a number of ticks (100 nanosecond time periods). TimeSpan is really just a number that knows how to express itself in terms of days, hours, minutes, seconds, and milliseconds. TimeSpan properties provide you with a way to get the value expressed in these terms (whole days, minutes, and so on), and methods let you initialize a TimeSpan structure from these values. The overloaded TimeSpan constructor lets you initialize a structure with a given number of days, hours, minutes, seconds, and milliseconds. The largest time unit that TimeSpan "knows" about is the day. It's impossible to convert a TimeSpan value to months, for example, because months have differing numbers of days. The same is true for years. So, if you call TimeSpan.ToString to output a value, it will be expressed in days, hours, minutes, seconds, and milliseconds. TimeSpan has two types of properties: those that return whole values, and those that return fractional values. The Days property, for example, gets the number of whole days represented by a TimeSpan value. By contrast, the TotalDays property gets the value expressed as whole and fractional days. So if you have a TimeSpan that represents 25 hours, the value of the Days property would be 1, and the value of the TotalDays property would be 1.04167 (that is, 1 and 1/24 days). There are similar properties for hours, minutes, seconds, and milliseconds. Of course, since TimeSpan is "just a number," you can use the standard comparison operators to see which of two values is larger or smaller, and you can use the standard operators to add and subtract TimeSpan values. TimeSpan, though, is not terribly useful all by itself. It's really intended to be used in conjunction with DateTime values. The difference between two dates, as pointed out above, is expressed in a TimeSpan. This code subtracts one date from another to get the time elapsed between them. C# DateTime BirthDate =3D new DateTime(1961, 10, 27, 08, 47, 00); DateTime Today =3D DateTime.Now; TimeSpan Age =3D Today - BirthDate; VisualBasic Dim BirthDate as DateTime =3D new DateTime(1961, 10, 27, 08, 47, 00) Dim Today as DateTime =3D DateTime.Now Dim Age as TimeSpan =3D Today.Subtract(BirthDate) You should note that in the second line of code I got the current date and time by accessing the static DateTime.Now property. If you initialize the BirthDate variable in the code above with your own birth date, then the Age variable will represent your current age. If you then want to see what the date will be when you're twice as old as you are right now, you simply add the calculated Age value to Today, like this: C# DateTime ALongTimeFromNow =3D Today + Age; Console.WriteLine(ALongTimeFromNow.ToString()); VisualBasic Dim ALongTimeFromNow as DateTime =3D Today.Add(Age) Console.WriteLine(ALongTimeFromNow.ToString()) .NET Official Documentation Last updated Jun 16, 2005. The DateTime and TimeSpan topics in the MSDN .NET Reference fully describe the methods and properties of these objects, and give some very good examples of using them in typical situations. If you need to work with other calendars or multiple cultures, be sure to check the references for Calendar, DateTimeStyles, and DateTimeFormatInfo in the System.Globalization namespace. http://www.imc.org/rfc2822 .NET Properties Last updated Jul 27, 2005. I had originally planned to duplicate all of the DateTime properties and methods in W3CDateTime. As I got into it, though, I started thinking that I was needlessly duplicating a lot of effort. This is something of a judgement call, I'll admit. However, it seemed silly to implement the Hour property when I could just as easily call get the Hour property on W3CDateTime.DateTime. That is, these two calls would be identical: hour =3D myDate.Hour; hour =3D myDate.DateTime.Hour; In most cases, I avoided duplicating effort. The result is that I only implemented a handful of properties for W3CDateTime, all of them static. The properties that I implemented are: LocalUtcOffset returns the offset between the local time (on the computer that's running the program) and UTC time. MaxValue returns a W3CDateTime that represents the maximum value that can be represented. This value is expressed in UTC time. MinValue returns a W3CDateTime that represents the minimum value that can be represented. This value is expressed in UTC time. Now returns the current local time, expressed in the local time zone. Today returns the current date, expressed in the local time zone. The time portion is set to 00:00:00. UtcNow returns the current time, expressed in UTC time. All of these are static properties. With the exception LocalUtcOffset, all of these properties are duplicates of properties implemented by System.DateTime. The duplication seemed reasonable in these cases. New Methods I needed the ability to do comparisons on W3CDateTime values, and also to add days, months, years, etc. I also needed to subtract two dates to determine the number of days or hours between them. System.DateTime implements all of this functionality, of course, but it becomes difficult to use. For example, if I wanted to add days to a W3CDateTime to get another value, I would have to write: myDateTime =3D new W3CDateTime(myDateTime.DateTime.AddDays(5), myDateTime.UtcOffset); By creating an AddDays method, I'm now able to write: myDateTime =3D myDateTime.AddDays(5); Subtracting two dates was a little trickier in that I had to be sure to use the UtcTime property. Otherwise, subtracting dates from two different time zones would produce erroneous results. For those reasons, I implemented the AddYears, AddHours, and similar methods, as well as both overloads of the Subtract method that are supported by System.DateTime. For comparisons, I implemented a static Compare method as well as the IComparable.CompareTo method. For equality testing, I implemented Equals and GetHashCode as outlined in the SDK article Implementing the Equals Method. Finally, I implemented two conversion methods: ToLocalTime and ToUniversalTime. These are similar to the methods implemented by System.DateTime, except that I added an overload that will convert the value to any given timezone offset. Tag: Data Grid View And Database Tag: 98188
- Next
  - 1
    - Making Dates with .NET .NET / Making Dates As with any other .NET data structure, you have to create an instance of the DateTime value type before you can use it. DateTime has seven different constructors, although three of them are just duplicates of some others with an extra parameter (a Calendar parameter used for globalization). So really there are only four constructors. Those constructors allow you to initialize a DateTime structure: =B7 To a 64-bit integer value representing a number of ticks =B7 To a specified year, month, and day =B7 To a specified year, month, day, hour, minute, and second =B7 To a specified year, month, day, hour, minute, second, and millisecond For example, this code initializes a DateTime to October 27, 1961 at 8:47 am: C# DateTime MyDate =3D new DateTime(1961, 10, 27, 08, 47, 00); VisualBasic Dim MyDate as DateTime =3D new DateTime(1961, 10, 27, 08, 47, 00) .NET Parsing Dates DateTime has two static methods that will parse a string to create a DateTime value. DateTime.Parse attempts to parse a valid date and time out of the string that's passed to it. The string must contain the representation of a date and time in one of the formats described in the DateTimeFormatInfo object that is initialized for the current culture. DateTimeFormatInfo contains information about different date formats like month/year, short and long date/time patterns, weekday and month name abbreviations, and other things that describe the myriad ways that dates and times can be formatted. Parse tries very hard to make sense of the string that's passed to it in order to create a valid DateTime value. It ignores leading and trailing white space, and unrecognized characters if possible, and it fills in missing information with the corresponding current date and time values. Parse will throw a FormatException, though, if it's unable to decipher the string you send to it. Overloaded versions of DateTime.Parse let you specify an object that implements the IFormatProvider provider to describe the expected date format. The other static method that parses strings to make DateTime values is called ParseExact. For this method to succeed, the string that you pass to it must exactly match the format that you specify in the IFormatProvider parameter. The program below illustrates how to use the Parse and ParseExact methods to read dates and times. C# public static void Main() { DateTime MyDate =3D new DateTime(1961, 10, 27, 08, 47, 00); Console.WriteLine(MyDate.ToString()); DateTime NewDate; NewDate =3D DateTime.Parse("10/27/61 08:47"); Console.WriteLine(NewDate.ToString()); NewDate =3D DateTime.Parse("10/1961"); Console.WriteLine(NewDate.ToString()); NewDate =3D DateTime.Parse("27 October 1961 8:47 pm"); Console.WriteLine(NewDate.ToString()); IFormatProvider format =3D new System.Globalization.CultureInfo("fr-FR", true); string[] expectedFormats =3D {"g", "G", "f", "F"}; // This is DD/MM/YYYY format NewDate =3D DateTime.ParseExact( "27/10/1961 08:47:00", expectedFormats, format, System.Globalization.DateTimeStyles.AllowWhiteSpaces); Console.WriteLine("Parsed DD/MM/YY: {0}", NewDate.ToString()); try { NewDate =3D DateTime.ParseExact( "10/27/1961", expectedFormats, format, System.Globalization.DateTimeStyles.AllowWhiteSpaces); Console.WriteLine(NewDate.ToString()); } catch (Exception e) { Console.WriteLine(e.Message); } } VisualBasic Public Shared Sub Main Dim MyDate as DateTime =3D new DateTime(1961, 10, 27, 08, 47, 00) Console.WriteLine(MyDate.ToString()) Dim NewDate as DateTime NewDate =3D DateTime.Parse("10/27/61 08:47") Console.WriteLine(NewDate.ToString()) NewDate =3D DateTime.Parse("10/1961") Console.WriteLine(NewDate.ToString()) NewDate =3D DateTime.Parse("27 October 1961 8:47 pm") Console.WriteLine(NewDate.ToString()) Dim format as IFormatProvider =3D _ new System.Globalization.CultureInfo("fr-FR", true) Dim expectedFormats as String() =3D {"g", "G", "f", "F"} ' This is DD/MM/YYYY format NewDate =3D DateTime.ParseExact( _ "27/10/1961 08:47:00", _ expectedFormats, _ format, _ System.Globalization.DateTimeStyles.AllowWhiteSpaces) Console.WriteLine("Parsed DD/MM/YY: {0}", NewDate.ToString()) Try NewDate =3D DateTime.ParseExact( _ "10/27/1961", _ expectedFormats, _ format, _ System.Globalization.DateTimeStyles.AllowWhiteSpaces) Console.WriteLine(NewDate.ToString()) Catch e as Exception Console.WriteLine(e.Message) End Try End Sub The only real tricky part here is the string array passed as the second parameter to ParseExact. This array specifies the formats that the method should try to match when parsing the string. In the code above, I used the general formats (short date with short or long time), and full formats (long date with short or long time). If the string to be parsed doesn't match one of those formats, then ParseExact throws a FormatException exception. See the official documentation for the DateTimeFormatInfo class for a complete list of format characters and patterns. .NET Date Calculations Last updated Jun 16, 2005. The DateTime value type has methods and properties that let you mangle dates in many fun and interesting ways. Properties such as Date, DayOfWeek, Hour, and Ticks let you get information about specific attributes of the DateTime value. All of the properties, by the way, are read only. There is no way to set the Month property on a DateTime value. There are methods that let you add years, months, days, hours, minutes, seconds, and milliseconds to dates; and methods that will convert DateTime values to other date formats like a Windows FileTime or an OLE Automation date. See the official documentation for full information on those methods. DateTime also provides overloads for the comparison operators so you can write things like: if (yourBirthDate < myBirthDate) Console.WriteLine("You're older than I am"); If you're writing in Visual Basic, of course, you don't have access to the overloaded operators so you'd need to use the Compare or CompareTo method, like this: If yourBirthDate.CompareTo(myBirthDate) < 0 Then Console.WriteLine("You're older than I am") End If The overloaded subtraction operator lets you subtract one date from another to obtain the difference in time between the two dates. The returned value is expressed in a TimeSpan: a number of ticks (100 nanosecond time periods). TimeSpan is really just a number that knows how to express itself in terms of days, hours, minutes, seconds, and milliseconds. TimeSpan properties provide you with a way to get the value expressed in these terms (whole days, minutes, and so on), and methods let you initialize a TimeSpan structure from these values. The overloaded TimeSpan constructor lets you initialize a structure with a given number of days, hours, minutes, seconds, and milliseconds. The largest time unit that TimeSpan "knows" about is the day. It's impossible to convert a TimeSpan value to months, for example, because months have differing numbers of days. The same is true for years. So, if you call TimeSpan.ToString to output a value, it will be expressed in days, hours, minutes, seconds, and milliseconds. TimeSpan has two types of properties: those that return whole values, and those that return fractional values. The Days property, for example, gets the number of whole days represented by a TimeSpan value. By contrast, the TotalDays property gets the value expressed as whole and fractional days. So if you have a TimeSpan that represents 25 hours, the value of the Days property would be 1, and the value of the TotalDays property would be 1.04167 (that is, 1 and 1/24 days). There are similar properties for hours, minutes, seconds, and milliseconds. Of course, since TimeSpan is "just a number," you can use the standard comparison operators to see which of two values is larger or smaller, and you can use the standard operators to add and subtract TimeSpan values. TimeSpan, though, is not terribly useful all by itself. It's really intended to be used in conjunction with DateTime values. The difference between two dates, as pointed out above, is expressed in a TimeSpan. This code subtracts one date from another to get the time elapsed between them. C# DateTime BirthDate =3D new DateTime(1961, 10, 27, 08, 47, 00); DateTime Today =3D DateTime.Now; TimeSpan Age =3D Today - BirthDate; VisualBasic Dim BirthDate as DateTime =3D new DateTime(1961, 10, 27, 08, 47, 00) Dim Today as DateTime =3D DateTime.Now Dim Age as TimeSpan =3D Today.Subtract(BirthDate) You should note that in the second line of code I got the current date and time by accessing the static DateTime.Now property. If you initialize the BirthDate variable in the code above with your own birth date, then the Age variable will represent your current age. If you then want to see what the date will be when you're twice as old as you are right now, you simply add the calculated Age value to Today, like this: C# DateTime ALongTimeFromNow =3D Today + Age; Console.WriteLine(ALongTimeFromNow.ToString()); VisualBasic Dim ALongTimeFromNow as DateTime =3D Today.Add(Age) Console.WriteLine(ALongTimeFromNow.ToString()) .NET Official Documentation Last updated Jun 16, 2005. The DateTime and TimeSpan topics in the MSDN .NET Reference fully describe the methods and properties of these objects, and give some very good examples of using them in typical situations. If you need to work with other calendars or multiple cultures, be sure to check the references for Calendar, DateTimeStyles, and DateTimeFormatInfo in the System.Globalization namespace. http://www.imc.org/rfc2822 .NET Properties Last updated Jul 27, 2005. I had originally planned to duplicate all of the DateTime properties and methods in W3CDateTime. As I got into it, though, I started thinking that I was needlessly duplicating a lot of effort. This is something of a judgement call, I'll admit. However, it seemed silly to implement the Hour property when I could just as easily call get the Hour property on W3CDateTime.DateTime. That is, these two calls would be identical: hour =3D myDate.Hour; hour =3D myDate.DateTime.Hour; In most cases, I avoided duplicating effort. The result is that I only implemented a handful of properties for W3CDateTime, all of them static. The properties that I implemented are: LocalUtcOffset returns the offset between the local time (on the computer that's running the program) and UTC time. MaxValue returns a W3CDateTime that represents the maximum value that can be represented. This value is expressed in UTC time. MinValue returns a W3CDateTime that represents the minimum value that can be represented. This value is expressed in UTC time. Now returns the current local time, expressed in the local time zone. Today returns the current date, expressed in the local time zone. The time portion is set to 00:00:00. UtcNow returns the current time, expressed in UTC time. All of these are static properties. With the exception LocalUtcOffset, all of these properties are duplicates of properties implemented by System.DateTime. The duplication seemed reasonable in these cases. New Methods I needed the ability to do comparisons on W3CDateTime values, and also to add days, months, years, etc. I also needed to subtract two dates to determine the number of days or hours between them. System.DateTime implements all of this functionality, of course, but it becomes difficult to use. For example, if I wanted to add days to a W3CDateTime to get another value, I would have to write: myDateTime =3D new W3CDateTime(myDateTime.DateTime.AddDays(5), myDateTime.UtcOffset); By creating an AddDays method, I'm now able to write: myDateTime =3D myDateTime.AddDays(5); Subtracting two dates was a little trickier in that I had to be sure to use the UtcTime property. Otherwise, subtracting dates from two different time zones would produce erroneous results. For those reasons, I implemented the AddYears, AddHours, and similar methods, as well as both overloads of the Subtract method that are supported by System.DateTime. For comparisons, I implemented a static Compare method as well as the IComparable.CompareTo method. For equality testing, I implemented Equals and GetHashCode as outlined in the SDK article Implementing the Equals Method. Finally, I implemented two conversion methods: ToLocalTime and ToUniversalTime. These are similar to the methods implemented by System.DateTime, except that I added an overload that will convert the value to any given timezone offset. Tag: Data Grid View And Database Tag: 98187
  - 2
    - Drag and Drop between treeviews on TWO forms in MDI... Hi, I have two child forms in my MDI application. They both have treeviews with different data but in teh same format (fund, tran type) I want to be able to drag a node from one to the other but it seems it only works between one or more tree views on the same form, not different forms. How can I either enable drag and drop between two forms from treeview to treeview or maybe use a copy/paste option? thanks for any help. Philip Tag: Data Grid View And Database Tag: 98184
  - 3
    - Referencing forms? I am trying to understand how to work with multiple forms. To aid in my understanding, I created a project with two forms each with a single button. When Form1's button is clicked, the form is hiddend via Me.Hide and Form2 is shown using ShowDialog. When Form2's button is clicked I want to close Form2 and show Form1. My stumbling block is how to reference Form1. I tried Form1.Show but this does not work. What am I doing wrong? Any help is appreciated. -Thanks Tag: Data Grid View And Database Tag: 98183
  - 4
    - Datagrid w/ DataSet: Mouseover in treeview? I am using a Datagrid with a DataSet which contains multiple tables. The Datagrid shows these tables in a tree-like matter. Once the mouse is moved over the tablelinks of the tree the cursor changes to symbol "hand" for signalling that by clicking it is possible to switch to the column-/ row-view of the selected table. This is standard behaviour. Question: While browsing in tree view, is there a possibillity for a mouseover that determines the tablename of the tablelink where the mousepointer is positioned? e.g. Tree shows links as: Table1 Table2 Table3 Table4 Now if mouse is put over Table3-link I want to know this. There is no DataGrid.HitTestType for this issue. It is Type "none". Tag: Data Grid View And Database Tag: 98179
  - 5
    - How to convert Message.LParam pointer to CREATESTRUCT to an object I'm capturing WM_CREATE messages by overriding WndProc in C#/.NET. How do I then convert the CREATESTRUCT* that GetLParam() would return to an object that I can use in my code ? protected override void WndProc(ref System.Windows.Forms.Message m) { if (m.Msg == Convert.ToInt32(WindowsMessages.WM_CREATE)) { StringBuilder text = new StringBuilder("msg = " + m.Msg.ToString() + "wParam=" + m.WParam.ToString() + ", lparam=" + m.LParam.ToString()); // call m.GetLParam() - gets a pointer to CREATESTRUCT; } base.WndProc (ref m); } Tag: Data Grid View And Database Tag: 98176
  - 6
    - PrintPreviwDialog Force Close I am working on a medical application that has to time out. When this occurs, the user may have a modal PrintPreviewDialog up, which I need to close. The CommonDialogs are odd beasts. Anyone know how to force one to close? Tag: Data Grid View And Database Tag: 98175
  - 7
    - Application has generated an exception that could not be handled I have an application developed by .net framework 1.0 , the application works fine on my development machine , but on the non-development machine (the customer machine) the application sometime crashes giving this error message , note that i handeled the unhandled exceptions in my application and that also there is no a particualr scenario that produces this exception. So does anyone have any ideas about what could be the reason for this exception , please help me because am stuck in this problem for more than a month now. I would Like to add that the application runs and that this exception appears while using the application. Thanks for the help in advance Tag: Data Grid View And Database Tag: 98174
  - 8
    - Accessing an IFrame's document. Hi I am writing an test automation library in C#, .NET 2005 using "Microsoft.mshtml". All was going well in testing the web application until I can go to a page containing an IFrame element. I do not know how to access the Document associated with the frame. I can get the IHTMLFrameElement easily enough,but I cannot see contentDocument member in this element class. I m only getting contentWindow that too is throwing an InvalidCastException. I facing this problem for every page containing an iFrame. Thanx... Mayank Jain Tag: Data Grid View And Database Tag: 98169
  - 9
    - How to set ListView scroll info? I have a listview whose contents are constantly being refreshed. When a refresh occurs, I delete all the items and add back. I want to maintain the scroll position before deleting all the items, and then want to restore it once the items are added back. I'm using P/Invoke Get/SetScrollInfo to get and restore the scroll information. GetScrollInfo is working fine - it returns expected information. SetScrollInfo has no effect - the scroll positions are unchanged (both horz and vert are 0). I also tried Get/SetScrollPos - no luck there, either. Is this the correct way to do this? Anyone know what might be wrong? Here's some of my code: private void RefreshList() { User32.SCROLLINFO hsi = User32.GetScrollInfo((uint) MyListView.Handle.ToInt32(), Constants.SB_HORZ); User32.SCROLLINFO vsi = User32.GetScrollInfo((uint) MyListView.Handle.ToInt32(), Constants.SB_VERT); MyListView.BeginUpdate(); MyListView.Items.Clear(); // Add new items here... User32.SetScrollInfo((uint)MyListView.Handle.ToInt32(), Constants.SB_HORZ, false, hsi); User32.SetScrollInfo((uint)MyListView.Handle.ToInt32(), Constants.SB_VERT, false, vsi); MyListView.EndUpdate(); } public class Constants { public const int SB_HORZ = 0; public const int SB_VERT = 1; public const int SB_CTL = 2; public const int SB_BOTH = 4; public const int SIF_RANGE = 0x0001; public const int SIF_PAGE = 0x0002; public const int SIF_POS = 0x0004; public const int SIF_DISABLENOSCROLL = 0x0008; public const int SIF_TRACKPOS = 0x0010; public const int SIF_ALL = (SIF_RANGE | SIF_PAGE | SIF_POS | SIF_TRACKPOS); } public class User32 { [StructLayout(LayoutKind.Sequential)] public struct SCROLLINFO { public UInt32 cbSize; public UInt32 fMask; public Int32 nMin; public Int32 nMax; public UInt32 nPage; public Int32 nPos; public Int32 nTrackPos; } [DllImport("user32.dll", EntryPoint = "GetScrollInfo", SetLastError = true)] private static extern int GetScrollInfoWnd(uint hWnd, int nBar, ref SCROLLINFO si); public static SCROLLINFO GetScrollInfo(uint hWnd, int nBar) { SCROLLINFO si = new SCROLLINFO(); si.cbSize = (uint) System.Runtime.InteropServices.Marshal.SizeOf(si); si.fMask = Constants.SIF_ALL; // also tried si.fMask = Constants.SIF_PAGE | Constants.SIF_POS | Constants.SIF_RANGE GetScrollInfoWnd(hWnd, nBar, ref si); // returns correct data return si; } [DllImport("user32.dll", EntryPoint = "SetScrollInfo", SetLastError = true)] private static extern int SetScrollInfoWnd(uint hWnd, int nBar, bool bRedraw, ref SCROLLINFO si); public static int SetScrollInfo(uint hWnd, int nBar, bool bRedraw, SCROLLINFO si) { int rc = SetScrollInfoWnd(hWnd, nBar, bRedraw, ref si); return rc; // return is 0 - presumably previous scroll position } } Thanks -- Michael Salamone [eMVP] Entrek Software, Inc. www.entrek.com Tag: Data Grid View And Database Tag: 98164
  - 10
    - How do I show a visually inherited form? I just started working with inherited forms and am being befuddled with how to show the inherited form. As a test, I designed Form1 with a single button on it and added an inherited form that inherits from Form1. When my application starts, I would like to have both forms show at the same time. How can this be done? I tried placing the following code in the Form1_Load event: Dim form2 As New InheritedForm form2.Show() but this gives me the following error: An unhandled exception of type 'System.ComponentModel.Win32Exception' occurred in system.windows.forms.dll Additional information: Error creating window handle. What am I doing incorrectly that is generating this error? -Thanks Tag: Data Grid View And Database Tag: 98158
  - 11
    - Recursion in CreateChildControls In my custom control I have overriden CreateChildControls and the first few lines look like this. protected override void CreateChildControls() { Debug.WriteLine("CreateChildControls", "FeatureList"); Controls.Clear(); .. } what I am seeing is that the Controls.Clear line indirectly calls CreateChildControls (the call is through a Get on the Controls collection from the stack). Although the controls end up being right, they are created twice which is hardly efficient. What do I need to do to stop this happening? Iain -- Iain Downs (DirectShow MVP) Commercial Software Therapist www.idcl.co.uk Tag: Data Grid View And Database Tag: 98155
  - 12
    - MonthCalendar - display problem when selecting a date range I am using VS 2005, .net Framework 2.0 When I select a range of dates, the selected dates are whited out except for 1/2 of the first and last date (these are highlighted in blue). This issue also occurs if I select a date and then use the year spinner button to go back a year. To track the issue, I started a new windows forms project, on the default form1 I added a monthcalendar, I have not changed any properties on the form or control. My theme set to default Windows XP. any ideas? Thanks -- Gord Tag: Data Grid View And Database Tag: 98153
  - 13
    - Compare dataset values I built a windows services application which should run 24 X 7, and the system picks user defined parameter to perform scheduled work. My scheduler will pick users settings (dataset) from database to perform task; In order to keep my scheduler perform task when users setting changed, I create a thread timer to retrieve schedule settings from database and compare with my current running schedule task. If settings changed, (by comparing each row values), the scheduler will stop current processes and re-schedule new task. My question is, instead of comparing dataset by rows, is there any other better or efficient way, and how should it be? Tag: Data Grid View And Database Tag: 98150
  - 14
    - Scrollbar problem with RichTextBox Hi, I don't know if this is a bug or is it just me not finding the solution? In VC# 2005 (running Windows2000) I have a multiline RichTextBox with ScrollBars set to "Both", but not forced. So I want to see no scrollbars at the beginning, and then, while filling up the Box with text, they should appear with a proportional thumb as usual. When deleting some text, the bars should disappear again. Well, instead of that, I get the following: As long as I don't resize the window, I can type in text without problems, but no scrollbars appear when arriving at the bottom or at the right. Only when I then resize the window (might be by only 2 mm), the scrollbars appear as they should, and from then on, everything works fine untill I close the app. But when I resize before reaching the margins, then dysfunctional scrollbars appear, with nonproportional thumbs, and the stay there until the text reaches the margins, for then to turn to normal scrollbars for the rest of the app's life. This behavior is independently for the horizontal and vertical scrollbar, each of them waiting text to come to its corresponding margin (right or bottom) before starting to work as it should, provided a resize has been done once. Quite annoying, what am I doing wrong? Thanks for any help Joe Tag: Data Grid View And Database Tag: 98149
  - 15
    - TextBox AutoScale in VS 2005 designer I've recently moved to VS 2005 and .NET Framework 2.0 (from VS .NET 2003 and .NET Framework 1.1). And I have a trivial problem in designer: 1) I create a new project with default settings (C# Windows Application). OK. 2) And on the main form I put a TextBox. I set its width to 100 pixels. OK so far. 3) Now I change TextBox font to Courier New, 12pt, bold. OK. 4) I want to set the TextBox'es height to 24 pixels. And I can't. It sets its height back to 26 pixels. 5) So I want to change the property called AutoSize. TextBox inherits such a property from TextBoxBase. But it is TextBoxBase's property, not TextBox'es, so the property window doesn't show it. 6) So I modify the code generated by designer, I add a line: textbox.AutoSize = false; and change height to 24. OK, it works for a while. But when designer makes any changes to code, it removes the line above that I added and returns back to 26 pixels. Now what I can do is change the AutoSize property and Height somewhere else in code, where designer won't mess up. But: 1) It's not optimal to change the control's size twice: once when it is created with the size forced by designer, and then again change the size to what I want it to be 2) When I change it in code I lose the possibility to view visually how the final effect will be, because designer will show something different from what will be set during runtime. I want to layout controls in designer. I don't want to set all the sizes and positions at runtime in code without preview, because it's too much work with over 30 controls. And if I can't do it in designer, then VS 2005 is a useless tool. I can write code in notepad. 3) I had no such problem in .NET 1.1 and Visual Studio .NET 2003 4) I have no problem with other controls, such as Label, which has a property AutoSize on its own (not inherited) and I can change that property in designer's property window, and all works fine. Any ideas how can I turn off TextBox'es AutoSize property in designer? Thanks in advance, Agata Staniak Tag: Data Grid View And Database Tag: 98147
  - 16
    - Trouble with BindingSource I've gone through a few demos and walkthroughs trying to become familiar with the new binding in vs2005. I'm having some success, but not every time. I've create a dataset with the datasource configuration wizard. I have 3 tables in this dataset (expense, category, and type). I drag each table onto a separate form. Visual studio creates a datagridview and binding navigator on each form. When executed, the grids on each form populate correctly. The problem is that one of the tables doesn't get updated when I press save, the other two save correctly. I'm not writing any code, just using the autogenerated code that VS writes: Private Sub ExpenseBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ExpenseBindingNavigatorSaveItem.Click Me.Validate() Me.ExpenseBindingSource.EndEdit() Me.ExpenseTableAdapter.Update(Me.ExpenseDataSet.expense) End Sub I can't figure out what is different about the expense table/grid that is causing it to not update. There are no errors generated. If I inspect the dataset in the debugger after I make changes in the grid, the dataset appears to get updated. I therefore believe it has something to do with the BindingSource or TableAdapter. The changes never make it from the dataset to the database (an access db). Joel Tag: Data Grid View And Database Tag: 98146
  - 17
    - Catch Exception problem.... How to catch the windows exception that shows a window with the name of the executable program and a messege saying : "[Program] has encounterd a problem and needs to close. We are sorry for the inconvenience", and three buttons, "Debug", "Send Error Report" and "Don't Send", in a dotnet applicacion, if its posible, of course... Tag: Data Grid View And Database Tag: 98142
  - 18
    - How to protect ADO.NET connection string under WindowsForms? Hello I build WindowsForm application, that use MS Access database. I wish to protect AccessDB password that I use in connection string. Application will be used by final users and customers. I understand that .NET framework application is easy to decompile and trace it's variables. So how to hide or protect connection string from easy disrupt, and reading DB password. Thanks MilanB Tag: Data Grid View And Database Tag: 98137
  - 19
    - how ?? I want to run one perticular executable from Harddisk (installed lincenced application ) so there is entry of path where that application is installed NOW HOW CAN I LOCATE THAT PATH ??(USING VB.NET) Tag: Data Grid View And Database Tag: 98135
  - 20
    - Error clicking List View Columns Headers (Application Verifier: He Hi All, Error while sorting ListView Items. While clicking the columns headers in ListView, an Access Violation Exception is thrown. Not always but sometimes. The Error was reported when testing the application using Application Verifier under Heap section... Thanks in Advance, Karthik Tag: Data Grid View And Database Tag: 98133
  - 21
    - DatagridView only add rows no edit existing Hello I need a DatagridView with the option of read-only for existing record but that I can insert new records I try with this.dataGridView1.ReadOnly = false; this.dataGridView1.AllowUserToAddRows = true; this.dataGridView1.AllowUserToDeleteRows = false; but the problem is that the user can update existing records and I want only able to insert new ones. if I use this.dataGridView1.ReadOnly = true; the user have a new record but can edit the information a the new one Please I think the solution is very simple but I have invest a lot of time with different combinations without any positive result please help MajorTom Tag: Data Grid View And Database Tag: 98131
  - 22
    - Cursor on ListView Hi I have a form in which there is a treeview alongside a listview. Now I have certain conditions when the Listview control is disabled. When this happens I would want the Cursor to be of type "NO" only when the mouse is over the ListView. It should be default over the other controls on the form. I have tried many things but nothing seems to work. I am able to set the Cursor to No when the Listview is disabled ...but the cursor does not change to default if I leave the Listview control... The mouse events dont seem to help either. Next I tried using the Cursor.draw(graphics, rectangle) method with the rectangle being the size of the Listview control. I thought this would limit the No cursor only within this rectangle. But Nope did not work! Even if i change the cursor property to anything else from the designer for the listview or even the form..it doesnt seem to work... what am i missing??????? appreciate all responses Thanks, Vinit Tag: Data Grid View And Database Tag: 98130
  - 23
    - Print To File hangs when cancelled. When you cancel the status window when printing to a file, the status window hangs and cannot be closed ---you must go to the task manager to End the window session in order to close the window. This is a demonstrable problem in Net Framework 1.1 by using the code below. I could not find any solution to this problem in Knowledge Base. **** StringReader streamToPrint = new StringReader (textArea.Text); //Assumes the default printer TextPrintDocument pd = new TextPrintDocument(streamToPrint,textArea.Font); if (storedPageSettings != null) { pd.DefaultPageSettings = storedPageSettings ; } PrintDialog dlg = new PrintDialog() ; dlg.Document = pd; DialogResult result = dlg.ShowDialog(); try { if (result == DialogResult.OK) { pd.Print(); } } catch( Exception ex ) { Console.WriteLine(ex); dlg.Dispose(); } Tag: Data Grid View And Database Tag: 98129
  - 24
    - TypeConverters IsValid method not getting called I have a TypeConverter derived from StringConverter in which I have overridden GetStandardValuesSupported GetStandardValues GetStandardValuesExclusive IsValid. Now, initially when I wrote this I did not have an IsValid method and therefore even if I entered an invalid value for the property on which my typeconverter is applied to it would accept it. After I added the IsValid method, I expected this behavior to change but when I run it under the debugger the IsValid method is not getting called at all. Any idea what is happening here? Thanks. Tag: Data Grid View And Database Tag: 98127
  - 25
    - Serializing TreeView and DataGridView controls states Hello All, First of all thanks in advance to everyone who will try to help me. I have Form with TreeView control and DataGridView control. Each TreeNode has its own rows and due to I am placing rows to ArrayList and store it in tag of TreeNode like this: // dgv - DataGridView visible within whole class private void treeView1_AfterSelect(object sender, TreeViewEventArgs e) { dgv.Rows.Clear(); dgv.Columns.Clear(); DataGridViewCheckBoxColumn ins = new DataGridViewCheckBoxColumn(); ins.Name = "Insert"; ins.HeaderText = "Insert; ins.Width = 90; DataGridViewTextBoxColumn itemName = new DataGridViewTextBoxColumn(); itemName.HeaderText = "Item name"; itemName.Name = "itemName"; itemName.Width = (dgv.Width - ins.Width - 43) / 2; DataGridViewTextBoxColumn itemValue = new DataGridViewTextBoxColumn(); itemValue.HeaderText = "Item Value"; itemValue.Name = "itemValue"; itemValue.Width = (dgv.Width - ins.Width - 43) / 2; DataGridViewComboBoxColumn mdfLink = new DataGridViewComboBoxColumn(); mdfLink.Name = "mdfLink"; mdfLink.HeaderText = "MDF Link"; mdfLink.Width = (dgv.Width - 80) / 6; mdfLink.DropDownWidth = mdfLink.Width * 2; dgv.Columns.AddRange(new DataGridViewColumn[] {ins,itemName,itemValue, mdfLink}); if (treeView1.SelectedNode.Tag != null) { ArrayList al = (ArrayList)treeView1.SelectedNode.Tag; foreach (object obj in al) { dgv.Rows.Add((DataGridViewRow)obj); } } else { // fill rows manually // ... } } private void treeView1_BeforeSelect(object sender, TreeViewCancelEventArgs e) { ArrayList al = new ArrayList(); foreach (DataGridViewRow dgvr in dgv.Rows) { al.Add(dgvr); } if (al.Count != 0) { treeView1.SelectedNode.Tag = al; } } And I need to store state of TreeView in a file by serialization to future restoring (I know that TreeView doesn't support serialization but TreeNoew does). But DataGridViewRow is not support serialization. As matter of fact I tried to store values in string arrays and populate it accordingly. My question is: 1. Is anybody know better way of serialization of treeview with attached DataGridView? 2. In case of using my method how do I save/restore selected item of ComboBoxCell? I will appreciate any help. Best regards, /Gelios Tag: Data Grid View And Database Tag: 98126

Hello i have some problems with load values to a datagridview.

I can´t put the data from a database into a datagridview.

My code is:

Base.bd bd1 = new Base.bd();

OleDbCommand c1 = new OleDbCommand("SELECT * FROM table1");

c1.Connection = bd1.getConn();

DataSet ds = new DataSet();

OleDbDataAdapter da = new OleDbDataAdapter();

da.SelectCommand = c1;

da.Fill(ds);

dgvModulos.AutoGenerateColumns = false;

dgvModulos.DataSource = ds;

Top

Re: Data Grid View And Database by Rodrigo

Rodrigo
Wed Mar 01 08:25:29 CST 2006

Problem solved.

"Rodrigo Ferreira" <rjrferreira@gmail.com> escreveu na mensagem
news:%23yzWu3SPGHA.2924@TK2MSFTNGP11.phx.gbl...
> Hello i have some problems with load values to a datagridview.
>
> I can´t put the data from a database into a datagridview.
>
> My code is:
>
> Base.bd bd1 = new Base.bd();
>
> OleDbCommand c1 = new OleDbCommand("SELECT * FROM table1");
>
> c1.Connection = bd1.getConn();
>
> DataSet ds = new DataSet();
>
> OleDbDataAdapter da = new OleDbDataAdapter();
>
> da.SelectCommand = c1;
>
> da.Fill(ds);
>
> dgvModulos.AutoGenerateColumns = false;
>
> dgvModulos.DataSource = ds;
>
>

Top