Help me with the excel file thingy - C# Discussion Boards

First Prev Next

Re: counting

PIEBALDconsult24-Sep-08 3:50

PIEBALDconsult

24-Sep-08 3:50

That's a typo; he meant "clitty".

Re: counting

Paul Conrad24-Sep-08 8:49

Paul Conrad

24-Sep-08 8:49

Pete O'Hanlon wrote:
rather not lick a city - it tastes all concretey.

Probably more than just concretey Roll eyes | :rolleyes:

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham

finding width and height of glyphs using its indices

GSSPriya24-Sep-08 0:27

GSSPriya

24-Sep-08 0:27

hi,

I have to find the width and height of glyphs in xps document using only the indices attribute in wpf.
I tried with the formula,

width = (advancewidth*fontsize)/ 100;

but advancewidth is an optional one .At that time what i should use to calculate width.

For eg:

<Glyphs

FontUri = "C:\WINDOWS\Fonts\TIMES.TTF"

FontRenderingEmSize = "14"

Indices="75;45;68,49"

StyleSimulations = "BoldSimulation"

UnicodeString = "hai"

Fill = "Black"

OriginX = "0"

OriginY = "150"

/>

Is there any possiblity to get the width and height from the fontfile used in the xps document.if yes how?

Plz reply

create public folder on exchange 2003

panim2524-Sep-08 0:27

panim25

24-Sep-08 0:27

i need to create public folder on exchange server 2003 in c#
i looking for the most simple way
thank you.

Comboobx pulldown problem

Denver Thomas23-Sep-08 23:59

Denver Thomas

23-Sep-08 23:59

Hi friends ,
I am using visual studio 2003.In my project I have a combobox populated directly from a dataset using 'displaymember' and 'valuemember' properties.But sometimes my combobox is hanging ie , it can be selected with scroll of mouse but pulldown is not working.Any way to correct this issue friends ?

with warm regards

Re: Comboobx pulldown problem

nelsonpaixao24-Sep-08 14:14

nelsonpaixao

24-Sep-08 14:14

I think the way you handle your comboboxes coding are everthing but warm, cold or freezing instead Laugh | :laugh:

But (only) because your regards are warm, i´m going to post you this routine.
I assume you know display_member is like country_name(varchar) and value_member is like id_country(int), and you made a store_procedure to fill the combobox (select id_country,country_name FROM dbo.Countries) Big Grin | :-D

Good Warm Luck Cool | :cool:

public static void ComboBox_Fill(ComboBox myComboBox,
string store_procedure, string display_member,
string value_member)
{
SqlConnection sql_conn = new SqlConnection(connection_string);
SqlCommand sql_cmd = new SqlCommand();
sql_cmd.Connection = sql_conn;
sql_cmd.CommandText = store_procedure;
sql_cmd.CommandType = CommandType.StoredProcedure;
sql_conn.Open();
SqlDataAdapter sql_da = new SqlDataAdapter();
sql_da.SelectCommand = sql_cmd;
DataTable dt = new DataTable();
sql_da.Fill(dt);
sql_conn.Close();
myComboBox.DataSource = dt;
myComboBox.DisplayMember = display_member;
myComboBox.ValueMember = value_member;
}

nelsonpaixao@yahoo.com.br

trying to help & get help

Re: Comboobx pulldown problem

Denver Thomas24-Sep-08 21:13

Denver Thomas

24-Sep-08 21:13

Brother ,
Thanxxxxx a lot for your reply.The same code I used in my project.Yaa but the problem was with frame work.I converted project in to VS 2005.It is working fine there.Also conversion cleared a lots of unhandled exceptions in my project.Once again thanxx for your reply...Take care

Help me with the excel file thingy

newbieprogrammerguy23-Sep-08 23:57

newbieprogrammerguy

23-Sep-08 23:57

Hi everybody i am exactly what my name suggests a newbie to programming world but i have matured in C# basically so i know some internal stuff(creating simple apps. and codes) but the next step i want to achieve is connecting with databases so not yet ready to make the big jump i want to just do this .....
I have an excel file (Office 2007) and i want to display the information in the file in the textboxes of the C# application so when i googled it all i get is OLEDB which i am not very sure and i remeber using VS2005 and connecting to SQL2005 and retrieving data but since now i am using its all LINQ i guess but as i said earlier i dun want to go near the SQL yet .........i know i know i am bit long winded pls forgive me but pls need an answer or may be a simple article on this would be helpful...tks to the future answer guy before hand Laugh | :laugh:

Re: Help me with the excel file thingy

#realJSOP24-Sep-08 1:11

#realJSOP

24-Sep-08 1:11

First, you should google "punctuation" so you can type lucid messages.

Second, you didn't google hard enough (or lied about doing it), because I found dozens of examples of reading an Excel file.

Here's one.[^]

"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001

How to drag and drop a file into DataGridView? [modified]

mimimimilaw23-Sep-08 23:35

mimimimilaw

23-Sep-08 23:35

I would like to drag and drop a row in DataGridView on .net framework 2.0 the row is a file detail from window explorer.

    <br />
    private void dGV_fileUpload_DragDrop(object sender, DragEventArgs e)<br />
    {<br />
<br />
        Object fileName = (Object)e.Data.GetData(typeof(????));<br />
        <br />
          FileInfo file = new FileInfo(fileName);<br />
          DataGridViewRow row = new DataGridViewRow();<br />
          row.CreateCells(dGV_fileUpload);<br />
          row.Cells[0].Value = file.Name;<br />
          row.Cells[1].Value = GetFileSize(file.Length);<br />
          row.Cells[2].Value = file.LastAccessTime.ToString();<br />
          this.dGV_fileUpload.Rows.Add(row);<br />
    }<br />

modified on Wednesday, September 24, 2008 5:44 AM

Re: How to drag and drop a file into DataGridView?

Giorgi Dalakishvili24-Sep-08 0:07

Giorgi Dalakishvili

24-Sep-08 0:07

This might help: Drag and Drop[^]

Giorgi Dalakishvili

#region signature
my articles

My blog[^]
#endregion

Print in C#

Laji5923-Sep-08 23:24

Laji59

23-Sep-08 23:24

How to work with PrintDialog?
I want to Print for example a Doc File that has opened in my application
What should I do for it?

Hello Friends

How to know shutdown using c#?

lovnin23-Sep-08 23:23

lovnin

23-Sep-08 23:23

How to know shutdown using c#?
Not using service or SessionEnding event.
Thanks a lot! Smile | :)

Re: How to know shutdown using c#?

Simon P Stevens24-Sep-08 1:39

Simon P Stevens

24-Sep-08 1:39

You can use the InitiateSystemShutdown[^] function.

You'll need to use pinvoke to call it from C#. pinvoke.net[^] will help you find the right signature for the declaration.

(Alternatively, you can use WMI if you prefer. Just google it)

Simon

User Groups Management Implemenation for Desktop Application Question ?

abmv23-Sep-08 23:05

abmv

23-Sep-08 23:05

Hi,
I have a desktop Human Resource (HR) application developed in WPF that does some employee management work for the HR,I need to implement user groups based security,meaning that I need to manage users who can access the system(username /password) and also give them CRUD Right and Screen Rights.Is that any basic framework I can build over or should I start from scratch? Any feedback, suggestion regarding this?

Thanks in advance.

wmi - registry

arkiboys23-Sep-08 23:01

arkiboys

23-Sep-08 23:01

\root\cimv2
Do you know if the above wmi path is looking at the registry?
if so, please let me know where in the registry I can find it.
Thanks.

Re: wmi - registry

Mark Salsbery24-Sep-08 8:17

Mark Salsbery

24-Sep-08 8:17

root\cimv2 is a WMI namespace.

Although much of the info obtainable from the classes in that
namespace may ultimately be stored in the registry, there is no
connection between the namespace and the registry.

Windows Management Instrumentation[^]

Mark Salsbery
Microsoft MVP - Visual C++
Java | [Coffee]

views don't appear in list of datamember

Yasser Sobhdel23-Sep-08 22:04

Yasser Sobhdel

23-Sep-08 22:04

Hi I have a dataset which its views don't appear in any datamember list.
I created another project and added the same database,in that new project every thing is working fine.so I just removed the dataset and added it again but the problem persists.
can any one help me? should I correct any configuration setting?
by the way I haven't changed any configuration in any project and I am using VS2008.
thanx

How to work with Shortcut & Keyboard

Laji5923-Sep-08 21:54

Laji59

23-Sep-08 21:54

How to work with Shortcut & Keyboard
For Example I want Manage Keys like "Ctrl+F" for Search
How to do it?
Thanks in advance

Hello Friends

Re: How to work with Shortcut & Keyboard

Blue_Boy23-Sep-08 22:08

Blue_Boy

23-Sep-08 22:08

private void frmFormName_KeyDown(object sender, KeyEventArgs e)<br />
{ <br />
   if (e.Control && e.KeyCode == Keys.F)<br />
   {   <br />
     MessageBox.Show("Conbination key CTRL+F is pressed"); <br />
   }<br />
}