- Upvotes Received
- 2
- Posts with Upvotes
- 2
- Upvoting Members
- 1
- Downvotes Received
- 0
- Posts with Downvotes
- 0
- Downvoting Members
- 0
- Interests
- vb.net
I NEED TO WRITE A CODE IN VB.NET , THAT LET ME EXPORT DATA FROM ACCESS DATABASE ( THE TABLE ATTACHED AS IMAGE ) AND IMPORT IT INTO SQL SERVER 2008 R2 . **NB : TAKING INTO CONSIDERATION DUPLICATION ** Example : if you see in the image the access … |
|
how i can compare the data of two datatables ( dt1 , dt2 ) and got the difference in a thrid one dt3 dt1 and dt2 Structure ID Date Time S1 S2 EmpID IN\OUT any help ? thank you |
|
i want to copy data from an access database to a sql database 2008 through coding in vb.net any help ? NB : I WANT ALSO TO CHECK FOR DUPLICATES EACH I SELECT FROM ACCESS TO COPY IN SQL |
|
i need to copy my data from access database to sql database through coding in vb.net , and taking into consideration the duplicates each time i select from access database to copy to sql , any help thx |
|
how i can import data from access database to my database in sql server , with a check for ducplicate each time i move data i need the code in vb.net any help ? |
|
Re:
[code] Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click connetionString = ("server=192.9.200.82;database=eKalyan;user id=invite;password=invite") MessageBox.Show("connection established") sql = ("select newuniqueid,newteh_code,newpcate_cd,newplano, pen_nm,rel_cd,pen_fnm,ccate_cd,pan_code,pvillage,ppo_cd,spo_cd,start_qtr,last_qtr,bundle_typ,bundle_no,mo_srno,pen_amt,pen_comm,status,operatorcode from ekalyan.welpen") cnn = New SqlConnection(connetionString) Try cnn.Open() cmdd = New SqlCommand(sql, cnn) cmdd.ExecuteNonQuery() cnn.Close() MsgBox(" ExecuteNonQuery in SqlCommand executed !!") Catch ex As Exception MsgBox("cannot … |
|
http://code.daypilot.org/60174/timesheet-for-asp-net-c-vb-net-sql-server similar as this one but with windows forms |
|
i need to generate for example the January month from 1-1-2014 till 30-1-2014 in sql database using visual basic 2010 so the table will be like that Date Day Employename 1-1-2014 Wednesday elie 2-1-2014 Thursday elie 3-1-2014 Friday elie , , , , , , , , , , , … |
|
how i can design an appilcation in visual basic 2010 , the same as the attached picutre using control boxes , thanks for any help |
|
i want to create a visual project with using the same template and design as outlook |
|
i configure the level 2 of attachments in gpo and i indicate the extension that i dont want the use to open them , when a user receiver an attachment let say .zip an attachment wanrnig window pop up ( print screen ) how i can disable it ? |
|
i am using the odbc data sources ( created from the control panel --> administrative tools --> odbc data sources ) to connect the crystal report to my access database . all things good and the data sources works like a charm , till i discover that generating the report … |
|
Remarque the hand punch is connected to the network throug a converter from serial to network , so i need to connect the port and the ip at the same time , any help ? |
|
Re:
I am making a login system that records time in and time out for students.. but the student can't sign in if already "Signed In" and student can't sign Out if already "signed out" that is why i have three form. **THE CONCEPT OF THE PROGRAM: When i log in … |
|
i need to develop a software in which i can connect to a handpunch1000 throug vb.net and collect data , i am using visual studio 2010 any help ? |
|
Re:
hello, i am doing a mini project in vb.net2010...BLOOD BANK MANAGEMENT...but i dnt knw how to connect vb.net2010 with ms access 2007..and how to code for add, delete,update records...plz help me |
|
|
Re:
Hi, need some help. How can I retrieve data from MS Access database into DataGridView that allow me to ADD/UPDATE/SAVE/DELETE? Thanks. Hope someone can help me. |
i am using an access odbc to connect my database to a crystal report , when i ma generating the report up to 10 times successivly the access con stop working , can i know why ?? and how i can make the odbc access more faster and can hold … |
|
how to prevent using ALT F4 TO close a vb form |
|
i have a txt file that is exported from an attendance software as follow : Date Time s1 s2 EmpiD IN\OUT 07-24-13 12:23:52 001 07 0000020009 0300000000 07-24-13 12:24:02 001 07 0000020010 0300000000 between the columns of this txt file different spaces for example between date and time 1 space … |
|
how to hide drives in my local computer and show it in my terminal servers using the same users , for example my user is wks410 when i loggged in my terminal servers all the drivers shoud be resitricted , when i logged in my local pc i need to … |
|
Re:
Hi all, I wanted to load a listbox with items from the database.I just wrote the code using oop. But on the interface i'm not sure how to read and insert the items in the listbox. How can i access the items being read at the client side(interface). Public Sub … |
|
how i could import my txt file into access database 2010 using vb.net . the txt file as follow : 08-14-13 08:09:26 001 07 0000020016 0100000000 08-14-13 13:12:06 001 07 0000020014 0300000000 i should take into consideration the space between columns becauase this txt file is exported from a certain … |