looneytunezez
10-04 12:25 PM
if you are not on his W-2, and the contract says that you are....that means he made a false contract, which should be invalid.
i think you can talk to a attorney to get more clear picture, but based on what you say....i think you shld be ok, since his initial contract was false.
http://smallbusiness.findlaw.com/business-forms-contracts/business-forms-contracts-overview/business-forms-contracts-overview-enforceable.html
again, I am not attorney and above statement is just my opinion.
i think you can talk to a attorney to get more clear picture, but based on what you say....i think you shld be ok, since his initial contract was false.
http://smallbusiness.findlaw.com/business-forms-contracts/business-forms-contracts-overview/business-forms-contracts-overview-enforceable.html
again, I am not attorney and above statement is just my opinion.
wallpaper 2011 the letting go quotes
wandmaker
07-27 02:43 PM
Hi,
My I-140/I-485 are pending. I had also applied for my EAD card which I received promptly. The EAD card will expire in October, 2008. You know, at least until the I-140 gets approved, I don't need the EAD card. Can I just let it expire and renew it when I need it? Or will it be a separate application when I try to renew an expired EAD.
Thanks.
It is your choice to let it expire or renew before expire - either way, you will have to file I-765 form, if you need EAD
My I-140/I-485 are pending. I had also applied for my EAD card which I received promptly. The EAD card will expire in October, 2008. You know, at least until the I-140 gets approved, I don't need the EAD card. Can I just let it expire and renew it when I need it? Or will it be a separate application when I try to renew an expired EAD.
Thanks.
It is your choice to let it expire or renew before expire - either way, you will have to file I-765 form, if you need EAD
crazyghoda
09-09 10:09 AM
You don't need SSN to apply for a passport for a baby.
Where did you hear that from? The passport application form has a field for the SSN and I dont think its optional.
We had our baby last month but SSN in IL takes 12 weeks and they refused to give it over the phone. I dont think I have much of a choice but to wait it out till I get the SSN to be able to plan any trip to India to see the grandparents.
If you have any link that states that SSN is optional for passport, please let me know.
Where did you hear that from? The passport application form has a field for the SSN and I dont think its optional.
We had our baby last month but SSN in IL takes 12 weeks and they refused to give it over the phone. I dont think I have much of a choice but to wait it out till I get the SSN to be able to plan any trip to India to see the grandparents.
If you have any link that states that SSN is optional for passport, please let me know.
2011 Wisdom Quotes, Letting Go,
reno_john
06-11 12:02 PM
Asked Core Iv A Question And They Deleted The Thread
--------------------------------------------------------------------------------
I asked IV core on what version of immigration bill they support because I and other people wanted to know since there are so many amendments to the current immigration bill and Now I log in to see , the thread is missing, why, my question was straight forward, again I am asking them on what form of immigration bill they support. I highly doubt In what they are doing looks like they are working for the benefit of them self. Guys please don�t be ignorant and its your right to ask the question don�t be a dumb crowd but ask questions.
I am too in the same GC queue with I140 and I485 filed and pending, so don�t count me as anti � immigrant but also want to see the betterment of others too who are in GC process and will be effected due to the introduction of the new bill.
I searched but could not find it. why.
--------------------------------------------------------------------------------
I asked IV core on what version of immigration bill they support because I and other people wanted to know since there are so many amendments to the current immigration bill and Now I log in to see , the thread is missing, why, my question was straight forward, again I am asking them on what form of immigration bill they support. I highly doubt In what they are doing looks like they are working for the benefit of them self. Guys please don�t be ignorant and its your right to ask the question don�t be a dumb crowd but ask questions.
I am too in the same GC queue with I140 and I485 filed and pending, so don�t count me as anti � immigrant but also want to see the betterment of others too who are in GC process and will be effected due to the introduction of the new bill.
I searched but could not find it. why.
more...
Krishanpal
07-22 07:25 AM
I guess NSC is much faster than other centres. I am not sure if they have more staff than others.
little_willy
08-05 11:37 PM
Me and my wife along with our 1 year old will be there to show our support.
more...
OLDMONK
07-23 12:13 PM
Dont know whether it matters.
But R. Mickels.
But R. Mickels.
2010 quotes about letting go of the
ravi_hyd
10-30 12:06 PM
.
more...
djsnug
06-10 09:28 PM
I think I'll secretly keep Phat7's image as wallpaper on my computer. The woman in there is absolutely beautiful! :D
hair quotes on moving on and letting go. #moving on #letting go
sss9i
11-15 04:11 PM
Hi,I am also looking for Science teacher job for my sister.
I am from Phoenix. Can you give me cell no,So that I can call you regarding H1B Visa and Information regarding Teacher certification.
Thank you
Sreenivas
Hi
I am a teacher on H1B. I am here with a company GTRR. If you are a math, science or special education teacher you can get job easily. The company site is gtrr.net.
I am from Phoenix. Can you give me cell no,So that I can call you regarding H1B Visa and Information regarding Teacher certification.
Thank you
Sreenivas
Hi
I am a teacher on H1B. I am here with a company GTRR. If you are a math, science or special education teacher you can get job easily. The company site is gtrr.net.
more...
gc_check
07-19 10:17 AM
I have to apply for my wife as my derivative of 485. My 485 was approved on July 8th 2010. Below is the timeline
July 1st - Applied Wife's 485
July 8th - My 485 was approved
July 13th - Wife's 485 Denied due to outdated forms
July 14th - My H1, Wife's H4 and I-94 Expired
July 19th - Planning on sending a new 485 application for spouse
I'm mainly concerned about two things
1. Is she out of status for 5 days from July 14th to 19th
2. Can I still apply her as a derivative, as my 485 is already approved.
Thank you,
You can still apply for 485 since your wife is in US and also their is a 180 days window you can apply for 485 even the primary is approved on certain cases, Contact an attorney and apply asap without any delay and also have a document with all details. It is still possible to file 485 for your spouse.
July 1st - Applied Wife's 485
July 8th - My 485 was approved
July 13th - Wife's 485 Denied due to outdated forms
July 14th - My H1, Wife's H4 and I-94 Expired
July 19th - Planning on sending a new 485 application for spouse
I'm mainly concerned about two things
1. Is she out of status for 5 days from July 14th to 19th
2. Can I still apply her as a derivative, as my 485 is already approved.
Thank you,
You can still apply for 485 since your wife is in US and also their is a 180 days window you can apply for 485 even the primary is approved on certain cases, Contact an attorney and apply asap without any delay and also have a document with all details. It is still possible to file 485 for your spouse.
hot To let go is to cherish; Quotes On Moving On And Letting Go. letting go.
gc@waiting
09-30 07:01 PM
Thanks very much dingudi.
BUT does anyone know as to what are the options if the 140 is still pending and the applicant is laid off after 6 months of 140/485 pending?
BUT does anyone know as to what are the options if the 140 is still pending and the applicant is laid off after 6 months of 140/485 pending?
more...
house letting go. quotes; quotes on moving on and letting go. letting go. quotes
neerajkandhari
10-24 09:32 PM
The date in 'Receipt Date' field on your 485 form is the start date of your 90 days calculation.
WHEN I CALLED USCIS THEY TOLD ME THE NOTICE DATE IS WHERE THEY START THEIR CALCULATION
I AM IN THE SAME BOAT
WAITING FOR AP
TICKS TO INDIA ALREADY ISSUED FOR DEC
I HOPE I GET MY AP BY THEN
WHEN I CALLED USCIS THEY TOLD ME THE NOTICE DATE IS WHERE THEY START THEIR CALCULATION
I AM IN THE SAME BOAT
WAITING FOR AP
TICKS TO INDIA ALREADY ISSUED FOR DEC
I HOPE I GET MY AP BY THEN
tattoo Quotes On Moving On And Letting Go. breakup. quotes
sundarpn
11-17 11:33 PM
Another question is when using AC-21 to change jobs via H1b transfer, (or even EAD for that matter)
how does one bring up the topic of AC-21 to the employer?
Is is as simple a putting a condition to them saying hey "I will need an employment verification letter from you to ensure that my 485 process started with my previous employer will not be hindered."
(I am not talking desi consulting coy...but other companies where the HR person might not have a clue of what AC21 is!)
how does one bring up the topic of AC-21 to the employer?
Is is as simple a putting a condition to them saying hey "I will need an employment verification letter from you to ensure that my 485 process started with my previous employer will not be hindered."
(I am not talking desi consulting coy...but other companies where the HR person might not have a clue of what AC21 is!)
more...
pictures love quotes about letting go; quotes on moving on and letting go.
Blog Feeds
02-10 08:50 PM
Most lawyers that are versed in the H1B visa process, are getting busier and busier these days. As we are nearing the April 1, 2010 filing deadline for the H1B visa. Many speculations out there as to when will the Cap be reached this year. The economy is still in recovery mode, and employers are careful before hiring. Yet, many Immigration experts feel the Cap will be met early this year, but when is the big question.
With drastic changes to the Labor Condition Application (http://www.visalawyerblog.com/2009/07/icert_portal_for_lca_filing.html)process (now taking more than 7 days to process), as well as unreasonable denials (http://www.visalawyerblog.com/2009/08/h1b_visa_lawyer_about_icert_wo.html), planning early is the key to a successful H1B case this year. But in this post, I want to go back to the basics, the Cap and the legislative background.
Background
On October 21, 1998 Congress passed, and the President signed into law, the much debated American Competitiveness and Workforce Improvement Act of 1998, Pub. L. No. 105-277 (hereinafter ACWIA). This legislation was first introduced by Senator Spencer Abraham (R-MI), the Chairman of the Senate Subcommittee on Immigration, in response to the inadequate numbers of H-1B visas available in any fiscal year. As part of the Immigration Act of 1990, Congress imposed a 65,000 per year cap on these visas. In 1997, the cap was reached prior to the end of the fiscal year. The situation grew to crisis proportions in fiscal year 1998 when all 65,000 visas numbers were taken in May of 1998.
In early March 1998, Senator Abraham introduced a bill entitled, "The American Competitiveness Act." The legislation was introduced on the heels of numerous reports and hearings concerning the high tech worker shortage in the United States. The primary goal of the legislation was to address the looming exhaustion of the H-1B professional or specialty occupation worker visa numbers. (http://www.h1b.biz/lawyer-attorney-1137085.html)
The ACWIA went through many different stages before an agreement could be reached. A complete elimination of the cap had originally been proposed by Senator Abraham. The legislation was then modified to increase the number of H-1B visa numbers available during the government fiscal year; provide additional funds for scholarships in the computer science and mathematics areas; increase enforcement of the Department of Labor component of the H-1B visa process; and provide clarification on the prevailing wage requirements of the process. The legislation also addressed permanent residence by providing for an extension of the H-1B visa should a permanent residence petition be pending, and through restructuring the allocation of the employment-based immigrant visa numbers.
This legislative game between conservative isolationists/liberal protectors of the U.S. workforce and moderate Democrats and Republicans supporting business needs and demands, caused chaos among U.S.-based businesses in need of skilled professional workers. From May 11, 1998 until October 1, 1998 U.S. businesses, research institutions and other organizations were unable to recruit foreign workers as temporary professionals. With the U.S. economy still booming and unemployment rates remaining at an all-time low, businesses, especially in the high tech sector, encountered many problems as a result of the cut-off in H-1B visa availability. These problems included, but were not limited to, taking employees off the U.S. payroll, sending employees back to their home country or to sites outside the U.S. as well as the termination of some critical development projects.
Requirements in the Statute
The ACWIA purportedly balances the need for increased professional visas numbers for foreign workers and the desire to protect the U.S. workforce. The following is a summary of the significant changes made by the legislation.
A. Temporary Increase in the Number of Professional Visas Available
There will be an increase from 65,000 to 115,000 visas for fiscal year 1999 and 2000 (through September 30, 2000). In fiscal year 2001, 107,500 visas will be available. Beginning October 1, 2001 the numbers will revert back to 65,000.
B. Electronic Postings
LCA notices may be posted electronically in situations without a bargaining representative. This provision was effective upon date of enactment.
C. Attestations Required for Employers Dependent Upon Foreign Professionals
U.S. employers of 51 or more employees, whose workforce is comprised of 15% or more foreign nationals in the H-1B category are considered dependent employers and must make certain attestations. Employers will also be considered dependent if they employ 26- 50 full time employees and have more than 12 H-1B employees or if they employ 7 -25 employees and have more than 7 H-1B employees.
The dependent employer must attest that it has not and will not displace a U.S. worker within 90 days before and 90 days after filing the visa application. This attestation carries through to employers who place employees at another worksite. The H-1B dependent employer must also attest that it has taken good faith steps to recruit U.S. workers using industry wide standards and has offered the position to any U.S. worker who is equally or better qualified for the job the foreign worker is sought.
H-1B employees with a Master�s degree or a salary of $60,000 or higher are not included in the attestation requirements and for the first 6 months following the implementation will not be included in the dependent employer calculation.
D. Increased Enforcement and Penalties for Violations
The Department of Labor may fine employers between $1,000-$35,000 per violation and preclude participation in the H-1B program for up to three years.
E. Back Benching H-1B Employees
Employers must pay H-1B nonimmigrants the wage stated on the H-1B petition even if the beneficiary is in nonproductive status. This does not apply to non-productive time due to non work related factors.
F. Benefits
Employers must offer foreign workers benefits and eligibility for insurance, disability, retirement and savings plans, stock options, etc., on the same basis as offerings made to U.S. workers.
G. Additional Fee for Use of H-1B Program
Beginning December 1, 1998, employers are required to pay an additional fee of $500 for an initial H-1B petition and for the first extension. These fees are to be used to support job training programs and scholarships for U.S. workers.
H. Prevailing Wage Computations
For institutions of higher education, related or affiliated non-profit entities or non profit or governmental research organizations, the prevailing wage shall take into account employees at such institutions in the area of employment.
I. Academic Honoraria
Payments of honoraria may now be made to B-1 and B-2 visitors for usual academic activity lasting 9 days at an academic institution or affiliated non-profit entity or a non-profit governmental research organization. No more than 5 honorarium may be received within a six month period.
Employers based in the U.S. now have a temporary reprieve when hiring foreign professionals. However, it is uncertain whether the 65,000 visas for this fiscal year will be adequate to meet the demand for this year and next. Some government officials estimate that visas will be unavailable as early as the beginning of May 2010. In addition, it is still unclear what is on the legislative horizon, reform or not. Pro Immigrants want to come with a proposal to reform legal immigration. U.S. employers employing foreign nationals in any capacity would be well advised to carefully monitor future legislative and regulatory proposals on the horizon. All I can say is that if you plan on hiring a foreign worker, you better call your lawyer now!!!
More... (http://www.visalawyerblog.com/2010/02/h1b_visa_lawyer_the_filing_sea.html)
With drastic changes to the Labor Condition Application (http://www.visalawyerblog.com/2009/07/icert_portal_for_lca_filing.html)process (now taking more than 7 days to process), as well as unreasonable denials (http://www.visalawyerblog.com/2009/08/h1b_visa_lawyer_about_icert_wo.html), planning early is the key to a successful H1B case this year. But in this post, I want to go back to the basics, the Cap and the legislative background.
Background
On October 21, 1998 Congress passed, and the President signed into law, the much debated American Competitiveness and Workforce Improvement Act of 1998, Pub. L. No. 105-277 (hereinafter ACWIA). This legislation was first introduced by Senator Spencer Abraham (R-MI), the Chairman of the Senate Subcommittee on Immigration, in response to the inadequate numbers of H-1B visas available in any fiscal year. As part of the Immigration Act of 1990, Congress imposed a 65,000 per year cap on these visas. In 1997, the cap was reached prior to the end of the fiscal year. The situation grew to crisis proportions in fiscal year 1998 when all 65,000 visas numbers were taken in May of 1998.
In early March 1998, Senator Abraham introduced a bill entitled, "The American Competitiveness Act." The legislation was introduced on the heels of numerous reports and hearings concerning the high tech worker shortage in the United States. The primary goal of the legislation was to address the looming exhaustion of the H-1B professional or specialty occupation worker visa numbers. (http://www.h1b.biz/lawyer-attorney-1137085.html)
The ACWIA went through many different stages before an agreement could be reached. A complete elimination of the cap had originally been proposed by Senator Abraham. The legislation was then modified to increase the number of H-1B visa numbers available during the government fiscal year; provide additional funds for scholarships in the computer science and mathematics areas; increase enforcement of the Department of Labor component of the H-1B visa process; and provide clarification on the prevailing wage requirements of the process. The legislation also addressed permanent residence by providing for an extension of the H-1B visa should a permanent residence petition be pending, and through restructuring the allocation of the employment-based immigrant visa numbers.
This legislative game between conservative isolationists/liberal protectors of the U.S. workforce and moderate Democrats and Republicans supporting business needs and demands, caused chaos among U.S.-based businesses in need of skilled professional workers. From May 11, 1998 until October 1, 1998 U.S. businesses, research institutions and other organizations were unable to recruit foreign workers as temporary professionals. With the U.S. economy still booming and unemployment rates remaining at an all-time low, businesses, especially in the high tech sector, encountered many problems as a result of the cut-off in H-1B visa availability. These problems included, but were not limited to, taking employees off the U.S. payroll, sending employees back to their home country or to sites outside the U.S. as well as the termination of some critical development projects.
Requirements in the Statute
The ACWIA purportedly balances the need for increased professional visas numbers for foreign workers and the desire to protect the U.S. workforce. The following is a summary of the significant changes made by the legislation.
A. Temporary Increase in the Number of Professional Visas Available
There will be an increase from 65,000 to 115,000 visas for fiscal year 1999 and 2000 (through September 30, 2000). In fiscal year 2001, 107,500 visas will be available. Beginning October 1, 2001 the numbers will revert back to 65,000.
B. Electronic Postings
LCA notices may be posted electronically in situations without a bargaining representative. This provision was effective upon date of enactment.
C. Attestations Required for Employers Dependent Upon Foreign Professionals
U.S. employers of 51 or more employees, whose workforce is comprised of 15% or more foreign nationals in the H-1B category are considered dependent employers and must make certain attestations. Employers will also be considered dependent if they employ 26- 50 full time employees and have more than 12 H-1B employees or if they employ 7 -25 employees and have more than 7 H-1B employees.
The dependent employer must attest that it has not and will not displace a U.S. worker within 90 days before and 90 days after filing the visa application. This attestation carries through to employers who place employees at another worksite. The H-1B dependent employer must also attest that it has taken good faith steps to recruit U.S. workers using industry wide standards and has offered the position to any U.S. worker who is equally or better qualified for the job the foreign worker is sought.
H-1B employees with a Master�s degree or a salary of $60,000 or higher are not included in the attestation requirements and for the first 6 months following the implementation will not be included in the dependent employer calculation.
D. Increased Enforcement and Penalties for Violations
The Department of Labor may fine employers between $1,000-$35,000 per violation and preclude participation in the H-1B program for up to three years.
E. Back Benching H-1B Employees
Employers must pay H-1B nonimmigrants the wage stated on the H-1B petition even if the beneficiary is in nonproductive status. This does not apply to non-productive time due to non work related factors.
F. Benefits
Employers must offer foreign workers benefits and eligibility for insurance, disability, retirement and savings plans, stock options, etc., on the same basis as offerings made to U.S. workers.
G. Additional Fee for Use of H-1B Program
Beginning December 1, 1998, employers are required to pay an additional fee of $500 for an initial H-1B petition and for the first extension. These fees are to be used to support job training programs and scholarships for U.S. workers.
H. Prevailing Wage Computations
For institutions of higher education, related or affiliated non-profit entities or non profit or governmental research organizations, the prevailing wage shall take into account employees at such institutions in the area of employment.
I. Academic Honoraria
Payments of honoraria may now be made to B-1 and B-2 visitors for usual academic activity lasting 9 days at an academic institution or affiliated non-profit entity or a non-profit governmental research organization. No more than 5 honorarium may be received within a six month period.
Employers based in the U.S. now have a temporary reprieve when hiring foreign professionals. However, it is uncertain whether the 65,000 visas for this fiscal year will be adequate to meet the demand for this year and next. Some government officials estimate that visas will be unavailable as early as the beginning of May 2010. In addition, it is still unclear what is on the legislative horizon, reform or not. Pro Immigrants want to come with a proposal to reform legal immigration. U.S. employers employing foreign nationals in any capacity would be well advised to carefully monitor future legislative and regulatory proposals on the horizon. All I can say is that if you plan on hiring a foreign worker, you better call your lawyer now!!!
More... (http://www.visalawyerblog.com/2010/02/h1b_visa_lawyer_the_filing_sea.html)
dresses Letting go of one#39;s
krishnam70
05-04 10:12 PM
Hi All,
I used to commute across the border from Canada to work(on h1b) between 2004 and 2006. My passport was stamped just the first time and never after that.
In 2006 we moved to US by road and started living here. Haven't left States since then. Our passports were checked as usual but not stamped at the border although the U-Haul I was driving was inspected and our luggage and other stuff was inspected too.
Now I have received a RFE from USCIS on our pending I- 485's that were filed last August. They want us to prove that our last date of entry was indeed what we have entered in the I-485 form.
Any suggestions on how to respond to this RFE.
Thanks
It happened to me too, though my attorney advised to correct this before filing our 485. I was forced to take a vacation by my employer to go out of country and enter getting us a new I-94. Do u have any inspection documents etc that were given at the POE you might be able to provide that as proof.
- cheers
kris
I used to commute across the border from Canada to work(on h1b) between 2004 and 2006. My passport was stamped just the first time and never after that.
In 2006 we moved to US by road and started living here. Haven't left States since then. Our passports were checked as usual but not stamped at the border although the U-Haul I was driving was inspected and our luggage and other stuff was inspected too.
Now I have received a RFE from USCIS on our pending I- 485's that were filed last August. They want us to prove that our last date of entry was indeed what we have entered in the I-485 form.
Any suggestions on how to respond to this RFE.
Thanks
It happened to me too, though my attorney advised to correct this before filing our 485. I was forced to take a vacation by my employer to go out of country and enter getting us a new I-94. Do u have any inspection documents etc that were given at the POE you might be able to provide that as proof.
- cheers
kris
more...
makeup Quotes On Moving On And Letting Go. To let go is to cherish
mambarg
07-20 09:56 AM
I got the answer.
INS review have steps to lookup info in CLAIMS software to see if there is approved petition.
http://www.uscis.gov/portal/site/uscis/menuitem.5af9bb95919f35e66f614176543f6d1a/?vgnextoid=ff4ed0676988d010VgnVCM10000048f3d6a1RCR D&vgnextchannel=c54f0ccc1793f010VgnVCM1000000ecd190a RCRD
SO I am sure they will verify the info in enotice before rejecting.
INS review have steps to lookup info in CLAIMS software to see if there is approved petition.
http://www.uscis.gov/portal/site/uscis/menuitem.5af9bb95919f35e66f614176543f6d1a/?vgnextoid=ff4ed0676988d010VgnVCM10000048f3d6a1RCR D&vgnextchannel=c54f0ccc1793f010VgnVCM1000000ecd190a RCRD
SO I am sure they will verify the info in enotice before rejecting.
girlfriend quotes about moving on and letting go
franklin
03-23 01:51 PM
I've just got all the info for setting up conference call and meeting with the lawmakers "info" kit.
Once I've digested the contents of both, I'll be setting up a call, probably early next week. Here is the IV lawmaker kit http://immigrationvoice.org/index.php?option=com_content&task=view&id=53&Itemid=36
Any help on this would be appreciated, since I'm feeling a little overwhelmed with info! Volunteers for meeting people with me would also be great
I'll post to the yahoo group shortly.
Here're the details on NC_Immigration_Voice:
Group home page: http://groups.yahoo.com/group/NC_Immigration_Voice
Group email address: NC_Immigration_Voice@yahoogroups.com
It is our time to seize the reigns and kick start some momentum
Once I've digested the contents of both, I'll be setting up a call, probably early next week. Here is the IV lawmaker kit http://immigrationvoice.org/index.php?option=com_content&task=view&id=53&Itemid=36
Any help on this would be appreciated, since I'm feeling a little overwhelmed with info! Volunteers for meeting people with me would also be great
I'll post to the yahoo group shortly.
Here're the details on NC_Immigration_Voice:
Group home page: http://groups.yahoo.com/group/NC_Immigration_Voice
Group email address: NC_Immigration_Voice@yahoogroups.com
It is our time to seize the reigns and kick start some momentum
hairstyles quotes on moving on and letting go. Letting go is merely arriving
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!
rajnag21
07-17 06:57 PM
Thanks again to everyone. I will ask him to join IV. :) He like me has been in the country for over 10 years. The combined stress (finding a partner plus this gc dragging thing) has made him catatonic to some extent.
He is just doing his job and looks beyond caring about anything anymore.But I worry for him so thats the reason for the post.
He is just doing his job and looks beyond caring about anything anymore.But I worry for him so thats the reason for the post.
desi3933
06-22 09:50 AM
[QUOTE=desi3933][COLOR="Blue"]1. No, unless she goes out of country and re-enters US on H1 visa on or after Oct 1st
As her I-94 is attached and COS if approved with H1B, Can she work on I-485-EAD/H4 from Aug 1 - Sept 30 and then work on H1B from Oct 1 - next 3 years from the same company?
Please advise.
I have answered this question in my last post (#1 in post). Here we go again --
By working on EAD she will be on AOS Pending status. In order to change to H4 back again, she needs to go out of country and re-enter US on H1 visa on or after Oct 1st.
Not a legal advice.
-----------------------------------
Permanent Resident since May 2002
As her I-94 is attached and COS if approved with H1B, Can she work on I-485-EAD/H4 from Aug 1 - Sept 30 and then work on H1B from Oct 1 - next 3 years from the same company?
Please advise.
I have answered this question in my last post (#1 in post). Here we go again --
By working on EAD she will be on AOS Pending status. In order to change to H4 back again, she needs to go out of country and re-enter US on H1 visa on or after Oct 1st.
Not a legal advice.
-----------------------------------
Permanent Resident since May 2002
0 comments:
Post a Comment