- Upvotes Received
- 1
- Posts with Upvotes
- 1
- Upvoting Members
- 1
- Downvotes Received
- 0
- Posts with Downvotes
- 0
- Downvoting Members
- 0
I am an Independent Consultant specializing in C# .NET development as well as SQL-Server.
22 Posted Topics
![]() | Re: Fortran, C/C++ are the most powerful programming languages. They are used to program the most powerful computers, super computers. |
Re: If I am not mistaken, the 102MB OEM partition contains Dell Diagnostics. | |
Re: Inserting data(T-SQL insert) and dumping a database(backup) are unrelated database operations. Please explain your problem. BTW: I do not see where your OleDbConnection is instantiated nor where the connection string is specified. | |
Re: There are a number of bad design decisions evident here. 1. No real application uses Application.DoEvents.(VB6 is not a real programming language). 2. Peeking and Poking data into ANY control is just plain wrong. 3. Why aren't you using MVVM? DataBinding? 4. Multithreading (ThreadPool.QueueUserWorkItem) to display a dialog on background … | |
Re: There are several. Depends on what kind of computer. How much USD do you want to spend? Desktop: Intel® Core™ i7-5960X Processor Extreme Edition BOX : $1059.00 Server: Intel® Xeon® Processor E7-8891 v2 (37.5M Cache, 3.20 GHz) TRAY: $6841.00 Mobile: Intel® Core™ i7-4940MX Processor Extreme Edition (8M Cache, up to … | |
Re: when is not an sql keyword used with t-sql insert. The only reference to insert & when is pl/sql and then the syntax is "insert when" | |
Re: ListViews display lists of data. So first you need a data class. Second, a collection List<Data> as the ItemsSource for your ListView. Third, in Settings.settings a Name, of type string, with Scope of User. Now you can serialize/deserialize List<Data> to settings. [Serializable] public class TestMe { public TestMe() { } … | |
Re: You do NOT remove rows from the DataGrid. Remove them from the DataSource. | |
Re: Well you've a try/catch block. What does the exception tell you? Don't just look at the Message. Examine the StackTrace and other fields also. What value does ExecuteNonQuery return? 0, 1 or -1? | |
Re: Examine the exception thrown. This will provide the info needed to track success/failure of System.IO.File.Move. http://msdn.microsoft.com/en-us/library/system.io.file.move%28v=vs.110%29.aspx Of course checking File.Exists will head-off the exceptions. | |
Re: Check Request.QueryString("UserEmail"). Is the value null? Note that the return type is string, so the '.ToString()' should be removed From MSDN: The following code example shows two ways to get the value of a query string variable named “fullname”. In each case, if the URL is http://www.contoso.com/default.aspx?fullname=Fadi%20Fakhouri, then the value … | |
Re: @Beta_1 No threading issues here. Use the Profiler to determine where the bottleneck is. Hint: it's not in the program logic. I would question why 100,000+ characters are being loaded into a textbox. I would also question why you are using Winforms & not WPF for ALL of this application. … | |
Re: Execute the stored proc and get the resultant Recordset. Then call .RecordCount Set rstAttchCount = cmdAttachCount.Execute rstAttchCount.RecordCount You may have to set the CursorLocation to adUseClient. The default is adUseServer The cursor type of the Recordset object affects whether the number of records can be determined. The RecordCount property will … | |
Re: You can use @"db\". The @ tells the compiler not to treat the \ as an escape character. From MSDN: because the backslash (\) is an escape character, literal backslashes in a string must be escaped or the entire string must be @-quoted. | |
Re: In line 4, has m_previewService been set to null? Is viewer null? viewer.LocalReport? viewer.LocalReport.GetType().GetField("m_previewService", Flags) Let us not overlook the obvious. | |
Re: You need to iterate over all cells BEFORE deletion. ie. foreach(Cell cell in row.Cells){...} If row.Cells(0).FormattedValue = True Then WriteCellValuesToFile(row); // new method Sql = "DELETE FROM member WHERE id = '" | |
Re: You need to join the vehicle_entry and booking tables. Hint: Inner vs. Outer Join I assume your UI has a calendar(theDate) & the ComboBox (AvailableVehicles). So the available vehicles (vehicle_entry) for a particular day (where booking.Date == theDate) will NOT have a related booking row. AvalableVehicles = new ObservableCollection<Vehicle>(); ComboBox1.DataSource … | |
Re: Don't use FileInfo. Load the file contents into a buffer (byte[]) and transmit the filename and buffer size in a well defined header(fixed length/format). Follow the header with the variable length byte[]. | |
Re: These constants are defined in WinUser.h You probably need to remove WS_THICKFRAME. | |
Re: You should have a class for your model. The model should have a property which exposes the collection of data. This becomes the DataSource for both DataGridViews. | |
Re: Do not think about ListBoxItems. Think about data. What you should be doing is storing the data in the file. Since you are specifying the file layout, I'd recommend creating a repository class for loading/storing the data. Look at System.IO for classes to do the low level io. | |
Re: Congratulations on using WPF. As a WPF developer one does NOT iterate over the items in ANY control. What you should be doing is iterating over the collection that constitutes the Items control's DataSource. |
The End.