Professional I.T. Tutorials
Professional Computer Courses by Sarib Ali.
Google Adsense Account Approval
Free Computer Video Tutorials - Google Adsense Account Approval Tips in Urdu & Hindi by Bilalakbar2344
How to bind DataGridView with Image field from SQL in VB.NET
Imports System.Data.SqlClient
Dim connstring As String
Dim sql As String
Dim sqlcon As New SqlConnection
Private Sub PopulateImginDataGridView_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles PopulateImginDataGridView.Click
connstring = "Data Source=localhost;Initial Catalog=Test;User id=sa;password=password;"
sqlcon.ConnectionString = connstring
sqlcon.Open()
DataGridView1.Rows.Clear()
Dim connstring As String
Dim sql As String
Dim sqlcon As New SqlConnection
Private Sub PopulateImginDataGridView_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles PopulateImginDataGridView.Click
connstring = "Data Source=localhost;Initial Catalog=Test;User id=sa;password=password;"
sqlcon.ConnectionString = connstring
sqlcon.Open()
DataGridView1.Rows.Clear()
How to read data using SQLDATAREADER using VB.NET
Imports System.Data.SqlClient
Dim sqlConnection As SqlConnection
Dim sqlCommand As SqlCommand
Dim dr As New SqlDataReader
Dim sqlConnection As SqlConnection
Dim sqlCommand As SqlCommand
Dim dr As New SqlDataReader
How to save image in Ms-SQL Database using VB.NET
Imports System.Data.SqlClient
Dim connstring As String
Dim sql As String
Dim sqlcon As New SqlConnection
Private Sub SaveImage_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SaveImage.Click
OpenFileDialog1.ShowDialog()
If OpenFileDialog1.FileName.Length > 0 Then
connstring = "Data Source=localhost;Initial Catalog=Test;User id=username;password=password;"
sqlcon.ConnectionString = connstring
sqlcon.Open()
Dim connstring As String
Dim sql As String
Dim sqlcon As New SqlConnection
Private Sub SaveImage_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SaveImage.Click
OpenFileDialog1.ShowDialog()
If OpenFileDialog1.FileName.Length > 0 Then
connstring = "Data Source=localhost;Initial Catalog=Test;User id=username;password=password;"
sqlcon.ConnectionString = connstring
sqlcon.Open()
How to retrieve image from Database VB.NET?
Imports System.Data.SqlClient
Dim connstring As String
Dim sql As String
Dim sqlcon As New SqlConnection
Private Sub RetrieveImage_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RetrieveImage.Click
Dim connstring As String
Dim sql As String
Dim sqlcon As New SqlConnection
Private Sub RetrieveImage_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RetrieveImage.Click
How to add button to DataGridView using VB.NET?
Imports System.Data.SqlClient
Dim connstring As String
Dim sql As String
Dim sqlcon As New SqlConnection
Private Sub PopulateImginDataGridView_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles PopulateImginDataGridView.Click
connstring = "Data Source=localhost;Initial Catalog=Test;User id=sa;password=password;"
sqlcon.ConnectionString = connstring
sqlcon.Open()
Dim connstring As String
Dim sql As String
Dim sqlcon As New SqlConnection
Private Sub PopulateImginDataGridView_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles PopulateImginDataGridView.Click
connstring = "Data Source=localhost;Initial Catalog=Test;User id=sa;password=password;"
sqlcon.ConnectionString = connstring
sqlcon.Open()
SQL Stored Procedure (INSERT / UPDATE / DELETE)
Stored Procedure ( Insert ,Delete, Update )
---------------------------------------------------------------
create procedure SPS_Designation_Add
@Designation VarChar(50)
As Begin
insert into Tbl_Designation
(Designation)
values
(@Designation)
end
-------------------------------------------------------------
---------------------------------------------------------------
create procedure SPS_Designation_Add
@Designation VarChar(50)
As Begin
insert into Tbl_Designation
(Designation)
values
(@Designation)
end
-------------------------------------------------------------
Create EXE File in VB.NET
Setup projects allow you to create installers in order to distribute an application. The resulting Windows Installer (.msi) file contains the application, any dependent files, information about the application such as registry entries, and instructions for installation. When the .msi file is distributed and run on another computer, you can be assured that everything necessary for installation is included; if for any reason the installation fails (for example, the target computer does not have the required operating system version), the installation will be rolled back and the computer returned to its pre-installation state.
The following steps will gives the elegant guidance to create an exe or installer file.
1, Go to file menu > click Add > new project >now “Add New Project” dialog will appear.
Valid Email Check JavaScript
<form name="validation" onSubmit="return checkbae()">
Please input a valid email address:<br />
<input type="text" size=18 name="emailcheck">
<input type="submit" value="Submit">
</form>
<script language="JavaScript1.2">
Please input a valid email address:<br />
<input type="text" size=18 name="emailcheck">
<input type="submit" value="Submit">
</form>
<script language="JavaScript1.2">
Complex Login JavaScript
<script type = "text/javascript">
// Note: Like all Javascript password scripts, this is hopelessly insecure as the user can see
//the valid usernames/passwords and the redirect url simply with View Source.
// And the user can obtain another three tries simply by refreshing the page.
//So do not use for anything serious!
var count = 2;
function validate() {
var un = document.myform.username.value;
var pw = document.myform.pword.value;
var valid = false;
// Note: Like all Javascript password scripts, this is hopelessly insecure as the user can see
//the valid usernames/passwords and the redirect url simply with View Source.
// And the user can obtain another three tries simply by refreshing the page.
//So do not use for anything serious!
var count = 2;
function validate() {
var un = document.myform.username.value;
var pw = document.myform.pword.value;
var valid = false;
Subscribe to:
Posts (Atom)