Comments by Scubapro - CodeProject

Scubapro 25-Oct-19 1:28am View

Hi Madhu158,

You are lucky that my email is still active and valid
after 9 years and I'm still active in IT.

If your textfile is always stored in the same directory,
you could use something like this:

For Each file As String In Directory.GetFiles("Your Directory")
If Path.GetExtension(file).ToLower = ".txt" Then

tRead = IO.File.OpenText(file)
'and so on, but you'll get the idea

End If
Next

Kind regards,
Scubapro.

Scubapro 19-Apr-18 5:37am View

You might want to check out (VS2008/VS2010):
https://www.codeproject.com/Questions/172759/How-to-set-a-icon-to-Setup-file-by-using-install-s

Scubapro 3-Dec-12 13:22pm View

I'm guessing the dtp is your datetimepicker? Then use:

TextBox1.Text = Format(dtp.value,"yyyy-MM-dd")

Scubapro 27-Jan-12 1:58am View

I hope your checkbox column isn't the first column of your datagridview, or else your 'string s = row.Cells[0].Value.ToString();' will be either "true" or "false".

Scubapro 25-Jan-12 2:35am View

Next time be specific in your question about GridView or DataGridView, as they are totally different objects!

Scubapro 23-Jan-12 4:12am View

It's like E.F Nijboer says; use a For/Next loop for your rows, use a streamreader, open your file, use WriteLine to write your rows, close the file.

Scubapro 20-Jan-12 8:38am View

Never mind, case closed!

Scubapro 20-Jan-12 8:26am View

Okay, and you don't assume anyone coding in C#, would be able to extract the text from a Textbox ???

Scubapro 20-Jan-12 8:19am View

Looking at the question, my guess is that this is exactly the problem were the OP is struggling with. So, why withhold this vital information?

Scubapro 20-Jan-12 8:18am View

Deleted

Looking at the question, my guess is that this is exactly the problem were the OP is struggling with. So, why withhold this vital information?

Scubapro 20-Jan-12 8:10am View

Since the buttonclick event is on Form2, you'll need to use: Form1.Textbox1.Text.

Scubapro 20-Jan-12 7:07am View

Why do you say it's time consuming? I've done this is in one of my projects for writing (and reading) a datatable with more then 300 rows (and 13 columns) to a textfile. I think you'll be suprised just how fast this works!

Scubapro 20-Jan-12 4:38am View

Use a try 'routine' and pinpoint the location of your problem. Then show us the code of were you're stuck.

Scubapro 11-Jan-12 8:09am View

You'll have to show some of where it goes wrong, otherwise it will be difficult to help you.

Scubapro 7-Jan-12 11:38am View

Then you'll probably have a bounded datagridview. In that case use the above codes in the CellFormatting event.

Scubapro 23-Dec-11 4:38am View

Tnx!

Scubapro 23-Dec-11 1:44am View

Off course it's not displayed. If you have a data-bounded datagridview, you'll have to perform a requery (database) and refresh your datagridview.

Scubapro 15-Dec-11 9:18am View

What do you mean exactly ? You want an output as above where total is not a field(column) of your Table, or you just want the '1100' ?

Scubapro 9-Dec-11 1:44am View

Take a look here: http://www.codeproject.com/KB/vb/mclhotkeynet.aspx

Scubapro 8-Dec-11 2:35am View

Which database en how does your code look like now?

Scubapro 8-Dec-11 1:48am View

Your absolutely right, I forgot about that.

Scubapro 5-Dec-11 6:13am View

Okay, check here: http://stackoverflow.com/questions/3272487/sql-server-2005-insert-multiple-rows-with-single-query

Scubapro 2-Dec-11 10:04am View

This is only the case if the other columns are of sizetype percent or autosize. If the other columns sizes are set to absolute, you won't have this problem.

Scubapro 2-Dec-11 9:27am View

Your question is somewhat cryptic. Do you mean that if you resize this particular column, that all others columns should be resized to the same size?

Scubapro 2-Dec-11 5:53am View

And where exactly did the OP say that my solution wasn't satisfactory? Many OP's just do not rate our solutions, regrettably.

Scubapro 2-Dec-11 2:43am View

Sorry, I'm an 'Oracle man' and not quite Access orientated.

Scubapro 2-Dec-11 2:31am View

Sorry about that! Please try again.

Scubapro 2-Dec-11 2:27am View

This is the second time you're copycatting. Please check the already given solution(s) before adding one.

Scubapro 1-Dec-11 10:32am View

I already suggested this in my Solution 2. This is just an expanded rephrase!

Scubapro 22-Nov-11 6:55am View

What do you mean by "formula for my quotation" ? A SQL-script ? And your not serious about the VB6 tag, right ?

Scubapro 22-Nov-11 5:48am View

Your first solution will produce a date and time, and whatever your second solution should produce, it's not going to be a date!

Scubapro 28-Oct-11 7:26am View

So, if your item code always contains 10 characters, you can use:

Dim item As String = "0101010001"
item = item.Insert(2, "-")
item = item.Insert(5, "-")
item = item.Insert(8, "-")

and you're done.

Scubapro 27-Oct-11 10:08am View

I agree with Dave. Maybe you should look into the WebBrowserDocumentCompletedEventHandler?

Scubapro 13-Oct-11 10:48am View

That's also possible. Use a keypress subroutine to check for Ctrl-C and Ctrl-V. On Ctrl-C, copy your cell(s). On Ctrl-V, paste your cell(s).

Scubapro 29-Sep-11 10:40am View

Okay. So if your using MySQL, use the equivalent 'STR_TO_DATE'.

Scubapro 29-Sep-11 9:43am View

'To_Date' is a SQL function.

Scubapro 27-Sep-11 8:30am View

Okay. Since cmdUpdate is a string use double apostrophes.

Suppose you got the table EMPLOYEES with columns EMPLOYEE_ID and SALARY.
Your SQL will be:

cmdUpdate = "UPDATE EMPLOYEES SET SALARY = 5000 WHERE EMPLOYEE_ID = 1234"

if the columns EMPLOYEE_ID (your row i) and SALARY (your column j) are Numbers.
Use the single apostrophes (as shown earlier) if a column is a VarChar(2).

Scubapro 17-Jun-11 7:22am View

Rephrasing the same question over doesn't help. Elaborate! Show what you want to do or show some code of where you are stuck!

Scubapro 17-Jun-11 7:09am View

Can you elaborate on that? Is not quiet clear to me what you want exactly.

Scubapro 23-Dec-10 3:44am View

Edited for readability.

Scubapro 7-Dec-10 9:47am View

Email removed, since anwers are automatically forwarded.

Scubapro 23-Nov-10 10:29am View

Deleted

<a href="http://www.vbdotnetheaven.com/UploadFile/mahesh/AccessMySqlDatabase04252005015856AM/AccessMySqlDatabase.aspx">This</a> should get you started.

Scubapro 17-Nov-10 2:45am View

Don't think anyone is going to answer you, if you're being this polite!

Scubapro 16-Nov-10 8:10am View

I'd go over chapter 13 once more if I were you, in order to finish this homework project.

Scubapro 12-Nov-10 1:19am View

This means that now the SQL-command is executed okay, but that it returns nothing. Try omitting the 'where' CLAUSE ("Select * from CLARUS") and see if this works. If yes, then make absolute sure the product exists. If no, you're problem lies else where.

Scubapro 11-Nov-10 10:39am View

Revised your answer (still gonna need the quotes). And indeed, that should be it.

Scubapro 11-Nov-10 10:20am View

Did you add the items in your combobox as strings?

Scubapro 2-Nov-10 11:11am View

I want to win the lotery. I need it badly. Please give me the winning numbers..

Scubapro 22-Oct-10 5:37am View

Okay, have it your way. Then use: <asp:DropDownList ID="DropDownList1" runat="server" style="direction:rtl"></asp:DropDownList>.
But the outcome will still be the same.

Scubapro 22-Oct-10 4:01am View

My point exactly!

Scubapro 22-Oct-10 2:56am View

What do you mean by 'dir does not exists'?

Scubapro 17-Aug-10 2:31am View

Edited for readability.

Scubapro 11-Aug-10 9:50am View

Well, thank heaven for that!

Scubapro 11-Aug-10 8:30am View

You'll probably have to change your gmail password now!

Scubapro 29-Jul-10 3:10am View

Maybe this link can help.
http://social.msdn.microsoft.com/Forums/en-US/vbpowerpacks/thread/b9433f73-43a9-4f09-aa8b-0d4204b2a9b0

Scubapro 28-Jul-10 10:14am View

AnnieMacD already answered the first post with same answer.

Scubapro 28-Jul-10 8:01am View

This way, don't forget to implement something if none of 2 is selected. Alternatively, you could use 2 checkboxes (none checked in the beginning) and if one gets selected (=true) set the other one to false and vice versa.

Scubapro 23-Jul-10 2:49am View

If you use a codeblock then use it to show your code!
Do not to put your question in it!

Scubapro 16-Jul-10 3:16am View

I still don't know exactly where your problem lies.
Can you show some code of what you've done so far
(regarding the DateTimePicker)?

Scubapro 15-Jul-10 3:09am View

What is Google and how can we use it?

Scubapro 14-Jul-10 5:50am View

Don't post this as an answer. Review/edit your original question.

Scubapro 2-Jul-10 1:48am View

Your right, ofcourse. But some people find checkboxes more aesthetically pleasing.

Hey, not everyone is a "winner".

Scubapro 1-Jul-10 8:29am View

The Tag is VB.NET NOT ASP.NET

Scubapro 18-Jun-10 8:32am View

Auriculas asini quis non habet

Scubapro 16-Jun-10 2:16am View

If life would just be so simple and easy.

Ehhhmm, why don't you BUY a schoolmanagement softwarepackage?

Scubapro 9-Jun-10 6:47am View

Yes, this is possible if the columns are separated by e.g. chr(09)(horizontal TAB)

Scubapro 8-Jun-10 10:52am View

This is in C#, not VB.

Scubapro 6-Jun-10 14:15pm View

txtIL_ID.Text = Str(dtgView.Rows(dtgView.SelectedRows(0)).Cells(1).Value)

Comments by Scubapro (Top 68 by date)