Lowyat.NET: Latest topics by spirit

Backup MSSQL Database (solved)

spirit — Fri, 27 Apr 2007 02:25:05 +0800

i am using visual studio 2005 and microsoft sql server 2000 enterprise edition. I now doing a window application, and i want to back up the database after i click a button, and store the database file with filename the date of the backup. So as to restore the database from backup file created above. any idea how to do this?

random generate character and digit

spirit — Thu, 01 Mar 2007 21:52:41 +0800

how to generate a 8 digit of mixed character and digit?

example : W9KR32K3
JSH8EU73
M937DFE4

put command code into a variable?

spirit — Mon, 05 Feb 2007 12:37:35 +0800

let's say i want to execute : treeview1.nodes(0).add("abcd")

so now, i wan represent the code above with a variable "A"
can i do like below?

dim A as ?????
A = treeview1.nodes(0).add("abcd")
A

simply say, when i put A in the vb code, it will run treeview1.nodes(0).add("abcd")

is tat possible??

TreeView node : add child to a node

spirit — Sat, 03 Feb 2007 21:25:43 +0800

Let's say i have the full path of the node where "\" is the path separator.

Now i wan add a child "CHILD1" to path [Plants\Orchid\OC001\] provided the node "OC001" is already exist in the treeview.

i am using the code below to add and it works:
TreeView1.Nodes("Plants").Nodes("Orchid").Nodes("OC001").nodes.Add("CHILD1")

SO, is there any code to add the the "CHILD1" under node [OC001] straight away ??

I need it as i add all the node from MSSQL database. my MSSQL database have a column "Path" which store the treeview path of [Plants\Orchid\OC001\]. As every data may have different tier of path, i need to add child to the correct node. For example, the other data may have path [Plants\Orchid\OC001\OC002\OC003\].

[addedon]February 5, 2007, 9:33 am[/addedon]anyone can help??

How to detect the 9th and 10th digit in a string?

spirit — Fri, 05 Jan 2007 15:56:05 +0800

Let's say i have a string stored in STR1

STR1 = I2100C43300000001

how can i check whether the 9th and 10th digit is 3 and 0?

How to refresh a form

spirit — Mon, 27 Nov 2006 13:11:18 +0800

using vb.net 2003.

i want to create a button to refresh the form so the form change back to what it look like as just opened.

Datagrid font colour on certain column

spirit — Mon, 27 Nov 2006 08:34:30 +0800

Is that possible to change the font colour on only 1 column while other column remain the same?

how to disallow combobox textbox typing

spirit — Sat, 25 Nov 2006 10:34:14 +0800

in my vb.net form, i add a combobox. Can i disable typing in combobox textbox? so that i can only choose item inside combobox list. (similar like the "Topic Tag" combobox when I post new topic.)

Mouse down event for datagrid

spirit — Thu, 23 Nov 2006 12:53:43 +0800

I build a mouse down event handler for my datagrid. So when i click on the data in datagrid, it will display the selected data in a new window. this works fine before i sort the data.

after i sort the data, then i will display incorrect data. I know the problem is the datagrid row index will not be the same with the data set row index after sorting. Any idea to solve?

listview

spirit — Tue, 21 Nov 2006 13:08:17 +0800

if i fetch data from MSSQL and display it in list view, Is it possible to set the data fetch with link label ability, which mean when i click on the link, it will go to another page??

let's say my list view like below:

Name Age Gender
John 15 Male

so can i make it like this?

Name Age Gender
John 15 Male

so when i click on the name John, it go to another form.

How to avoid form to open more than 1?

spirit — Mon, 20 Nov 2006 12:07:07 +0800

i am using visual studio .net 2003. how am i going to limit the frm in my window application to not open more than 1?

i am doing a menu in 1 form. by clicking the button in the menu, another form will pop up. But if i click the button twice, then 2 same form will open. how to avoid it?

How to display a column from mssql in a textbox?

spirit — Wed, 15 Nov 2006 13:08:05 +0800

i wan to fetch a column of data from mssql to a textbox. How should i do that? any example?

VB.net and MSSQL 2000 -> data grid display

spirit — Wed, 25 Oct 2006 23:28:39 +0800

i am using visual studio .net 2003 with mssql server 2000 enterprise edition.

here is my stored proc code :

» Click to show Spoiler - click again to hide... «

here is the vb.net code

» Click to show Spoiler - click again to hide... «

look at the arrow there:
if i put .value = "I2100C43300000001" then it is working, but when i put txtserial.text(the text in the textbox) which hold the same value, then it cannot work.

can anybody help me T_T??

1 more question. If i display in data grid, after i change the value in data grid, can i update the data in MSSQL as well? is tat possible?

write to and read from eeprom

spirit — Mon, 01 May 2006 21:01:57 +0800

i am using MikroElektronika microbasic compiler for pic software to write a code .

now i have a variable declare as word(16bits). and i wish to store it in eeprom which 1 location is 8 bit. wan to ask any algorithm to split the 16 bit data into 2 8 bits data for me to be able to store in eeprom?