.Net in C# and AngularJs for Beginners

This problem is very common while inserting value in database of SQL. The reason behind this is that: 1. You do not declare your SQL variable in parameters like this SqlCommand cmd= New SqlCommand(" insert into table name (Name, RollNo) values(@Name, @ RollNo",Con); cmd.Parameters. AddwithValues (" Name ", TextBox1.Text);  cmd.Parameters. AddwithValues (" RollNo ", TextBox2.Text);    cmd.ExecuteNonQuery();  here you should include "@Name" and "@RollNo" with parameters 2. Second which I got is that we write cmd.ExecuteNonQuery(); above the parameter like this SqlCommand cmd= New SqlCommand(" insert into table name (Name, RollNo) values(@Name, @ RollNo",Con); cmd.ExecuteNonQuery(); cmd.Parameters. AddwithValues (" Name ", TextBox1.Text);  cmd.Parameters. AddwithValues (" RollNo ", TextBox2.Text);    This also shows Scalar variable problem. I hope this will help you a lot.  thank you   

When you want to upload YouTube video in your server and want to display it in your web page then before this you will have to convert the YouTube link in embedded link because ifram tag of html supports this. How yo will get embedded YouTube video link. Look at the below picture. The selected text in the picture is embedded link of this video, you can get this by clicking on share text as this is obvious in picture. Since user will upload only URL got in web page you will have to convert it in embedded URL. How you will convert youtube url in embedded? if you are using C# then do link this.          string s = TextBox1.Text; // text box in which user enters Youtube URL         string g = "embed/";         string o = "watch?v=";         string m = s.Replace(o, g); // finally we get m as a embedded URL to store in database. With the help of sql command you can easily store this string m in your database. How to display these videos in aspx page?  <as

I this tutorial i will teach you how to check username and email ID if already registered or exist in database. It will be helpful for you when you will make a user registration page. So lets start 1. first take two text boxes and two labels make sure your labels do not contain any written text (It will appear unseen while loading page) 2. make a table in your database for testing purpose right now containing two columns named 'UserName' and 'Email ID'. 3. now select username text box( textbox1) and go to source. On the left side of toolbox there is Script manager drag and drop it on your page any where in body.   4. Now, Just below Script Manager there is Update Panel (as it is seen in image) now add your textbox in this panel but you will have to add another tag named Content Template it is also in coding as shown.  5. Now double click on TextBox1 which is related to User Name  and make Sql Connection and write code as shown here.   repeat  t

In Asp.Net gridview has its own importance because it bind same type of repeated data from server in bulk and give flexibility to programers. When I started working on gridview it was quite difficult for me to manage data in gridview because when you see other side arranging data in very stylish way and when you try to achieve it and do not succeeded in it, then it give you mental pain. But here i described some simple way to make it more understandable for you. So here we go. Suppose you want to make three columns in gridview and in one column want to set 'Tile' for your data i.e in one section Titles appear automatically. See in the above picture colored area represent different region of different data from database like Title, Description, Author Name, Date and video URL.    Do the following Steps: 1. Set The AutoGenerateColumns to Off.   It will allow you to manage your own columns in Grid View. Now you can see that there are two columns in the picture and i

Some clients prefer to use MS Access as a database for their software or web application. In this tutorial you will get a guide how to use MS Access as a database. To achieve this you should do following steps: 1.       Open MS Access.          2.       Create database by clicking on blank database.        3. Name your database on the area given. 4. Create your columns and save it. 5. Now, open your visual studio and make a new form to make software. 6. Make connection with access database as seen in image below. When you will click on add new database then a window will appear to give you comfort to add database as shown in image. This will give you connection string. when you click on create new database then to add Ms Access as a database you will have to click on change button and will have to choose database as shown in image.   Now click on brows button to find you access sheet.      7.       In the code