Comments by Ankit Rajput

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

Comments by Ankit Rajput (Top 182 by date)