Acccessing User control in Class Library Project in ASP.NET

Hi All,

In one of scnerio. i have to access user control of web application in my Class Library project.I do check what are the possibilities and alternatively found the solution.

Solution:

Implement interface to user control and get access of properties and methods in class library.

   23 public partial class multiupload : Imultiupload

{
...
}

here is my Interface

    9 public interface Imultiupload

{
...
}

in my Class Library project class where i want to access i have just initialize the control like this,

   41 Imultiupload fileupload = null;

and then i have access it by LoadControl method.

  314 fileupload = (Imultiupload)Page.LoadControl("~/inigo/admin/controls/multiupload.ascx");

  315                             fileupload.ControlID = Lib.ToUnderscore(p.Name);

  316                             fileupload.AllowMultipleFileUploads = true;

  317                             fileupload.ButtonText = "Upload Files";

Using Interface to access the user control in class library project is good practice.

Happy Coding :-)

Make your Class Lib project as Web Application Project

Hi All,

In one of my requirement i have to put my user control to Class Lib project. so i have digs a net and found the solution with something unbelievable.to achieve this please follow given steps,

1) Unload Class Lib project.
2) Edit Class Lib project and add following under very first line of ProjectGuid element

{349c5851-65df-11da-9384-00065b846f21};{fae04ec0-301f-11d3-bf4b-00c04f79efbc}

3) Once done with above Reload the project and Finish..!!

now when you select 'Add New Item' you will get all required web files there. once you rebuild it will available with single class assembly dll.


Happy Coding :-)

Show enum with space {If you are using Pascal case for Data}.

Hi All,

for a long period i was looking for some solution to allowing space in Enum to show Friendly while Displaying.

after digging too much i have come up with solution. I was using Pascal casing for strings shown in Enum, so here i have done some logic,

static string ToFriendlyCase(this string EnumString)
{
return Regex.Replace(EnumString, "(?!^)([A-Z])", " $1");
}

so if you Enum is TextField it will show you as "Text Field".

Happy Coding :-)

Find any keyword stored inside MS-Sql 'Function' or 'Procedure'.

Hi All,

As developer, one have frequently facing with problem of finding function or procedure in which they have made change. Here is how you will find out any keyword which you are looking for..

SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%KEYWORD%'
AND ROUTINE_TYPE='PROCEDURE' -- Write 'FUNCTION' to search in function.
ORDER BY ROUTINE_NAME

Happy Coding :-)

Show Edit Form Open with Telerik RadGrid with Insert button click.

Hi All,

My requirement for one event related to Telerik RadGrid for asp.net is i need to facilitate users to see Detailed Form when Master Record is inserted within same page.

So, here is my solution for this, in my case postback event is raised so i need to check with IsPostBack, below is code snap to be used for.

1) you need to register that event like with below code

132 this.rgformFields.PreRender += new EventHandler(rgformFields_PreRender);

2) above code which auto generate protected method which looks like below,

110 protected void rgformFields_PreRender(object sender, EventArgs e)

111 {

112 if (IsPostBack)

113 {

114 rgformFields.MasterTableView.IsItemInserted = true;

115 rgformFields.Rebind();

116 }

117 }

rgformFields is RadGrid of Telerik suite. I hope this could solve problem/requirement.

Happy Coding,

Stored procedure to generate Inserts from Table in MS-Sql

Hi All,

"Narayana Vyas" have given all of us a very good stored procedure which will generates insert scripts from tables.

Please find it here, or mail me i will send it you on reply.

http://vyaskn.tripod.com/code/generate_inserts.txt

Happy Coding :-)

Compare and extract difference string from two string[].

Hi,

In my one requirement i have to compare difference between two string[] through which i can justify missing headers.

.net have Dictionary class which i have used to solve my requirement.

below is code snippet how,

385 Dictionary<string, int> diff = new Dictionary<string, int>(StringComparer.InvariantCultureIgnoreCase);

386 foreach (string s in _strHeadersNames)

387 diff[s] = 1;

388 string[] strvalues = IsColumnHeadersExist(_strHeadersNames, strCsvFilePath).Split(',');

389 if (strvalues.Length > 1)

390 {

391 foreach (string s in strvalues)

392 {

393 int value;

394 if (diff.TryGetValue(s, out value) && value != 2)

395 diff[s] = 3;

396 else

397 diff[s] = 2;

398 }

399 foreach (KeyValuePair<string, int> pair in diff)

400 if (pair.Value == 1)

401 _strDiff = string.Concat(_strDiff, pair.Key, ",");

I hope above will be useful to you.

Happy Coding:-)

Check Duplicate Row while working with CSV file

Hi All,

If you are working with CSV file parsing, there is always a good practice to check duplicate rows while parsing data. If prevents the system crashing due to duplicate record entry in data and we could make proper exception handling with Friendly message to our users.

So, here i have make one usable function with help of C# as code language.

435 private int CheckDuplicateRows(string _SaveLocation)

436 {

437 if (!string.IsNullOrEmpty(_SaveLocation))

438 {

439 string[] FileContent = File.ReadAllLines(_SaveLocation);

440 ArrayList al = new ArrayList();

441 int lineNo = 1;

442 //ignore the header row

443 for (int i = 1; i <= FileContent.Length - 1; i++)

444 {

445 lineNo += 1;

446 if (al.Contains(FileContent[i]))

447 {

448 return lineNo;

449 }

450 else

451 {

452 al.Add(FileContent[i]);

453 }

454 }

455 return 1;

456 }

457 else return 1;

458 }

Thats all, and your code is safe to manage the exception of DuplicateRow, it will return 1 if there is no duplicate row else will return the duplicate row number.

Happy Coding :)

Find any Objects you have created in MS-SQL Server

Hi All,

before couple of hours i was looking for one of my user defined function, the misery is i forget its name( ... lazy developer habit), here is solution to my laziness.

SELECT name, id, xtype, uid, info, status, base_schema_ver, replinfo, parent_obj, crdate, ftcatid, schema_ver, stats_schema_ver, type, userstat, sysstat, indexdel, refdate,version, deltrig, instrig, updtrig, seltrig, category, cache

FROM sys.sysobjects

XTYPE =

‘U’ For table

‘PK’ For Primary Keys

‘F’ For Foreight Keys

‘V’ For views

‘P’ For stored procedures

‘TR’ For triggers

‘S’ For system objects

‘FN’ Function

It searches for all database objects.