Category and SubCategory Add

using System;
using System.Collections;
using System.Configuration;
using System.Data;
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;

public partial class Admin_SubCategoryManagement : System.Web.UI.Page
{
    DAL dal = new DAL();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Request["i"] != null)
        {
            if (Request["i"].ToString() == "1")
            {
                td_gridder.Visible = false;

                td_editter.Visible = true;
            }
            else if (Request["i"].ToString() == "2")
            {
                td_gridder.Visible = true;

                td_editter.Visible = false;
            }
        }
        else
        {
            Response.Redirect("Default.aspx");
        }


        if (!IsPostBack)
        {
            dal.FillCombo(ddl_Category, "ProductCategory_Master_Sp 's'", "Category", "PK_ID", "--select Category--", 0);
        }

        if (ViewState["PK_ID"] != null)
        {
            btn_edit.Visible = true;
            btn_save.Visible = false;
        }
        else
        {
            btn_edit.Visible = false;
            btn_save.Visible = true;
        }
    }

    protected void ddl_Category_Indexchanged(object sender, EventArgs e)
    {
        if (ddl_Category.SelectedIndex != 0)
        {
            dal.FillGrid(grd_News, "ProductSubCategroy_Master_Sp 's','','" + ddl_Category.SelectedValue + "'");
        }
        else
        {
            grd_News.DataSource = null;
            grd_News.DataBind();
        }
    }


    protected void btn_save_Click(object sender, EventArgs e)
    {
        if (ddl_Category.SelectedIndex != 0)
        {
            dal.PutData("ProductSubCategroy_Master_Sp 'i','','" + ddl_Category.SelectedValue + "','" + txt_title.Text + "'");
            dal.FillGrid(grd_News, "ProductSubCategroy_Master_Sp 's','','" + ddl_Category.SelectedValue + "'");
}
}
protected void btn_edit_Click(object sender, EventArgs e)
    {
        dal.PutData("ProductSubCategroy_Master_Sp 'u','" + ViewState["PK_ID"] + "','" + ddl_Category.SelectedValue + "','" + txt_title.Text + "'");
        dal.FillGrid(grd_News, "ProductSubCategroy_Master_Sp 's','','" + ddl_Category.SelectedValue + "'");
        ControlClear();
        btn_edit.Visible = false;
        btn_save.Visible = true;


        td_gridder.Visible = true;

        td_editter.Visible = false;
    }

    private void ControlClear()
    {

        txt_title.Text = string.Empty;

        ViewState["PK_ID"] = null;
    }
    protected void btn_cancel_Click(object sender, EventArgs e)
    {
        ControlClear();
    }
    protected void btn_grd_delete_click(object sender, CommandEventArgs e)
    {

        dal.PutData("ProductSubCategroy_Master_Sp 'd','" + e.CommandArgument.ToString() + "'");
  dal.FillGrid(grd_News, "ProductSubCategroy_Master_Sp 's','','" + ddl_Category.SelectedValue + "'");
    }
    protected void btn_grd_edit_click(object sender, CommandEventArgs e)
    {
        ViewState["PK_ID"] = e.CommandArgument.ToString();
        DataTable dt = new DataTable();
        dt = dal.GetDataTable("ProductSubCategroy_Master_Sp 'e','" + ViewState["PK_ID"].ToString() + "'");
        txt_title.Text = dt.Rows[0]["SubCategory"].ToString();


        btn_edit.Visible = true;
        btn_save.Visible = false;



        td_gridder.Visible = false;

        td_editter.Visible = true;
    }
}

E-Mail Send - Resevie C# Code

using System;
using System.Windows.Forms;
using System.Net.Mail;

namespace WindowsApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                MailMessage mail = new MailMessage();
                SmtpClient SmtpServer = new SmtpClient("smtp.gmail.com");

                mail.From = new MailAddress("your_email_address@gmail.com");
                mail.To.Add("to_address@mfc.ae");
                mail.Subject = "Test Mail";
                mail.Body = "This is for testing SMTP mail from GMAIL";

                SmtpServer.Port = 587;
                SmtpServer.Credentials = new System.Net.NetworkCredential("username", "password");
                SmtpServer.EnableSsl = true;

                SmtpServer.Send(mail);
                MessageBox.Show("mail Send");
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
        }
    }
}

Send Email in C# Code

// create mail message object
MailMessage mail = new MailMessage();
mail.From = "";           // put the from address here
mail.To = "";             // put to address here
mail.Subject = "";        // put subject here 
mail.Body = "";           // put body of email here
SmtpMail.SmtpServer = ""; // put smtp server you will use here 
// and then send the mail
SmtpMail.Send(mail);

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

String server = "127.0.0.1";
 
private void btnSend_Click(object sender, System.EventArgs e)
{
 MailAddress to = new MailAddress("admin@.mail.adr");
 MailAddress from = new MailAddress(txtFrom.Text);
 MailMessage message = new MailMessage(from, to);  
 
 message.Subject = txtSubject.Text;
 message.Body = @"" txtContent.Value;

 SmtpClient client = new SmtpClient(server);
 
 try
 {
 client.Send(message);
  }
 catch (Exception ex)
 {
 throw new Exception(ex.Message, ex);
 }
}

Other Example 

using System;
using System.Text;
using System.Net.Mail;
using System.Net;

namespace TestingConsole
{
  class Program
  {
      static void Main(string[] args)
      {
          try
          {
              string to = "to@domain.com";
              string from = "from@gmail.com";
              string from_pwd = "mypassword";
              string subject = "Sample Mail testing";
              string body = "Wow this is testing body";
              MailMessage mM = new MailMessage();
              mM.From = new MailAddress(from);
              mM.To.Add(to);
              mM.Subject = subject;
              mM.Body = body;
              mM.IsBodyHtml = false;
              mM.Priority = MailPriority.High;
              SmtpClient sC = new SmtpClient("smtp.gmail.com");
              sC.Port = 587;
              sC.Credentials = new NetworkCredential(from,from_pwd);
              sC.EnableSsl = true;
              sC.Send(mM);
          }
          catch (Exception e)
          {
              Console.WriteLine(e.Message + " " + e.StackTrace);
          }
      }
  }
}

Out Of Date Change UserName and Password

PasswordExpires, Part I 

public class PasswordExpires
{
  DomainPolicy policy;
  
  const int UF_DONT_EXPIRE_PASSWD = 0x10000;
 
  public PasswordExpires()
  {
    //get our current domain policy
    Domain domain = Domain.GetCurrentDomain();
    DirectoryEntry root = domain.GetDirectoryEntry();
  
    using (domain)
    using (root)
    {
      this.policy = new DomainPolicy(root);
    }
  }

 PasswordExpires, Part II

public DateTime GetExpiration(DirectoryEntry user)
  {
    int flags = 
      (int)user.Properties["userAccountControl"][0];
 
    //check to see if password is set to expire
    if(Convert.ToBoolean(flags & UF_DONT_EXPIRE_PASSWD))
    {
      //the user’s password will never expire
      return DateTime.MaxValue;
    }
 
    long ticks = GetInt64(user, "pwdLastSet");
 
    //user must change password at next login
    if (ticks == 0)
      return DateTime.MinValue;
 
    //password has never been set
    if (ticks == -1)
    {
      throw new InvalidOperationException(
        "User does not have a password"
        );
    }
 
    //get when the user last set their password;
    DateTime pwdLastSet = DateTime.FromFileTime(
      ticks
      );
 
    //use our policy class to determine when
    //it will expire
    return pwdLastSet.Add(
      this.policy.MaxPasswordAge
      );
  } 

 PasswordExpires, Part III 

public TimeSpan GetTimeLeft(DirectoryEntry user)
  {
    DateTime willExpire = GetExpiration(user);
 
    if (willExpire == DateTime.MaxValue)
      return TimeSpan.MaxValue;
 
    if (willExpire == DateTime.MinValue)
      return TimeSpan.MinValue;
 
    if (willExpire.CompareTo(DateTime.Now) > 0)
    {
      //the password has not expired
      //(pwdLast + MaxPwdAge)- Now = Time Left
      return willExpire.Subtract(DateTime.Now);
    }
 
    //the password has already expired
    return TimeSpan.MinValue;
  }
  
  private Int64 GetInt64(DirectoryEntry entry, string attr)
  {
    //we will use the marshaling behavior of
    //the searcher
    DirectorySearcher ds = new DirectorySearcher(
      entry,
      String.Format("({0}=*)", attr),
      new string[] { attr },
      SearchScope.Base
      );
      
    SearchResult sr = ds.FindOne();
    
    if (sr != null)
    {
      if (sr.Properties.Contains(attr))
      {
        return (Int64)sr.Properties[attr][0];
      }
    }
    return -1;
  }

Checking Password Expiration

string adsPath = "LDAP://CN=User1,OU=Users,DC=domain,DC=com";
 
DirectoryEntry user = new DirectoryEntry(
  adsPath,
  null,
  null,
  AuthenticationTypes.Secure
  );
 
string attrib = "msDS-User-Account-Control-Computed";
 
using (user)
{
  user.RefreshCache(new string[] { attrib });
 
  int flags = (int)user.Properties[attrib].Value
    & (int)AdsUserFlags.PasswordExpired);
 
  if (Convert.ToBoolean(flags)
  {
    //password has expired
    Console.WriteLine("Expired");
  }
}

Login Password Case-Sensitive

 private void btnlogin_Click(object sender, EventArgs e)
        {
            login();
        }
        private void ClearFields()
        {
            txtusername.Text = String.Empty;
            txtpwd.Text = String.Empty;
        }

        private void btncancel_Click(object sender, EventArgs e)
        {
            this.Close();
        }
        private void txtpwd_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyValue == 13)
            {
                login();
            }
        }
        private void login()
        {
            try
            {
                ConnectionClass l_ConnectionClass = new ConnectionClass();
                DataSet l_UserDataSet = l_ConnectionClass.FetchDataInDataSet("select * from tbluserlogin where userName = '" + txtusername.Text.ToLower().Trim() + "' and userPwd = '" + txtpwd.Text.Trim() + "'");
                if (l_UserDataSet.Tables[0].Rows.Count > 0)
                {
                    PublicVariables.CheckLoginFlag = true;
                    PublicVariables.OSUserID = Convert.ToInt16(l_UserDataSet.Tables[0].Rows[0]["userId"]);
                    PublicVariables.UserRole = l_UserDataSet.Tables[0].Rows[0]["userRole"].ToString();
                    DateTime getdatefrm = l_ConnectionClass.getlogouttime();
                    DateTime datenow = DateTime.Now;
                    if ((getdatefrm.AddMinutes(0) > datenow) && (getdatefrm != DateTime.MinValue))
                    {
                        MessageBox.Show("please wait");
                        ClearFields();
                        PublicVariables.CheckLoginFlag = false;                  
                    }
                    else
                    {
                        l_ConnectionClass.updateuserlogin();
                        Close();
                        this.Hide();
                    }
                }
                else
                {
                    MessageBox.Show("Login Failed !!!!", "Error", MessageBoxButtons.OK);
                    PublicVariables.CheckLoginFlag = false;
                    txtusername.Text = "";
                    txtpwd.Text = "";
                    txtusername.Focus();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Connection Failed. Plz Check your Network Cable Connection", "Error", MessageBoxButtons.OK);
            }
        }
        private void txtusername_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyValue == 13)
            {
                txtpwd.Focus();
            }
        }

Sql Connection String Examples

Using C#:

using System.Data.SqlClient;
...
SqlConnection oSQLConn = new SqlConnection();
oSQLConn.ConnectionString = "Data Source=(local);" +
                            "Initial Catalog=mySQLServerDBName;" +
                            "Integrated Security=yes";
oSQLConn.Open(); 

If connection to a remote server (via IP address):

oSQLConn.ConnectionString = "Network Library=DBMSSOCN;" & _ "Data Source=xxx.xxx.xxx.xxx,1433;" & _ "Initial Catalog=mySQLServerDBName;" & _ "User ID=myUsername;" & _ "Password=myPassword" Where: 
- "Network Library=DBMSSOCN" tells SqlConnection to use TCP/IP Q238949
- xxx.xxx.xxx.xxx is an IP address.  
- 1433 is the default port number for SQL Server.  Q269882 and Q287932
- You can also add "Encrypt=yes" for encryption 

Connection String Examples

A data connection includes a connection string that is typically provided by the owner of the external data source. The following table lists examples of connections strings for different types of external data sources.

Data source	Example	Description
SQL Server database on the local server	data source="(local)";initial catalog=AdventureWorks	Set data source type to SQL Server.
SQL Server instance database	Data Source=localhost\MSSQL10_50.InstanceName; Initial Catalog= AdventureWorks	Set data source type to SQL Server.
SQL Server Express database	Data Source=localhost\MSSQL10_50.SQLEXPRESS; Initial Catalog= AdventureWorks	Set data source type to SQL Server.
Analysis Services database on the local server	data source=localhost;initial catalog=Adventure Works DW	Set data source type to SQL Server Analysis Services.
SharePoint List	data source=http://MySharePointWeb/MySharePointSite/	Set data source type to SharePoint List.
SQL Server 2000 Analysis Services server	provider=MSOLAP.2;data source=;initial catalog=FoodMart 2000	Set the data source type to OLE DB Provider for OLAP Services 8.0. You can achieve a faster connection to SQL Server 2000 Analysis Services data sources if you set the ConnectTo property to 8.0. To set this property, use the Connection Properties dialog box, Advanced Properties tab.
Report Models	Not applicable.	You do not need a connection string for a report model. In Report Builder, browse to the report server and select the .smdl file that is the report model.
Oracle server	data source=myserver	Set the data source type to Oracle. The Oracle client tools must be installed on the Report Builder computer and on the report server.
SAP NetWeaver BI data source	DataSource=http://mySAPNetWeaverBIServer:8000/sap/bw/xml/soap/xmla	Set the data source type to SAP NetWeaver BI.
Hyperion Essbase data source	Data Source=http://localhost:13080/aps/XMLA; Initial Catalog=Sample	Set the data source type to Hyperion Essbase.
Teradata data source	data source=...;	Set the data source type to Teradata. The connection string is an Internet Protocol (IP) address in the form of four fields, where each field can be from one to three digits.
Teradata data source	Database=; data source=N>...NN>;Use X Views=False;Restrict to Default Database=True	Set the data source type to Teradata, similar to the previous example. Only use the default database that is specified in the Database tag, and do not automatically discover data relationships.
XML data source, Web service	data source=http://adventure-works.com/results.aspx	Set the data source type to XML. The connection string is a URL for a web service that supports Web Services Definition Language (WSDL).
XML data source, XML document	http://localhost/XML/Customers.xml	Set the data source type to XML. The connection string is a URL to the XML document.
XML data source, embedded XML document	Empty	Set the data source type to XML. The XML data is embedded in the report definition.

Serverfault

http://serverfault.com

Date Select On Show DataGridView

  string constring = "Data Source=localhost\\SQLEXPRESS;Initial Catalog=bar_db;Integrated Security=True";
            SqlConnection con = new SqlConnection(constring);
            DateTime dt = new DateTime();
            dt = Convert.ToDateTime(dateTimePicker1.Value.ToShortDateString());
            SqlCommand cmd = new SqlCommand();
            string sqlqry = "select mbrchrg AS MemberCharge,costumechrg AS CostumerCharge,Date from swimpool where Date = '" + dt + "'";
            dataGridView1.DataSource = "";
            cmd.CommandText = sqlqry;
            cmd.CommandType = CommandType.Text;
            cmd.Connection = con;
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            da.SelectCommand = cmd;
            DataSet ds = new DataSet();
            da.Fill(ds, "swimpool");
            dataGridView1.DataSource = ds.Tables["swimpool"].DefaultView;




-------------------------------------------------------------------------
namespace HotelManagement
{
    public partial class User_Record : Form
    {
        Dbclass db = new Dbclass();
        string common;
        public User_Record()
        {
            InitializeComponent();
        }

        private void btnExit_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void User_Record_Load(object sender, EventArgs e)
        {
            DataTable dt = new DataTable();

            string str = "select Addmminisator,User_Id,User_Type,User_Name,User_Password from user_master";
            dt = db.FindFun(str);
            grduser_record.DataSource  = dt;
            totalrecord.Text = Convert.ToInt32(grduser_record.Rows.Count - 1).ToString();

        }

        private void btnpreview_Click(object sender, EventArgs e)
        {
            Crstluser_master use = new Crstluser_master();
            Frmviewr view = new Frmviewr();
            DataTable dt = new DataTable();
            string str = " Select * from user_Master";
            dt = db.FindFun(str);

            use.SetDataSource(dt);
            view.crstlviewer.ReportSource = use;
            view.Show();
        }
    }
}