Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
100% Quality Score
Upvotes Received
1
Posts with Upvotes
1
Upvoting Members
1
Downvotes Received
0
Posts with Downvotes
0
Downvoting Members
0
0 Endorsements
Ranked #2K
~13.4K People Reached
About Me

I am an Independent Consultant specializing in C# .NET development as well as SQL-Server.

Favorite Tags

22 Posted Topics

Member Avatar for vjcagay

Fortran, C/C++ are the most powerful programming languages. They are used to program the most powerful computers, super computers.

Member Avatar for vegaseat
-1
4K
Member Avatar for Violet_82
Member Avatar for Taufique111

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.

Member Avatar for mark261511
0
167
Member Avatar for Stacy_1

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 …

Member Avatar for harshchandra
0
202
Member Avatar for rubysethi

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 …

Member Avatar for almostbob
-2
132
Member Avatar for Xiao_1

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"

Member Avatar for SteveDotNet
0
341
Member Avatar for OMER AHMED

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() { } …

Member Avatar for Santanu.Das
0
1K
Member Avatar for kau14
Member Avatar for col-lino

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?

Member Avatar for SteveDotNet
0
733
Member Avatar for Stacy_1

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.

Member Avatar for SteveDotNet
0
232
Member Avatar for Blueie

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 …

Member Avatar for Blueie
0
810
Member Avatar for Beta_1

@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. …

Member Avatar for Beta_1
0
211
Member Avatar for djblois

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 …

Member Avatar for SteveDotNet
0
646
Member Avatar for sameh_1

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.

Member Avatar for SteveDotNet
0
415
Member Avatar for Maideen

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.

Member Avatar for SteveDotNet
0
354
Member Avatar for hfuehf

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 = '"

Member Avatar for SteveDotNet
0
108
Member Avatar for Nova6112

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 …

Member Avatar for SteveDotNet
0
147
Member Avatar for overwraith

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[].

Member Avatar for SteveDotNet
0
157
Member Avatar for rfresh
Member Avatar for SteveDotNet
0
183
Member Avatar for rahulzephyr

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.

Member Avatar for ddanbe
0
147
Member Avatar for Mr._1

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.

Member Avatar for SteveDotNet
0
309
Member Avatar for burhanahmed92

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.

Member Avatar for SteveDotNet
0
2K

The End.