Comments by goathik (Top 41 by date)

interesting...

Anytime =)

i was trying to guess but i gave up. that code is just weird. Why would he use the Text property from a LISTbox on that query?

THAT ^ is the answer.

i will simulate here and let you know in a minute

anyway, please, insert your full block of code for better analysis

did you mistyped "cm" and "cn" ? or perhaps that can possibly be the problem?

did you just rate a solution with one star just because A MEMBER doesn't need it anymore? Do you really think none else would browse this question via google?

His answer is correct and I'll rate it 5 stars. If the question is still open, blame the admins.

did you just rate a solution with one star just because A MEMBER doesn't need it anymore? Do you really think none else would browse this question via google?

His answer is correct and I'll rate it 5 stars. If the question is still open, blame the admins.

You should review my profile, you will find my contact information there. Merci!

there's no way to guess this one without the code

yeah, i also got curious about that override

ah ok, just a sec

SqlConnection connection = new SqlConnection(connectionstring);
SqlCommand command = new SqlCommand("SELECT TOP(1) GroupID FROM ProjectGroup ORDER BY 1 DESC",connection);

connection.Open();
SqlDataReader reader = command.ExecuteReader();

//won't need a while, since it will only retrieve one row
reader.Read();

//here is your data
string data = reader["GroupID"].ToString();

reader.Close();
connection.Close();

sure, just a sec

Thumbs up for that answer! I would do the same. If my boss still insists he is right, then he could try making a further explanation or just ask someone else to do the job, but at least you won't be blamed if anything runs into total chaos

suppose i have 3 years of experience, the select must return me, only if i earn 3+ dollars? It really makes no sense... or perhaps... you wanted to ask for the employee that earns the better salary, even tho he worked there for less time? suppose Victor works there for 3 years and he already gets $5000, although Alex still gets $2000, even he is there for 10 years. So that select should show Victor first, then Alex?

are you trying to troll us with that troll they did to you on that interview, mister? ;)

I don't think it is possible, but who knows, right? My suggestion: put everything in a label and bold it as you wish, and since you want to edit them, put a tiny "edit" button beside the label. I know that is out of question, but this is just a comment, not a solution ;)

nah, just try my solution ;)

Try his solution, from the search i have made, unfortunently it seems that that node selection event is a client side one.

it literally forces a post back on your page...

let me know if you need to know how to build your connection string

There are some things we need to know.
- ASP.Net or Windows Application?
- Linq or ADO.Net?
- On your table, do you only have always one row with that [Count] column, or more than one row?
- If more than one row, what is the WHERE condition?

then you want to find the textbox control inside the rows and save it on the grid's datakey row? can you paste your grid's code and also the server code of your submit button please?

we need to know what error you are getting. Also, what does Form7_Load(sender, e) do?

¬¬

You should also blame mr. OriginalGriff, for he also pointed our friend to keep trying to run the dangerous query he has written, until he gets it working.

I do, but that is another issue. according to his project scenario, perhaps he won't need security at all.
Whatever... hope i helped him solving the problem he STATED.

that query can work, even tho it is not the best way to write it. the problem he stated has nothing to do with the beauty of his code

I'm sorry, I'm not used to this forum text formating. ignore those

listView1.Columns[1].ListView.Items[i].SubItems.Clear();

did you try this? just a wild guess...

cmd.Parameters.AddWithValue("@SaleFileName", SqlDBType.NVarChar );

i believe the error has everything to do with this line. does it happen if you remove it?

can you also provide the gridview header and the databinding code, please?

I agree. on the imported data, you should foresee where the contact info is and cut off that information from the output. Just as you are already starting to do on the final lines of the code you provided.