Advanced programming in C# and ASP.net

Dynamically create a Report in ReportViewer

2011-11-23T01:20:00.000-08:00

Here im going to tell you about how to create a report using a report viewer by coding.

First you should create a typed DataSet with the structure of your Table(or how you need the table to be).
Now the next step is to create a report

Website/Project -> Add New Item -> Report

Give a name for it.
After this Select the Dataset from the New menu displayed in the rdlc file

The dataset will be diplayed in the report data window.

You must have to provide a Name for the dataset. In DataSource you will get the Typed DataSet you created.

Select the DataTable you created in the Dataset in the AvailableDatasets section and click OK.

Now, You will get the information in the left pane window.

Above you can see the Dataset added to the Table. Here the DataSet name given by me is DataSetSmilu. You should remember this name when we Bind the data from the program....

Now you can right click on the report create a table in the Report page and add the Fileds shown above like this.

Now you have the report file to be attached with the Report Viewer. You can add images, header etc to this page...

Now create a new WebForm.
From the ToolBox add a Ajax ScriptManager into the page
Now from the Reports Section add a Report Viewer into the page.
Select the ToolTip of the ReportViewer and Select the .rdlc file that you have created.

Now whenever you add a Report.rdlc file an ObjectDataSource will be added to the page. We dont need that objectdatasource for the working here...
So You can delete the ObjectDataSource.
Now you should go to Source of the Page and remove the ObjectDataSource Link on the LocalReport section of Reportviewer

<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana"
Font-Size="8pt" InteractiveDeviceInfos="(Collection)"
WaitMessageFont-Names="Verdana" WaitMessageFont-Size="14pt" Width="651px"&rt
<LocalReport ReportPath="rerportsmilu.rdlc"&rt
<DataSources&rt
< rsweb:ReportDataSource / &rt
</DataSources&rt
</LocalReport&rt
</rsweb:ReportViewer&rt

After editing the form should look like this.

Now to our coding part.
Goto your codebehind file. ie the .cs file of the page and bind the data to the dataset.

using System.Data.SqlClient;
using Microsoft.Reporting.WebForms;
using System.Web.Configuration;

//code in page load or some methods..

smiluDS tDs = new smiluDS();
SqlConnection con = new SqlConnection(WebConfigurationManager.ConnectionStrings["NationalBankConnectionString"].ConnectionString);
SqlDataAdapter da = new SqlDataAdapter("Select * from Employee", con);
da.Fill(tDs, tDs.Tables[0].TableName);

ReportDataSource rDs = new ReportDataSource("DataSetSmilu", tDs.Tables[0]);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(rDs);
ReportViewer1.LocalReport.Refresh();
//code complete

In the above code the We are using a SqlDataAdapter to get the data.
Now since we are using a TypedDataSet you should create an instance of the TypedDataSet itself.. Here it is smiluDS. Now a ReportDataSource should be created for the reportviewer. In the report viewer we should specify the DataSet which we have created in the RDLC file and data to be Binded into it..

Try to run it.. you will get the d

VB to C# Application Path in WindowsService

2011-11-21T04:44:00.001-08:00

This method in VB.NET can be written like the below reflection method. The below method gets you the location of your application
My.Application.Info.DirectoryPath

System.Reflection.Assembly.GetExecutingAssembly().Location;

Insertion Using Entity Model

2010-08-31T00:12:00.000-07:00

This is the Entity data Model NationalBankEntities3 in the program.

We are going to add Items into the table EmployeeDetail

Now we must write the code like below

NationalBankModel3.NationalBankEntities3 m = new NationalBankModel3.NationalBankEntities3();

NationalBankModel3.EmployeeDetail Emp = new NationalBankModel3.EmployeeDetail() { EmpName = "Smilu", EmpAddress = "EKM", EmpPhNo = "987654", EmpDob =Convert.ToDateTime("01/01/01") };

m.AddToEmployeeDetails(Emp);

m.SaveChanges();

Here AddToEmployeeDetails will be the method which will insert the data of the Entity we send.

SaveChages() will store the data into the table

Linq to XML

2010-08-10T00:25:00.000-07:00

Here we are just going to see how we can associate XML with LinQ.

First create an XML file with the structure like this CLICK HERE

Now add a GridView to your design.

We need

System.Xml.Linq;

namespace for working of XLINQ

Now in the page load event add the code like this..

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

var query = from s in XElement.Load(MapPath("Students.xml")).Elements("Student1")

select new

{

Name = (string)s.Element("StName"),

Address = (string)s.Element("StAddress"),

PhNo = (string)s.Element("StPHNO"),

flag = (int)s.Element("Flag")

};

GridView1.DataSource=query;

GridView1.DataBind();

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

In the above code we are using XElement.Load method to Load the Students.xml file and we must mention the Node inside which we have put the informations.

(string)s.Element("StName")

The above method converts the data inside the Node to the type we have specified and stores into it....

When we execute it we will get a GridView which contains columns Name, Address, PhNo, and Flag..

Students.XML File

2010-08-10T00:21:00.000-07:00

<Students>
<Student>
<StID>S001</StID>
<StName>Simi</StName>
<StAddress>EKM</StAddress>
<StPHNO>987654123</StPHNO>
<Flag>1</Flag>
</Student>
<Student>
<StID>S002</StID>
<StName>Ravi</StName>
<StAddress>EKM</StAddress>
<StPHNO>654987</StPHNO>
<Flag>0</Flag>
</Student>
<Student>
<StID>S003</StID>
<StName>Manu</StName>
<StAddress>TVM</StAddress>
<StPHNO>987654123</StPHNO>
<Flag>1</Flag>
</Student>
<Student>
<StID>S004</StID>
<StName>Sooraj</StName>
<StAddress>EKM</StAddress>
<StPHNO>64568</StPHNO>
<Flag>0</Flag>
</Student>
<Student>
<StID>S005</StID>
<StName>Remya</StName>
<StAddress>EKM</StAddress>
<StPHNO>987654123</StPHNO>
<Flag>1</Flag>
</Student>
</Students>

JOIN - Linq to Objects

2010-08-09T01:04:00.000-07:00

We have two List<> methods namely GetStudents() which get us the information about the Students and GetFlagNames() which give us information about Flag.

public List GetStudents()

{

return new List

{

new Student{Name="Smilu",Address="EKM",PhNo="987654",flag=1},

new Student{Name="JK", Address="Parur",PhNo="897643",flag=0},

new Student{Name="Kiran", Address="EKM",PhNo="798654",flag=1}

};

}

public List GetFlagNames()

{

return new List

{

new FlagName{flagID=0,flagName="CS"},

new FlagName{flagID=1,flagName="Network"}

};

}

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

We store the list object into a variable called "mystudents" and "flags" respectively...

var mystudents = GetStudents();

var flags = GetFlagNames();

This query represents the Joining using LinQ

var query = from s in mystudents

join f in flags on s.flag equals f.flagID

select new { s.Name, s.PhNo, f.flagName };

Linq to Objects - Arithmetic Operations

2010-08-08T21:24:00.000-07:00

Linq to objects can have arithmetic operations like

Min
Max
Average
Sum
Count etc....

This is the List collection we are going to use....

public List GetStudents()

{

return new List

{

new Student{Name="Smilu",Address="EKM",PhNo="987654",flag=1},

new Student{Name="JK", Address="Parur",PhNo="897643",flag=0},

new Student{Name="Binu", Address="EKM",PhNo="798654",flag=1}

};

}

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

For using this we need to first create a var variable and assign the list into it...

var StudentInfo=GetStudents();

LabelMaxValue.Text = st.Max(s => s.flag).ToString();

LabelMin.Text=st.Min(s=>s.flag).ToString();

LabelCount.Text = st.Count.ToString();

LabelSum.Text = st.Sum(s => s.flag).ToString();

LabelAverage.Text = st.Average(s => s.flag).ToString();

Here you can see like s=> s.flag. This is a method showing the specific field we need to work on.

How to Change Text of a Label inside a MasterPage from its inherited Page.

2010-08-04T01:50:00.000-07:00

((Label)this.Master.FindControl("Label1")).Text = "Text to be changed";

This code will find the control inside the Masterpage and Change it.

ADO.NET Entity Framework

2010-07-28T01:43:00.000-07:00

Create a EDM by adding a new ADO.NET Entity Data Model. Add your Database to it...

Some terms used.....
EDM - Entity Data Model (Mapping Layer)
CSDL - Conceptual Schema Definition Language (Conceptual Layer)
SSDL - Stored Schema Definition Language (Logical Layer)

Extension .edmx

Codes after creating the EDM file....

NationalBankModel.NationalBankEntities mm = new NationalBankModel.NationalBankEntities();
//var query = from n in mm.EmployeeDetails
// select n;

//var query = from n in mm.EmployeeDetails
// where mm.Logins.Any(Emp => Emp.EmpID >3)
// select new {n.EmpID, n.EmpName, n.EmpAddress, n.EmpPhNo };

var query = from n in mm.EmployeeDetails
//join oo in mm.Logins on n.EmpID equals oo.EmpID
where mm.Logins.Any(Emp => Emp.EmpID == 3)
//where n.EmpID > 2
select new { n.EmpID, n.EmpName, n.EmpAddress, n.EmpPhNo };

GridView1.DataSource = query;
GridView1.DataBind();

foreach (var emp in mm.EmployeeDetails)
{
ListItem li = new ListItem();
li.Text = emp.EmpID + " ";
if (!emp.Logins.IsLoaded)
{
emp.Logins.Load();
}

foreach (var p in emp.Logins)
{
li.Text += "Login Name: " + p.username + " ";
}

BulletedList1.Items.Add(li);
}

Custom Reporting using Crystalreports

2010-07-26T20:34:00.000-07:00

Namespaces to use.

using System.Data.SqlClient;
using CrystalDecisions.CrystalReports.Engine;

Code....
SqlConnection con=new SqlConnection(@"Data Source=.\sqlexpress;Initial Catalog=NationalBank;Integrated Security=True");
SqlDataAdapter da=new SqlDataAdapter("select * from EmployeeDetails where EMpname like 'g%'",con);

DataSet ds = new DataSet();
da.Fill(ds, "d");

ReportDocument rpt = new ReportDocument();
rpt.Load(Server.MapPath(@"~\CrystalReport.rpt"));
rpt.SetDataSource(ds.Tables["d"]);
CrystalReportViewer1.ReportSource = rpt;

Taking index of a row in Gridview using RowCommand

2010-07-15T05:01:00.000-07:00

For taking data using rowcommand property....

When you create the code of Gridview place the code like this for your customized Controls(Button)

<asp:imagebutton id="imgProfile" width="100px" height="100px" runat="server" imageurl="'<%#">' CommandName="cmdImage" CommandArgument='<%# Container.DataItemIndex %>' />

Here look at the COmmand argument property it should be like this. Then only we can take the Index of the Gridview.

Now, in Code behind you can call it like this....

string name = ((TextBox)GridView1.Rows[Convert.ToInt32(e.CommandArgument)].FindControl("TextBoxName")).Text;

thus you can work on it getting the index of the row.

Fetch data from Footer of Gridview

2010-07-15T04:59:00.000-07:00

Taking data from the Footer of a Gridview control in asp.net

GridViewRow row = GridView1.FooterRow;

if (e.CommandName == "cmdSUBMIT")

{

string name = ((TextBox)row.FindControl("TextBoxName")).Text;

Response.Write(name);

}

Dock panel in WPF and Databinding

2009-07-28T00:08:00.000-07:00

<DockPanel >
<TextBox DockPanel.Dock="Top" Text="TOP"/>
<TextBox DockPanel.Dock="Right" Text="Right"></TextBox>
&l;tTextBox DockPanel.Dock="Bottom" Text="{Binding Path=Name}"/>
</DockPanel>

-----------------------------------
class person
{
string name = "Admin";
public string Name
{
get { return name; }
set { name = value; }
}
}
--------------------------------------
public Window1()
{
InitializeComponent();
person p = new person();
this.DataContext = p;
}
--------------------------------------

How to get Control ID's from websites using C# web browser

2009-07-03T22:52:00.000-07:00

ButtonGetID_Click

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

MessageBox.Show(webBrowser1.Document.ActiveElement.Id.ToString());

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

Insert data to the Fileds

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

webBrowser1.Document.ActiveElement.InnerText = "smilu";

webBrowser1.Document.GetElementById("Passwd").InnerText = "password";

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

Click in HTML Buttons

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

HtmlElement el = webBrowser1.Document.All["signIn"];

object obj = el.DomElement;

System.Reflection.MethodInfo mi = obj.GetType().GetMethod("click");

mi.Invoke(obj, new object[0]);

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

String Encryption

2009-02-21T00:15:00.000-08:00

using System.Security.Cryptography;

using System.IO;

static string EncrypData;

static byte[] bytes =System.Text.ASCIIEncoding.ASCII.GetBytes("AbCdEfGh");

private void buttonEncrypt_Click(object sender, EventArgs e)

{

try

{

DESCryptoServiceProvider cryptoProvider = new DESCryptoServiceProvider();

MemoryStream memoryStream = new MemoryStream();

CryptoStream cryptoStream = new CryptoStream(memoryStream, cryptoProvider.CreateEncryptor(bytes, bytes), CryptoStreamMode.Write);

StreamWriter writer = new StreamWriter(cryptoStream);

writer.Write(textBox1.Text);

writer.Flush();

cryptoStream.FlushFinalBlock();

writer.Flush();

EncrypData = Convert.ToBase64String(memoryStream.GetBuffer(), 0, (int)memoryStream.Length);

StreamWriter sw = new StreamWriter(@"C:\MyEncryption.DAT");

sw.Write(EncrypData);

sw.Flush();

sw.Close();

}

catch (Exception ex)

{

MessageBox.Show(ex.Message);

}

private void buttonDecrypt_Click(object sender, EventArgs e)

{

try

{

DESCryptoServiceProvider cryptoProvider = new DESCryptoServiceProvider();

MemoryStream memoryStream = new MemoryStream(Convert.FromBase64String(EncrypData));

CryptoStream cryptoStream = new CryptoStream(memoryStream, cryptoProvider.CreateDecryptor(bytes, bytes), CryptoStreamMode.Read);

StreamReader reader = new StreamReader(cryptoStream);

StreamWriter sw = new StreamWriter(@"C:\MyDecrypt.DAT");

sw.Write(reader.ReadToEnd());

sw.Flush();

sw.Close();

}

catch (Exception ex)

{

MessageBox.Show(ex.Message);

}

Globalization

2008-11-28T22:49:00.000-08:00

using System.Globalization;

using System.Threading;

switch (comboBox1.SelectedIndex)

{

case 0:

{

Thread.CurrentThread.CurrentUICulture = new CultureInfo("ar-SA");

Form1 frm = new Form1();

frm.ShowDialog();

break;

}

case 1:

{

Thread.CurrentThread.CurrentUICulture = new CultureInfo("en-US");

Form1 frm = new Form1();

frm.ShowDialog();

break;

}

case 2:

{

Thread.CurrentThread.CurrentUICulture = new CultureInfo("hi-IN");

Form1 frm = new Form1();

frm.ShowDialog();

break;

}

default:

{

Form1 frm = new Form1();

frm.ShowDialog();

break;

}

Code Access Security

2008-11-04T22:21:00.000-08:00

Code Access Security - Denying Read permission on C: drive

using System.Security.Permissions;
using System.IO;

[assembly:FileIOPermission(SecurityAction.RequestRefuse,Read="C:\\")]
namespace CASS
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void button1_Click(object sender, EventArgs e)
{
try
{
StreamReader sr = new StreamReader("C:\\boot.ini");
MessageBox.Show(sr.ReadToEnd());
sr.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}

How to create a simple Windows Service in C#..

2008-10-29T22:44:00.000-07:00

With due permission from Saji P Babu i'm writing this topic in my blog

Windows Services are programs that can be started when the OS starts.... This will be running in the background of the Windows.

In this i'm just creating a simple windows service. For theory parts just refer some other sites...

Here is the practical part.

First we are going to create a Windows Service. For that
1) Open visual studio,
2) Take File menu -->New-->Project
3) From the list take a Windows service Application

Now you'll be getting a form without a design with name "projectIntaler.cs"

Next step is

Right Click on the form and select AddInstaller
Now you will get two Controls on the form

ProjectInstaller1
serviceInstaller1

Take the Properties of projectInstaller1
--Set account to LocalSystem

now, take the properties or serviceInstaller1, there are three properties you must set

Start Type
Service name and
Display Name

Start type refers to how one must start this service.
Service name refers to the name to be shown in the Process List and,
Display name is the name that will be displayed inside the Services list....

Now set Start type to "Automatic",
ServiceName to "someName" and
DisplayName to "dispName"

-------------------------------------------------
Now take Service1.cs .
In this file we will be adding controls... Inside this we can only add controls form inside the Command tab. This will not show any design of the controls... More will be background controls

So we will just check a FileSystemWatcher control.
FileSystemWatcher is a control through which we can monitor an entire drive...

Add a fileSystemWatcher to it.
Now take the properties of fileSystemWatcher Set the path to the Folder or the Drive you need to Monitor...
Set EnableRaisingEvents to true...
IncludeSubDirectories to True.

There is an option also called notify Filter you can set it to anything you need.

Now take the Events of the FileSystemWatcher by clicking the Event tab in the Properties window...
Double click on the "created" event so that you get the fileSystemWatcher1_Created event.

now inside the event write these codes

-------------------------
System.IO.StreamWriter sw = new System.IO.StreamWriter(@"C:\sm.txt", true);
sw.WriteLine(e.ChangeType + " " + e.FullPath);
sw.Flush();
sw.Close();
-------------------------
This will create a file when there is change in the directory we have selected.

So now you have created a windows service... This cannot be executed directly. So we must install this service to our machine and start it.
So, First of all Build the solution... now we must install it..
For that Take the VisualStudio Command Prompt
Inside it navigate to the folder inside which we have created the service.
Now goto the debug folder ...
eg: the path will be like this

D:\Smilu\windowService\bin\debug>

now if you are inside the debug folder you can see the .exe files of your service that we need to install

For installing it type the command like this

installutil /i smilu.exe

/i - will install the service
/u - will unistall the service

-------------------------
D:\Smilu\windowService\bin\Debug>installutil /i smilu.exe
-------------------------
Here smilu.exe is the service name.

Now restart the machine... The service gets automatically started when we starts the windows.

or

Go to the control panel-->Administrative Tools-->services
Inside it there will be your service listed...
Right click on it and start the service...

Now create a file in the Directory you have mentioned for fileSystemWatcher..
and see the new file created with sm.txt in C:\.
This windows service will not be shown anywhere... It'll be working in the back ground as a process.....
To see this process Take TaskManager and see the Process tab inside it....
You can see the Process inside it.....

Now The most important thing... If you need to modify the WindowsService you first need to Uninstall the service and only after that you should create it or install it...

for unistalling it you can use

installutil /u smilu.exe

If you install a service already running it may cause upto a System crash on your machine...

The steps should be the exact cycle like this

1) Create a Windows Service
2) Install a Windows Service and use it
and now if u need to modify
1) Uninstall the running service..
2) Build the service
3) Install it again

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

Converting XML String to a Dataset in C#

2008-10-28T00:05:00.000-07:00

using System.IO;

//Event
string a=gwObj.GetCitiesByCountry("India"); //This returns an xml string
StringReader sr = new System.IO.StringReader(a);
DataSet ds = new DataSet();
ds.ReadXml(sr);
dataGridView1.DataSource = ds.Tables[0];

comboBox1.DataSource = ds.Tables[0];
comboBox1.DisplayMember = "City";

this program displays the city inside the combo box

C# Hashing

2008-07-30T20:34:00.000-07:00

using System.Security.Cryptography;

UnicodeEncoding ue = new UnicodeEncoding();
private void button1_Click(object sender, EventArgs e)
{
byte[] plaintext = ue.GetBytes(TextBoxplaintxt.Text);
MD5CryptoServiceProvider md5 = new MD5CryptoServiceProvider();
byte[] hash = md5.ComputeHash(plaintext);
TextBoxHashed.Text = Convert.ToBase64String(hash);
}

Encryption and Decryption in C#

2008-07-30T02:59:00.000-07:00

using System.IO;
using System.Security;
using System.Security.Cryptography;
string passValue;
private void EncryptButton_Click(object sender, EventArgs e)
{
try
{
passValue = textBox1.Text;
RandomNumberGenerator rnd = RandomNumberGenerator.Create();
byte[] salt = new byte[16];
rnd.GetBytes(salt);
Rfc2898DeriveBytes derBytes = new Rfc2898DeriveBytes(passValue, salt);
byte[] key = derBytes.GetBytes(16);
Rijndael cryptoAlg = Rijndael.Create();
cryptoAlg.Key = key;
FileStream fs = new FileStream(@"C:\Hello\EncryptPass.txt", FileMode.Create);
fs.Write(salt, 0, salt.Length);
fs.Write(cryptoAlg.IV, 0, cryptoAlg.IV.Length);
CryptoStream cryptStream = new CryptoStream(fs, cryptoAlg.CreateEncryptor(), CryptoStreamMode.Write);
//Converting a string to an byte array
byte[] ar = System.Text.Encoding.UTF8.GetBytes(passValue);
cryptStream.Write(ar, 0, ar.Length);
cryptStream.FlushFinalBlock();
cryptStream.Close();
MessageBox.Show("Data Encrypted");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void DecryptButton_Click(object sender, EventArgs e)
{
try
{
Rijndael deCryptoAlg = Rijndael.Create();
FileStream fs3 = new FileStream(@"C:\Hello\DecryptPass.txt", FileMode.OpenOrCreate);
FileStream fs2 = new FileStream(@"C:\Hello\EncryptPass.txt", FileMode.Open);
byte[] salt = new byte[16];
byte[] IV = new byte[deCryptoAlg.IV.Length];
fs2.Read(salt, 0, salt.Length);
fs2.Read(IV, 0, IV.Length);
Rfc2898DeriveBytes derByte = new Rfc2898DeriveBytes(passValue, salt);
byte[] key = derByte.GetBytes(16);
deCryptoAlg.Key = key;
deCryptoAlg.IV = IV;
CryptoStream cryStream = new CryptoStream(fs2, deCryptoAlg.CreateDecryptor(), CryptoStreamMode.Read);
int bytesRead = 0;
byte[] buffer = new byte[256];
do
{
bytesRead = cryStream.Read(buffer, 0, 256);
} while (bytesRead > 0);
fs3.Write(buffer, 0, 256);
fs3.Flush();
cryStream.Close();
MessageBox.Show("File Decrypted");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}

SQL Transactions in .net

2008-05-14T22:25:00.000-07:00

SqlTransaction is used in cases we are updating Multiple tables at a Time. Here the error occurs such as first table gets updated and the next table which have a relation with the first table does not get Updated due to some Errors may be some Power Failure etc.... So to overcome these types of errors we can use SqlTransaction in the programs.....

Here is an example for the SqlTransaction

public partial class Form1 : Form
{
SqlConnection con = new SqlConnection(@"Integrated Security=SSPI;Initial Catalog=NationalBank;Data Source=.\SQLEXPRESS");
SqlCommand cmd;

Here you are going to make an Object for SqlTransaction named sqtr

SqlTransaction sqtr;

public Form1()
{
InitializeComponent();
con.Open();
}

private void button1_Click(object sender, EventArgs e)
{
The below step starts the transaction
sqtr = con.BeginTransaction();

try
{
eNameInsert(txtName.Text);
eAddressInsert(txtPassword.Text);
If the transaction completes successfully the commit method is called.....
sqtr.Commit();
}
catch (Exception ex)
{
The rollback method of the SqlTransaction Undos all the things which have been updated if an Error occurs
sqtr.Rollback();
MessageBox.Show(ex.Message);
}
}
static int i;
private void eNameInsert(string Name)
{

try
{

We must mention the SqlTransaction object name after the con with each SqlCommand
cmd = new SqlCommand("Insert into eName values(@eName)", con,sqtr);
cmd.Parameters.AddWithValue("@eName", Name);
cmd.ExecuteNonQuery();

cmd = new SqlCommand("Select EId from eName where EName='" + Name + "'", con,sqtr);
i = Convert.ToInt32(cmd.ExecuteScalar());
}
catch (SqlException ex)
{
sqtr.Rollback();
MessageBox.Show(ex.Message);
}
}
private void eAddressInsert(string Address)
{

try
{
cmd = new SqlCommand("Insert into eAddress values(@id,@eAddress)", con,sqtr);
cmd.Parameters.AddWithValue("@eAddress", Address);
cmd.Parameters.AddWithValue("@id", i);
cmd.ExecuteNonQuery();
sqtr.Commit();
}
catch (SqlException ex)
{
sqtr.Rollback();
MessageBox.Show(ex.Message);
}
}