Search results for query: *

I have set all cells (column headers, row cells) of the Datagridview to 8.25 tahoma. When the form is resized, all the column header fonts are resized, but the rowcells remains at 8.25. I checked and set all the dgv font properties that I can think of (defaultcellstyle ...

I created a bunch of usercontrol that I need to pass to a generic procedure that will copy and place them on a form. something like this: dosomething(usrCtl1) dosomething(usrCtl2) dosomething(usrCtl3) I tried this code but did not work. private sub dosomething(uc as UserControl) for i...

Environment: Visual Studio 2015 / .net 4.5.1 I am trying to create an excel file from my vb.net application. I am populating the file with database records. I was able to populate column A, but could not populate the rest of the columns. I got the code from docs.microsof.com and the code is...

Environment is : SQL Server 2012 and Access 2000 database Here is my code: IF OBJECT_ID('tempdb..#temptable') IS NOT NULL DROP TABLE #temptable; create table #temptable ( [LastName] varchar(50) ,[FirstName] varchar(50) ) INSERT INTO #temptable Select tbl1.LastName, tbl1.FirstName FROM...

I was hoping somebody can help mw with this, as I have been working on this for the past couple of days now. I am trying to automate unzipping of files as follows: Dim pinfo As New ProcessStartInfo pinfo.FileName = "C:\Program Files\7-Zip\7z.exe" Dim zipFile As String =...

I have a sql table with these data Year Country Ranking Category 2018 Ghana 1 Swimming 2018 Sweden 2 Swimming 2018 Costa Rica 3 Swimming 2018 Jordan 1 Sprint 2018 Thailand 2 Sprint 2018 Finland 3 Sprint 2018 Myanmar 1 Boxing 2018 Peru 2 Boxing 2018 Belgium 3 Boxing 2017...

I have an xml file that has the following entries: <Permission> <FormName>MainMenu</FormName> <ControlName>Submit</ControlName> <ControlProperty>Enabled</ControlProperty> <Supervisor xml:space="preserve">TRUE</Supervisor> <EXAMINER xml:space="preserve"> </EXAMINER>...

Need to lock a record after I select it and unlock it (even without updating). I also need to check if record is lock. Been googling this for quite some time now, found some articles on locking row from table but not from a view. When I implement on my view, did not seem to work. BEGIN TRAN...

I have multiple datagridview in my form, each bound to different list (of generic objects). I need to create one routine to sort (thru Column Header Click) of any of these datagridviews. I have a code that hard-code the field of the datasource as: _dsrc.OrderBy(Function(x) CInt(x.ID)).ToList...

I set-up the properties of a combobox in design time as follows: DropDownStyle = DropDown AutoCompleteMode = SuggestAppend AutoCompleteSource = ListItems I do not have an event for this combobox. Works fine, until I make a selection and somehow it triggered a button click, which is a database...

I have a form (A) that has a hyperlink to an edit form (B). I would like to see the changes reflected on form A, after I have edited the records on form B. I have this code in from B, A.Activate() A.Show() A.btn1.PerformClick() This works, but opens another instance of...

I am writing a sql server stored procedure that get passed multiple parameters. For one of the parameter, I have this pseudo-code ..... where (@param1 is null or col1 = @param1) and (@param2 is null or col2 = @param2) and (@param3 is null or (case when @param3 = 1 then...

I am trying to implement this functionality in a data entry form for my application. The form will have a datagridview (dtgOffices) with 8 columns.. First column is a datagridviewtextboxcolumn, three datagridviewcombobox columns and another datagridviewtextboxcolumn, that will indicate if this...

I created a user control (CorpControl) with a handful of controls as text boxes (txtTaxID) , combo boxes (cboHQ), button and datetimepickers. Public Class CorpControl Private Sub CorpControlControl_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load...

I have created multiple datagridview at design time named dgv1 thru dgv50. And the following records from a datatable dt Column1 Column2 123 0 138 1 367 2 278 3 367 4 259 5 .... .. 145 9 Need to do a for loop to populate the dgv's with column1 data such that...

I have 50 text boxes on my tab page(tab1) named tbx1, tbx2 etc... I am trying to populate these text boxes with data from a datatable For i as integer = 0 To dt.Rows.Count - 1 tab1.Controls("tbx" & (i + 1).ToString).Text = dt.Rows(i).Item("VALUES").ToString next I also tried For i as...

I am trying to validate a date field from a sql server DB, and Ii is raising error - "Conversion from string "" to type 'Date' is not valid" or Conversion from DBNull to type 'Date' is not valid". Validation is for loading a datagridview with datatable thru a BindingSource. Here is my date...

I have a sub that creates an excel file and populate it with records from a datatable. The event that calls this sub will loop thru multiple datatable and create different worksheet in the same excel file, without saving the file. Does anybody know how I can code this? My current code creates...

My table has a varchar column that contains 5-digit numeric values. When I use the like query to filter, I am not getting the expected resultss. ZipCode 20019 10027 00199 10019 ... ... This is my condition where zipcode like '%0019%' Condition only returns 20019 10019 but not 00199 Any...

I create the following button and maskedtextbox dynamically, as well as other controls. cntrl = New MaskedTextBox() newControl(cntrl, "mtbSSN", "", "000-00-0000") cntrl = New Button() newControl(cntrl, "btnSearchSSN", "Search SSN) Private Sub newControl(ByVal...