Re: Telephone answering mechine service c# - C# Discussion Boards

wi5nia14-Jan-09 11:31

wi5nia

14-Jan-09 11:31

no, I just want to show a list of LastNames from the table, and if there is a NULL value for the LastName column in a given row then show for that row the value from the column Company

Wendelius14-Jan-09 11:44

Wendelius

14-Jan-09 11:44

Okay, then you have at least two options. You can modify your SQL statement and create an additional column and bind to it, like (there may be typos in the examples):

string sql = "select LastName, FirstName, Company, <code>COALESCE(LastName, Company) AS ListData </code>"
             + "from TestTable";
SqlConnection conn = new SqlConnection(connString);
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
DataSet dataset1 = new DataSet();
da.Fill(dataset1, "TestTable");
listBox1.DataSource = dataset1.Tables["TestTable"];
listBox1.DisplayMember = "<code>ListData</code>";

or after filling the dataset, you can create a computed column:

string sql = "select LastName, FirstName, Company "
             + "from TestTable";
SqlConnection conn = new SqlConnection(connString);
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
DataSet dataset1 = new DataSet();
da.Fill(dataset1, "TestTable");
<code>dataset1.Tables["TestTable"].Columns.Add("ListData", 
                                         typeof(string), 
                                         "ISNULL(LastName,Company)");</code>
listBox1.DataSource = dataset1.Tables["TestTable"];
listBox1.DisplayMember = "ListData";

Hope it helps.

The need to optimize rises from a bad design.My articles[^]

wi5nia14-Jan-09 11:53

wi5nia

14-Jan-09 11:53

the second solution works like a charm Smile | :)

many thanks

Telephone answering mechine service c#

Wendelius14-Jan-09 12:00

Wendelius

14-Jan-09 12:00

You're welcome Smile | :)

The need to optimize rises from a bad design.My articles[^]

XDate in ZedGraph

Rayya14-Jan-09 9:23

Rayya

14-Jan-09 9:23

Hi,

I need the output of date time as DateTime format
"s" which means dd-MM-yyTHH:mm:ss using XDate of ZedGraph.

my code is s follow:
double x = (double)new XDate(yearData, monthData, dayData, hourData, minData, secData);

Then write AxisType.Date;

I am getting dd-MM-yy correctly, but HH:mm:ss as 00:00:00.

Can anyone please help to write a correct code to get the
required output?

Thanks.

Re: XDate in ZedGraph

EliottA14-Jan-09 12:44

EliottA

14-Jan-09 12:44

You won't find much help on third party controls here, you can consult their non-functioning wiki[^]

rikigr414-Jan-09 8:40

rikigr4

14-Jan-09 8:40

Hi All,

I am looking for code written in .NET that provides connection between application and telephone.
So that - the telephone will return a code according to input code that it get's from the user.

I'll be happy to get even a little help - if you know something that relate and can help me!!

Thanks. Wink | ;)

#realJSOP14-Jan-09 9:46

#realJSOP

14-Jan-09 9:46

TAPI, TAPI, He's your man!
If TAPI can't do it, no one can!

"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

User 665814-Jan-09 10:09

User 6658

14-Jan-09 10:09

Wow, that was truly poetic Laugh | :laugh:

modified 12-Sep-18 21:01pm.

Rutvik Dave14-Jan-09 11:18

Rutvik Dave

14-Jan-09 11:18

as Jhon told you TAPI is the only way.

you can download c# wrappers here[^]

or you can use windows dll like this[^].

rikigr414-Jan-09 21:18

rikigr4

14-Jan-09 21:18

Thank you!
I would be happy to get more specipic help - about getting back answer from the telephone (and not dialinig to the talaphone from the computer).

Thanks again!

Hmmm | :|

yafa15-Jan-09 4:03

yafa

15-Jan-09 4:03

in the link u got, were the code here:

The code below is responsible for registering incoming calls so that they can be handled by our application. For that you need to select the line on which you want to receive calls and press the Register button.

 Collapse Copy Code
try
{
    registertoken[line]=tobj.RegisterCallNotifications(ia[line],
                 true,true,TapiConstants.TAPIMEDIATYPE_AUDIO,2);    
    MessageBox.Show("Registration token : "+ 
                 registertoken[line], 
                 "Registration Succeed for line "+line);
}
catch(Exception ein)
{
    MessageBox.Show("Failed to register on line "+line,"Registration for calls");
}

The class given below is to be added depending upon your TAPI event handling requirements. This is specially designed according to the requirements of the application.

please read the article!!

How to determine if two C# exe come from the same source

gisa shel riki14-Jan-09 22:08

gisa shel riki

14-Jan-09 22:08

I have no help
only DASH HAM!

Wink | ;)

cwster14-Jan-09 8:03

Re: How to determine if two C# exe come from the same source

14-Jan-09 8:03

In Visual C# if I force a recompile of unchanged source code the resulting executable are not the same. Can anyone define where they should be different and why or provide a tool that will indicate if two exe files came from the same source code?

Thanks,
Curt

Scott Dorman14-Jan-09 9:00

Re: How to determine if two C# exe come from the same source

14-Jan-09 9:00

Most likely they are different due to changes in the assembly metadata, like the file version and/or assembly version. How are you determining the files are not the same?

Scott Dorman

Microsoft® MVP - Visual C# | MCPD
President - Tampa Bay IASA

[Blog][Articles][Forum Guidelines]

Hey, hey, hey. Don't be mean. We don't have to be mean because, remember, no matter where you go, there you are. - Buckaroo Banzai

cwster14-Jan-09 9:39

Re: How to determine if two C# exe come from the same source

14-Jan-09 9:39

I used HexEdit to compare the files. In one case the difference was from:
{231F082C-31A4-4DF7-A34E-9B7383E240FD}
to:
{20EFE830-6E58-4A20-B725-F263FA47C142}

which looks like a regenerated version but in other cases the differences were just a few "random" bytes.

My customer expects to being able to confirm a certain set of files was used to create a executable by comparing the executable created at another time. Is there another way to confirm this?

Scott Dorman14-Jan-09 9:43

Re: How to determine if two C# exe come from the same source

14-Jan-09 9:43

As Luc said, it really isn't possible to do a binary comparison on a file and tell what changed about them. The best you can hope for is that you can tell the file didn't change.

The only way to recompile and have the resulting binary be the same is to ensure that absolutely nothing in the source code changes, including things like version stamps, etc.

It isn't clear what your customers real expectation is and why they want this ability. A good source control system and build process will ensure that you can recreate an executable from the same source each time.

Scott Dorman

Microsoft® MVP - Visual C# | MCPD
President - Tampa Bay IASA

[Blog][Articles][Forum Guidelines]

Hey, hey, hey. Don't be mean. We don't have to be mean because, remember, no matter where you go, there you are. - Buckaroo Banzai

cwster14-Jan-09 9:54

Re: How to determine if two C# exe come from the same source

14-Jan-09 9:54

My customer has a medical device background (safety critical, high process) and I must PROVE the build process, especially when re-created on another machine, results in the same executable. Unfortunately, have good process isn't enough.

Scott Dorman14-Jan-09 9:57

Re: How to determine if two C# exe come from the same source

14-Jan-09 9:57

Hmmm...for the most part having a repeatable process has to be good enough. That is the basis for CMM certifications. ~~Would computing a CRC or some other type of checksum on the files and comparing that checksum be enough?~~

Scott Dorman

Microsoft® MVP - Visual C# | MCPD
President - Tampa Bay IASA

[Blog][Articles][Forum Guidelines]

Hey, hey, hey. Don't be mean. We don't have to be mean because, remember, no matter where you go, there you are. - Buckaroo Banzai

Dave Kreskowiak14-Jan-09 10:35

Dave Kreskowiak

14-Jan-09 10:35

Considering there are plenty of situations where COM-exposed GUID are generated on every compile, and never the same between compiles, and between machines, you can't compare the two and come up with the exact same binary.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Re: How to determine if two C# exe come from the same source [modified]

Luc Pattyn14-Jan-09 9:07

Luc Pattyn

14-Jan-09 9:07

Hi,

IMO this is impossible:
- first, pretending to know at what locations EXE files could differ even when all the sources are the same is assuming a lot, e.g. is it documented the compiler must allocate objects in a specific order? is it documented the linker will always link things in the same order?
- second, assume you have the magic tool; I build once from some sources; I build again from the same sources (tool says: same source); now I replace one of the source files by a copy, modifying some comments, the name of a local variable, the order of two declaration statements, etc
and build again; the tool will tell you once more the sources were the same although they were not.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

I use ListBoxes for line-oriented text (not TextBoxes), and PictureBoxes for pictures (not drawings).

modified on Friday, June 10, 2011 12:25 PM

Re: How to determine if two C# exe come from the same source

cwster14-Jan-09 9:46

Re: How to determine if two C# exe come from the same source [modified]

14-Jan-09 9:46

It's fairly common, at least in the embedded development world, to compare "executables" in this manner, however the "executable" is a binary image that is loaded into a chip.

I didn't intend a file name comparison of the sources. I was hoping there was another way to insure two executables are from exactly the same source code/included libraries/etc.

Luc Pattyn14-Jan-09 9:59

Luc Pattyn

14-Jan-09 9:59

Hi,

cwster wrote:
It's fairly common, at least in the embedded development world, to compare "executables" in this manner,

I am aware of that, however the original question seemed very general; under controlled circumstances
(same PC, same tools, same settings, etc, the only possible difference is in one or more source files) one can do much better obviously.

On the other hand, COFF/IntelHex/whatever you use to download code would be much simpler than the
Windows Portable Executable file format.

But anyway, I can always come up with a different source that results in an "exe" that is so similar that no tool in the world will be able to tell whether the original source file was used or not.
(comments, local var names, declaration order, etc etc).

Suggestion: calculate checksums for each source file (use a separate tool that runs before building
the "exe", and somehow add a DATA section that gets to contain those checksums (this is not hard
when another little tool creates a new source file from all the checksums, possibly using
assembly code or linker commands).

Alternative: you could replace checksums by embedded version numbers, if you would trust those.
That would require e.g. an editor that always increments the version number automatically.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

I use ListBoxes for line-oriented text (not TextBoxes), and PictureBoxes for pictures (not drawings).

modified on Friday, June 10, 2011 12:26 PM

Re: How to determine if two C# exe come from the same source

#realJSOP14-Jan-09 9:46

#realJSOP

14-Jan-09 9:46

You have to sign the assembly.

Re: How to determine if two C# exe come from the same source

Scott Dorman14-Jan-09 9:56