NANDA KISHORE CHINTHOJU

Sunday, May 31, 2015

update and delete gridview rows

code behind:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;

namespace gridviewedit
{
public partial class WebForm1 : System.Web.UI.Page
{
SqlConnection _con = new SqlConnection("Data Source=db205.my-hosting-panel.com;Initial Catalog=goggery_sample;Persist Security Info=True;User ID=goggery_sample;Password=sample1.0");
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
bind();
}
}
protected void bind()
{
SqlCommand _cmd = new SqlCommand("select * from emp_nandu", _con);
DataSet _ds = new DataSet();
SqlDataAdapter _da = new SqlDataAdapter(_cmd);
_da.Fill(_ds);
GridView1.DataSource = _ds;
GridView1.DataBind();
}

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row = (GridViewRow)GridView1.Rows[e.RowIndex];
int EMP_ID = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value.ToString());
Label Lbl = (Label)row.FindControl("lblemp_id");
TextBox txtename = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtename");
TextBox txtmanager = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtmanager");
TextBox txtdept = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtdept");
TextBox txtsal = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtsal");

GridView1.EditIndex = -1;
0
SqlCommand _cmd = new SqlCommand("update emp_nandu set ENAME='"+txtename.Text+"',MANAGER_ID='"+txtmanager.Text+"',DEPT='"+txtdept.Text+"', SAL='"+txtsal.Text+"' where EMP_ID="+EMP_ID+"", _con);
_con.Open();
_cmd.ExecuteNonQuery();
_con.Close();
bind();

}

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
bind();

}

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values["EMP_ID"].ToString());
// string username = GridView1.DataKeys[e.RowIndex].Values["UserName"].ToString();
_con.Open();
SqlCommand _cmd = new SqlCommand("delete from emp_nandu where EMP_ID='"+id+"'", _con);
_cmd.ExecuteNonQuery();
_con.Close();
bind();
}

protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridView1.EditIndex = -1;
bind();

}

}
}
asp page code:
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="gridviewedit.WebForm1" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body style="height: 257px; width: 627px">
<form id="form1" runat="server">
<div>

</div>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="EMP_ID"
onrowcancelingedit="GridView1_RowCancelingEdit"
onrowdeleting="GridView1_RowDeleting" onrowediting="GridView1_RowEditing"
onrowupdating="GridView1_RowUpdating"
Height="211px"
Width="617px" >
<Columns>

<asp:TemplateField HeaderText="EMP_ID">
<EditItemTemplate>
<asp:TextBox ID="txtemp_id" runat="server" Text='<%# Eval("EMP_ID") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lblemp_id" runat="server" Text='<%# Eval("EMP_ID") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="ENAME">
<EditItemTemplate>
<asp:TextBox ID="txtename" runat="server" Text='<%# Eval("ENAME") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lblename" runat="server" Text='<%# Eval("ENAME") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="MANAGER">
<EditItemTemplate>
<asp:TextBox ID="txtmanager" runat="server" Text='<%# Eval("MANAGER_ID") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lblmanager" runat="server" Text='<%# Eval("MANAGER_ID") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="DEPT">
<EditItemTemplate>
<asp:TextBox ID="txtdept" runat="server" Text='<%# Eval("DEPT") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lbltext" runat="server" Text='<%# Eval("DEPT") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="SAL">
<EditItemTemplate>
<asp:TextBox ID="txtsal" runat="server" Text='<%# Eval("SAL") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lblsal" runat="server" Text='<%# Eval("SAL") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:CommandField ShowCancelButton="true" />
<asp:CommandField ShowEditButton="true" />
<asp:CommandField ShowDeleteButton="true" />
</Columns>
</asp:GridView>
</form>
</body>
</html>

Thursday, May 14, 2015

logfile in c#

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.IO;

namespace logfile
{
public partial class WebForm1 : System.Web.UI.Page
{
SqlConnection _con = new SqlConnection("Data Source=db205.my-hosting-panel.com;Initial Catalog=goggery_sample;User ID=goggery_sample;Password=sample1.0");
protected void Page_Load(object sender, EventArgs e)
{

}

public void LogFile(string sExceptionName, string sEventName, string sFormName)
{

StreamWriter log;

if (!File.Exists("logfile.txt"))
{

log = new StreamWriter("E:\\nandu\\logfile.txt");

}

else
{

log = File.AppendText("E:\\nandu\\logfile.txt");

}

// Write to the file:

log.WriteLine("Data Time:" + DateTime.Now);

log.WriteLine("Exception Name:" + sExceptionName);

log.WriteLine("Event Name:" + sEventName);

//log.WriteLine("Control Name:" + sControlName);

//log.WriteLine("Error Line No.:" + nErrorLineNo);

log.WriteLine("Form Name:" + sFormName);

// Close the stream:

log.Close();

}

protected void btnsubmit_Click(object sender, EventArgs e)
{
try
{
SqlCommand _cmd = new SqlCommand("insert into log_nandu values('" + txtname.Text + "','" + txtcourse.Text + "','" + txtfee.Text + "')", _con);
_con.Open();
_cmd.ExecuteNonQuery();
_con.Close();
}
catch (Exception exe)
{

//call LogFile method and pass argument as Exception message, event name, control name, error line number, current form name

LogFile(exe.Message, exe.ToString(),this.Page.ToString());

}
}

}
}

Monday, March 9, 2015

interface c#

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace inter
{

public interface operations
{

void operation();
int add();
int sub();
//int mult();
}
public class math : operations
{
private int x1;
private int y1;

public math(int x, int y)
{
x1 = x;
y1 = y;

}
public int add()
{
return x1 + y1;
}
public int sub()
{
return x1 - y1;
}
public void operation()
{
Console.WriteLine("x1: {0}", x1);
Console.WriteLine("y1:{0}", y1);
Console.WriteLine("add:{0}", add());
Console.WriteLine("sub:{0}", sub());
}
}
public class math2 : operations
{
private int a;
private int b;

public math2(int c, int d)
{
a = c;
b = d;
}
public int mult()
{
return a * b;
}
public void operation()
{
Console.WriteLine("a: {0}", a);
Console.WriteLine("b:{0}", b);
Console.WriteLine("add:{0}", mult());

}
}

class Tester
{
static void Main(string[] args)
{
math madd = new math(20, 30);
math2 m2= new math2(10,30);
madd.operation();
m2.operation();
Console.ReadKey();
}
}
}

operator over loading

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace oprovr
{
class program
{

public int fun(int a, int b)
{

return(a+b);
}
public int fun(int a, int b, int c)
{
return(a+b+c);
}
public string fun(string a, string b)
{
return(a+b);
}

static void Main(string[] args)
{
//Console.WriteLine("enter values");
//int a=Convert.ToInt32(Console.ReadLine());
//int b=Convert.ToInt32(Console.ReadLine());
program f= new program();
int c=f.fun(3,5);
int b=f.fun(1,2,3);
string s = f.fun("over", "loading");
Console.WriteLine("two sum" +c);
Console.WriteLine("three sum" +b);
Console.WriteLine(s);

Console.ReadKey();
}

}
}

polyndrom using for loop c#

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace polyn
{
class Program
{
static void Main(string[] args)
{
string s,revs="";
Console.WriteLine("enter string");
s = Console.ReadLine();
for (int i = s.Length-1 ; i>= 0; i--)
{
revs += s[i].ToString();
}

if (revs == s)
{
Console.WriteLine("given string is polyndrum \ngiven string is {0}\nrevs string is {1}", s, revs);
}
else
{
Console.WriteLine("given string is not polyndrum \ngiven string is {0}\nrevs string is {1}", s, revs);
}
Console.ReadKey();

}
}
}

polyndrom using while c#

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace polyn_while
{
class Program
{
static void Main(string[] args)
{
int num, rev = 0, rem,temp=0;
Console.WriteLine("enter a no");
num = Convert.ToInt32(Console.ReadLine());
temp = num;
while (num > 0)
{
rem = num % 10;
rev= rev * 10 + rem;
num = num / 10;
}
if (rev== temp)
{
Console.WriteLine("given no is polyn:{0}",rev);
}
else
{
Console.WriteLine("given no is not a polyn:{0}", rev);

}
Console.ReadKey();
}
}
}

prime number c#

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace prime
{
class Program
{
static void Main(string[] args)
{
bool isPrime = true;
Console.WriteLine("Prime Numbers : ");
for (int i = 2; i <= 10; i++)
{
for (int j = 2; j <= 10; j++)
{

if (i != j && i % j == 0)
{
isPrime = false;
break;
}

}
if (isPrime)
{
Console.Write("\t" +i);
}
isPrime = true;
}
Console.ReadKey();
}
}
}