<script language="javascript" type="text/javascript">
function DisableButton(button,span) {
Page_ClientValidate();
if (Page_IsValid) {
button.style.display = 'none';
document.getElementById(span).style.display = 'inline';
}
}
</script>
<asp:Button ID="btnAdd" runat="server" Text="Add" CssClass="Button" OnClientClick="DisableButton(this,'spanAdd');" />
<span id="spanAdd" class="Infotext" style="display: none;">Please Wait...</span>
Example to filter user records by name / email if both criteria have the value
DECLARE @Name varchar(20)
DECLARE @Email varchar(20)
SET @Name = 'user'
SET @Email = ''
select * from User
WHERE (@Name = '' OR userName = @Name)
AND (@Email = '' OR userEmail= @Email)
Use [dbname]
declare @n char(1)
set @n = char(10)
declare @stmt nvarchar(max)
-- procedures
select @stmt = isnull( @stmt + @n, '' ) +
'drop procedure [' + name + ']'
from sys.procedures
-- check constraints
select @stmt = isnull( @stmt + @n, '' ) +
'alter table [' + object_name( parent_object_id ) + '] drop constraint [' + name + ']'
from sys.check_constraints
-- functions
select @stmt = isnull( @stmt + @n, '' ) +
'drop function [' + name + ']'
from sys.objects
where type in ( 'FN', 'IF', 'TF' )
-- views
select @stmt = isnull( @stmt + @n, '' ) +
'drop view [' + name + ']'
from sys.views
-- foreign keys
select @stmt = isnull( @stmt + @n, '' ) +
'alter table [' + object_name( parent_object_id ) + '] drop constraint [' + name + ']'
from sys.foreign_keys
-- tables
select @stmt = isnull( @stmt + @n, '' ) +
'drop table [' + name + ']'
from sys.tables
-- user defined types
select @stmt = isnull( @stmt + @n, '' ) +
'drop type [' + name + ']'
from sys.types
where is_user_defined = 1
exec sp_executesql @stmt
Select O.name objectName, C.name ColumnName
from sys.columns C
inner join sys.objects O
ON C.object_id=O.object_id
where C.name like 'address1'
order by O.name,C.name
please follow step below to fix this issue
select row_number() OVER (ORDER BY key) as RunningN,* from TBLName
select rank() OVER (ORDER BY key) as RunningN,* from TBLName
SELECT Routine_Name, Routine_Definition
FROM Information_Schema.Routines
WHERE Routine_Definition Like '%tblname%'
AND Routine_Type = 'Procedure'
function ChkNumeric()
{ //alert(event.keyCode);
if(((event.keyCode>=48) && (event.keyCode<=57) || (event.keyCode==9) || (event.keyCode==8) || (event.keyCode==13) || (event.keyCode==46)) || ((event.keyCode>=96) && (event.keyCode<=105)))
{
event.returnValue=true;
}
else
{
alert("Only Numerics Are Allowed")
event.returnValue=false;
}
}
Dim strchklist As String = ""
| Dim li As ListItem |
| For Each li In CheckBoxList1.Items |
| If li.Selected Then |
| strchklist += li.Text + " " |
| End If |
| Next |
| If strchklist = "" Then |
| Response.Write("No item Selected") |
| Else |
| Response.Write(("You selected : " + strchklist)) |
http://sapid.sourceforge.net (xml cms)
http://www.own-free-website.com (free hosting)
http://blogs.msdn.com/jamesche/archive/2007/09/27/automating-aspnet-compiler-in-visual-web-developer.aspx
http://www.codeplex.com/PUMA
Protected Sub gv1_RowDeleting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewDeleteEventArgs) Handles gv1.RowDeleting
Dim row As Integer
row = e.RowIndex
Dim idx As String = gv1.Rows(row).Cells(0).Text
Dim cmd As SqlCommand = conn.CreateCommand
Dim ds As New DataSet
cmd.CommandText = "Delete from login where id = " + idx.ToString + ""
conn.Open()
cmd.ExecuteNonQuery()
conn.Close()
bind_grid()
End Sub
Protected Sub gv1_PageIndexChanging(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewPageEventArgs) Handles gv1.PageIndexChanging
gv1.PageIndex = e.NewPageIndex
bind_grid()
End Sub
this source code will get the image size, image dimension, image type and save to folder
If FileUpload1.HasFile = True Then
If Round(FileUpload1.PostedFile.ContentLength / 1000) > 100 Then
Label1.Text = "Uploaded file size must be less than 100 KB"
End If
Label1.Text = "File name: " & _
FileUpload1.PostedFile.FileName & "
" & _
"File Size: " & _
Round(FileUpload1.PostedFile.ContentLength / 1000) & " kb
" & _
"Content type: " & _
FileUpload1.PostedFile.ContentType & _
"Image Dimensions :" & _
GetSize(FileUpload1.PostedFile.InputStream, "").ToString
FileUpload1.PostedFile.SaveAs(Server.MapPath(FileUpload1.PostedFile.FileName))
Else
Label1.Text = "Please select file"
End If
this example for show alert message when user click at delete button in Datalist
Protected Sub dl1_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DataListItemEventArgs) Handles dl1.ItemDataBound
If Not e.Item.ItemType = ListItemType.Header And Not e.Item.ItemType = ListItemType.Footer Then
Dim lnkDelete As LinkButton = CType(e.Item.FindControl("LDelete"), LinkButton)
lnkDelete.Attributes.Add("onclick", "return confirm('Are you sure you want to delete this record?');")
End If
End Sub
This code use for show a message box when delete button clicked on gridview and when to prevent the accidental deletions.
protected void gv1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
foreach (DataControlField dcf in gv1.Columns)
{
if (dcf.ToString() == "CommandField")
{
if (((CommandField)dcf).ShowDeleteButton == true)
{
e.Row.Cells[gv1.Columns.IndexOf(dcf)].Attributes
.Add("onclick", "return confirm(\"Are you sure?\")");
}
}
}
}
}
public static void alert(string msg)
{
string jscript = "";
Page page = HttpContext.Current.Handler as Page;
if (page != null)
{
page.RegisterStartupScript("clientScript", jscript);
}
}
| VB 'using mssql express edition Dim strConn As String = " Dim conn As New SqlConnection(strConn) Dim cmd As SqlCommand = conn.CreateCommand Dim reader As SqlDataReader cmd.CommandText = "Select * from clients where client_id = '" + iid.ToString() + "'" conn.Open() reader = cmd.ExecuteReader If reader.Read = True Then TextBox1.Text = reader.GetString(1) TextBox2.Text =reader.GetDatetime(2) TextBox3.Text = reader.GetString(3) TextBox4.Text = reader.GetString(4) End If conn.Close() string strConn = " SqlConnection conn = new SqlConnection(strConn); SqlCommand cmd = conn.CreateCommand; SqlDataReader reader; cmd.CommandText = "Select * from clients where client_id = '" + iid.ToString() + "'"; conn.Open(); reader = cmd.ExecuteReader; if (reader.Read == true) { TextBox1.Text = reader.GetString(1); TextBox2.Text = reader.GetDatetime(2); TextBox3.Text = reader.GetString(3); TextBox4.Text = reader.GetString(4); } conn.Close(); |
