Comments by Jackson K T (Top 22 by date)

could you suggest something practical on this issue ?

yea. :) Thanks

Encryption was the first thing in my mind but I use SQL SERVER 2008 R2. It provides Transparent Data Encryption (TDE) but only available with Enterprise edition or higher . Another option is column level encryption but I fear it may hit performance . Is there any work around ? Like custom encryption algorithms ?. I use .Net Winforms for Front End

I thought risk is less than online application because data is only locally available. So if u want to steal you have be inside the office

So how can we set permission to filepath1 ?

Add a constructor with 0 arguments
public BasicAuthHandler()
{

}

try gvWorkOrderDescription.Rows.Count

public static void ClearControls(Control FormName)
{

try
{
foreach (Control Obj in FormName.Controls)
{

if (Obj.HasChildren == true)
{
ClearControls(Obj);
if (Obj is Gramboo.Controls.GrbRadioButtonGroup)
{
((Gramboo.Controls.GrbRadioButtonGroup)Obj).Value = "";
}
else if (Obj is Gramboo.Controls.GrbDataGridView)
{
if (((Gramboo.Controls.GrbDataGridView)Obj).IsList == false)
((Gramboo.Controls.GrbDataGridView)Obj).DataSource = null;
}
}
else if (Obj is TextBox)
{
((TextBox)Obj).Text = "";
}
else if (Obj is ComboBox)
{

((ComboBox)Obj).Text = "";
((ComboBox)Obj).SelectedIndex = -1;
}
else if (Obj is DateTimePicker)
{
((DateTimePicker)Obj).Value = DateTime.Now.Date;
}
else if (Obj is CheckBox)
{
((CheckBox)Obj).Checked = false;
}
else if (Obj is RadioButton)
{
((RadioButton)Obj).Checked = false;

}
else if (Obj is MaskedTextBox)
{
((MaskedTextBox)Obj).Text = "";
}

}
}
catch (Exception ex)
{
ShowMessage(ex.Message, "", MessageBoxIcon.Error);
}
}

My initialization routine need to be threaded because it's done using reflection so that in the inherited form you won't need to write initialization .

Thank you !!! It just worked :)

Actually I'm trying to create a custom datagridview which can re use in other projects.

This datagridview has a custom property which can assign it's entry form ,ie. if the grid is displaying employee list ,if we set this property ,when clicking on a particular row in the grid redirect to employee entry form .

So I thought it will be helpful if I can select the entry form from propertygrid at design time.
Now I'm setting this property by code like

mydatagridview.EntryFormName = new employeeEntryform();

This is the property I created

[Browsable(true)]
[DefaultValue(null)]
Editor(typeof(EntryFormEditor), typeof(System.Drawing.Design.UITypeEditor))]
public Form EntryFormName { get; set; }

The code I posted in my Question is the class EntryFormEditor. This class is supposed to display all forms in my project in the propertygrid

To get more clarity I will explain a little bit

I have user control inherited from datagridview which has a custom property named "EntryForm" . This property used to navigate to data entry form from the datagridview.So I need to list all available forms to select corresponding data entry form

I tried GetEntryAssembly() and GetCallingAssembly too

my problem is if WindowsApplication1 is using the dll then I want to get all forms in WindowsApplication1

That's my problem I want to get the assembly which is using this dll

for eg : if WindowsApplication1 is using the dll then I want to get all forms in WindowsApplication1

I tried this before posting this question.Not working :( ...

I Think I need to explain my question more clearly

This report is Showing minimum number of staffs for each designation in a Department

i used PIVOT query to get the result .It's works fine but my problem is some sections are managed by single manager .So it should be displayed as shown in my example

in my example Jeans,Suitings and kids sections are managed by a single manager so i need to merge that cells like in the image

Thanks Dave

I checked their FAQ before I posted this question.They are saying the toolkit is absolutely free and can use in commercial application without purchasing licence . The thing actually I need to know is , using third party controls like this is a good practice ?.Is there any hidden problems behind it ? .I'm New to .Net technology and VB.Net