NRSolution4u Dot net Learning

Sunday, September 16, 2018

Display MAC Address

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Net.NetworkInformation;

public partial class _Default : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

}

protected void Button1_Click(object sender, EventArgs e)

{

NetworkInterface[] nics = NetworkInterface.GetAllNetworkInterfaces();

String sMacAddress = string.Empty;

foreach (NetworkInterface adapter in nics)

{

if (sMacAddress == String.Empty)// only return MAC Address from first card

{

sMacAddress = adapter.GetPhysicalAddress().ToString();

}

TextBox1.Text = sMacAddress;

}

Database Query using Class Concept

1. Create class ( website->add new item-> class file ( .cs) )

public class Class1
{
SqlDataReader dr;
SqlCommand cm;
SqlConnection cn;

public string Connection()
{

string cs = @"path";
return cs;
}

public string querry()
{
string k = "select * from Table1";
return k;
}

public string INSERT()
{

string q = "insert into Table1 values";
return q;
}
}

2. How to access class file in aspx page

protected void Button1_Click(object sender, EventArgs e)
{

Class1 MY1 = new Class1();
string cs = MY1.Connection();
cn = new SqlConnection(cs);
cn.Open();

string k = MY1.INSERT()+"('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "')";

cm = new SqlCommand(k, cn);

cm.ExecuteNonQuery();

Response.Write("Data saved");

}

Array List Counter in asp.net c#

string branch="CSE";

string semester = "7";

string cs = ConfigurationManager.AppSettings["keyname"];

cn = new SqlConnection(cs);

cn.Open();

ArrayList myarray = new ArrayList();

string k = "SELECT email FROM table where year='" + ListBox1.Text + "' GROUP BY email";

cm = new SqlCommand(k, cn);

dr = cm.ExecuteReader();

while (dr.Read())

{

myarray.Add(dr["email"]);

}

Label120.Text = myarray.Count.ToString();

}

Query string using response.redirect function

Button Click Event :

Response.Redirect("Default3.aspx?roll=" + TextBox2.Text);

Response.Redirect("Default2.aspx?UserId="+txtUserId.Text+"

&UserName="+txtUserName.Text);
protected void Page_Load(object sender, EventArgs e)
{

if (Request.QueryString.Count > 0)
{

TextBox1.Text=Request.QueryString["roll"];

}

}

QUERY String on Gridview in ASP.NET

SET GRIDVIEW PROPERTY HYPERLINK FIELDS

DATANAVIGATEURL : bdetail.aspx?sno={0}+&name={1}+&cost={2}+&ocost={3}+&bcost={4}+&bid={5}

QUERY STRING CALL PAGE LOAD

TextBox4.Text = Request.QueryString["sno"];

TextBox5.Text = Request.QueryString["name"];

TextBox10.Text = Request.QueryString["cost"];

TextBox6.Text = Request.QueryString["bcost"];

TextBox9.Text = Request.QueryString["bid"];

Friday, September 14, 2018

Random password simple code

Random rr = new Random();
int n = (int)(rr.NextDouble() * 9999);
string x = "NRSOLUTION";
Label4.Text = x.ToString() + "@" + n.ToString();

Tuesday, September 11, 2018

FileUPLOAD CONTROL SIMPLE WAY FOR UPLOADING FILE

HOSTED CODE ONLY

if (!IsPostBack)
{

FileUpload1.Attributes["onchange"] = "UploadFile(this)";
}

protected void Upload(object sender, EventArgs e)

{

FileUpload1.SaveAs(Server.MapPath(@"~/Admin/") + "//member//" + FileUpload1.FileName);

Label1.Text = FileUpload1.FileName;

Image1.ImageUrl = "/Admin/member/" + Label1.Text;

}

ASPX CODE

<HEAD>

function UploadFile(fileUpload) {

if (fileUpload.value != '') {

document.getElementById("<%=btnUpload.ClientID %>").click();

}

</script>

</HEAD>

<asp:FileUpload ID="FileUpload1" runat="server"/><br />

<asp:Button ID="btnUpload" Text="Upload" runat="server" OnClick="Upload" Style="display: none" />