Hello friends, today we will learn about MDI PARENT Form. We will use the previous example of datagridview in desktop application-showing data. Now add a new item by exploring solution explorer and add –> New Item , ADD NEW ITEM selection form will open as shown in the image. Now add select windows form and name
create a cursor in ms sql server
create a cursor in ms sql server Cursor is used to fetch records(rows) from any table sequentially and records can be manipulated, calculated as per your need. To create a cursor use this sql query: declare cursor_name cursor for select id from tbl_Category open cursor_name fetch next from cursor_name into @Id while @@fetch_status=0 begin insert into table_name(id) values
Dropdown binding with database in asp .net website
Dropdown binding with database in asp .net website Hello Friend , we learned how to bind a gridview and datagridview in asp .net website and desktop application respectively. Which is much easier. Now we learn how to bind a dropdown with database values like list of available employees to select under which new employee will
Gridview in web application and use of session
Hello Friend, Now its website turn. Now we will use gridview similar to windows control datagridview control in the previous example datagridview in desktop application-showing data. Here we will use the previous web example of Basic Login website with database connectivity. We will also learn basic use of session to maintain data integrity. In the previous example
datagridview in desktop application-showing data
Datagridview in desktop application-showing data Hello friends, how are you? And how is your programming? Today we will try to fetch some data from database and will show in the windows form. To do so, we need to use a Data Control. We will use datagridview control by expanding Data and then drag the control
desktop application database connectivity
Desktop application database connectivity Hello Friends, Today we will learn how to connect database in desktop application. For a reference you can also follow Basic Login website with database connectivity which will help you in understanding database basic handling. I am repeating the same project and also you can download the project. The link is at the
introduction of store procedure in mssql server
Hello friend, It is very bad habit and difficult to write separate sql query for each operation in sql query. The best solution for this problem is procedure . Procedure is similar to function which we will learn in next chapter, is collection of code which can be executed at any time. To create a procedure open
website-database connectivity using web.config
website-database connectivity using web.config Today, we will learn database connectivity using web.config <connectionStrings> property. The main advantage of using connection string in web.config are: Security– Web.config file is the configuration file which stores all the server setting required for the web application. And IIS server never allows to browse or view web.config file through browser. So
Basic Login website with database connectivity
For a data driven website i.e. dynamic website where we need to store data in database, we have to connect database with our website. To connect database we have to follow these steps: Connection String Connection string is the description of the server and database which is to be connected is a string of having some
Basic Login website without database connectivity
Basic Login website without database connectivity Hello Friends, Today We will make a basic login website in which we will use two text boxes and three labels and a button. Here is the design of the website. If you dont know how to create a website please follow our previous post “hello word asp .net
insert, delete and update queries using mssql server
Insert Query insert into table_name(column1,column2,column3,column4) values(value1,value2,value3,value4) We can also use design view to insert values into table. If you dont know how to create a table please follow the previous post create a table in mssql server . Just Right click on the Table_name in which you need to insert the table and select open table. Now put the
hello word asp .net website
Hello friends!! Today I am starting tutorial of basic asp .net web application development using c# scripting language. And I will show you how we can develop a very basic web application which will just use basic controls. Open Visual Studio and click to file: Now click on New and select web site : You
create a table in mssql server
To create a table in sql server we cam follow two steps: Design View Using Query window Design View Click to open sql server management studio and login to the server. Then select database by expanding database section If you dont have any database then create it by right clicking on database and then
Excel Sheet in C# .net windows application(ReoGrid)
Excel Sheet in C# .net windows application(ReoGrid) Create Spreadsheet Control Add Control by Form Designer in Visual Studio Right-click on Toolbox panel, click ‘Choose Items…’ Choose .NET Framework Components tab Click ‘Browse…’ button Choose unvell.ReoGrid.dll in open file dialog Click ‘OK’ to close the dialog Choose the Control appeared in Toolbox and drag it into designer,
simple calculator windows .net application and use of try catch
This is a next video after hello world application and in this video we will see how to use basic math operators like addition, subtraction, multiplication etc. Also here we learn use of “try and catch” module to handle exception occurring during division operation when we will try to divide any number by 0.