15,897,226 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 Ankit Rajput (Top 182 by date)
Ankit Rajput
9-Jan-13 1:55am
View
My problem has been resolved with the help of this article.
http://www.hagrin.com/319/exception-hresult-0x800a03ec-excel-net-sql-and-windows-server-2008
Ankit Rajput
9-Jan-13 1:16am
View
Hi,
Sorry for late reply.
Actually the same scenario is working fine on my pc with Windows XP.
and on both side we have installed Office 2007.
Another thing, we dont have any reference of excel in c# code.
Ankit Rajput
28-May-12 13:39pm
View
I think you forgot to mention the question.....
Ankit Rajput
7-Dec-11 6:55am
View
thanks for replying....
But the solution of 300 lines(i have tested it) is not working in the same manner as i need it. If we restrict user to Command Prompt(Windows only), can we do something else in that case? Please suggest
Ankit Rajput
3-Dec-11 7:03am
View
I cant change client. becuase client can be command prompt or Hyperterminal.
So i need to send something from Server. Or if i can change through client then please suggest.
Ankit Rajput
2-Dec-11 4:23am
View
What is the problem with code?
Ankit Rajput
1-Dec-11 23:42pm
View
sorry for delay in reply.
We have developed some services, now for interacting with these services as management console, we have created a socket listener. and now we connect it from command prompt(cmd in WinXP) with the help of Telnet command.
Now we need to give functionality of clear screen with this client.
Ankit Rajput
29-Jul-11 3:54am
View
Do you know what do you want to know?
Ankit Rajput
21-Jul-11 8:28am
View
Tell us about your telephony medium. And ask your problem.
Ankit Rajput
27-Jun-11 8:16am
View
What is the error?
Ankit Rajput
27-Jun-11 7:30am
View
Gud Ans My 5.
Ankit Rajput
27-Jun-11 7:21am
View
Can you please confirm your data reading method from your telnet connection?
Ankit Rajput
2-Jun-11 0:36am
View
Your problem is not clear. If you are getting any exception then please update your question with Exception.
Ankit Rajput
1-Jun-11 5:13am
View
What is the problem with that?
Ankit Rajput
25-May-11 3:06am
View
What is the problem?
Ankit Rajput
12-May-11 3:38am
View
Check the path length and Database field length
Ankit Rajput
11-May-11 2:15am
View
Can you please provide the code?
Ankit Rajput
5-May-11 1:11am
View
Have you taken the services from any Site for SMS sending?
Ankit Rajput
4-May-11 15:06pm
View
I have already implemented the iteration into my project and released to production.
Now to update my knowledge or you can say to find another way or better way to do something, I have raised this question.
Ankit Rajput
4-May-11 8:32am
View
I have commented according to your Question( "pls find for me a C# code"). I think now you can understand why i had written this.
Ankit Rajput
4-May-11 8:29am
View
If you dont have any matching data in the table.
Then how can you expect from a query to delete it?
Ankit Rajput
4-May-11 8:08am
View
Then open new query window.
Select the approriate database.
Type your query here and run it.
If it is able to delete the data then it will delete from code as well.
Ankit Rajput
4-May-11 8:05am
View
We are here to help when you get any problem.
We are not here to code for you.
Have you tried something by your own?
Ankit Rajput
4-May-11 8:03am
View
Which version of SQL Server do you have?
Ankit Rajput
4-May-11 7:58am
View
Nice Answer. My 5
Ankit Rajput
4-May-11 7:56am
View
I think, He wants to change the color picturebox of Main Form from where form2 is opening.
Ankit Rajput
4-May-11 7:43am
View
Do one thing Copy this query from debug mode.
And run it directly to Sql Server Query Analyzer.
Is it able to delete the data from here?
Ankit Rajput
4-May-11 7:31am
View
I have updated the answer.
Hope now it will help a little
Ankit Rajput
4-May-11 7:28am
View
Check the Condition in your query.
Ankit Rajput
4-May-11 7:10am
View
Have you tried anything?
Ankit Rajput
4-May-11 7:08am
View
Then you have to check the query in debug mode.
Ankit Rajput
4-May-11 6:49am
View
Have you tried it on Google?
Ankit Rajput
4-May-11 6:33am
View
is your problem resolved?
Ankit Rajput
4-May-11 6:32am
View
Is your problem resolved?
If yes, then accept a answer.
Ankit Rajput
4-May-11 6:28am
View
I have updated my answer try it.
Ankit Rajput
4-May-11 3:42am
View
Your question is not clear. What do you want exactly to ask?
Ankit Rajput
4-May-11 3:39am
View
The best way to read about microsoft technologies is MSDN.
Else you can search the things on google. You will get a plenty of links to read about it.
Bu the way, if you got your answer. Then accept this answer.
Ankit Rajput
4-May-11 3:36am
View
Sorry. Use
listBox1.SelectedItems[0].ToString();
Ankit Rajput
4-May-11 3:28am
View
First fill the grid.Then use its columns.
Ankit Rajput
4-May-11 3:28am
View
change the sequence of these two statements
dgv.DataSource = ds.Tables["ExcessGView"];
dgv.Columns["excess"].Width = 270;
Ankit Rajput
4-May-11 3:16am
View
Does column excess exist in the dgv.
If possible please provide your code which you implemented now.
Ankit Rajput
4-May-11 2:51am
View
Have you tried anything?
Ankit Rajput
4-May-11 2:49am
View
by the way, If you are setting width like this. Then you don't need to use AutoSizeColumnsmode.
Ankit Rajput
4-May-11 2:45am
View
You have used like
dgv.Columns("excess").Width = 270;
but use it like
dgv.Columns["excess"].Width = 270;
Means use '[]' in place of '()' when accessing columns.
Ankit Rajput
4-May-11 2:23am
View
Thanks, For make it clear.
Ankit Rajput
4-May-11 2:22am
View
set this property of grid
AutoSizeColumnsMode = System.Windows.Forms.DataGridViewAutoSizeColumnsMode.DisplayedCells;
Ankit Rajput
4-May-11 2:17am
View
Actually its my confusion thats why i asked.
Ankit Rajput
4-May-11 1:12am
View
I think, we need to call DataBind function in case of web application only. Am i right?
Ankit Rajput
4-May-11 1:11am
View
Make your question a little bit clearer.
Ankit Rajput
3-May-11 8:36am
View
Try the solution which i have provided.
Ankit Rajput
3-May-11 8:13am
View
What is type of control(startingdate)?
Ankit Rajput
3-May-11 8:12am
View
What is the error?
Please specify
Ankit Rajput
3-May-11 7:29am
View
What is the type of call_control?
Ankit Rajput
3-May-11 5:38am
View
For that, You need to use Reflection.
Ankit Rajput
3-May-11 4:52am
View
No. You can not use like this. You need to iterate with all the items.
Ankit Rajput
3-May-11 4:52am
View
Deleted
No. You can not use like this. You need to iterate with all the items.
Ankit Rajput
3-May-11 4:31am
View
Is there any exception or log which you can share with us?
It will help to analyze your problem.
Ankit Rajput
3-May-11 4:17am
View
[EDIT]: Code block added.
Ankit Rajput
3-May-11 4:14am
View
Do not write email id in your post.
Email will be automatically sent to you when an answer ot comment will be added to your post
Ankit Rajput
3-May-11 3:48am
View
If you think answer is not up to the mark then you can downvote it. but do not use abusive language
Ankit Rajput
3-May-11 3:46am
View
@Ganesh: do not use this type of language here.
He is trying to help you without any charge. Mind it.
Ankit Rajput
3-May-11 3:42am
View
You need to club all the three variables into onelike this
string strResource="team,vehicle,stationery";
cmd.Parameters.Add(new SqlParameter("@Resources",strResource));
Ankit Rajput
3-May-11 3:03am
View
EDIT: Code block added
Ankit Rajput
3-May-11 2:14am
View
EDIT: Code block added to the post
Ankit Rajput
2-May-11 8:19am
View
Which type of problem.
User has already accepted the answer.
Ankit Rajput
2-May-11 8:03am
View
Gr8 Answer. My 5
Ankit Rajput
2-May-11 7:42am
View
most welcome.
Ankit Rajput
2-May-11 7:29am
View
I have updated my answer please try it.
Ankit Rajput
2-May-11 7:14am
View
One thing, I want to know, as you are suggesting to hide the form. Will it not create the performance or memory issues?
Ankit Rajput
2-May-11 7:03am
View
Provide the code from where you are opening the Forms.
Ankit Rajput
2-May-11 6:48am
View
so which type of opinion you want?
Ankit Rajput
2-May-11 6:43am
View
have you tried this code without making the file?
Ankit Rajput
2-May-11 6:41am
View
What do you want from CP?
Ankit Rajput
2-May-11 6:26am
View
do not forget to accept the answer.
Ankit Rajput
2-May-11 6:21am
View
You are most welcome.
Ankit Rajput
2-May-11 6:05am
View
RAJI: I think you mistyped. This property should be set as DropDownList.
Ankit Rajput
2-May-11 5:55am
View
change your query as I have suggested in my Answer.
Ankit Rajput
2-May-11 5:52am
View
Please do not add your code as solution.
If you need to add something then update your question with Updation Log as comment
Ankit Rajput
2-May-11 5:45am
View
Are you sure its a Web Application?
Ankit Rajput
2-May-11 5:32am
View
Please right down your problem here. Or provide the code which is not working.
Ankit Rajput
2-May-11 5:30am
View
Now I have updated the query in my Answer.
Please check and revert
Ankit Rajput
2-May-11 5:28am
View
I am updating my Answer Please check it.
Ankit Rajput
2-May-11 5:25am
View
Can you please provide the code?
It will help to analyze your problem.
Ankit Rajput
2-May-11 5:19am
View
EDIT: For better readability
Ankit Rajput
2-May-11 4:22am
View
Show us the code. Where are you getting Syntax Error?
Ankit Rajput
2-May-11 3:34am
View
show your code. We can not provide you help on Syntax errors without code.
Ankit Rajput
2-May-11 3:26am
View
No need to Use While here because we need to show a row into textboxes. We do not need to iterate.
By the way, Thanks
Ankit Rajput
2-May-11 3:09am
View
Write this in Place of ??????
dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString()
Ankit Rajput
2-May-11 2:59am
View
Downvoting: Its a windows application. How to use javascript?
Ankit Rajput
2-May-11 2:56am
View
I have updated my answer. Please check it.
And please use Reply option if you replying for any comment.
Ankit Rajput
2-May-11 2:50am
View
First Let me know whether its a Windows Application or Web Application?
If its a Windows Application, Then load all the data for Form Load event.
Do coding for specific value in this event.
Ankit Rajput
2-May-11 2:39am
View
Provide some code. and tell the problem
Ankit Rajput
2-May-11 2:32am
View
Where you want to navigate?
Ankit Rajput
2-May-11 2:32am
View
Nice Explanation. My 5.
You can use event model as well Check my Answer.
Ankit Rajput
2-May-11 2:20am
View
What to explain in it?
"select * from teacher2" its your query. It will select all the data from your table. If you need to pick specific data then you need provide some condition. Like
"select * from teacher2 Where teacherID=1".
Ankit Rajput
2-May-11 1:39am
View
You need it for windows application or for Web Application?
Ankit Rajput
2-May-11 1:37am
View
Then what is the problem
Ankit Rajput
2-May-11 1:16am
View
These are two characters or its a single
Ankit Rajput
2-May-11 1:12am
View
I dont think so we need to use javascript in windows application.
Ankit Rajput
2-May-11 1:02am
View
I think you forget to put where clause in your query.
Please check it once.
Ankit Rajput
30-Apr-11 7:39am
View
Downvoted. Answer is not sufficient for the question
Ankit Rajput
30-Apr-11 7:38am
View
Nice Answer. My 5
Ankit Rajput
30-Apr-11 6:41am
View
Please provide your code where you have created the timer.
Ankit Rajput
30-Apr-11 6:07am
View
This one is the same method. We need to iterate in ToDataTable function. and I dont want to iterate in my code.
By the Thanks
Ankit Rajput
30-Apr-11 6:06am
View
By the way Thanks
Ankit Rajput
30-Apr-11 6:06am
View
This one is the same method. We need to iterate in ToDataTable function. and I dont want to iterate in my code.
Ankit Rajput
30-Apr-11 1:53am
View
I have updated my asnwer. Please check it
Ankit Rajput
30-Apr-11 1:44am
View
ok
Ankit Rajput
29-Apr-11 5:50am
View
Nice Answer. My 5
Ankit Rajput
29-Apr-11 3:37am
View
Can you please provide some code?
Ankit Rajput
29-Apr-11 3:36am
View
EDIT: Code block added for better understanding
Ankit Rajput
29-Apr-11 2:41am
View
Good Answer. My 5.
Ankit Rajput
29-Apr-11 2:37am
View
If both client and server are in .Net then second option will be a better solution otherwise first one.
Ankit Rajput
29-Apr-11 2:35am
View
Edit: For more readability
Ankit Rajput
29-Apr-11 1:29am
View
Gud Article My 5.
Ankit Rajput
29-Apr-11 1:28am
View
Gud Suggestion. My 5
Ankit Rajput
28-Apr-11 3:50am
View
why this one is not useful?
Ankit Rajput
28-Apr-11 1:46am
View
Nice Answer. My 5.
Ankit Rajput
27-Apr-11 7:24am
View
Every body is giving the same answer.
But still we all dont the exact problem.
Can you please describe your problem?
Ankit Rajput
27-Apr-11 7:12am
View
Actually, I will say you the same thing if you ask for competition.
Take Care:)
Ankit Rajput
27-Apr-11 6:56am
View
What do you mean?
Do you want a competition here?
Ankit Rajput
27-Apr-11 5:00am
View
thanks
Ankit Rajput
27-Apr-11 3:47am
View
Now check your connection string.
I have already mentioned the link in my Answer
Ankit Rajput
27-Apr-11 3:27am
View
He again added the same question
Ankit Rajput
27-Apr-11 3:26am
View
He has asked it third time.
Ankit Rajput
27-Apr-11 3:23am
View
Good explanation. My 5
Ankit Rajput
27-Apr-11 3:19am
View
Have you defind this function(SqlDataSource1_Selecting' ) in your code behind or any where else
Ankit Rajput
27-Apr-11 3:18am
View
Server=TestSQLConnectionString; database=pubs; user ID=MyUser; password=password
Ankit Rajput
27-Apr-11 3:18am
View
this is one also will not work
Ankit Rajput
27-Apr-11 3:15am
View
He has added again as new question
Ankit Rajput
27-Apr-11 3:14am
View
What is the error?
Ankit Rajput
27-Apr-11 3:06am
View
Please mention the error you are getting.
It will help everyone to think about your problem.
Ankit Rajput
27-Apr-11 3:05am
View
I think, problem is occuring due to Connection String.
I am updating my answer for Connection String purpose.
Ankit Rajput
27-Apr-11 2:53am
View
I have already maintioned the Refrence name.
Only the difference is, I have maintioned it as .Net will show you
Ankit Rajput
27-Apr-11 2:45am
View
Can you please provide the error detail.
Ankit Rajput
26-Apr-11 8:24am
View
Hi Siva,
can you please describe the medium of call(e.g. VOIP,PSTN,GSM)?
Ankit Rajput
26-Apr-11 7:03am
View
I think there is no functionality in .Net Framework
You have to create your own control.
Ankit Rajput
26-Apr-11 2:26am
View
Same type is already asked few days back.
Please check the questions once
Ankit Rajput
25-Apr-11 3:11am
View
Is there any exception with this code?
Ankit Rajput
25-Apr-11 2:59am
View
thanks SA
Ankit Rajput
25-Apr-11 2:55am
View
I think, He forgets what is the problem?
Ankit Rajput
25-Apr-11 2:24am
View
is there any exception you are getting when using from another PC?
Ankit Rajput
25-Apr-11 2:23am
View
I have tested it with 2007 only and it is working fine at my end.
Is there any exception you are getting?
Ankit Rajput
22-Apr-11 10:55am
View
You have Microsoft Word or anyother Company or any Open source word document
Ankit Rajput
22-Apr-11 8:35am
View
Please check the new solution.
Ankit Rajput
22-Apr-11 7:52am
View
For every instance?
Ankit Rajput
22-Apr-11 7:50am
View
Please update if your problem sorted out with this article.
Ankit Rajput
22-Apr-11 6:51am
View
Your question is not clear.
Please ask clearly what you want to know?
Ankit Rajput
22-Apr-11 6:47am
View
Downvoted: You should ask clarification in comment. Please do not ask as New Solution.
Ankit Rajput
22-Apr-11 5:25am
View
most welcome
Ankit Rajput
22-Apr-11 4:10am
View
downvoting: because it will not work in MySql. Query provided will work in SQl Server.
Ankit Rajput
22-Apr-11 4:09am
View
I have updated the query. Now the result will be same as desired.
Ankit Rajput
22-Apr-11 3:55am
View
For that you need to use Outer Join
Ankit Rajput
22-Apr-11 3:54am
View
thats not an issue.
You can use it from table1
Ankit Rajput
22-Apr-11 2:46am
View
Can you please provide some more details about data fetching from Excel?
Ankit Rajput
22-Apr-11 2:25am
View
I am also agree with Sandeep
Ankit Rajput
22-Apr-11 1:16am
View
Hi Ankur,
He is asking the same question again and again.
Ankit Rajput
22-Apr-11 1:06am
View
Hi Sandeep,
Why are you asking same type of questions again and again?
Ankit Rajput
21-Apr-11 8:19am
View
You will find both the properties in your form on which you have both the buttons.
Ankit Rajput
21-Apr-11 7:57am
View
It will change the value to 1222.3456
Ankit Rajput
21-Apr-11 7:44am
View
Flexgrid in C#?
Are you using COM component?
Ankit Rajput
21-Apr-11 7:34am
View
In that case, Check your XML data which you have created.
Ankit Rajput
21-Apr-11 7:28am
View
I have updated the Answer now check it
Ankit Rajput
21-Apr-11 7:26am
View
I have updated the Answer now check it.
Ankit Rajput
21-Apr-11 7:06am
View
I have already test it before posting here.
Ankit Rajput
21-Apr-11 3:53am
View
Hi Wayne,
Are you sure, we can not use reader without cycling?
Regards
Ankit
Ankit Rajput
21-Apr-11 3:39am
View
Can you please provide the details of Exception?
Ankit Rajput
16-Apr-11 2:35am
View
what do you mean with it?
You want full project for Yourself or you need some help?
Ankit Rajput
15-Apr-11 5:15am
View
did you mean CPU usage?
Ankit Rajput
15-Apr-11 3:00am
View
Hi Chaithu,
I am talking about code provided in this solution.
In your code, It was already cleared.
Regards
Ankit
Ankit Rajput
15-Apr-11 2:44am
View
Hi,
What is the use of object of class Program in your code?
Regards
Ankit
Ankit Rajput
15-Apr-11 2:43am
View
In second, compiler will treat it as initialization. Becuase you are intializing variable at the time of declaration.
But in first one, you are trying to intialize it in another statement. and statement are allowed only in functions.
Ankit Rajput
15-Apr-11 2:37am
View
What is this?
Ankit Rajput
15-Apr-11 2:30am
View
Can you please describe the problem more?
Ankit Rajput
15-Apr-11 2:23am
View
In this case, your error should be like "Invalid token '=' in class, struct, or interface member declaration".
Reason of this I have already mentioned in the next solution.
Ankit Rajput
15-Apr-11 2:21am
View
Hi,
You are facing this problem because you are using a=10; and it is not the Initialization of variable. It's a statement and you can not use a statement in class. you have to put it into a function.
RegardsAnkit
Ankit Rajput
15-Apr-11 1:59am
View
Deleted
In the first case, you have not terminated the line that's why compiler is treating like
a=10 static void Main(string[] args)
That's why you are getting this error.
Ankit Rajput
13-Apr-11 7:37am
View
Can you please describe a little bit your problem?
Ankit Rajput
23-Mar-11 3:14am
View
Have you handled it in your code?
Ankit Rajput
22-Mar-11 8:39am
View
One more thing i want to add here.
Now you need to handle SelectedIndexedChanged Event to pass the values to the database.
Ankit Rajput
22-Mar-11 7:54am
View
It's a good idea to check the return value if a function returns something. It will increase the performance as well in your case.
Ankit Rajput
22-Mar-11 7:38am
View
Hi Satendra,
Can you please explain in detail which functionality you want to put in threading?
Regards
Ankit
Show More