Monday, August 7, 2023

MYSQL insert update and delete in asp.net c# - with connection string

   private string conString = @"server=localhost;database=stamppaper;port=3306;username=root;password=;SslMode=none";


private void BindGrid()

        {

            using (MySqlConnection con = new MySqlConnection(conString))

            {

                using (MySqlCommand cmd = new MySqlCommand("SELECT * FROM Stamp", con))

                {

                    cmd.CommandType = CommandType.Text;

                    using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd))

                    {

                        using (DataTable dt = new DataTable())

                        {

                            sda.Fill(dt);

                            grdStamp.DataSource = dt;


                            grdStamp.Columns[0].HeaderCell.Value = "Sr. No.";

Monday, July 10, 2023

Advanced LINQ Query Techniques in C# with code samples

 https://efficientuser.com/2023/05/09/advanced-linq-query-techniques-in-c-with-code-samples/

How to open vdf file (in android) in excel - How to save contacts in android phone - Import or export contacts in android

------- First way to export or  save ---------------------

1) open contacts app in android phone by searching "contacts' in apps

2) Now go to organise section and click  "Export to file"

3) And click on save. (with file extension .vcf)

------------------++  Second way to export or saave ------------

4) Or you can go to Contacts.google.com and click  on  export button (up arrow left to three dots button)

---------For import --------

1) open contacts app in android phone by searching "contacts' in apps

2) Now go to organise section and click  "Import from file"

3) Click on your email id shown below "save imported contacts to"


 https://www.spreadsheetweb.com/how-to-open-vcf-format-in-excel/