-----------------------------------------------------------
New Message on MumbaiUserGroup
-----------------------------------------------------------
From: Jigs
Message 2 in Discussion
This was a KB article on microsoft site. now i don;t find the link to the same. so i
am pasting the code here. Create the Sample Follow these steps to create a new
Visual Basic Windows Application project: Start Microsoft Visual Studio .NET.
On the File menu, point to New, and then click Project. In the New Project
dialog box, click Visual Basic Project under Project Types, and then click Windows
Application under Templates. By default, Form1 is added. Drag a DataGrid control from
the toolbox to Form1. Add the following code to the top of the code window in the
Declarations section of Form1.vb:Imports System.Data.SqlClient Imports
System.Windows.Forms Add the following
code after the "Windows Form Designer generated code" section of the code
window:Public MyCombo As New ComboBox() Dim con As New
SqlConnection("server=myservername;uid=myid;pwd=mypassword;database=northwind")
Dim daEmp As New SqlDataAdapter("Select * From Employees", con) Public ds As New
DataSet() Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load AddHandler MyCombo.TextChanged,
AddressOf Ctrls_TextChanged 'Fill ComboBox list. MyCombo.Name =
"MyCombo" MyCombo.Visible = False MyCombo.Items.Clear()
MyCombo.Items.Add("Sales Representative") MyCombo.Items.Add("Inside Sales
Coordinator") MyCombo.Items.Add("Vice President, Sales")
MyCombo.Items.Add("Sales Manager") MyCombo.Items.Add("Flunky")
daEmp.Fill(ds, "Employees") 'Set the RowHeight of the DataGrid to the height
of the ComboBox. DataGrid1.PreferredRowHeight = MyCombo.Height
DataGrid1.DataSource = ds DataGrid1.DataMember = "Employees" 'Add
ComboBox to the Control collection of the DataGrid.
DataGrid1.Controls.Add(MyCombo) End Sub Private Sub DataGrid1_Paint(ByVal
sender As Object, ByVal e As System.Windows.Forms.PaintEventArgs) Handles
DataGrid1.Paint If DataGrid1.CurrentCell.ColumnNumber = 3 Then
MyCombo.Width = DataGrid1.GetCurrentCellBounds.Width End If End Sub
Private Sub Ctrls_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs)
If DataGrid1.CurrentCell.ColumnNumber = 3 Then MyCombo.Visible = False
If DataGrid1.Item(DataGrid1.CurrentCell) & "" = "" Then
SendKeys.Send("*") End If
DataGrid1.Item(DataGrid1.CurrentCell) = MyCombo.Text End If End Sub
Private Sub DataGrid1_CurrentCellChanged(ByVal sender As Object, ByVal e As
System.EventArgs) Handles DataGrid1.CurrentCellChanged If
DataGrid1.CurrentCell.ColumnNumber = 3 Then MyCombo.Visible = False
MyCombo.Width = 0 MyCombo.Left = DataGrid1.GetCurrentCellBounds.Left
MyCombo.Top = DataGrid1.GetCurrentCellBounds.Top MyCombo.Text =
DataGrid1.Item(DataGrid1.CurrentCell) & "" MyCombo.Visible = True
Else MyCombo.Visible = False MyCombo.Width = 0 End If
End Sub Private Sub DataGrid1_Scroll(ByVal sender As Object, ByVal e As
System.EventArgs) Handles DataGrid1.Scroll MyCombo.Visible = False
MyCombo.Width = 0 End Sub Private Sub DataGrid1_Click(ByVal sender As Object,
ByVal e As System.EventArgs) Handles DataGrid1.Click MyCombo.Visible = False
MyCombo.Width = 0 End Sub
Modify the connection string as necessary for your environment. Press F5 to
run the project. Click one of the fields in the Title column in the DataGrid. Notice
that the ComboBox control is located in the DataGrid. Expand the ComboBox.
Notice that a list of titles is displayed.
Regards,
Jignesh Desai
http://www.dotnetJiNi.com
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/MumbaiUserGroup/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]