Agusto Xaverius P Sipahutar : VB.Net

How to deploy the Crystal Reports 2008 Basic Runtime

agusto — Fri, 31 Jul 2009 17:46:00 GMT

Waktu itu saya pernah memposting mengenai deployment Crystal Report dengan menggunakan Crystal Report Visual Studio 2005 (link: http://geeks.netindonesia.net/blogs/agusto/archive/2009/03/29/crystals-report-deployment-using-net-framework-2-0-merge-modules.aspx).

Pada saat saya sudah menggunakan Visual Studio 2008 dan ingin melakukan merge module itu kembali untuk di patch ke client server ternyata cara itu tidak adalagi di Visual Studio 2008. Pada Visual Studio 2008 sudah tidak sertakan lagi .msm (Merge Module) files tersebut, tetapi dari installasi Visual Studio 2008 kita sudah di sertakan 2 file .msi yang langsung di bisa diinstall client server kita.

2 Files itu adalah CRRedist2008_x86.msi (untuk environment x86) dan CRRedist2008_x64.msi (untuk environment x64).

Di OS yang saya miliki 2 files itu berada di C:\Program Files (x86)\Microsoft SDKs\Windows\v6.0A\Bootstrapper\Packages\CrystalReports10_5.

Tetapi bila memang ingin mengetahui dimana 2 files .msi itu berada, bisa dilakukan dengan membuat setup installasi dan setelah itu klik kanan –> properties dan setelah itu pilih prerequisites. Dan setelah itu compile maka CRRedist2008_x86.msi dan CRRedist2008_x64.msi akan di copykan ke setup installer project kita.

Selamat mencoba

Share this post: | | | |

Most Useful 20+ Visual Studio Add-ins

agusto — Fri, 23 May 2008 05:23:00 GMT

This is the list of the Visual Studio Add-ins, most of which are open source or free. I hope this list will help you to code more faster and effective. If there is not your favorite add-in in the below list, do not hesitate to add it as a comment.

TestDriven.NET - makes it easy to run unit tests with a single click, anywhere in your Visual Studio solutions. It supports all versions of Microsoft Visual Studio .NET and it integrates with the best .NET development tools including NCover, NCoverExplorer, Reflector, TypeMock, dotTrace, NUnit, MbUnit, ZaneBug, MSBee & Team System.
AnkhSVN - is a Visual Studio .NET addin for the Subversion version control system. It allows you to perform the most common version control operations directly from inside the VS.NET IDE. Not all the functionality provided by SVN is (yet) supported, but the majority of operations that support the daily workflow are implemented.
C# Refactory - performs a large number of refactorings, allowing you to re-shape your c-sharp code as needs arise. Refactoring is an essential part of the extreme programming development approach. C# refactory enables you to automate many refactorings thus increasing the reliability and speed with which you can refactor your c-sharp code.
GhostDoc - is a free add-in for Visual Studio that automatically generates XML
documentation comments for C#. Either by using existing documentation inherited
from base classes or implemented interfaces, or by deducing comments from
name and type of e.g. methods, properties or parameters.
SharpTools is an extensible add-in to the Microsoft Visual Studio.NET development environment, and a software development kit (SDK) supporting the rapid development of further extensions which will run within SharpTools.
Google Plugin - Search Google from Visual Studio .NET
Resource Refactoring Tool - provides developers an easy way to extract hard coded strings from the code to resource files.
BIDS Helper - A set of VS.Net add-ins that extend and enhance the functionality of the SQL Server BI Development Studio.
Power Toys for Visual Studio - are small tools that provide aid to developer pain-points or assist in diagnosing development-related issues. In addition to providing support, the power toys are released as Microsoft Shared Source to provide sample code to real-world solutions and allow for collaborative-development.
Koders IDE - enable software developers to perform Koders searches directly from within the Eclipse or Visual Studio development environments by extending the reach of the Koders.com open source code index to the desktop.
Codekeep - Once you've downloaded and installed a CodeKeep add-in, you can manage your code snippets and search for other code snippets without ever having to leave Visual Studio.
CodeShare - Add-in is a Visual Studio.NET plugin for sharing code snippets in an enterprise. It provides menu options within the IDE to contribute and find code snippets from a central repository.
RSS Blog Reader - open source add-in and a full-featured RSS / Blog aggregator which integrates into the familiar dockable panes of the Visual Studio.NET IDE.
csUnit is a free and open source unit testing tool for the .NET Framework. csUnit works with all .NET languages including C#, Visual Basic .NET, J#, and managed C++. It comes with a choice of command line, graphical user interface, and an addin for Visual Studio.
Oracle Developer Tools for Visual Studio .NET - The Oracle Developer Tools for Visual Studio .NET (ODT) is a tightly integrated Add-in for Microsoft Visual Studio. Features are generate SQL scripts for Oracle schema, generate ASP.NET web applications with very little coding required, drag and drop and automatically generate .NET code, seamlessly step from your .NET code into your PL/SQL stored procedure code and back out again, etc...
WSCF - A Free Visual Studio Add-In and Command Line Tool for ImprovedSchema-Based Contract-First Web Services Design and Programming
ZipStudio - provides a means of zipping up complete or partial Visual Studio solutions and projects and associated files, directly from in Visual Studio itself.
MySQL Developer Tools is a powerful add-in designed to simplify the MySQL database application development process. It integrates into Visual Studio and Delphi, making all database development and administration tasks available from your favorite IDE. It provides an easier way to explore and maintain existing databases, design compound SQL statements, query and manipulate data in different ways.
Comment Reflower - is an Add-in for Visual Studio 2003 and 2005 to reflow the text in comments in source files to have even word wrapping. It does more than simply just wrapping all text in comment blocks.
VSCmdShell - provides users with a shell window inside the Visual Studio IDE that can be used for Visual Studio commands as well. Current version allows user to use either Windows Command Shell (cmd.exe) or Windows PowerShell.
IBM Database Add-ins - development Add-In and managed provider for the Microsoft .NET platform includes RAD features, DB2 database project, scripting wizards, and CLR stored procedures to simplify building DB2 applications using Visual Studio .NET.
VSdocman is a tool for commenting and the quick automatic generation of class documentation from your C# and VB .NET source code files. It is ideal tool for you if you create .NET component, control, application, smart device or web site (ASP .NET) projects
CopySourceAsHtml - An add-in for Microsoft Visual Studio 2005 that allows you to copy source code, syntax highlighting, and line numbers as HTML. CSAH uses Visual Studio's syntax highlighting and font and color settings automatically.
Codexchange - is an Visual Studio.NET add-in providing you with instant integrated access to an online repository of ready to use .NET code snippets
ADO.NET Express - is an add-in for Visual Studio 2003 that automates common tasks of writing repetitive data access code. ADO.NET Express generates class methods for calling stored procedures and executing common types of SQL statements.
VSTypeFinderAddin - for Visual Studio 2005 provides the possibility to search for all classes, structs, enums and delegates in a solution.
AopDotNetAddIn - is a Visual Studio AddIn that provides the aspect oriented capabilities to the .Net languages (C#,VB.Net,J#), this AddIn was developed as a graduation project
Reflector is the class browser, explorer, analyzer and documentation viewer for .NET. Reflector allows to easily view, navigate, search, decompile and analyze .NET assemblies in C#, Visual Basic and IL.

[Updated 25/07/2007]

DPack– Free collection of VS .NET 2003 and 2005 tools. Brings tools designed for greatly increase developer’s productivity, automate repetitive processes and expand upon some of VS features.
Regionerate (pronounced ri-jeh-neh-rate) is a new open-source tool for developers and team leaders that allows you to automatically apply layout rules on C# code.
Consolas is intended for use in programming environments and other circumstances where a monospaced font is specified. All characters have the same width, like old typewriters, making it a good choice for personal and business correspondence. Optimizing the font specifically for ClearType allowed a design with proportions closer to normal text than traditional monospaced fonts like Courier. This allows for more comfortable reading of extended text on-screen.
Project MRU Cleaner Add-In
Explore In Windows Add-In for Visual Studio 2005

Resources and Articles on Visual Studio Add-in

for detail info you can click on this link : http://www.plentyofcode.com/2007/07/most-useful-top-15-visual-studio-add.html

Share this post: | | | |

NDoc For .Net 2.0

agusto — Thu, 03 Aug 2006 19:50:00 GMT

NDoc generates API documentation from .NET assemblies and XML documentation comment files.
The current stable version of NDoc (1.3.1) only supports the .Net framework versions 1.0 and 1.1. This versions is being developed by Jonas Lagerblad and supports the .Net framework version 2.0

These downloads are offered as a mirror of the official files. Please make sure you check http://jonas.lagerblad.com/blog/?p=4 for updates.
Downloads
ndoc-bin-1.3.1-v13.zip
ndoc-src-1.3.1-v13.zip.

Share this post: | | | |

Xml Web Service dengan SOAP dan Visual Basic 6.0

agusto — Tue, 01 Aug 2006 13:27:00 GMT

Xml Web Service dengan SOAP dan Visual Basic 6.0

Di web service .net akan kita bisa lihat penjelasan SOAP seperti ini : SOAP
The following is a sample SOAP request and response. Method nya :

POST /_vti_bin/routingservices.asmx HTTP/1.1
Host: wsstemplate
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: "http://www.plasmedia.com/ffi/SharepointRoutingWS/GetDepartmentList"

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<GetDepartmentList xmlns="http://www.plasmedia.com/ffi/SharepointRoutingWS">
<listName>string</listName>
</GetDepartmentList>
</soap:Body>
</soap:Envelope>

Result yang akan di hasilkan :

HTTP/1.1 200 OK
Content-Type: text/xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<GetDepartmentListResponse xmlns="http://www.plasmedia.com/ffi/SharepointRoutingWS">
<GetDepartmentListResult>
     <DeptInfo>
                 <ID>string</ID>
                 <Name>string</Name>
      </DeptInfo>
      <DeptInfo>
                 <ID>string</ID>
                 <Name>string</Name>
      </DeptInfo>
</GetDepartmentListResult>
</GetDepartmentListResponse>
</soap:Body>
</soap:Envelope>

Penggunaannya di visual basic 6.0 / VBA :

Dim xmlhttp, xmldom
Set xmlhttp = CreateObject("Microsoft.XMLHTTP")
set xmldom = CreateObject("Microsoft.XMLDOM")

Dim sEnvelope
Dim szUrl
szUrl = "http://wsstemplate/ffi/_vti_bin/routingservices.asmx"

sEnvelope = "<soap:Envelope xmlns:xsi=""http://www.w3.org/2001/XMLSchema-instance"" xmlns:xsd=""http://www.w3.org/2001/XMLSchema"" xmlns:soap=""http://schemas.xmlsoap.org/soap/envelope/"">"

sEnvelope = sEnvelope & "<soap:Body>"
sEnvelope = sEnvelope & "<GetDepartmentList "
sEnvelope = sEnvelope & "xmlns=""http://www.plasmedia.com/ffi/SharepointRoutingWS"">"
sEnvelope = sEnvelope & "<listName>Department Info</listName>"

sEnvelope = sEnvelope & "</GetDepartmentList></soap:Body></soap:Envelope>"

xmlhttp.Open "POST", szUrl, False
xmlhttp.setRequestHeader "Content-Type", "text/xml"
xmlhttp.setRequestHeader "SOAPAction", "http://www.plasmedia.com/ffi/SharepointRoutingWS/GetDepartmentList"
xmlhttp.send (sEnvelope)

If (xmlhttp.readyState = 4) Then

If (xmlhttp.Status = 200) Then
      xmldom.async = False
      xmldom.loadXML(xmlhttp.responseText) 'Hasil ini akan di hasilkan result XMl sesuai dengan hasil yg jelaskan diatas
      msgbox xmlhttp.responseText

End If
End If

Set xmldom = Nothing
Set xmlhttp = Nothing

Share this post: | | | |

Upload File to Database SQL Server 97/2000

agusto — Tue, 25 Apr 2006 19:41:00 GMT

Ini bisa di sebut dengan BLOB / Binary Large Object. Jadi pastilah document ataupun image yang kita punyai akan di konvert ke binary dulu setelah itu simpan ke data base kita dengan type binary juga.

Contoh bisa di lihat di MSDN cari dengan keyword BLOB, di sini juga saya berikan contoh nya :

Imports System Imports System.Data Imports System.Data.SqlClient Imports System.IO Public Class TestBLOB
	Public Shared Sub Main()
		AddBLOBtoDatabase()
	End Sub
	Public Shared Sub AddBLOBtoDatabase()
		Dim byFile() as Byte = GetPhoto(“C:\test.txt“) SqlConnection conn = new SqlConnection("Data Source=localhost;Integrated Security=SSPI;Initial Catalog=TESTDATABASE;"); SqlCommand cmd = new SqlCommand("INSERT INTO DOCS ([Document]) " + "Values(@File)", Conn); cmd .Parameters.Add(“@File", SqlDbType.Image, photo.Length).Value = byFile; conn.Open(); // Open Connection cmd.ExecuteNonQuery(); //Execute Query conn.Close(); //Close Connection
	End Sub
	Public Shared Function GetFile(sFilePath as string) as byte()
		Dim fs As FileStream = new FileStream(sFilePath, FileMode.Open, FileAccess.Read) //read File Dim br As BinaryReader = new BinaryReader(fs) Dim byFile() As Byte = br.ReadBytes(fs.Length) br.Close() fs.Close() Return byFile
	End Function

End Class

Share this post: | | | |

Working Load XML with XPATH and Namespace

agusto — Wed, 21 Dec 2005 15:59:00 GMT

Tips yang mungkin bisa berguna

Bila kita mempunyai XML data yang menggunakan Namespace tetapit tidak memiliki perfix, akan terjadi sedikit masalah dalam pembuatan query pada XPAT di XML.

Misalnya datanya sebagai berikut :

<CodeFile xmlns="urn:sample:CodeFile">
<RetailerId>56d1a8f6-f748-405d-90dd-c20dea1053deRetailerId>
<Store>
<StoreID>faeb5402-3202-4f46-a530-0c631ac054eeStoreID>
<Till>
<TillID>90ccda47-939d-46c2-b705-30d83b0f5f3fTillID>
<Genre>
<Genre>RewardGenre>
<CodeGroup>
<Telco>1Telco>
<Divider>500Divider>
<LowValue>0LowValue>
<HighValue>20000HighValue>
<Action>AddAction>
<Codes>
<Code>008225996472286053Code>
<Code>007133082893966958Code>
Codes>
CodeGroup>
Genre>
Till>
</Store>
CodeFile>

Sedikit kendala pada xml ini adalah namespace ada tapi prefix tidak ada bisa di lihat pada tag xml ini :
<CodeFile xmlns="urn:sample:CodeFile">,
Namespace nya adalah urn:sample:CodeFile

Tetapi prefix tidak ada.

Pada tag tag yang akan kita query akan sedikit bermasalah karena node tersebut tidak akan bisa di load di XPATH bila namespace dan prefix tidak di set pada XPATH nya dengan benar.

Sehingga kita harus mengupayakan XML ini mempunyai namespace dan prefix dan kita bisa load dengan benar.

Konsepnya adalah kita load XML ini update xmlns="urn:sample:CodeFile" sehingga mempunyai prefix misalnya kita buat prefixnya akan menjadi spt ini xmlns:M="urn:sample:CodeFile". Jadi nantinya XML tersebut memiliki prefix yaitu M.

Contoh Sintaxnya adalah sebagai berikut :

StreamReader myStremReader = System.IO.File.OpenText(sfilename); // Load data xml fisik filenya
string strTmp = myStremReader.ReadLine(); //read satu baris
myStrBuilder.Append(strTmp.Replace("xmlns=","xmlns:M=")); //update xmlnya sehingga memiliki prefix
myStrBuilder.Append(myStremReader.ReadToEnd()); //read sisa datanya dan semua nya di gabungkan kembali di StringBuilder
myStremReader.Close(); //Close load file

Dan sisanya bisa lakukan XMLNameSpaceManager,XPATH seperti biasanya

Share this post: | | | |

Embedded Icon / Image to Resources

agusto — Wed, 23 Nov 2005 14:23:00 GMT

CMIWW.

Biasanya kita melakukan load image atau icon seperti code sebagai berikut
public Form1(){
//Load a file from the file system
this.BackgroundImage = new Bitmap(@"C:\image\wallpaper.jpg");
}

Kelemahan coding adalah pada saat penginstalan ke client pastikan folder dan file tersebut berada di yang kita inginkan bila tidak applikasi tidak akan menload image yang ada karena memang tidak ada di folder tersebut.
Ataupun kita melakukan dengan menggunakan applikasi path tempat applikasi berada dan file image/icon tersebut ada di folder tempat penginstalan dan ternyata file di terdelete secara manual.Salah satu solusi yang bisa kita lakukan adalah image / icon yang kita inginkan kita embedded ke applikasi kita.
Hal-hal yang di lakukan :
1.Copy file kita inginkan ke solution applikasi kita.
2.Set property di image/icon yang ada
Pada property Build Action set menjadi Embedded Resource
3.Load File programming.

using System.Reflection;
//tambahan namespace ini pada applikasi window formnya

namespace TEST

{
static void ()

{
   Application.Run(new Form1));
   Assembly myassem= this.GetType().Assembly;
   System.IO.Stream streamico = myassem.GetManifestResourceStream(this.GetType ().Namespace.ToString () +         ".GEARS.ico");
    this.Icon new Icon(streamico);

    //Atau yang Form background imagenya
    System.IO.Stream streambgk = myassem.GetManifestResourceStream(this.GetType().Namespace.ToString()+ ".wallpaper.jpg");
    this.BackgroundImage = new Bitmap(streambgk);
}

}//ending namespace

Share this post: | | | |

Free .NET Development Tools

agusto — Wed, 02 Nov 2005 14:38:00 GMT

This some free .Net Development tool and all that stuff is really “FREE“

1. Nant

Namt is a build tool. Build scripts are written that can perform tasks on your build server. Tasks are a-plenty, but typical tasks include the ability to build .NET solutions, run unit tests, copy files, make and delete directories and many more. In fact, with the ability to write custom takss for Nanr, there are plenty of possibilities.

Url : http://nant.sourceforge.net/

2. CruiseControl.NET
CruiseControl.NET is an Automated Continuous Integration server for .NET. CruiseControl.NET will monitor your source control repository and run your build scripts at set intervals, or whenever a file is checked in. CruiseControl.NET also provides a dashboard web application to view logs and status, plus a system tray application for all developers to install. This way, everyone knows who broke the build!

url : http://confluence.public.thoughtworks.org/display/CCNET/Welcome+to+CruiseControl.NET

3. Nunit

If you're not already unit testing your code, then you certiainly should be. Nunit allows you to write unit tests in your .NET language against your code. The GUI is easy to use and gives a developer confidence to make changes to code. Nunit can be integrated into your build (Nant) so tests can be automated.

Url : http://www.nunit.org/

4.NunitASP

Like Nunit, NunitASP is for unit testing.But in the case of NunitASP, this is an Nunit extension that is used to test the code-behind pages o your ASP.NET applications. You can program tests to click buttons, select an array of web controls and other useful features.

Url : http://nunitasp.sourceforge.net/

5. TestDriven.NET TestDriven.NET

is a free add-in for Visual Studio that piggy-backs on Nunit. It adds quick access, right mouse click functionality to run your unit tests, showing the results in the output window. You can even debug your tests from the right mouse button. Url : http://www.testdriven.net/ 5. RegEx Designer.NET If you've written validation for your .NET sites, regular expressions can be a pain to get to grips with. The RegExDesigner allows you to test out your regular expressions and even generate .NET code from your regular expressions.

Url : http://www.sellsbrothers.com/tools/#regexd

6. FxCop FxCop

is a code analysis tool that checks your code for standards conformance. GUI and command line is available and again can be automatically run via your build script.

Url : http://www.gotdotnet.com/team/fxcop

7. NDoc

NDoc generates class library documentation from .NET assemblies and the XML documentation files generated by the C# compiler Ndoc allows you to produce HTML or MSDN Style documentation.. Using Ndoc is as simple as filling in your .NET XML Comments.

Url : http://ndoc.sourceforge.net/

Share this post: | | | |

Tips mewarnai datagrid row

agusto — Tue, 30 Aug 2005 15:53:00 GMT

Mungkin rekan rekan .Net mungkin punya yang lebih bagus tolong beritahu yach....

Sebab saya juga mendapatkannya dari salah satu situs cuman saya lupa urlnya

1. Control ComDataGridBoolColumn.vb

Option Strict Off

Option Explicit On

Public Class ComDataGridBoolColumn

Inherits System.Windows.Forms.DataGridBoolColumn

Public Sub New(ByVal sMappingName As String, ByVal sHeaderText As String, ByVal iColWidth As Integer, ByVal iMaxLength As Integer, ByVal sAlignment As String, ByVal bIsReadOnly As Boolean)

MyBase.MappingName = sMappingName

MyBase.HeaderText = sHeaderText

MyBase.Width = iColWidth

MyBase.AllowNull = True

MyBase.NullValue = False

MyBase.Alignment = sAlignment

MyBase.ReadOnly = bIsReadOnly

End Sub

Protected Overloads Overrides Sub Paint(ByVal g As Graphics, ByVal bounds As Rectangle, ByVal source As CurrencyManager, ByVal rowNum As Integer, ByVal backBrush As Brush, ByVal foreBrush As Brush, ByVal alignToRight As Boolean)

If rowNum Mod 2 = 0 Then

backBrush = Brushes.LightGoldenrodYellow

End If

MyBase.Paint(g, bounds, source, rowNum, backBrush, foreBrush, alignToRight)

End Sub

End Class

Option Strict Off

Option Explicit On

Public Class ComDataGridBoolColumn

Inherits System.Windows.Forms.DataGridBoolColumn

Public Sub New(ByVal sMappingName As String, ByVal sHeaderText As String, ByVal iColWidth As Integer, ByVal iMaxLength As Integer, ByVal sAlignment As String, ByVal bIsReadOnly As Boolean)

MyBase.MappingName = sMappingName

MyBase.HeaderText = sHeaderText

MyBase.Width = iColWidth

MyBase.AllowNull = True

MyBase.NullValue = False

MyBase.Alignment = sAlignment

MyBase.ReadOnly = bIsReadOnly

End Sub

If rowNum Mod 2 = 0 Then ''' -> di sini bila yang genap maka di warnai dengan warna Brushes.LightGoldenrodYellow

backBrush = Brushes.LightGoldenrodYellow

End If

MyBase.Paint(g, bounds, source, rowNum, backBrush, foreBrush, alignToRight)

End Sub

End Class

2. Control ComDatagridTextBoxColumn.vb

Option Strict Off

Option Explicit On

Public Class ComDatagridTextBoxColumn

Inherits System.Windows.Forms.DataGridTextBoxColumn

Public Sub New(ByVal sMappingName As String, ByVal sHeaderText As String, ByVal iColWidth As Integer, ByVal iMaxLength As Integer, ByVal sFormat As String, ByVal sAlignment As String, ByVal bIsReadOnly As Boolean)

MyBase.MappingName = sMappingName

MyBase.HeaderText = sHeaderText

MyBase.Width = iColWidth

MyBase.TextBox.MaxLength = iMaxLength

MyBase.Format = sFormat

MyBase.Alignment = sAlignment

MyBase.ReadOnly = bIsReadOnly

MyBase.TextBox.Enabled = False

MyBase.NullText = ""

End Sub

If rowNum Mod 2 = 0 Then ''' -> di sini bila yang genap maka di warnai dengan warna Brushes.LightGoldenrodYellow

backBrush = Brushes.LightGoldenrodYellow

End If

MyBase.Paint(g, bounds, source, rowNum, backBrush, foreBrush, alignToRight)

End Sub

End Class

-------------------------------

Cara penggunaannya :

Public Sub InitData()

Dim oDpt As SqlDataAdapter = Nothing

Dim oDgts As DataGridTableStyle

Try

DataGrid1.DataSource =

oDgts.MappingName =

'Ini salah satu sample penggunaannya

oDgts.GridColumnStyles.Add(New ComDatagridTextBoxColumn("StockItemCode", "Stock Code", 80, 20, String.Empty, Convert.ToString(HorizontalAlignment.Left), False))

oDgts.GridColumnStyles.Add(New ComDatagridTextBoxColumn("ItemName", "Stock Name", 200, 20, String.Empty, Convert.ToString(HorizontalAlignment.Left), False))

Me.DataGrid1.TableStyles.Clear()

Me.DataGrid1.TableStyles.Add(oDgts)

Catch ex As Exception

MessageBox.Show(ex.Message, Me.Name & ",InitData")

Finally

oDgts = Nothing

If Not (oDpt Is Nothing) Then oDpt = Nothing

End Try

End Sub

Share this post: | | | |