Comments by Surendra Adhikari SA

Surendra Adhikari SA 2-May-16 1:01am View

you should first check if your dataset table has rows or not .
i.e. if (ds.Tables[0].Rows.Count >0 ) { //do your task }

Surendra Adhikari SA 4-Oct-13 3:11am View

http://www.codeproject.com/Articles/21519/Fast-Exporting-from-DataSet-to-Excel
this may help

Surendra Adhikari SA 24-Jul-13 1:10am View

what is your actual problem then?? is any error on code above?

Surendra Adhikari SA 24-Jul-13 1:04am View

then what is your expected output?
did you want to display same as of your csv line by line ??
and discription of "USD,125.49,132" (meaning) may be helpful.

Surendra Adhikari SA 10-Jul-13 2:05am View

i updated the solution ...did you solved this?

Surendra Adhikari SA 8-Jul-13 9:29am View

Deleted

Solution..updated.

Surendra Adhikari SA 8-Jul-13 8:34am View

Deleted

seeing your queries...

Surendra Adhikari SA 26-Jun-13 10:13am View

what value SQL holds at line SQLCmd.CommandText = SQL?

Surendra Adhikari SA 26-Jun-13 9:55am View

+5 for _Amy

Surendra Adhikari SA 18-Jun-13 7:37am View

need more explanation to solve. code you have tried ,error ,table structure etc. else sorry

Surendra Adhikari SA 18-Jun-13 7:21am View

you welcome ...

Surendra Adhikari SA 18-Jun-13 3:24am View

why not use xml for hold this type of data?

Surendra Adhikari SA 18-Jun-13 0:38am View

Ok . This is really a great explanation . It trigger my mind to update my concept and i'm going to remove my solution .Thanks SA. my 5+ also

Surendra Adhikari SA 17-Jun-13 21:22pm View

... welcome man

Surendra Adhikari SA 17-Jun-13 9:57am View

what is the problem with your code?? what you want?

Surendra Adhikari SA 17-Jun-13 7:12am View

show your report load code then i can help

Surendra Adhikari SA 17-Jun-13 7:01am View

ohh , then you can google for same steps here

Surendra Adhikari SA 17-Jun-13 6:39am View

show your report load code then we can help

Surendra Adhikari SA 17-Jun-13 5:00am View

its ok man.

Surendra Adhikari SA 17-Jun-13 0:51am View

did you copy and paste my solution ? remove DataGridView1_CellFormatting sub (whole) and copy above code , didn't it worked for you ?? ... <<amazed>> its running fine for me (i have tested your code in my mechine)

Surendra Adhikari SA 16-Jun-13 7:03am View

your loop is fine . what this line is for : if(Blocks[i,j].Material != BlockMaterial.Material_Air) ?

Surendra Adhikari SA 16-Jun-13 6:35am View

you should describe your purpose and error you got..

Surendra Adhikari SA 16-Jun-13 4:36am View

its fine then.

Surendra Adhikari SA 16-Jun-13 2:03am View

error is self explaining.. i.e. you have to check for column name in Login_Table. You must match column name in your commandtext . can you give your table structure then we can update your quiry string.

Surendra Adhikari SA 14-Jun-13 8:54am View

what database did you used ?

Surendra Adhikari SA 14-Jun-13 8:49am View

you have to look on server side programming, you can google for the connection to ms access from any of them.

Surendra Adhikari SA 14-Jun-13 8:41am View

Your Sub does not have Handles clause, I have updated solution ,
without handles clause you have to call that sub, it does not fired on events of control.
try and enjoy.

Surendra Adhikari SA 14-Jun-13 7:30am View

have you solved it? any error from above code?

Surendra Adhikari SA 14-Jun-13 7:23am View

what are you trying with this code string "color = row.Cells["Color"].Value.ToString();"
did you want to show color as value of "Color" column ?

if you have a column with name Color then it is working code.
check for values of column(Color).

Surendra Adhikari SA 14-Jun-13 7:15am View

can you give detail? code snippet how did you done " Records are submitted already. I want to edit and that item must be selected from dataset or datatable." and what you have tried?

Surendra Adhikari SA 14-Jun-13 7:13am View

Have you solved??

Surendra Adhikari SA 14-Jun-13 6:52am View

agree @CHill60.
this is working code (logic is fine) .just debug and watch for data.

Surendra Adhikari SA 14-Jun-13 6:30am View

this is what i want to say ...

Surendra Adhikari SA 14-Jun-13 6:02am View

what you get from debugger or Error?

Surendra Adhikari SA 14-Jun-13 5:20am View

can you show your table structure??

Surendra Adhikari SA 14-Jun-13 4:48am View

what error did you get from your code above?

Surendra Adhikari SA 14-Jun-13 0:52am View

have you solved it?? whats the problems?

Surendra Adhikari SA 13-Jun-13 21:18pm View

ok i have updated above example in c# , you can modify this as of your logic

Surendra Adhikari SA 13-Jun-13 2:30am View

how did you excute this in c# ? can you give your code.

Surendra Adhikari SA 12-Jun-13 21:29pm View

then there may be some code that effects the column other then this block.

Surendra Adhikari SA 12-Jun-13 8:11am View

Deleted

can't you use shell command.

Surendra Adhikari SA 12-Jun-13 7:43am View

how do you want to retrieve data of xml,
from c# application or from sql server ?
Is xml file has multiple row?

Surendra Adhikari SA 12-Jun-13 7:33am View

you have to post your data insert code and selected index change event code of your drop down list.

Surendra Adhikari SA 12-Jun-13 4:33am View

try creating ,modifying a text file in that folder (C:\MyTestFolder ). This error is usually generated due to O.S.

Surendra Adhikari SA 11-Jun-13 8:10am View

you can certainly do this ...but
what have you tried so far?
can you give your related code snippet .

Surendra Adhikari SA 11-Jun-13 7:51am View

This question is not clear ? did you want to display data in one column from another column?
what is your actual problem ?
No one can solve your question in this form although there are thousands of user online in codeproject every moment.

Surendra Adhikari SA 11-Jun-13 7:47am View

welcome, i have already tested it in my mechine .and thanks for your +5 .

Surendra Adhikari SA 10-Jun-13 1:34am View

I have tested your code but i didnt found any error. Problem may be from different issue as (os,system or other code)

Surendra Adhikari SA 9-Jun-13 8:01am View

my 5 vote for
dim text as string = "twist" to wes aday.

Surendra Adhikari SA 9-Jun-13 7:58am View

what type of file you want to upload and check is that excel file?? give detail... what is the problem?

Surendra Adhikari SA 9-Jun-13 7:54am View

may be your field value container length is shorter then the string it may contain in run time . try extending field area (length) of that field and check.

Surendra Adhikari SA 9-Jun-13 7:45am View

did you want to compare string of serial.text with the name of text file within the folder c:\try\ ??

Surendra Adhikari SA 8-Jun-13 11:34am View

did you solved this?

Surendra Adhikari SA 7-Jun-13 4:25am View

did you got any error?? debug through the code and give detail of debugging . that may help.

Surendra Adhikari SA 7-Jun-13 3:47am View

my +5

Surendra Adhikari SA 7-Jun-13 3:41am View

thanks.

Surendra Adhikari SA 7-Jun-13 3:40am View

if you need to study how internally copy and paste command works in computer system .then you should search in Google first for terms like computer architecture,memory structure of a computer etc first.
Tutorial like http://computer.howstuffworks.com/computer-memory4.htm may helpful.
If you want to know how to impliment copy,paste,move etc ioperation in your project then you can clarify your question in detail.

Surendra Adhikari SA 7-Jun-13 3:22am View

what is the error?? you got.

Surendra Adhikari SA 7-Jun-13 3:15am View

you are always welcome .and thanks to ridoy.

Surendra Adhikari SA 7-Jun-13 3:10am View

your question is self explaining .. that is you can decrease code repetition .you can make a class file and call its method .
Or in simple you can make a function or sub that send message and call it whereever you want.

Surendra Adhikari SA 7-Jun-13 1:06am View

at first give your code , what you tried ? what is problem or error on your code then i may help.

Surendra Adhikari SA 6-Jun-13 4:43am View

can you show your code to display on crystal report viewer ..

Surendra Adhikari SA 6-Jun-13 2:59am View

in which line of code do you get error??

Surendra Adhikari SA 5-Jun-13 0:46am View

what you actually want to show in gridview cell from above data . Are you want to show data like in feilds col1+col2+col3 in a single cell of gridview.?? clarify .

Surendra Adhikari SA 4-Jun-13 8:43am View

Thanks .. its Solved now

Surendra Adhikari SA 3-Jun-13 7:48am View

I am trying but .... didn't got satisfied solution yet. I will update my question as of your suggestion.

Surendra Adhikari SA 2-Jun-13 6:39am View

i agree with you as ,i am getting different output then of my php function on .net with different solution on this problem (even using same key and text).
Data is already encrypted by php function above and i cant change that. So i must replicate the function on vb.net to fetch and display that data.
What to Do then??
Waiting for any Solution ....Thanks In Advance.

Surendra Adhikari SA 2-Jun-13 6:29am View

I have already Googled about it . and tried verious methods but i get different output on vb.net then of php code stated above .Thanks for the link , but this did not solved my scenario .can you give some detail as of mine scenario.

Surendra Adhikari SA 2-Jun-13 6:24am View

welcome . if solved then you can mark question as solved .

Surendra Adhikari SA 30-May-13 5:47am View

i think you have {sales.invoice_no} as integer and listView1.SelectedItems[0].SubItems[1].Text is text so the problem occur .change data type of sales.invoice_no and test

Surendra Adhikari SA 29-May-13 3:18am View

if you have same structure then
1.Bind another grid with data table used to bind previous grid
2. you can loop through each rows of one and add rows to other
What is the structure of grid view 1 and grid view 2 ??

Surendra Adhikari SA 22-May-13 2:15am View

can you show your code.
what programming language did you used?

Surendra Adhikari SA 22-May-13 2:05am View

please clarify your question . which database server do you using ??

Surendra Adhikari SA 25-Feb-13 4:08am View

can you give detail of your table structure. or not created yet.

Comments by Surendra Adhikari SA (Top 74 by date)