Android Tutorials: Connect MySQL Database from android: Retrieve Database from mysql and Diplaying in Dynamic Table using android To download Full program click here I Installed WAMP...
Thursday 26 June 2014
Tuesday 31 July 2012
Password check in asp.net
string
strConnection
= ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
string
strSelect
= "SELECT COUNT(*) FROM Users WHERE Username = @Username AND Password
= @Password";
SqlConnection
con = new
SqlConnection(strConnection);
SqlCommand
cmd = new
SqlCommand();
cmd.Connection
= con;
cmd.CommandType
= CommandType.Text;
cmd.CommandText
= strSelect;
SqlParameter
username = new
SqlParameter("@Username", SqlDbType.VarChar,
50);
username.Value
= txtUserName.Text.Trim().ToString();
cmd.Parameters.Add(username);
SqlParameter
password = new
SqlParameter("@Password", SqlDbType.VarChar,
50);
password.Value
= txtPassword.Text.Trim().ToString();
cmd.Parameters.Add(password);
con.Open();
int
result = (Int32)cmd.ExecuteScalar();
con.Close();
if
(result
>= 1)
Response.Redirect("Default.aspx");
else
lblMsg.Text
= "Incorrect Username or Password";
preview button
printDocument1.DefaultPageSettings.PaperSize = new System.Drawing.Printing.PaperSize(printDocument1.DocumentName, 825, 1100);//Paper Size
this.printPreviewDialog1.Document = this.printDocument1;
printPreviewDialog1.ShowDialog();
PrintDialog printDialog = new PrintDialog();
printDialog.Document = printDocument1;
printDialog.UseEXDialog = true;
Decimal Function
public string deci(double d)
{
try
{
if (d - (int)d == 0.0)
{
ss = d.ToString() + ".00";
}
else if ((d - (int)d) == 0.1 || (d - (int)d) == 0.2 || (d - (int)d) == 0.3 || (d - (int)d) == 0.4 || (d - (int)d) == 0.5 || (d - (int)d) == 0.6 || (d - (int)d) == 0.7 || (d - (int)d) == 0.8 || (d - (int)d) == 0.9)
{
ss = d.ToString() + "0";
}
else
{
for (int i = 0; i < Convert.ToString(d).Length; i++)
{
if (Convert.ToString(d).Substring(i, 1) == ".")
{
ss = Convert.ToString(d).Substring(0, i + 3);
break;
}
}
}
return ss;
}
catch
{
return d.ToString() + "0";
}
compoBox value one by one Print
do
{
if (cl == cmbvattype.Items.Count)
{
cl = cmbvattype.Items.Count - 1;
}
y = y + 60;
string vat = cmbvattype.Items[cl].ToString();
e.Graphics.DrawString(vat, new Font("Times New Roman", 13, FontStyle.Underline), Brushes.Black, 80, y - 30);
for (int r = 0; r < dataGridView1.Rows.Count; r++)
{
if (vat == dataGridView1.Rows[r].Cells[1].Value.ToString())
{
if (rc == dataGridView1.Rows.Count)
{
break;
}
---------------
---
--
--
---
}
while (cl < cmbvattype.Items.Count);
Connection in perid
{
class connection
{
OleDbConnection con, con1, con2;
public OleDbConnection connect_remote()
{
con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Pathname:\folder1\folder2\DynaCon_db.mdb;Jet OLEDB:Database Password=123;");
return con;
}
string get()
{
con2 = connect_remote();
con2.Open();
OleDbCommand cmd = new OleDbCommand("Select path from login", con2);
string t = cmd.ExecuteScalar().ToString();
con2.Close();
return t;
}
public OleDbConnection connect()
{
con1 = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" + get() + "';Jet OLEDB:Database Password=123;");
return con1;
}
}
}
Friday 20 July 2012
MS Access Connection class in .Net
class connection
{
OleDbConnection con;
public OleDbConnection connect()
{
con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\folder_name\db_name.mdb;Jet OLEDB:Database Password=123;");
return con;
}
}
Wednesday 18 July 2012
Enter Only Values In Textbox
if (!(char.IsDigit(e.KeyChar) || char.IsControl(e.KeyChar) || (e.KeyChar == (char)45) || char.IsPunctuation(e.KeyChar)))
{
e.Handled = true;
MessageBox.Show("Enter Only Number", "Only Number");
}
Export to Excel
private void btnexport_Click(object sender, EventArgs e)
{
try
{
SaveFileDialog saveFileDialog1 = new SaveFileDialog();
saveFileDialog1.Filter = "Execl files (*.xls)|*.xls";
saveFileDialog1.FilterIndex = 0;
saveFileDialog1.DefaultExt = ".xls";
saveFileDialog1.RestoreDirectory = true;
saveFileDialog1.CreatePrompt = true;
saveFileDialog1.Title = "Export Excel File To";
Microsoft.Office.Interop.Excel.Application ExcelApp = new Microsoft.Office.Interop.Excel.Application();
object misValue = System.Reflection.Missing.Value;
Excel.Application xlApp = new Excel.ApplicationClass();
Excel.Workbook xlWorkBook = xlApp.Workbooks.Add(misValue);
Excel.Worksheet xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
for (int i = 1; i < dataGridView1.Columns.Count + 1; i++)
{
xlWorkSheet.Cells[1, i] = dataGridView1.Columns[i - 1].HeaderText;
}
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
for (int j = 0; j < dataGridView1.Columns.Count; j++)
{
xlWorkSheet.Cells[i + 2, j + 1] = Convert.ToString(dataGridView1.Rows[i].Cells[j].Value);
}
}
//Excel.ChartObjects xlCharts = (Excel.ChartObjects)xlWorkSheet.ChartObjects(Type.Missing);
//Excel.ChartObject xlChart = (Excel.ChartObject)xlCharts.Add(300, 100, 300, 300);
//Excel.Chart chartPage = xlChart.Chart;
////set the source data and the chart type.
//Excel.Range chartRange = xlWorkSheet.get_Range("B2", "D13");
//chartPage.SetSourceData(chartRange, misValue);
//chartPage.ChartType = Excel.XlChartType.xlBarClustered;
saveFileDialog1.ShowDialog();
xlWorkBook.SaveAs(saveFileDialog1.FileName, Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);
xlWorkBook.Close(true, misValue, misValue);
if (MessageBox.Show("Are u Want to open the file", "Xls File Open", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
System.Diagnostics.Process.Start(saveFileDialog1.FileName);
}
releaseObject(xlWorkSheet);
releaseObject(xlWorkBook);
releaseObject(ExcelApp);
// MessageBox.Show("The Save button was clicked or the Enter key was pressed" + "\nThe file would have been saved as " + this.saveFileDialog1.FileName);
}
catch
{ }
}
serial Generator in Gridview
void serialno_generator()
{
try
{
int c = 1;
int j = int.Parse(dataGridView1.Rows.Count.ToString());
for (int k = 0; k < j; k++)
{
dataGridView1.Rows[k].Cells[0].Value = c.ToString();
c = c + 1;
}
}
catch (Exception eserial)
{
MessageBox.Show(eserial.Message, "Serial No");
}
Monday 2 July 2012
SaveDialog Box
private void BackUp_Load(object sender, EventArgs e)
{
this.textBox1.ReadOnly = false;
spath = "D:/bssdata/bss/FileName.mdb";
textBox1.Text = spath;
}
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Personal);
saveFileDialog.Filter = "Database Files (*.mdb)|*.mdb|All Files (*.*)|*.*";
if (saveFileDialog.ShowDialog(this) == DialogResult.OK)
{
path = saveFileDialog.FileName;
}
if (File.Exists(path))
{
File.Delete(path);
File.Copy(spath, path);
if (MessageBox.Show("The Database File Backup has taken", "Backup Process", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1) == DialogResult.OK)
{
this.Close();
}
}
else
{
File.Copy(spath, path);
MessageBox.Show("The Database File Backup has taken", "Backup", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
Friday 29 June 2012
Enter only 10 Numbers in Textbox
int a=convert.ToInt32(txtnum.text);
if(a>10)
{
MessageBox.show("Only 10 Numbers");
string a1=txtnum.text;
string b=a.substring(0,10);
txtnum.Text=b.Tostring();
}
if(a>10)
{
MessageBox.show("Only 10 Numbers");
string a1=txtnum.text;
string b=a.substring(0,10);
txtnum.Text=b.Tostring();
}
Auto Complete List Values in comboBox
DataTable t = new DataTable();
t.Columns.Add("ID", typeof(int)
t.Columns.Add("Display", typeof(string));
for (int i = 1; i <= 2000; i++)
{
t.Rows.Add(i, i.ToString("N0"));
}
comboBox2.DataSource = t;
comboBox2.ValueMember = "ID";
comboBox2.DisplayMember = "Display";
comboBox2.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
comboBox2.AutoCompleteSource = AutoCompleteSource.ListItems;
Thursday 21 June 2012
Autocomplete Textbox in C#
public partial
class Search_Candidate : Form
{
OleDbDataReader reader;
OleDbCommand cmd;
OleDbConnection con;
AutoCompleteStringCollection
autoComplete = new AutoCompleteStringCollection();
public Search_Candidate()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
string strcon = "select * from
table_name where field_name LIKE '" + textBox1.Text +
"'&'%'";
cmd = new
OleDbCommand(strcon, con);
reader =
cmd.ExecuteReader();
if (reader.HasRows == true)
{
while (reader.Read())
{
autoComplete.Add(reader[1].ToString());
}
}
textBox1.AutoCompleteMode =
AutoCompleteMode.SuggestAppend;
textBox1.AutoCompleteSource
= AutoCompleteSource.CustomSource;
textBox1.AutoCompleteCustomSource = autoComplete;
}
}
Subscribe to:
Posts (Atom)