Re: Getting CMYK colors from bmp - C# Discussion Boards

Susan Hernandez1-Sep-05 5:36

1-Sep-05 5:36

This web site http://www.aspfaq.com/show.asp?id=2160[^] seems to indicate that if you have the free version of SQL Server engine, MSDE (I think that's something like Microsoft SQL Desktop Engine) you should have the osql command line tool. That's like query analyzer without the graphical interface.

If that's the case (it would be in the same BINN folder I wrote about last post) then you can set up your logins using osql/SQL commands if you have to.

Re: can't find Enterprise Manager

theStorminMormon1-Sep-05 6:10

theStorminMormon

1-Sep-05 6:10

OK, OSQL.exe works, but I can't log in to ther server. Since it's Integrated Security I would have thought I dont' need username/password, but the command prompt wants me to enter them.

Ideas?

The ends can never justify the means. It is the means that determine the ends.

Re: remote database connection question

Susan Hernandez31-Aug-05 15:20

Susan Hernandez

31-Aug-05 15:20

Of course, if you don't log in with a network account, there is always the question to investigate: can you get to ANY file on the server in question, from your laptop? I'm not sure how your setup is - well - set up, such that you are accessing things remotely.

Re: remote database connection question

theStorminMormon1-Sep-05 1:37

theStorminMormon

1-Sep-05 1:37

You may be a newbie, but you definately know a whole lot more than I do. Thanks so much for your help. I'm going to try out all the things that you've mentioned so far.

I can get to the server from my laptop, but it asks me for a login to get on. I have to supply domain name\user name and password before I get access.

Also, just so you know, the database one I've assembled from scratch and is located on my personal workstation, so I don't have to talk to an admin. Besides... I work in a small company. Our "network admin" is also our accountant.

I'll let you know how it goes!

The ends can never justify the means. It is the means that determine the ends.

More info on MSDE

Susan Hernandez1-Sep-05 7:35

Susan Hernandez

1-Sep-05 7:35

Well, I'm glad I have been able to be of some slight assistance so far. I was happy to see in the other thread (MSDE 2000) some of the same information we've been talking about.

So what it looks like you may have to do at this point is try to log in using an administrator password. The default administrator user name is "sa" and the default password is usually blank, "sa", or "password". I hope you changed that during installation, but if you didn't, then you can try one of those suggestions. Once you log in as an administrator, you may want to set up some logins right away, such as the ComputerName\Administrators group with full privileges.

I really feel bad for you that you are working with MSDE as your first experience working with SQL Server, because although the engine is great and powerful, there is no graphical help and you have to do everything using SQL Commands. Larger ramp-up time than normal. The good news is there's very comprehensive documentation called SQL Server Books On-Line at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_tsqlcon_6lyk.asp?frame=true[^] which gives you syntax for all the SQL Queries you could ever wish to do.

Let's take a SQL Server Authentication example:

Add the login 'SusanH' to the SQL Server instance
EXEC sp_addlogin 'SusanH', 'SusanHsPassword'

Give 'SusanH' some permissions

GRANT CREATE DATABASE, CREATE TABLE<br />
TO SusanH

Now let's look at a Windows Authentication example:

Grant permissions to an existing domain account
EXEC sp_grantlogin 'MyDomain\SusanH' -or-
EXEC sp_grantlogin 'MyComputerName\SusanH'

I'm not completely sure if these are proper samples that will work, however I think you get the idea and can take it from here by looking through the transact-sql reference documentation. They give the syntax for the statements at the top, examples at the bottom, and links to 'see also' topics.

Good luck.

Getting CMYK colors from bmp

yarns31-Aug-05 4:19

yarns

31-Aug-05 4:19

Hi,
i have file - bitmap how using C# i can get each layer for all four color CMYK?

Greetings

Re: Getting CMYK colors from bmp

Niklas Ulvinge31-Aug-05 8:10

Niklas Ulvinge

31-Aug-05 8:10

Layers?

If you want to convert RGB to CMYK then try to search the rather old site:
www.google.com and you'll find it in a sec, try the words rgb cmyk conversion algorithm formula or something alike.

Niklas Ulvinge aka IDK

Re: Getting CMYK colors from bmp

Dario Solera31-Aug-05 8:54

Dario Solera

31-Aug-05 8:54

BTW, the correct formula should be:

C = 1.0 - R
M = 1.0 - G
Y = 1.0 - B
K = min(C, M, Y)

CORRECTION: R, G, B values must converted to 'float'.
For example 255 = 1.0, 127 ~ 0.5
Use this: FloatValue = R(or G or B) / 255.

[ITA] Tozzi ha ragione: Gaia si sta liberando di noi.
[ENG] Tozzi is right: Gaia is obliterating us.

-- modified at 15:29 Wednesday 31st August, 2005

Re: Getting CMYK colors from bmp

Niklas Ulvinge31-Aug-05 8:57

Niklas Ulvinge

31-Aug-05 8:57

Are you sure?

I've seen some other more complex formulas...

Niklas Ulvinge aka IDK

Re: Getting CMYK colors from bmp

Dario Solera31-Aug-05 9:29

Dario Solera

31-Aug-05 9:29

I'm pretty sure.

However you can try.

[ITA] Tozzi ha ragione: Gaia si sta liberando di noi.
[ENG] Tozzi is right: Gaia is obliterating us.

Re: Getting CMYK colors from bmp

Niklas Ulvinge31-Aug-05 9:33

Niklas Ulvinge

31-Aug-05 9:33

I think the different formulas perform better and worse, the quality of the colors is redused with the conversion and the complex one's isn't losing as much quality as the others, I think.

Niklas Ulvinge aka IDK

Re: Getting CMYK colors from bmp

Dario Solera31-Aug-05 9:41

Dario Solera

31-Aug-05 9:41

Yes, I believe it too. After a google search, I have noticed that each software house uses different formuals. The ones I've posted are used by Adobe for the PDF format.

Try to download the PDF specifications (1300 pages or so!!!) from the Adobe site. Unfortunately I don't remember the exact link.

[ITA] Tozzi ha ragione: Gaia si sta liberando di noi.
[ENG] Tozzi is right: Gaia is obliterating us.

Re: Getting CMYK colors from bmp

Andrew Kirillov31-Aug-05 9:01

Andrew Kirillov

31-Aug-05 9:01

Hello

Yes, Niklas is right. There is no any conversion classes from RGB to CMYK in .NET. So, the only way is to get conversion formulas from google and use them by yourself.

With best regards,
Andrew

Enterprise Library Data Block - ExecuteNonQuery method with rows affected as return value

Member 106086631-Aug-05 4:14

Member 1060866

31-Aug-05 4:14

I am using Data Application Block of June 2005 version of enterprise library. I am able to use the executeNonQuery method which is given in the quick starts.
string sqlCommand = "USP_U_ChangeUserPassword";
Database db = DatabaseFactory.CreateDatabase();
DBCommandWrapper commandWrapper = db.GetStoredProcCommandWrapper(sqlCommand);
commandWrapper.AddInParameter("@password", DbType.String, password);
db.ExecuteNonQuery(commandWrapper)

But this way we will not get the number of affected rows.

I tried to use the overloaded ExecuteNonQuery() which returns affected rows
eg,
string sqlCommand = "spChangeName";
Database db = DatabaseFactory.CreateDatabase();

SqlParameter[] arParams = new SqlParameter[2];
SqlParameter param1 = new SqlParameter("@FName", DbType.String);
param1.Value = "Johnson22";
arParams[0] = param1;
SqlParameter param2 = new SqlParameter("@LName", DbType.String);
param2.Value = "White";
arParams[1] = param2;
int affectedRows = db.ExecuteNonQuery("spChangeName", arParams);

But this is throwing the following error
Failed to convert parameter value from a SqlParameter to a string.

Please provide me a solution for this issue

Re: Enterprise Library Data Block - ExecuteNonQuery method with rows affected as return value

Susan Hernandez31-Aug-05 14:19

Susan Hernandez

31-Aug-05 14:19

I do not have an answer to your question. However, I would like to suggest to you the Enterprise Library home on GotDotNet where they have a message forum, and they break it down by block.

http://www.gotdotnet.com/codegallery/codegallery.aspx?id=295a464a-6072-4e25-94e2-91be63527327[^]

You may need a Passport (hotmail account) to access this, I'm not sure.

Re: Enterprise Library Data Block - ExecuteNonQuery method with rows affected as return value

Susan Hernandez31-Aug-05 14:28

Susan Hernandez

31-Aug-05 14:28

I'm wondering if you can access RowsAffected of the command wrapper, and if that would properly give you back the rows affected.

<br />
...<br />
Database db = DatabaseFactory.CreateDatabase();<br />
DBCommandWrapper commandWrapper = db.GetStoredProcCommandWrapper(sqlCommand); <br />
commandWrapper.AddInParameter("@password", DbType.String, password); <br />
db.ExecuteNonQuery(commandWrapper);<br />
<br />
int rowsAffected = commandWrapper.RowsAffected;<br />

I haven't tried this myself, so I'm sorry if I'm looking in the wrong direction.

-- modified at 20:28 Wednesday 31st August, 2005

Re: Enterprise Library Data Block - ExecuteNonQuery method with rows affected as return value

Member 106086631-Aug-05 17:53

Member 1060866

31-Aug-05 17:53

Thanks Susan, your suggestion is working fine

Re: Enterprise Library Data Block - ExecuteNonQuery method with rows affected as return value

Susan Hernandez1-Sep-05 7:50

Susan Hernandez

1-Sep-05 7:50

FYI

I think the reason your second example did not work was because you were trying to pass in a SqlParameter array into db.ExecuteNonQuery, whereas looking at the constructor for it, it looks like it's asking for an object array of the actual values, not the parameters:

public virtual int ExecuteNonQuery(string storedProcedureName, params object[] parameterValues)

So I would guess that your second code sample should be something like:

string storedProcName = "spChangeName";<br />
Database db = DatabaseFactory.CreateDatabase();<br />
<br />
int affectedRows = db.ExecuteNonQuery(storedProcName, "Johnson22", "White");<br />

Using c++ dll in c#

JuanAlbertoMD31-Aug-05 4:02

JuanAlbertoMD

31-Aug-05 4:02

Hello!

I am trying to use a DLL that contains functions of c++ in c # but I have not been able to make it, this DLL is of a software called LOOX Maker, which is a editor graphic that has many options reason why I want to reuse that code and not to have to program it again, also i have the source of this program, I have tried several things but I have not obtained it. somebody that has more experience in this type of things can help me? I can send the project to you where I am trying to use it and also the DLL and source code of LOOX Maker, I hope that somebody can help me.

Re: Using c++ dll in c#

Mohamad Al Husseiny31-Aug-05 4:50

Mohamad Al Husseiny

31-Aug-05 4:50

Use P/Invoke which mainly used to let us Windows API Function but you can use it with regular dll
look at Calling Win32 DLLs in C# with P/Invoke[^]

MCAD

C# Project Integration

Jim Barber31-Aug-05 3:35

Jim Barber

31-Aug-05 3:35

Hi all. I've been using C#.net for about 6 months and love it. I have several projects that I would like to roll under one project. Now, while I understand how to import the projects in to my main project, I am having a hard time calling those project forms from my main form menu and I also get an error that my main form and the other project forms have multiple entry points.

Can someone please help me understand this quandry and help me find a solution? I'm sure you genius' out there know how to fix this and are grinning as you read this.

Sincerely,

J. Barber
C#.net newby! Confused | :confused:

Re: C# Project Integration

Judah Gabriel Himango31-Aug-05 6:29

Judah Gabriel Himango

31-Aug-05 6:29

You have a solution file (.sln) that contains multiple projects files (.csproj).

For one project to call some object in another project, you need to right-click on the project's references in Visual Studio and Add Reference to the other project. Then you'll be able to call any object in the project you just added a reference to.

As for multiple entry points, that's the compiler telling you that several of your projects contain a "static void Main" method, which is always the entry point for an executable. You can only have one static void main per project.

Tech, life, family, faith: Give me a visit.
I'm currently blogging about: Cops & Robbers
Judah Himango

Re: C# Project Integration

Lars Niedziolka31-Aug-05 14:26

Lars Niedziolka

31-Aug-05 14:26

Hi Barbar,

if you create a common windows application, Microsoft Visual Studio create a project with one Form. And this form has a static Method Main. This Main is the entry point for your Application (the first called Method). All you have to do is to make sure that you have exactly one static Main method.
For instance, create a new class and add a static Main method and delete all others Mains.

It's unimportant where you define your Main method.

Lars Niedziolka

How Can I Add and ...

mostafa_h31-Aug-05 3:06

mostafa_h

31-Aug-05 3:06

Hi!
thanks for help
I'm a beginner in C#.net and this is my question:
in my database application and in my form , I use 2 table from SQL .In table1(mainTable) my fields are id_car,car,id_city and in Table2 my fields are id_city,city.id_city in table1 has a relation to id_city in Table2 , but I want to fill the Datagrid by table1 .I have a textbox,combobox and a datagrid ,in my form and for displaying the records , I use a View in SQL .
THANKS if anyone to reply that How can I add,update,Delete
the table in my form .by the way ,I try to find a sample for my reply ,but I Can't .
thanks in advance!!!
Mostafa

Re: How Can I Add and ...

Mohamad Al Husseiny31-Aug-05 5:03

Mohamad Al Husseiny

31-Aug-05 5:03

You can write somthing like

SqlDataAdapter adabter=new SqlDataAdapter("Select id_car,car,id_city from table1","Your connection string");
DataTable dt=new DataTable("tableName");
adabter.Fill(dt);
textBox1.DataBindings.Add("Text",dt,"id_car");

other control like datagrid have Datasource property
which you can use it to display data in the datagrid
for more info look at
ADO.NET Overview[^]
Note:
if you use database other than sql server use its data provider classes

MCAD

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