How to Change the Data Type of a Column Using T-SQL

Submitted by admin on
There are some cases that you need to change the data type of a field in SQL Server by not using the Management Studio Tools. The reason is if your database is replicated. You cannot change it directly using the management studio tools so your best option is to use T-SQL. In my case I have a column name “TransDate” that has a datetime datatype.

How to Differentiate Two Cell Values in DataGridView Control

Submitted by admin on
I read a lot of question about this on the forum and thought it’s time to share with you on how to differentiate two cell values in DataGridView control. By default we use the Value property of cells like: QtyOrdered = InvoiceDetails("Qty", e.RowIndex).Value Another is to use the FormattedValue like: QtyOrdered = InvoiceDetails("Qty ", e.RowIndex).FormattedValue But the two code above will not work if you have a condition like If QtyOrdered > InvoiceDetails ("TotalQty", e.RowIndex).Value Then to determine if the Qty Ordered is less than the

File Search And Destroy

Submitted by euverve on
I coded a simple utility that removes files based on file hash because some malwares or virus spreads in every folder in usb or drive. This is threaded so while searching the form will not hang. Souce Codes: Public Class Mainform Private Sub Form1_Load ( ByVal sender As System . Object , ByVal e As System .EventArgs ) Handles MyBase .Load Control .CheckForIllegalCrossThreadCalls = False End Sub

LoadData in Datagridview

Submitted by xiankaylle on
This is a simple program that load datas from MysSql Database Applying Object Oriented Programming I hope this sample will help you guys! Thank you! and God Bless! in order to run the Program make Sure that you have Mysql in your System Unit and Follow the instructions below. NOTE PLEASE READ THIS: http://iseesharp.blogspot.com/2006/09/connecting-mysql-and-c.html
Subscribe to