Datagridview on datagridview

Windows Forms Data Controls and Databinding

- Previous
  - 1
    - How to change appearance of toolstrip overflow button? Hi there I derived my own class from the toolstrip, to implement a few changes. My toolstrip uses a blue background color. This works fine, but i got a little problem: The overflow button is nearly invisible, until you hover over it with the mouse. It uses the same background color as the toolstrip and only has this little black arrow which is nearly impossible to see with the blue background. I only want to get this button better visible! I tried to change the BackColor and ForeColor properties of the overflow button (which is accessible via toolstrip.OverflowButton), but ForeColor changes nothing at all and BackColor only draws a little line on the button in the desired color. I also tried to write my own ToolstripRenderer. I override the OnRenderOverflowButtonBackground, but then i have to draw the entire button by myself, which is not what i wanted. Tried to do something with ButtonRenderer.DrawButton() but this didn't work either. Any help would be appreciated! Tag: Windows Forms Data Controls and Databinding Datagridview on datagridview Windows Forms
  - 2
    - getting error while binding data to textfield. I ment TableName property of course...sorry Tag: Windows Forms Data Controls and Databinding Datagridview on datagridview Windows Forms
  - 3
    - Where the heck have my scrollbars gone!! Hi all, I am creating some DataGridView controls at run-time I populate the grids with data dependent on what the user selects For some reason, both my vertical and horizontal scrollbars have disappeared (even though the datagridview is set to show 'both') Any ideas Thanks Tag: Windows Forms Data Controls and Databinding Datagridview on datagridview Windows Forms
  - 4
    - Re-Creating the TaskBar and Visual Styles Implementation I am trying to re-create the taskbar exactly as it is now. I don't need the start menu, quick launch, or tray (yet) but just the part that displays application buttons. I was using visualstylesrenderer but it does not contain styles for the buttons in their normal state. It does contain them for flashing state. I ended up getting the image directly from the resource file and this seemed to work until you stretch the image to fit the buttons size. It then becomes blurry and ugly. Is there a better way to do this and if not how would I go about stretching the taskbandbuttom bmp so that it looks right. Is there a method for creating a taskband already that does all this for me or not Tag: Windows Forms Data Controls and Databinding Datagridview on datagridview Windows Forms
  - 5
    - How to run multiple reports on a reportviwer I have two buttons and reportviewer on a form. button (A) runs reportA, button (B) runs reportB. I use the following routine to print the reports: The first report (A) runs fine but when I select report (B) it reprints report (A) - is there a way to clear, or reset the report viewer Code Snippet public static void MyReport( string strSql, ReportViewer rvObject, string strReportName, string strTable) { //Create array of tables in the db strDSName[0] = "DB_EmployeeDataSet_Employee" ; strDSName[1] = "DB_EmployeeDataSet_Shift" ; strDSName[2] = "DB_EmployeeDataSet_Company" ; strDSName[3] = "DB_EmployeeDataSet_Department" ; strDSName[4] = "DB_EmployeeDataSet_ClockTransactions" ; strDSName[5] = "DB_EmployeeDataSet_Dependants" ; strDSName[6] = "DB_EmployeeDataSet_HealthTransactions" ; //Create the dataset OleDbConnection MyConnection = new OleDbConnection (MyConnectionStr); DataSet MyDataSet = WindowsApplication1. Class1 .GetDataset(strSql, MyConnection, strTable); //Bind to the report rvObject.LocalReport.DataSources.Clear(); rvObject.LocalReport.ReportPath = strPath + strReportName; //Associate new dataset with the reportviewer datasource for ( int i = 0; i <= 6; i++) { rvObject.LocalReport.DataSources.Add( new ReportDataSource (strDSName[i], MyDataSet.Tables[0])); } //Do not use localreport to refresh rvObject.RefreshReport(); MyDataSet.Dispose(); } Tag: Windows Forms Data Controls and Databinding Datagridview on datagridview Windows Forms
  - 6
    - Memory usage of ListView's LargeImageList, when using OwnerDraw and DrawItem event To implement an image thumbnail viewer, I have used a ListView control that uses a LargeImageList, and has OwnerDraw set to true. I've also added the following event handler to draw the image manually, for certain reasons: private void ListViewEx_DrawItem(object sender, DrawListViewItemEventArgs e) { ListView lv = sender as ListView; if (lv.LargeImageList == null) return; int nImage = e.Item.ImageIndex; if (nImage < 0 || nImage >= lv.LargeImageList.Images.Count) return; // PROBLEM line: Image img = lv.LargeImageList.Images[nImage]; Rectangle rSrce = new Rectangle(0, 0, img.Width, img.Height); Rectangle rDest = e.Bounds; e.Graphics.DrawImage(img, rDest, rSrce, GraphicsUnit.Pixel); } My issue is that when each DrawItem event occurs, I can see the memory usage in TaskManager increasing very rapidly . If I just create a new empty Image on the "PROBLEM" line then it's fine. So, it appears that just getting an Image reference from LargeImageList leaves many large objects lying around. Any suggestions would be appreciated. Tag: Windows Forms Data Controls and Databinding Datagridview on datagridview Windows Forms
  - 7
    - Setting visibility of properties in a propertygrid at runtime Hi, How to set visibility of properties in a property grid at runtime.. My requirement is to show and hide some properties based on the selected item of dropdownlist. Tag: Windows Forms Data Controls and Databinding Datagridview on datagridview Windows Forms
  - 8
    - Error : DataTable internal index is corrupted: '5' Thank you Ken But still I'm updating Gridview also. The application is behaving unexpectedly. Tag: Windows Forms Data Controls and Databinding Datagridview on datagridview Windows Forms
  - 9
    - .NET app checks for original install location before running? Some problems witht he assumptions Microsoft have made. 1. If the original install was on a network drive which then disconnected, the product will not execute at all even thought it was successfully installed -- I'm all for repairs, but the way it's implement causes MORE significant problems then it tries to solve. 2. The process of searching for the original MSI should NOT prevent the application from running when the shortcut is clicked -- if it doesn't find it MSI it should still continue, not prompt with a message for the user to locate it (this IS DEFINITELY NOT END USER friendly) and if cancel is pressed then it should still continue to run the app, not just fail and do nothing. 3. The repair is triggered directly after the install when the users clicks on the shortcut -- this is apparently done once and only once. The tool I'm using is what is provided with VS 2005. Spending $4000/yr (more than the cost of my MSDN Universal subscription at $2500/yr) for a single dev license for InstallShield services is NOT an option. The very fact that InstallShield can price their product at such a high cost is pretty indicative that Microsoft's OS and installation process is overly complicated for the task at hand -- and Vista has only made matter worse not better. I realize, not your issue (hoping someone at Microsofts gets a clue, but I doubt they ever will) -- but thanks for the MSI setting and link to MSI building tools. I'll investigate them as clearly what comes with VS 2005 is seriously limited (again more half hearted attempts from Microslop). Rob. Tag: Windows Forms Data Controls and Databinding Datagridview on datagridview Windows Forms
  - 10
    - UserControl with ComboBox Got the point about the FormatStringEditor. Any idea how to expose the Text Property. Tag: Windows Forms Data Controls and Databinding Datagridview on datagridview Windows Forms
  - 11
    - Change Install and Update URL after publishing... As far as I know you need to sign the manifest on the target machine, not the dev machine or it will not work. This means that you will need to distribute the certificate to the target machine also. Hope that helps. Tag: Windows Forms Data Controls and Databinding Datagridview on datagridview Windows Forms
  - 12
    - list view set focus to item that is fine and dandy but when you get into chopping char out to work on... you get errors that you can't convert from char to string or string to char... string builder works wonders........... it turns the string into an array that you can work with,,,, string Data = Item.SubItems[1].Text; StringBuilder sb = new StringBuilder (Data.Length); char c = Data[0]; if (c == '"' ){ // is first char a quote // for ( int i = 1; i < Data.Length; i++){ c = Data [ i ] ; if (c == '"' ){ // find second quote and split string File_Name = Data.Substring(1,i-1); File_Name_Arguments = Data.Substring(i+1,Data.Length-i-1); break ; } } } Tag: Windows Forms Data Controls and Databinding Datagridview on datagridview Windows Forms
  - 13
    - How to use VBScript as a Custom Action DLL in .net setup ? Hello Mr.Phil Wilson, Here is the script, Function CheckSN Dim SerNum 'SerNum = Session.Property("ISX_SERIALNUM") SerNum=Session.Property("PIDKEY") If (SerNum="") Then MsgBox "Serial number not specified. Stopping Setup." CheckSN=1602 Else CheckSN=0 End if End Function I am using this during installation.I have followed the tips as per previous message.Please tell me how it will be exeuted. Thanks & regards, Shyam Vaidya. Software Developer. Tag: Windows Forms Data Controls and Databinding Datagridview on datagridview Windows Forms
  - 14
    - problem with DataGrid .net 1.1 Hi all. I have a real problem with ComboBox used inside a DataGrid. 1. I have all needed events added to datacolumn. 2. I try to change the cell and go to OnChangeDataGridCell (my event function) so it seems to work. 3. I click on the cell, and next I click into datagrid (not the cell). 4. Then i try to go back to my last selected cell (combo) and there is a problem... the on click is called, but should be OnChaneDataGridCell. 5. So solving the problem i wanted to call my OnChangeDataGridCell from OnClick. Ok but overloaded method Edit is not called. So It is not released What is going on Thanks in advance. There is nothing special and I Do don' t post my code. Rather I want to know manually how can I understand the situation and if there is some solution for this kind of problem. Tag: Windows Forms Data Controls and Databinding Datagridview on datagridview Windows Forms
  - 15
    - Considering C# Tilak's code is not technically correct. The drawing won't properly repaint itself when you minimize, then restore the form. Check this thread for code that shows how to use the form's Paint event. Tag: Windows Forms Data Controls and Databinding Datagridview on datagridview Windows Forms
  - 16
    - Error dialog in PropertyGrid Hi, When entering an invalid value in a PropertyGrid control an ugly dialog pops up telling the user that an error setiing the value occurred. Is it possible to replace this dialog with your own implementation Tag: Windows Forms Data Controls and Databinding Datagridview on datagridview Windows Forms
- Next
  - 1
    - totally newbie question about deploying software I have a windows form application developed with .net 2.0 c#. I am using visual c# express If i use the clickonce deployment, i cant have a destop icon, have the user specify an installation directory, show an end user licence agreement, or make entries to the registry. But i need the functionality that the where it checks for the .net framework and downloads from vendor if not present. Does anyone have any suggestions, is there another installer tool that can be installed with visula c# express thanks Tag: Windows Forms Data Controls and Databinding Datagridview on datagridview Windows Forms
  - 2
    - How-to Start .Net executable with parameters? Not sure what I'm missing here but it does not seem to work I added in my project MyApp within the MainForm.vb (startup form for the project) some code as below (in VB.Net); Public Sub MainForm( ByVal args() As String ) If args.Length = 0 Then MessageBox.Show("Nothing", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error) Else MessageBox.Show(args(0), Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error) End If From the other .Net application (Starter.exe) I issue the command; System.Diagnostics.Process.Start("C:\MyFolder\MyApp.exe", "1 T"); nothing displays (no messages at all) Tag: Windows Forms Data Controls and Databinding Datagridview on datagridview Windows Forms
  - 3
    - Open Form, Close last form A couple of ideas- have you tried assigning null after disposing (worked for me with images issues i had once) Otherwise, what about adding the ref keyword Tag: Windows Forms Data Controls and Databinding Datagridview on datagridview Windows Forms
  - 4
    - Results from a worker thread into main thread? i.InvokeRequired - this part intrigues me, will it really toggles to false when the current pass came from the call to i.BeginInvoke() I never tried this somewhat recursive approach. When I have to do this, I always follow this template; if (this.InvokeRequired) { // create a delegate to a worker method, ex. RefreshGrid // setup arguments i.BeginInvoke(RefreshGridDelegate, args) } else // just call the worker method directly RefreshGrid(args); Tag: Windows Forms Data Controls and Databinding Datagridview on datagridview Windows Forms
  - 5
    - MDIContainer inside another MDIContainer. Hello. I have One MainForm for my system. This MainForm is MDIContainer. From that form, i call other forms that are MDIContainers too. So, when i try to open one of this childForms from the MainForm frmTemp.MdiParent = this ; // frmTemp is a ChildForm i am trying to create which is a MDI container. "this" is the mainForm frmTemp.Show(); i get this error. Form cannot be both an MDI child and MDI parent. Parameter name: value Is there any workaround about this the design of my software almost force me to use this type of architecture. Thanks Tag: Windows Forms Data Controls and Databinding Datagridview on datagridview Windows Forms
  - 6
    - TreeNodeCheckChanged and SelectedNodeChanged of TreeView dosen't fire TreeNodeCheckChanged and SelectedNodeChanged events of TreeView in ASP.NET 2 dosent fire when a chack is made or removed. Is there any fix Tag: Windows Forms Data Controls and Databinding Datagridview on datagridview Windows Forms
  - 7
    - need help with Datagrid's Captiontext im very sry, but I have no idea how to put those codes into my project. Here are my codes, I dunno where to type it in: Private Sub TimeAtt_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load DataGrid1.ParentRowsVisible = False ' create a connection string Dim connString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\database.mdb" Dim myConnection As OleDbConnection = New OleDbConnection myConnection.ConnectionString = connString ' create a data adapter Dim da As OleDbDataAdapter = New OleDbDataAdapter( "SELECT username, empno FROM emp" , myConnection) ' create a new dataset Dim ds As DataSet = New DataSet ' fill dataset da.Fill(ds, "emp" ) DataGrid1.SetDataBinding(ds, "emp" ) ' Attach DataSet to DataGrid DataGrid1.DataSource = ds.DefaultViewManager End Sub Tag: Windows Forms Data Controls and Databinding Datagridview on datagridview Windows Forms
  - 8
    - ToolStripSplitButton ImageAlign TextAlign Is there a work around for the text alignment bug in ToolStripSplitButton To replicate, Create a toolstrip on a form Add a SplitButton Set button text to "Hello" Set the image. Set ImageAlign middle left Set TextAlign to middle right Set AutoSize to false Set Width to something such as 150 Run and text is NOT aligned left, but instead looks ugly crammed up against the image. Thanks Mark Tag: Windows Forms Data Controls and Databinding Datagridview on datagridview Windows Forms
  - 9
    - how to save datagrid into a file? Hi, I'm using visual basic, and currently I am working on how to save the information which is inside the datagrid to either a .txt or .xls file, using a SaveFileDialog. But I have no clue of how to write the data from my datagrid into the file. Any help is much appreciated, thank you! janue. Tag: Windows Forms Data Controls and Databinding Datagridview on datagridview Windows Forms
  - 10
    - help with BackGroundWorker i think i'm missing something basic here: if my winform call's the B.L(web service) in 2 diffrent threads, and this B.L has only 1 DAL object, what is hapennig both threads use the same DAL so they both use the same m_db member, and this is why i have threading conflicts is it possible that this is why i get sometimes the error msg about max polling in the DAL Tag: Windows Forms Data Controls and Databinding Datagridview on datagridview Windows Forms
  - 11
    - Regarding collection of cells in a single column hi how we can get collection of all cells in a particular datagridviewcheckbox column It seems there is no function exists like that. So how can we get the collection of all cells Thanks, Santhosh. Tag: Windows Forms Data Controls and Databinding Datagridview on datagridview Windows Forms
  - 12
    - Windows Installer condition :Microsoft Visual Basic 2005 Hello all, I have a program that installs 3 compact databases (.sdf) during the install in [TARGETDIR]DB, but when i am installing a newer version of my program I want to leave the databases in tact and just append the changes through the Custom Actions. I have gone into my File System tab \Application Folder\DB and the properties for each of the files i have set the condition to "Not Installed", "NOT Installed", "!Installed" and a few others, yet I can not stop the install from overwriting the files if they are present. Many thanks in Advance Phil Tag: Windows Forms Data Controls and Databinding Datagridview on datagridview Windows Forms
  - 13
    - Delete Nice Rong-Chun Zhang , So here is the code. BEGIN TRAN SafeLyPreventDeletion -- To Remove when really deleting the tables DECLARE @stmt nvarchar ( max ) DECLARE @aTable nvarchar ( max ) DECLARE @aRelation nvarchar ( max ) DECLARE TablesToDeleteCursor Cursor FOR select [name] from sysobjects where [type] = 'u' -- A cursor to delete relations first. DECLARE aTableRelations CURSOR FOR SELECT B . name , A . NAME from sysobjects a join sysobjects b on a . parent_obj = b . id where a . type = 'F' OPEN aTableRelations FETCH NEXT FROM aTableRelations INTO @aTable , @aRelation While @@FETCH_STATUS = 0 BEGIN SELECT 'DROPPING RELATION ' + @aRelation SET @stmt = 'alter table ' + @aTable + ' drop constraint ' + @aRelation EXEC ( @stmt ) FETCH NEXT FROM aTableRelations INTO @aTable , @aRelation END CLOSE aTableRelations DEALLOCATE aTableRelations -- Now that relations are dropped, drop tables too. OPEN TablesToDeleteCursor FETCH NEXT FROM TablesToDeleteCursor INTO @aTable While @@FETCH_STATUS = 0 BEGIN SELECT 'DROPPING TABLE ' + @aTable SET @stmt = 'DROP TABLE ' + @aTable EXEC ( @stmt ) Fetch NEXT FROM TablesToDeleteCursor INTO @aTable END CLOSE TablesToDeleteCursor DEALLOCATE TablesToDeleteCursor ROLLBACK TRAN SafeLyPreventDeletion -- To Remove when really deleting the tables Tag: Windows Forms Data Controls and Databinding Datagridview on datagridview Windows Forms
  - 14
    - foreach(Form f in AllformsOfApplication) t is a Type object. It holds infomation about a Form class. It is not an instance of that class. Hence instead of " if(t is Form)" you want "if (t.IsSubclassOf(typeof(Form)))" However, that only gets you one line further, because next up, "allForms.add(t);" is going to fail. Now, there are two way we can go here: List<Type> allForms = new List<Type>(); and " allForms.add(t);" which will give you a List of Type objects describing all the forms in your assembly....OR... List<Form> allForms = new List<Form>(); and "allForms.Add(Activator.CreateInstance(t) as Form);" which give you a list of (new, hidden) Forms. (These are all the same Form classes as in your application, but they are not the same Form objects as you are using in your application.) If you tell us what you are planning on doing with this list, prehaps we can show you a better way of going about it. Tag: Windows Forms Data Controls and Databinding Datagridview on datagridview Windows Forms
  - 15
    - Error: Access denied I have a client, who is trying to install our click once application and when they hit .application page they are getting access denied. Does any one know why would they get access denied I asked them to check if the firewall is blocking and they told me there is no filters in the firewall server. I checked the trusted sites and my site is there as a trusted site. I am unable reproduce the problem at my end. In the publish.htm, when they hit setup.exe, it does launch and installs the pre-requisites correcly. But when it launches the .application thats when they are gettting this error. Thanks. Tag: Windows Forms Data Controls and Databinding Datagridview on datagridview Windows Forms
  - 16
    - dual core processors I am building a real time data processing application consisting of two main processes, and I'm having trouble getting things to run fast enough. I believe that if the processes always ran on seperate processors of the dual core processor, the system will run fast enough. How can I guarantee that the processes will always load and execute in seperate processor cores Tag: Windows Forms Data Controls and Databinding Datagridview on datagridview Windows Forms

Bibek

Hello i am developing a windows application using C#.net.I need to bind the datagridview on one column of the datagridview.is it possible

if no what will be the solution

Thank you.

Re: Windows Forms Data Controls and Databinding Datagridview on datagridview

Ken Tucker

Sorry I do not understand what you are asking

Re: Windows Forms Data Controls and Databinding Datagridview on datagridview

Zhi-Xin Ye - MSFT

You want to display a master/detail relationship

Re: Windows Forms Data Controls and Databinding Datagridview on datagridview

Bibek

What i am saying is i want first to bind the data on one datagridview and bind that datagridview on a column of another datagridview.

for eg. I want to display data like this on datagridview.

Weight. Product Combination

12 productid quantity

2 2

4 3

3 4

13 productid quantity

2 2

3 4

14 productid quantity

2 4

4 6

3 4

Re: Windows Forms Data Controls and Databinding Datagridview on datagridview

Gavin Jin - MSFT

I think you can also use some expandable datagridview

look at this article ,I hope it helps

http://blogs.msdn.com/markrideout/archive/2006/01/08/510700.aspx

Re: Windows Forms Data Controls and Databinding Datagridview on datagridview

Zhi-Xin Ye - MSFT

It's impossible to achieve this kind of effect by directly binding, you have to custom paint the DataGridView.

Re: Windows Forms Data Controls and Databinding Datagridview on datagridview

Bibek

Yes i achieved this using master/detail relationships