Rohit Damodaran 100* (133) | Pondicherry v Karnataka- Ranji Trophy 21-22 #RohitDamodaran #cricket

Rohit Damodaran's impressive century for Pondicherry against Karnataka in the 2021-22 Ranji Trophy was a standout performance in the match. Batting first, Pondicherry posted a total of 270, with Damodaran leading the charge with his brilliant knock of 133.

Damodaran's innings was a mix of patience, determination and aggressive stroke play. He started cautiously, taking his time to get set on a pitch that offered some assistance to the bowlers. But once he got his eye in, he unleashed an array of strokes that left the Karnataka bowlers gasping for breath.

The right-handed opener's innings was punctuated with some delightful shots, including crisp drives through the off-side, flicks off his pads and some powerful cuts through the point and cover regions. He was particularly severe on the spinners, dancing down the track and lofting them over long-off and long-on with ease.

Damodaran's century came off just 153 balls and included 16 fours and 2 sixes. He was finally dismissed by leg-spinner Shreyas Gopal, caught by Abhimanyu Mithun at mid-off, but by then he had done enough to give his team a solid platform.

Despite his heroics, Pondicherry eventually lost the match by an innings and 20 runs. But Damodaran's century will be remembered as one of the highlights of the game, and a testament to his skill and temperament at the highest level of domestic cricket in India.

Overall, Rohit Damodaran's century was a remarkable display of batting that showcased his talent and potential as a top-order batsman. His ability to adapt to different conditions and situations, and his willingness to take on the bowlers with confidence and aggression, bodes well for his future in the sport.

link : https://www.cricbuzz.com/live-cricket-scorecard/45376/kar-vs-pdc-elite-group-c-ranji-trophy-2021-22

 

Inductance Calculation by Rohit Damodaran

 

Reviewed by Rohit Damodaran

{தமிழ்} C# in Tamil | OOPs Concept | Part-10 #List, Model, foreach, lambda expression

{தமிழ்} C# Advanced Tutorial in Tamil | OOPs Concept | Part-10 #List, Model, foreach, lambda expression c# #Tamil #TamilTutorials #List #Model #lambda expression #foreach In this video we will learn about OOPS Concept in C# Class Anto Sujesh C# inheritance in tamil OOPS Concept inheritance in tamil oops inheritance in tamil inheritance in tamil C# inheritance in tamil Csharp inheritance in tamil Object Oriented Programming (OOPs) Concept in C# Tamil follow me on FB : https://www.facebook.com/Antotamiltutorials/ Me on FB : https://www.facebook.com/antosujesh

asas

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.IO;
using System.Data.SqlClient;

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

        public DataTable dataTable1()
        {
            DataTable ds = new DataTable();
            SqlConnection con = new SqlConnection(@"Data Source=DESKTOP-6073CLJ\SQLEXPRESS;Initial Catalog=MVC;Integrated Security=True");
            SqlDataAdapter adp = new SqlDataAdapter("select count(*) as total_count from Employees", con);
            DataTable dt = new DataTable();
            adp.Fill(dt);
            return ds;
        }


        private void button1_Click(object sender, EventArgs e)
        {
            DataTable dtt = dataTable1();
            string NewconnectionString = @"Data Source=DESKTOP-6073CLJ\SQLEXPRESS;Initial Catalog=MVC;Integrated Security=True";
           // StreamWriter CsvfileWriter = new StreamWriter(@"D:\testfile.csv");
            string sqlselectQuery = "select top 10* from Employees ";
            SqlCommand sqlcmd = new SqlCommand();

            SqlConnection spContentConn = new SqlConnection(NewconnectionString);
            sqlcmd.Connection = spContentConn;
            sqlcmd.CommandTimeout = 0;
            sqlcmd.CommandType = CommandType.Text;
            sqlcmd.CommandText = sqlselectQuery;
            spContentConn.Open();
         
            using (spContentConn)
            {
                using (SqlDataReader sdr = sqlcmd.ExecuteReader())
                using (DataTable dt = new DataTable())
                {
                    dt.Load(sdr);
                    Console.WriteLine(dt.Rows.Count);  //check its filled

                    //Create the Streamwriter

                    StreamWriter CsvfileWriter = new StreamWriter(@"D:\testfile.csv");

                    using (CsvfileWriter)
                    {

                        //Use sting join methods to attach and write the columns
                        CsvfileWriter.WriteLine(string.Join(",",
                        dt.Columns.Cast<DataColumn>().Select(csvfile =>
                        csvfile.ColumnName)));

                        foreach (DataRow row in dt.Rows)
                        {
                            //Use sting join methods to attach and write and iterate
                            //through the rows of the datatable
                            CsvfileWriter.WriteLine(string.Join(",", row.ItemArray));
                        }
                        //Summary
                     
                        int cint = dtt.Rows.Count;
                        CsvfileWriter.WriteLine(string.Join(",",
                        dtt.Columns.Cast<DataColumn>().Select(csvfile =>
                        csvfile.ColumnName)));

                        foreach (DataRow row1 in dtt.Rows)
                        {
                            //Use sting join methods to attach and write and iterate
                            //through the rows of the datatable
                            CsvfileWriter.WriteLine(string.Join(",", row1.ItemArray));
                        }
                    }
                }
                //using (CsvfileWriter)
                //{
                //    //This Block of code for getting the Table Headers
                //    DataTable Tablecolumns = new DataTable();

                //    for (int i = 0; i < sdr.FieldCount; i++)
                //    {
                //        Tablecolumns.Columns.Add(sdr.GetName(i));
                //    }
                //    CsvfileWriter.WriteLine(string.Join(",", Tablecolumns.Columns.Cast<DataColumn>().Select(csvfile => csvfile.ColumnName)));
                //    //This block of code for getting the Table Headers
                //    int count = sdr.Cast<object>().Count();
                //    while (sdr.Read())
                //        //based on your Table columns you can increase and decrese columns


                //    //  CsvfileWriter.WriteLine(sdr[0].ToString() + "," + sdr[1].ToString() + "," + sdr[2].ToString() + "," + sdr[3].ToString() + "," + sdr[4] + "," + sdr[5].ToString() + "," + sdr[6].ToString() + "," + sdr[7].ToString() + "," + sdr[8].ToString() + "," + sdr[9].ToString() + "," + sdr[10].ToString() + "," + sdr[11].ToString() + ",");
                //    for (int j = 0; j < count; j++)
                //    {
                //        if (j > 0) CsvfileWriter.Write(",");
                //        CsvfileWriter.Write(sdr[j].ToString());
                //    }
                //}
            }
     
        }

        private void button2_Click(object sender, EventArgs e)
        {
            for (int i = 0; i < 100000; i++)
            {
                string sql = " insert into Employees (col1,col2,col3,col4,col5,col6,col7,col8,col9,col10,col11) values('fuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisg','fuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisg','fuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisg','fuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisg','fuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisg','fuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisg','fuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisg','fuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisg','fuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisg','fuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisg','fuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisgfuisgfgdsgfigisg') ";
                SqlConnection connection = new SqlConnection(@"Data Source=DESKTOP-6073CLJ\SQLEXPRESS;Initial Catalog=MVC;Integrated Security=True");
                SqlCommand cmd = new SqlCommand(sql, connection);
                cmd.CommandType = CommandType.Text;
                connection.Open();
                cmd.ExecuteNonQuery();
                connection.Close();
            }
        }
   
    }
}

How to create Store Procedure with multiple parameter

CREATE or ALTER  PROCEDURE test_sp @Employeename nvarchar(100)
AS
DECLARE @emp nvarchar(100)
SET @emp = (SELECT  Employeename   FROM Employees where Employeename=@Employeename)
IF @emp IS NULL
 PRINT 'RUN SP'
ELSE
 PRINT 'FOUND'
 select @emp


GO;



exec test_sp 'test1'

loading multiple tables within dataset using store producer

CREATE PROCEDURE testSP
AS
BEGIN
 SELECT CategoryID,CategoryName,Description FROM Categories 
 SELECT SupplierID,CompanyName,ContactName FROM Suppliers
 SELECT ProductID,ProductName,CategoryID,SupplierID FROM Products
END
GO

C#

using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["NorthwindNewConnectionString"].ToString()))
{
 SqlDataAdapter da = new SqlDataAdapter("testSP",conn);
 da.SelectCommand.CommandType = CommandType.StoredProcedure;

 DataSet ds = new DataSet();

 da.Fill(ds);

 DataTable dtCategories = ds.Tables[0];
 DataTable dtSuppliers = ds.Tables[1];
 DataTable dtProducts = ds.Tables[2];
}

C# Advanced Tutorial in Tamil | List with example

 Hi please find the List example below

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Generics
{
    class Program
    {
        static void Main(string[] args)
        {
            List<string> myclass = new List<string>();
            myclass.Add("Anto");
            myclass.Add("sujesh");
            myclass.Add("balaji");
            myclass.Add("Mani");
            for(int i =0;i < myclass.Count; i++)
            {
                Console.Write(myclass[i] + "\n");
            }
         
            Console.ReadKey();
        }
    }
}

List in tamil | C# Advanced Tutorial  in Tamil |learn C# in tamil | learn csharp in tamil | Generics with example in tamil | Generics with example | csharp Advanced | tamil Tutorial | anto tutorials | anto sj Tutorial | learn c# in tamil | learn csharp in tamil | C# List Tamil | csharp List tamil