SqlLib C# (CSharp) Exemples de code

Exemple #1

0

Afficher le fichier

Fichier : ReportsController.cs Projet : shakthi1231/awicon

        public HttpResponseMessage Get(string report)
        {
            var connection              = SqlLib.getConnection();
            var commandText             = @"SELECT * FROM [dbo].[Reports] WHERE [name] = @name";
            HttpResponseMessage result  = new HttpResponseMessage(HttpStatusCode.OK);
            SqlCommand          command = new SqlCommand(commandText, connection);

            command.Parameters.AddWithValue("@name", report);
            try
            {
                connection.Open();
                using (var sqlQueryResult = command.ExecuteReader())
                    if (sqlQueryResult != null)
                    {
                        Debug.WriteLine("SqlResult is successfulr");
                        var    reportObj = sqlQueryResult.Read();
                        byte[] template  = (byte[])sqlQueryResult["template"];
                        var    startRow  = Int32.Parse(sqlQueryResult["startRow"].ToString());
                        var    table     = sqlQueryResult["table"].ToString();
                        var    map       = sqlQueryResult["map"].ToString();


                        using (var fs = new FileStream(@"c:\temp\Sample.xlsx", FileMode.Create, FileAccess.Write))
                            fs.Write(template, 0, template.Length);
                        DataTable dt = getColumns(table, map);
                        result = writeToExcel(dt);
                    }
            }
            catch (Exception ex)
            {
                Debug.WriteLine("Ëxception is thrown");
                Debug.WriteLine(ex.Message);
            }
            return(result);
        }

Exemple #2

0

Afficher le fichier

        public HttpResponseMessage GetCategoryId(string table)
        {
            List <object> columnNames   = new List <object>();
            var           sqlConnection = SqlLib.getConnection();
            var           commandText   = "select COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = @table  AND TABLE_SCHEMA='dbo'";
            SqlCommand    command       = new SqlCommand(commandText, sqlConnection);

            command.Parameters.AddWithValue("@table", table);
            try
            {
                sqlConnection.Open();
                using (var sqlQueryResult = command.ExecuteReader())
                    if (sqlQueryResult != null)
                    {
                        Debug.WriteLine("SqlResult is successfull");


                        while (sqlQueryResult.Read())
                        {
                            var tableName = sqlQueryResult.GetValue(0).ToString();
                            columnNames.Add(tableName);
                        }

                        Debug.WriteLine("Printing all the tableNames...");
                        Debug.WriteLine(columnNames);
                        Debug.WriteLine("finished");
                    }
            }
            catch (Exception ex)
            {
                Debug.WriteLine("Ëxception is thrown");
                Debug.WriteLine(ex.Message);
            }
            var response = Request.CreateResponse(HttpStatusCode.OK);

            response.Content = new ObjectContent <List <object> >(columnNames, Configuration.Formatters.JsonFormatter, "application/json");
            return(response);
        }

Exemple #3

0

Afficher le fichier

Fichier : Program.cs Projet : trucking/MsSqlLib

        static void Main(string[] args)
        {
            string server   = "hds-039.hichina.com";
            string database = "hds0390432_db";
            string username = "******";
            string password = "******";

            Console.WriteLine(123);
            List <string> itemList = new List <string> {
                "id", "item1", "item2"
            };
            List <string> valueList1 = new List <string> {
                "4", "tracy", "test1"
            };
            List <string> valueList2 = new List <string> {
                "5", "judy", "test2"
            };
            List <string> valueList3 = new List <string> {
                "6", "jorden", "test3"
            };
            List <List <string> > valueListArr = new List <List <string> >();

            valueListArr.Add(valueList1);
            valueListArr.Add(valueList2);
            valueListArr.Add(valueList3);
            //SqlConnection conn = new SqlConnection();
            //conn.ConnectionString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\mssqlsystemresource.mdf;Integrated Security=True;Connect Timeout=3";
            //conn.Open();
            SqlLib sl = new SqlLib(server, database, username, password);

            Console.WriteLine("this is MSSqlLib test fun!");
            //Console.WriteLine(conn.ServerVersion);
            Console.WriteLine(sl.Version);
            sl.Insert("test", itemList, valueListArr);
            Console.WriteLine(sl.EchoSql());
            sl.CloseConn();
        }

Exemple #4

0

Afficher le fichier