- Strength to Increase Rep
- +0
- Strength to Decrease Rep
- -0
- Upvotes Received
- 14
- Posts with Upvotes
- 13
- Upvoting Members
- 10
- Downvotes Received
- 1
- Posts with Downvotes
- 1
- Downvoting Members
- 1
 | Hi all I have a script to update the value from datagridview to database I do use a button insert ToolStripButton but not working hope people to help thank ! Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load conn = New SqlConnection("") conn.Open() Dim query As …  |
 | The following (see the full code below) successfully adds a page in a section in Onenote. What I don't seem to be able to do is to get the lastly created page on top of the section. Here's the code that is puzzling me. onenoteApp.GetHierarchy(sectionId, OneNote.HierarchyScope.hsPages, out string xmlPages); var … |
| | I prepare a table in Excel within a Using () statetement. At the end I UsedRange.Copy() to what I understand is the clipboard. Then I Selection.PasteExcelTable in a Word document. I get an COM Exception "command failed". When I activate the word document and press Ctrl+V the table gets copied. … |
| | When I execute this progammatically, I get a table with row heights much larger than when I do this manually. Note : Sel is the Word.Selection object and the Clipboard contains an Excel Table. public void AddClipboard() { Sel.PasteExcelTable(false,false, false); var t = Sel.Tables[Sel.Tables.Count]; t.AutoFitBehavior(Word.WdAutoFitBehavior.wdAutoFitContent); } |
| | Hi have this code that runs well for me. It's part of my WordWrapper where Sel is defined as the Selection object. I tried to save `Sel.Font to a var f` variable, and reset `Sel.Font = f`before exit, but that does not work. "Value out of range". /// <summary> /// … |
 | Hi group, I'm discovering that my Excel spreadsheets that are being created by a VB.net app I've written isn't completely closing them as they should be. I'm struggling to understand why and how to fix this. Here is the code for the portion of the app that creates the workbook, … |
 | I use VB.net 2012 and Newtonsoft.Json Here my code Public Class Order Public Property nb As Integer Public Property product As String Public Property price As String End Class Public Class Person Public Property nb As Integer Public Property name As String Public Property address As String End Class Dim … |
| | I cannot find anything in phpExcel documentation. What I would like is to end up with an associative array with keys from the first row in the excel worksheet. It's something that can be done of course, but is there a native method? |
| | I'm using Excel interop and it seems that this functionality needs to run in the User Interface thread. So I execute that from the ProgressChanged backgroundworker event. Is there a way to have the dowork event (that invoked the progress changed event) interrupt execution until the ProgressChanged event is finished? …  |
| | I have this Linq expression that works well. What is the right approach to test if it has returned anything? internal static void getCreditNotes(string invoiceId, out DataTable creditNotes,out double total) { total = 0; creditNotes = new DataTable(); var q = dt.AsEnumerable(). Where(r => (string) r["invoiceId"] == invoiceId && (string) … |
| | I may be very wrong, but in the web world, just installing Bootstrap gives you some basic control over how you controls look. Is there something similar for WPF? I don't seem to find anything, I have a very basic little wpf application with a pageframe, buttons, textblocks and textboxes. … |
| | I have this control on my (wpf)form Status <TextBlock x:Name="Status" HorizontalAlignment="Left" Margin="138,0,0,0" TextWrapping="Wrap" Text="TextBlock" VerticalAlignment="Top" Grid.ColumnSpan="3" Height="67" Width="577" Grid.Row="1" IsHyphenationEnabled="True" UseLayoutRounding="False"/> It seems that just setting Status.Text=someValue from within a click event does not refresh until the event is completed. How can this be done (in C#) if one wants …  |
| | Hi, having code placed below, I cannot clue out, how to convert query in FilterData() to a dynamic query. Any ideas how to do it? Thanks in advance for any hint. Martin public class Item { public DateTime SampleDate; public List<String> Columns = new List<String>(); //this stores all columns } … |
| | How to copy a word table multiple times to a specific place using VB.Net 2010? I have viewed the other responses and these seem just not to work. I am working on a VB.Net 2010 program using the Interop class. We are having problems trying to duplicate a table more … |
| | There is no **"Microsoft Outlook 14.0 Object Library"** in my **visual studio 2008 reference COM** List how can i update it. Thanks |
| | Hi guys I tried to to use inner join on 5 tables it worked but the problem is instead of getting the exact sum values it got doubled. Here's my code cmd = New OleDbCommand("SELECT om_list.invoice_no as invoice_no, om_list.internal_id as internal_id, om_list.customer_id as customer_id, om_list.account_name as account_name, om_list.seller_name as seller_name, … |
| | Hello, I am experiencing a very unusual problem. If an exception occurs within my Frm_Load method which handles MyBase.Load, the method simply ends, a nice message is printed to the debug windows explaining the error, and program execution continues. The problem is, I want an error in the Load method … |
| | tables: T_THERA - is a transaction table Columns: ID - STRING MR - STRING ITEMCODE - STRING QTY - INT SIGNA - TEXT M_ITEMS - Masterfile of items Columns: ITEMCODE - STRING DESCRIPTION - STRING M_SIGNA - Masterfile of Signa Columns: SIGNACODE - String DESCRIPTION - String I have a … |
| | I have created a currency textbox formatting with the _Validating event. I use this formatting for six textboxes that have to have their values added. So what happens is after I typed in an amount and left the textbox, the amount (the text I inputted) becomes formatted, and the 'Total' … |
| | I am currently confused and not sure why. I believe I have stared at this for to long. I am currently just trying to populate a ComboBox with the data that is read in from a SQL DB through a SQL query. Currently I have the below code. I am … |
 |
Re:
Main form i don't know why i have this error in my code: ' ' Created by SharpDevelop. ' User: s11088659 ' Date: 5/26/2014 ' Time: 9:44 AM ' Lab 8 ' ' To change this template use Tools | Options | Coding | Edit Standard Headers. ' Public Partial Class resultex … |
 | ## Disclaimer ## Full disclosure, this is a problem I've recently encountered at work. I couldn't find a reasonable solution and ended up recommending a logistics approach rather than a full code approach to solve it. The code performs a subset of required functionality to give users more options, but … |
| | I am having trouble getting a correct response when searching through each of my datarows. While stepping through during debugging, I am seeing the boolean response is getting triggered even if one row does not match my selected string. I just want to search all of the rows and if … |
| | Dim dr As OleDb.OleDbDataReader = GetData(qry) If dr.HasRows = True Then Do While dr.Read TextBox32.Text = dr.Item("total") If Val(TextBox32.Text) > 800 Then TextBox37.Text = Val(TextBox32.Text) - 800 Else TextBox37.Text = 0 End If TextBox38.Text = Val(TextBox36.Text) + Val(TextBox37.Text) TextBox31.Text = (Val(TextBox33.Text) + Val(TextBox32.Text)) * Val(TextBox34.Text) Loop Else If MsgBox("Fuel allowance …  |
| | i have 2 tables one holds and id number for a transaction and the other tables holds the data for that transaction i can populate the first datagridview with the "id" data. I want to be able to select the row on the datagridview (id) and show the details for … |
| | I have this line of code which gets the activation date of an agent and computes the difference between date.now to get the date difference: Dim dt As New DataTable dt = ExecQuery("select agtid,Activation from tblagentinfo") If dt.Rows.Count > 0 Then Dim activation As String For i As Integer = … |
| | I have a form with a dgv on it. The dgv has 1 column defined as a DataGridViewCheckBoxColumn. I would like this dgv to behave as a radiobutton group, i.e. when I click on one cell, that should be set to true, and the others to false. I've got it … |
| | For this project, my client asked me if he could select seven names from the list (which is a DataGridView) and use them in a single, separate form. The solution that came to my mind is to use the CheckBoxColumn for this matter. My problem is I have never used … |
| | I would like to write string list items into a single line.At the moment when I do the write,it breaks the line with newline feeds with multiple lines.See section from code below: List<String> stringList = new List<String>(); stringList.Add(line1); while (line2 != null) { if ( line1.Length >= 8 && line2.Length … |
| | Hi.....Is it possible to place live tiles or animated tiles in c# windows forms? if not what is the best way to display message when i move cursor over the button....to display message using tooltip or something like that which would be atrractive to see that message display....?? any ideas … |