| | |
Placing ComboxBox in DataGrid Cell -Visual Basic .Net Windows Forms
Please support our VB.NET advertiser: Intel Parallel Studio Home
Placing ComboxBox in DataGrid Cell is a task usually found in Invoicing application. Here is my version of same.
Imports System.Data.SqlClient Public Class Form1 Dim cn As SqlConnection Dim cmd As SqlCommand Dim da As SqlDataAdapter Dim dr As SqlDataReader Dim ds As New DataSet Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load cn = New SqlConnection("Integrated Security=sspi;Initial Catalog =ShalvinPD;Data Source = .\sqlexpress") cn.Open() da = New SqlDataAdapter("select ProductName,Categoryid ,UnitPrice from Products", cn) da.Fill(ds, "products") DataGrid1.SetDataBinding(ds, "products") fillcombo() End Sub Private Sub DataGrid1_CurrentCellChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles DataGrid1.CurrentCellChanged Dim x, y, w, h As Integer Dim rect As Rectangle rect = DataGrid1.GetCurrentCellBounds x = rect.X + DataGrid1.Left y = rect.Y + DataGrid1.Top w = rect.Width h = rect.Height ComboBox1.SetBounds(x, y, w, h) ComboBox1.Visible = True End Sub Private Sub fillcombo() cmd = New SqlCommand("select * from categories", cn) dr = cmd.ExecuteReader() While dr.Read() ComboBox1.Items.Add(dr("categoryName")) End While End Sub Private Sub DataGrid1_MouseDown(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles DataGrid1.MouseDown MessageBox.Show(e.X.ToString() + " " + e.Y.ToString() + " " + e.Button.ToString()) End Sub End Class Happy Programming
Similar Threads
- How to do basic file I/O in Visual C++ or in Visual C++ .NET (C++)
- Page numbers displayed in single cell in asp.net datagrid, why? (ASP.NET)
- Accessing Datagrid selected row cell value (c# .NET) (ASP.NET)
- How do i Make visual basic remember selections From other forms (Visual Basic 4 / 5 / 6)
- The Move.....Visual Basic 6, Visual Basic .NET ? (VB.NET)
| Thread Tools | Search this Thread |
.net .net2008 2008 access add advanced application array assignment basic beginner box browser button buttons center click client code combo convert cpu cuesent data database datagrid datagridview datetimepicker designer dissertation dissertations dissertationtopic eclipse editvb.net employees excel exists filter forms function html images isnumericfuntioncall listview map mobile module msaccess mssqlbackend mysql net number open page pan panel pdf picturebox picturebox2 port position print printing printpreview record regex reuse right-to-left save search serial settings socket sorting sqldatbase sqlserver storedprocedure structures temp textbox timer timespan transparency txttoxmlconverter usercontol vb vb.net vba vbnet vista visual visualbasic visualbasic.net visualstudio.net web winsock wpf wrapingcode xml year



