Re: usercontrol - C# Discussion Boards

12-Nov-09 9:48

Hi I create a windows form control library and use it in my forms;
I want to transfer a variable from my component to my code in form;
How can i do it?

Christian Graus12-Nov-09 10:20

12-Nov-09 10:20

This is a pretty basic question. How did you create a form control library ?

You can expose values as properties and read them in your form. Or you can expose a delegate that fires when a value is changed.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

farokhian12-Nov-09 10:28

12-Nov-09 10:28

I crete form control library like other !
Is it a hard job?!

Christian Graus12-Nov-09 10:42

12-Nov-09 10:42

farokhian wrote:
Is it a hard job?!

It requires you to write a line or two of code. If you don't know how to create a property ( let alone a delegate ), then I would suggest you buy a basic C# book and read it. I assume this is for a class, or you are teaching yourself. You can't possibly be a paid programmer ? Just buy a book and work through it, don't worry about class libraries if you don't even know basic C#.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

farokhian12-Nov-09 10:56

12-Nov-09 10:56

I am teaching my self;
And i create properties and my problem was solved.
I don't think these things are so hard to learn ?!
This is the simple property that i create :
public string TxtBoxId
{
get
{
return text;
}
set
{
text = value;
}

}

Anyway THX.

Christian Graus12-Nov-09 10:59

12-Nov-09 10:59

Yes, that's all you need. What I am trying to say is, if you want to learn, buy a book to learn these sort of basics, otherwise there will always be holes in what you know, in terms of the fundamentals.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

farokhian12-Nov-09 11:06

12-Nov-09 11:06

Thanks alot for your suggestion .
Be sure that i do your suggetion.

Good Luck

Christian Graus12-Nov-09 11:15

How can I check if a table exists?

12-Nov-09 11:15

I hope so. I've urged you to buy a basic book before, and you plainly have not done it.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Emmet_Brown12-Nov-09 9:24

12-Nov-09 9:24

can anyone help?

I tried to google out the solution but none of the answers I found was non proper for C#.

I've a MS SQL Database (Compact Edition(this is not an issue here))

I want to check if a table exists, what should I do?

I found an SQL statement for this

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TableName]') AND type in (N'U'))

but I could not figure out how to use this in C#

My first idea is=

string command2 = "IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TableName]') AND type in (N'U'))"
SqlCeCommand com2 = new SqlCeCommand(command2, conn);

Where should I look if it returned 1 or 0?

Christian Graus12-Nov-09 9:32

12-Nov-09 9:32

SQLCe will not support [dbo]. at the head of a table name. I don't know if it supports this sort of call ( I've never tried it ). Remove the [dbo]. and then complete the statement ( such as if EXISTS... select 1 ELSE select 0 ) then you can execute scalar and see if you get 1 or 0 back. You can experiment inside SQL Server management console to establish exactly what SQL works.

Your alternative is to say select * from tablename and do it in a try catch to see if it blows up ( presumably b/c the table does not exist )

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Emmet_Brown12-Nov-09 9:36

12-Nov-09 9:36

thanks I'll try

furthermore, just to know

Can I use this "if -> else" format like below?

IF (blahblahblah) >0 BEGIN CREATE TABLE MyTable (...etc) END"

Christian Graus12-Nov-09 9:42

12-Nov-09 9:42

I think so. I've never executed SQL that complex outside of a proc, but I don't see why you shouldn't be able to.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Emmet_Brown12-Nov-09 9:50

12-Nov-09 9:50

according to compiler
Compact Edition does not support the function OBJECT_ID()
I guess try-catch is the only solution
is it?

Christian Graus12-Nov-09 10:43

12-Nov-09 10:43

I would presume so. I am not surprised, CE is a very cut down version, designed to be portable, not complete.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

The Man from U.N.C.L.E.12-Nov-09 9:36

The Man from U.N.C.L.E.

12-Nov-09 9:36

Just execute the command, but a better command would be

string command2 = "Select Case OBJECT_ID('TableName') when null then 0 else 1 end;";
SqlCeCommand com2 = new SqlCeCommand(command2, conn);
bool tableExists = (bool)com2.ExecuteScalar();

If you have knowledge, let others light their candles at it.
Margaret Fuller (1810 - 1850)
www.JacksonSoft.co.uk

Emmet_Brown12-Nov-09 9:39

12-Nov-09 9:39

oh this works?
I'll try right now Big Grin | :-D

Emmet_Brown12-Nov-09 9:47

12-Nov-09 9:47

The function is not recognized by SQL Server Compact Edition. [ Name of function = OBJECT_ID,Data type (if known) = ]

..it says

pointing out the

bool tableExists = (bool)com2.ExecuteScalar();

line :/

The Man from U.N.C.L.E.12-Nov-09 10:48

The Man from U.N.C.L.E.

12-Nov-09 10:48

SQL CE. silly me.

string command2 = "SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'your table name'";
SqlCeCommand com2 = new SqlCeCommand(command2, conn);
bool tableExists = false;
If ((Integer)com2.ExecuteNonQuery() > 0){
   tableExists = true;
}

ExecuteNonQuery returns the number of rows selected and if the table exists the return value will be 1.

If you have knowledge, let others light their candles at it.
Margaret Fuller (1810 - 1850)
www.JacksonSoft.co.uk

Emmet_Brown12-Nov-09 10:56

12-Nov-09 10:56

oh thanks =)

How to convert Dialogic .vox to .wav using c# or vb

PIEBALDconsult12-Nov-09 9:46

PIEBALDconsult

12-Nov-09 9:46

I would likely use SELECT COUNT(*) FROM sys.objects ... to see how many tables have that name and type.

[Message Deleted]

Michael Smacks12-Nov-09 8:46

Michael Smacks

12-Nov-09 8:46

[Message Deleted]

bruze12-Nov-09 8:45

bruze

12-Nov-09 8:45

Can any one help,

How to convert Dialogic .vox to .wav file using c# or vb.

I have dialog vox file,I need to convert Dialogic .vox to .wav file using c# or vb.

Below code using convert ADPCM Vox to Wav but my requirement is Dialogic .vox to .wav

Module moduleVOX2WAV

    Dim WaveHeader() As Int32 = New Int32() {&H46464952, &HFFFFFFDB, &H45564157, &H20746D66, 16, &H10001, 6000, 12000, &H100002, &H61746164, -1}
    Dim IndexShift() As Int16 = New Int16() {-1, -1, -1, -1, 2, 4, 6, 8}
    Dim StepSize() As Int16 = New Int16() {16, 17, 19, 21, 23, 25, 28, 31, 34, 37, 41, 45, 50, 55, 60, 66, 73, 80, 88, 97, 107, 118, 130, 143, 157, 173, 190, 209, 230, 253, 279, 307, 337, 371, 408, 449, 494, 544, 598, 658, 724, 796, 876, 963, 1060, 1166, 1282, 1411, 1552, 1707, 1878, 2066, 2272, 2499, 2749, 3024, 3327, 3660, 4026, 4428, 4871, 5358, 5894, 6484, 7132, 7845, 8630, 9493, 10442, 11487, 12635, 13899, 15289, 16818, 18500, 20350, 22385, 24623, 27086, 29794}
    Dim Nibble2Bit(,) As Int16 = New Int16(,) {{0, 0, 0, 0}, {0, 0, 0, 1}, {0, 0, 1, 0}, {0, 0, 1, 1}, {0, 1, 0, 0}, {0, 1, 0, 1}, {0, 1, 1, 0}, {0, 1, 1, 1}, {1, 0, 0, 0}, {1, 0, 0, 1}, {1, 0, 1, 0}, {1, 0, 1, 1}, {1, 1, 0, 0}, {1, 1, 0, 1}, {1, 1, 1, 0}, {1, 1, 1, 1}}
    Dim SignTable() As Int16 = New Int16() {1, -1}
    Dim StepSizeIndex As Int16 = 0
    Dim Signal As Int16 = -2
    Dim AvgBuffer() As Int16 = New Int16() {0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0}
    Dim AvgIndex As Int16 = 0
    Dim Total As Int32 = 0
    Dim Length As Int32
    Dim Offset As Int32
    Dim nibble As Int16
    Dim ReadBuffer(4096) As Byte
    Dim WriteBuffer(8192) As Int16

    Public Sub Convert(ByVal srcVOXFile As String, ByVal destWAVFile As String)
        Dim strm As New IO.FileStream(srcVOXFile, IO.FileMode.Open, IO.FileAccess.Read)
        FileOpen(2, destWAVFile, OpenMode.Binary, OpenAccess.Write, OpenShare.LockWrite)
        FilePut(2, WaveHeader)
        Length = 4096
        While Length = 4096
            Length = strm.Read(ReadBuffer, 0, 4096)
            For Offset = 0 To Length - 1
                nibble = 0
                Signal += Decode(ReadBuffer(Offset) \ 16)
                If (Signal > 2047 Or Signal < -2047) Then Truncate()
                WriteBuffer(2 * Offset) = Signal
                nibble = 1
                Signal += Decode(ReadBuffer(Offset) Mod 16)
                If (Signal > 2047 Or Signal < -2047) Then Truncate()
                WriteBuffer(2 * Offset + 1) = Signal
            Next
            FilePut(2, WriteBuffer)
            Total += Length
        End While
        strm.Close() : strm = Nothing
        Total = 4 * Total
        Length = Total + 36
        FilePut(2, Length, 4 + 1)
        FilePut(2, Total, 40 + 1)
        FileClose(2)
    End Sub

    Public Function Decode(ByVal i As Byte) As Int16
        Dim diff As Int16
        Dim value As Int32
        value = 2 * Total + 2 * Offset + nibble
        diff = SignTable(Nibble2Bit(i, 0)) * (StepSize(StepSizeIndex) * Nibble2Bit(i, 1) + (StepSize(StepSizeIndex) / 2) * Nibble2Bit(i, 2) + (StepSize(StepSizeIndex) / 4) * Nibble2Bit(i, 3) + (StepSize(StepSizeIndex) / 8))
        StepSizeIndex = StepSizeIndex + IndexShift(i Mod 8)
        If StepSizeIndex < 0 Then StepSizeIndex = 0
        If StepSizeIndex > 48 Then
            StepSizeIndex = 48
        End If
        Return diff
    End Function

    Public Sub Truncate()
        Dim value As Int32
        value = 2 * Total + 2 * Offset + nibble
        If Signal > 2047 Then Signal = 2047
        If Signal < -2047 Then Signal = -2047
    End Sub

End Module

Thanks,
Bruze

Re: How to convert Dialogic .vox to .wav using c# or vb

Christian Graus12-Nov-09 9:17