C# Discussion Boards - CodeProject

First Prev Next

Re: instance of sql server at client side

HemJoshi24-Sep-08 23:06

HemJoshi

24-Sep-08 23:06

Hi Laziale,

You donot need to install SQLServer in each client m/c.If you are using SQL DMO for backup and restore of db throgh application than only you need to add the required DLL in your setup(Using merge module).

Thanks
Hem

Re: instance of sql server at client side

Guffa24-Sep-08 2:26

Guffa

24-Sep-08 2:26

As your application is using a database, it has to have a database to use.

You either have to install a local database on the client computer, or you need an instance of SQL Server (not express) on a server that they can access via LAN/internet.

Despite everything, the person most likely to be fooling you next is yourself.

Re: instance of sql server at client side

darkelv24-Sep-08 4:00

darkelv

24-Sep-08 4:00

IF you plan to run the application on a different machine, BUT connect to the database on your local machine, you will need to allow remote connection on the SQL server, using Surface Area Configuration. It is turned off by default. Also check the firewall to allow the port to go through also.

IF you plan to run the application on a different machine AND connect to the database on that machine, yeah, you will need to install SQL server on that machine.

Custom TextBox [modified]

ajtunbridge24-Sep-08 1:23

ajtunbridge

24-Sep-08 1:23

Hello. Got an annoying problem here. I'm trying to create a custom TextBox which renders the text central vertically. Additionally, I want the font to reduce in size if it is wider than the TextBox so it is all visible. The problem is the text renders fine until it's too wide, then it won't draw at all. Here's the KeyPress event handler:

private void TextArea_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == 8)
{
if (baseString.Length > 0) baseString.Remove(baseString.Length - 1, 1);
}
else
baseString.Append(e.KeyChar);

if (baseString.Length == 0)
{
using (Graphics gfx = this.CreateGraphics())
{
gfx.Clear(this.BackColor);
return;
}
}

// Setup the graphics object
Graphics g = this.CreateGraphics();
g.TextRenderingHint = System.Drawing.Text.TextRenderingHint.ClearTypeGridFit;
g.SmoothingMode = System.Drawing.Drawing2D.SmoothingMode.HighQuality;

SizeF stringSize = g.MeasureString(baseString.ToString(), this.Font);

if (stringSize.Width > this.Width)
{
while (stringSize.Width > this.Width)
{
this.Font = new Font(this.Font.FontFamily, this.Font.Size - 1);
stringSize = g.MeasureString(baseString.ToString(), this.Font);
}
}
else
{
while (stringSize.Height < (this.Height - 6))
{
this.Font = new Font(this.Font.FontFamily, this.Font.Size + 1);
stringSize = g.MeasureString(baseString.ToString(), this.Font);
}
}

g.Clear(this.BackColor);

float posX, posY;

posX = (this.Width / 2) - (stringSize.Width / 2);
posY = (this.Height / 2) - (stringSize.Height / 2);

g.DrawString(baseString.ToString(), this.Font, new SolidBrush(this.ForeColor), posX, posY);
g.Dispose();
}

You can see the reduced size string flicker in and out when typing fairly fast but then it disappears. Any help would be appreciated.

-----------------------------------------------------------------
EDIT: Realised I should have put the painting in the OnPaint method which I did, and found an unintentional loop which I've removed. It's working correctly now apart from the fact that as the text gets longer, and therefore the font smaller, my alignment veers off to the left a bit.

modified on Wednesday, September 24, 2008 9:29 AM

counting

Krishna Varadharajan24-Sep-08 1:22

Krishna Varadharajan

24-Sep-08 1:22

How can i count all location respectively while licking a city...by using class r any material avilable?

krishna

Re: counting

Simon P Stevens24-Sep-08 1:42

Simon P Stevens

24-Sep-08 1:42

Create a integer variable. Set it to 0 to begin with. Increment it by one every time a city is clicked.

When you have finished, output the integer. This is the number of times cities were clicked.

Simon

Re: counting

Pete O'Hanlon24-Sep-08 2:22

Pete O'Hanlon

24-Sep-08 2:22

krishnavaradharajan wrote:
licking a city

Ooh yuck

. I'd rather not lick a city - it tastes all concretey.

Deja View - the feeling that you've seen this post before.

My blog | My articles | MoXAML PowerToys

Re: counting

Guffa24-Sep-08 2:31

Guffa

24-Sep-08 2:31

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

Yeah. And all the graffiti leaves my tounge looking really funny... Wink | ;)

Despite everything, the person most likely to be fooling you next is yourself.

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]

Last Visit: 31-Dec-99 18:00 Last Update: 27-Apr-24 10:38

Refresh

ᐊ Prev 1...6417 6418 6419 642064216422 6423 6424 6425 6426 Next ᐅ

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