Comments by Mas11 - CodeProject

Mas11 18-Jul-17 4:00am View

yes.

Mas11 19-Feb-17 2:57am View

Not working, am using below query.

SUM({[CASE ASSIGNED COMMITTEE].[COMMITTEE ID].[id]},[Measures].[RDC CASES FACT Count])-
SUM({[CLOSED CASE COMMITTEE].[COMMITTEE ID].[id]},[Measures].[RDC CASES FACT Count])

Mas11 21-Jan-15 1:05am View

I really appreciated your answer that's why we have preview functionality where we can fix these types of stuff but the problem is that my manager is told me he needs this kind of functionality. If there is any way then please let me know. I'm using express PDF.

Mas11 5-Jun-14 2:40am View

Yes its not responce.

Mas11 21-May-14 2:38am View

thx a lot for your suggestion,

Mas11 19-May-14 3:40am View

thx a lot dear!

Mas11 19-May-14 3:40am View

THX A LOT IT WORK!

Mas11 12-Feb-14 9:14am View

Your Welcome :)

Mas11 6-Jan-14 7:19am View

Thanks ! your first method work perfectly.

Mas11 6-Jan-14 7:03am View

Below Method gives an error : Index and length must refer to a location within the string.
Parameter name: length

Mas11 3-Jan-14 7:31am View

Thanks, but I did so long before.

Mas11 16-Dec-13 0:40am View

Yes. Same view here

Mas11 5-Dec-13 5:36am View

great answer 5*..

Mas11 4-Dec-13 5:06am View

Can you please let me know in this sequence >> dir='<%# Session["dir"].ToString() %>'

Mas11 27-Nov-13 23:12pm View

Show me tour code.

Mas11 27-Nov-13 4:16am View

Hey drag some controls in panel then u'll see its visible or not.

Mas11 27-Nov-13 0:06am View

5*

Mas11 24-Nov-13 5:32am View

use ajax control UpdatePanel. First put Script Manager control at top of the page then put UpdatePanel & then put your Crystal report section under updatepanel.

Mas11 24-Nov-13 5:21am View

Put your crystal report section under update panel.

Mas11 24-Nov-13 5:20am View

@amir: Nice Comment >> i am in hurry really and i have no time to read a lot of documents

Mas11 4-Nov-13 6:48am View

Good Catch!

Mas11 29-Oct-13 9:01am View

@jackspero18 >> can u write your code please, what you write.

Mas11 20-Sep-13 5:03am View

Thanks !

Mas11 20-Sep-13 3:33am View

Yes, exactly.. Thanks a lot.

Mas11 20-Sep-13 3:09am View

Agree with you.

Mas11 20-Sep-13 0:16am View

My Vote of 5*.

Mas11 18-Sep-13 6:10am View

What kind of output you will get as per above solution.. Please post here.

Mas11 28-Aug-13 5:32am View

Thanks Sandeep for your answer.

Mas11 28-Aug-13 5:32am View

Thanks It works for me.. 5*..

Mas11 21-Aug-13 6:11am View

Nice answer Aarti ! 5*

Mas11 21-Aug-13 6:11am View

Nice Try !

Mas11 20-Aug-13 7:08am View

Thanks Dear!

Mas11 20-Aug-13 7:08am View

Thanks !

Mas11 20-Aug-13 2:12am View

Thanks Sandeep.

Mas11 20-Aug-13 2:11am View

Thanks a lot Ron!

Mas11 26-Jul-13 0:38am View

Please explain what confusion do you have.

Mas11 22-Jul-13 0:28am View

Have you read above question properly. He is beginner in WebService & for that its perfect link.

Mas11 19-Jul-13 6:00am View

Nice Answer !

Mas11 3-Jul-13 9:14am View

Actually its need of my application that user can go back to his 'previous search result' same as our browser work, when we click on back & forward arrow then it shows all the previous pages.

Mas11 27-Jun-13 9:53am View

I dn't know ! why people don't like ur answer but this is best one :) 5* for this.

Mas11 21-Jun-13 8:46am View

Ya, It's correct answer.

Mas11 21-Jun-13 8:02am View

Thanks dear ! its mine answer.. 5*++

Mas11 21-Jun-13 7:44am View

Deleted

Hi, Thanks for your effort but it doesn't get me the correct solution.

Mas11 14-Jun-13 3:24am View

Thanks !

Mas11 11-Jun-13 3:32am View

Hi ! Thanks for ur answer.

Mas11 11-Jun-13 3:32am View

Hi Hitesh ! Thanks for ur answer but it doesn't give me exact solution.

Mas11 6-Jun-13 7:58am View

Ya ! that's why I was suggest plz bind your data into <ul> <li> because all our Data control creates table structure. Second option is that you can create <tr><td> css for your DataList control.

Mas11 6-Jun-13 7:53am View

Change your client side date format as 'dd/MM/yyyy' & issue resolved !

Mas11 6-Jun-13 7:45am View

Hey plz bind your data in dynamic <ul><li>Your data </li></ul> link. Definitely it will solve your issue. I have done this before for adding category & subcategory.

Mas11 28-May-13 8:31am View

Really a good answer! Thanks a lot Aarti : )

Mas11 28-May-13 7:29am View

Thanks for the answer ! I got it.

Mas11 16-May-13 9:52am View

ya ! You are.

Mas11 16-May-13 4:53am View

Wonderful Abdul ! You creates smile on my face. Good job bro & its mine answer.

Mas11 16-May-13 0:39am View

Thanks for your answer but its not that one which I m looking for.

Mas11 16-May-13 0:36am View

No, Is it not full text search. It is, If user write single letter like 'j' as above mentioned example, then all the search comes which has 'j' letter first. But if user write some proper word like ('jeans','Phone') then it show result on the basis of these word in all the column where it get these word.

Mas11 15-May-13 6:04am View

then plz accept that solution as ur answer !

Mas11 15-May-13 4:48am View

Please read my question properly !

Mas11 14-May-13 5:44am View

Can you please write code as per my code scenario, because I tried your solution but doesn't reach to run it.

Mas11 13-May-13 9:17am View

Cannot get inner content of div_images because the contents are not literal

Mas11 17-Apr-13 2:46am View

Ya, but I haven't an idea regarding this. For this I was using loop for count row, then bind to that column(lengthy process). SO I'm posting here!

Mas11 17-Apr-13 2:39am View

Hi, Aarti you are genious in SQL, You help me lots of time in SQL. Thanks CodeProject for providing such wonderfull blog ! :)

Mas11 16-Apr-13 3:23am View

Thanks ! Its mine answer. :)

Mas11 16-Apr-13 2:54am View

Thanks for the answer, but it doesn't work.

Mas11 12-Apr-13 5:13am View

Wonderful my brother ! It works for me. I have done some minor changes in it. But finally this is the solution. I want to mark it as 100 mark but 5 is max limit. Cheers dear :)

Mas11 11-Apr-13 9:34am View

Really Apologize ! Plz see updated question.

Mas11 11-Apr-13 9:33am View

Apologize ! Plz see updated question.

Mas11 11-Apr-13 9:27am View

Plz see in solution 2 for the detail.

Mas11 11-Apr-13 9:26am View

Actually In Result column: "TotalWIshedBy" is the sum of the wish which is also liked by other userid (takes data from tbl_commonwish) & UserID (it is the wish written by UserID > Takes data from tbl_wishlist)

Mas11 11-Apr-13 9:17am View

Thanks for the answer, but it doesn't provide a solution.

Mas11 11-Apr-13 9:09am View

No, I have updated, plz chk.

Mas11 11-Apr-13 9:04am View

plz see, updated info.

Mas11 5-Apr-13 8:10am View

Same view here !

Mas11 4-Apr-13 3:14am View

Thanks Abhinav ! It means I was right.

Mas11 4-Apr-13 2:45am View

Thanks Abhinav for the answer. Please light over that in upper scenario my TL told me that hashtable takes minor memory on the server (suppose 500 kb) rather than one by one (suppose 3MB).

Mas11 2-Apr-13 7:12am View

Ya, I know! but I was using: Authenticate_User(userid, pass) many time & its really hard to change the code. Do you have any idea regarding type cast string into htmlinput.

Mas11 25-Mar-13 10:00am View

Thanks Ryan I'll try by this. But any suggestion over my given code.

Mas11 25-Mar-13 9:51am View

Hi Raje_ I have created web Service for this but how could I Call this on Textbox. Really appreciate your suggestion.

[System.Web.Services.WebMethodAttribute(), System.Web.Script.Services.ScriptMethodAttribute()]
public static string[] GetCompletionList(string prefixText, int count, string contextKey)
{
SqlConnection conn;
SqlCommand cmd;
string cmdString = "select userID from tbl_Registration where userID = '" + prefixText + "'";
conn = new SqlConnection(ConfigurationManager.AppSettings["mas"]);
cmd = new SqlCommand(cmdString, conn);
conn.Open();
SqlDataReader myReader;
List<string> returnData = new List<string>();
myReader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (myReader.Read())
{
returnData.Add(myReader["userID"].ToString());
}
return returnData.ToArray();
}

Mas11 19-Mar-13 7:32am View

Nice Code ! worked for me :)

Mas11 18-Mar-13 6:44am View

5* for it !

Mas11 18-Mar-13 6:44am View

5* for it!

Mas11 18-Mar-13 6:44am View

Ya exactly Nitin ! Sometimes I makes a silly mistakes. Anyway thanks a lot guys for your support :)

Mas11 18-Mar-13 6:39am View

Ohh sh*t ! Thanks a lot I got it..

Mas11 18-Mar-13 6:34am View

Thanks for the answer! Now I know that after running your code that there was no control added in placeholder. But see in my code I was added it in the code : "PlaceHolder1.Controls.Add(ChkboxList)"

Mas11 18-Mar-13 6:15am View

Please look on updated code !

Mas11 11-Mar-13 8:51am View

Thanks GV it also works. 5*..

Mas11 11-Mar-13 8:51am View

Nice Bhusan ! It works. Actually i dn't know that distinct works in case of count.
5 * for this !

Mas11 11-Mar-13 7:49am View

Thanks Imtiyaz it works ! NIce job bro.
5* for it.

Mas11 11-Mar-13 7:45am View

Deleted

Some format error !

Mas11 5-Mar-13 3:33am View

Thanks for the answer ! but it show some format error.

Mas11 19-Feb-13 23:33pm View

Thanks !

Mas11 19-Feb-13 6:25am View

Deleted

Hi Griff thanks for your answer. One thing I am clearing here I am not asking for the transaction code. I am already using Paypal & thats a very secure for this.

Mas11 19-Feb-13 6:21am View

Actually, Its need of my project that's we can deduct some money from user ($3 charge). This could be only happened when we know the deduct money is available in his account.

Mas11 19-Feb-13 1:15am View

Please pass ValidationExpression="[1-9]*" in your "Regular Expression Validator" property field.

Mas11 13-Feb-13 23:39pm View

Nice Answer ! My 5*

Mas11 13-Feb-13 1:41am View

Thanks for your answer.

Mas11 31-Jan-13 7:34am View

Dear its very common error. If u r not aware of that then there is no means to blame Mantu !. First read data type properly then ask such kind of basic question.

Mas11 25-Jan-13 4:46am View

Nice answer !

Mas11 2-Jan-13 6:47am View

Hi Zafar, Thanks for the reply. So in this way windows services is only an option. If there is any other trick then let me know.

Mas11 17-Dec-12 4:05am View

Exactly !!

Mas11 9-Dec-12 2:01am View

Thanks a lot !!.

Mas11 6-Dec-12 1:00am View

Thanks for the answer.

Mas11 6-Dec-12 0:59am View

Thanks Aarti, but now i got the solution actually my datatype is nvarchar, so it create a problem. Now i change this into datetime & problem solve. Thanks for your support.

Mas11 6-Dec-12 0:45am View

I hope in this way i have to do big changes in my database. There is 20000 record & date comes mm/dd/yyyy format (as per my need it has to be same format). But according to your query i have to convert this in yyyy/mm/dd. There is any other solution rather then converting this.

Mas11 4-Dec-12 10:35am View

Thanks for reply !!

Mas11 4-Dec-12 7:23am View

Hey guys i have solved this..

Mas11 12-Nov-12 6:33am View

Good Answer !

Mas11 31-Oct-12 5:17am View

not worked bro !!

Mas11 16-Oct-12 4:28am View

Very nice!!, thanks bro for your logic.

Mas11 12-Oct-12 7:52am View

Thanks bro !! for such great & valuable information. But in my case (above question) it would be possible. If yes then please share to me.

Mas11 12-Oct-12 7:42am View

Hi nelek, if you dont mind . My question doesn't make any sense?

Mas11 11-Oct-12 0:38am View

Write your code here, that's why we can check & find solution.

Mas11 9-Oct-12 8:47am View

Thanks Sandip for your response. I want to send html markup of the registration page to another page. But how ? In querystring its bit diffult to define id for each & etc. There is any direct method for this?

Mas11 9-Oct-12 8:47am View

Thanks gladiatron for your response. Yes you are right i want to send html markup of the registration page to another page. But how ? In querystring its bit diffult to define id for each & etc. There is any direct method for this?

Mas11 9-Oct-12 8:44am View

Thanks a lot for your valuable information.

Mas11 20-Sep-12 1:37am View

Thanks a lot !!.

Mas11 20-Sep-12 1:36am View

Wonderfull aarti, u glad me a lot.. Thanks for ur answer.

Mas11 14-Sep-12 8:45am View

when i logged in site, and stay for some time then it automatically logged out.

Mas11 14-Sep-12 8:45am View

when i logged in site, and stay for some time then it automatically logged out.

Mas11 14-Sep-12 8:25am View

when i logged in site, and stay for some time then it automatically logged out.

Mas11 11-Sep-12 2:02am View

wonderfull my bro !!.. Thanks a lot. It works & run me so fast. Thanks for your cooperation.

Mas11 9-Aug-12 4:54am View

Okk Thanks.. I suggest to my client that he upgrade his database to SQl 2008-R2. thanks a lot for your valuable answer.

Mas11 9-Aug-12 4:27am View

But "SQL Server 2008 R2" is higher version than "SQL Express-2008". And in MS-SQL we can't get data from Higher version to Lower. I search over this & get the same answer.

But Philip are you confirm that a .BAK file from SQL-2008 R2 is accepted by
SQL Express 2008.

Mas11 29-Jul-12 23:58pm View

Good answer..

Mas11 13-Jul-12 6:18am View

ya i know, but i want to solve this by asp.net code. Means i upload .csv file & on click of Button Control It(.csv data) save to sql database.

Mas11 10-Jul-12 5:29am View

okk.. Thanks for answer.. But i think the code is right plz check it

try {
string requestedDomain = HttpContext.Current.Request.Url.ToString().toLower();

if (Strings.InStr(requestedDomain, "http://yoursite.com")) {
requestedDomain = requestedDomain.Replace("http://yoursite.com", "http://www.yoursite.com");

Response.Clear();
Response.Status = "301 Moved Permanently";
Response.AddHeader("Location", requestedDomain);
Response.End();

}

} catch (Exception ex) {
Response.Write("Error in Global.asax :" + ex.Message);
}

Mas11 6-Jul-12 7:10am View

Thanks !! nice answer

Mas11 6-Jul-12 6:48am View

Thanks a lot bro.. It worked

Mas11 2-Jul-12 8:58am View

I Mean .Net Framework 4.0

Mas11 2-Jul-12 6:50am View

Manas Thanks for answer, But i dn't get answer from that link.

Mas11 29-Jun-12 1:49am View

OKK..

Mas11 29-Jun-12 1:40am View

Yes.. Now its exact solution !!

Mas11 29-Jun-12 1:39am View

Thanks a lot for your reply bro !!

Mas11 29-Jun-12 1:38am View

Sorry my bro.. Wonderfull.. It worked.. Really i am smiling.. Again Thanks a lot..

Mas11 29-Jun-12 1:34am View

Thanks for answer but it doesn't work.

Mas11 29-Jun-12 1:34am View

It Doesn't work ashish !!

Mas11 28-Jun-12 5:27am View

Thanks abhinav!!

Mas11 27-Jun-12 3:45am View

Thanks a lot for your responce. I have solved this.

select '$' + CONVERT(VARCHAR(10), CAST(ROUND(expenses.hours*expenses.rate , 2) as DECIMAL(18,2))) as Total

Mas11 27-Jun-12 3:36am View

Ok, Thanks a lot Griff, but this query show result in this way ($112.123) & i want decimal up to 2 digit ie. $112.12. How can we add decimal up to 2 digit in this query. i write this but it doesn't work. Kindly help me where i does mistake.

SELECT '$' + CONVERT(CAST(ROUND(expenses.hours*expenses.rate , 2) as DECIMAL(18,2))) as Total

Mas11 26-Jun-12 7:42am View

Thanks for your reply, But i don't want to solve this by coding. I want to know "how can we change url redirection setting in IIS". If you know kindly share with me

Mas11 18-Jun-12 23:54pm View

Thanks for reply, but dear i have already saw that link & there is no theme for downloading.

Mas11 15-Jun-12 7:27am View

Thanks a lot Manas, It worked..

Mas11 15-Jun-12 7:27am View

Thanks for reply..

Mas11 12-Jun-12 4:31am View

Actually i have no idea about Sitecore,I want to create aspx page in Sitecore. And how can we open uor project in sitecore. If you know kindly provide me valuable guidance.

Thanks

Mas11 7-Jun-12 5:24am View

Ok i got it..

Mas11 7-Jun-12 5:14am View

Deleted

Thanks for answer but can you write the code, because i have already use some code but that doesnt work.

Mas11 6-Jun-12 2:44am View

But PdfSaveOptions is not exist in my code for this i have to add new namespace. Can you tell me which namespace.

Mas11 5-Jun-12 6:27am View

Thanks Taha, but this is not the solution which i looks for, i want to know how we set TrackingID (where we get) & Url Parameter in DNN version 6.0. I know there is a inbuilt function of Google Analytics in DNN version 6.0 but i have no idea how can we set. If anyone have a idea, kindly guide me.

Mas11 30-May-12 3:04am View

I do it bro.

Mas11 30-May-12 2:46am View

hi Imdadhusen,
there is small issue, thats the date format comes in mm/dd/yyyy but i need dd/mm/yyyy. I saw its java script file its too lengthy to search. So can you tell me how i change date format.

Mas11 29-May-12 8:38am View

ok....

Mas11 29-May-12 8:30am View

A wonderfull thanks to my bro, i was searching over this from last 3 days, but finally you creates smile on my face. Again thanks a lot.

Mas11 14-May-12 7:07am View

Thanks..

Mas11 14-May-12 7:05am View

but how can we change link dynamically i.e. individual(new) link appears on individual(new) video click means by adrotrator we only fix it static.

Mas11 9-May-12 7:40am View

Ok..

Mas11 23-Apr-12 7:01am View

Dear Sravani.v, i want to import data from SQL 2008 to Excel.

Mas11 23-Apr-12 6:59am View

Dear P.Salini, i want to import data from SQL 2008 to Excel.

Mas11 23-Apr-12 6:58am View

Nilesh i want to import data from SQL 2008 to Excel.

Mas11 18-Apr-12 2:22am View

but their is 700 data already filled in my table.. I hope this will sequence only a single row.

Mas11 18-Apr-12 2:03am View

Can you provide me a code.. Because their is 700 record in my table & i dont want to delete that.. Can it solve by simple sql query.

Mas11 18-Apr-12 1:39am View

Thanks.. I got a solution from this link..

http://www.codedigest.com/Articles/ASPNET/130_Export_to_Excel_in_ASPNet_20_%E2%80%93Gridview_to_Excel_DataTable_to_Excel.aspx

Mas11 18-Apr-12 1:38am View

Thanks a lot my bro.. i got a exact solution from this link..

Mas11 18-Apr-12 0:37am View

Mas11 17-Apr-12 5:57am View

i also try this code but it doesnt work..

Mas11 17-Apr-12 5:57am View

it doesnt work, i use this page in crystal report.

Mas11 17-Apr-12 2:28am View

No i want new window open on button click with some height & width

Mas11 13-Apr-12 3:21am View

Okk but according to my need i dnt want to add web_offline.htm page. I simply do it by button control i.e. Active website & Deactive website(dynamic method).

Mas11 13-Apr-12 2:55am View

Okk but according to my need i dnt want to add web_offline.htm page. I simply do it by button control i.e. Active website & Deactive website(dynamic method).

Mas11 13-Apr-12 2:34am View

lakamraju please explain me how can i loaded all pages with that error pages.. I try so many method but till now i dont get a success.. I try over it from last two days.. please help me if you can..

Mas11 13-Apr-12 2:19am View

dear lakamraju how can we load all pages with that error pages, can you explain briefly.. or write code if you can..

Mas11 12-Apr-12 1:37am View

Ok..

Mas11 12-Apr-12 1:20am View

Deleted

Mas11 12-Apr-12 1:20am View

Deleted

Mas11 12-Apr-12 1:19am View

Dear Nilesh i have created a virtual directory & it run, but when i fire a event of page it dont find a database connection. I write a code below..
<appsettings>
<add key="xxxx" ;="" value="data source=xxx.xxx.x.xxx\SQLEXPRESS; Persist Security Info=True; initial catalog=database_name; integrated security=true;" <="" pre="">

Mas11 28-Mar-12 8:36am View

Yes i can make it easy...
Can we update 2 table by inner join

Mas11 28-Mar-12 8:32am View

Original Griff thanks a lot for your valuable guidance.. I catch it..

Mas11 28-Mar-12 8:17am View

Exactly bro.. but i have solved this at the same day.. but thanks for your answer..

Mas11 24-Mar-12 8:13am View

Dear bro by using SQLCommand not DataAdaptor.

Mas11 24-Mar-12 8:12am View

Dear bro by using SQLCommand not DataAdaptor.

Mas11 24-Mar-12 3:12am View

but only via inner join

Mas11 24-Mar-12 3:12am View

Yes bro i want to Do two updates in one transaction.

Mas11 24-Mar-12 3:08am View

Your question is not clear.. plz write in brief.

Mas11 21-Mar-12 8:45am View

Dear ryanb31 i have already told that update 2 table together not one by join.

Comments by Mas11 (Top 182 by date)