Start with a pencil and paper and model out how you want the program to work, Then tackel the code.

after u downloaded data need to be stored into Access DB, u can use sql query that is something like "insert into ur table(field1, field2,..) values (...)" to insert the data into Access DB << >>

nidhelp wrote: ok... so do u mean i should change 'Indexed' back to 'No' for all of the 4 fields? No, I mean if you create an index column, then it should be an identity, set by the database, not by you. And you should never change it. Personally, I think the wizards for generating dataadapters are crap, you should just write your own SQL code in a database layer in your app. Christian Graus - Microsoft MVP - C++

hi there, ur question can be devided into 3 parts: nidhelp wrote: check if that id is already in my database => to validate: just execute "select id from customer where id= m_sID". If the returned result is not NULL, that means it's duplicated nidhelp wrote: if all three of the particular fields have repeated data => the similar thing u need to do: "select id from customer where field1 = field1Val and field2 = field2Val and field3=field3Val" nidhelp wrote: if based on all fields on a row =>similar to the second one with all fields need to be verified in WHERE clause Happy programming << >>

send me an email for recieving a free sample in c#.net database . my email:nmm705@yahoo.com Mostafa

oh yes, i forgot to mention about the error i got in Access. i've a field named IDno and this field is added to each and every of my tables. is it ok or correct to let all tables have IDno as pk? i thought it's ok so i tried.. i let table1 have IDno as pk. but then when i tried to let IDno be pk in table2, it gives me error regarding duplicate pk so im stuck now... if i dont use IDno, i donno what is best used as primary key in table2 and the rest of my tables. there's a button on the toolbar called Index Name, so i typed "PrimaryKey" and selected "IDno", hoping that through this way, perhaps table2 can have IDno as pk. does this way make IDno a pk? i doubt so.. i doubt so because if IDno is made to be a pk in my table now, how come i still get the same error as before i tried typing "PrimaryKey" and selecting "IDno" in Index Name? the error is: Could not determine which columns uniquely identify the rows for "table2". for table1, things are fine, i used OleDbAdapter and generated all the statements successfully. but doing this table2 gives me error, i just want to use OleDbAdapter to build update and delete functions too. i donno why it failed. it succeeded in generating Select and Insert statements... so what's wrong? i really have no idea what's wrong. please help. i really need some guidance. thanks! -- modified at 3:08 Tuesday 30th August, 2005

Probably an MD5 or SHA1 or 2 with salt is the best. Matt Gerrans

Hi, Ok, I thought u were waiting for my answer. It seems that Form2 does not contain txtBox1. What u need to do is create a simple textbox in Form2 and make it public. If u do not make it public it will not work. There is another solution. Define a public property which will set the valus of text box. Something like this.. in Form2: private string setValue = string.Empty; public string SetMyValue { set { this.txtBox1.Text = value; } } in Form1's button click: Form2 frm = new Form2(); frm.SetMyValue = "I got the value"; this.Hide(); frm.Show(); :-D Jayant D. Kulkarni Brainbench Certified Software Engineer in C#, ASP.NET, .NET Framework and ADO.NET

try this link

hi you see, when i use data form wizard, the form just pop-up across my screen as i used the show form method.. my most important need now is to be able to place my form that i had generated from data form wizard INTO a tab page... i tried to copy and paste the form controls over to a tab page, the result was that the form could not load.. i want the form to be placed in a tab page which i've already created and is working well.. PLEASE help me... thanks

nidhelp wrote: im not sure how a computer using string to read and write data will be able to pass data successfully to a computer using varchar for database.. Make sure your varchar is as long as the longest possible string you'd pass in. That's it. nidhelp wrote: but what i want to do is to pass the data directly into a database from the other computer without having the user to need to use a wizard.. Do you know any SQL ? What you're after is a simple INSERT. nidhelp wrote: my question is: how do i write/change my codes in MY computer in order for the data passed over to directly be stored in a database? (the data will not be kept in text file any more..) Connect to a database with a table that has a varchar value, and do an INSERT into it. Do you intend on making this data easy to search in any way ? Will you at least put a datastamp on it ? Christian Graus - Microsoft MVP - C++

Its more of a preference for the programmer but security-wise and readability i agree it has to be put in a different form. I usualy do my queries in a different form, pass it to another dll for sorting, editing, etc then finally pass it to my win app or web app. Hope that helps! Kampai!!!

ok thanks!i will try to do it!

I've downloaded microsoft sql 2005 server express. I've also spent the past few hours looking for step-to-step guide to start using and creating a database. However, up till now I still have no idea how to start using this sql server express. Im wondering, is visual studio .net 2003 compatible with microsoft sql 2005 server express? This is because I only see Deep Integration with Visual Studio 2005 titles/headings associated with microsoft sql 2005 server express. I would like to know what are the different database systems available that can be used with visual studio . net 2003 (yes, not 2005).. Thanks!

yes ok i understand now.. i just thought that people would understand !33tspeek easily.. so sorry about it..

ok thanks

//to make tabcontrol invisible tabControl.Visible=false; //to select particular tabpage tabControl.SelectedTab=tabPage2;

it's ok.. i managed to do it.. but it's not the way i want it exactly.. 1)how can a user close a tab page including the tab after viewing it?? i dont mean it this way: tabControl1.TabPages.Contains(tabPage4) { tabControl1.TabPages.Remove(tabPage4); } 2)how do i disallow the user from opening the same tab page of information? i dont want to disallow the button function.. just want to disallowing opening of tab page.. thanks