foreach (System.IO.DriveInfo drive in System.IO.DriveInfo.GetDrives())
{
TreeNode node = new TreeNode();
node.Value = drive.Name;
//Make sure the drive is ready before we access it
if (drive.IsReady)
{
node.Text = drive.Name + " - (free space: " + drive.AvailableFreeSpace + ")";
this.TreeView1.Nodes.Add(node);
}
else
{
node.Text = drive.Name + " - (not ready)";
this.TreeView1.Nodes.Add(node);
}
}
Thursday, February 4, 2010
This will give all information about c:\
System.IO.DriveInfo Drive = new System.IO.DriveInfo(@"c:\");
lblDriveName.Text = Drive.Name;
lblDriveType.Text = Drive.DriveType.ToString();
lblAvailableFreeSpace.Text = Drive.AvailableFreeSpace.ToString();
lblDriveFormat.Text = Drive.DriveFormat;
lblTotalFreeSpace.Text = Drive.TotalFreeSpace.ToString();
lblTotalSize.Text = Drive.TotalSize.ToString();
lblVolumeLabel.Text = Drive.VolumeLabel;
lblDriveName.Text = Drive.Name;
lblDriveType.Text = Drive.DriveType.ToString();
lblAvailableFreeSpace.Text = Drive.AvailableFreeSpace.ToString();
lblDriveFormat.Text = Drive.DriveFormat;
lblTotalFreeSpace.Text = Drive.TotalFreeSpace.ToString();
lblTotalSize.Text = Drive.TotalSize.ToString();
lblVolumeLabel.Text = Drive.VolumeLabel;
Hto dynamically set IsReadonly property of the File to false
string download_filename = (Server.MapPath("aatish.txt"));
System.IO.FileInfo fileInfo = new System.IO.FileInfo(download_filename);
fileInfo.IsReadOnly = false;
System.IO.FileInfo fileInfo = new System.IO.FileInfo(download_filename);
fileInfo.IsReadOnly = false;
How to create webservice ?
1) create file with .asmx file
2) write your logic in .cs file for example
using System;
using System.Collections;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Xml.Linq;
using System.Data;
using System.Data.SqlClient;
///
/// Summary description for WebService_360
///
[WebService(Namespace = "http://aatish.com/WebService_360", Name = "GetCustomers")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.
// [System.Web.Script.Services.ScriptService]
public class WebService_360 : System.Web.Services.WebService {
public WebService_360 () {
//Uncomment the following line if using designed components
//InitializeComponent();
}
[WebMethod]
public DataSet GetCustomers()
{
SqlConnection conn;
SqlDataAdapter myDataAdapter;
DataSet myDataSet;
string cmdString = ("select * from student_info");
conn = new SqlConnection("Server=myserver;database=allexample;Integrated Security=SSPI;");
myDataAdapter = new SqlDataAdapter(cmdString, conn);
myDataSet = new DataSet();
myDataAdapter.Fill(myDataSet, "student_info");
return myDataSet;
}
}
3) Add ref to web service through
add web references
4) call web service
protected void Button1_Click(object sender, EventArgs e)
{
try
{
myservices.customer mycustomer = new myservices.customer();
GridView1.DataSource = mycustomer.getcustomer();
GridView1.DataBind();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
2) write your logic in .cs file for example
using System;
using System.Collections;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Xml.Linq;
using System.Data;
using System.Data.SqlClient;
///
/// Summary description for WebService_360
///
[WebService(Namespace = "http://aatish.com/WebService_360", Name = "GetCustomers")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.
// [System.Web.Script.Services.ScriptService]
public class WebService_360 : System.Web.Services.WebService {
public WebService_360 () {
//Uncomment the following line if using designed components
//InitializeComponent();
}
[WebMethod]
public DataSet GetCustomers()
{
SqlConnection conn;
SqlDataAdapter myDataAdapter;
DataSet myDataSet;
string cmdString = ("select * from student_info");
conn = new SqlConnection("Server=myserver;database=allexample;Integrated Security=SSPI;");
myDataAdapter = new SqlDataAdapter(cmdString, conn);
myDataSet = new DataSet();
myDataAdapter.Fill(myDataSet, "student_info");
return myDataSet;
}
}
3) Add ref to web service through
add web references
4) call web service
protected void Button1_Click(object sender, EventArgs e)
{
try
{
myservices.customer mycustomer = new myservices.customer();
GridView1.DataSource = mycustomer.getcustomer();
GridView1.DataBind();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
How to use 3 tier architecture ?
1) create App_code folder
2) In App_code folder create BLL folder and again In BLL folder create BLL.CS file
3) In App_code folder create DAL folder and again In DAL folder create DAL.CS file
4) IN every BLL and DLL class file create private,public regions for variables and methods.
FOR EXAMPLE BLL.cs
using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
///
/// Summary description for BLL
///
public class BLL
{
public BLL()
{
//
// TODO: Add constructor logic here
//
}
#region Private Variables
DateTime _date;
#endregion
#region Public Properties
public DateTime DATE
{
set { _date = value; }
get { return _date; }
}
#endregion
#region Public Methods
public DataSet GetUserInfo()
{
DataSet ds = new DataSet();
try
{
ds = DAL.GetUserInfo(this);
return ds;
}
catch(Exception ex)
{
ex=ex;
return ds;
}
}
FOR EXAMPLE DAL.cs
using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using LCE.DAL;
using System.Data.SqlClient;
///
/// Summary description for DAL
///
public class DAL
{
public DAL()
{
//
// TODO: Add constructor logic here
//
}
#region Private Variables
#endregion
#region Public Properties
#endregion
#region Public Methods
public static DataSet GetUserInfo(BLL objUser)
{
DataSet ds = new DataSet();
try
{
ds = (SqlHelper.ExecuteDataset(LCE.Configuration.GetConnectionString(), CommandType.StoredProcedure,
"spGetUserInfo"));
return ds;
}
catch(Exception ex)
{
ex = ex;
return ds;
}
}
2) In App_code folder create BLL folder and again In BLL folder create BLL.CS file
3) In App_code folder create DAL folder and again In DAL folder create DAL.CS file
4) IN every BLL and DLL class file create private,public regions for variables and methods.
FOR EXAMPLE BLL.cs
using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
///
/// Summary description for BLL
///
public class BLL
{
public BLL()
{
//
// TODO: Add constructor logic here
//
}
#region Private Variables
DateTime _date;
#endregion
#region Public Properties
public DateTime DATE
{
set { _date = value; }
get { return _date; }
}
#endregion
#region Public Methods
public DataSet GetUserInfo()
{
DataSet ds = new DataSet();
try
{
ds = DAL.GetUserInfo(this);
return ds;
}
catch(Exception ex)
{
ex=ex;
return ds;
}
}
FOR EXAMPLE DAL.cs
using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using LCE.DAL;
using System.Data.SqlClient;
///
/// Summary description for DAL
///
public class DAL
{
public DAL()
{
//
// TODO: Add constructor logic here
//
}
#region Private Variables
#endregion
#region Public Properties
#endregion
#region Public Methods
public static DataSet GetUserInfo(BLL objUser)
{
DataSet ds = new DataSet();
try
{
ds = (SqlHelper.ExecuteDataset(LCE.Configuration.GetConnectionString(), CommandType.StoredProcedure,
"spGetUserInfo"));
return ds;
}
catch(Exception ex)
{
ex = ex;
return ds;
}
}
Wednesday, February 3, 2010
How to make connection on page.
How to make connection on page.
SqlConnection conn = new SqlConnection ("server=360-2009-09; database=all example; Integrated Security=SSPI ;");
SqlCommand cmd;
SqlDataAdapter da;
SqlDataReader dr;
DataSet ds = new DataSet ();
ON Page Load
con.Open ();
da =new SqlDataAdapter("select * from New_user",con);
DataSet ds = new DataSet();
da.Fill (ds,"New_user");
datagrid1.DataSource=ds;
datagrid1.DataBind ();
con.Close ();
OR (SELECT)
cmd = new SqlCommand("select * from user_info where userid=@userid", conn);
int myvalue = Convert.ToInt16(GridView1.SelectedRow);
cmd.Parameters.Add("userid",GridView1.SelectedValue);
dr = cmd.ExecuteReader();
dr.Read();
while(dr.Read())
{
assign values to diffrent control.
}
dr.Close();
conn.Close();
OR(INSERT)
cmd = new SqlCommand("insert into New_user values('" +txtfname.Text + "','" + txtlastname.Text + "')", con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
OR(UPDATE)
cmd = new SqlCommand("update user_info set firstname=@firstname,lastname=@lastname where userid=@userid", conn);
cmd.Parameters.Add("userid", txtuid.Text);
cmd.Parameters.Add("firstname",txtfname.Text);
cmd.Parameters.Add("lastname",txtlname.Text);
statuslabel.Text = "Your record updated successfully...";
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
SqlConnection conn = new SqlConnection ("server=360-2009-09; database=all example; Integrated Security=SSPI ;");
SqlCommand cmd;
SqlDataAdapter da;
SqlDataReader dr;
DataSet ds = new DataSet ();
ON Page Load
con.Open ();
da =new SqlDataAdapter("select * from New_user",con);
DataSet ds = new DataSet();
da.Fill (ds,"New_user");
datagrid1.DataSource=ds;
datagrid1.DataBind ();
con.Close ();
OR (SELECT)
cmd = new SqlCommand("select * from user_info where userid=@userid", conn);
int myvalue = Convert.ToInt16(GridView1.SelectedRow);
cmd.Parameters.Add("userid",GridView1.SelectedValue);
dr = cmd.ExecuteReader();
dr.Read();
while(dr.Read())
{
assign values to diffrent control.
}
dr.Close();
conn.Close();
OR(INSERT)
cmd = new SqlCommand("insert into New_user values('" +txtfname.Text + "','" + txtlastname.Text + "')", con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
OR(UPDATE)
cmd = new SqlCommand("update user_info set firstname=@firstname,lastname=@lastname where userid=@userid", conn);
cmd.Parameters.Add("userid", txtuid.Text);
cmd.Parameters.Add("firstname",txtfname.Text);
cmd.Parameters.Add("lastname",txtlname.Text);
statuslabel.Text = "Your record updated successfully...";
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
How to make connection on page.
SqlConnection conn = new SqlConnection("server=myserver;database=allexample;Integrated Security=SSPI;");
SqlCommand cmd;
SqlDataAdapter da;
SqlDataReader dr;
DataSet ds = new DataSet();
ON Page Load
con.Open();
da =new SqlDataAdapter("select * from New_user",con);
DataSet ds = new DataSet();
da.Fill(ds,"New_user");
datagrid1.DataSource=ds;
datagrid1.DataBind();
con.Close();
OR (SELECT)
cmd = new SqlCommand("select * from user_info where userid=@userid", conn);
int myvalue = Convert.ToInt16(GridView1.SelectedRow);
cmd.Parameters.Add("userid",GridView1.SelectedValue);
dr = cmd.ExecuteReader();
dr.Read();
while(dr.Read())
{
assign values to diffrent control.
}
dr.Close();
conn.Close();
OR(INSERT)
cmd = new SqlCommand("insert into New_user values('" +txtfname.Text + "','" + txtlastname.Text + "')", con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
OR(UPDATE)
cmd = new SqlCommand("update user_info set firstname=@firstname,lastname=@lastname where userid=@userid", conn);
cmd.Parameters.Add("userid", txtuid.Text);
cmd.Parameters.Add("firstname",txtfname.Text);
cmd.Parameters.Add("lastname",txtlname.Text);
statuslabel.Text = "Your record updated successfully...";
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
SqlCommand cmd;
SqlDataAdapter da;
SqlDataReader dr;
DataSet ds = new DataSet();
ON Page Load
con.Open();
da =new SqlDataAdapter("select * from New_user",con);
DataSet ds = new DataSet();
da.Fill(ds,"New_user");
datagrid1.DataSource=ds;
datagrid1.DataBind();
con.Close();
OR (SELECT)
cmd = new SqlCommand("select * from user_info where userid=@userid", conn);
int myvalue = Convert.ToInt16(GridView1.SelectedRow);
cmd.Parameters.Add("userid",GridView1.SelectedValue);
dr = cmd.ExecuteReader();
dr.Read();
while(dr.Read())
{
assign values to diffrent control.
}
dr.Close();
conn.Close();
OR(INSERT)
cmd = new SqlCommand("insert into New_user values('" +txtfname.Text + "','" + txtlastname.Text + "')", con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
OR(UPDATE)
cmd = new SqlCommand("update user_info set firstname=@firstname,lastname=@lastname where userid=@userid", conn);
cmd.Parameters.Add("userid", txtuid.Text);
cmd.Parameters.Add("firstname",txtfname.Text);
cmd.Parameters.Add("lastname",txtlname.Text);
statuslabel.Text = "Your record updated successfully...";
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
Subscribe to:
Posts (Atom)
