Asp.net TextBox First Letter Capital using JQuery
Asp.net TextBox First Letter Capital using JQuery <script type="text/javascript"> $(document).ready(function () { //"txtFirstName" is textbox…
Show Alert Box From Serverside in Asp.net
Show Alert Box From Serverside in Asp.net //Fuction for Alert Box protected void jsCall(string alertmessage)…
Use of UrlEncode and UrlDecode Method in Asp.net
Use of UrlEncode and UrlDecode Method in Asp.net UrlEncode Method : HttpUtility.UrlEncode(string) Ex: string encodedText=…
Posted inASP.NET MAIL WORKS WEB CONFIG
Send Mail in Forget Password Using Config File in Asp.net
Creating SMTP in Web Config File <configuration> <connectionStrings> <add name="Connection" connectionString="Data Source=.\SQLExpress;Initial Catalog=practise;Integrated Security=True;" providerName="System.Data.SqlClient"/>…
Posted inASP.NET MAIL WORKS WEB CONFIG
Send Mail Using Config File in Asp.net
Creating SMTP in Web Config File <configuration> <system.net> <mailSettings > <smtp> <network host="smtp.gmail.com" port="587" userName="Email…
Posted inASP.NET
Asp.net Pass Multiple Parameters in Query String or URL
If we want to send multiple parameters from one page to another page we need…
Posted inASP.NET
Save/Upload files in folder and download files from folder in asp.net
To implement this first design table in your database like below to save file details in database.
Column Name
Data Type
Allow Nulls
Id
int(set identity property=true)
No
FileName
varchar(50)
Yes
FilePath
varchar(50)
Yes
Now create new website after that right click on your website and add new folder and give name as Filesbecause here I am using same name for my sample if you want to change folder name you need to change the Files folder name in your code behind also
After that design your aspx page like this
Save and Download Files from file system
Posted inSQL
Query to concatenate two column values in SQL Server
I will explain how to write a query to concatenate two columns of data to…
Posted inSQL
Query to concatenate row values in sql server
If we want to concatenate one column row values into single row we need to…
Posted inSQL
Implementing Referential Integrity and Cascading Actions in SQL
Many a times you need to delete the record but at the same time you need to make sure all the related or referenced records are also deleted.
This is because you can not delete a record if it is referenced in another table.
In this case you can either delete the referenced record or you can set the “Cascade Delete On”.
CREATE TABLE [dbo].[Tracks](
[TrackID] [int] NOT NULL PRIMARY KEY,
[Title] [varchar](50) NULL,
[AlbumID] [int] NULL,
[Duration] [time](0) NULL)