I have some code written by another developer(no, really). The datagridview has the AllowUserToResizeColumns property set to true, but at runtime the grid will not allow column resizing. I've checked the code to see if the property is being set in code and I can't find anything. Is there some other grid property that, if set to a certain value, will disable column resizing?
View 2 RepliesI am trying to update my DGV with the following code. i have generated SQL update command in the tableadapter. but still the changes are not affecting the DB.
[Code]...
I'm working with datagridview.I found an example on the web about creating a datagridview: firs I make my array containing data, then I make a datatable from array, then I make datagridview from datatable.I don't know if it's the correct way but it seems work.In a column I make random numbers for test: for example I have on column "Time" these values: 1155, 1725, 584, 996, 1352.Then I try to sort with code when I press pushbutton: it doesn't work because I have the values:1155, 1352, 1725, 1758 (until now it seems to work correctly), but then I have 584 and 996 values: wrong!Ok, let's try with the manual sorting: same result.I filled cells with "integer" values, let's try using strings, then I used "value.tostring" same result.I also tryed to fill strings with blankspaces to obtain same length, but nothing changed. "1155", "1352", "1725", "1758", " 584", " 996".Then I tryed to fill with "0" values:"1155", "1352", "1725", "1758", "0584", "0996".The same.How can I fill cells values?
View 9 RepliesI have a few classes, one is a form, the other is the source of the datagridview. I want to be able to sort the columns of the datagridview by clicking on the header. Here are the classes that I am dealing with:
Imports DiscoveryByte.AddTools.Misc_Tools
Public Class ViewDiscoveryFlashCards
Private DBBindingSource As New BindingSource
[code].....
I can edit values on the DataGridView and as long as the program is running it is there exit the program and restart the program and return to the DataGridView and all changes are gone. I know there has been a lot of posts on this subject and I have read many of them but nobody seems to be using SqlClientCE for the data base and I need instructions of how to make a table adapter say like the following do the trick.[code]...
View 1 Repliesi got problem while saved the record.here is my code.
Imports System.Data.OleDb
Imports System.Data
Imports System.Configuration
Public Class Form2
[code]....
I should mention I am developing this in SharpDevelop, so if it's a bug with this software then I'll take this up with them.
So I am having issues with trying to get a right-mouse click to work. I have a grid of 30 buttons and I need to right-click to enable a button and left-click disable. I have surfed all over the internet trying to find the answer and the closest I have come to it is it detecting a left-click, but never right.
Sub Button1Click(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles Button1.Click
DataGridView1.CurrentCell = datagridview1.Rows(0).Cells(0)
[Code]......
As you can understand, I am having a lot of frustration with this. It just seems that I can't get it to work. I've scoured the internet looking for a solution without avail.
I'm trying to compress a file in .NET, but having some trouble. The zip file is created, but it's only 1KB and no files are within the zip file. Basically, it's not working for some reason and I'm not sure why.
Public Sub CompressFile(ByVal fileName As String)
Dim strOutput As Stream = File.Create("zippedFile.zip")
Try
Using (strOutput)
Dim strInput As Stream = File.OpenRead(fileName)
Using (strInput)
[Code] .....
I have a folder named "Root" in my d: drive.The "Root" folder contains two folders namely "Child1" and "Child2".The "Child1" again contains a folder named "Sub-Child1".The "Child2" again contains a folder named "Sub-Child1".I want to do a code in such a way that i can show the folder names in a Treeview.
View 8 Replieshow to operate onthe excel in vb.net......such as Create an Excel 2003 file in VB.NET 2005,Open and Edit Cells in an Excel 2003 file in VB.NET,Format Excel 2003 Page in VB.NET ,How to export from database to excel,How to export from DataGridView to excel,etc.i know the structure a file excel.It contains 3 main component.
1. Application which can modify and operate cells .
2. Work book , is child of Application and contains worksheet.
3. worksheet is child of Work book and contain columns and rows.
I have a picturebox on the form that has the KeyTip property assigned. If I hit the corresponding key, nothing happens. It seems to only work with controls other than the PictureBox.I have set KeyPreview to True and added this
[Code]...
I'm having an issue with rasing an event. In my application I have a form and within that form I create an instance of a class (clsUsage). Within clsUsage I create an instance of clsUser which does several checks form permissions and other things. What I want is for clsUser to send status updates to clsUsage. ClsUser will be a dll but for now I've got it as a separate project in my solution. The RaiseEvent in clsUser seems to execute but the proc in clsUser that handles the event does not execute. I'm wondering if this is threading issue.
[Code]...
I have a script for uninstallation which I use to uninstall a developed application. For some reason I am getting the following message and the uninstallation is not working. The message is attached.The script for the uninstallation is follows:
Dim shell, systempath
set shell = WScript.CreateObject( "WScript.Shell" )
systempath = shell.ExpandEnvironmentStrings("%SystemRoot%")
[code].....
Private Sub DataGridView1_CellClick(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.CellClick
If e.ColumnIndex <> 3 Then
Exit Sub
[code]....
I am using the CellClick event to update DB column PaidStatus from Paid to Un-Paid and vice-versa....Once updated i want the updated data to be reflected..i am using DataGridView1.Refresh()....but it does not show the updated data from the DB..i have to close the application and re launch it to see the changes.
[ VB.NET 2008 ]
I'm facing new problem that MaxInputLength is not working in my code, my code is here.
I have set 12 for NQty . New Row allows only 12 chars but already existing rows are allowing more than 12.. so here maxinput lengh not working
i have set 7 for N1 Qty but it allows 7 chars for already existing and new rows because i did not assign any values to that column..
Private Sub Load_Grid()
With DataGridView1
.Columns.Clear()
[Code]....
I have the following code, what it should do it write 98 columns down and 15 columns across.but what it seems to be doing to just writing into the 1st column over and over again.
Dim TBF_IST_Min As DataTable = TBF_Dataset.Tables.Add("TBF Minutes")
' Add columns to the TBF_IST_Min table.
TBF_IST_Min.Columns.Add("0-2", GetType(Integer))
TBF_IST_Min.Columns.Add("2-3", GetType(Integer))
[code]....
I have a form with a button and a tabcontrol that has 2 tabs, on each tab I have 1 datagridview in them
both datagridviews are bound in the load event to a different bindingsource each.
When I click the button I fill the datatables programatically, and set some cells and columns on the datagridview to readonly.
The columns are set to readonly on both grids, but the cells are not. Only the cells in the first datagridview are being set to readonly and the cell on the second grid are not.
Further info:
If before clicking the button i switch to the second tabpage on the tabcontrol, and click the second grid on a column, and then go back to the first tabpage, the readonly cells are set fine when I click the button
If I press the button a second time, the readonly cells are set on both grids are set fine.
It seems to me that this error is presented on non-active (in lack of a better name) datagridviews.
I have tried, to call update, refresh, focus, endedit, etc etc on the click event of the button for the second grid but nothing seems to make it work.
I am running Windows Vista Ultimate. I have a copy of Visual Studios 2005. The toolbar is not working. I tried all of these and none of these fixed the toolbar:
-Show all (greyed out)
-Reset Toolbar
-delete C:UsersUsernameAppDataLocalMicrosoftVisualStudio8.0*.tbd worked one time then it did not.
I've updated my settings via:
My.Settings.SomeString = "new text"
then I call
My.Settings.Save()
When I check the .config file, the entry under
<userSettings>
<BE.IS.My.MySettings>
<setting name="SomeString" serializeAs="String">
[code]....
... the value remained the same, unchanged.1 thing though, my app is started via Sub Main() in module file, instead of "Enable application framework". Does this affect the saving of Settings file?
I have created a class module with this
Imports System.Data
Imports System.Data.OleDb
Public Class DefaultReport_New
[code].....
I tried using LockBits to blur images, since I heard it was faster, and there's no error, but there's no blur either. It doesn't do anything. The commented-out code is the code I had before using LockBits, and it works.
vb.net
Private Sub BlurImage(ByVal img As Bitmap, Optional ByVal radius As Integer = 3, Optional ByVal blur_bounds As Object = Nothing)
Dim bb As Rectangle
[Code]....
Im having a very strange problem.. I just copied the source code from one working application to this new application. It was working fine over there but not over here in new application. Neither it was showing any error nor updating the data. Below is the source code (method) that im using ..
public static void AppendViolations(string dsPath, DataTable dtSource, string PartitionID)
{
string ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=" + dsPath;
string SqlStatement = "select * from IncaViolations";
[code]....
I have a table in my database. I have an import routine which reads rows from and XML file. It first loops through my existing table to see if the row exists using a date and store code column as a unique id. It all works fine until this senario occurs.First file is read in and a new row is added for 01/03/2011, store code 100. The second file is read in which also has a row with 01/03/2011, store code 100. But when I loop through it does not find the row I just added so it adds it again.The only solution I can think of is to re-populate the local table everytime I add a new row but this will have a massive amount of over heads.If I add a row to an existing dataset surely if I loop through that dataset I should come across it.
View 2 RepliesI have a file called test.dat and for my OpenFileDialog I have:When the dialog opens, it looks correct, but when I choose DAT Files (*.dat), test.dat isn't shown.
View 5 RepliesProgram written and tested on XP x86 and then attempted to run it on windows 7 x86, but it just gives me the error '***** has stopped working'.I have checked it is being built for the correct platform (x86) and Win 7 has .Net framework 4 installed so i'm at a loss as to why it won't run. Some programs i've written work fine, some just crash.[code]
View 3 RepliesWith DataAdapter i passed a query and this is working....
Dim strSQL1 As String = "SELECT tbl_Items.GroupName, tbl_Items.ItemName, tbl_quantity.Quantity, tbl_quantity.QtyDate FROM (tbl_Items INNER JOIN tbl_quantity ON tbl_Items.ItemID = tbl_quantity.ItemID)WHERE(tbl_quantity.QtyDate = #12/29/2009#)"
Dim da1 As New OleDbDataAdapter(strSQL1, DataConn)
Dim dt1 As New DataTable
da1.Fill(dt1)
But when i give the date as this, not working...
Dim tmpDate As DateTime
tmpDate = System.DateTime.Now.Date
Dim strSQL1 As String = "SELECT tbl_Items.GroupName, tbl_Items.ItemName, tbl_quantity.Quantity, tbl_quantity.QtyDate FROM (tbl_Items INNER JOIN tbl_quantity ON tbl_Items.ItemID = tbl_quantity.ItemID)WHERE(tbl_quantity.QtyDate = " & tmpDate & " )"
I have eight labels which is supposed to get message using the tool tip. I have used code to set tooltip message using the following:
strinpErr = "Message for tooltip
Me.ToolTip1.SetToolTip(Me.lblinpErr, strinpErr)
ToolTip1.Active = True
But I am not getting any tooltip message.
vb.net
[Code]...
"The Vodafone Warriors under 20 side has lost in the last minute of their Toyota Cup final's match just moments ago.<br> <br> A Warriors Media release will be post as soon as it's sent." Can someone see why this would not work?
I am working on a mouse move for my project. How I do I set the messagebox to show if I have move the mouse, or if I have not move the mouse then show the messagebox?
View 5 RepliesI am reading the strings from the text file, but I would like to get the strings that come before the comma, then input the strings in the listbox.
[Code]...