Saad SoNu Ali: 2017

Saturday, 11 November 2017

Funny Vital Tea Add | Arshad Chai Wala | Vital Tea

Friday, 10 November 2017

Tiger Zinda Hai | Secret Message Hidden In Movie By Salman Khan

Friday, 27 October 2017

When You Meet Your Juwda First Time | by Saad SoNu Ali

Asalam-u-Alikum Beautiful People

Tuesday, 24 October 2017

How to Make Car Driving Game In Unity in Urdu | By Saad SoNu Ali

Aslam-u-Alikum Beautiful People

Introduction To Unity in Urdu | by Saad SoNu Ali

Aslam-u-Alikum Beautiful People

Monday, 23 October 2017

How to add video file to blogger urdu/hindi | by Saad SoNu Ali

Aslam-u-Alikum Beautiful People

Saturday, 21 October 2017

Face Recognition Website | Microsoft Face API | in Urdu by Saad SoNu Ali

Aslam-u-Alikuum Beautiful People

Saturday, 14 October 2017

How to Delete Previous Version of Windows on Windows 10 by Saad SoNu Ali...

Aslam-u-Alikuum Beautiful People In This Video You Will Learn:

How to Delete Previous Version of Windows on Windows 10 And How to remove temporary files how space up disk

Spread Peace And Love And Help Other's

Aslam-u-Alikuum Beautiful People

This Is Saad And In This Video I Want To Give Message You To All That Spread Peace And Love And Help Other's

Friday, 13 October 2017

5 website to get FREE Royalty Images for Commercial use in urdu by Saad ...

Aslam-u-Alikuum Beautiful People

Thursday, 12 October 2017

Search data in database and Filter in datagridview or table in C# (Proje...

Aslam-u-Alikuum Beautiful People

void FillDataGridView()

{

if (sqlCon.State == ConnectionState.Closed)

sqlCon.Open();

SqlDataAdapter SqlDA = new SqlDataAdapter("[dbo].[CVSsearch]", sqlCon);

SqlDA.SelectCommand.CommandType = CommandType.StoredProcedure;

SqlDA.SelectCommand.Parameters.AddWithValue("@CName", textBox5.Text.Trim());

DataTable dtbl = new DataTable();

SqlDA.Fill(dtbl);

dataGridView1.DataSource = dtbl;

dataGridView1.Columns[0].Visible = false;

sqlCon.Close();

}

private void button4_Click(object sender, EventArgs e)

{

try

{

FillDataGridView();

}

catch (Exception ex)

{

SQL Code:

CREATE PROCEDURE [dbo].[CVSsearch]

@CName nvarchar(50)

select * from [dbo].[Company Name]

Where CName like @CName+'%'

Tuesday, 10 October 2017

C# Tutorial - Insert Update Delete into multiple tables in SQL (Project ...

Aslam-u-Alikuum Beautiful People

C# Code:

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

namespace AcountingSoftware
{
public partial class Form4 : Form
{
SqlConnection sqlCon = new SqlConnection(@"Data Source=DESKTOP-DODHH2V\SAAD;Initial Catalog=acoountingsoftware;Integrated Security=True");
int Id = 0;
public Form4()
{
InitializeComponent();
}

private void button1_Click(object sender, EventArgs e)
{
string user = textBox1.Text;
returnclass rc = new returnclass();
label1.Text = rc.scalarReturn("select CCode from [dbo].[Company Name] where CCode='" + user + "'");
label2.Text = rc.scalarReturn("select CName from [dbo].[Company Name] where CCode='" + user + "'");
label3.Text = rc.scalarReturn("select CAddress from [dbo].[Company Name] where CCode='" + user + "'");
label4.Text = rc.scalarReturn("select CContactinfo from [dbo].[Company Name] where CCode='" + user + "'");
}

private void Form4_Load(object sender, EventArgs e)
{
Reset();
FillDataGridView();
}

private void btnSave_Click(object sender, EventArgs e)
{

try
{
if (sqlCon.State == ConnectionState.Closed)
sqlCon.Open();
if (btnSave.Text == "Save")
{
SqlCommand sqlcmd = new SqlCommand("itemprocedures", sqlCon);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@mode", "Add");
sqlcmd.Parameters.AddWithValue("@Id", "0");
sqlcmd.Parameters.AddWithValue("@CCode", label1.Text.Trim());
sqlcmd.Parameters.AddWithValue("@CName", label2.Text.Trim());
sqlcmd.Parameters.AddWithValue("@CAddress", label3.Text.Trim());
sqlcmd.Parameters.AddWithValue("@CContactinfo", label4.Text.Trim());

sqlcmd.Parameters.AddWithValue("@Item1C", ic1.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item2C", ic2.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item3C", ic3.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item4C", ic4.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item5C", ic5.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item6C", ic6.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item7C", ic7.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item8C", ic8.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item9C", ic9.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item10C", ic10.Text.Trim());

sqlcmd.Parameters.AddWithValue("@Item1N", in1.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item2N", in2.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item3N", in3.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item4N", in4.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item5N", in5.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item6N", in6.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item7N", in7.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item8N", in8.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item9N", in9.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item10N", in10.Text.Trim());

sqlcmd.Parameters.AddWithValue("@Item1P", ip1.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item2P", ip2.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item3P", ip3.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item4P", ip4.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item5P", ip5.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item6P", ip6.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item7P", ip7.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item8P", ip8.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item9P", ip9.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item10P", ip10.Text.Trim());
sqlcmd.Parameters.AddWithValue("@AdminN", textBox5.Text.Trim());

sqlcmd.ExecuteNonQuery();
MessageBox.Show("Saved Success fully...:-)");
}
else
{

SqlCommand sqlcmd = new SqlCommand("itemprocedures", sqlCon);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@mode", "Edit");
sqlcmd.Parameters.AddWithValue("@Id", Id);
sqlcmd.Parameters.AddWithValue("@CCode", label1.Text.Trim());
sqlcmd.Parameters.AddWithValue("@CName", label2.Text.Trim());
sqlcmd.Parameters.AddWithValue("@CAddress", label3.Text.Trim());
sqlcmd.Parameters.AddWithValue("@CContactinfo", label4.Text.Trim());

sqlcmd.Parameters.AddWithValue("@Item1C", ic1.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item2C", ic2.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item3C", ic3.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item4C", ic4.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item5C", ic5.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item6C", ic6.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item7C", ic7.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item8C", ic8.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item9C", ic9.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item10C", ic10.Text.Trim());

sqlcmd.Parameters.AddWithValue("@Item1N", in1.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item2N", in2.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item3N", in3.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item4N", in4.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item5N", in5.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item6N", in6.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item7N", in7.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item8N", in8.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item9N", in9.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item10N", in10.Text.Trim());

sqlcmd.Parameters.AddWithValue("@Item1P", ip1.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item2P", ip2.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item3P", ip3.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item4P", ip4.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item5P", ip5.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item6P", ip6.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item7P", ip7.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item8P", ip8.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item9P", ip9.Text.Trim());
sqlcmd.Parameters.AddWithValue("@Item10P", ip10.Text.Trim());
sqlcmd.Parameters.AddWithValue("@AdminN", textBox5.Text.Trim());
sqlcmd.ExecuteNonQuery();
MessageBox.Show("updates Saved Success fully...:-)");

}
Reset();
FillDataGridView();

}
catch (Exception ex)
{

MessageBox.Show(ex.Message, "Error...!!");
}

finally
{
sqlCon.Close();
}
}

void FillDataGridView()
{

if (sqlCon.State == ConnectionState.Closed)
sqlCon.Open();
SqlDataAdapter SqlDA = new SqlDataAdapter("itemviewrsearch", sqlCon);
SqlDA.SelectCommand.CommandType = CommandType.StoredProcedure;
SqlDA.SelectCommand.Parameters.AddWithValue("@CCode", textBox2.Text.Trim());
SqlDA.SelectCommand.Parameters.AddWithValue("@CName", textBox3.Text.Trim());
SqlDA.SelectCommand.Parameters.AddWithValue("@CAddress", textBox4.Text.Trim());

DataTable dtbl = new DataTable();
SqlDA.Fill(dtbl);
dataGridView1.DataSource = dtbl;
dataGridView1.Columns[0].Visible = false;
sqlCon.Close();

}

private void button2_Click(object sender, EventArgs e)
{
try
{
FillDataGridView();
}
catch (Exception ex)
{

MessageBox.Show(ex.Message, "Error...!!");
}
}
void Reset()
{
ic1.Text ="";
ic2.Text ="";
ic3.Text ="";
ic4.Text ="";
ic5.Text ="";
ic6.Text ="";
ic7.Text ="";
ic8.Text ="";
ic9.Text ="";
ic10.Text ="";

in1.Text ="";
in2.Text ="";
in3.Text ="";
in4.Text ="";
in5.Text ="";
in6.Text ="";
in7.Text ="";
in8.Text ="";
in9.Text ="";
in10.Text ="";

ip1.Text ="";
ip2.Text ="";
ip3.Text ="";
ip4.Text ="";
ip5.Text ="";
ip6.Text ="";
ip7.Text ="";
ip8.Text ="";
ip9.Text ="";
ip10.Text ="";

textBox1.Text = textBox2.Text = textBox3.Text = textBox4.Text = "";

btnSave.Text = "Save";
FillDataGridView();
btnDelete.Enabled = false;
}

private void btnReset_Click(object sender, EventArgs e)
{
Reset();
}

private void btnDelete_Click(object sender, EventArgs e)
{
try
{

if (sqlCon.State == ConnectionState.Closed)
sqlCon.Open();

SqlCommand sqlcmd = new SqlCommand("[dbo].[Ideletion]", sqlCon);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@Id", Id);

sqlcmd.ExecuteNonQuery();
MessageBox.Show("Deleted Success fully...:-)");
Reset();
FillDataGridView();

}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error...!!");

}
}

private void dataGridView1_DoubleClick(object sender, EventArgs e)
{
Id = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value.ToString());

label1.Text= dataGridView1.CurrentRow.Cells[1].Value.ToString();
label2.Text= dataGridView1.CurrentRow.Cells[2].Value.ToString();
label3.Text= dataGridView1.CurrentRow.Cells[3].Value.ToString();
label4.Text= dataGridView1.CurrentRow.Cells[4].Value.ToString();

ic1.Text = dataGridView1.CurrentRow.Cells[5].Value.ToString();
in1.Text = dataGridView1.CurrentRow.Cells[6].Value.ToString();
ip1.Text = dataGridView1.CurrentRow.Cells[7].Value.ToString();

ic2.Text = dataGridView1.CurrentRow.Cells[8].Value.ToString();
in2.Text = dataGridView1.CurrentRow.Cells[9].Value.ToString();
ip2.Text = dataGridView1.CurrentRow.Cells[10].Value.ToString();

ic3.Text = dataGridView1.CurrentRow.Cells[11].Value.ToString();
in3.Text = dataGridView1.CurrentRow.Cells[12].Value.ToString();
ip3.Text = dataGridView1.CurrentRow.Cells[13].Value.ToString();

ic4.Text = dataGridView1.CurrentRow.Cells[14].Value.ToString();
in4.Text = dataGridView1.CurrentRow.Cells[15].Value.ToString();
ip4.Text = dataGridView1.CurrentRow.Cells[16].Value.ToString();

ic5.Text = dataGridView1.CurrentRow.Cells[17].Value.ToString();
in5.Text = dataGridView1.CurrentRow.Cells[18].Value.ToString();
ip5.Text = dataGridView1.CurrentRow.Cells[19].Value.ToString();

ic6.Text = dataGridView1.CurrentRow.Cells[20].Value.ToString();
in6.Text = dataGridView1.CurrentRow.Cells[21].Value.ToString();
ip6.Text = dataGridView1.CurrentRow.Cells[22].Value.ToString();

ic7.Text = dataGridView1.CurrentRow.Cells[23].Value.ToString();
in7.Text = dataGridView1.CurrentRow.Cells[24].Value.ToString();
ip7.Text = dataGridView1.CurrentRow.Cells[25].Value.ToString();

ic8.Text = dataGridView1.CurrentRow.Cells[26].Value.ToString();
in8.Text = dataGridView1.CurrentRow.Cells[27].Value.ToString();
ip8.Text = dataGridView1.CurrentRow.Cells[29].Value.ToString();

ic9.Text = dataGridView1.CurrentRow.Cells[30].Value.ToString();
in9.Text = dataGridView1.CurrentRow.Cells[31].Value.ToString();
ip9.Text = dataGridView1.CurrentRow.Cells[32].Value.ToString();

ic10.Text = dataGridView1.CurrentRow.Cells[33].Value.ToString();
in10.Text = dataGridView1.CurrentRow.Cells[34].Value.ToString();
ip10.Text = dataGridView1.CurrentRow.Cells[35].Value.ToString();


btnSave.Text = "Update";
btnDelete.Enabled = true;
}

}
}

Sql Code:

CREATE TABLE [dbo].[Items](
[Id] [int] IDENTITY(1,1) NOT NULL,
[CCode] [nvarchar](50) NULL,
[CName] [nvarchar](50) NULL,
[CAddress] [nvarchar](300) NULL,
[CContactinfo] [nvarchar](50) NULL,
[Item1C] [nvarchar](100) NULL,
[Item1N] [nvarchar](100) NULL,
[Item1P] [int] NULL,
[Item2C] [nvarchar](100) NULL,
[Item2N] [nvarchar](100) NULL,
[Item2P] [int] NULL,
[Item3C] [nvarchar](100) NULL,
[Item3N] [nvarchar](100) NULL,
[Item3P] [int] NULL,
[Item4C] [nvarchar](100) NULL,
[Item4N] [nvarchar](100) NULL,
[Item4P] [int] NULL,
[Item5C] [nvarchar](100) NULL,
[Item5N] [nvarchar](100) NULL,
[Item5P] [int] NULL,
[Item6C] [nvarchar](100) NULL,
[Item6N] [nvarchar](100) NULL,
[Item6P] [int] NULL,
[Item7C] [nvarchar](100) NULL,
[Item7N] [nvarchar](100) NULL,
[Item7P] [int] NULL,
[Item8C] [nvarchar](100) NULL,
[Item8N] [nvarchar](100) NULL,
[Item8P] [int] NULL,
[Item9C] [nvarchar](100) NULL,
[Item9N] [nvarchar](100) NULL,
[Item9P] [int] NULL,
[Item10C] [nvarchar](100) NULL,
[Item10N] [nvarchar](100) NULL,
[Item10P] [int] NULL,
[AdminN] [nvarchar](50) NULL,
CONSTRAINT [PK_Items] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

Store procedurde
For update an save:
PROCEDURE [dbo].[itemprocedures]
@mode nvarchar(50),
@Id int,
@CCode nvarchar(50),
@CName nvarchar(50),
@CAddress nvarchar(500),
@CContactinfo nvarchar(50),
@Item1C nvarchar(100),
@Item1N nvarchar(100),
@Item1P int,
@Item2C nvarchar(100),
@Item2N nvarchar(100),
@Item2P int,
@Item3C nvarchar(100),
@Item3N nvarchar(100),
@Item3P int,
@Item4C nvarchar(100),
@Item4N nvarchar(100),
@Item4P int,
@Item5C nvarchar(100),
@Item5N nvarchar(100),
@Item5P int,
@Item6C nvarchar(100),
@Item6N nvarchar(100),
@Item6P int,
@Item7C nvarchar(100),
@Item7N nvarchar(100),
@Item7P int,
@Item8C nvarchar(100),
@Item8N nvarchar(100),
@Item8P int,
@Item9C nvarchar(100),
@Item9N nvarchar(100),
@Item9P int,
@Item10C nvarchar(100),
@Item10N nvarchar(100),
@Item10P int,
@AdminN nvarchar(50)

AS
if @mode = 'Add'
BEGIN
INSERT INTO [dbo].[Items]
(
CCode ,
CName ,
CAddress ,
CContactinfo ,
Item1C ,
Item1N ,
Item1P ,
Item2C ,
Item2N ,
Item2P ,
Item3C ,
Item3N ,
Item3P ,
Item4C ,
Item4N ,
Item4P ,
Item5C ,
Item5N ,
Item5P ,
Item6C ,
Item6N ,
Item6P ,
Item7C ,
Item7N ,
Item7P ,
Item8C ,
Item8N ,
Item8P ,
Item9C ,
Item9N ,
Item9P ,
Item10C ,
Item10N ,
Item10P ,
AdminN

)
VALUES(
@CCode ,
@CName ,
@CAddress ,
@CContactinfo ,
@Item1C ,
@Item1N ,
@Item1P ,
@Item2C ,
@Item2N ,
@Item2P ,
@Item3C ,
@Item3N ,
@Item3P ,
@Item4C ,
@Item4N ,
@Item4P ,
@Item5C ,
@Item5N ,
@Item5P ,
@Item6C ,
@Item6N ,
@Item6P ,
@Item7C ,
@Item7N ,
@Item7P ,
@Item8C ,
@Item8N ,
@Item8P ,
@Item9C ,
@Item9N ,
@Item9P ,
@Item10C ,
@Item10N ,
@Item10P ,
@AdminN
)
END
ELSE If @mode='Edit'
BEGIN
UPDATE [dbo].[Items]
SET

CCode =@CCode ,
CName =@CName ,
CAddress =@CAddress ,
CContactinfo =@CContactinfo,
Item1C =@Item1C ,
Item1N =@Item1N ,
Item1P =@Item1P ,
Item2C =@Item2C ,
Item2N =@Item2N ,
Item2P =@Item2P ,
Item3C =@Item3C ,
Item3N =@Item3N ,
Item3P =@Item3P ,
Item4C =@Item4C ,
Item4N =@Item4N ,
Item4P =@Item4P ,
Item5C =@Item5C ,
Item5N =@Item5N ,
Item5P =@Item5P ,
Item6C =@Item6C ,
Item6N =@Item6N ,
Item6P =@Item6P ,
Item7C =@Item7C ,
Item7N =@Item7N ,
Item7P =@Item7P ,
Item8C =@Item8C ,
Item8N =@Item8N ,
Item8P =@Item8P ,
Item9C =@Item9C ,
Item9N =@Item9N ,
Item9P =@Item9P ,
Item10C =@Item10C ,
Item10N =@Item10N ,
Item10P =@Item10P ,
AdminN =@AdminN

WHERE Id = @Id
END

For View and search:
Create PROCEDURE [dbo].[itemviewrsearch]
@CCode nvarchar(100),
@CName nvarchar(100),
@CAddress nvarchar(100)

As
select * from [dbo].[Items]
Where CCode LIKE @CCode+'%' AND CName LIKE @CName+'%' AND CAddress LIKE @CAddress+'%'

For Delete;
Create PROCEDURE [dbo].[Ideletion]
@Id int
AS
DELETE [dbo].[Items]
WHERE Id=@Id

Monday, 9 October 2017

C# Application - Insert Delete Update Select in SQL Server (Project: Acc...

Aslam-u-Alikuum Beautiful People

Accounting Software Part 2

SQl Code

Create Tabel:

Companies Name

For Save And Update Record:

CREATE PROCEDURE [dbo].[Csuprocedures]

@mode nvarchar(50),

@Id int,

@CCode nvarchar(50),

@CName nvarchar(50),

@CAddress nvarchar(300),

@CContactinfo nvarchar(50)

AS

if @mode = 'Add'

BEGIN

INSERT INTO [dbo].[Company Name]

(

CCode,

CName,

CAddress,

CContactinfo

)

VALUES(

@CCode,

@CName,

@CAddress,

@CContactinfo

)

END

ELSE If @mode='Edit'

BEGIN

UPDATE [dbo].[Company Name]

SET

CCode = @CCode,

CName = @CName,

CAddress = @CAddress,

CContactinfo = @CContactinfo

WHERE Id = @Id

END

For Search :

CREATE PROCEDURE [dbo].[CVSsearch]

@CName nvarchar(50)

As

select * from [dbo].[Company Name]

Where CName like @CName+'%'

For Delete:

Create PROCEDURE [dbo].[CDdelete]

@Id int

AS

DELETE [dbo].[Company Name]

WHERE Id=@Id

Accounting Software Part 2

C# Code:

On Admin panel:

Form3 f = new Form3();

f.Show();

On Starting

SqlConnection sqlCon = new SqlConnection(@"Data Source=DESKTOP-DODHH2V\SAAD;Initial Catalog=acoountingsoftware;Integrated Security=True");

int Id = 0;

private void btnSave_Click(object sender, EventArgs e)

{

try

{

if (sqlCon.State == ConnectionState.Closed)

sqlCon.Open();

if (btnSave.Text == "Save")

{

SqlCommand sqlcmd = new SqlCommand("[dbo].[Csuprocedures]", sqlCon);

sqlcmd.CommandType = CommandType.StoredProcedure;

sqlcmd.Parameters.AddWithValue("@mode", "Add");

sqlcmd.Parameters.AddWithValue("@Id", "0");

sqlcmd.Parameters.AddWithValue("@CCode", textBox1.Text.Trim());

sqlcmd.Parameters.AddWithValue("@CName", textBox2.Text.Trim());

sqlcmd.Parameters.AddWithValue("@CAddress", textBox3.Text.Trim());

sqlcmd.Parameters.AddWithValue("@CContactinfo", textBox4.Text.Trim());

sqlcmd.ExecuteNonQuery();

MessageBox.Show("Saved Success fully...:-)");

}

else

{

SqlCommand sqlcmd = new SqlCommand("[dbo].[Csuprocedures]", sqlCon);

sqlcmd.CommandType = CommandType.StoredProcedure;

sqlcmd.Parameters.AddWithValue("@mode", "Edit");

sqlcmd.Parameters.AddWithValue("@Id", Id);

sqlcmd.Parameters.AddWithValue("@CCode", textBox1.Text.Trim());

sqlcmd.Parameters.AddWithValue("@CName", textBox2.Text.Trim());

sqlcmd.Parameters.AddWithValue("@CAddress", textBox3.Text.Trim());

sqlcmd.Parameters.AddWithValue("@CContactinfo", textBox4.Text.Trim());

sqlcmd.ExecuteNonQuery();

MessageBox.Show("updates Saved Success fully...:-)");

}

Reset();

FillDataGridView();

}

catch (Exception ex)

{

MessageBox.Show(ex.Message, "Error...!!");

}

finally

{

sqlCon.Close();

}

void FillDataGridView()

{

if (sqlCon.State == ConnectionState.Closed)

sqlCon.Open();

SqlDataAdapter SqlDA = new SqlDataAdapter("[dbo].[CVSsearch]", sqlCon);

SqlDA.SelectCommand.CommandType = CommandType.StoredProcedure;

SqlDA.SelectCommand.Parameters.AddWithValue("@CName", textBox5.Text.Trim());

DataTable dtbl = new DataTable();

SqlDA.Fill(dtbl);

dataGridView1.DataSource = dtbl;

dataGridView1.Columns[0].Visible = false;

sqlCon.Close();

}

private void button4_Click(object sender, EventArgs e)

{

try

{

FillDataGridView();

}

catch (Exception ex)

{

MessageBox.Show(ex.Message, "Error...!!");

}

void Reset()

{textBox1.Text = textBox2.Text = textBox3.Text = textBox4.Text = textBox5.Text = "";

btnSave.Text = "Save";

FillDataGridView();

btnDelete.Enabled = false;

}

private void btnReset_Click(object sender, EventArgs e)

{

Reset();

}

private void btnDelete_Click(object sender, EventArgs e)

{

try

{

if (sqlCon.State == ConnectionState.Closed)

sqlCon.Open();

SqlCommand sqlcmd = new SqlCommand("[dbo].[CDdelete]", sqlCon);

sqlcmd.CommandType = CommandType.StoredProcedure;

sqlcmd.Parameters.AddWithValue("@Id", Id);

sqlcmd.ExecuteNonQuery();

MessageBox.Show("Deleted Success fully...:-)");

Reset();

FillDataGridView();

}

catch (Exception ex)

{

MessageBox.Show(ex.Message, "Error...!!");

}

private void dataGridView1_DoubleClick(object sender, EventArgs e)

{

Id = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value.ToString());

textBox1.Text = dataGridView1.CurrentRow.Cells[1].Value.ToString();

textBox2.Text = dataGridView1.CurrentRow.Cells[2].Value.ToString();

textBox3.Text = dataGridView1.CurrentRow.Cells[3].Value.ToString();

textBox4.Text = dataGridView1.CurrentRow.Cells[4].Value.ToString();

btnSave.Text = "Update";

btnDelete.Enabled = true;

}

private void Form3_Load(object sender, EventArgs e)

{

Reset();

FillDataGridView();

}

DataTable dtbl = new DataTable();

SqlDA.Fill(dtbl);

dataGridView1.DataSource = dtbl;

dataGridView1.Columns[0].Visible = true;

sqlCon.Close();

}

On Search Button Event:

try

{

FillDataGridView();

}

catch (Exception ex)

{

MessageBox.Show(ex.Message, "Error...!!");

}

on Grid View Double Click Event:

Id = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value.ToString());

txtName.Text = dataGridView1.CurrentRow.Cells[1]. Value . ToString();

btnSave.Text = "Update";

btnDelete.Enabled = true;

After this do:

void Reset()

{

txtName.Text = "";

txtsearch.Text = "";

btnSave.Text = "Save";

Id = 0;

btnDelete.Enabled = false;

FillDataGridView();

}

On Button Reset Click:

Reset();

on Delete Click:

try

{

if (sqlCon.State == ConnectionState.Closed)

sqlCon.Open();

SqlCommand sqlcmd = new SqlCommand("kgonesnrdeletion", sqlCon);

sqlcmd.CommandType = CommandType.StoredProcedure;

sqlcmd.Parameters.AddWithValue("@Id", Id);

sqlcmd.ExecuteNonQuery();

MessageBox.Show("Deleted Success fully...:-)");

Reset();

FillDataGridView();

}

catch (Exception ex)

{

MessageBox.Show(ex.Message, "Error...!!");

}

Create Login Window in C# Using SQL Server (Project Accounting Part:1) i...

Aslam-u-Alikuum Beautiful People

Acountting Software Part1

SQL

Create database acoountingsoftware

CREATE TABLE [dbo].[Login](

[Id] [int] IDENTITY(1,1) NOT NULL,

[Username] [nvarchar](50) NULL,

[Password] [nvarchar](50) NULL,

CONSTRAINT [PK_Login] PRIMARY KEY CLUSTERED

(

[Id] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

Visual C# Code

Return Class

class returnclass

{

public string scalarReturn(string q)

{

string s ;

SqlConnection conn = new SqlConnection(@"Data Source=DESKTOP-DODHH2V\SAAD;Initial Catalog=acoountingsoftware;Integrated Security=True"); //connection obj

conn.Open(); //opening connection

try

{

SqlCommand cmd = new SqlCommand(q, conn); //querry execution

s = cmd.ExecuteScalar().ToString();

}

catch (Exception)

{

s = " ";

}

conn.Close();

return s;

}

On Button Click Event:

private void button1_Click(object sender, EventArgs e)

{

string user = textBox1.Text;

string password = textBox2.Text;

string userdb, passworddb;

returnclass rc = new returnclass();

userdb = rc.scalarReturn("select Username from Login where Username='" + user + "'");

if (userdb.Equals("0"))

{

MessageBox.Show("Invalid user name!");

}

else

{

passworddb = rc.scalarReturn("select Password from Login where Password='" + password + "'");

if (passworddb.Equals(password))

{

Form2 f = new Form2();

f.Show();

}

else

{

MessageBox.Show("Invalid Password!");

}

}

}

Saturday, 7 October 2017

How to Connect html5 Website to ASP.NET(Project: Student Home Work : Par...

Aslam-u-Alikum Beautiful People

View And Search In ASP.Net (Project:Student Home Work : Part 3) in urdu ...

Aslam-u-Alikuum Beautiful People

save update and delete Data in SQL in ASP Net (Project: Student Home Wo...

Aslam-u-Alikuum Beautiful People

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

How To Insert View Update Delete and Search Data with Sql Server +(done)

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

How to Search Record (done)

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

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

Part 2:

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

How To Insert View Update Delete and Search Data with Sql Server

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

Step 1:

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

Desing View :

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

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="HWORK.aspx.cs" Inherits="HWORK" %>

<!DOCTYPE html>

.auto-style1 {

width: 207px;

}

.auto-style2 {

width: 524px;

}

</style>

</head>

<div>

<asp:HiddenField ID="hfId" runat="server" />

<tr>

<asp:Label ID="Label1" runat="server" Text="Day"></asp:Label>

</td>

<asp:DropDownList ID="DropDownList6" runat="server" Height="16px" style="margin-left: 0px; margin-top: 0px" Width="103px">

<%--<asp:ListItem>Nursery</asp:ListItem>

<asp:ListItem>KG-1</asp:ListItem>

<asp:ListItem>KG-2</asp:ListItem>--%>

<asp:ListItem>1</asp:ListItem>

<asp:ListItem>2</asp:ListItem>

<asp:ListItem>3</asp:ListItem>

<asp:ListItem>4</asp:ListItem>

<asp:ListItem>5</asp:ListItem>

<asp:ListItem>6</asp:ListItem>

<asp:ListItem>7</asp:ListItem>

<asp:ListItem>8</asp:ListItem>

<asp:ListItem>9</asp:ListItem>

<asp:ListItem>10</asp:ListItem>

<asp:ListItem>11</asp:ListItem>

<asp:ListItem>12</asp:ListItem>

<asp:ListItem>13</asp:ListItem>

<asp:ListItem>14</asp:ListItem>

<asp:ListItem>15</asp:ListItem>

<asp:ListItem>16</asp:ListItem>

<asp:ListItem>17</asp:ListItem>

<asp:ListItem>18</asp:ListItem>

<asp:ListItem>19</asp:ListItem>

<asp:ListItem>20</asp:ListItem>

<asp:ListItem>21</asp:ListItem>

<asp:ListItem>22</asp:ListItem>

<asp:ListItem>23</asp:ListItem>

<asp:ListItem>24</asp:ListItem>

<asp:ListItem>25</asp:ListItem>

<asp:ListItem>26</asp:ListItem>

<asp:ListItem>27</asp:ListItem>

<asp:ListItem>28</asp:ListItem>

<asp:ListItem>29</asp:ListItem>

<asp:ListItem>30</asp:ListItem>

<asp:ListItem></asp:ListItem>

</asp:DropDownList>

<asp:Label ID="Label14" runat="server" Text="Class"></asp:Label>

  <asp:DropDownList ID="DropDownList4" runat="server" Height="22px" style="margin-left: 26px; margin-top: 0px" Width="103px">

<%--<asp:ListItem>Nursery</asp:ListItem>

<asp:ListItem>KG-1</asp:ListItem>

<asp:ListItem>KG-2</asp:ListItem>--%>

<asp:ListItem>1</asp:ListItem>

<asp:ListItem>2</asp:ListItem>

<asp:ListItem>3</asp:ListItem>

<asp:ListItem>4</asp:ListItem>

<asp:ListItem>5</asp:ListItem>

<asp:ListItem>6</asp:ListItem>

<asp:ListItem>7</asp:ListItem>

<asp:ListItem>8</asp:ListItem>

<asp:ListItem>9</asp:ListItem>

<asp:ListItem>10</asp:ListItem>

<asp:ListItem>11</asp:ListItem>

<asp:ListItem>12</asp:ListItem>

<asp:ListItem>KG-1</asp:ListItem>

<asp:ListItem>KG-2</asp:ListItem>

<asp:ListItem>Nursery</asp:ListItem>

<asp:ListItem></asp:ListItem>

</asp:DropDownList>

</td>

</tr>

<tr>

<asp:Label ID="Label2" runat="server" Text="Session"></asp:Label>

</td>

<asp:TextBox ID="txts" runat="server" Width="208px"></asp:TextBox>

</td>

</tr>

<tr>

<asp:Label ID="Label3" runat="server" Text="Month"></asp:Label>

</td>

<asp:DropDownList ID="DropDownList5" runat="server" Height="16px" style="margin-left: 2px; margin-top: 0px" Width="103px">

<%--<asp:ListItem>Nursery</asp:ListItem>

<asp:ListItem>KG-1</asp:ListItem>

<asp:ListItem>KG-2</asp:ListItem>--%>

<asp:ListItem>1</asp:ListItem>

<asp:ListItem>2</asp:ListItem>

<asp:ListItem>3</asp:ListItem>

<asp:ListItem>4</asp:ListItem>

<asp:ListItem>5</asp:ListItem>

<asp:ListItem>6</asp:ListItem>

<asp:ListItem>7</asp:ListItem>

<asp:ListItem>8</asp:ListItem>

<asp:ListItem>9</asp:ListItem>

<asp:ListItem>10</asp:ListItem>

<asp:ListItem>11</asp:ListItem>

<asp:ListItem>12</asp:ListItem>

</asp:DropDownList>

</td>

</tr>

<tr>

<asp:Label ID="Label4" runat="server" Text="Homework"></asp:Label>

</td>

<asp:TextBox ID="txthw" runat="server" TextMode="MultiLine" Height="107px" Width="518px"></asp:TextBox>

</td>

</tr>

<tr>

</td>

<asp:Button ID="btnSave" runat="server" Text="Save" OnClick="btnSave_Click" Width="77px" />

<asp:Button ID="btnDelete" runat="server" Text="Delete" OnClick="btnDelete_Click" Width="77px" />

<asp:Button ID="btnClear" runat="server" Text="Clear" OnClick="btnClear_Click" Width="69px" />

</td>

</tr>

<tr>

</td>

<asp:Label ID="lblErrorMessage" runat="server" Text="" ForeColor="Red"></asp:Label>

<asp:Label ID="lblSuccessMessage" runat="server" Text="" ForeColor="Green"></asp:Label>

<asp:Label ID="Label16" runat="server" ForeColor="#FF3300" Text="Fill Al Text Feild" Visible="False"></asp:Label>

</td>

<tr>

</td>

 </td>

</tr>

</table>

</div>

<p>

<%--<a href="index.html">SAAD</a>--%>

<asp:Label ID="Label10" runat="server" style="margin-left: 40px" Text="Day:"></asp:Label>

<asp:DropDownList ID="DropDownList1" runat="server" Height="16px" style="margin-left: 26px; margin-top: 0px" Width="103px">

<%--<asp:ListItem>Nursery</asp:ListItem>

<asp:ListItem>KG-1</asp:ListItem>

<asp:ListItem>KG-2</asp:ListItem>--%>

<asp:ListItem>1</asp:ListItem>

<asp:ListItem>2</asp:ListItem>

<asp:ListItem>3</asp:ListItem>

<asp:ListItem>4</asp:ListItem>

<asp:ListItem>5</asp:ListItem>

<asp:ListItem>6</asp:ListItem>

<asp:ListItem>7</asp:ListItem>

<asp:ListItem>8</asp:ListItem>

<asp:ListItem>9</asp:ListItem>

<asp:ListItem>10</asp:ListItem>

<asp:ListItem>11</asp:ListItem>

<asp:ListItem>12</asp:ListItem>

<asp:ListItem>13</asp:ListItem>

<asp:ListItem>14</asp:ListItem>

<asp:ListItem>15</asp:ListItem>

<asp:ListItem>16</asp:ListItem>

<asp:ListItem>17</asp:ListItem>

<asp:ListItem>18</asp:ListItem>

<asp:ListItem>19</asp:ListItem>

<asp:ListItem>20</asp:ListItem>

<asp:ListItem>21</asp:ListItem>

<asp:ListItem>22</asp:ListItem>

<asp:ListItem>23</asp:ListItem>

<asp:ListItem>24</asp:ListItem>

<asp:ListItem>25</asp:ListItem>

<asp:ListItem>26</asp:ListItem>

<asp:ListItem>27</asp:ListItem>

<asp:ListItem>28</asp:ListItem>

<asp:ListItem>29</asp:ListItem>

<asp:ListItem>30</asp:ListItem>

<asp:ListItem></asp:ListItem>

</asp:DropDownList>

<asp:Label ID="Label11" runat="server" style="margin-left: 40px" Text="Month"></asp:Label>

 <asp:DropDownList ID="DropDownList2" runat="server" Height="16px" style="margin-left: 26px; margin-top: 0px" Width="103px">

<%--<asp:ListItem>Nursery</asp:ListItem>

<asp:ListItem>KG-1</asp:ListItem>

<asp:ListItem>KG-2</asp:ListItem>--%>

<asp:ListItem>1</asp:ListItem>

<asp:ListItem>2</asp:ListItem>

<asp:ListItem>3</asp:ListItem>

<asp:ListItem>4</asp:ListItem>

<asp:ListItem>5</asp:ListItem>

<asp:ListItem>6</asp:ListItem>

<asp:ListItem>7</asp:ListItem>

<asp:ListItem>8</asp:ListItem>

<asp:ListItem>9</asp:ListItem>

<asp:ListItem>10</asp:ListItem>

<asp:ListItem>11</asp:ListItem>

<asp:ListItem>12</asp:ListItem>

</asp:DropDownList>

<asp:Label ID="Label12" runat="server" style="margin-left: 40px" Text="Session"></asp:Label>

<asp:TextBox ID="TextBox1" runat="server" Height="20px" style="margin-left: 56px; margin-top: 0px;" Width="105px"></asp:TextBox>

<asp:Label ID="Label13" runat="server" style="margin-left: 40px" Text="Class"></asp:Label>

     <asp:DropDownList ID="DropDownList3" runat="server" Height="16px" style="margin-left: 26px; margin-top: 0px" Width="103px">

<%--<asp:ListItem>Nursery</asp:ListItem>

<asp:ListItem>KG-1</asp:ListItem>

<asp:ListItem>KG-2</asp:ListItem>--%>

<asp:ListItem>1</asp:ListItem>

<asp:ListItem>2</asp:ListItem>

<asp:ListItem>3</asp:ListItem>

<asp:ListItem>4</asp:ListItem>

<asp:ListItem>5</asp:ListItem>

<asp:ListItem>6</asp:ListItem>

<asp:ListItem>7</asp:ListItem>

<asp:ListItem>8</asp:ListItem>

<asp:ListItem>9</asp:ListItem>

<asp:ListItem>10</asp:ListItem>

<asp:ListItem>11</asp:ListItem>

<asp:ListItem>12</asp:ListItem>

<asp:ListItem>KG-1</asp:ListItem>

<asp:ListItem>KG-2</asp:ListItem>

<asp:ListItem>Nursery</asp:ListItem>

<asp:ListItem></asp:ListItem>

</asp:DropDownList>

<asp:Button ID="Button1" runat="server" Height="27px" OnClick="Button1_Click" style="margin-left: 56px" Text="Search" Width="90px" />

<asp:Label ID="Label15" runat="server" ForeColor="Red" Text="Error Fill All Feild" Visible="False"></asp:Label>

</p>

<asp:GridView ID="gvContact" runat="server" AutoGenerateColumns="false" Height="61px" Width="895px" HorizontalAlign="Center" style="margin-left: 96px">

<asp:BoundField DataField="Day" HeaderText="Day" />

<asp:BoundField DataField="Session" HeaderText="Session" />

<asp:BoundField DataField="Month" HeaderText="Month" />

<asp:BoundField DataField="HomeWork" HeaderText="HomeWork" />

<asp:TemplateField>

<asp:LinkButton ID="lnkView" runat="server" CommandArgument='<%# Eval("Id") %>' OnClick="lnk_OnClick">View</asp:LinkButton>

</ItemTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>

<p>

 </p>

<p>

 </p>

</form>

</body>

</html>

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

Step2:

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

Sql Server Database code

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

CREATE TABLE [dbo].[homework](

[Id] [int] IDENTITY(1,1) NOT NULL,

[Date] [nvarchar](100) NULL,

[Session] [int] NULL,

[Month] [int] NULL,

[HomeWork] [nvarchar](2000) NULL,

[Day] [int] NULL,

[Class] [int] NULL,

CONSTRAINT [PK_homework] PRIMARY KEY CLUSTERED

(

[Id] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

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

SQL STORE PROCEDURE

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

fOR INSERT AND UPDATE

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

CREATE PROCEDURE [dbo].[hworkinsertup]

@Id int,

@Session int,

@Month int,

@HomeWork nvarchar(100),

@Day int,

@Class int

BEGIN

IF(@Id=0)

INSERT INTO homework(

Session ,

Month ,

HomeWork ,

Day,

Class)

VALUES

(

@Session ,

@Month ,

@HomeWork ,

@Day,

@Class)

ELSE

BEGIN

UPDATE homework

SET

Session =@Session ,

Month =@Month ,

HomeWork =@HomeWork,

Day=@Day,

Class=@Class

WHERE Id = @Id

END

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

fOR VIEW ALL RECORD

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

CREATE PROCEDURE [dbo].[hwviewall]

BEGIN

SELECT*

FROM [dbo].[homework]

END

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

FOR VIEW BY ID

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

CREATE PROCEDURE [dbo].[hwviewbyid]

@Id int

BEGIN

SELECT * FROM [dbo].[homework]WHERE Id = @Id

END

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

fOR SEARCH

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

CREATE PROCEDURE [dbo].[hwviewbysearch]

@Day int,

@Month int,

@Session int,

@Class int

BEGIN

SELECT * FROM [dbo].[homework]

WHERE Day = @Day AND Session LIKE @Session AND Class LIKE @Class

END

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

fOR DELETE

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

CREATE PROCEDURE [dbo].[hwdelete]

@Id int

BEGIN

DELETE FROM [dbo].[homework]WHERE Id = @Id

END

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

Step 3

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

C# Code

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

On Page Start

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

SqlConnection sqlCon = new SqlConnection(@"");

returnclass rc = new returnclass();

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

On Page Load Event:

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

if (!IsPostBack)

{

btnDelete.Enabled = false;

}

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

Reset Code :

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

protected void btnSave_Click(object sender, EventArgs e)

{

if (txthw.Text == "")

{

Label16.Visible = true;

}

else

{

if (sqlCon.State == ConnectionState.Closed)

sqlCon.Open();

SqlCommand sqlCmd = new SqlCommand("[dbo].[hworkinsertup]", sqlCon);

sqlCmd.CommandType = CommandType.StoredProcedure;

sqlCmd.Parameters.AddWithValue("@Id", (hfId.Value == "" ? 0 : Convert.ToInt32(hfId.Value)));

sqlCmd.Parameters.AddWithValue("@Day", DropDownList6.Text.Trim());

sqlCmd.Parameters.AddWithValue("@Session", txts.Text.Trim());

sqlCmd.Parameters.AddWithValue("@Month", DropDownList5.Text.Trim());

sqlCmd.Parameters.AddWithValue("@HomeWork", txthw.Text.Trim());

sqlCmd.Parameters.AddWithValue("@Class", DropDownList4.Text.Trim());

sqlCmd.ExecuteNonQuery();

sqlCon.Close();

string contactID = hfId.Value;

Clear();

if (contactID == "")

lblSuccessMessage.Text = "Saved Successfully";

else

lblSuccessMessage.Text = "Updated Successfully";

Label16.Visible = false;

// FillGridView();

}

protected void btnClear_Click(object sender, EventArgs e)

{

Clear();

}

public void Clear()

{

hfId.Value = "";

DropDownList6.Text = txts.Text = DropDownList5.Text = txthw.Text = "";

lblSuccessMessage.Text = lblErrorMessage.Text = "";

btnSave.Text = "Save";

btnDelete.Enabled = false;

}

void FillGridView()

{

if (TextBox1.Text == "")

{

Label15.Visible = true;

}

else

{

int Day = Convert.ToInt32((DropDownList1.Text));

int Month = Convert.ToInt32((DropDownList1.Text));

int Session = Convert.ToInt32((TextBox1.Text));

int Class = Convert.ToInt32((DropDownList1.Text));

if (sqlCon.State == ConnectionState.Closed)

sqlCon.Open();

SqlDataAdapter sqlDa = new SqlDataAdapter("[dbo].[hwviewbysearch]", sqlCon);

sqlDa.SelectCommand.CommandType = CommandType.StoredProcedure;

sqlDa.SelectCommand.Parameters.AddWithValue("@Day", Day);

sqlDa.SelectCommand.Parameters.AddWithValue("@Month", Month);

sqlDa.SelectCommand.Parameters.AddWithValue("@Session", Session);

sqlDa.SelectCommand.Parameters.AddWithValue("@Class", Class);

DataTable dtbl = new DataTable();

sqlDa.Fill(dtbl);

sqlCon.Close();

gvContact.DataSource = dtbl;

gvContact.DataBind();

Label15.Visible = false;

}

protected void lnk_OnClick(object sender, EventArgs e)

{

int contactID = Convert.ToInt32((sender as LinkButton).CommandArgument);

if (sqlCon.State == ConnectionState.Closed)

sqlCon.Open();

SqlDataAdapter sqlDa = new SqlDataAdapter("[dbo].[hwviewbyid]", sqlCon);

sqlDa.SelectCommand.CommandType = CommandType.StoredProcedure;

sqlDa.SelectCommand.Parameters.AddWithValue("@Id", contactID);

DataTable dtbl = new DataTable();

sqlDa.Fill(dtbl);

sqlCon.Close();

hfId.Value = contactID.ToString();

DropDownList6.Text = dtbl.Rows[0]["Day"].ToString();

txts.Text = dtbl.Rows[0]["Session"].ToString();

DropDownList5.Text = dtbl.Rows[0]["Month"].ToString();

txthw.Text = dtbl.Rows[0]["HomeWork"].ToString();

btnSave.Text = "Update";

btnDelete.Enabled = true;

}

protected void btnDelete_Click(object sender, EventArgs e)

{

if (sqlCon.State == ConnectionState.Closed)

sqlCon.Open();

SqlCommand sqlCmd = new SqlCommand("[dbo].[hwdelete]",sqlCon);

sqlCmd.CommandType = CommandType.StoredProcedure;

sqlCmd.Parameters.AddWithValue("@Id",Convert.ToInt32(hfId.Value));

sqlCmd.ExecuteNonQuery();

sqlCon.Close();

Clear();

// FillGridView();

lblSuccessMessage.Text = "Deleted Successfully";

}

// protected void gvContact_SelectedIndexChanged(object sender, EventArgs e)

// {

// }

protected void Button1_Click(object sender, EventArgs e)

{

FillGridView();

// string i,o,p;

// i = DropDownList1.Text;

// o = DropDownList2.Text;

// p = TextBox1.Text;

// Label6.Text = rc.scalarReturn("select Date from homework where Day = LIKE'+ i' Month ='+ o' Session= '+ p'");

// Label5.Text = rc.scalarReturn("select HomeWork from homework where Day ='+ i' Month ='+ o' Session= '+ p'");

}

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

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

Part 2

Compelete :-)

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

Thumbs Up This Video

And

Subscribe To My Channel

And

Trun Notifications On

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

Till Next Time

Aslam-u-Alikum Beautiful People

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

Saturday, 11 November 2017

Friday, 10 November 2017

Wednesday, 8 November 2017

Friday, 27 October 2017

Asalam-u-Alikum Beautiful People

Tuesday, 24 October 2017

Aslam-u-Alikum Beautiful People

Aslam-u-Alikum Beautiful People

Monday, 23 October 2017

Aslam-u-Alikum Beautiful People

Saturday, 21 October 2017

Aslam-u-Alikuum Beautiful People

Saturday, 14 October 2017

Aslam-u-Alikuum Beautiful People In This Video You Will Learn:

How to Delete Previous Version of Windows on Windows 10 And How to remove temporary files how space up disk

Aslam-u-Alikuum Beautiful People

Friday, 13 October 2017

Aslam-u-Alikuum Beautiful People

Thursday, 12 October 2017

Tuesday, 10 October 2017

Aslam-u-Alikuum Beautiful People

Monday, 9 October 2017

Aslam-u-Alikuum Beautiful People

Aslam-u-Alikuum Beautiful People

Saturday, 7 October 2017

Aslam-u-Alikum Beautiful People

Aslam-u-Alikuum Beautiful People

Aslam-u-Alikuum Beautiful People