C# World

Close all other instances of window form when open new one through menustrip item click

2016-04-20T22:19:00.002-07:00

Write method in MDIPatent form :-
---------------------------------------------

private void CheckActiveChildForm(Form FormControl, string FormExists)
{
int h = 0;
if (MdiChildren.Count() == 0)
{
//Form2 childF = new Form2();
FormControl.MdiParent = this;
FormControl.Show();
}
if (MdiChildren.Count() > 0)
{
for (int i = 0; i < MdiChildren.Count(); i++)
{
if (MdiChildren.ElementAt(i).Text != FormExists)
{
h = 1;
MdiChildren.ElementAt(i).Close();
}
}
}

if (h == 1)
{
FormControl.MdiParent = this;
FormControl.Show();
}
}

Call method on menu strip menu item event :-
-----------------------------------------------------------

Job frmJob = new Job();
CheckActiveChildForm(frmJob, "Add/Edit Job");

Here : "Add/Edit Job" is the form text which is to be pass as a paremeter.

Create asp.net web app with default membership in database.

2016-02-25T23:12:00.000-08:00

Create asp.net web app with default membership in database.

Steps:
1. Go to visual studio and create asp.net web application.
2. Add a webpage RegisterUser.aspx
3. In Toolbox --> drag "Login-->CreateUserWizard" tab to webpage.
4. In web.config file: Add membership and profiles like this

=>Connection string:
<connectionStrings>
<add name="DefaultConnection" connectionString="MultipleActiveResultSets=True; Data Source=serverName;Initial Catalog=YourDB;Persist Security Info=True;User ID=username;Password=password;" providerName="System.Data.SqlClient"/>
</connectionStrings>

=>In <systerm.web> section add following lines in <membership> tag.

<membership>
<providers>

<clear />
<remove name="AspNetSqlMembershipProvider" />

<add connectionStringName="DefaultConnection" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="true" applicationName="/" requiresUniqueEmail="false" passwordFormat="Hashed" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="7" minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="10" passwordStrengthRegularExpression="" name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
<add name="MyProvider" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" connectionStringName="DefaultConnection" applicationName="/" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="false" requiresUniqueEmail="false" passwordFormat="Clear" maxInvalidPasswordAttempts="10" minRequiredPasswordLength="5" minRequiredNonalphanumericCharacters="1" passwordAttemptWindow="10" passwordStrengthRegularExpression="" />
</providers>
</membership>
<profile>
<providers>

<clear />
<add name="AspNetSqlProfileProvider" type="System.Web.Profile.SqlProfileProvider" connectionStringName="DefaultConnection" applicationName="RMS" />
</providers>
</profile>
<roleManager enabled="true">
<providers>
<clear />
<remove name="AspNetSqlRoleProvider" />
<add connectionStringName="DefaultConnection" applicationName="/" name="AspNetSqlRoleProvider" type="System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
<remove name="AspNetWindowsTokenRoleProvider" />

</providers>

</roleManager>

5. Create blankDatabase in SqlServer 2008 or sqlServer 2012
6. Go to visualstudio command prompt and type command aspnet_regsql
7. follow the instruction to add database for creating membership tables in sqlServer database which you have selected through aspnet_regSql command.
Default membership tables will created automatically in database.
8. Now run your website RegisterUserpage
9. Enter required details of user and click on "Create User" button.
User will register according to user membership tables.
========================================================================
Similarly add login wizard for user Login and run application.
Login wizard will automatically work for membership.

2015-10-28T00:12:00.001-07:00

Get data according to date filter in sqlServer 2008:

/****** Script for SelectTopNRows command from SSMS ******/

SELECT [Log_JobNoPMS],[Log_PMJobStatus] ,[Log_PMUser]

FROM [PMTABS_SS].[dbo].[JobStatusLog]

where

-- month(Log_Time)=10 and year(log_time)=2015

(Log_time between '2015-10-01 00:01:00' and '2015-10-31 21:11:00')

--log_jobnopms='HU_151026-15_F1'

Group by [Log_JobNoPMS],[Log_PMJobStatus] ,[Log_PMUser]

order by log_jobnopms

Magic table in SQL

2014-01-15T07:56:00.003-08:00

Introduction

Today we are going to play around with the Magic Table in SQL Server. When we perform an insert or update operation on any table then the data is put into tables of inserted and deleted data. These inserted and updated tables are known as Magic Tables or Virtual Table.

I assume you have basic knowledge of Stored Procedures. For more help visit,

First of all we create a table named emp

Creation of table:

create table emp(empId int, empName varchar(15))

Insertion of data:
insert into emp
select 1,'d'union all
select 2,'e'union all
select 3,'e'union all
select 4,'p'union all
select 5,'a'union all
select 6,'k'

Output:
select * from emp

Magic Table:

These are Virtual Tables named inserted and updated that are created by SQL Server when we perform an insert, delete or update operation. We can't see the Magic Table directly, We use a trigger to see the Magic Table.

Type of Magic Table:

Inserted
Deleted

Magic Table for insert operation:

When we insert data into a table then data is first inserted in the inserted table.

We can use the following trigger to see the inserted Magic Table.

create trigger majic_insert
on emp
for insert
as
select * from inserted
Output:

insert into emp values(11,'d')
When we execute that command, the trigger magic_insert fires and shows the table inserted.

Magic Table for delete operation:

When we delete data from any table then data is put into the deleted table.

By using following trigger we can see the deleted Magic Table.

create trigger magic_delete
on emp
for delete
as
select * from deleted
Output:

delete from emp where empId=11

When we execute that command the trigger magic_delete fires and shows the table deleted.

Magic Table for update operation:

When we perform an update operation then data from the first table is deleted first, then after that the new updated data is inserted.

By using following trigger we can see the inserted and deleted Magic Table.

create trigger magic_update
on emp
for update
as
select * from inserted
select * from deleted
Output:
update emp set empName='deepak' where empId=1

When we execute that command the trigger magic_update fires and shows the tables inserted and deleted.

Could not load file or assembly 'file:///C:\Program Files\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86\dotnet1\crdb_adoplus.dll' or one of its dependencies. The system cannot find the file specified.

2013-08-31T20:50:00.000-07:00

changing in app.config
 
from:
 
<!--<startup>
  <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/></startup>-->
 
to:
 
<startup useLegacyV2RuntimeActivationPolicy="true">
 
    <supportedRuntime version="v4.0"/>
 
  </startup>

Change mdi parant back color in C#

2013-08-23T20:34:00.001-07:00

Here is the code :-
------------------

Copy and paste this code in form load event.

  foreach (Control c in this.Controls)
            {
                if( c is MdiClient)
                c.BackColor = Color.Red;
            }

How to develop crystal report in windows form c#

2013-08-09T21:43:00.002-07:00

how to develop crystal report in window form c#.
here is the link.

http://csharp.net-informations.com/crystal-reports/csharp-crystal-reports-stepbystep.htm

Generating Serial Number Inside Gridview with Pagingin asp.net

2013-07-16T04:31:00.003-07:00

<asp:TemplateField HeaderText="SNo">

<HeaderStyle CssClass="DetailsContent" />
<ItemStyle Width="6%" Height="18px" HorizontalAlign="Center" CssClass="DetailsContent"></ItemStyle>
<ItemTemplate>

</ItemTemplate>
</asp:TemplateField>

// Code in Gridview_RowdataBound protected void gvUserList_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
e.Row.Cells[0].Text = "" + ((((GridView)sender).PageIndex * ((GridView)sender).PageSize) + (e.Row.RowIndex + 1));

}

}

METHOD OVERLOADING IN C#.

2013-07-11T06:19:00.000-07:00

//Method Overloding :
//The Methods having the same name .. but different signature
//Signature : Number of parameters and Types of parameters
//Return type is not included in signature..
//Return type change : not overloding ...erororororo
class a
{
    //private attribute
    int x;
    public void display()
    {
        x=9999;
        System.Console.WriteLine("x="+x);
    }
    /* erorororororooror
    public int display()
    {
        x=9999;
        System.Console.WriteLine("x="+x);
        return 999;
    }
    */
    public void display(int p)
    {
        x=p;
        System.Console.WriteLine("x="+x);
    }
    public void display(int p,int q)
    {
        x=p+q;
        System.Console.WriteLine("x="+x);
    }
}
class b
{
    public static void Main()
    {
        a z=new a();
        z.display();
        z.display(222);
        z.display(33,33);

    }
}

Drop whole database tables using single query

2013-07-11T06:11:00.004-07:00

use following query : -
==================

use master

exec sp_MSforeachtable @Command1 = "DROP TABLE ?"

your whole database dables will drop instantly.

Table Variable in SQL

2013-07-08T23:18:00.000-07:00

Table Variable

Temporary table is the Table variable which can do all kinds of operations that we can perform in`Temp` table. Below is the syntax for using Table variable.

Declare @TempTableVariable TABLE(
UserID int,
UserName varchar(50), 
UserAddress varchar(150))

The below scripts are used to insert and read the records for Tablevariables:

insert into @TempTableVariable values ( 1, 'Anna','Paris');

Now select records from that tablevariable:

select * from @TempTableVariable

When to Use Table Variable Over Temp Table

Tablevariable is always useful for less data. If the result set returns a large number of records, we need to go for temp table.

Temporary Tables in SQL

2013-07-08T23:10:00.000-07:00

Introduction
Types of Temporary Tables
- Local Temp Table
- Global Temp Table
Creating Temporary Table in SQL Server
Storage Location of Temporary Table
When to Use Temporary Tables?

Introduction

SQL Server provides the concept of temporary table which helps the developer in a great way. These tables can be created at runtime and can do the all kinds of operations that one normal table can do. But, based on the table types, the scope is limited. These tables are created inside tempdb database.

Types of Temporary Tables

SQL Server provides two types of temp tables based on the behavior and scope of the table. These are:

Local Temp Table
Global Temp Table

Local Temp Table

Local temp tables are only available to the current connection for the user; and they are automatically deleted when the user disconnects from instances. Local temporary table name is stared with hash ("#") sign.

Global Temp Table

Global Temporary tables name starts with a double hash ("##"). Once this table has been created by a connection, like a permanent table it is then available to any user by any connection. It can only be deleted once all connections have been closed.

Creating Temporary Table in SQL Server

As I have already discussed, there are two types of temporary tables available. Here I am going to describe each of them.

Local Temporary Table

The syntax given below is used to create a local Temp table in SQL Server :

CREATE TABLE #LocalTempTable(
UserID int,
UserName varchar(50), 
UserAddress varchar(150))

The above script will create a temporary table in tempdb database. We can insert or delete records in thetemporary table similar to a general table like:

insert into #LocalTempTable values ( 1, 'anna','Paris');

Now select records from that table:

select * from #LocalTempTable

After execution of all these statements, if you close the query window and again execute "Insert" or "Select"Command, it will throw the following error:

Msg 208, Level 16, State 0, Line 1
Invalid object name '#LocalTempTable'.

This is because the scope of Local Temporary table is only bounded with the current connection of current user.

Global Temporary Table

The scope of Global temporary table is the same for the entire user for a particular connection. We need to put "##"with the name of Global temporary tables. Below is the syntax for creating a Global Temporary Table:

CREATE TABLE ##NewGlobalTempTable(
UserID int,
UserName varchar(50), 
UserAddress varchar(150))

The above script will create a temporary table in tempdb database. We can insert or delete records in thetemporary table similar to a general table like:

insert into ##NewGlobalTempTable values ( 1, 'ANNA','Paris');

Now select records from that table:

select * from ##NewGlobalTempTable

Global temporary tables are visible to all SQL Server connections. When you create one of these, all the users can see it.

Storage Location of Temporary Table

When to Use Temporary Tables?

Below are the scenarios where we can use temporary tables:

When we are doing large number of row manipulation in stored procedures.
This is useful to replace the cursor. We can store the result set data into a temp table, then we can manipulate the data from there.
When we are having a complex join operation.

convert small letters to capital letters in javascript in asp.net

2013-07-05T02:51:00.001-07:00

How to convert Text to Speech in C#

2013-07-03T04:18:00.000-07:00

Steps :
=====

1. Add reference from .NET assembly named System.speech
2 Add code given below in .cs page of the form.

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Speech.Synthesis;
using System.IO;
namespace WindowsFormsApplication2
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
SpeechSynthesizer reader; //declare the object
private void Form1_Load(object sender, EventArgs e)
{
reader = new SpeechSynthesizer(); //create new object

textBox1.ScrollBars = ScrollBars.Both;
}

private void button1_Click(object sender, EventArgs e)
{
reader.Dispose();
if (textBox1.Text != "") //if text area is not empty
{

reader = new SpeechSynthesizer();
reader.SpeakAsync(textBox1.Text);
// reader.SpeakCompleted += new EventHandler<SpeakCompletedEventArgs>(reader_SpeakCompleted);
}
else
{
MessageBox.Show("Please enter some text in the textbox", "Message", MessageBoxButtons.OK);
}
}

//event handler
void reader_SpeakCompleted(object sender, SpeakCompletedEventArgs e)
{
label1.Text = "IDLE";
}
}
}

How to get exe version in window application in C#

2013-07-02T06:01:00.001-07:00

Here is the simple line :
================

string AppVersion = Application.ProductVersion; //To get Product Version

string AppVersion = Application.ProductName; // To get Product Name.

Set value in Text Object in Crystal report at Runtime in C#

2013-07-02T05:34:00.000-07:00

Here is the Simple Code :-
===================

CrystalReport1 Obj = new CrysralReport1();

//Set a Crystal Reports text object at runtime
CrystalDecisions.CrystalReports.Engine.TextObject txtQuotationNum = ((CrystalDecisions.CrystalReports.Engine.TextObject)crQuotation.ReportDefinition.Sections["Section1"]
.ReportObjects["txtQuotation"]); // "txtQuotation" is the TextObject name mention on Crystal Report Viewer.

txtQuotationNum.Text = "bla bla bla...";
crystalReportViewer1.ReportSource = crQuotation;

DataTable already belongs to another DataSet Exception

2013-07-01T22:29:00.002-07:00

Exception Occure : DataTable already belongs to another DataSet Exception :-
--------------------------------------------------------------------------------

Like the other responses point out, the error you're seeing is because the DataTable you're attempting to add to a DataSet is already a part of a different DataSet.

One solution is to Copy the DataTable and assign the copy to the other DataSet.

dataTable dtCopy = datatable1.Copy();
ds.Tables.Add(dtCopy);

Your problem will solve.

Windows 8 blogger Tamplate for free download

2013-06-27T04:37:00.001-07:00

Here is the link:-
-------------------

http://s2free.blogspot.in/2013/06/all-metro-ui-windows-8-style-blogger.html

Download Menubar CSS free

2013-06-27T04:28:00.000-07:00

Here is the link:
-------------------

http://cssmenumaker.com/css-drop-down-menu

SEO On Blogger

2013-06-27T04:25:00.004-07:00

Go to Template--> Edit HTML-->Click

press (ctrl+f) in code and find this text.
<title><data:blog.pageTitle/></title>

Replace this text with this text :

<b:if cond='data:blog.pageType == "item"'>
<title><data:blog.pageName/> |<data:blog.title/></title>
<b:else/>
<title><data:blog.pageTitle/></title> </b:if>

you have done...!!!!

Sql Server 2008 Installation Steps

2013-06-27T04:20:00.001-07:00

How to insall SQL SERVER 2008 Step by step:-
-------------------------------------------------

Here is the link :

http://blog.sqlauthority.com/2008/06/12/sql-server-2008-step-by-step-installation-guide-with-images/

Download Crystal Report Setup file for Visual Studio 2010 (Developer edition)

2013-06-27T03:21:00.001-07:00

Click on the First link for Standard version. This version can install in your system and you can start crystal report. (Developer edition).

https://www.sap.com/campaign/ne/free_trial/crystal_reports_visual_studio/wty_int_crvs.epx?Level=1&FormResultID=91c2d627-6436-443b-9be2-64559651bba8&ContinueURL=%2fcampaign%2fne%2ffree_trial%2fcrystal_reports_visual_studio%2findex.epx%3furl_id%3dtext-na-sapcom-crvs-trial-landing%26kNtBzmUK9zU%3d1&kNtBzmUK9zU=1

for Client edition, so that your application can run on client machine and client can able to print crystal report on his machine.
click on this link.

click "13_0.msm" in MSM 32 bit column on this page.
http://scn.sap.com/docs/DOC-7824

Allow Only Number and single dot C#

2013-06-27T01:06:00.001-07:00

//Write code on Textbox KeyPress Event.
=============================

private void txtQty_KeyPress(object sender, KeyPressEventArgs e)
{

if (e.KeyChar == '0' || e.KeyChar == '1' || e.KeyChar == '2' || e.KeyChar == '3' || e.KeyChar == '4' || e.KeyChar == '5' || e.KeyChar == '6' || e.KeyChar == '7' || e.KeyChar == '9' || e.KeyChar == '8' || e.KeyChar == '.')
{
if (txtQty.Text.ToString().Contains(".") || e.KeyChar == '.')
{
if (txtQty.Text.ToString().Contains(".") && e.KeyChar == '.')
{
e.Handled = true;
}

else
{
e.Handled = false;
}
}
}
else if (e.KeyChar == '\b')
{
e.Handled = false;
}
else
{
e.Handled = true;
}

}

How to get all text in uppercase latters in a textbox using java script in asp.net

2013-06-20T00:44:00.001-07:00

use this script in header section :-
--------------------------------

<script type="text/javascript">
function ToUpper(txt) {
document.getElementById(txt).value = document.getElementById(txt).value.toUpperCase();
}
</script>

Take a textbox like this and call the java script function over here. :-
-------------------------------------------------------------------

<asp:TextBox ID="txtCode" runat="server" AutoPostBack="True"
ontextchanged="txtCode_TextChanged" MaxLength="99" onkeypress="ToUpper(this.id)" onblur="ToUpper(this.id)"></asp:TextBox>

How to passing the value from One form to another form in windows application c#

2013-05-17T23:28:00.002-07:00

Write code on Form -1 :--
=======================

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void button1_Click(object sender, EventArgs e)
{
Form2 objForm2 = new Form2(this);
objForm2.Show();

}

public void PassValue(string strValue)
{
textBox1.Text = strValue;
}

}
}

------------------------------------------------------------------------------------------------------------

Write code on form : 2:-

=====================

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

namespace WindowsFormsApplication1

{

public partial class Form2 : Form

{

Form1 ownerForm = null;

public Form2()

{

InitializeComponent();

}

public Form2(Form1 ownerForm) //create parameterized constructor for form 1

{

InitializeComponent();

this.ownerForm = ownerForm;

}

private void Form2_Load(object sender, EventArgs e)

{

}

private void button1_Click(object sender, EventArgs e)

{

this.ownerForm.PassValue(textBox1.Text);

this.Close();

}

C# World

Close all other instances of window form when open new one through menustrip item click

Create asp.net web app with default membership in database.

Create asp.net web app with default membership in database.

Magic table in SQL

Could not load file or assembly 'file:///C:\Program Files\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86\dotnet1\crdb_adoplus.dll' or one of its dependencies. The system cannot find the file specified.

Change mdi parant back color in C#

How to develop crystal report in windows form c#

Generating Serial Number Inside Gridview with Pagingin asp.net

METHOD OVERLOADING IN C#.

Drop whole database tables using single query

Table Variable in SQL

Table Variable

Temporary table is the Table variable which can do all kinds of operations that we can perform inTemp table. Below is the syntax for using Table variable.

When to Use Table Variable Over Temp Table

Temporary Tables in SQL

Introduction

Types of Temporary Tables

Local Temp Table

Global Temp Table

Creating Temporary Table in SQL Server

Local Temporary Table

Global Temporary Table

Storage Location of Temporary Table

When to Use Temporary Tables?

convert small letters to capital letters in javascript in asp.net

How to convert Text to Speech in C#

How to get exe version in window application in C#

Set value in Text Object in Crystal report at Runtime in C#

DataTable already belongs to another DataSet Exception

Windows 8 blogger Tamplate for free download

Download Menubar CSS free

SEO On Blogger

Sql Server 2008 Installation Steps

Download Crystal Report Setup file for Visual Studio 2010 (Developer edition)

Allow Only Number and single dot C#

How to get all text in uppercase latters in a textbox using java script in asp.net

How to passing the value from One form to another form in windows application c#

Temporary table is the Table variable which can do all kinds of operations that we can perform in`Temp` table. Below is the syntax for using Table variable.