C# Discussion Boards - CodeProject

teknolog1239-Jan-10 2:14

9-Jan-10 2:14

hi there, I am using sql 2008 express to keep orders and each time I finish with the orders, I want to reset the identity value. I manipulate the database over c#, how can I reset the identity value when I deleted all the records? (I already have the code to read and write to database) Thanks in advance

Re: Reset sql column identity value from c#

Eddy Vluggen9-Jan-10 2:27

Eddy Vluggen

9-Jan-10 2:27

teknolog123 wrote:
how can I reset the identity value when I deleted all the records?

From SQL (haven't tried to execute it over a SqlCommand, but I guess that it would work);

SQL

DBCC CHECKIDENT (yourtable, reseed, 6798)

Would start the numbering at 6798, which is a good a place to start counting as any Smile | :)

I are Troll Suspicious | :suss:

Re: Reset sql column identity value from c#

teknolog1239-Jan-10 3:14

teknolog123

9-Jan-10 3:14

thanks where and how can I put that code below?

SqlConnection sqlBaglanti = new SqlConnection();
SqlDataAdapter sqlAdaptor;
SqlCommandBuilder sqlKomut;
DataTable dtTablo = new DataTable();

private void masaCubuk_MouseDown(object sender, MouseEventArgs e)
{
sqlBaglanti.ConnectionString = @"Data Source=SOUNDMAXP\SQLEXPRESS;
Initial Catalog=Kafe;Integrated Security=SSPI;";
sqlAdaptor = new SqlDataAdapter("Select * From dbo.Masa1", sqlBaglanti);
sqlKomut = new SqlCommandBuilder(sqlAdaptor);
sqlAdaptor.Fill(dtTablo);

for (int i = 0; i < dtTablo.Rows.Count; i++)
{
dtTablo.Rows[i].Delete();
}
sqlAdaptor.Update(dtTablo);
sqlBaglanti.Close();
sqlBaglanti.Dispose();
}

Re: Reset sql column identity value from c#

Eddy Vluggen9-Jan-10 3:52

Eddy Vluggen

9-Jan-10 3:52

teknolog123 wrote:
thanks where and how can I put that code below?

If you paste code, then highlight it and press on the "code block" button; that makes it somewhat more readable. I assume that you'd execute a SqlCommand[^].

You'd need to do something similar to this at the end of your method;

const string myConnectionString = @"
	Data Source=SOUNDMAXP\SQLEXPRESS;
	Initial Catalog=Kafe;
	Integrated Security=SSPI;";
const string myCommandText = @"
	DBCC CHECKIDENT (yourtable, reseed, 6798)";

using(SqlConnection con = new System.Data.SqlClient.SqlConnection())
{
	con.Open();
	using(SqlCommand cmd = con.CreateCommand())
	{
		cmd.CommandText = myCommandText;
		cmd.ExecuteNonQuery();
	}
	con.Close();
}

This can be further adapted to use your connection-object, off course Smile | :)

I are Troll Suspicious | :suss:

Print Microsoft Report

Thaer Hamael9-Jan-10 1:05

Thaer Hamael

9-Jan-10 1:05

Hi All
I want to print the report using the Microsoft Report without showing the report on the screen (Print Direct When I Click On Button Name Print Report)

thanks Rose | [Rose]

Thaer

Re: Print Microsoft Report

OriginalGriff9-Jan-10 2:09

OriginalGriff

9-Jan-10 2:09

Thaer Hamael wrote:
Hi All
I want to print the report using the Microsoft Report without showing the report on the screen (Print Direct When I Click On Button Name Print Report)

Are you waiting for our permission? If, then consider it given.

Or are you too lazy to use google: MSDN - Walkthrough: Printing a Local Report without Preview[^]

All those who believe in psycho kinesis, raise my hand.

Suniel159-Jan-10 0:25

Suniel15

9-Jan-10 0:25

Dear users am new on this web dont know really how to use it but still ..want to ask a Question.

Q: I have made a WEbcam Recording software..but the problem is that the video gets saved but i cant Play it...Plz help its my Project of IT.

Re: C#

DaveyM699-Jan-10 0:58

DaveyM69

9-Jan-10 0:58

If you're sure the video is saved correctly (i.e can be played with another application so you know it's valid) then we'll need to so the code that attempts to play it.

Dave

BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Why are you using VB6? Do you hate yourself? (Christian Graus)

Re: C#

OriginalGriff9-Jan-10 1:01

OriginalGriff

9-Jan-10 1:01

I think we may need a little more detail...

1) Why not? What happens when you try?
2) How are you trying to play it?
3) How are you saving it?

Try to include some of the code which has a problem - use the code block widget to preserve your formatting and check with preview - but don't just cut and paste everything! No one is going to wade through huge amounts of code, so just show us the bit with the problem.

All those who believe in psycho kinesis, raise my hand.

Working with Crystal Reports and Forms

sorooshk8-Jan-10 21:40

sorooshk

8-Jan-10 21:40

I want to create a program that will make it easy for the user to fill in the forms without a Database, NO DATABASE IS NEEDED!!!!! WTF | :WTF:

1. I want to have a form with some Text Boxes or other elements.
2. When the user presses the submit button all of the field data will be sent to a CR (Crystal Report) and then printed in a premade shape and order.

NO DATABASE!!!!!!

It does not need any database, I just want to send the data to CR and print it, How should I do that?????????

I searched many forums but they say just create a db and so on, but I do not want any db.

Please Help me Please!!! Frown | :(

Re: Working with Crystal Reports and Forms

Saksida Bojan8-Jan-10 22:03

Saksida Bojan

8-Jan-10 22:03

You do not need to create Database you need only DataSet.

Here is what I got from Google with 3 minute of search

http://csharp.net-informations.com/crystal-reports/csharp-crystal-reports-without-database.htm[^]

Re: Working with Crystal Reports and Forms

sorooshk8-Jan-10 22:16

sorooshk

8-Jan-10 22:16

Really thanks for your great answer.

But unfortunately, the webpage you gave me does not load here and I cannot find it, but I will try it.

Again: Thanks a million.

Re: Working with Crystal Reports and Forms

Said Ali Jalali9-Jan-10 2:34

Said Ali Jalali

9-Jan-10 2:34

Hi.
You should add some Paramter to your Report File(Crystal Report)at design time.
Then you can access it in your Code.Like this:

crystalReport1.Parameter_Name.CurrentValues.AddValue("Ali");
crystalReport1.Parameter_Last_Name.CurrentValues.AddValue("Jalali");
//
Then show your report viewer.

Good luck.

CanI

Re: Working with Crystal Reports and Forms

Saksida Bojan9-Jan-10 3:11

Saksida Bojan

9-Jan-10 3:11

I used to access that way, but I found mayor disadvantage. This approach is good if it is meant to put data that does not include Table like display.

How to retrieve username from event Log in C#?

Sunil G8-Jan-10 19:10

Sunil G

8-Jan-10 19:10

Hi All,

I want to retrieve username from event logviewer in my c# application.

Is there any way ?

Re: How to retrieve username from event Log in C#?

Eddy Vluggen9-Jan-10 1:20

Eddy Vluggen

9-Jan-10 1:20

Yup, enumerate the EventLogEntry's and check out the UserName[^] property in there.

A quick remark, copied from MSDN:
This property is often blank for events in logs other than the Security log.

Good luck

I are Troll Suspicious | :suss:

Form With Shadow

roshihans8-Jan-10 16:35

roshihans

8-Jan-10 16:35

I have a form and a png image file (with a transparent shadow in its border) and what I want is to make a drop shadow effect on the form. I know there are CS_DROPSHADOW solution for this, but I think it doesn't look too good. So I create a "fake" form using CreateWindowEx (via DllImport), and draw the png image file into the fake form.

void CreateFakeForm()
{
            WNDCLASSEX wndClsEx = new WNDCLASSEX();
            wndClsEx.Init();
            wndClsEx.style = CS_VREDRAW | CS_HREDRAW;
            wndClsEx.lpfnWndProc = m_DefWndProcDelegate;
            wndClsEx.cbClsExtra = 0;
            wndClsEx.cbWndExtra = 0;
            wndClsEx.hInstance = GetModuleHandle(null);
            wndClsEx.hIcon = IntPtr.Zero;
            wndClsEx.hIconSm = IntPtr.Zero;
            wndClsEx.hCursor = IntPtr.Zero;
            wndClsEx.hbrBackground = IntPtr.Zero;
            wndClsEx.lpszClassName = m_WndClsName;
            wndClsEx.lpszMenuName = null;

            bool success = RegisterClassEx(ref wndClsEx) != 0;

            UInt32 dwExStyle = WS_EX_LAYERED |
                WS_EX_TRANSPARENT |
                WS_EX_NOACTIVATE |
                WS_EX_LEFT;
            UInt32 dwStyle = WS_VISIBLE | WS_OVERLAPPED;
            
            FakeWndHandle = CreateWindowEx(dwExStyle
                , m_WndClsName
                , null
                , dwStyle
                , X
                , Y
                , PngImg.Width
                , PngImg.Height
                , MainFormHandle
                , IntPtr.Zero
                , GetModuleHandle(null)
                , IntPtr.Zero
                );
}

The problem is my fake form always in the topmost position. Is there a way to put the fake form behind the main form?
In other words, how do I set z-order between the main form and the fake form so that the fake form placed at the bottom of the Z order?

How to hide the fake form whenever the main form minimized or maximized, and move or resize the fake form whenever the main form moved or resized?

Thanks.

Re: Form With Shadow

Saksida Bojan8-Jan-10 19:06

Saksida Bojan

8-Jan-10 19:06

Why don't you override CreateParams instead of creating FakeWindow?

This example overrides default border and replace it with AERO. to get WS_ numbers, go to your Windows SDK and look under window.h for decleration

protected override CreateParams CreateParams
{
    get
    {
        CreateParams cp = base.CreateParams;
        unchecked
        {
            cp.Style |= (int)0x80000000;    // WS_POPUP
            cp.Style |= 0x40000;            // WS_THICKFRAME
        }
        return cp;
    }
}

Re: Form With Shadow

roshihans8-Jan-10 19:59

roshihans

8-Jan-10 19:59

Thanks for the reply,

I'm using Windows XP, so I think there are no WS_ for AERO.

Re: Form With Shadow

Saksida Bojan8-Jan-10 20:21

Saksida Bojan

8-Jan-10 20:21

when i said WS_ i meant WS_EX_NOACTIVATE and other. The one I post was uses AERO. It isn't limited for aero. It has all same as unmanaged code

Re: Form With Shadow

roshihans8-Jan-10 22:42

roshihans

8-Jan-10 22:42

When you say override CreateParams, did you refer to the main form's CreateParams? But then, where do I draw the png image files into?. Sorry, but I'm new in this so I'm still confused.

Re: Form With Shadow

Saksida Bojan8-Jan-10 22:46

Saksida Bojan

8-Jan-10 22:46

for painting try look into OnPaint event or you can even ovverride

roshihans wrote:
When you say override CreateParams, did you refer to the main form's CreateParams?

That is correct

Re: Form With Shadow

roshihans9-Jan-10 1:43

roshihans

9-Jan-10 1:43

Saksida Bojan wrote:
for painting try look into OnPaint event or you can even ovverride

I thought if I paint form's border with a transparent-shadow background (using png file), it will not become transparent unless I set the main form transparent too. And how to paint the shadow into the border which is located in non-client area?

Re: Form With Shadow

Saksida Bojan9-Jan-10 1:58

Saksida Bojan

9-Jan-10 1:58

roshihans wrote:
And how to paint the shadow into the border which is located in non-client area?

Special 'Graphics' Objects to Draw Anywhere on your Window[^]

roshihans wrote:
it will not become transparent unless I set the main form transparent too

To enable Form transparecy you need to enable transparent color.

this.SetStyle(ControlStyles.SupportsTransparentBackColor | ControlStyles.DoubleBuffer, true);

Re: Form With Shadow

roshihans9-Jan-10 5:00

roshihans

9-Jan-10 5:00

Thanks a lot for your help. I will try your suggestion

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