- 22
- 428 860
Barry Solomon
Приєднався 20 бер 2007
Software development tutorials surrounding Microsoft Technologies with a focus on C#, .Net Framework, SQL Server, and in the interest of best practices.
3. Encapsulation - Basics of Object Oriented Programming (C#)
Encapsulation, one of the pillars of Object Oriented Programming (OOP)
Переглядів: 11 374
Відео
9. MS SQL - Importing Data from Excel to a Table in Management Studio
Переглядів 21 тис.10 років тому
Importing Data from Excel to a Table in Management Studio using Microsoft SQL Server.
8. MS SQL - Adding Functions in Management Studio
Переглядів 1,6 тис.10 років тому
Adding Functions in Management Studio using Microsoft SQL Server.
7. MS SQL - Adding Stored Procedures in Management Studio
Переглядів 6 тис.10 років тому
Adding Stored Procedures in Management Studio using Microsoft SQL Server.
6. MS SQL - Adding a Foreign Key Constraint (Many-to-Many Relationship) in Management Studio
Переглядів 8 тис.10 років тому
Adding a Foreign Key Constraint (Many-to-Many Relationship) in Management Studio using Microsoft SQL Server
5. MS SQL - Adding a Foreign Key Constraint (One-to-Many Relationship) in Management Studio
Переглядів 9 тис.10 років тому
Adding a Foreign Key Constraint (One-to-Many Relationship) in Management Studio using Microsoft SQL Server
2. MS SQL - Creating a Table in Management Studio
Переглядів 47610 років тому
Creating a Table in Management Studio using Microsoft SQL Server
1. MS SQL - Creating a Database in Management Studio
Переглядів 73010 років тому
Creating a Database in Management Studio using Microsoft SQL Server
3. MS SQL - Adding Indexes to a Table in Management Studio
Переглядів 6 тис.10 років тому
Adding Indexes to a Table in Management Studio using Microsoft SQL Server
4. MS SQL - Adding a Trigger to a Table in Management Studio
Переглядів 13 тис.10 років тому
Adding a Trigger to a Table in Management Studio using Microsoft SQL Server
2. Abstraction - Basics of Object Oriented Programming (C#)
Переглядів 4,6 тис.10 років тому
Abstraction, one of the pillars of Object Oriented Programming (OOP)
1. Introduction - Basics of Object Oriented Programming (C#)
Переглядів 2,1 тис.10 років тому
Introduction to the Basics of Object Oriented Programming (C#). This introduces the four pillars of Object Oriented Programming (OOP) including Abstraction, Encapsulation, Polymorphism, and Inheritance.
My Channel Introduction
Переглядів 2 тис.10 років тому
My channel introduction to programming with C#.Net surrounding Microsoft Technologies in the interest of following best practices.
C# - Using SqlDataAdapter, SqlCommand, DataTable and DataGridView
Переглядів 94 тис.11 років тому
Using a SqlDataAdapter to populate a DataTable and display on a DataGridView
C# - Microsoft Word API Mail Merge
Переглядів 34 тис.11 років тому
Using the Microsoft Word API to perform mail merge on a document with a word document template.
Episode 3: C# .Net Iteration - For Loop
Переглядів 29611 років тому
Episode 3: C# .Net Iteration - For Loop
Episode 4: C# .Net Iteration - While Loop
Переглядів 13811 років тому
Episode 4: C# .Net Iteration - While Loop
Episode 2: C# .Net Conditional - Switch Statements
Переглядів 16011 років тому
Episode 2: C# .Net Conditional - Switch Statements
Episode 1: C# .Net Conditional - If Statements
Переглядів 61511 років тому
Episode 1: C# .Net Conditional - If Statements
C# Import From Excel Using OleDb Tutorial
Переглядів 79 тис.13 років тому
C# Import From Excel Using OleDb Tutorial
I hope you are alive
How can we achieve the samething in my .net core application
dater adapter...rhymes with tater....
how would I show a table of records - multiple records from a dataset.
Thanks man, carried me through my college project !!!!
Great video! Been references for the last couple weeks on a project I've been working on. Curious if you had any tips on when the Word document has prompts? For some reason I can't get mine to work.
How would you display this in a console application?
Hi can I talk to you
2021 and this video helped me after hours of scratching my head. This is exactly what I needed! Thank you, Barry :)
Hi:)
very useful! thank you!
I can make a billion dollar software with just this trick!
Great
Thanks the vedio was so helpful but facing few error
Hi could you help me in this i am getting this error in last, at time of excecution(its failing) while importing excel---> TITLE: SQL Server Import and Export Wizard -------------------------------------------------------------------------------------------------------- Data flow execution failed. Error 0xc0000033: {5CCE2348-8B9F-4FD0-9AFA-9EA6D19576A7}: Integration Services evaluation period has expired. Error 0xc0000033: {5CCE2348-8B9F-4FD0-9AFA-9EA6D19576A7}: Integration Services evaluation period has expired. ------------------------------ ADDITIONAL INFORMATION: Integration Services evaluation period has expired. ({5CCE2348-8B9F-4FD0-9AFA-9EA6D19576A7}) ----------------------------------------------------------------------------------------------------------------------------------- In Addition I have tried running following query to change evaluation period expiry date---> -- Run the following query to retrieve the installed and expiry date on an Evaluation edition of SQL Server 2012/4 instance. SELECT create_date AS 'SQL Server Install Date', DATEADD(DD, 180, create_date) AS 'SQL Server Expiry Date' FROM sys.server_principals WHERE name = 'NT AUTHORITY\SYSTEM'
5:05 thank you for this info lol that '@' symbol was use that way huh
I don't know this is old lol, 10 yr old me XD
many thanks for your very good tutorial why do i have to specify the excel version? does this effect the data or prevent some data from appear?
Thank you for solution. I watched and followed your video. The "ws.Cells" part doesn't work. It has a red underline, and an error message says, "The member_Worksheet.Cells' cannot be used like a method." I'd like some advice on how to deal with this error.
Great video, thanks!
Thank you very much
Is there any body here to help? I have a database and I could connect it to C#. The problem is that I do not know how can I access each of the cells in the tables( there are about 10 different tables ) and do math operations on them and store the results in a new table?
Very helpful. What about conditional formatting for mail merger fields?
Grumpy old men!!!
I love you, bro!
Dear, can I have your facebook, I would like to ask more question cause I can't import excel file to SSMS
If possible, try to convert the excel file to csv, and on Task choose "Import Flat File". It's more simple because you dont need any provider installed, but it's not always you can work with csv files.
Hi I really Like you're tutorial, could you provide the script to automatically add (looped) dummy customers?
How to read ms word mail merge using stream in c#?
Thanks
can you define a primary key with this method?
Thanks a lot bruv. Informative
thank you so much bro)) you awesome ))
Thanks! Great and simple!
How can I use this method with multiple record. I wanna loop through data from my datagridview. Awesome video.
hay
شكرا جزيلا
I do not have this reference can someone help me add it? I don't see a .Net tab either just the COM
thankuuuu
how to merge cell export to excel
gracia por el truco lo necesitaba….
How can you set the trigger Order in MSSMS. Is there anywhere a property window to see the sp_settriggerorder property?
helped a lot and scratch from basics
Unnecessarily verbose. Why not simply use the properties to modify the private variables? K.I.S.S.
Thanks sir it is very helpful
your quality is so bad....this seems to be the best tutorial online.....BUT I CAN ONLY SEE HALF OF IT....!!! smh.....terrible
Just saw your video, because I wanted to know what this part of ssms is, known as triggers. Thanks for the video. Since I'm reacting more than four years after the publication of this video, it's likely that meanwhile you'll have learned about the thing I responding to, but in case other people watching do not yet know: The thing you speak of when you say that you have to restart the program in order to see your previous additions of database elements (tables, views, stored procedures, functions etc.) is known as the refresh of the local Intellisense cache. Just press Ctrl+Shift+R and restarting will propbably become unnecessary thing. HTH, Peter
Thanks!
the HDR stands for Header - if no headers for the table so should be NO
cool tut!!!
ur a god ty