Re: How to generate SQL Script for Tables with data in a Database ? - C# Discussion Boards

Dave Kreskowiak3-Jun-05 3:58

3-Jun-05 3:58

Nope. If you want to remove data from the beginning of a text file, you have to rewrite the entire text file, skipping the data at the beginning you want to drop.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

How can I disable ALT+F4 closing in a Windows Form?

pubududilena2-Jun-05 22:58

pubududilena

2-Jun-05 22:58

hi,
I am writting C# Application.
I want to disable ALT+F4 closing in windows Form?

regards,
pubudu.

Re: How can I disable ALT+F4 closing in a Windows Form?

mav.northwind2-Jun-05 23:09

mav.northwind

2-Jun-05 23:09

Hi!
Alt+F4 results in your form firing a Form.Closing event.
You can cancel the closing progress there.

Regards,
mav

Re: How can I disable ALT+F4 closing in a Windows Form?

MoustafaS3-Jun-05 5:07

MoustafaS

3-Jun-05 5:07

Catch the event handler Form_Closing and :

void MyForm_Closing(ClosingEvent e)
{
  e.Cancel;
}

How to generate SQL Script for Tables with data in a Database ?

pubududilena2-Jun-05 22:32

pubududilena

2-Jun-05 22:32

hi all,
I have a database in SQL server 2000. There are 5 tables with data..

Now I want to get SQL Script for Tables with DATA in the Tables..

How can I succeed this?

Whenever I run that SQL Script ,I want to attach the database with data.

thanks in advance..

Re: How to generate SQL Script for Tables with data in a Database ?

Colin Angus Mackay2-Jun-05 22:46

Colin Angus Mackay

2-Jun-05 22:46

I don't fully understand what you are asking for.

Do you want to find out which tables contain data?

SELECT COUNT(*) FROM TableName will return the number of rows in a table. Any non-zero value indicates there is data.

My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

Re: How to generate SQL Script for Tables with data in a Database ?

pubududilena2-Jun-05 22:55

pubududilena

2-Jun-05 22:55

hi,
No.. not that what I want..
Suppose that I have table with 70 rows data..Now How can I generate SQL Script for create Table with 70 rows data in a another database?

regards,
pubudu.

Re: How to generate SQL Script for Tables with data in a Database ?

Brian Van Beek3-Jun-05 10:26

Brian Van Beek

3-Jun-05 10:26

just select out all of the values from the first table, go through them row by row and add them to a query, then just write the generated sql to a file from your application.

select * from table_1;

in your code then begin a String query = "create table_2....;"

then for each record returned in your query add it to query like so

query+= "insert into table_2 values (" + value(s) from query + ....");"

Does this help? or am I missing what you are trying to do?

Brian Van Beek
My Blog is Awesome, ok maybe not, but is still fun!!

Connect crystal report to database

Ercoolz2-Jun-05 20:20

Ercoolz

2-Jun-05 20:20

Hello guys...I have a problem in here...(Who doesn't??;))
How can we connect crystal report to database manually not via database expert??

Thanks before..
Best regards

Re: Connect crystal report to database

pubududilena2-Jun-05 22:51

pubududilena

2-Jun-05 22:51

hi,
1) You have to create Data Set using "Data Set" in the add New Item Dialog.
2) Add Teables what do you need to generate report.
3)after that you can add that data set to your crystal report using database expert-->project data-->Ado.NET datasets..
4)complete database expert wizard.
3) then write like code to generate report :

Dataset1 ds2=new Dataset1();--->This is instance of Dataset1 class.
System.Data.SqlClient.SqlDataAdapter oda=create adapter instance using ur Query..
oda.Fill(ds2,tablename); (Give tablename=Table name in the query)

Now use this dataset object (ds2) to fill report..

regards,
pubudu.

Re: Connect crystal report to database

Anonymous2-Jun-05 23:51

Anonymous

2-Jun-05 23:51

hi pubudu..
I knew those way..At ur step 3,u still use database expert to connect to database..and u still use dataset.What i want to know is how we can view data from blank field in crystal report and we can set that source data in code behind..of coz..we need to know how to connect the database too..
Dont use .net facility for this..just coding..How that can be done?
The main problem is how can we view our report properly when we want to change the server..

Thanks again..

Re: Connect crystal report to database

Anonymous20-Jun-05 3:11

Anonymous

20-Jun-05 3:11

Hello,

The below article might help you. Is this you want?

http://support.businessobjects.com/library/kbase/articles/c2010371.asp

Image.FromFile()

Os Sutrisno2-Jun-05 19:20

Os Sutrisno

2-Jun-05 19:20

I can't seem to find and use the Image.FromFile method.

MSDN states that there is this function available and I have already included: using System.Drawing

Can anyone help me please? Sigh | :sigh:

Re: Image.FromFile()

Yulianto.2-Jun-05 19:48

Yulianto.

2-Jun-05 19:48

Os Sutrisno wrote:
find

Find? Confused | :confused:

See this.[^]

<italic>Work hard, Work effectively.

Re: Image.FromFile()

Os Sutrisno2-Jun-05 20:10

Os Sutrisno

2-Jun-05 20:10

Find as in when I type Image myPic = new Image.

Intellisense doesn't list FromFile as one of the methods.

Anyways, I found out what was going on Poke tongue | ;-P

.Net Compact Framework doesn't support Image.FromFile D'Oh! | :doh:

Re: Image.FromFile()

MoustafaS3-Jun-05 5:10

MoustafaS

3-Jun-05 5:10

Image class cann't be instantiated from,You must do it from Bitmap().

Re: Image.FromFile()

Susan Hernandez3-Jun-05 13:59

Susan Hernandez

3-Jun-05 13:59

The FromFile method is a static method. Therefore, you do not call it from an instantiation of the object, you call it right from the Class itself.

Wrong:

<br />
Image myPic = new Image;<br />
myPic.FromFile("someFileName");// WRONG<br />

Correct:

<br />
Image myPic = Image.FromFile("someFileName");// Correct<br />

DES decode

Member 13623382-Jun-05 19:14

Member 1362338

2-Jun-05 19:14

I have MAC "52 08 29 0E D9 BF 0B 6D" and i can des encrypt it to "0E C7 55 E2 85 3D F8 93" but how to des decode it back to orginal MAC?

Key is "37 97 23 23 97 89 FD 9D" and initial vector is "00 00 00 00 00 00 00 00".

-Suortti

Re: DES decode

Mike Dimmick3-Jun-05 0:59

Mike Dimmick

3-Jun-05 0:59

This code typed directly into the browser with no testing.

System.Security.Cryptography.DES des = 
   new System.Security.Cryptography.DES();
byte[] key = 
   new byte[] { 0x37, 0x97, 0x23, 0x23, 0x97, 0x89, 0xFD, 0x9D };
byte[] iv  =
   new byte[] { 0, 0, 0, 0, 0, 0, 0, 0 };
 
using ( des )
{
   System.Security.Cryptography.ICryptoTransform dec =
      des.CreateDecryptor( key, iv );

   using ( dec )
   {
      dec.TransformFinalBlock( mac, 0, 8 );
   }
}

Stability. What an interesting concept. -- Chris Maunder

Re: DES decode

Member 13623383-Jun-05 22:44

Member 1362338

3-Jun-05 22:44

didnt help much Frown | :(

textBox

picasso22-Jun-05 18:54

picasso2

2-Jun-05 18:54

I have a simple application that I am using to learn C#. The application contains two textbox fields and a button.

The program consist of a method that calculates the sqare root of a number (data type float)

How can I display the result in a textbox if the textbox only takes text

Example
result is res=1.5
textBox1.Text=res -- compiler error

thanx for the help

Re: textBox

Yulianto.2-Jun-05 19:06

Yulianto.

2-Jun-05 19:06

res.toString();

<italic>Work hard, Work effectively.

Re: textBox

Susan Hernandez3-Jun-05 14:19

Susan Hernandez

3-Jun-05 14:19

Some Samples:

<br />
// txtInputTextBox.Text = 5.2<br />
decimal inputDecimal = Convert.ToDecimal(txtInputTextBox.Text);<br />
<br />
// shows "5.2"<br />
string myString1 = inputDecimal.ToString(); <br />
<br />
// shows "5.20"<br />
string myString2 = inputDecimal.ToString("0.00"); <br />
<br />
// shows "5.2000"<br />
string myString3 = String.Format("{0:0.0000}", inputDecimal); <br />
<br />
// shows "The Result is: $5.20."<br />
string myString4 = String.Format("The Result is: {0:C}.", inputDecimal); <br />

stand alone any where

ABBASI_RA2-Jun-05 16:23

ABBASI_RA

2-Jun-05 16:23

hi how i can make a stand alone c# windows application?
i want to use it somewhere without installing .NET frameworw.
thanks

Re: stand alone any where

Christian Graus2-Jun-05 16:29

Christian Graus

2-Jun-05 16:29

ABBASI_RA wrote:
how i can make a stand alone c# windows application?
i want to use it somewhere without installing .NET frameworw.

Write it in C++. That's your only option. And don't use managed C++, or you'll need the .NET framework all over again

The reason everyone ships their .NET apps with a dependancy to the .NET framework is because that's the way it works. Your compiled C# program is not recognisable to any computer, the .NET framework is needed to compile it into a final executable.

Christian Graus - Microsoft MVP - C++

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