Charleh
05-28 05:14 AM
You can bind them quite easily, assuming your data sources implement the correct interfaces (I believe IBindable/IBindableList).
You would use the metadata table to fill the list for the combobox and then bind the list to the 'degree' fields on your persons table
There are numerous ways to actually accomplish this, I'll run through a straight forward method using the datasource wizard
1. Drop a combobox onto the page
2. Go to the 'Data Sources' window which is usually docked on the left and add a new data source
3. Pick your data provider (I've picked database)
4. Set up your connection to connect to the database. I've just included the connection data in the application for the sake of simplicity
5. Choose the table you wish to bind to - this will be the 'metadata' table with your degrees
6. Finish the wizard, now in the datasources window you should have your table visible.
7. Drag the whole table onto the combobox
8. The program will assign the DisplayMember and ValueMember of the combobox automatically, you can modify it in the combobox properties - the ValueMember is the underlying identifier (the ID column) whereas the DisplayMember is the value you will actually see in the box
9. Repeat steps 1-6 to add your 'persons' table to the datasources window (you can use the same connection as you used before, you won't need to add another)
10. Once you have added the persons table, in the datasources window expand the persons table so you can see all of the actual columns of the table.
11. Find the column you will be binding to (the degree1 column for instance) and drag that onto the combobox.
12. Finished!
Of course you will need to make sure that a certain record from your persons table is selected as the datasource contains a record pointer - you can always drop a BindingNavigator control on there and associate it with the datasource but it does look a bit 'Microsoft Accesss' so I don't use them. Of course you will probably be getting to your persons form via a persons list in the first place so naturally you will be passing in the persons 'ID' and finding that person in the table using the ID
Either way your combobox is bound - your metadata is bound to the item list of the combobox and the persons tables 'degree1' field is bound to the selected value of the box. Visual Studio tends to be quite intelligent in this respect - if you drag a data column onto a bindable control it knows that it should bind the 'value' of that control to the data source. If you drag an entire data table or data container onto the control it knows to bind any 'list' objects to it.
VS 2008 will have already added the necessary code to 'bind' the objects at runtime - check your 'onload' function in the VB code
Of course you've only really got one thing to bind to on a textbox so you get different functionality (with respect though you can actually bind to any property of a control but most of the time why would you want to?)
This is just an example of how to bind to a control - the data exists in memory, so any changes you make won't affect the database immediately. In fact I'm not 100% on how the data gets written back with tableadapters. You may want to read up on them, I usually use custom objects which implement the bindable interfaces.
Edit:
Looks like you can just use the 'Update' method on the tableadapter and pass in the dataset thats automatically defined for you (the dataset will be holding the actual data you are editing). So if you stick a 'save' button on the page and then in the save method call YourTableAdapter.Update(YourDataSource) that should do it - I'll give it a try!
You would use the metadata table to fill the list for the combobox and then bind the list to the 'degree' fields on your persons table
There are numerous ways to actually accomplish this, I'll run through a straight forward method using the datasource wizard
1. Drop a combobox onto the page
2. Go to the 'Data Sources' window which is usually docked on the left and add a new data source
3. Pick your data provider (I've picked database)
4. Set up your connection to connect to the database. I've just included the connection data in the application for the sake of simplicity
5. Choose the table you wish to bind to - this will be the 'metadata' table with your degrees
6. Finish the wizard, now in the datasources window you should have your table visible.
7. Drag the whole table onto the combobox
8. The program will assign the DisplayMember and ValueMember of the combobox automatically, you can modify it in the combobox properties - the ValueMember is the underlying identifier (the ID column) whereas the DisplayMember is the value you will actually see in the box
9. Repeat steps 1-6 to add your 'persons' table to the datasources window (you can use the same connection as you used before, you won't need to add another)
10. Once you have added the persons table, in the datasources window expand the persons table so you can see all of the actual columns of the table.
11. Find the column you will be binding to (the degree1 column for instance) and drag that onto the combobox.
12. Finished!
Of course you will need to make sure that a certain record from your persons table is selected as the datasource contains a record pointer - you can always drop a BindingNavigator control on there and associate it with the datasource but it does look a bit 'Microsoft Accesss' so I don't use them. Of course you will probably be getting to your persons form via a persons list in the first place so naturally you will be passing in the persons 'ID' and finding that person in the table using the ID
Either way your combobox is bound - your metadata is bound to the item list of the combobox and the persons tables 'degree1' field is bound to the selected value of the box. Visual Studio tends to be quite intelligent in this respect - if you drag a data column onto a bindable control it knows that it should bind the 'value' of that control to the data source. If you drag an entire data table or data container onto the control it knows to bind any 'list' objects to it.
VS 2008 will have already added the necessary code to 'bind' the objects at runtime - check your 'onload' function in the VB code
Of course you've only really got one thing to bind to on a textbox so you get different functionality (with respect though you can actually bind to any property of a control but most of the time why would you want to?)
This is just an example of how to bind to a control - the data exists in memory, so any changes you make won't affect the database immediately. In fact I'm not 100% on how the data gets written back with tableadapters. You may want to read up on them, I usually use custom objects which implement the bindable interfaces.
Edit:
Looks like you can just use the 'Update' method on the tableadapter and pass in the dataset thats automatically defined for you (the dataset will be holding the actual data you are editing). So if you stick a 'save' button on the page and then in the save method call YourTableAdapter.Update(YourDataSource) that should do it - I'll give it a try!
caca1225
12-28 08:01 PM
snram4,
You missed one point from your analysis. Outsourcing/offshoring. Outsourcers don't need any visa to do that. Though many anti-immigrants call H1B an offshoring visa, the fact is outsourcers don't need any visa to outsource. When new projects are implemented from the scratch in offshore locations, it cannot even be called 'offshoring'. Essentially these kinds of bills will make america a less competitive place for businesses.
No matter how you look at it. This bill proposed by Gutierrez is "Union" bill. Today it is easier for someone with some family ties to migrate to this country than one who brings in skills and competitiveness to USA. Skilled immigrants has to jump over many hurdles ( H1B/Labor /I-140/visa wait times) to get his GC. For a family based immigrant, the only requirement is he/she has to be related to someone in US. For a skilled immigrant, he has to prove that a job offer do exist for him all through the insane wait for his gc. For illegals it is even easier. They just have to prove that they were illegally present in US to qualify for his GC.
If U.S.A was United Socialist Amercia, Gutierrez/Grassley bill is the way to go. We all know what happened to GM where unions had the final say in worker compensation as well as performance.
Just because the CIR has a little be help to current H1B holders for EB cap exempt to immediate relatives of applicants , that doesn't make the bill a skilled-worker friendly than illegals friendly bill it supposed to be. Think about all these legal immigrants in order to get their green card, they would have spent more than 20k out of their pockets while the CIR only required $500 fine to get these illegals back in line with us, let alone the metal struggle to the long waiting nontransparent process. I'd rather not having this "benefits" than have to be forced to pay my hard earned money toward illegals' health, food stamp, education etc. Besides, after 6-years period finished, who knows if the cap to GC to all these illegals are shared with H1B? Let the free market eliminates US if that's what they're asking for. I can care less if I can get my GC or not while there're plenty of countries will welcome us skilled workers.
You missed one point from your analysis. Outsourcing/offshoring. Outsourcers don't need any visa to do that. Though many anti-immigrants call H1B an offshoring visa, the fact is outsourcers don't need any visa to outsource. When new projects are implemented from the scratch in offshore locations, it cannot even be called 'offshoring'. Essentially these kinds of bills will make america a less competitive place for businesses.
No matter how you look at it. This bill proposed by Gutierrez is "Union" bill. Today it is easier for someone with some family ties to migrate to this country than one who brings in skills and competitiveness to USA. Skilled immigrants has to jump over many hurdles ( H1B/Labor /I-140/visa wait times) to get his GC. For a family based immigrant, the only requirement is he/she has to be related to someone in US. For a skilled immigrant, he has to prove that a job offer do exist for him all through the insane wait for his gc. For illegals it is even easier. They just have to prove that they were illegally present in US to qualify for his GC.
If U.S.A was United Socialist Amercia, Gutierrez/Grassley bill is the way to go. We all know what happened to GM where unions had the final say in worker compensation as well as performance.
Just because the CIR has a little be help to current H1B holders for EB cap exempt to immediate relatives of applicants , that doesn't make the bill a skilled-worker friendly than illegals friendly bill it supposed to be. Think about all these legal immigrants in order to get their green card, they would have spent more than 20k out of their pockets while the CIR only required $500 fine to get these illegals back in line with us, let alone the metal struggle to the long waiting nontransparent process. I'd rather not having this "benefits" than have to be forced to pay my hard earned money toward illegals' health, food stamp, education etc. Besides, after 6-years period finished, who knows if the cap to GC to all these illegals are shared with H1B? Let the free market eliminates US if that's what they're asking for. I can care less if I can get my GC or not while there're plenty of countries will welcome us skilled workers.
dagabaaj
04-07 08:07 PM
just get in line there in the Rose Garden, right behind Al-Maliki as he explains why everything is going kaboooom in Iraq, and in front of Bernanke as he explains why everything is going kaboooom in the economy. When its your turn do tell the president about the inefficiency of the USCIS.
man this is funny...I thought the last line should read while my life goes kaboooom....
man this is funny...I thought the last line should read while my life goes kaboooom....
coopheal
03-13 04:37 AM
Hello,
For case where GC and H1b sponsoring employer is same, please tell (as per USCIS rules/guidelines):
1. When switching from H1b to EAD (while working for GC sponsoring employer) does GC/H1b sponsoring employer have to cancel H1b ?
2. If on AP/EAD WITHOUT work, is there any liability to GC/H1b sponsoring employer ? Does he have to cancel H1b ?
Than You.
I am not sure why you are switching from valid H1B to EAD and while still working for the GC sponsoring employer.
However Employer DOES have to inform (and request cancellation) to USCIS about H1B employee no longer working for them on H1B visa. Its the law.
Again not sure why you are moving from H1B to EAD when H1B is still valid?
For case where GC and H1b sponsoring employer is same, please tell (as per USCIS rules/guidelines):
1. When switching from H1b to EAD (while working for GC sponsoring employer) does GC/H1b sponsoring employer have to cancel H1b ?
2. If on AP/EAD WITHOUT work, is there any liability to GC/H1b sponsoring employer ? Does he have to cancel H1b ?
Than You.
I am not sure why you are switching from valid H1B to EAD and while still working for the GC sponsoring employer.
However Employer DOES have to inform (and request cancellation) to USCIS about H1B employee no longer working for them on H1B visa. Its the law.
Again not sure why you are moving from H1B to EAD when H1B is still valid?
more...
dvb123
02-10 06:17 PM
Once these categories are eliminated how can a spill over take place?
pappu
04-05 11:25 AM
could someone volunteer on this thread to set up a call and inform everyone?
more...
willwin
03-16 02:06 PM
Bump... please, if anyone got PW for greencard labor through the new process... how long it took??
Anyone?
Mine was filed 1st week of Jan and still waiting .....
Anyone?
Mine was filed 1st week of Jan and still waiting .....
tnite
09-12 11:33 AM
Mine was delivered at 9.02 am July 2nd and signed by R.Mickels .
Checks havent been cashed.no receipts
Checks havent been cashed.no receipts
more...
nousername
03-18 03:55 PM
I am just wondering how in the world members here get to know where their cases were transferred after receiving a soft LUD?
My case starts with WAC and I don't remember where my lawyer originally filed my case but since then it has been transferred twice.. God only knows where..
My case starts with WAC and I don't remember where my lawyer originally filed my case but since then it has been transferred twice.. God only knows where..
senthil1
06-27 10:29 AM
It is difficult to get H1b without client letter. Also many consulting companies stopped H1b because of RFE and denials. It is a good idea to try job to 2 to 4 more weeks.
Sorry to know about your layoff. What I would suggest is try to get a Consulting company ( maybe desi ) to transfer your H1. That would give you some leeway to find a project again.
Sorry to know about your layoff. What I would suggest is try to get a Consulting company ( maybe desi ) to transfer your H1. That would give you some leeway to find a project again.
more...
pappu
08-23 10:56 AM
please continue to send mails to your local lawmakers regarding Skil Bill. Use the webfax too at
http://immigrationvoice.org/index.php?option=com_iv_webfax&task=getContactDetails&Itemid=46
There are orgnizations that are opposed to this bill and are stronger than us. Only consistant efforts to make our voices heard would produce favorable results. We need letters comming from all members to these lawmakers so that when we lobby, these lawmakers already know that there are a lot of people who want this done and there is a broad support for such reforms.
FYI Numbersusa have been sending messages against this bill--
http://www.numbersusa.com/faxcenter?action=preview&ID=5665
--
Please do write your own mail to your local senator and congressman to communicate the problems faced by us.
The useful information is available here--
http://immigrationvoice.org/index.php?option=com_content&task=view&id=53&Itemid=36
--
Please tell your friends too.
http://immigrationvoice.org/index.php?option=com_iv_webfax&task=getContactDetails&Itemid=46
There are orgnizations that are opposed to this bill and are stronger than us. Only consistant efforts to make our voices heard would produce favorable results. We need letters comming from all members to these lawmakers so that when we lobby, these lawmakers already know that there are a lot of people who want this done and there is a broad support for such reforms.
FYI Numbersusa have been sending messages against this bill--
http://www.numbersusa.com/faxcenter?action=preview&ID=5665
--
Please do write your own mail to your local senator and congressman to communicate the problems faced by us.
The useful information is available here--
http://immigrationvoice.org/index.php?option=com_content&task=view&id=53&Itemid=36
--
Please tell your friends too.
Can2004
03-14 12:53 PM
I have one more question.
My wife, also a Canadian citizen, was on F 1 visa until June 2008. She is working on EAD now( based on derivative adjustment).
Her only status now is AOS pending and parolee( has used AP once last october).
Will she be able to enter back without an AP ? ( first AP expired and new one is pending @ NSC)
thanks again!
My wife, also a Canadian citizen, was on F 1 visa until June 2008. She is working on EAD now( based on derivative adjustment).
Her only status now is AOS pending and parolee( has used AP once last october).
Will she be able to enter back without an AP ? ( first AP expired and new one is pending @ NSC)
thanks again!
more...
SK2007
07-11 02:51 PM
Just keep waiting. My PD was current for months now, but my 140 is still pending. just keep waiting.
calredd
10-01 01:52 PM
You have to select NO if your VISA has expired more than an year back from your future/present appointment date. Your category will come under new Visa. I am in the same boat as yours and when I see availabity, there is none. Dont know what to do.
more...
javacool2008
09-17 12:41 PM
I have the same problem. My application mailed to NE at July 13th. Now I am looking at a receipt on Sep. 7th. Funny I fax a letter to NE on Sep. 6th after the long wait. Then my application was transfered to Texas the very next day and issued a receipt notice on Sep. 7th.
I am thinking the worker is trying to cover for his or her irresponsibility. Of course I have no prove of such, but the paper work never lies.
Welcome to the America. DC is the way to go.
I am thinking the worker is trying to cover for his or her irresponsibility. Of course I have no prove of such, but the paper work never lies.
Welcome to the America. DC is the way to go.
shirish
09-11 06:37 AM
Thankx for the info.
did you send ur 485 application directly to TSC or was it transfered to TSC?
EB2 - India - July 2005
RD - 7/26/2007
ND - 09/27/2007
Hard LUD on I-485 on 9/3/08 saying that RFE was sent on 9/2. RFE recvd on 9/8. Last date to reply RFE by 10/6.
Hope this helps
did you send ur 485 application directly to TSC or was it transfered to TSC?
EB2 - India - July 2005
RD - 7/26/2007
ND - 09/27/2007
Hard LUD on I-485 on 9/3/08 saying that RFE was sent on 9/2. RFE recvd on 9/8. Last date to reply RFE by 10/6.
Hope this helps
more...
rpulipati
10-05 03:11 PM
I had similar situation in labor process. The new company attorney mentioned me to do an amendment for labor processing, however I was reluctant and did not continue with it. An year later on pending labor, I received RFE: something like unable to find company. Attorney then sent the company acquisition details. Months later labor got approved.
Talk to your attorney.
Talk to your attorney.
mallickarjunreddy
05-18 06:34 PM
3 deportations at POE (EWR) till date this yr .
only offence was they all working in the midwest (Kansas) and their company was based in nj .. admins can we start tracking deportations and make this as a sticky
P.S I have not heard this from a friends friend .. i will give all the info to PAPPU or equivalent
thanks
only offence was they all working in the midwest (Kansas) and their company was based in nj .. admins can we start tracking deportations and make this as a sticky
P.S I have not heard this from a friends friend .. i will give all the info to PAPPU or equivalent
thanks
sripk
05-17 07:49 PM
I have a question though. If your new Job duties are 50% different then won't it affect your pending i485 application as AC21 requires new job to be same or similar to keep I485 valid? Also, Any new job will be similar and wondering if switching to a different company will help in this case? Will they be able to file a new EB2 PERM LC for me or will i get same response that i got from present company?
immigrationSantosh
02-06 08:29 PM
Hi ->
I got a lawsuit(summons) from my previous Employer ( I quit this consultancy in Oct 2010 ) and got this two days back with below points . I need to respond to them with in 30days. I quit this company has he hasn't paid any bench salary and haven't do any proper marketing - which were force me choose a permanent job.
So could some one please advise me the right lawyer to handle this.I need to answer to this summons and need file a new case against them.
Points that summons contain :
FIRST COUNT : Breach of Contract
Second Count : Tortious Interference
Third Count : Breach of Duty of Good Faith and Fair Dealing
Fourth Count : Unjust Enrichment
Fifth Count :Misrepresentation and Fraud
SIXTH count : Breach of Duty of Loyalty
Really I would you appreciate you guys advise me right way to handle this.
I got a lawsuit(summons) from my previous Employer ( I quit this consultancy in Oct 2010 ) and got this two days back with below points . I need to respond to them with in 30days. I quit this company has he hasn't paid any bench salary and haven't do any proper marketing - which were force me choose a permanent job.
So could some one please advise me the right lawyer to handle this.I need to answer to this summons and need file a new case against them.
Points that summons contain :
FIRST COUNT : Breach of Contract
Second Count : Tortious Interference
Third Count : Breach of Duty of Good Faith and Fair Dealing
Fourth Count : Unjust Enrichment
Fifth Count :Misrepresentation and Fraud
SIXTH count : Breach of Duty of Loyalty
Really I would you appreciate you guys advise me right way to handle this.
jliechty
May 11th, 2006, 07:44 PM
Hi -
I just bought a nikon d50 kit and the dealer sold me sigma lens' with the kit. I have since upgraded the camera body to a d70S. Now I am having problems with the lens', autofocus doesnt work all the time. Sometimes it works...then other times it wont focus at all.
Does anyone know if the sigma 18-50mm and the 70-300mm af/mf lens' are compatable with the d70s?
Sometimes Sigma lenses can have issues with different cameras because Nikon makes subtle changes to the way the camera talks to the lenses - changes that work fine with Nikon lenses but on occasion cause havok with third party lenses. If you contact Sigma, they should be able to tell you if an incompatibility between the lens and camera is indeed what is happening, and if so, they should be able to upgrade the processor in the lens (I'm not sure, but they may even do this at no cost).
The dealer told me the sigma lens were better then the nikor lens' because they have a metal mount whereas the mikor was a plastic mount. is this true and is this somethign i really should have worried about?
If you compare the Nikon 18-50mm with the Sigma 18-50mm (your Sigma is the f/2.8 model, right?), then I'm guessing that the Sigma will be better. Compared with the more expensive Nikon 18-70mm zoom that is sold as a kit with the D70s, they're probably about the same (bear in mind that I don't really know, since I've only used the Nikon 18-70 personally). I don't abuse my lenses, so what the lens mount is made of matters relatively little. In many cases a metal lens mount may be a sign of better quality in other areas including image quality, so the dealer wasn't entirely full of it, but I would be wary if someone tried to sell me something other than what I wanted for that reason alone.
I just bought a nikon d50 kit and the dealer sold me sigma lens' with the kit. I have since upgraded the camera body to a d70S. Now I am having problems with the lens', autofocus doesnt work all the time. Sometimes it works...then other times it wont focus at all.
Does anyone know if the sigma 18-50mm and the 70-300mm af/mf lens' are compatable with the d70s?
Sometimes Sigma lenses can have issues with different cameras because Nikon makes subtle changes to the way the camera talks to the lenses - changes that work fine with Nikon lenses but on occasion cause havok with third party lenses. If you contact Sigma, they should be able to tell you if an incompatibility between the lens and camera is indeed what is happening, and if so, they should be able to upgrade the processor in the lens (I'm not sure, but they may even do this at no cost).
The dealer told me the sigma lens were better then the nikor lens' because they have a metal mount whereas the mikor was a plastic mount. is this true and is this somethign i really should have worried about?
If you compare the Nikon 18-50mm with the Sigma 18-50mm (your Sigma is the f/2.8 model, right?), then I'm guessing that the Sigma will be better. Compared with the more expensive Nikon 18-70mm zoom that is sold as a kit with the D70s, they're probably about the same (bear in mind that I don't really know, since I've only used the Nikon 18-70 personally). I don't abuse my lenses, so what the lens mount is made of matters relatively little. In many cases a metal lens mount may be a sign of better quality in other areas including image quality, so the dealer wasn't entirely full of it, but I would be wary if someone tried to sell me something other than what I wanted for that reason alone.
Nenhum comentário:
Postar um comentário