Visual Basic

Problem with Datagridview Combobox column...

22-Jan-09 22:41

You can't replace a control, but you can create a new one and remove/hide the old. So in your code, create a new usercontorl2, add it to forms controls, place it in the right position and remove the usercontrol1 from forms controls.

If you're using other containers inside the form (for example tabpage), place the control to the right containers controls collection.

The need to optimize rises from a bad design.My articles[^]

RA|-|UL PATEL22-Jan-09 22:03

22-Jan-09 22:03

I have added one combobox column to datagrid view in my windows application.
In Combobox items added is 1,2,3,4,5

even the items has been added it doesn't Display anything in my combobox.When i click on arrow of combobox column,it shows added items 1,2,3,4,5

I want atleast one item must be displayed there in combo box by default.
i.e There must be one selected item.

darkelv22-Jan-09 22:11

darkelv

22-Jan-09 22:11

Set SelectedIndex to other than -1 when you create the column.

Is the column bound?

RA|-|UL PATEL22-Jan-09 22:36

22-Jan-09 22:36

first of all thanks for answer darkelv.

For datagridview combobox column there is no selected
index property.

yes it is bound.
I has set displaymember,Valuemember property according to i need it.

Re: Problem with Datagridview Combobox column... [modified]

darkelv22-Jan-09 22:57

darkelv

22-Jan-09 22:57

Maybe check if the binding is bound to the correct item/property.

Here's a sample of my code that is bound to an array of enum

Edit: Are you using comboBoxColumn.Items.Add() instead of setting DataSource?

//==Status==//
		public static AtomDataGridViewComboBoxColumn StatusGridViewColumn(Atom.Interface.ILocale locale)
		{
			AtomDataGridViewComboBoxColumn status = new AtomDataGridViewComboBoxColumn();
			status.DataPropertyName = "Status";
			status.HeaderText = LocalText.GetText(locale, LocalID.Create("ChequePrint.Master.Cheque_Status"), "Status");
			status.Name = "Status";
			status.SortMode = DataGridViewColumnSortMode.Automatic;
			status.ReadOnly = false;
			status.Width = 90;
			status.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
			status.DefaultCellStyle.Format = "";
			//===== MUST HANDLE DATA FILL FOR COMBO BOX HERE =====//
			#region .:BE831DCA-BCDC-4294-8634-E33D8C66E51E [Status]:.
            ArrayList a = new ArrayList();
            a.Add(StatusTypes.Outstanding);
            a.Add(StatusTypes.Issued);
            a.Add(StatusTypes.Cleared);
            a.Add(StatusTypes.Void);
            Array enums = a.ToArray(typeof(StatusTypes));
            //Array enums = Enum.GetValues(typeof(StatusTypes));
            status.DataSource = enums;
			#endregion .:BE831DCA-BCDC-4294-8634-E33D8C66E51E [Status]:.
			return status;
		}

Wendelius22-Jan-09 22:44

Re: Problem with Datagridview Combobox column... [modified]

22-Jan-09 22:44

~~DataGridViewComboBoxColumn~~ DataGridViewComboBoxCell doesn't have selectedindex or selectedvalue, so you must use Value property instead.

The need to optimize rises from a bad design.My articles[^]

modified on Friday, January 23, 2009 5:05 AM

RA|-|UL PATEL22-Jan-09 23:01

22-Jan-09 23:01

Is it possible to add full DataGridViewComboBoxColummn to DataGridView with the use of DataGridViewComboBoxCell.

modified on Friday, January 23, 2009 6:11 AM

Wendelius22-Jan-09 23:05

22-Jan-09 23:05

My bad, I didn't mean the column but the cell. DataGridViewComboBoxCell has the value property and it doesn't have selectedindex or selectedvalue.

The need to optimize rises from a bad design.My articles[^]

RA|-|UL PATEL22-Jan-09 23:32

22-Jan-09 23:32

Is it possible to add full DataGridViewComboBoxColummn to DataGridView with the use of DataGridViewComboBoxCell.

Wendelius22-Jan-09 23:47

22-Jan-09 23:47

I don't quite understand your question. The DataGridViewComboBoxColumn represents the column itself while the cells is one cell in that column on a specified row.

I think there's a very good example here: DataGridViewComboBoxColumn Class[^]

The need to optimize rises from a bad design.My articles[^]

Remote Connection While using Attached Database file in MssqlExpress 2005

Ashutosh Phoujdar22-Jan-09 23:59

Ashutosh Phoujdar

22-Jan-09 23:59

Can you please try this :

Dim rowCounter as Integer = 0
With CType(Grid.Rows(rowCounter).Cells(0), DataGridViewComboBoxCell)
            .Items.Add("1")
            .Items.Add("2")
            .Items.Add("3")
            .Items.Add("4")
            .Value = .Items.Item(ind)
End With

Hope this will answer your query

dnpro
"Very bad programmer"

My Latest Articles
RichTextBox Control with Find functionality
LogViewer - A Simple Log Listening Utility

r_mohd22-Jan-09 18:05

r_mohd

22-Jan-09 18:05

Hi All,

Kindly suggest me how i use same database file from different Computers. i am using mssql express 2005 with vb.net.

thanks

rmshah
Developer

Re: Remote Connection While using Attached Database file in MssqlExpress 2005

Ashutosh Phoujdar22-Jan-09 19:03

Ashutosh Phoujdar

22-Jan-09 19:03

Please try these steps :

1. Put the database file (*.mdf) in shared location, and give Full Control to users
Who will use connection e.g. ASPNET user or any machine user in case of windows application.

2. Then use following connection string :
SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=<unc-path-to-database-file>;Integrated Security=True;Connect Timeout=30;User Instance=True");

3. Although this may not recommended solution, but It works.

dnpro
"Very bad programmer"

Re: Remote Connection While using Attached Database file in MssqlExpress 2005

Wendelius22-Jan-09 20:49

Re: reading from resource files

22-Jan-09 20:49

You don't actually use same database file. You install SQL Server on a computer, place your database in the SQL Server and applications will connect to the SQL Server (not the database file) using SqlConnection.

For connection refer to: http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.aspx[^]

The need to optimize rises from a bad design.My articles[^]

files from subfolder

jishbalan22-Jan-09 17:11

jishbalan

22-Jan-09 17:11

Hello all,

Can any body helps me to find a code for getting files from subfolders or files inside that subfolder.

i know code to get files from folders and subfolders. But if many folders are there, my code fails i.e. folder/subfolder/subfolder/...

i am not sure how many subfolders are there inside a folder
i need the code for getting file from folder/subfolder/subfolder/subfolder..

i am using these code for getting files inside subfolder

For Each fld In path.SubFolders
For Each fil In fso.GetFolder(fld.path).Files
If Right(fil, 3) = "txt" Then
fileNameArray1(fileCounts) = fil
fileCounts = fileCounts+1
End If
Next
Next
please try give the code for getting files inside folder/subfolder/subfolder/subfolder/..

Thanks and regards
Jishith

Re: files from subfolder

N a v a n e e t h22-Jan-09 17:14

N a v a n e e t h

22-Jan-09 17:14

You need a recursive function. This[^] KB article show how to do it in C#. Same can be ported to VB.NET.

Navaneeth

How to use google | Ask smart questions

Re: files from subfolder

Ashutosh Phoujdar22-Jan-09 18:56

Ashutosh Phoujdar

22-Jan-09 18:56

The article mentioned in previous reply is perfect call for this situation.
But, Now .NET supports recursive search by using simple code snippet. Have a look in following code snippet :

 Dim myFiles() As String = Directory.GetFiles("C:\Temp", "*.*", SearchOption.AllDirectories)

If myFiles.Length > 0 Then
       'Do process list of files retrieved          
End If

dnpro
"Very bad programmer"

[Message Deleted]

moonshaddow22-Jan-09 17:08

moonshaddow

22-Jan-09 17:08

[Message Deleted]

N a v a n e e t h22-Jan-09 17:12

N a v a n e e t h

22-Jan-09 17:12

moonshaddow wrote:
Error: Illegal characters in path.

Looks like some bad data. What My.Resources.mages returns?

Navaneeth

How to use google | Ask smart questions

Re: reading from resource files

moonshaddow22-Jan-09 17:26

moonshaddow

22-Jan-09 17:26

N a v a n e e t h wrote:
What My.Resources.mages returns?

My.Resources.mages is i txt file i put in resource manager, sorry for not explaining myself before

J.Hardy

Does VB support partial classes? [modified]

PIEBALDconsult22-Jan-09 9:07

PIEBALDconsult

22-Jan-09 9:07

I'm beginning to work on a piece of code generation. It's primarily for C#, but I thought I'd include support for VB because I'm a nice guy. Big Grin | :-D

Do I understand correctly that VB doesn't support partial classes?

Add: Thanks for the answers, guys.

modified on Thursday, January 22, 2009 4:19 PM

Re: Does VB support partial classes?

Wendelius22-Jan-09 9:36