<script language=”javascript” type=”text/javascript”> function chkFile() { var fextension = document.getElementById(“<%=FileUpload1.ClientID %>”).value; var exten = fextension.split(“.”); var len=exten.length; //alert(exten.length); if(exten[len-1]==”doc” || exten[len-1]==”docx”) { alert(“File upload successfully”); return true; } else { alert(“Please select doc file”); return false; } } </script>
Create Folder/Directory and Check Existing or not Here Session[“user”] is a name which will be created…. ‘upload’ is a floder/Director that already created. if(Directory.Exists(Server.MapPath(“upload”) + “/” + Session[“user”].ToString())) { } else { System.IO.Directory.CreateDirectory(Server.MapPath(“upload”) + “/” + Session[“user”].ToString()); }
First Time Page Load Gridview Shown as below .aspx Page Coding <div> <asp:GridView ID=”GridView1″ runat=”server” AutoGenerateColumns=”False” ShowFooter=”True” > <Columns> <asp:TemplateField HeaderText=”Rollno”> <ItemTemplate> <asp:Label ID=”lblRno” runat=”Server” Text=””></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText=”Name”> <ItemTemplate> <asp:Label ID=”lblName” runat=”server” Text='<%# Eval(“name”) %>’></asp:Label> </ItemTemplate> <FooterTemplate> <asp:TextBox ID=”txtName” runat=”server” Text=””></asp:TextBox> </FooterTemplate> </asp:TemplateField> <asp:TemplateField HeaderText=”City”> <ItemTemplate> <asp:Label ID=”lblCity” runat=”server” Text='<%# Eval(“city”) %>’></asp:Label> </ItemTemplate> …
–JavaScript– <script language=”javascript” type=”text/javascript”> //user for select all checkbox function SelectAllCheckboxes(spanChk){ // Added as ASPX uses SPAN for checkbox var oItem = spanChk.children; var theBox= (spanChk.type==”checkbox”) ? spanChk : spanChk.children.item[0]; xState=theBox.checked; elm=theBox.form.elements; for(i=0;i<elm.length;i++) if(elm[i].type==”checkbox” && elm[i].id!=theBox.id) { //elm[i].click(); if(elm[i].checked!=xState) elm[i].click(); //elm[i].checked=xState; } } //User for check any checkbox is selected or not and delete confirm …
Inner Joins It match records together based on one or more common fields, as do most JOINS but inner joins return only records where there are matches for whatever fields you have said are to be used for join. Join Two Tables Table_1 : Product_Master Table_2 : Sales_Order_Detaisl Query: select a.product_no,a.decscription from product_master a inner …
use <database_name> Select DataBase using above query select * from information_schema.tables You can easily fine tables list using above syntax. sp_help <table_name> See particular table structure/Design. select s_order_no, count(s_order_no) As ‘SalesOrder’ from sales_order_details group by s_order_no having (count(s_order_no)>1) Find Duplicate Records In Table
<script language=”javascript” type=”text/javascript”> function validateFormOnSubmit(theForm) { var reason = “”; var intFlag = 0; //Radio button List validation reason += validateTextBox(); reason += validateLastName(); reason += validateDate(); reason += validateQualification(); reason += validateRadioButtonList(); if(reason != “”) { //alert(“Please select Student Status”); alert(reason); return false; } else { return true; } /* complete radio list validation …
link for Prevent Server Files to delete from client pc http://www.bigresource.com/ASP-prevent-my-client-to-delete-file-yAVtPdFN.html
Gridview Dynamically Insert Update Deleted. http://csharpdotnetfreak.blogspot.com/2009/05/gridview-sqldatasource-insert-edit.html
Add Item into ListBox Write below code in page load event for adding items in listbox1 if (!Page.IsPostBack) { ListBox1.Items.Add(“Baroda”); ListBox1.Items.Add(“Anand”); ListBox1.Items.Add(“Ahmedabad”); ListBox1.Items.Add(“Pune”); } Now create another list box and one button to transfer multiple selected item from previous listbox Write downbelow code in Button Click event……….. int sel = 0; for (int i = …