lucoin
Last Activity: Jan 27 '10, 01:49 PM
Joined: Sep 9 '07
Location: Sydney
-
combine data from different databases
Hi,everyboday. I'm designing a human management system. this system will be used by the branches separately. but the head office should combine the data from different branches. due to some restrictions, the system could not base on network. so I think the only way to combine the data is to update head office database manually. I am using vb.net and sql server ro develop the system. the branches will use the databases with same structures, anybody... -
vb.net problem about refresh pictures in datagridview
as add imagecolumn to the datagridview which contains the photo path.
the problem I have to click the button twice, then the picture comes. the code as follows.
...Code:Dim ds As DataSet ds = AuctionComm.GetAuctions() dgAuction.Columns.Clear() dgAuction.Columns.Add(PhotoColumn) dgAuction.DataSource = ds.Tables("Auctions") RefreshRows(dgAuction) -
I fond some codes can add images to the column
just like to set the image cells value through a shared method image.fromfile( "<ralative path here>")
hope this helps others -
Cool,everything works.
as the same I add imagecolumn to the the datagridview. but how to add pics to the buttom. because in my database I save the photo column as relative path in the program folder. how can I reference the path and review the pics on on the imagesbutton.
thanks a lot...Leave a comment:
-
Thank you. It works. but how to add click event to the button to monitor the changes to a special cell in the certain row....Leave a comment:
-
how to add a button in datagridview in vb.net
as asked in the title. how to add button to the datagridview in vb.net. to control the actions such as delete one row.
PS:the button are expected to appear at the end of each row.
PS:I use dataset to specify the datasource of datagridview in code. -
how to store array in micro sql server database?
I am using .net asp with c# and sql server 2005 express edition to develop an enrollment system, for the subjects, they may have more than one pre-requisites. when I stored the pre-requisites, how should I design the data table column like "Sbuject_Pr e", what the data type it should be? when I retrieve this column, how should I do? Thank you! -
Thanks. That's the problem.
I forgot to add .Trim();...Leave a comment:
-
what is the data types I get from the database by SqlDataReader
I am using asp.net(C#) to build a login sys. I use the SqlDataReader to get the data from the data base to validate the user. but it always comes the password dosn't matches. but I tested to print the password get from the database and user input on the page, they are the same. can any one tell me why?
I use text box to get user input
like sting userpwd = textbox.text..T oString().Trim( );
and SqlDataReader sdr... -
Questions about web services
I am new to C# and asp,net. I got an assignment about student enrollment system. I this system, I can not store the student name in the local data base. the local about student just stores the student number and password used for testing. when retrieve the data about student information, I have to retrieve the student number from the local database and use web service to get the student name. the web services are accessed by the URL which includes... -
Yes, I did. The problem is when I change the local salesperson to another branch. what should I do. for example, I want to shift one sales person from Sydney to Melbourne. yes, delete the salesperson from Sydney salesperson table, and insert into Melbourne salesperson table and change the location. but when I delete the salesperson from Sydney, how about the other tables has associate tuples to that person. If there any better solution to solve...Leave a comment:
-
how to tread the primary key and foreign key in fragmentation
I have a global schema include the relations customer, order, orderline, salesperson, and product. I fragment the salesperson into salesperson_MEL and salesperson_SYD , the salesperson in different branches may have shift. so what I should do with the salesperson relation in branches, if delete, how about the related order records. what should I deal with this? -
That's why I ask this question. I works yes via the network by access one database in Sydney or whatever. but it will cost network transition much. That's why distributed database, so the local office can trade the certain data locally to improve the efficiency. I just touch distributed database a little, I am not sure my understanding is right. So...?Leave a comment:
-
how to build treeviews ,nodes
Now I want to build a navigation panel for my web site using java applet.
It works as some nodes connect with lines. It describes a world map while the node 'world' site in the middle of the panel and other region nodes like 'Australia', 'Asia','Europe' ,'North America' and etc are float around the 'world' randomly. when customer click on the region nodes the node clicked will come to the center of the panel and the cities and node 'world'... -
how to start a distributed database
I have a project to build a distributed database for an organization which run to branches located in Sydney and Melbourne. Sydney office is considered as the head office and Sydney branch office as well. now I have some tables in Sydney head office like CUSTOMER,ORDERS ,ORDERLINE,SALE SPERSON,PRODUCT , AND SUPPLIER. so how can I fragment to the branches.
PS: I am a beginner to oracle, I am not sure if I ask the right question. In learning.... -
Thank you, it works very well. But one more thing, how can I get how many 'text' fields there?...Leave a comment:
-
I mean if I use getElementByTyp e('text'), what variables I will get. Thank you.Leave a comment:
-
How to getElementByType and check validation using javascript.
Hello guys,
I met a problem about php and javascipt
For a tickets booking system, when a customer search for flights from one city, so in the data base there should be many routes to different cities, like from Sydney, it can go to Landon, Paris and Beijing and etc. So first I use php to get the data from data base, and use a loop to list all of them and after each route, there is a input field which type is text for the customer to... -
Thank you, now I know how to check if the route exists. but the problem is how to update the Qty? by the way, I didn't use any database, I just use session to add to a chopping cart. My code:
[PHP]
<?php
session_start() ;
$fc=$_POST['from_city'];
$num_rows=$_POS T['num_rows'];
//loop to get all the variables posted
for($i=1; $i<=$num_rows; $i++){
if(isset($_POST['ticket_'.$i])&&!empty($_POS T['ticket_'.$i])){...Leave a comment:
-
yeah, I tried this method, but for in_array function, it matches all the fields. but for the same route, just 'fromcity' and 'tocity' are the same that is enough. how to only check two fields, if match and then update the quantity....Leave a comment:
No activity results to display
Leave a comment: