Comments by Santosh K. Tripathi (Top 152 by date)

+5

good answer. as always :)

Welcome :)

pass value for '@CreatedBy' from you C# code.

after
catch (Exception ex)
{
Response.Write(ex.ToString());
}

add

finally{
conn.close();
}

why we need to raise error? example please?

may i know, why you want to raise error? what is purpose of this?

i have one doubt. if in a class i am creating 10 data set, i have to set for all of them( 10 more lines of code). is there any way to set it as default for all dataset in this class.

you are again correct :)
My point is, assume if, database and application are on different server!
Network related issues.

you are correct.

one more thing making connecting to database several time is not good idea. it is very expensive.

:) you are correct. so my suggestion is "Member 10690878" should move whole logic in database. i mean he should use Stored Procedure.

what will happen if after 1st commend, sql connection Fail?

you are right. in app never delete data just mark it isDeleted = true.

and for more complex logic use stored procedure. :)

thanks :)

Thanks. i was looking for this.

I am unable to use this class. could you help me.

My code is


MemoryStream[] arrBmpImages;
int K=0;

protected void GetPNGScreenShots()
{
arrBmpImages = new MemoryStream[CountdtPDF];
for (int i = 0; i < CountdtPDF; i++)
{
Thread_StartForImages(ref arrBmpImages);
k++;
}

}

private void Thread_StartForImages(ref MemoryStream[] arrBmpImages)
{
Thread m_thread = new Thread(Thread_CaptureImages);
m_thread.SetApartmentState(ApartmentState.STA);
m_thread.Start(arrBmpImages);
m_thread.Join();
}


Private void Thread_CaptureImages(ref MemoryStream[] arrBmpImages)
{
System.Drawing.Bitmap bmpImage;
bmpImage = // get images via http://www.codeproject.com/Articles/95439/Get-ASP-NET-C-Website-Thumbnail-Screenshot

using (MemoryStream ms = new MemoryStream())
{
bmpImage.Save(ms, System.Drawing.Imaging.ImageFormat.Png);
arrBmpImages[k] = ms;
}
}

Now i will use arrBmpImages[] to create PDF or PPT

How i can do it by using you code. i tried but not able to do. Please help.

People who can't give any solution, they don't have right to down vote. if you are down voting, just give logic for that.
Bye the way They have there own rights to up or down vote. I know at the time of posting question few people will down vote.

if you are down voting, mean you have knowledge more than i have. But you are "A Miser" in knowledge shearing.

Share it.. :)

issue is solved by using .GetBuffer() Ref:-


Image image = Image.GetInstance(chartImage.GetBuffer());
http://www.codeproject.com/Articles/297677/Using-ASP-Net-Charting-with-Image-Map-in-MVC

Still its takes 40 seconds. i want to reduce it more. is MemoryStream[] arrBmp is good or should i use some other data structure?

Hi SA,

could you solve my problem.

http://www.codeproject.com/Questions/1013868/How-Do-I-Increase-Performance-While-Generating-Pdf

Hi Pradeep, Explain you requirement for correct solution.

what you tried?

thanks ansari

Thanks for clearing concept

Hi,
did you find anything? i need it.

what you have tried till now?

what you have tried till now?

what you have tried till now?

what you have tried till now?

what you have tried till now?

what you have tried till now?

use F12. in Elements tab search for btnGenerateInvoice and see what is its client side id. i hope it will be like XYZ_btnGenerateInvoice .

now modify
var btn = document.getElementById('<%=btnGenerateInvoice.ClientID%>');

to
var btn = document.getElementById('XYZ_btnGenerateInvoice');

and see what happens.

if you could find btnGenerateInvoice in element tab it means this element is not rendered client side. so you can not manipulate this element.

try and see what is happening there?

debug in crome

what you have tried till now?

in your code you are setting it "false". Look

btnGenerateInvoice.disabled = "false";



it should be true like this

btnGenerateInvoice.disabled = true;

correct.

Hi,
Good one.

By the way, i thinks it can be more optimize, as -SA said.

Hi, Could you explain bit more your requirement?

Hi SA,
See your answer http://www.codeproject.com/Questions/623025/error-C-CCartoPoint-cannot-instantiate-abstrac

I am agree with your answer. i want to ask few things...

in case of a normal class, when we use new keyword and if there is no constructor is defined.
At compile time compiler insert a constructor and instantiate.

i want to know
1. for abstract class compiler doesn't insert default constructor?
2. "What is that mechanism" for abstract class which stops it to instantiate?

You know meaning of locked door. just think about a person who haven't heard about lock and he just know about door!
"It is like asking why we cannot open a locked door..."

my answer would we "there is some mechanism or some arrangement is made on the door that prevents it from opening. And this arrangement or mechanism is call lock."

Hi SA,

Really, I like your effort toward users and portal(codeproject).

When i reached office at 9 AM in morning, i saw you were replying to questions.
Now it is 10.30 PM , still you are giving answers.

your way of answering is also good.
I have seen few members (with 1+ M points), They leave comment on question, like a user committed a crime by asking a question.

members who, leaving such type of comments, should think few years back they also don't know about things (or don't have knowledge).By continuous learning they acquired this knowledge.
विद्या ददाति विनयं विनयाद् याति पात्रताम्। पात्रत्वाद्धनमाप्नोति धनाद्धर्मं ततः सुखम्॥
Meaning is...
"Knowledge gives humility, from humility, one attains character; From character, one acquires wealth; from wealth good deeds (righteousness) follow and then happiness"


I think instead of leaving such type comment, they should put something in there plate (at least few link) to get some knowledge on that topic.

By the way, good work man. thanks from my side for such attitude.

+5 in from me new way
:) :) :) :) :)

good point.

Reason for my vote of 5 \n very informative

+5 from me :)

come up with some example for getting help from members of codeproject.

+5

+5

if you like answer, you should accept it as solution. The person who gave the answer feel good and he will give answer to other's questions also.

thanks F-ES Sitecore for reply.
today i come to know one new thing. +5 from me.

good.

duplicate entry.

http://www.codeproject.com/Questions/889491/How-can-I-write-this-in-javascript?arn=5

Explain your requirement and problem.

So what is issue in writing this javascript?

+5

i would like to suggest to you "Place client side validation for txtSearchRegNo".
this will help to reduce error.

good one. 5+

5+

5+ from me also.

could you modify and post, above code. it will helpful.
thanks

-SA is correct i want to give a a suggestion you can do like this also

string strCheckValue = string.Empty;

strCheckValue += GetCheckBoxText(checkBox1);
strCheckValue += GetCheckBoxText(checkBox2);
strCheckValue += GetCheckBoxText(checkBox3);
strCheckValue += GetCheckBoxText(checkBox4);
strCheckValue += GetCheckBoxText(checkBox5);
strCheckValue += GetCheckBoxText(checkBox6);
strCheckValue += GetCheckBoxText(checkBox7);

strCheckValue = strCheckValue.TrimStart(',');


private string GetCheckBoxText(CheckBox chkBox)
{
string result = string.Empty;
if (chkBox.Checked)
{
result = chkBox.Text + ",";
}
return result;
}

+5 for _duDE_

error is at what line? what are values in variables in that line?

+5 from me.

but i'll say, give some time to Mayank to learn by debugging.

+5

explain bit more

what do you want to show in each boxes if you have like this

1. NINETEEN THOUSAND THREE HUNDRED FORTY RUPEES ONLY
2. NINETEEN THOUSAND THREE HUNDRED FIVE RUPEES ONLY
3. NINETEEN THOUSAND FORTY FIVE RUPEES ONLY
4. NINETEEN THOUSAND FIVE RUPEES ONLY
5. FORTY FIVE RUPEES ONLY
6. FIVE RUPEES ONLY
and so on...

what are rules to show text to show in each boxes?

i agree with chill60.
"powerful" != "performant"

Thanks for reply.

Thanks for reply.

what you have tried?

what you tried?

what you tried?

giving me the code ?
what is this?

thanks :)

I want to highlight these two words. but could not make it bold in comment area.

I mean these two words are in positive way :) not in negative.

Once again +5 from me.

Really, I like your way of answering questions. I learn a lot from your "detailed" and "deep" answers.

Thanks

vijay asked "Written one Example or Approach..."

I think someone should tell him how to start. latest give him some example links.

As per my understating if someone asking for approach, we should give him some hint, at least he can go to start.


by the way, it may be helpful for you

http://stackoverflow.com/questions/16076309/import-multiple-csv-files-to-sql-server-from-a-folder

or

https://www.google.co.in/webhp?sourceid=chrome-instant&ion=1&espv=2&ie=UTF-8#q=load+multiple+csv+files+in+sql

5+ from me :)

Read UPDATE part of the article.

--
As Chris[^] suggested, I would like to add here itself as a part of the Tip/Trick that I would not suggest to use it and mess with browser's history as this is a bad, bad thing.
One should implement it, only if they really need it and are prepared to accept that it is not a good practice.
---

some time we haven't any good option and we have to do something, to resolve problem.

Hi, could you clarify it.

what you have tried?

5+

5+ :)

why it is down voted, while solution is accepted. unable to understand?

_SA is right.

As per MSDN ( https://msdn.microsoft.com/en-us/library/ff926074.aspx )
1. Write only one statement per line.
2. Write only one declaration per line.

this will easy and save your time during debugging/ Maintenance.

What you tried?

This place is for learning something, Not for getting ready made solutions.

Try from your self. if you need any help, then every one is here to help you.

thanks :)

it is same as solution 1.

what is issue in writing SP?

this is also
http://www.codeproject.com/Articles/361579/A-Beginners-Tutorial-for-Understanding-ADO-NET

i could not understand, why it is down voted?

Is it web application or desktop application?

5+ from me. :)

give us some clue about column name of both table and some sample data.

5+

don't post as solution. you should post a comment.

Peter Leow's answer is good.

Hi,
where is problem?

try
Run application in debug mode and get value of 'insertQryPatient' and 'insertQriTreat'.

execute these values (SQL inset command) in you database to know , Where is problem?

5+

5+

good information.

5+

5+

nice

Could make it more clear. what is code?
By the way put some condition to break loop.

5* from me also :)

thanks for this information.

Hi,
Please put some more details about your requirement. your question is not clear.

i will keep it in mind next time :)

thanks for response. My solution is showing here two time, really i don't know how it happen.

we can discourse little bit more. i want to put my few points.

1. in my answer i did use 'new Array' keyword because

http://stackoverflow.com/questions/931872/what-s-the-difference-between-array-and-while-declaring-a-javascript-ar

http://stackoverflow.com/questions/7375120/why-is-arr-faster-than-arr-new-array

2. I used '*possible.length' instead of '*36 (no need to calculate array length manually, easy for maintenance if you add/remove few characters in array).

Is this answer wrong?
or 'ttds' has accepted any solution and hence question is closed?
or a person can't answer a question if question is old?

I was searching for some this and found this question. I answered it because some time earlier i was facing same issue.

Thanks RyanDev for this information. i never thought this type things can create problem.

Hi,

Could you tell me 'error message' is comes from database or from browser itself.

Reason for my vote of 5 \n Nice and useful

welcome :)

Hi,
It is not clear. Please use Improve question to make it clear.

Hi,
It is not clear. Please use Improve question to make it clear.

Hi,

I need to know

1. length of City Field.
2. How are you adding city? Means while inserting new country you are adding multiple city at same time or you want to update city flied by adding one more cityin existing cites.

Yes you right. yesterday i was facing same problem. After debugging i come to know this behavior of JS.

so what is issue?

Hi,
Could you tell, what values are you passing in txtdate1 and txtdate2?

as you are saying

datatable.rows.count < 0

it means data table has less than zero row. even if a data table is empty still it's row count is zero (0).

so row count in negative number doesn't makes any seance.

Please explain your question by giving some good example, so we can understand.

From MSDN https://msdn.microsoft.com/en-us/library/det4aw50(v=vs.110).aspx

public DataRow[] Select(
string filterExpression
)

filterExpression should be string. so "or" is correct instead of ||


http://www.csharp-examples.net/dataview-rowfilter/

May i know who and why downvoted this answer.

Plz let me "what is wrong with this answer?".

+5

its correct use one table and identify user by Unique key.

Don't include the () in the call to setInterval. its my experience for timeout or setInterval don't include () with function name. its creates problem.

Welcome

this is the correct, way go with it.

Hi, if u find my answer is useful for you, "accepted" my answer.

Reason for my vote of 2 \n could you tell me what is new in this article.

take a look

http://www.codeproject.com/Articles/23306/ASP-NET-Performance-and-Scalability-Secrets


http://www.codeproject.com/Articles/13100/ASP-NET-Best-Practices-for-High-Performance-Applic

upload means

1. Make a form there should be file browse option (like, when we upload photo on or attach any file in mail) and a button.
2. by browsing set path and on click of button start read and save data of file.

These may help to you...

https://gist.github.com/Munawwar/924413
https://bytescout.com/products/developer/spreadsheetsdk/read-write-excel.html
http://csharp.net-informations.com/excel/csharp-read-excel.htm
http://csharp.net-informations.com/excel/csharp-excel-tutorial.htm

thanks it works for me also....

ok.

i am unable to understand what do you want to say?

Thanks :)

+5

Thanks for information.. :)

good answer :) 5

Reason for my vote of 3 \n useful

+5 from me

try this one

i made some change in it. define two functions convertToDecimal() & convertToString they will return you needed value. you can use this function in you application any where you need a value without error.

SqlCommand cmd=new SqlCommand("spInsertArts",con);
cmd.CommandType=System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@name",convertToString(txtname.Text));
cmd.Parameters.AddWithValue("@description",convertToString(txtdesc.Text));
cmd.Parameters.AddWithValue("@Price",convertToDecimal (txtprice.Text));
con.Open();
cmd.ExecuteNonQuery();


---------------------------------------------------

function 1.

private decimal convertToDecimal(string testValue)
{
decimal result = decimal.Zero;

if (testValue != null || testValue != "")
{
decimal number;
if (decimal.TryParse(testValue, out number))
{
result = Convert.ToDecimal(testValue);
}
}
else
{
result = Convert.ToDecimal(DBNull.Value);
// Note if you will pass Alphabet or other characters it will return you 0 (Zero).
}

return result;
}



function 2.

private string convertToString(string testValue)
{
string result = string.Empty;

if (testValue != null || testValue != "")
{
result = Convert.ToString(testValue);
}
else
{
result = Convert.ToString(DBNull.Value);
}

return result;
}

hi, if it worked for you plz, accept answer and rate it.

by mistake.. i unanble to understand voting system on this portal

Thanks a lot dear for a quick and correct reply.. by the way it works with crome, firefox, IE9, safari...