Sunday, August 27, 2023

How to enable or disable microphone in windows - google meet or another software

 > In the right corner of taskbar

> Right click on speaker settings

>Click on Open sound settigns

>Click on manage sound devices under (Test your microphone)

>Click on microphone (enable or disable)

Wednesday, August 23, 2023

How to create new user - new account in Window 10

 > Go to control panel

> Go to User accounts

>Click on manage another account

>Click on Add a new user in PC setting

>Click on Add some one else on this PC

> Give the name , password and security questions

> If it asks for phone number etc just skip(I don't have the person information and Click on Add a new user without a microsoft account)

Monday, August 7, 2023

Google API - API Key - API code in different languages - How to create api key

 https://github.com/youtube/api-samples


https://developers.google.com/youtube/v3/docs/?apix=true


Go to credentials menu and there you can create API key.

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.";


                            id = 0;

                        }

                    }

                }

            }

        }




 private void btnDelete_Click(object sender, EventArgs e)
        {

            string query = "DELETE FROM STAMP WHERE ID = '" + id + "'";
            if (id == 0)
            {
                MessageBox.Show("Please select stamp from List...");
            }
            else
            {
                var confirmDelete = MessageBox.Show("Are you sure you want to delete?", "Delete", MessageBoxButtons.YesNo);
                if (confirmDelete == DialogResult.Yes)
                {
                    try
                    {

                        MySqlConnection con = new MySqlConnection(conString);
                        MySqlCommand cmd = new MySqlCommand(query, con);
                        con.Open();
                        cmd.ExecuteNonQuery();

                        con.Close();
                        this.BindGrid();
                        MessageBox.Show("Stamp deleted Successfully...");
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.Message);
                    }
                }                
            }
        }     


   private void btnSave_Click(object sender, EventArgs e)
        {
            if (this.validateAllFields())
            {
                if (id == 0)
                {
                    string query = "insert into Stamp ( Rupees, Date, Name, Address, AadharNumber, PhoneNumber, CreatedBy, " +
                        "ModifiedBy) values ('" + txtRupees.Text + "' ,'" + txtDate.Text + "' ,'" + txtName.Text + "'," +
                        " '" + txtAddress.Text + "', '" + txtAadharNumber.Text + "', '" + txtMobileNumber.Text + "', '1'," +
                        " '1');";
                    MySqlConnection conDatabase = new MySqlConnection(conString);
                    MySqlCommand cmd = new MySqlCommand(query, conDatabase);

                    MySqlDataReader myReader;
                    try
                    {
                        conDatabase.Open();
                        myReader = cmd.ExecuteReader();
                        while (myReader.Read())
                        {
                        }

                        this.BindGrid();
                        MessageBox.Show("Stamp Saved Successfully...");

                        this.clearAllFields();
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.Message);
                    }
                }

Sunday, August 6, 2023

How to make rajma recipe

https://www.aajtak.in/lifestyle/food/story/rajma-masala-recipe-how-to-make-rajma-lunch-ideas-pplbsf-1751215-2023-08-05

Android Color to black and white - Mobile color

 >In android mobile, go to settings

>Go to About Device

>Tab on Build number (7 to 8 times)

>Then your developer option will be enable

>Go To Settings

> Click on "Digital Wellbeing and parental controls"

>Click on "bedtime mode" and click on "customize"

>Tab grayscale to on.

Now mobile will be black and white