15,891,372 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View Python questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by Santosh K. Tripathi (Top 152 by date)
Santosh K. Tripathi
31-Mar-16 6:32am
View
i know, it may work with 2014, but i am using 2008 :(
Santosh K. Tripathi
31-Mar-16 6:05am
View
thanks for response. i just copy and paste you code.
DECLARE @tmptable TABLE (
Id int identity(1,1)
,ProductId int
,INDEX IX3 NONCLUSTERED(Id,ProductId)
)
still same error...
1. incorrect syntax near to 'INDEX'.
2. incorrect syntax near to 'ID'. Expecting select, or '('. -(this is after NONCLUSTERED key word).
Santosh K. Tripathi
31-Mar-16 5:59am
View
Note:- due to some reason, i have to use table variable, not temp table.
Santosh K. Tripathi
31-Mar-16 5:43am
View
as you told new code is
Declare @tmptable table (Id int identity(1,1) primary key ,ProductId int)
CREATE NONCLUSTERED INDEX ind1 ON @tmptable (Id, ProductId)
Now in second line
1. incorrect syntax near to '@tmptable'.
Note:- i have to use table variable, not temp table.
Santosh K. Tripathi
31-Mar-16 5:33am
View
thanks for response.
1. incorrect syntax near to 'INDEX'.
2. incorrect syntax near to 'ID'. Expecting select, or '('. -(this is after NONCLUSTERED key word).
Santosh K. Tripathi
28-Mar-16 7:10am
View
+5
Santosh K. Tripathi
28-Mar-16 7:04am
View
good answer. as always :)
Santosh K. Tripathi
10-Dec-15 20:30pm
View
Welcome :)
Santosh K. Tripathi
10-Dec-15 3:30am
View
pass value for '@CreatedBy' from you C# code.
Santosh K. Tripathi
15-Nov-15 3:55am
View
after
catch (Exception ex)
{
Response.Write(ex.ToString());
}
add
finally{
conn.close();
}
Santosh K. Tripathi
6-Nov-15 10:04am
View
why we need to raise error? example please?
Santosh K. Tripathi
6-Nov-15 10:03am
View
may i know, why you want to raise error? what is purpose of this?
Santosh K. Tripathi
3-Nov-15 6:24am
View
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.
Santosh K. Tripathi
26-Oct-15 13:28pm
View
you are again correct :)
My point is, assume if, database and application are on different server!
Network related issues.
Santosh K. Tripathi
25-Oct-15 3:52am
View
you are correct.
Santosh K. Tripathi
25-Oct-15 3:48am
View
one more thing making connecting to database several time is not good idea. it is very expensive.
Santosh K. Tripathi
25-Oct-15 3:47am
View
:) you are correct. so my suggestion is "Member 10690878" should move whole logic in database. i mean he should use Stored Procedure.
Santosh K. Tripathi
24-Oct-15 13:54pm
View
what will happen if after 1st commend, sql connection Fail?
Santosh K. Tripathi
24-Oct-15 13:51pm
View
you are right. in app never delete data just mark it isDeleted = true.
and for more complex logic use stored procedure. :)
Santosh K. Tripathi
15-Sep-15 1:19am
View
Deleted
web config
<configuration>
<system.webserver>
<security>
<requestfiltering>
<requestlimits maxallowedcontentlength="999999999">
<system.web>
<compilation debug="false" targetframework="4.0">
<sessionstate timeout="300">
<httpruntime requestvalidationmode="2.0" executiontimeout="3600" maxrequestlength="999999999">
<appsettings>
<add key="RoleLevels" value="1,2,3,4">
<connectionstrings>
<add name="XYZ" connectionstring="Data Source=xyz;Initial Catalog=;User ID=sa;Password=xyz;Connection Timeout=0;Max Pool Size = 500;Pooling = True" providername="System.Data.SqlClient">
<system.web.extensions>
<scripting>
<webservices>
<jsonserialization maxjsonlength="999999999">
</scripting>
Santosh K. Tripathi
3-Aug-15 6:14am
View
thanks :)
Santosh K. Tripathi
31-Jul-15 5:09am
View
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.
Santosh K. Tripathi
29-Jul-15 12:49pm
View
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.. :)
Santosh K. Tripathi
29-Jul-15 6:45am
View
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?
Santosh K. Tripathi
29-Jul-15 5:29am
View
Hi SA,
could you solve my problem.
http://www.codeproject.com/Questions/1013868/How-Do-I-Increase-Performance-While-Generating-Pdf
Santosh K. Tripathi
17-Jun-15 1:14am
View
Hi Pradeep, Explain you requirement for correct solution.
Santosh K. Tripathi
17-Jun-15 0:38am
View
what you tried?
Santosh K. Tripathi
13-Jun-15 21:13pm
View
thanks ansari
Santosh K. Tripathi
5-Jun-15 23:08pm
View
Thanks for clearing concept
Santosh K. Tripathi
7-May-15 2:40am
View
Hi,
did you find anything? i need it.
Santosh K. Tripathi
5-May-15 4:15am
View
what you have tried till now?
Santosh K. Tripathi
5-May-15 4:15am
View
what you have tried till now?
Santosh K. Tripathi
5-May-15 4:15am
View
what you have tried till now?
Santosh K. Tripathi
5-May-15 4:15am
View
what you have tried till now?
Santosh K. Tripathi
5-May-15 4:14am
View
what you have tried till now?
Santosh K. Tripathi
5-May-15 4:14am
View
what you have tried till now?
Santosh K. Tripathi
31-Mar-15 6:23am
View
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?
Santosh K. Tripathi
31-Mar-15 4:38am
View
debug in crome
Santosh K. Tripathi
31-Mar-15 4:36am
View
what you have tried till now?
Santosh K. Tripathi
31-Mar-15 4:33am
View
in your code you are setting it "false". Look
btnGenerateInvoice.disabled = "false";
it should be true like this
btnGenerateInvoice.disabled = true;
Santosh K. Tripathi
31-Mar-15 3:19am
View
correct.
Santosh K. Tripathi
27-Mar-15 7:02am
View
Hi,
Good one.
By the way, i thinks it can be more optimize, as -SA said.
Santosh K. Tripathi
27-Mar-15 0:04am
View
Hi, Could you explain bit more your requirement?
Santosh K. Tripathi
25-Mar-15 13:25pm
View
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?
Santosh K. Tripathi
25-Mar-15 12:58pm
View
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."
Santosh K. Tripathi
24-Mar-15 13:14pm
View
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
:) :) :) :) :)
Santosh K. Tripathi
24-Mar-15 1:59am
View
good point.
Santosh K. Tripathi
24-Mar-15 1:54am
View
Reason for my vote of 5 \n very informative
Santosh K. Tripathi
24-Mar-15 0:25am
View
+5 from me :)
Santosh K. Tripathi
24-Mar-15 0:02am
View
come up with some example for getting help from members of codeproject.
Santosh K. Tripathi
24-Mar-15 0:00am
View
+5
Santosh K. Tripathi
23-Mar-15 23:58pm
View
+5
Santosh K. Tripathi
23-Mar-15 8:36am
View
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.
Santosh K. Tripathi
23-Mar-15 8:33am
View
thanks F-ES Sitecore for reply.
today i come to know one new thing. +5 from me.
Santosh K. Tripathi
23-Mar-15 6:37am
View
good.
Santosh K. Tripathi
23-Mar-15 6:29am
View
duplicate entry.
http://www.codeproject.com/Questions/889491/How-can-I-write-this-in-javascript?arn=5
Santosh K. Tripathi
23-Mar-15 6:28am
View
Explain your requirement and problem.
Santosh K. Tripathi
23-Mar-15 6:26am
View
So what is issue in writing this javascript?
Santosh K. Tripathi
23-Mar-15 4:35am
View
+5
Santosh K. Tripathi
17-Mar-15 6:05am
View
i would like to suggest to you "Place client side validation for txtSearchRegNo".
this will help to reduce error.
Santosh K. Tripathi
15-Mar-15 1:03am
View
good one. 5+
Santosh K. Tripathi
15-Mar-15 1:01am
View
5+
Santosh K. Tripathi
15-Mar-15 0:57am
View
5+ from me also.
Santosh K. Tripathi
14-Mar-15 21:29pm
View
could you modify and post, above code. it will helpful.
thanks
Santosh K. Tripathi
13-Mar-15 5:56am
View
-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;
}
Santosh K. Tripathi
13-Mar-15 5:37am
View
+5 for _duDE_
error is at what line? what are values in variables in that line?
Santosh K. Tripathi
13-Mar-15 5:34am
View
+5 from me.
but i'll say, give some time to Mayank to learn by debugging.
Santosh K. Tripathi
13-Mar-15 4:01am
View
+5
Santosh K. Tripathi
13-Mar-15 3:06am
View
explain bit more
Santosh K. Tripathi
13-Mar-15 2:34am
View
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?
Santosh K. Tripathi
12-Mar-15 1:02am
View
i agree with chill60.
"powerful" != "performant"
Santosh K. Tripathi
12-Mar-15 0:59am
View
Thanks for reply.
Santosh K. Tripathi
12-Mar-15 0:59am
View
Thanks for reply.
Santosh K. Tripathi
10-Mar-15 8:10am
View
what you have tried?
Santosh K. Tripathi
10-Mar-15 1:34am
View
what you tried?
Santosh K. Tripathi
10-Mar-15 1:34am
View
what you tried?
Santosh K. Tripathi
10-Mar-15 0:48am
View
giving me the code ?
what is this?
Santosh K. Tripathi
10-Mar-15 0:42am
View
thanks :)
Santosh K. Tripathi
10-Mar-15 0:37am
View
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.
Santosh K. Tripathi
10-Mar-15 0:15am
View
Once again +5 from me.
Really, I like your way of answering questions. I learn a lot from your "detailed" and "deep" answers.
Thanks
Santosh K. Tripathi
9-Mar-15 3:01am
View
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
Santosh K. Tripathi
8-Mar-15 23:57pm
View
5+ from me :)
Santosh K. Tripathi
5-Mar-15 6:32am
View
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.
Santosh K. Tripathi
5-Mar-15 6:26am
View
Hi, could you clarify it.
Santosh K. Tripathi
5-Mar-15 6:16am
View
what you have tried?
Santosh K. Tripathi
4-Mar-15 23:33pm
View
5+
Santosh K. Tripathi
4-Mar-15 23:21pm
View
5+ :)
Santosh K. Tripathi
4-Mar-15 1:15am
View
why it is down voted, while solution is accepted. unable to understand?
Santosh K. Tripathi
3-Mar-15 23:02pm
View
_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.
Santosh K. Tripathi
3-Mar-15 3:43am
View
What you tried?
Santosh K. Tripathi
2-Mar-15 23:22pm
View
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.
Santosh K. Tripathi
2-Mar-15 23:09pm
View
thanks :)
Santosh K. Tripathi
2-Mar-15 22:55pm
View
it is same as solution 1.
Santosh K. Tripathi
2-Mar-15 22:41pm
View
what is issue in writing SP?
Santosh K. Tripathi
2-Mar-15 22:39pm
View
this is also
http://www.codeproject.com/Articles/361579/A-Beginners-Tutorial-for-Understanding-ADO-NET
Santosh K. Tripathi
2-Mar-15 1:30am
View
i could not understand, why it is down voted?
Santosh K. Tripathi
1-Mar-15 22:52pm
View
Is it web application or desktop application?
Santosh K. Tripathi
26-Feb-15 23:48pm
View
5+ from me. :)
Santosh K. Tripathi
26-Feb-15 23:38pm
View
give us some clue about column name of both table and some sample data.
Santosh K. Tripathi
26-Feb-15 23:34pm
View
5+
Santosh K. Tripathi
26-Feb-15 23:32pm
View
don't post as solution. you should post a comment.
Santosh K. Tripathi
26-Feb-15 23:19pm
View
Peter Leow's answer is good.
Santosh K. Tripathi
26-Feb-15 1:13am
View
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?
Santosh K. Tripathi
23-Feb-15 2:11am
View
5+
Santosh K. Tripathi
23-Feb-15 1:02am
View
5+
Santosh K. Tripathi
23-Feb-15 0:50am
View
good information.
Santosh K. Tripathi
23-Feb-15 0:50am
View
5+
Santosh K. Tripathi
22-Feb-15 23:29pm
View
5+
Santosh K. Tripathi
22-Feb-15 23:27pm
View
nice
Santosh K. Tripathi
22-Feb-15 23:18pm
View
Could make it more clear. what is code?
By the way put some condition to break loop.
Santosh K. Tripathi
20-Feb-15 1:23am
View
5* from me also :)
Santosh K. Tripathi
20-Feb-15 0:17am
View
thanks for this information.
Santosh K. Tripathi
20-Feb-15 0:11am
View
Hi,
Please put some more details about your requirement. your question is not clear.
Santosh K. Tripathi
18-Feb-15 4:03am
View
i will keep it in mind next time :)
Santosh K. Tripathi
12-Feb-15 23:27pm
View
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).
Santosh K. Tripathi
10-Feb-15 5:49am
View
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.
Santosh K. Tripathi
9-Feb-15 22:57pm
View
Thanks RyanDev for this information. i never thought this type things can create problem.
Santosh K. Tripathi
5-Feb-15 5:57am
View
Hi,
Could you tell me 'error message' is comes from database or from browser itself.
Santosh K. Tripathi
5-Feb-15 3:52am
View
Reason for my vote of 5 \n Nice and useful
Santosh K. Tripathi
5-Feb-15 3:17am
View
welcome :)
Santosh K. Tripathi
5-Feb-15 1:46am
View
Hi,
It is not clear. Please use Improve question to make it clear.
Santosh K. Tripathi
5-Feb-15 1:46am
View
Hi,
It is not clear. Please use Improve question to make it clear.
Santosh K. Tripathi
4-Feb-15 23:51pm
View
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.
Santosh K. Tripathi
4-Feb-15 23:05pm
View
Yes you right. yesterday i was facing same problem. After debugging i come to know this behavior of JS.
Santosh K. Tripathi
27-Jan-15 2:25am
View
so what is issue?
Santosh K. Tripathi
26-Jan-15 23:14pm
View
Hi,
Could you tell, what values are you passing in txtdate1 and txtdate2?
Santosh K. Tripathi
23-Jan-15 6:45am
View
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.
Santosh K. Tripathi
22-Jan-15 2:18am
View
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/
Santosh K. Tripathi
15-Jan-15 1:12am
View
May i know who and why downvoted this answer.
Plz let me "what is wrong with this answer?".
Santosh K. Tripathi
14-Jan-15 6:55am
View
+5
Santosh K. Tripathi
14-Jan-15 1:43am
View
its correct use one table and identify user by Unique key.
Santosh K. Tripathi
14-Jan-15 0:22am
View
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.
Santosh K. Tripathi
14-Jan-15 0:13am
View
Welcome
Santosh K. Tripathi
13-Jan-15 23:34pm
View
this is the correct, way go with it.
Santosh K. Tripathi
13-Jan-15 22:54pm
View
Hi, if u find my answer is useful for you, "accepted" my answer.
Santosh K. Tripathi
12-Jan-15 23:33pm
View
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
Santosh K. Tripathi
20-Aug-14 1:55am
View
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
Santosh K. Tripathi
19-Aug-14 6:13am
View
thanks it works for me also....
Santosh K. Tripathi
4-Aug-14 0:13am
View
ok.
Santosh K. Tripathi
4-Aug-14 0:12am
View
i am unable to understand what do you want to say?
Santosh K. Tripathi
25-Jul-14 1:56am
View
Thanks :)
Santosh K. Tripathi
22-Jul-14 1:22am
View
+5
Santosh K. Tripathi
14-May-14 6:01am
View
Thanks for information.. :)
Santosh K. Tripathi
14-May-14 4:39am
View
good answer :) 5
Santosh K. Tripathi
13-May-14 1:38am
View
Reason for my vote of 3 \n useful
Santosh K. Tripathi
7-May-14 1:04am
View
Deleted
No..
You have to read it from database and the use like lblUserID.Text = dt.Rows[0]["user_id"]
Santosh K. Tripathi
6-May-14 0:16am
View
+5 from me
Santosh K. Tripathi
29-Apr-14 5:38am
View
try this one
Santosh K. Tripathi
29-Apr-14 5:34am
View
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;
}
Santosh K. Tripathi
29-Apr-14 4:25am
View
hi, if it worked for you plz, accept answer and rate it.
Santosh K. Tripathi
28-Feb-14 2:11am
View
by mistake.. i unanble to understand voting system on this portal
Santosh K. Tripathi
28-Feb-14 0:10am
View
Thanks a lot dear for a quick and correct reply.. by the way it works with crome, firefox, IE9, safari...
Show More