- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
The .sdf or standard data file is used for storing data in a structured format; uses fields of fixed lengths to store values; can be imported and exported by various database and data analysis programs; commonly used for transferring data between different programs.
You need Visual Studio from Microsoft. Inside this visual Rapid Application Development (RAD) tools, you can use c++, c#, or basic language. It is lot of learning to become programmer. You can find SharpDevelop free programing studio if you want to learn more. With this program, you will need .NET packages on your computer. It is like JAVA from Sun (Oracle). It is copy from Microsoft of JAVA ideas. Like free NetBeans IDE for JAVA development. Inside studio you will have option for create New project. It can be grafical with graphical designer for draw some button, text input frame ... You will have properties for this objects, and possibility to write programming code. It is lot of learning to do real application. When you write some application you can compile it to exe output. Visual Basic is only simplest part of this technology. C# (C-sharp) need more learning, and C++ is hardest thing. Good luck!
sql is used for databases. Something like sql server, oracle, or access uses sql. It is a group of tables configured to reference eachother, so if you are programming in visual basic, you are trying to reference something on your sql server.
'declare the SQL statement that will query the database SQL = "SELECT * FROM TABLE_NAME"
'create an instance of the ADO connection and recordset objects Set Connection = Server.CreateObject("ADODB.Connection") Set Recordset = Server.CreateObject("ADODB.Recordset") 'Open the connection to the database Connection.Open ConnString
'Open the recordset object executing the SQL statement and return records Recordset.Open SQL,Connection
'first of all determine whether there are any records If Recordset.EOF Then Response.Write("No records returned.") Else 'if there are records then loop through the fields Do While NOT Recordset.Eof Response.write Recordset("FIRST_FIELD_NAME") Response.write Recordset("SECOND_FIELD_NAME") Response.write Recordset("THIRD_FIELD_NAME") Response.write "<br>" Recordset.MoveNext Loop End If
'close the connection and recordset objects to free up resources Recordset.Close Set Recordset=nothing Connection.Close Set Connection=nothing