C# Discussion Boards - CodeProject

Re: how to call a web method in a web form application??

Christian Graus1-Feb-09 22:41

1-Feb-09 22:41

txt speak only makes you look more stupid.

If you want help, try reading the forum rules, posting in the right forum, perhaps even googling for information or doing some basic reading on the technologies you are using. Did you even notice that I told you the answer ? If you browse to your web service, it will return test pages so you can execute the web methods via a URL.

Christian Graus

Driven to the arms of OSX by Vista.

Re: how to call a web method in a web form application??

Steve_2-Feb-09 0:01

Steve_

2-Feb-09 0:01

Your problem is that the method 'AddValue' does not take zero arguments. This is stated quite clearly in the error message you are receiving. Take a look at the AddValue method in your code or the documentation for it (if you didn't make it) and see what arguments it takes. Then double-click the error to find the line that is causing the error and make sure your call to AddValue is supplying all of the correct arguments.

Next time, as the other guy said, post in the right forum and clean up your grammar and you might get help faster.

Steve

chech box

t_nedelchev1-Feb-09 21:59

t_nedelchev

1-Feb-09 21:59

Hello everybody
How to change a size of box on checkBox control?
thanks in advance

Re: chech box

Christian Graus1-Feb-09 22:15

Christian Graus

1-Feb-09 22:15

you would need to create your own control, or to make the control owner drawn and draw it yourself, perhaps.

Christian Graus

Driven to the arms of OSX by Vista.

Re: chech box

Steve_2-Feb-09 0:07

Steve_

2-Feb-09 0:07

Do you want to change the size of just the check box control? CheckBoxs have (I think) the AutoSize property set to true. This will mean you cannot actually resize it in the form designer. Set this to false in the property grid or in code and you should be able to resize it. However, this will not make the actual box change size, just the area the control covers and the text will change position. If you want to actually make the box bigger, you will have to do as the other poster said and draw the box yourself.

how to make my application startup with windows

ahmedhassan961-Feb-09 21:50

ahmedhassan96

1-Feb-09 21:50

hi every body
i want to know how can i make my application startup with windows
thanks in advance

Re: how to make my application startup with windows

«_Superman_»1-Feb-09 22:13

«_Superman_»

1-Feb-09 22:13

Create the full path of your application under the registry key HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Run

«_Superman_»

Re: how to make my application startup with windows

ahmedhassan962-Feb-09 2:42

ahmedhassan96

2-Feb-09 2:42

thank you very much it worked with me

Re: how to make my application startup with windows

Giorgi Dalakishvili2-Feb-09 0:17

Giorgi Dalakishvili

2-Feb-09 0:17

See here: Managing Start-up[^]

Giorgi Dalakishvili

#region signature
My Articles

Asynchronous Registry Notification Using Strongly-typed WMI Classes in .NET [^]

My blog
#endregion

Re: how to make my application startup with windows

PIEBALDconsult2-Feb-09 4:27

PIEBALDconsult

2-Feb-09 4:27

I'd use a Windows Scheduled Task.

Flash in Windows Forms

Najmal1-Feb-09 21:41

Najmal

1-Feb-09 21:41

Hi..

How can import a flash vedio to a Windows Form??

Re: Flash in Windows Forms

Steve_2-Feb-09 0:09

Steve_

2-Feb-09 0:09

Did you try using Google?

How to save Gujarati font in Sql Server

jigneshDPatel1-Feb-09 21:23

jigneshDPatel

1-Feb-09 21:23

In My Application I us Vb.net 2008 in C# and my database is Sql server 2005 express Edition

In My application I am usig gujarati font so how can i save that gujarati font in database

Plese help me on this matter if any other idea so please tell me also

please help..........

Re: How to save Gujarati font in Sql Server

SeMartens1-Feb-09 21:30

SeMartens

1-Feb-09 21:30

Hi,

you cannot store strings with a specific font in a sql server. A font is just a description how to display characters. What you want to achieve is that the sql server stores a specific encoding. So set the encoding of your sql database to the one used for your language (try to google this, I don't know which encoding supports your language). This should help.

Regards
Sebastian

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

Re: How to save Gujarati font in Sql Server

Muhammad Shahid Farooq2-Feb-09 1:25

Muhammad Shahid Farooq

2-Feb-09 1:25

Aajignesh, read the following carefully I think this will help you:

For example table name is Customer. Customer table have two coulmns (CustomerId & CustomerName). You want to store Gujarati Font in second column (CustomerName). Set the datatype of CustomerName column to nvarchar(50), Then make the query look like as below:

Insert into Customer (CustomerId, CustomerName) values ('1', N'Write Name in Gujarati Font')

Note: Don't Forget to install Gujarati Font on your operating system.

Incase of any confusion feel free to ask muhammadshahidfarooq@yahoo.com

Re: How to save Gujarati font in Sql Server

jigneshDPatel2-Feb-09 1:56

jigneshDPatel

2-Feb-09 1:56

Thanks sir That's Work
1) sir what is the mening of N in this if u know so please tell me

thanks again to help me on this problem

Sir One another problem please help me on it

1) how can i set by default font set gujarati i try but every time i select language than write in gujarati other wise by default i write in english so if u have any idea so plese tell me

thanks you..........

Re: How to save Gujarati font in Sql Server

Muhammad Shahid Farooq2-Feb-09 19:49

Muhammad Shahid Farooq

2-Feb-09 19:49

N in insert query represent Unicode.

Q:Why we use Unicode?
A: Unicode can represent over 65,000 characters, it accommodates many languages whose characters are not represented in ANSI encoding. ANSI character encoding represents characters in one byte, it is limited to 256 characters.

For default input language, follow these steps:
1. Click Start, click Run, type intl.cpl, and then click OK.
2. Click the Languages tab, and then click Details.
3. On the Settings tab, click Add.
4. Select the language that you want in the Input language list, and then click OK.
5. Select the language that you want in the Default input language list.
6. Click OK two times.

Re: How to save Gujarati font in Sql Server

jigneshDPatel2-Feb-09 19:58

jigneshDPatel

2-Feb-09 19:58

Thanks you.

need query to calculate amount

harithadotnet1-Feb-09 21:01

harithadotnet

1-Feb-09 21:01

Hi,

I have a table like

Sno ReceiptNo CustomerId Amount Date commissionAmount AgentId
1 10 C96 5000 02/02/2009 500 A20
2 10 C96 5000 02/02/2009 300 A46
3 10 C96 5000 02/02/2009 200 A37
4 11 C50 3000 02/03/2009 300 A35
5 11 C96 2000 02/03/2009 200 A43

here one receiptid have multiple records with same customer.
this table contains multiple records with the same receiptno and customer id.but i want to add distinct amount of each receipt of perticular custimer. means here customer C96 total paid amount is 5000+2000 i.e 7000.
I want query for this.If any one give the answer it will be very useful for me . Thanks in advance.

Haritha.

Haritha

Re: need query to calculate amount

Najmal1-Feb-09 21:53

Najmal

1-Feb-09 21:53

HI Haritha.........

SELECT SUM(amount) FROM customer WHERE ReciptNo IN (SELECT DISTINCT ReceiptNo,amount FROM customer WHERE CustomerId='C96')

Rose | [Rose]

najmalccl@gmail.com

Re: need query to calculate amount

Muhammad Shahid Farooq2-Feb-09 1:08

Muhammad Shahid Farooq

2-Feb-09 1:08

Haritha, use the following query this will help you:

Select sum(Amount) as Amount_Sum from Customer group by CustomerId

Re: need query to calculate amount

Member 45019402-Feb-09 2:26

Member 4501940

2-Feb-09 2:26

Either of these will work if using sql server

with temp (ReceiptNo, CustomerID, Amount)
as
(
SELECT ReceiptNo, CustomerID, Amount
FROM customer
group by ReceiptNo, CustomerID, Amount
)
select CustomerID, sum(Amount) from temp group by CustomerID
GO

/*** or this one ***/


SELECT ReceiptNo, CustomerID, Amount
INTO [#temp]
FROM customer
GROUP BY ReceiptNo, CustomerID, Amount
select CustomerID, sum(Amount) from #temp group by CustomerID
GO

drop table #temp
GO

Re: need query to calculate amount

PIEBALDconsult2-Feb-09 4:38

PIEBALDconsult

2-Feb-09 4:38

Why the H are you using temporary tables for that? Confused | :confused:

Re: need query to calculate amount

PIEBALDconsult2-Feb-09 4:34

PIEBALDconsult

2-Feb-09 4:34

Why do these look like sports bookmaking[^] transactions? Suspicious | :suss:

Re: need query to calculate amount

priyareguri3-Feb-09 6:38

priyareguri

3-Feb-09 6:38

select distinct receiptno from tablename...
i will displays all records without duplicates then u can fine total amount of all records ...or particular customer records...

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