Comments by sunil mali

sunil mali 22-Jun-18 8:28am View

Wow.. Thank you so much, You are a true star, Can you please help me with some link where i can learn pivotes in deep.

sunil mali 17-May-18 5:44am View

I need help badly as i am getting this type of request again and again and i am failing badly.

sunil mali 17-May-18 5:41am View

If you have a look at my output table you will understand what i am trying to say.
I cannot execute logic as per your suggestion as it would end up creating lakh of columns.

sunil mali 17-May-18 5:39am View

Let me explain you the logic in detail.
1. One account can have multiple gst numbers.
2. GST number tagged against Account1 will not be there for Account2

As per your suggestion you want me to create columns based on GST Numbers, so if there are 100000 gst numbers, i have to create 100000 gst columns.
I don't want that,
WHat i want is if Acount1 has 3 gst numbers then data will come only in column1, column2 & column3
If Account2 has 2 gst numbers then data will come only in Column1 & Column2
If Account3 has only 1 gst number then data will come in only column1.
if Account4 has 10gst numbers then output table should have column1...column10
and each column should have different gst numbers.

sunil mali 2-May-18 9:07am View

Hi Rajat,
Thank you so much for the explaination,
But there was problem in my explaination of the question i have updated the question, can you please look back and get back to me.

sunil mali 30-Apr-18 6:53am View

I am having problem with the column names as my columns are not fixed like,
GST1, GST2, GST3, GST4
This could have any value,

SELECT * FROM
(select AccountNo, GSTNumber from source) src
PIVOT
(
MAX(GSTNumber)
FOR GSTNumber in (select GSTNumber from source)
) as pvt

i want to use select query inside (in) like above. but its not working.

sunil mali 13-Feb-18 0:17am View

Thank you so much sir..

sunil mali 9-Feb-18 4:03am View

Exact output as per my expectation :) 5/5
Thank you so much..

sunil mali 4-Dec-17 8:16am View

That's okay sir, I understood what you wanted to say.
So the message was conveyed. :)

sunil mali 29-Nov-17 5:10am View

Its working now i just removed new keyword from your solution, i know it's typo because you have explained in your solution.
Thank you so much.
Also thanks for the explanation as to what is causing the issue.

sunil mali 29-Nov-17 5:06am View

Hello Sir,

Code is giving error as,
op is a variable but used like type.

Please suggest.

sunil mali 21-Nov-17 2:00am View

I am done the error while eager loading was because of namespace(System.Data.Entity)
Thank you so much Richard your Answer was very helpful.
Also references suggested by you were very useful. Much Appreciated, Thank you once again.

sunil mali 21-Nov-17 1:50am View

Thank you sir,
Lazy loading worked perfectly in my case.
I tried eager loading but it gave error on line .Include(p => p.Role) (Cannot convert lambda expression to type string because it is not a delegate type.)
Can you please help.

why are you re-inventing the wheel? ASP.NET has several perfectly good authentication systems built-in - for example,
[Sunil]This is just a demo project which i want to try before starting with the Actual project so that i don't get stuck when i am working on real environment.

sunil mali 27-Aug-16 5:55am View

I dont want to use ReadPast as, i have to change my entire website queries.
Is there any way or Transaction Isolation Level using which i can enable select when insert is happening?

sunil mali 9-Feb-16 2:37am View

Hi Chill60,
Thanks for the quickest solution.
Your first solution is working fine but second one is not working and giving me expected results can you please try to correct it.
I have already accepted your solution.
But it would be great if you can make second query work as it looks optimized.

sunil mali 27-Jul-15 7:55am View

public static void AddValueToSqlParameter(ref SqlParameter _param, string ParamName, object ParamValue,
SqlDbType _dbType, int _Size,ParameterDirection Direction)
{

if (ParamName == "" && ParamName == null)
{
throw new ArgumentException("No Parameter Specified");
}
else
{
if (_Size == 0)
{
_param = new SqlParameter(ParamName, _dbType);
}
else
{
_param = new SqlParameter(ParamName, _dbType, _Size);
}
_param.Direction = Direction;
}
_param.Value = ParamValue;
}

public static DataTable ExecuteSelectQuery(string procedure_Name, ref SqlParameter[] Param, String ConnString)
{
SqlDataAdapter da;
DataTable dt = new DataTable();
SqlConnection con = new SqlConnection(ConnString);

try
{
if (procedure_Name != "")
{
con.Open();
da = new SqlDataAdapter(procedure_Name, con);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
if (Param != null)
{
foreach (SqlParameter Params in Param)
{
da.SelectCommand.Parameters.Add(Params);
}
}
da.Fill(dt);
da.Dispose();
}

}
catch (SqlException ex)
{
throw ex;
}
catch (Exception ex)
{

throw new ArgumentException(ex.Message);
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}

}
return dt;
}

sunil mali 8-Jun-15 9:59am View

Ok Sure,
I will break this and have it properly questioned in another post.

sunil mali 7-May-15 7:38am View

Even i am having same issue. Menus doesn't work in IE 10 . Even if i put metatag it doesn't work. Have you found any solution for this bug??

sunil mali 16-Apr-15 3:01am View

Thanks Jorgen & Maciej for your precious time..

sunil mali 16-Apr-15 2:59am View

I read your comment.. My requirement is as mentioned by Jorgen..

sunil mali 16-Apr-15 2:49am View

Yes Jorgen you are right
Thanks you understood my problem correctly.

sunil mali 15-Apr-15 10:06am View

select * from Location where Convert(varchar(20),dtTime,106)=Convert(varchar(20),getdate(),106)
and DTL_Status in('SC','NI')

sunil mali 20-Mar-15 2:57am View

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Regex to allow special characters, spaces and alphanumeric</title>
<script type="text/javascript" src="http://code.jquery.com/jquery-1.8.2.js"></script>
<script type="text/javascript">
$(function() {
$('#btnValidate').click(function() {
var txt = $('#txtdesc').val();
var re = /^[A-Za-z0-9_@./#&+-]*$/
if (re.test(txt)) {
alert('Valid Text')
}
else {
alert('Please Enter Valid Text');
return false;
}
})
})
</script>
</head>
<body>
<div>
Enter Text :<input type="text" id="txtdesc" />
<input type="button" id="btnValidate" value="Validate" />
</div>
</body>
</html>

Include extra characters which you need in regex

sunil mali 31-Dec-14 0:42am View

Hello sir,

I have added comment below.
Please check and let me know if u can help me with it.

sunil mali 30-Dec-14 0:23am View

I want count for last three days based on days.
Example yesterday with Status A 100 records
day before yesterday with status B 200 records
so on..

sunil mali 30-Dec-14 0:16am View

Hello sir,

I dont want to get data for last three days.
My requirement is display count of records based on last 3 dates.
Ex. (T-1), (T-2), (T-3)
I want total records present for last three days
records should be based on dates.

Ex.

<pre lang="c#">Id dtTime Status
1 29/12/2014 A
2 29/12/2014 A
3 29/12/2014 A
4 29/12/2014 A
5 28/12/2014 B
6 28/12/2014 B
7 28/12/2014 B
8 28/12/2014 B
8 28/12/2014 B
9 27/12/2014 C
10 27/12/2014 C
11 27/12/2014 C
12 27/12/2014 C
12 27/12/2014 C
12 27/12/2014 C</pre>

ouput:
//4 records on 29 with status A
<pre lang="vb">29/12/2014 4
//5 records on 28 with status B
28/12/2014 5
//6 records on 27 with status C
27/12/2014 6</pre>

This is my dashboard data where i want to display total count of records with particular status based on date.
right now i want T-1(1day before), (T-2) and (T-3) data.

query i wrote is as below..
But below query is using 3 select statement on same table.
Because its same table queried 3 times i want to optimize this query.
<pre lang="sql">(select count(*) from Customer um where (select CONVERT(varchar(20),dtTime,101))=CONVERT(varchar(20),(GETDATE()-1),101) and
um.[Status]='A') as T_1,
(select count(*) from Customer um where (select CONVERT(varchar(20),dtTime,101))=CONVERT(varchar(20),(GETDATE()-2),101) and
um.[Status]='B') as T_2,
(select count(*) from Customer um where (select CONVERT(varchar(20),dtTime,101))=CONVERT(varchar(20),(GETDATE()-3),101) and
um.[Status]='C') as T_3

sunil mali 30-Dec-14 0:16am View

Deleted

Hello sir,

I dont want to get data for last three days.
My requirement is display data based on dates.
Ex. (T-1), (T-2), (T-3)
I want total records present for last three days
records should be based on dates.

Ex.

<pre lang="c#">Id dtTime Status
1 29/12/2014 A
2 29/12/2014 A
3 29/12/2014 A
4 29/12/2014 A
5 28/12/2014 B
6 28/12/2014 B
7 28/12/2014 B
8 28/12/2014 B
8 28/12/2014 B
9 27/12/2014 C
10 27/12/2014 C
11 27/12/2014 C
12 27/12/2014 C
12 27/12/2014 C
12 27/12/2014 C</pre>

ouput:
//4 records on 29 with status A
<pre lang="vb">29/12/2014 4
//5 records on 28 with status B
28/12/2014 5
//6 records on 27 with status C
27/12/2014 6</pre>

This is my dashboard data where i want to display total count of records with particular status based on date.
right now i want T-1(1day before), (T-2) and (T-3) data.

query i wrote is as below..
But below query is using 3 select statement on same table.
Because its same table queried 3 times i want to optimize this query.
<pre lang="sql">(select count(*) from Customer um where (select CONVERT(varchar(20),dtTime,101))=CONVERT(varchar(20),(GETDATE()-1),101) and
um.[Status]='A') as T_1,
(select count(*) from Customer um where (select CONVERT(varchar(20),dtTime,101))=CONVERT(varchar(20),(GETDATE()-2),101) and
um.[Status]='B') as T_2,
(select count(*) from Customer um where (select CONVERT(varchar(20),dtTime,101))=CONVERT(varchar(20),(GETDATE()-3),101) and
um.[Status]='C') as T_3</pre>
Please help me with this.

sunil mali 5-Nov-14 1:07am View

Ok Sure thanks..

sunil mali 3-Sep-14 1:15am View

I have already shared source code of activex.
My purpose is to create activex and consume it on client side using javascript.
I trigger my activex from javascript get it registered and once registered i consume methods from my activex.
In future methods can be anything.
right now its hello world message.

Its a working code. It works in my system as well as in client system also.
Only problem is when i install dotnet 3.5 it doesn't work.
But if i install 4.0 it works.

I refered below article and some more from various website to create activex
http://www.codeproject.com/Articles/24089/Create-ActiveX-in-NET-Step-by-Step

sunil mali 2-Sep-14 8:16am View

Hi Sergey,

I have updated code, please check and let me know incase of any mistakes.
Please note: This ActiveX works if i install .net 4.0 .
But if i install dotnet 3.5 it doesn't work.

This code is built in dotnet 3.5 but even though i have to use dotnet 4.0 to run this.

sunil mali 1-Jul-14 2:54am View

Thanks

sunil mali 24-Mar-14 2:30am View

Is there somethng i need to do with this.

sunil mali 24-Mar-14 2:29am View

Hi Sir,

Sorry for Wrong Statement Its Total Server Running 5 databases.
Below that i gave my server configruation to check if something wrong with server.

I get timeout error whenever there is complex query gets executed.
My App server and DB Server is seprate.

internal static DataSet ExecuteDataSet(string CommandText, CommandType CommandType, SqlParameter[] SqlParam)
{
try
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString))
{
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandText = CommandText;
cmd.CommandType = CommandType;
//cmd.Transaction = trans;

if (CommandType == System.Data.CommandType.StoredProcedure)
{
if (SqlParam != null)
{
foreach (SqlParameter param in SqlParam)
{
cmd.Parameters.Add(param);
}
}

}

da.SelectCommand = cmd;
da.Fill(ds);
}

return ds;
}

}
catch (Exception ex)
{
ex.Message.ToString();
return null;
}
finally
{
}
}

sunil mali 11-Mar-14 6:15am View

Hi tommie,

Thanks for sharing.
I have my own functionalities which i want to build in activex and later want to use in my code.
I checked resources shared by you, but its not creating activex anywhere.
Or its not even doing any functionalities using activex component.
Please correct me if i am wrong.
Resources shared by you is using existing functionalities built by a product.
Anyways thanks again for sharing.

sunil mali 27-Feb-14 8:59am View

Somebody please help

sunil mali 17-Feb-14 0:13am View

Hello sir,

First link doesn't have activex registration through setup or using of cab file to install in ie.
This will not help me
and i tried second link with .cab file which i have but no results.

Browser pops me for opening .cab but after that it doesn't ask for setup installation.

sunil mali 13-Jan-14 4:18am View

I tried researching before but i was getting help on earlier versions of vs and installshied.
With new version of installshield i am not able to find accurate solution.
Ok Thanks i will try and check out if i can get something.

sunil mali 11-Jan-14 7:02am View

Thanks i got my answer my command was wrong
it looks like it should be extension .ini instead of .inf.
In blog its written as .inf.

sunil mali 20-Sep-13 5:47am View

it is hanging on read
serverStream.Read(inStream, 0, (int)clientSocket.ReceiveBufferSize);

after some time it returns back but its empty...

sunil mali 20-Sep-13 5:47am View

No yaar this didn't work.

sunil mali 20-Sep-13 5:08am View

when i do it through telnet i have to press ctrl+s to end string and get resonse back.
how do i write CRLF for ctrl+s any idea.

sunil mali 20-Sep-13 3:34am View

i think i should give up now...
very less posts on blogs...
no help on internet...
thanks everyone for helping...

sunil mali 20-Sep-13 2:00am View

it is hanging on read
serverStream.Read(inStream, 0, (int)clientSocket.ReceiveBufferSize);

after some time it returns back but its empty...

sunil mali 20-Sep-13 1:59am View

i tried utf8 also...
the line where it reads from serverstream... it gets hanged there...

sunil mali 19-Sep-13 7:48am View

on below line my application is getting hanged.

serverStream.Read(inStream, 0, (int)clientSocket.ReceiveBufferSize);

sunil mali 19-Sep-13 7:21am View

I tried still same issue..
in command prompt if i type
telnet ip port
message
ctrl+s
it gives me response.. here ctrl+s acts as terminator of message ...
how do i adapt this in my code...
because my code keeps on waiting for response...

sunil mali 19-Sep-13 1:44am View

somebody please help...

sunil mali 19-Sep-13 0:11am View

Sir Please tell me how to Do it...
I have very limited knowledge in socket programmimg..
Best part is i created a client and server on local it works fine, it sends and receives a response...
But i am not able to comm. With my socket server running on cliet's machine..

sunil mali 19-Sep-13 0:07am View

No exceptions sir..
It connects... sends a message and keeps on waiting..
And after some time it ends up by terminating connection.

sunil mali 12-Sep-13 3:56am View

no...
Hello all,

I created hidenn field in jquery ande allocated dropdown text to hidden field

Collapse | Copy Code
$('[id$=ddlCountry]').change(function () {
var selectedOption = $("#ddlCountry option:selected").text();
$("<input/>", { type: 'hidden', name: 'CountryName' }).val(selectedOption).appendTo("form");

alert("Handler for .change() called.");
});

In code behind
i used
Response.Write(Request["CountryName"]);

To read hidden field text
so i got text in my codebehined.
Thanks everyone for participating.

Regards,
SUNIL

sunil mali 12-Sep-13 3:51am View

still we cannot read this value in c#
i found a solution

sunil mali 11-Sep-13 5:23am View

Sorry for late reply...
was on leave due to ganeshotsav...

sunil mali 11-Sep-13 5:23am View

Hello sir,
you are right i am using ajax webmethods to get data in dropdownlist\
its jquery + json which is doing this for me.,.

sunil mali 11-Sep-13 5:20am View

compare ?? how?

sunil mali 10-Sep-13 4:14am View

it gives me null.

sunil mali 10-Sep-13 3:53am View

my dropdownlist is html control.
it will not work this way

sunil mali 10-Sep-13 3:46am View

Sir i want to fetch it in my c# code

sunil mali 7-Sep-13 8:54am View

null

sunil mali 2-Aug-13 6:50am View

yes i did so many times during project creation.
my code works...
only the problem is it jumps to metadata instead of actual code.

sunil mali 2-Aug-13 6:33am View

Deleted

This code is in my presentation layer

public void GetMenu(){
Handler mh = new Handler();
DataSet ds = mh.GetMenu(mm);
}

here in this case

This code is in my Business layer

public class Handler
{
public DataSet GetMenu(MenuMaster mm)
{
return DbAc.get_Menu(mm);
}
}

This code is in my Data layer

public DataSet get_Menu(MenuMaster sm)
{
SqlParameter[] ParamList = new SqlParameter[2];

ParamList[0] = new SqlParameter("@Id", SqlDbType.VarChar, 50);
ParamList[0].Value = sm.ID;

ParamList[1] = new SqlParameter("@GroupId", SqlDbType.VarChar);
ParamList[1].Value = sm.GroupId;

return SqlDBHelper.ExecuteDataSet("getMenu", CommandType.StoredProcedure, ParamList);
}

if i right click on GetMenu function and try to click on go to code defination, its taking me to metadata not actual code

sunil mali 17-Jul-13 8:50am View

Uff i just missed that line where it says ACCESS DB...

sunil mali 17-Jul-13 8:08am View

No sir,
Its not working in my case.
My Old Pdf in cache is not getting cleared.

sunil mali 16-Jul-13 6:04am View

hi sir,
can u please tell which library i should use?

sunil mali 15-Jul-13 7:14am View

Oh sorry i misunderstood...
It worked. :)
Thanks a lot.

sunil mali 13-Jul-13 6:58am View

where doesnt work in left join.

sunil mali 13-Jul-13 5:30am View

My scanId column is in UploadMaster table which is in from Clause
Thats why i wrote (and um.ScanId=10071351010004) at the end of my query

sunil mali 10-Jul-13 1:12am View

Thanks It works.. :)

sunil mali 10-Jul-13 1:12am View

Thanks It works.. :)

sunil mali 10-Jul-13 1:11am View

not worked

sunil mali 1-Jul-13 9:06am View

sure i will try and let u know

sunil mali 1-Jul-13 9:05am View

i have a situation where i have to replace my existing file...you are telling me some solution where i can delete and create new one...
please send me code so that i can give one try....

sunil mali 1-Jul-13 7:56am View

Sir, Read write permission is their for that folder... thats why i am able to write,
is their something called overwrite permission if yes then let me know so that i can tell my network admistrator...

sunil mali 1-Jul-13 7:55am View

No sir its not even throwing exception....
and yes i replied against sushil's comment....

sunil mali 1-Jul-13 7:22am View

Deleted

Sir, Read write permission is their for that folder... thats why i am able to write,
is their something called overwrite permission if yes then let me know so that i can tell my network admistrator...

sunil mali 26-Jun-13 3:46am View

Thank you so much sir..

sunil mali 26-Jun-13 3:46am View

Thank you so much sir...

sunil mali 20-Jun-13 1:22am View

this is my one query which is giving me sum of columns from single table
select SUM(wp.CapacityAlloc) as CapacityAlloc,SUM(wp.QC1Comp) as QC1Pending,(SUM(wp.CapacityAlloc)-SUM(wp.QC1Comp)) as QC1Completed,
SUM(wp.DEComp) as DEPending, (SUM(wp.CapacityAlloc)-SUM(wp.DEComp)) as DECompleted,
SUM(wp.QC2Comp) as QC2Pending , (SUM(wp.CapacityAlloc)-SUM(wp.QC2Comp)) as QC2Completed from WorkProgress wp where wp.BBId=@BBId

My 2nd query is this one
select
count(dm1.Id) as DiscrepancyRaised,count(dm2.Id) as DiscrepancyClosed,COUNT(sm1.Id) as Failed,COUNT(sm2.Id) as Success,COUNT(sm3.Id) as UW
from WorkProgress wp, DiscrepencyMaster dm1,DiscrepencyMaster dm2,UploadMaster um,StatusMaster sm1,StatusMaster sm2,StatusMaster sm3
where dm1.UploadId=um.Id and um.EmpId in(select um.EmpId from LoginData where BBId in(select BranchId from Branch_BPO_Mapping bbm where bbm.BPOId=@BBID)) and dm1.Status='Open'
and dm2.UploadId=um.Id and dm2.Status='Closed' and sm1.Status='Fail' and sm2.Status='Success' and sm3.Status='UW'

Both are giving me correct result...
If i have to combine these two queries then as per your logic
i have to write select statement for each column even if it is from same table

select((select SUM(wp.CapacityAlloc) as CapacityAlloc from WorkProgress wp where wp.BBId=@BBId),(select SUM(wp.QC1Comp) as CapacityAlloc from WorkProgress wp where wp.BBId=@BBId) vice versa...

as you can see i am writing select for each column and i am finding sum of it.
my moto is very straight forward...
i have two select statement, first statement is giving me correct result that is also with one where clause.. and one from clause....combining these two queryies will increase performance of my query i dont know how to do it... but i think there might be a way to do it...
i hope i am clear...

sunil mali 20-Jun-13 1:11am View

Deleted

I have this kind of query

declare @BBId int
set @BBId=6
declare @DocScanned int
set @DocScanned=(select count(Id) as DocumentScanned from UploadMaster where EmpId in(select EmpId from LoginData where BBId in(select BranchId from Branch_BPO_Mapping where BPOId=@BBID)))

select @DocScanned as DocScanned,SUM(wp.CapacityAlloc) as CapacityAlloc,SUM(wp.QC1Comp) as QC1Pending,(SUM(wp.CapacityAlloc)-SUM(wp.QC1Comp)) as QC1Completed,
SUM(wp.DEComp) as DEPending, (SUM(wp.CapacityAlloc)-SUM(wp.DEComp)) as DECompleted,
SUM(wp.QC2Comp) as QC2Pending , (SUM(wp.CapacityAlloc)-SUM(wp.QC2Comp)) as QC2Completed,
count(dm1.Id) as DiscrepancyRaised,count(dm2.Id) as DiscrepancyClosed,COUNT(sm1.Id) as Failed,COUNT(sm2.Id) as Success,COUNT(sm3.Id) as UW
from WorkProgress wp, DiscrepencyMaster dm1,DiscrepencyMaster dm2,UploadMaster um,StatusMaster sm1,StatusMaster sm2,StatusMaster sm3
where wp.BBId=@BBId and
dm1.UploadId=um.Id and um.EmpId in(select um.EmpId from LoginData where BBId in(select BranchId from Branch_BPO_Mapping bbm where bbm.BPOId=@BBID)) and dm1.Status='Open'
and dm2.UploadId=um.Id and dm2.Status='Closed' and sm1.Status='Fail' and sm2.Status='Success' and sm3.Status='UW'

sunil mali 20-Jun-13 1:07am View

If this is the only way to do it then yes i should accept your answer.....

sunil mali 19-Jun-13 14:01pm View

Sir your answer is right, at first i was planning to do same as you suggested.. but i had lot of queries... which were combination of sum and count from multiple tables.... then i thought of joining this select queries... because result of my each query was one row... i am looking for kind of join here because result of my each query is single row... i dont know whther it is possible or not... i am just trying to find different ways of doing it to reduce my code....

sunil mali 19-Jun-13 12:38pm View

I dont have any relationship between these tables,
It is just a report which shows count from different tables
My motive is just to reduce code... as i m howing count of multiple tables in single page..

sunil mali 31-May-13 5:06am View

This will not work as i don't know total parameters. It can be two,three or more than that.

sunil mali 25-May-13 8:39am View

Deleted

i want to get value of my textbox to DateTime dt.
how do i do that?

sunil mali 20-May-13 9:41am View

I want to add 1 day, not in currrent date, i want to add it in date which is in one of my textbox.

sunil mali 3-May-13 9:12am View

Thanks bhushan this is what i want...Thanks :)

sunil mali 3-May-13 8:56am View

Hii bhushan,

This will add item text property and value property as --Select--
i also want to give some value property to same item lets say 12 as value to this item

ex:-
it should display
droplst.SeletedItem.text should give me --Select--
and droplst.selectedValue.text should give me 12
Improve solution Permalink Posted 2 secs ago
sunil_mali1.1K

sunil mali 26-Apr-13 4:01am View

ohh... i thought, i had so many doubts together, so it might create unecessary garbage there.. okk i will do that.

sunil mali 26-Apr-13 4:00am View

hello sir,
It was not mean't to Shout, i thought my subject is small so i should write it in capitals, i didn't know capital means shouting, i didn't mean that at all, still if you feel i was shouting, then sorry for that.

sunil mali 30-Mar-13 2:40am View

Also if you have any product, which i can use for non commercial purpose... Your suggestions are always welcome..

sunil mali 29-Mar-13 8:52am View

Javascript is the only way using which we can access client's drive... Because javascript is client side library...
i have found one links like
https://www.bytescout.com/products/developer/pdfgeneratorsdkjs/index.html
but i am not able to use it, because i am not able to understand where to start....

I know i can achieve it, as whatever doubts i had till this date i have solved everything...At the end of this blog definately i have one or other way to achieve this...
just looking for someone right who can answer....

sunil mali 29-Mar-13 8:06am View

i am not looking for anything new sir, i used dynamic web twain for saving images to my local machine, now i want those saved image to be converted into pdf, Converting saved images to pdf feature is not there in dynamic web twain. Thats why i am looking for some javascript snippet for this....

sunil mali 22-Mar-13 2:21am View

Thank you all,
Shubham sir and aspnet_regiis sir,
With the help of my network administrator i configured smtp on one of our machine.
He gave me one ip address and i used it for sending email....
its sending emails... no limitations(as if u send it via gmails server u can send only 500 emails in a day)... and from gmail account only... . its sending through my servers iis smtp.... i can write any email as sender and send it to anybody i want... and password too....
so i achieved my task of sending emails to them.... obviously your help triggered me of running smtp on one of our server... i got static ip from them... and i sent email through code...
Thank you all....

Regards,
SUNIL MALI.

sunil mali 19-Mar-13 3:58am View

Thank you so much Nitin.....
Perfect solution...I tried and it worked...
now i can give full stop to my task...
very good link thanks once again...

sunil mali 17-Mar-13 2:46am View

thanks prasad for editing my comment as i was not able to format it....Waiting for someone;s reply.

sunil mali 16-Mar-13 9:25am View

I hope my question is clear

sunil mali 7-Mar-13 2:49am View

Superb Solution sir....

i tried it like
SELECT ISNULL(T.UserId,0) from(select UserId from LoginTemp where UserId='005'
union all select NULL where not Exists(select 1 from LoginTemp where UserId='005'))T

its same but with my table
i marked it as answer but still if u can make it much more easier and less code it will be great...
Still thanks and great logic..
Thank you so much....

sunil mali 6-Mar-13 5:17am View

Hi GVPrabhu

i would have done it this way
but i have list of parmeters may be 40 to 50
and i cant do it for all like what you have done

is there a way where we can use case in select statement itself and get this output
i want something like this
i dont know if its possible
select (if exists(select empname from employe) else (select '0')),......
this becomes easier to get values... and i can use it for all my 50 parameters.

Thanks

sunil mali 6-Mar-13 1:43am View

I havn't tried yet, i need logic to build this kind of application. where simultaneous users cannot login at the same time. I am not using in build asp.net authentication mechanism,i am planning to do it through stored procedure still i will share my login code with you. which doesn;t have simultaneous users solution.

sunil mali 6-Mar-13 0:25am View

For me it will work like
select EmpName,fnGetEmployeeStatus(EmpId) as Status from Employee

So it will give result as
EmpName Status
SUNIL Cold
MAhesh hot

this statuses are dependent on how important this franchisee is...and so many factors.

sunil mali 2-Mar-13 6:41am View

Thanks for help... It helped me...

sunil mali 2-Mar-13 6:40am View

Superb Solution sir... Thank You very much...

sunil mali 11-Feb-13 1:23am View

Please mark it as answer if you are ok with it...

sunil mali 9-Feb-13 1:12am View

Yes add new page stylesheet and copy
body element as it is to your stylesheet
and then in your master page add link attribute in your head section
i mean to say inside your head tag... you just,try it seriously its very easy .... just for you i did this and posted in such easy way.....

sunil mali 13-Dec-12 6:42am View

hi friend,

i have tried your code, but this code is only working in ie, i am developing this solution to work on mobile and there are very less mobiles which has internet explorer inbuilt.
I think problem is with .htc file which you have provided with your code.
Do you have any other solution, your solution didn't worked for me as it works only on ie, and it was too complecated.

Calling Web Services from HTML Pages using JavaScript[^]

i checked above link, and it helped me a lot to run this solution
but i should make it run on all browsers because my application is mobile based.
can we do same think without .htc file?
do u have any other solution for same?
will it work on all devices and all browser?

sunil mali 7-Dec-12 6:26am View

Thanks for your reply,

but my trouble is i don't have file upload control in my page.
I just have one image control whose source is determined by jquery code..
i want to read file name from this image control or somehow i want to store image from image control to servers folder...
i don't know jquery i want to use csharp code for saving it.

again thanks for you reply... see if u can help me with this..

sunil mali 5-Dec-12 12:42pm View

Thanks bro...
your solution is nice but your solution has server side code and i want client side code. server side code has some disadvantages ex
1. Whatever image i upload, it will actually download on servers memory and then it will resize.
2. Downloading of image on server takes time if it is more than 2mb or 3mb
Thats what i want to save and it can be done only by using some clie.nt side script.

Comments by sunil mali (Top 106 by date)

This code is in my presentation layer

This code is in my Business layer

This code is in my Data layer