TCP/IP - Sockets - C# Discussion Boards

polishprogrammer6-Dec-07 9:34

6-Dec-07 9:34

It answers the question at face value, more or less. My question had to do more with the mechanism for updating the database from C# code. I brushed up on my SQL a bit this morning and found the ALTER TABLE ADD COLUMNNAME command which works if I always know exactly what column names to add, but I want to automate the process.

Basically, I'm look to set up a mechanism that will search all the tables in the database if the software version has changed and compare the table definition for each table in the existing database with the table definition for each and every table in the database that will deploy with the newer version of the software to determine if there are any changes to the database. If so, then I need to execute the ALTER TABLE ADD COLUMNNAME command to add those new fields to the existing database.

Now, I can perform this process through some brute force type of programming, where I get the schema for each table in the newer version of the DB, compare it to the scheme for each table in the existing version of the DB, and then update the data accordingly, but if there's a more efficient way to accomplish the task, I would be glad to hear it.

How to Counter Sign in various levels

Member 36551006-Dec-07 3:03

Member 3655100

6-Dec-07 3:03

Hello.

The MSDN says:
"This implementation of CMS/PKCS #7 supports only one level of countersignature. That is, a signature can be signed, which forms a countersignature, but that countersignature cannot be signed again."
( http://msdn2.microsoft.com/en-us/library/yeayfsh9.aspx[^] )

So, how do I, in C#, compute a CounterSignature of a CounterSignature, and add this new CounterSignature to the SignedCms ?

The RFC3852 says:
"11.4. Countersignature
The countersignature attribute type specifies one or more signatures
on the contents octets of the signature OCTET STRING in a SignerInfo
value of the signed-data. That is, the message digest is computed
over the octets comprising the value of the OCTET STRING, neither the
tag nor length octets are included. Thus, the countersignature
attribute type countersigns (signs in serial) another signature.

The countersignature attribute MUST be an unsigned attribute; it MUST
NOT be a signed attribute, an authenticated attribute, an
unauthenticated attribute, or an unprotected attribute.
The following object identifier identifies the countersignature
attribute:

id-countersignature OBJECT IDENTIFIER ::= { iso(1) member-body(2)
us(840) rsadsi(113549) pkcs(1) pkcs9(9) 6 }

Countersignature attribute values have ASN.1 type Countersignature:

Countersignature ::= SignerInfo

Countersignature values have the same meaning as SignerInfo values
for ordinary signatures, except that:

1. The signedAttributes field MUST NOT contain a content-type
attribute; there is no content type for countersignatures.

2. The signedAttributes field MUST contain a message-digest
attribute if it contains any other attributes.

3. The input to the message-digesting process is the contents
octets of the DER encoding of the signatureValue field of the
SignerInfo value with which the attribute is associated.

A countersignature attribute can have multiple attribute values. The
syntax is defined as a SET OF AttributeValue, and there MUST be one
or more instances of AttributeValue present.

The UnsignedAttributes syntax is defined as a SET OF Attributes. The
UnsignedAttributes in a signerInfo may include multiple instances of
the countersignature attribute.

A countersignature, since it has type SignerInfo, can itself contain
a countersignature attribute. Thus, it is possible to construct an
arbitrarily long series of countersignatures."

Somebody can help me? Again:
How do I, in C#, compute a CounterSignature of a CounterSignature, and add this new CounterSignature to the SignedCms ?

string in sql statement

eyeseetee6-Dec-07 2:18

eyeseetee

6-Dec-07 2:18

Hi
How do you put a string value in sql statement
for example

select * from table where tablename = string(tablename)
something like thta

cheers

Re: string in sql statement

Skippums6-Dec-07 2:29

Skippums

6-Dec-07 2:29

Isn't it single quotes (')?

-Jeff

Re: string in sql statement

eyeseetee6-Dec-07 2:49

eyeseetee

6-Dec-07 2:49

no this didnt work either
any more suggessiotns?

Re: string in sql statement

eyeseetee6-Dec-07 3:02

eyeseetee

6-Dec-07 3:02

found it:
use this '" + string + "'

Re: string in sql statement

Abhijit Jana6-Dec-07 3:26

Abhijit Jana

6-Dec-07 3:26

Jamie1985 wrote:
select * from table where tablename = string(tablename)

<code>select * from student where name = '" + txtname+ "' </code><pre>

Best Regards
-----------------
Abhijit Jana
View My CodeProject Articles

"Success is Journey it's not a destination"

TCP/IP - Sockets

half-life6-Dec-07 1:56

half-life

6-Dec-07 1:56

HI,

i'm sending messages from App1 to App 2 in TCP/IP
the thing is that first collect all info and rhen sends it little Messages
App2 reads the MSG One By One and display

the Thing is that when i debug all the MSG arrives (or get there in time)
but when i run the EXE and send info To App2, not all the Info Arrives
About (70%!!!!!!!!!!!!!!!) Lost, how can i Get Each MSG

i'm using :

<br />
connectionSocket = new Socket(AddressFamily.InterNetwork,<br />
                               SocketType.Seqpacket,<br />
                                 ProtocolType.Tcp);<br />
<br />
<br />
ipAddress = IPAddress.Parse(runnerTcpIP);<br />
<br />
ipEndPoint = new IPEndPoint(ipAddress,int.Parse(runnerPortNumber));<br />

type of connection with Begin/EndConnect
Send/Recieve

THANKS Smile | :)

Have Fun
Never forget it

Re: TCP/IP - Sockets

Andre Azevedo6-Dec-07 2:03

Andre Azevedo

6-Dec-07 2:03

half-life wrote:
connectionSocket = new Socket(AddressFamily.InterNetwork,
SocketType.Seqpacket,
ProtocolType.Tcp);

Use SocketType.Stream instead.

________________________________________________________________
There are 10 kind of people: those who knows binary and those who doesn't.

Re: TCP/IP - Sockets

half-life6-Dec-07 2:07

half-life

6-Dec-07 2:07

Did It

Still Not Working

THANKS Anyway

Have Fun
Never forget it

Re: TCP/IP - Sockets

Mike Dimmick6-Dec-07 3:09

Mike Dimmick

6-Dec-07 3:09

I suspect you're expecting message boundaries to be preserved, that is, the data from one Send to appear in one Receive. TCP doesn't work like that. I suggest you read How to use TCP effectively[^] and the rest of the Winsock Programmer's FAQ[^]. It's C-oriented, but still makes sense for a .NET programmer.

DoEvents: Generating unexpected recursion since 1991

Re: TCP/IP - Sockets

half-life6-Dec-07 3:58

half-life

6-Dec-07 3:58

mmmmmmmmm,

THANKS man.

i need to build a header to identify where a MSG begins
and where it ends

Have Fun
Never forget it

Change cell color of dataGridView

M Riaz Bashir6-Dec-07 1:35

M Riaz Bashir

6-Dec-07 1:35

Hi,

How can I change the color on particular cell of dataGridView?

Thank you in advance

(Riaz)

Re: Change cell color of dataGridView

Sathesh Sakthivel6-Dec-07 1:39

Sathesh Sakthivel

6-Dec-07 1:39

In the data grid, you will have to create custom column styles classes derived from DataGridColumnStyle) which would paint the background based on the row that you want to highlight. The DataGrid is very column-based, so doing something like changing the row highlighting is difficult, to say the least.

Basically, you have to create new versions of the DataGridColumnStyle
for your table, and then set the backgrounds appropriately.

SSK.

Anyone who says sunshine brings happiness has never danced in the rain.

FormDats (width, height, ...) save to XML for Dual-Monitors

merlin.AT6-Dec-07 1:29

merlin.AT

6-Dec-07 1:29

Hello

I search for an application that shows me how to save the datas (width, height, left, top, windowstat) from a few forms to a XML-file and restore them an apllication startup. It sould be handle for 2 monitors. So when the application was closed an monitor 2 and on the next start the monitor 2 was not available, the apllication must start up on monto 1.

Did anyone has such a class on C# for me?

Many thank
Thomas

Ftp over Ftp Proxy GetResponse() error

Springtime6-Dec-07 1:22

Springtime

6-Dec-07 1:22

Hi,

Im trying to connect ftp server over "ftp-proxy".
Here my code:

FtpWebRequest request = (FtpWebRequest)FtpWebRequest.Create("ftp://ftp.xxx.com");
request.Credentials = new NetworkCredential("User", "PASS");
System.Net.WebProxy prox = new System.Net.WebProxy("111.111.111.111",21);
prox.Credentials = new NetworkCredential("USER", "PASS");
request.Proxy = prox;
request.UsePassive = true;
request.UseBinary = true;
request.UsePassive = true;
request.Method = WebRequestMethods.Ftp.ListDirectoryDetails;
FtpWebResponse response = (FtpWebResponse)request.GetResponse();

I get an error on the last line from my code:
FtpWebResponse response = (FtpWebResponse)request.GetResponse();
-->The server committed a protocol violation.

Can anybody help??

Thx in advance.

Re: Ftp over Ftp Proxy GetResponse() error

Sam Xavier17-Jan-08 23:47

Sam Xavier

17-Jan-08 23:47

Hello,

Are you sure that you are using the correct port of web proxy?

Best Regards,
Sam Xavier
www.componentone.com

List of Countries

nagendrathecoder6-Dec-07 1:21

nagendrathecoder

6-Dec-07 1:21

Hi All,

I need list of all countries in the world in my application.
Can anyone tell me how to obtain the list of all countries?

Thanks,
Nagendra.

Re: List of Countries

Nagy Vilmos6-Dec-07 1:37

Nagy Vilmos

6-Dec-07 1:37

Try those nice ISO boys[^].

Panic, Chaos, Destruction.
My work here is done.

Re: List of Countries

nagendrathecoder6-Dec-07 2:09

nagendrathecoder

6-Dec-07 2:09

hi,

i m confused, how can i add that list to my application. Confused | :confused:

Re: List of Countries

benjymous6-Dec-07 2:25

benjymous

6-Dec-07 2:25

It's a text file - just strip out the info you don't need, and load it into your program. Shouldn't take more than a few minutes to code

--
Help me! I'm turning into a grapefruit!
Buzzwords!

Re: List of Countries

Ravi Bhavnani6-Dec-07 3:49

Ravi Bhavnani

6-Dec-07 3:49

Does CultureTypes[^] help?

/ravi

This is your brain on Celcius
Home | Music | Articles | Freeware | Trips
ravib(at)ravib(dot)com

How to Generate Sqlscript for Table using Query Analyzer

Satish - Developer6-Dec-07 0:46

Satish - Developer

6-Dec-07 0:46

I want to generate a script for tables and stored procedures using query analyzer.

for stored procedures i got it using -- sp_helptext spname

For tables how to do? using sp_help tablename -- giving structure of table and not generating a script. but i need script for this table using query analyzer

Cross post. Please ignore

Pete O'Hanlon6-Dec-07 1:05

Pete O'Hanlon

6-Dec-07 1:05

See title

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

My blog | My articles

Instantiate Shell32.ShellLinkObjectClass object

dan!sh 6-Dec-07 0:34

dan!sh

6-Dec-07 0:34

Hi can anyone help me to instantiate Shell32.ShellLinkObjectClass object.

I am doing it this way :
Shell32.ShellLinkObjectClass o = new ShellLinkObjectClass();

And it gives following exception.
Retrieving the COM class factory for component with CLSID {11219420-1768-11D1-95BE-00609797EA4F} failed due to the following error: 80040154.

Until you realize this message has nothing to say, its too late to stop reading

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