Online Tutorial Page: January 2016

Sunday, January 31, 2016

how to create delete button in asp net

use Below code for delete data from Sql server in asp.net :


Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click

Try
            Dim RowsAffected As Integer = 0

con.Open()
Dim cq As String = String.Format("delete from UnitType where UnitTypeID= {0}", TextBox1.Text)
cmd = New SqlCommand(cq) With {.Connection = con}
RowsAffected = cmd.ExecuteNonQuery()
Label5.Text = "Successfully deleted"
FillGrid()
TextBox1.Text = ""
TextBox2.Text = ""
If con.State = ConnectionState.Open Then
con.Close()
End If
Catch ex As Exception
Response.Write(ex.Message)
End Try

End Sub

how to use autocomplete in asp net

Use Below Code to show data in Textbox in Asp.net :

<System.Web.Script.Services.ScriptMethod(), System.Web.Services.WebMethod()>


    Public Shared Function SearchUnit(ByVal prefixText As String, ByVal count As Integer) As List(Of String)

Dim con As SqlConnection = New SqlConnection

con.ConnectionString = ConfigurationManager.ConnectionStrings("MTechSqlDatabaseConnectionString").ConnectionString
        Dim cmd As SqlCommand = New SqlCommand

cmd.CommandText = String.Format("select UnitType from UnitType where UnitType LIKE '%{0}%' ", prefixText)
        '

cmd.Parameters.AddWithValue("@ProductName", prefixText)
cmd.Connection = con
con.Open()
Dim UnitType As List(Of String) = New List(Of String)
Dim sdr As SqlDataReader = cmd.ExecuteReader
While sdr.Read
UnitType.Add(sdr("UnitType").ToString)
End While
con.Close()
Return UnitType

End Function

<div>
<asp:ScriptManager ID="ScriptManager1" runat="server" EnablePageMethods="True"></asp:ScriptManager>

 <asp:TextBox ID="TextBox4" runat="server"></asp:TextBox>

<ajaxToolkit:AutoCompleteExtender ID="AutoCompleteExtender2" runat="server" CompletionInterval="100" EnableCaching="False" MinimumPrefixLength="1" ServiceMethod="SearchUnit" TargetControlID="TextBox4"></ajaxToolkit:AutoCompleteExtender>
                    
</div>

how to open a page in new tab on button click in asp net

Below Code Open only one new Tab and if you click again it refresh that page:


Protected Sub Button6_Click(sender As Object, e As EventArgs) Handles Button6.Click
      Page.ClientScript.RegisterStartupScript(Me.GetType, "OpenWindow", "window.open('UnitType.aspx','_newtab');", True)

End Sub

Below Code Open new Tab and if you click again it will open another new tab page:

<asp:Button ID="Button7" runat="server" Text=">>" OnClientClick="document.getElementById('form1').target ='_blank';" /> Protected Sub Button7_Click(sender As Object, e As EventArgs) Handles Button7.Click Response.Redirect("Authors.aspx") End Sub