run application in as administrator in c sharp

Run application in as administrator in c sharp

     start your application in administrator permissions using c sharp
 
using System.Diagnostics;
using System.Security.Permissions;
using System.Threading;
using System.Security.Principal;

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

       private void Form1_Load(object sender, EventArgs e)
        {
           button1.Text =
"Run Firefox with administrator permission";
        }
      private void button1_Click(object sender, EventArgs e)
       {
          MyMethod();
        }

      public void MyMethod()
       {
          ProcessStartInfo info = new ProcessStartInfo(@"C:\Program Files\Mozilla Firefox 13\firefox.exe");
         if (System.Environment.OSVersion.Version.Major >= 6)
              {
                  info.Verb =
"runas";
              }             
           Process p = Process.Start(info);

        }
     }
}


Output  Image
 
By:VidyaGyan
 

MySql database Connection in C Sharp

 

MySql database connection in c sharp

this is mySql database connectivity using System.Data.Odbc; 

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.Odbc;

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

private void button1_Click(object sender, EventArgs e)
{
try
{
string MyConString = "DRIVER={MySQL ODBC 3.51 Driver};" +"SERVER=www.BombayAccessories.com;" +"DATABASE=database1;" +"UID=Bombay;" +"PASSWORD=Accessories;" +"OPTION=3";
OdbcConnection MyConnection = new OdbcConnection(MyConString);
OdbcDataAdapter sda = new OdbcDataAdapter("select * from Products", MyConnection);
DataTable dt=new DataTable();
sda.Fill(dt);
dataGridView1.DataSource=dt;

}
catch (Exception ei)
{
MessageBox.Show(ei.Message);
}
}
}
}


OutPut Image:
 
 
By: VidyaGyan
 

CODING FOR WEB SERVICES FOR PAYMENT


CODING FOR WEB SERVICES FOR PAYMENT

using System.Web.Services;
using System.Data;
using System.Data.SqlClient;
...
/// <summary>
/// Summary description for PaymentService
/// </summary>
[WebService(Namespace = "http://tempuri.org/")]
[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 PaymentService : System.Web.Services.WebService {
SqlConnection con;
public PaymentService () {

//Uncomment the following line if using designed components
//InitializeComponent();
}

[WebMethod]
public bool checkcard(int cno, int pno)
{
con=new SqlConnection(@"Data Source=.\SQLEXPRESS;User Instance=true;AttachDbFilename=C:\Users\radiant\Documents\Visual Studio 2010\WebSites\WebSite4\App_Data\DB.mdf;Integrated Security=SSPI");
con.Open();
string qry = "select * from cardpay where cardno=" + cno+"and pinno="+pno;
SqlDataAdapter da = new SqlDataAdapter(qry, con);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count == 0)
return false;
else
return true;

}

}