getting the values from unbound DatagridviewcomboBoxColumns ??? - C# Discussion Boards

User 171649210-Dec-06 13:28

10-Dec-06 13:28

You could use the Query Builder. Assuming you are using C# Express Edition, this "in-built" help page from the C# help file that installs with the C# express edition will show you how. There are also related help pages you might like to read! There are other ways to achieve the desired result but for a novice, this might be the easiest way.

ms-help://MS.VSExpressCC.v80/MS.NETFramework.v20.en/dv_vdt01/html/815a30ce-6fb1-4611-bf43-bedd2020c443.htm

Although you are wanting to program in C#, the question is about database. Try posting database questions in the correct forum.

modified 1-Aug-19 21:02pm.

Re: BindingSource and DataSet

Muammar©10-Dec-06 20:16

Muammar©

10-Dec-06 20:16

Try this link.

All generalizations are wrong, including this one!
(\ /)
(O.o)
(><)

Project Installer - Installing Fonts?

wbjohnson10-Dec-06 7:19

wbjohnson

10-Dec-06 7:19

Hey guys

i have a c# project and ive added a project installer...

is there any way i can install some fonts to in the windows font directory as the application gets installed?

many thanks

Will

Re: Project Installer - Installing Fonts?

Filip van der Meeren10-Dec-06 9:16

Filip van der Meeren

10-Dec-06 9:16

Checkout the help of the Visual Studios...

It is all in there ... Poke tongue | ;-P

Don't you also love the code?

Re: Project Installer - Installing Fonts?

wbjohnson10-Dec-06 9:19

wbjohnson

10-Dec-06 9:19

ive had a dig around and cant much :S

can u point me in the right direction?

Re: Project Installer - Installing Fonts? [modified]

Filip van der Meeren10-Dec-06 9:25

Filip van der Meeren

10-Dec-06 9:25

When you have created a new setup project in vs2005, you go to the 'File System' right click on 'File System on Target Machine', 'Add Special Folder', 'Fonts Folder'.

And then you just add in the Fonts folder the right files...

Just of topic... I have helped you could you help me? I want to finish my work (General Discussion - Cards?).

Don't you also love the code?

Re: Project Installer - Installing Fonts?

wbjohnson10-Dec-06 9:29

wbjohnson

10-Dec-06 9:29

thanks dude! spot on!! Big Grin | :-D

getting the values from unbound DatagridviewcomboBoxColumns ???

Rocky#10-Dec-06 7:05

Rocky#

10-Dec-06 7:05

hi every one,
well I have this little problem here. I'm getting a nullreferenceException when I try to access the value of a DataGridViewComboBox column. I have correctly bounded the column and its also showing the values of that table too. The name of the column is "AttendanceComboBoxColumn". now I just wanna know how to get the value selected in this comboBox.

for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
//MessageBox.Show("att: " + dataGridView1["AttendanceComboBoxColumn", i].Value.ToString() + "\n empid: " + dataGridView1["empIDDataGridViewTextBoxColumn", i].Value.ToString()+"\nDate: "+selected_date.ToString());
//MessageBox.Show("att: " + dataGridView1["AttendanceComboBoxColumn", i].Value.ToString() + "\n empid: " + dataGridView1["empIDDataGridViewTextBoxColumn", i].Value.ToString());
//MessageBox.Show("att: " + dataGridView1["AttendanceComboBoxColumn", i].Value.ToString() );// null ref
//MessageBox.Show("att: " + dataGridView1["empIDDataGridViewTextBoxColumn", i].Value.ToString()); // ok
//sqlUpdateCommandAttendance.Parameters["@AttendanceID"].Value = Convert.ToDecimal(dataGridView1["AttendanceComboBoxColumn", i].Value);
int c = AttendanceComboBoxColumn.DisplayIndex;
MessageBox.Show(dataGridView1[c, i].Value.ToString());
sqlUpdateCommandAttendance.Parameters["@AttendanceID"].Value = Convert.ToDecimal(dataGridView1[c,i].Value);
sqlUpdateCommandAttendance.Parameters["@original_empid"].Value = Convert.ToDecimal(dataGridView1["empIDDataGridViewTextBoxColumn", i].Value);
sqlUpdateCommandAttendance.Parameters["@original_attendDate"].Value = selected_date;
count+=sqlUpdateCommandAttendance.ExecuteNonQuery();
}

thanks in advance

Rocky

runing a *.exe file

hadad10-Dec-06 6:54

hadad

10-Dec-06 6:54

how can I call a *.exe file from whithin the c# code

Dad

Re: runing a *.exe file

gnadeem10-Dec-06 7:10

gnadeem

10-Dec-06 7:10

here u go.
Process p = new Process();
p.StartInfo=new ProcessStartInfo("C:\\CleanMyPCOnStartUp.exe");
p.Start();

Re: runing a *.exe file

karam chandrabose10-Dec-06 8:12

karam chandrabose

10-Dec-06 8:12

if u want to invoke methods / load forms in a particular exe u can use reflection!

Populating a ComboBox

Civic0610-Dec-06 5:33

Civic06

10-Dec-06 5:33

Is there a way to add lets say "Australia", "Canada", "US" to a combobox dropdown and also set a value such as '5','3','2'?

Visually we'll be able to see the country names...however the numbers above are associated with each country.

Re: Populating a ComboBox

teejayem10-Dec-06 5:48

teejayem

10-Dec-06 5:48

i don't think you can manually set a value to a comboBox item. You can however get the selectedIndex for that item that is chosen.

ex:

comboBox1.Items.Add("US");
comboBox1.Items.Add("CA");
//store it in a string
string value = comboBox1.SelectedIndex.ToString();
//store it as an int
int value = comboBox1.SelectedIndex;

So if US is selected it will store "0" in the variable "value". If CA is selected it would store "1" etc. Let me know if this helps you.

Don't be overcome by evil, but overcome evil with good

Re: Populating a ComboBox

Robert Rohde10-Dec-06 5:53

Robert Rohde

10-Dec-06 5:53

Hi,

instead of adding just strings you could add objects holding every info you need:

public struct CountryWithid {
   public string Country;
   public int Id;

   public CountryWithid(string country, int id) {
      this.Country = country;
      this.Id = id;
   }

   public override string ToString() {
      return this.Country;
   }
}

//adding items
comboBox.Items.Add(new CountryWithId("US", 8));
comboBox.Items.Add(new CountryWithId("Canada", 3));

//retrieving selected Id
int selectedid = ((CountryWithId)comboBox.SelectedItem).Id;

Robert

Re: Populating a ComboBox

Luis Alonso Ramos10-Dec-06 7:15

Luis Alonso Ramos

10-Dec-06 7:15

Extendind on Robert's answer, I have a generic ComboBoxItem class that contains four properties and a method:

int Id - ID of the item
Guid Guid - another ID in Guid form
string Text - text to display
object Tag - any object you would like to assign
string ToString() - simply returns the Text property

And I use that class to add objects to ComboBoxes when I have your need.

Luis Alonso Ramos
Intelectix
Chihuahua, Mexico

N yot much here: My CP Blog!

telephonic application

amgag10-Dec-06 5:04

amgag

10-Dec-06 5:04

how can i receive and send a call through TAPI. can i any one have idea how to use to TAPI and how to connect modem for these typr of application.

Thanks and best Regards.
Zahid kareem

How to search/replace words in a pre-formatted pdf file

babbelfisken10-Dec-06 3:59

babbelfisken

10-Dec-06 3:59

Hi,

I'm new to C#.

What i have done so far is a simple windows application from which
users input data.

These data is then to be inserted in a pdf file.

Some of the words in this PDF file are distinct so when i search the file
and stumbles on one of this distinct word, i replace it with a user inputted
word.

Also i want to make a copy of the pdf file so i don't screw up the original.

Any suggestions or alternatively solutions?
No need to give full solutions, then i won't
learn anything Wink | ;)

Thanks, Daniel from Sweden

send data over modem

sianatia10-Dec-06 1:55

sianatia

10-Dec-06 1:55

hi there,
i use TAPI to control modem,now i can dial or hang up but i dont know how to send data over a connected line,what should i do?
thanks

Marshaling a string to a native dll...

Shy Agam10-Dec-06 1:16

Shy Agam

10-Dec-06 1:16

Hello,

I wrote a native C++ dll.
One of the functions it exports receives a string (LPCSTR to be exact), and keeps this string in order to use it later.
When my C# app simply sends a string to the dll, the GC is collecting it as soon as the function returns.

Problem is, I need that string in other functions.
So I've tried using GCHandle like so:

Global stuff:

string s = "MyVeryImportantString";
GCHandle gch;

Inside a C# function:

gch = GCHandle.Alloc(s, GCHandleType.Pinned);
nativeDllFunction(GCHandle.ToIntPtr(gch));

Later on I free the GCHandle of course.

That didn't work, but that's probably because I'm doing something wrong, and it probably has a solution...
That's not why I'm writing right now...
I'm here to ask your opinions about my workaround...
Inside my native dll, I wrote a function to allocate new memory for the string, using malloc.
This way I'm not holding a pointer to the string the GC is collecting, but a pointer to a copy I made.

Doing so could help future mistakes with managed assemblies which use this dll.
Moreover, it saves me the need to worry, and the time to write a proper GCHandle code.
As I'm new to dll programming in C++, I don't really know fashionable methods of doing stuff. Is it bad to use the malloc function inside of my dll?
Is it better to use the GCHandle method instead?

Thanks in advance,
Shy.

Re: Marshaling a string to a native dll...

Luc Pattyn10-Dec-06 1:49

Luc Pattyn

10-Dec-06 1:49

Hi,

in order to prevent the gc from deleting or moving an object, you need a GCHandle AND pinning,
as in the following code snippet:

// play sound from a sound resource
	Stream stream=type.Assembly.GetManifestResourceStream(resourceName);
	int len=(int)stream.Length;
	byte[] buf=new byte[len];
	stream.Read(buf, 0, len);
	GCHandle handle=GCHandle.Alloc(buf);
	IntPtr ptr=Marshal.UnsafeAddrOfPinnedArrayElement(buf, 0);
	int res=sndPlaySound(ptr, 4);	// SND_MEMORY
	handle.Free();

You can postpone the last line (until the unmanaged code no longer uses the pointer),
but you should execute it eventually, otherwise the memory situation will deteriorate.

Smile | :)

Luc Pattyn

How can I implement "OLE object" with C# and SQL

devloperx10-Dec-06 0:09

devloperx

10-Dec-06 0:09

How can I implement "OLE object" with C# and SQL
I need a simi way to do link to files with ADO.NET with SQL SERVER
like MS-ACCESS OLE Object to Insert and Edit >object like any file such as MS-Word, MS-Excel ..etc;
so When an User open GUI Application he would be able to (brows - save - Edit) the files on SQL Directly,,
thank you
my email:devloperx@yahoo.com

Re: How can I implement "OLE object" with C# and SQL

devloperx10-Dec-06 2:21

devloperx

10-Dec-06 2:21

I need help

Workgroup name of local host

cashi_qau9-Dec-06 23:13

cashi_qau

9-Dec-06 23:13

i want to pick up the workgroup name of the local host in c#. i want a solution instead of WMI, window services and web services.

I will be thankfull.

Muhammad Kashif

Re: Workgroup name of local host

gnadeem10-Dec-06 3:10

gnadeem

10-Dec-06 3:10

kashif,
you may consider using external function NetWkstaGetInfo from "netapi32" lib.
regards

String - ValueType or ReferenceType?

Shy Agam9-Dec-06 22:43

Shy Agam

9-Dec-06 22:43

Hello everyone,

The VS's Object Browser shows that Object is the base class for String.
Does this necessarily means that String is a reference type?

Thanks in advance,
Shy.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.