Blog – Mahesh J

Bind With Gridview using string formate

• Asp.net

Bind With Gridview using string formate

Mahesh Javiya 14 years ago

‘<%#String.Format(“JewelleryDetail.aspx?prdid={0}&CatId={1}”,Eval(“STYLE_ID”),Request.QueryString[“CatId”].ToString())%>’... Read More

Create thumbnail with category folder 1 min read

• Asp.net

Create thumbnail with category folder

Mahesh Javiya 14 years ago

try { Product obj_Product = new Product(); string[] filePaths = Directory.GetFiles(Server.MapPath(“~\\”+ Common.WebImageFolder )); foreach (string filePath in filePaths) { File.Delete(filePath); } string[] imageDirectory = Directory.GetDirectories(Server.MapPath(“~\\”... Read More

Read and Edit xml file 1 min read

• XML

Read and Edit xml file

Mahesh Javiya 14 years ago

XML Read and Edit xml file <?xml version=”1.0″ encoding=”utf-8″?> <appSettings> <EmailAddress></EmailAddress> <UserName></UserName> <Password></Password> <SMTPserver>smtp.gmail.com</SMTPserver> <Port> </Port> <ssl>False</ssl> </appSettings> Code: public void GetEmailsetting() { vidDocument.Load(XmlPath); // this... Read More

Read Data from .txt file in sql 1 min read

• Sql server

Read Data from .txt file in sql

Mahesh Javiya 14 years ago

LOAD DATA LOCAL INFILE ‘C:\\[your folder path to the data file]\\GEODATASOURCE-WORLD-MAJOR-CITIES-SAMPLES.TXT’ INTO TABLE `countrystatecitydb`.`countrystatecity` CHARACTER SET utf8 FIELDS TERMINATED BY ‘\t’0 LINES TERMINATED BY ‘\r\n’;... Read More

xp command shell to create file on server 1 min read

• Sql server

xp command shell to create file on server

Mahesh Javiya 14 years ago

xp command shell to create file on serverExec Master.dbo.Sp_Configure ‘Show Advanced Options’, 1 RECONFIGURE WITH OVERRIDE Exec Master.dbo.Sp_Configure ‘XP_CmdShell’, 1 RECONFIGURE WITH OVERRIDE exec master..xp_cmdshell... Read More

Store Procedure to get a Multiple Category 1 min read

• Sql server

Store Procedure to get a Multiple Category

Mahesh Javiya 14 years ago

WITH CATEGORYVIEW (cat_Id, cat_ParentId,cat_orgname, cat_name,Main_catId,MainCatName ,cat_image,cat_displayorder,cat_IsShow) AS ( SELECT cat_Id, cat_ParentId,cat_name,cast(cat_name as varchar(255)),cast(cat_Id as varchar(255)),cast(cat_name as varchar(255)),cat_image,cat_displayorder,cat_IsShow FROM [CATEGORY_MST] WHERE isnull(cat_ParentId,0) = 0 UNION ALL... Read More

Match Comma Separated value(1,2,10) of field with int in sql 1 min read

• Sql server

Match Comma Separated value(1,2,10) of field with int in sql

Mahesh Javiya 14 years ago

select * from STYLE_MST u where 1=1 ‘,’+replace(DmndRate_Qly, ‘ ‘, ”)+’,’ Like ‘%,2,%’... Read More

Get a Row Number in sql 1 min read

• Sql server

Get a Row Number in sql

Mahesh Javiya 14 years ago

ROW_NUMBER() OVER(ORDER BY SalesYTD DESC) AS ‘Row Number’... Read More

JavaScript to change a class

• Javascript

JavaScript to change a class

Mahesh Javiya 14 years ago

<script type=”text/javascript”> document.getElementById(“active1”).className = “active”; </script>... Read More

JavaScript to disable button after click 1 min read

• Javascript

JavaScript to disable button after click

Mahesh Javiya 14 years ago

<script language=”javascript” type=”text/javascript”> function disableButton(sender,group) { Page_ClientValidate(group); if (Page_IsValid) { sender.disabled = “disabled”; __doPostBack(sender.name, ”); } } </script> and in Html <div> Enter Name :-... Read More