C# Discussion Boards - CodeProject

Nilesh Gambhava12-Jul-06 18:13

12-Jul-06 18:13

I want to create CHM Help file programmatically in C#. Basically I want to create documentation for my tables and stored procedures.

I did lot of searching on net but what I found is "HTML to CHM".
So What I think is,
1) I will create html files programmatically
2) Using some complier or some batch command or some thing, I will create CHM files

But some article points that you can use CHM file as a help in your .NET Application & some where it is written that System.Windows.Forms.Help can be used for it so there must be some way.

Can anyone give me some idea or some right direction?

Just I need fire, Then I will do it.

Nilesh Gambhava,
Life is NP-Complete so don't use Algorithm but use Heuristics

Re: How to Create CHM Help file in C#?

Andrew Lygin12-Jul-06 18:40

Andrew Lygin

12-Jul-06 18:40

Hi,
To use .chm-file in your application as help file you can use HelpProvider class.

appHelp = new HelpProvider();
appHelp.HelpNamespace = "MyApplication.chm";

And then use SetHelpNavigator(), SetHelpKeyword(), SetHelpString() and other methods.

Re: How to Create CHM Help file in C#?

Nilesh Gambhava13-Jul-06 0:50

Nilesh Gambhava

13-Jul-06 0:50

Thanks for quick response.

But I am not getting it.

I want to create new CHM file, I dont want to use CHM file as help

Nilesh

Nilesh Gambhava,
Life is NP-Complete so don't use Algorithm but use Heuristics

Is there a way to stop a process from being closed?

Anthony Mushrow12-Jul-06 16:18

Anthony Mushrow

12-Jul-06 16:18

Like a 'critical system process'

What i really need is to stop people form closing a security app through the command line. So if theres any way to do that then, yeah.

Re: Is there a way to stop a process from being closed?

Andrei Ungureanu12-Jul-06 18:14

Andrei Ungureanu

12-Jul-06 18:14

try building a windows service that and set the stop property to false.

Do your best to be the best

Re: Is there a way to stop a process from being closed?

Eran Aharonovich12-Jul-06 21:25

Eran Aharonovich

12-Jul-06 21:25

Try API hooking.

Hook the TerminateProcess API.

You can use the madshi library.

www.madshi.net

Eran Aharonovich (eran.aharonovich@gmail.com )
Noviway

How can I prevent a listView (View: List) from showing on serveral columns? [modified]

AngryC12-Jul-06 14:39

AngryC

12-Jul-06 14:39

Hello,

I have a listView with the View property set to List. What I want to do is simply preventing the listView item from showing on serveral columns.

Like this:

1............2.............3
4............5.............6

I want them to appear as follow:

1
2
3
4
5
6

Please note: I don't want to add columns that will be visible to my user.

Please help. Thanks.

Re: How can I prevent a listView (View: List) from showing on serveral columns?

Andrew Lygin12-Jul-06 18:02

Andrew Lygin

12-Jul-06 18:02

Hi,
No, you can't do this with the "List" View style. But you can set View = Details, add one column and set HeaderStyle = None if you don't want your users to see column header.

How can i find the current users 'My Documents' (XP)

Anthony Mushrow12-Jul-06 13:45

Anthony Mushrow

12-Jul-06 13:45

I can get the username, which will work most of the time, but as for example on my computer, the address is

C:\Documents and Settings\USER.OWNER-VS1SHD0MH8\My Documents\

because my computer is wierd.
But i need to know how to get to 'My Documents' every time.

Re: How can i find the current users 'My Documents' (XP)

Sean8912-Jul-06 14:00

Sean89

12-Jul-06 14:00

Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);

Hope that helps Poke tongue | ;-P

Re: How can i find the current users 'My Documents' (XP)

Anthony Mushrow12-Jul-06 14:09

Anthony Mushrow

12-Jul-06 14:09

Oh yeah, thats good.

You learn somehting new every day. Its a miracle i didn't find this sooner, just think of the minutes i could have saved typing!!

Opening a file that has already be lock by another user for write access

keroed_edmond12-Jul-06 13:35

keroed_edmond

12-Jul-06 13:35

i am building a software that will read from a csv file that is constantly been lock by an avaya smdr that keeps on writing to that file, but i want my program to be able to jus open the file and read it is this possible?? or once another program has lock a file for readAndWrite i cant even read from that file

kenny

Re: Opening a file that has already be lock by another user for write access

Not Active12-Jul-06 14:03

Not Active

12-Jul-06 14:03

http://msdn2.microsoft.com/en-us/library/system.threading.readerwriterlock.aspx[^] Defines a lock that supports single writers and multiple readers

Re: Opening a file that has already be lock by another user for write access

keroed_edmond12-Jul-06 14:19

keroed_edmond

12-Jul-06 14:19

thanks for the link i jus getting ready to leave the office but as soon as i reach home i going read it.

kenny

Re: Opening a file that has already be lock by another user for write access

keroed_edmond12-Jul-06 16:43

keroed_edmond

12-Jul-06 16:43

i reading through the example u sent me and i saw how it would allow you to read write to a integer value name resource but how would i use this in terms of reading from a text file

kenny

Pls Help Me !!!

Fahad Ali12-Jul-06 11:51

Fahad Ali

12-Jul-06 11:51

i am using this code to print a report but the problem comes when i pass parameters like Supplier_Id as i have done in this query the error comes like "Query engine Error and follows with the path.I am using this code.Well the problem doesn't comes with the query in which i have not passed parameters Pls help me to sort out this problem.Thanks Fahad.

try
{
int Supplier_Id=Convert.ToInt32(Supplier_Id_C.Text);
string s_p="sp_P_S_Rpt";
SqlConnection conn = Class_Connection.Make_Conn();
// SqlCommand command = new SqlCommand(s_p, conn);
// command.CommandType = CommandType.StoredProcedure;
// command.Parameters.Add("@Supplier_Id", SqlDbType.Int);
// command.Parameters["@Supplier_Id"].Value = Supplier_Id;
// SqlDataAdapter adapter = new SqlDataAdapter(command);
// DataSet ds = new DataSet();
// adapter.Fill(ds, "P_S");
//

// dataGrid1.DataSource=ds;
// dataGrid1.DataMember="P_S";
// P_R_Rpt obj = new P_R_Rpt();
// obj.SetDatabaseLogon("sa","sa","CDMA","Final_Project1_e");
// obj.SetDataSource(ds);
// crystalReportViewer1.ReportSource=obj;
// Cursor = System.Windows.Forms.Cursors.Default;
//reportDocument1.SetDatabaseLogon("sa","sa","CDMA","Final_Project1_e");

// reportDocument1.SetDataSource(ds);
// crystalReportViewer1.ReportSource = reportDocument1;

// Finalized.P_R_Rpt obj = new P_R_Rpt();
// obj.SetDatabaseLogon("sa","sa","CDMA","Final_Project1_e");
// reportDocument1.SetDataSource(ds);
// crystalReportViewer1.ReportSource = reportDocument1;

SqlCommand command = new SqlCommand(s_p, conn);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@Supplier_Id", SqlDbType.Int);
command.Parameters["@Supplier_Id"].Value = Supplier_Id;
SqlDataAdapter adapter = new SqlDataAdapter("SELECT dbo.Supplier.Supplier_Name, dbo.P_Order.P_O_Date, dbo.P_Order.P_O_Serial_No, dbo.P_Order.P_O_Id FROM dbo.P_Order INNER JOIN dbo.P_O_Details ON dbo.P_Order.P_O_Id = dbo.P_O_Details.P_O_Id INNER JOIN dbo.Supplier ON dbo.P_O_Details.Supplier_Id = dbo.Supplier.Supplier_Id WHERE(dbo.P_O_Details.Supplier_Id = 2)","Data Source=CDMA;Database=Final_Project1_e;UID=sa;PASSWORD=sa");// = new SqlDataAdapter(command);
//P_R ds = new P_R();
//SqlDataAdapter adapter = new SqlDataAdapter(command);
DataSet ds = new DataSet();
adapter.Fill(ds,"P_R_Rpt1");

dataGrid1.DataSource=ds;
dataGrid1.DataMember = "P_R_Rpt1";
//P_R ds = new P_R();
// P_R_Rpt obj = new P_R_Rpt();
// obj.Load();
// obj.SetDataSource(ds);
P_R_Rpt1 obj = new P_R_Rpt1();
obj.SetDataSource(ds);
//obj.Load();

//sample_Rpt1.FilePath = @"C:\\Documents and Settings\\Fahad\\Desktop\\Finalized_With_Report\\Sample_Rpt.rpt";
obj.SetDatabaseLogon("sa","sa");//oRpt.SetDataSource (ds);

crystalReportViewer1.Visible=true;//CrystalReportViewer1.Visible=true;
crystalReportViewer1.DisplayGroupTree=false;
crystalReportViewer1.ReportSource = obj;//CrystalReportViewer1.ReportSource = oRpt;
//obj.Load();
//obj.Refresh();
// crystalReportViewer1.RefreshReport();//.RefreshReport()
// crystalReportViewer1.Refresh();//crystalReportViewer1.Refresh()
// crystalReportViewer1.Show();//crystalReportViewer1.Show()

}
catch(Exception ee)
{
MessageBox.Show(ee.Message);
}

Re: Pls Help Me !!!

PlayByTheRules12-Jul-06 22:05

PlayByTheRules

12-Jul-06 22:05

Fahad Ali wrote as the subject line:
Pls Help Me !!!

Just about every one here is looking for help. This is a useless subject line. You should use something more meaningful. For example "Query Engine Error" would be better.

How can create Software lock in C# ?

persian_king12-Jul-06 11:39

persian_king

12-Jul-06 11:39

how can write protection class for applications created in c# which work with a validation key or serial number etc ?
is there any way to do it crack proofed?
also i'd like my program be available for a specific "trial period" and be locked after this period. application shoul not be "unlocked" after Reinstalling.

thanks in advance.

knowledge is power (%)

Re: How can create Software lock in C# ?

Not Active12-Jul-06 14:00

Not Active

12-Jul-06 14:00

persian_king wrote:
is there any way to do it crack proofed

You come with that and Bill Gates will sing at your birthday party.

There are plenty of third party products that offer these types of features. You can always write your own, but of course it will only be as good as your code and testing process.

Re: How can create Software lock in C# ?

Divyang Mithaiwala12-Jul-06 20:23

Divyang Mithaiwala

12-Jul-06 20:23

Hello,

I think this will helpfull to u.

regards,
Divyang Mithaiwala
System Engineer & Software Developer

PropertyGrid meets Generics

Mattman20612-Jul-06 11:16

Mattman206

12-Jul-06 11:16

Hello everyone,

This may seem like an odd question but here goes.

I'm using the PropertyGrid for a project of mine -- works great and I've used the EnumDescConverter and PropertySorter TypeConverters that I found on CodeProject.

Basically I have an (older) application (.NET 1.1) that I have moved to .NET 2.0. In the older application, I had a class with a Layers property that contained a collection of Layers. I used the ExpandableObjectConverter to let the PropertyGrid show a + sign beside the layers as well as a list of the layers. This was great. Basically it was something like

public class Config
{
...
  private LayerCollection m_Layers = new LayerCollection();

  [TypeConverter(typeof(ExpandableObjectConverter))]
  public LayerCollection Layers
  {
    get { return m_Layers; }
  }
...
}

LayerCollection implemented CollectionBase, as well as ICustomTypeDescriptor to show "Layer #" beside each entry. This worked great.

Now, however, I'm restructured things so that it looks something like this:

public class Config
{
...
  private List<Layer> m_Layers = new List<Layer>();

  public List<Layer> Layers
  {
    get { return m_Layers; }
  }
...
}

If I apply the ExpandableObjectConverter to the Layers properties, it just shows the Count property of the List. Hmmm. Not what I wanted. I know I'm missing something here -- just not sure what.

I used the generic List because it was easy -- but now I'm thinking that I may have to go back and have a LayerCollection class again so that it can implement the ICustomTypeConverter. Maybe make that generic so I can reuse it, but still.

Any ideas? Has anyone else run into a similar fiasco?

Thanks!
-Matt

Re: PropertyGrid meets Generics [modified]

Mattman20612-Jul-06 16:25

Mattman206

12-Jul-06 16:25

Nevermind

I created a class called ExpandableList<T> that inherits from List<T> AND implements ICustomTypeDescriptor.

This is a pretty useful technique, I'll post it as an article soon.
-Matt

Bart: Look at me, I'm a grad student. I'm 30 years old and I made $600 last year.
Marge: Bart, don't make fun of grad students. They've just made a terrible life choice.

-- modified at 22:27 Wednesday 12th July, 2006

Problem with code returning parameter from stored procedure

leckey12-Jul-06 10:26

leckey

12-Jul-06 10:26

I first tried this code that passes a couple of parameters (part number, part type number) to a stored procedure. I can get this to run fine, insert the data into the table, no problem.

However, I want the stored procedure to return a field that is an auto-increment field called ID.

The stored procedure is syntactically correct, so I'm inclined to think it's something with the C# code.

The error I'm getting is: Parameter1 is not a parameter for procedure UpdatePart_Step_1_Test3

This is the c# code (note that I have so additional parameters that I declare but am not yet passing):

private void btnAdd_Click(object sender, System.EventArgs e)<br />
		{<br />
			strPartNumberInputReference = txtSearchPart.Text;<br />
			strPartTypeID = ddPartType.SelectedValue;<br />
			strDwgNumber = txtDwgNumber.Text;<br />
			strDwgRevision = txtDwgRevision.Text;<br />
			strDwgLocation = txtDwgLocation.Text;	<br />
			SqlParameter param1 = new SqlParameter("@PartNumber", strPartNumberInputReference);	<br />
			param1.Direction = ParameterDirection.Input;<br />
			//SqlParameter param2 = new SqlParameter("@DwgNumber", strDwgNumber);<br />
			//SqlParameter param3 = new SqlParameter("@DwgRevision", strDwgRevision);<br />
			//SqlParameter param4 = new SqlParameter("@DwgLocation", strDwgLocation);<br />
			SqlParameter param5 = new SqlParameter("@PartTypeValue", strPartTypeID);<br />
			SqlParameter param6 = new SqlParameter(@ID, SqlDbType.Int);<br />
			param6.Direction = ParameterDirection.Output;<br />
			IDOutput = SqlHelper.ExecuteNonQuery (this.connectionString, CommandType.StoredProcedure, "dbo.UpdatePart_Step_1_Test3", param1, param5, param6);<br />
			test3 = param6.Value;<br />
	<br />
		}

Here is the stored proc:

CREATE PROCEDURE [dbo].[UpdatePart_Step_1_Test3]<br />
@PartNumber varchar (15),<br />
@PartTypeValue varchar (60),<br />
@ID int OUTPUT<br />
<br />
AS<br />
<br />
if NOT EXISTS (Select * from PartsDB.dbo.Parts where PartNumber = @PartNumber)<br />
BEGIN<br />
<br />
insert into PartsDB.dbo.Parts<br />
(PartNumber, PartTypeID)<br />
<br />
VALUES<br />
(<br />
@PartNumber,<br />
@PartTypeValue<br />
)<br />
<br />
END<br />
SET @ID = @@IDENTITY<br />
<br />
return 0<br />
GO

Again, if I just send in param1 and param 5 (and change the stored proc so it's not expecting a third parameter) it works fine!

Any ideas what is causing the error? I'm not finding any documentation.

Re: Problem with code returning parameter from stored procedure

Christian Graus12-Jul-06 10:35

Christian Graus

12-Jul-06 10:35

leckey wrote:
SqlHelper.ExecuteNonQuery

This is obviously a helper class, what does the code look like ?

Your code knows far too much about your data layer, why have a helper method and pass it SQL Parameters ?

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

Re: Problem with code returning parameter from stored procedure

led mike12-Jul-06 10:43

led mike

12-Jul-06 10:43

I think the helper is from the Microsoft Application Block for DAL

"Just about every question you've asked over the last 3-4 days has been "urgent". Perhaps a little planning would be helpful?"
Colin Angus Mackay in the C# forum

led mike

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