\u0628\u0631\u0627\u06cc \u0627\u0646\u062a\u0642\u0627\u0644 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0648 \u0645\u062a\u063a\u06cc\u0631\u0647\u0627 \u0627\u0632 \u06cc\u06a9 \u0635\u0641\u062d\u0647 \u0628\u0647 \u0635\u0641\u062d\u0647 \u062f\u06cc\u06af\u0631 \u0631\u0627\u0647 \u0647\u0627\u06cc \u0645\u062a\u0639\u062f\u062f\u06cc \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u06a9\u0647 \u062f\u0631 \u0627\u06cc\u0646 \u0645\u0642\u0627\u0644\u0647 \u0645\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u0645\u06cc\u062f\u0647\u06cc\u0645.<\/p>\n
\u0628\u0631\u0627\u06cc \u0627\u0646\u062c\u0627\u0645 \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0628\u0627\u06cc\u062f \u0627\u0628\u062a\u062f\u0627 \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u0628\u0627 \u0646\u0627\u0645 usertable \u062f\u0631 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633<\/a> \u0628\u0627 \u0641\u06cc\u0644\u062f \u0647\u0627\u06cc Firstname , Lastname , age \u0628\u0633\u0627\u0632\u06cc\u0645. \u0628\u0647 \u0647\u0645\u06cc\u0646 \u062c\u0647\u062a \u0627\u0632 \u062f\u0633\u062a\u0648\u0631 \u0632\u06cc\u0631 \u0628\u0631\u0627\u06cc \u0633\u0627\u062e\u062a \u06cc\u06a9 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u062f\u0631 sql server \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u0645.\u0628\u0631\u0627\u06cc \u06a9\u0633\u0628 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u062f\u0631 \u062d\u0648\u0632\u0647 Microsoft SQL Server \u0686\u06cc\u0633\u062a<\/a> \u0628\u0647 \u0634\u0645\u0627 \u067e\u06cc\u0634\u0646\u0647\u0627\u062f \u0645\u06cc \u0634\u0648\u062f \u0645\u0642\u0627\u0644\u0647 \u0627\u062e\u062a\u0635\u0627\u0635\u06cc \u0645\u0627 \u0631\u0627 \u0645\u0637\u0627\u0644\u0639\u0647 \u0646\u0645\u0627\u06cc\u06cc\u062f.<\/p>\n create table usertable<\/p>\n (<\/p>\n UserId varchar(100),<\/p>\n FirstName varchar(50),<\/p>\n LastName varchar(30),<\/p>\n Age varchar(30)<\/p>\n )<\/p>\n \u062a\u0648\u062c\u0647 \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u0647\u06cc\u0686 \u0645\u0642\u062f\u0627\u0631\u06cc \u0631\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 Edit \u06a9\u0631\u062f\u0646 \u062c\u062f\u0648\u0644 \u062f\u0631 \u0641\u06cc\u0644\u062f \u0647\u0627\u06cc \u0622\u0646 \u0642\u0631\u0627\u0631 \u0646\u062f\u0647\u06cc\u062f.<\/p>\n \u0627\u06a9\u0646\u0648\u0646 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0641\u06cc\u0644\u062f \u0647\u0627\u0631\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062f\u0633\u062a\u0648\u0631\u0627\u062a \u0632\u06cc\u0631 \u062f\u0631 \u062c\u062f\u0648\u0644 \u0648\u0627\u0631\u062f \u0645\u06cc\u06a9\u0646\u06cc\u0645(\u0628\u0647 \u06cc\u0627\u062f \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f \u06a9\u0647 \u0627\u06cc\u0646 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0631\u0627 \u0627\u0632 \u06a9\u0646\u062a\u0631\u0644\u0631 \u0647\u0627\u06cc \u0648\u0631\u0648\u062f\u06cc \u06af\u0631\u0641\u062a\u0647 \u0648 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0622\u0646\u0647\u0627 \u0631\u0627 \u062c\u0627\u06cc\u06af\u0632\u06cc\u0646 \u0645\u06cc\u06a9\u0646\u06cc\u0645).<\/p>\n [irp posts=”8606″ name=”\u0645\u0639\u0631\u0641\u06cc \u0648 \u06a9\u0627\u0631\u0628\u0631\u062f \u0646\u0631\u0645 \u0627\u0641\u0632\u0627\u0631 \u0647\u0627\u06cc \u0628\u0647\u06cc\u0646\u0647 \u0633\u0627\u0632\u06cc \u062d\u062c\u0645 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647”]\n \u0646\u06a9\u062a\u0647: \u062f\u0631 \u0627\u06cc\u0646 \u0645\u0642\u0627\u0644\u0647 \u0645\u0627 \u0628\u0647 \u062f\u0644\u06cc\u0644 \u0633\u0627\u062f\u06af\u06cc \u0648 \u062c\u0644\u0648\u06af\u06cc\u0631\u06cc \u0627\u0632 \u062d\u062c\u0645 \u0632\u06cc\u0627\u062f \u0645\u0642\u0627\u0644\u0647 \u0646\u0633\u0628\u062a \u0628\u0647 \u0627\u06cc\u062c\u0627\u062f Textbox \u0648 \u062f\u06cc\u06af\u0631 \u06a9\u0646\u062a\u0631\u0644\u0631\u0647\u0627 \u0628\u0631\u0627\u06cc \u0648\u0631\u0648\u062f \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0646\u0645\u06cc\u067e\u0631\u062f\u0627\u0632\u06cc\u0645.<\/p>\n insert into usertable values(5, ‘rohatash’,’Kumar’,’23’)<\/p>\n go<\/p>\n insert into usertable values(3, ‘monu’,’rathor’,’20’)<\/p>\n go<\/p>\n insert into usertable values(4, ‘rahul’,’sharma’,’24’)<\/p>\n go<\/p>\n insert into usertable values(8, ‘ram’,’singh’,’26’)<\/p>\n \u0627\u06a9\u0646\u0648\u0646 \u0628\u0631\u0627\u06cc \u0627\u0637\u0645\u06cc\u0646\u0627\u0646 \u0627\u0632 \u0627\u0646\u062c\u0627\u0645 \u0635\u062d\u06cc\u062d \u06a9\u0627\u0631 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062f\u0633\u062a\u0648\u0631 select \u0645\u0642\u0627\u062f\u06cc\u0631 \u062c\u062f\u0648\u0644 usertable \u0631\u0627 \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u0645\u06cc\u06a9\u0646\u06cc\u0645 \u06a9\u0647 \u062e\u0631\u0648\u062c\u06cc \u0622\u0646 \u0628\u0647 \u0635\u0648\u0631\u062a \u0634\u06a9\u0644 \u0632\u06cc\u0631 \u0645\u06cc\u0628\u0627\u0634\u062f.<\/p>\n select * from usertable;<\/p>\n \u062d\u0627\u0644\u0627 \u0628\u0627\u06cc\u062f \u06f2\u0635\u0641\u062d\u0647 \u06cc asp.net \u0631\u0627 \u0628\u0631\u0627\u06cc \u0627\u0646\u062a\u0642\u0627\u0644 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633\u00a0 \u0627\u0632 \u06cc\u06a9\u06cc \u0628\u0647 \u062f\u06cc\u06af\u0631\u06cc \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u0645.<\/p>\n [irp posts=”4268″ name=”asp.net \u0686\u06cc\u0633\u062a \u0648 \u0647\u0645\u0647 \u0686\u06cc\u0632 \u062f\u0631\u0628\u0627\u0631\u0647 \u06a9\u0627\u0631\u0628\u0631\u062f \u0622\u0646”]\n \u062f\u0631 visual studio.net \u06cc\u06a9 \u067e\u0631\u0648\u0698\u0647 asp.net \u062c\u062f\u06cc\u062f \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc\u06a9\u0646\u06cc\u0645 \u0648 \u062f\u0631 \u0635\u0641\u062d\u0647 Default1.aspx \u06a9\u062f \u0632\u06cc\u0631 \u0631\u0627 \u0648\u0627\u0631\u062f \u0645\u06cc\u06a9\u0646\u06cc\u0645:<\/p>\n <div><\/p>\n <a href=”showdetail.aspx?userid=5″ title=”Show records where userId is 5″>Show records where userId is 5<\/a><\/p>\n <p><asp:HyperLink ID=”hyper1″ runat=”server” Text=”Show Record where userID is 4″> <\/asp:HyperLink> <\/p><\/p>\n <\/div><\/p>\n \u0633\u067e\u0633 \u062f\u0631 default1.aspx.cs \u06a9\u062f \u0632\u06cc\u0631 \u0631\u0627 \u0648\u0627\u0631\u062f \u0645\u06cc\u06a9\u0646\u06cc\u0645.<\/p>\n Protected Sub Page_Load(ByVal sender As Object, ByVal eAs System.EventArgs)Handles Me.Load<\/p>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0If Not IsPostBack Then<\/p>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 hyper1.NavigateUrl = “showdetail.aspx?userid=4&com=show”<\/p>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0End If<\/p>\n \u00a0\u00a0\u00a0End Sub<\/p>\n \u062d\u0627\u0644 \u06cc\u06a9 \u0635\u0641\u062d\u0647 \u06cc \u062f\u06cc\u06af\u0631 \u0628\u0627 \u0646\u0627\u0645 showdetail.aspx \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc\u06a9\u0646\u06cc\u0645 \u0648 \u06a9\u062f \u0632\u06cc\u0631 \u0631\u0627 \u062f\u0631 \u0622\u0646 \u0642\u0631\u0627\u0631 \u0645\u06cc\u062f\u0647\u06cc\u0645:<\/p>\n \u00a0\u00a0\u00a0 <div><\/p>\n \u00a0\u00a0\u00a0\u00a0<asp:DetailsView ID=”DetailsView1″ runat=”server” EnableViewState=”False”<\/p>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Width=”146px”><\/p>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/asp:DetailsView><\/p>\n \u00a0\u00a0\u00a0<\/div><\/p>\n \u0627\u06a9\u0646\u0648\u0646 \u062f\u0631 code segment \u0635\u0641\u062d\u0647 \u06cc showdetail.aspx.cs \u062f\u0631 \u0631\u0648\u06cc\u062f\u0627\u062f page_load \u0642\u0637\u0639\u0647 \u06a9\u062f \u0632\u06cc\u0631 \u0631\u0627 \u0628\u0647 \u062c\u0647\u062a \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 ado.net \u0627\u0632 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0627\u06cc\u062c\u0627\u062f \u0634\u062f\u0647\u060c \u0648\u0627\u0631\u062f \u0645\u06cc\u06a9\u0646\u06cc\u0645.<\/p>\n Protected Sub Page_Load(ByVal sender As Object, ByVal eAs System.EventArgs)Handles Me.Load<\/p>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0If Not IsPostBack Then<\/p>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0If Not String.IsNullOrWhiteSpace(Request.QueryString(“userid”))Then<\/p>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Dim userId As Integer = 0<\/p>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Integer.TryParse(Request.QueryString(“userid”), userId)<\/p>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0If Not userId.Equals(0) Then<\/p>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 GetData(userId)<\/p>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0End If<\/p>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0End If<\/p>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Dim command As String = Request.QueryString(“com”)<\/p>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0End If<\/p>\n \u00a0\u00a0\u00a0End Sub<\/p>\n \u00a0\u00a0\u00a0Private Sub GetData(ByVal userIdAs Integer)<\/p>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Dim table As New DataTable()<\/p>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Dim conn As New SqlConnection(“Data Source=.;uid=sa;pwd=Password$2;database=master”)<\/p>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0If True Then<\/p>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Dim sql As String = “SELECT userId, FirstName, LastName, Age FROM usertable WHERE userId = @userId ORDER By userId”<\/p>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Using cmd As New SqlCommand(sql, conn)<\/p>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Dim ad As New SqlDataAdapter(cmd)<\/p>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0If True Then<\/p>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Dim prm As New SqlParameter(“@userId”,SqlDbType.Int)<\/p>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 prm.Value = userId<\/p>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 cmd.Parameters.Add(prm)<\/p>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ad.Fill(table)<\/p>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0End If<\/p>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0End Using<\/p>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0End If<\/p>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DetailsView1.DataSource = table<\/p>\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DetailsView1.DataBind()<\/p>\n \u00a0\u00a0\u00a0End Sub<\/p>\n \u0627\u06a9\u0646\u0648\u0646 \u0628\u0631\u0646\u0627\u0645\u0647 \u0631\u0627 \u0627\u062c\u0631\u0627 \u0648 \u062a\u0633\u062a \u0645\u06cc\u06a9\u0646\u06cc\u0645 \u06a9\u0647 \u0628\u0627\u06cc\u062f \u0628\u0627 \u0635\u0641\u062d\u0647 \u0627\u06cc \u0647\u0645\u0627\u0646\u0646\u062f \u0634\u06a9\u0644 \u0632\u06cc\u0631 \u0645\u0648\u0627\u062c\u0647 \u0634\u0648\u06cc\u062f.<\/p>\n \u0627\u06a9\u0646\u0648\u0646 \u0628\u0631 \u0631\u0648\u06cc \u0644\u06cc\u0646\u06a9 \u0645\u0648\u062c\u0648\u062f \u062f\u0631 \u0635\u0641\u062d\u0647 default.aspx \u06a9\u0644\u06cc\u06a9 \u06a9\u0646\u06cc\u062f \u062a\u0627 \u0628\u0647 \u0635\u0641\u062d\u0647 showdetail.aspx \u0628\u0627 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u062f\u0631\u062e\u0648\u0627\u0633\u062a \u0634\u062f\u0647 \u0648 \u0645\u0648\u062c\u0648\u062f \u062f\u0631 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0647\u062f\u0627\u06cc\u062a \u0634\u0648\u06cc\u062f.<\/p>\n \n","protected":false},"excerpt":{"rendered":" \u0628\u0631\u0627\u06cc \u0627\u0646\u062a\u0642\u0627\u0644 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0648 \u0645\u062a\u063a\u06cc\u0631\u0647\u0627 \u0627\u0632 \u06cc\u06a9 \u0635\u0641\u062d\u0647 \u0628\u0647 \u0635\u0641\u062d\u0647 \u062f\u06cc\u06af\u0631 \u0631\u0627\u0647 \u0647\u0627\u06cc \u0645\u062a\u0639\u062f\u062f\u06cc \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u06a9\u0647 \u062f\u0631 \u0627\u06cc\u0646 \u0645\u0642\u0627\u0644\u0647 \u0645\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u0645\u06cc\u062f\u0647\u06cc\u0645. \u0628\u0631\u0627\u06cc \u0627\u0646\u062c\u0627\u0645 \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0628\u0627\u06cc\u062f \u0627\u0628\u062a\u062f\u0627 \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u0628\u0627 \u0646\u0627\u0645 usertable \u062f\u0631 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0628\u0627 \u0641\u06cc\u0644\u062f \u0647\u0627\u06cc Firstname , Lastname , age \u0628\u0633\u0627\u0632\u06cc\u0645. \u0628\u0647 \u0647\u0645\u06cc\u0646 …<\/p>\n","protected":false},"author":64,"featured_media":10082,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[96],"tags":[],"class_list":["post-10078","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-general"],"_links":{"self":[{"href":"https:\/\/iranhost.com\/blog\/wp-json\/wp\/v2\/posts\/10078","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/iranhost.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/iranhost.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/iranhost.com\/blog\/wp-json\/wp\/v2\/users\/64"}],"replies":[{"embeddable":true,"href":"https:\/\/iranhost.com\/blog\/wp-json\/wp\/v2\/comments?post=10078"}],"version-history":[{"count":0,"href":"https:\/\/iranhost.com\/blog\/wp-json\/wp\/v2\/posts\/10078\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/iranhost.com\/blog\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/iranhost.com\/blog\/wp-json\/wp\/v2\/media?parent=10078"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/iranhost.com\/blog\/wp-json\/wp\/v2\/categories?post=10078"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/iranhost.com\/blog\/wp-json\/wp\/v2\/tags?post=10078"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}