SQLite and msvc - Database Discussion Boards

Re: Setting up SQL Server 2005

NewbieDude12-Mar-06 18:49

12-Mar-06 18:49

Hi Chandana,

When I installed VS 2005, SQL Server 2005 Express installed aswell, but I do not have the server management studio, I just have:

-Configuration manager
-Surface area manager
-Error usage and reporting

Thats it, does this mean I have installed all the components properly?

Re: Setting up SQL Server 2005

Chandana Subasinghe12-Mar-06 23:54

Chandana Subasinghe

12-Mar-06 23:54

hi yes you need to install SQL server management studio

Re: Setting up SQL Server 2005

NewbieDude12-Mar-06 23:56

NewbieDude

12-Mar-06 23:56

Thanks its all sorted now...the express technical community preview addition has some bugs i have found!

Re: Setting up SQL Server 2005

Chandana Subasinghe10-Mar-06 7:52

Chandana Subasinghe

10-Mar-06 7:52

This may be valuable for you .

http://www.aspfree.com/c/a/MS-SQL-Server/SQL-Server-2005-Introduction-to-SQL-Server-Management-Studio/[^]

Re: Setting up SQL Server 2005

Illegal Operation12-Mar-06 18:18

Illegal Operation

12-Mar-06 18:18

You need to install SQL Server Management System. You can download it from Microsoft.com.

Illegal Operation

Making Computer Software Talk

Send a Value in to a Parameter field from Formula fields?(Crystal report)

superdragon9-Mar-06 19:59

superdragon

9-Mar-06 19:59

Now, i have a formula, after solving some expression i want to assign a new value to a Parameter fields.
But i dont know how to do it.
Please help me!

superdragon

How to include SQLNCLI.1 as a provider that has in-process access in SQLSERVER2005

kh1219-Mar-06 19:21

kh121

9-Mar-06 19:21

Hi,

I get the following type of error when using SQLSERVER2005 with databases with compatibility level 80(sql2000).

-OLE DB error: OLE DB or ODBC error

According to Microsoft help(http://support.microsoft.com/kb/907284), I should be able to do the following as a work around

-In SQL Server, explicitly add SQLNCL.1 to the list of providers that have in-process access

Any help on how to do this in SQLSERVER2005??

Thanks a lot..

k

SQLite and msvc

Waldermort9-Mar-06 18:05

Waldermort

9-Mar-06 18:05

I have never worked with databases before, and my C++ skills are only at the intermediate level. I have been asked to make a program which can store and keep track of students. My first attempt at this involved using Excel to store the data (records are imported from xls files), but this is proving a little more problematic than I care for. I have come to realise that I need a real Database.

I have been advised that SQLite would be ideal in my situation, so I went and downloaded it. Problem is I now have a dll and a lib, with no clue how to use them. I have searched the interent high and low for tutorials or examples showing how to incorporate SQLite into an MSVC project, but I have found nothing.

Could somebody please show me an example of how to use this, preferably in a non-MFC environment.

Also from what I understand there is one main database file which may hold several tables. I'm a little unsure how I should structure this. The end result would hold several thousand students, each divided by year and class. Then for each student I need to be a able to pull a performance record which would hold all the exam results for the students tenure in the school.

Any help with one or both of these matters would be greatly appreciated.

Thankyou

Re: SQLite and msvc

Waldermort9-Mar-06 23:59

Waldermort

9-Mar-06 23:59

Eeek, I completely missed this[^] I was looking under the SQL subheading rather than the General. My bad.

My second question still stands though. I would appreciate any advice on how to structure my data.

High importance: How to map the data tables in a remote database to local memory?

zhaoyu1629-Mar-06 17:30

zhaoyu162

9-Mar-06 17:30

How to map the data tables in a remote database to data tables in local memory, if using .net classes?
So, I can get some DataTable instance. thanks.

Re: High importance: How to map the data tables in a remote database to local memory?

Colin Angus Mackay9-Mar-06 23:33

Colin Angus Mackay

9-Mar-06 23:33

Use a SqlDataAdapter (assuming you are using SQL Server) to get the data from the remote database and Fill a DataSet/DataTable.

ColinMackay.net
Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?

Re: High importance: How to map the data tables in a remote database to local memory?

Colin Angus Mackay10-Mar-06 6:09

Colin Angus Mackay

10-Mar-06 6:09

If you don't like my previous answer then you might like to elaborate on your problem.

ColinMackay.net
Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?

-- modified at 12:09 Friday 10th March, 2006

Re: High importance: How to map the data tables in a remote database to local memory?

zhaoyu16210-Mar-06 14:57

zhaoyu162

10-Mar-06 14:57

Thank Colin Angus Mackay;P very much, i have gotten desired result according your answer.

[MySQL + .net] Getting SQL query from MySqlCommand object

Distinctive9-Mar-06 12:34

Distinctive

9-Mar-06 12:34

I'm using MySQL on an ASP.net project, using the official .NET data provider to connect to my MySQL database.

What I want to do is get the final SQL command that my MySqlCommand object uses after I've set it's parameters and asked it to execute the query.

MySqlCommand.CommandText returns my original SQL with my parameter place holders, but I want to see the actual SQL used.

For example, I create my SQL queries by the following:

string _SQL = "SELECT name FROM users WHERE department = ?department; "; <br />
<br />
MySqlCommand DbCom = new MySqlCommand(_SQL, DbCon);<br />
DbCom.Parameters.Add("?department", MySqlDbType.VarChar, 25);<br />
DbCom.Parameters["?department"].Value = "engineering";<br />
MySqlDataReader DbRDR = DbCom.ExecuteReader(); <br />
<br />
[SNIP]... CODE HERE ...[/SNIP]<br />
<br />
DbRDR.Close(); <br />
DbRDR = null; <br />
DbCom.Dispose();

If I use "DbCom.CommandText" it will return "SELECT name FROM users WHERE department = ?department; ", but I want it to return the actual query which would be "SELECT name FROM users WHERE department = `engineering`; "

Can anyone please enlighten me on how to do this?

Thanks

Re: [MySQL + .net] Getting SQL query from MySqlCommand object

Colin Angus Mackay10-Mar-06 6:20

Colin Angus Mackay

10-Mar-06 6:20

The idea of using parameters in a command is to separate the actual command from the data used to modify the command. That is, it splits the parameters away from the actual command as a way of reducing the possibility of a SQL Injection Attack. It sends the two pieces of information to the database as command + parameters rather than concatenating the parameters into the command before being sent to the database.

Distinctive wrote:
it will return "SELECT name FROM users WHERE department = ?department; "

That looks correct to me. That is your command text.

Distinctive wrote:
but I want it to return the actual query which would be "SELECT name FROM users WHERE department = `engineering`; "

Look at it this way. If you have a line of C# code like this:

Console.WriteLine("Hello my name is {0}", name);

Would you expect the compiler to be able to tell you what the "actual command" is? It can't until runtime, because until runtime name has an unknown value.

[DISCLAIMER: I've not used MySQL and the above is based on how other database data providers work in .NET and any provider produced by a third party may not operate in the same way.]

ColinMackay.net
Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?

Re: [MySQL + .net] Getting SQL query from MySqlCommand object

Distinctive10-Mar-06 11:33

Distinctive

10-Mar-06 11:33

Thanks for your help, that makes sense to me, I didn't realise that it worked that way.

Updating a record from a table and returning the updated record.

PeteConc9-Mar-06 8:04

PeteConc

9-Mar-06 8:04

Hello. I am making a stored procedure with the following SQL statement:

Update Table1 set Field1='X'
Where Field2 = 'N'

I want the StoredProcedure to return Field3 from the updated record. Is it possible to do this?

Thanks.

Re: Updating a record from a table and returning the updated record.

Daniel Santillanes9-Mar-06 8:30

Daniel Santillanes

9-Mar-06 8:30

sure

right after your update, put the select statement

select field3 from table1 where field2 = 'N'

and execute your stored procedure with either

cmd.ExecuteReader() / cmd.ExecuteScalar()

daniero

Re: Updating a record from a table and returning the updated record.

PeteConc10-Mar-06 0:24

PeteConc

10-Mar-06 0:24

Actually that's not exactly what I wanted. The example I gave was not complete. Here's what I want to do:

- Select @Res = max(Y) From table1 where X=0
- Update table1 set X=1 where Y = @Res

I want to get the max record where X=0 and then update that record. The problem is that there may be two processes executing this stored procedure at the same time.
Thus, they may execute the 'select' part at the same time, get the same 'max(Y)' and then update the same record. That's what I wnat to avoid. I need to assure that between the 'select' and the 'update' there is no process accessing the same record in the table. This is a concurrency problem.

Retrieve data randomly from SQL

Armando_Ramirez9-Mar-06 6:55

Armando_Ramirez

9-Mar-06 6:55

Hi ¡
Im trying to retrieve data from a SQL table in Visual Web Developer 2005. Depending of the value from a column a GridView displays the entire register of the SQL Table Row, but the value of that column should be generated randomly...

Any Idea?

THANX ¡¡

net 2

papa19809-Mar-06 5:38

papa1980

9-Mar-06 5:38

Hello every body i am sorry for this question but i am beginer in web developing and i don't get it how to edit dada in gridview in net 2.0
please if some body can help me.
good bye
best regars
down i apply the text
DataSet ds = new DataSet();
ds = SqlFunction.EditBook();
if (ds != null)
{
//
DataView dv = new DataView();
dv.Table = ds.Tables["Table"];
// string str = ds.Tables[0].TableName.ToString();
// HttpContext.Current.Trace.Write("Table name=",str);
/* DataGrid datagrid1 = new DataGrid();
datagrid1.DataSource = dv;
datagrid1.DataBind(); */

GridView1.DataSource = dv;

GridView1.DataBind();

}
else
{
HttpContext.Current.Trace.Write("Error in EditBook");
}

Quick run-down on directories 80, 90, msql.1 vs mssql.2 mssql.3

LuluSailor9-Mar-06 4:13

LuluSailor

9-Mar-06 4:13

Anyone have quick explanation or link to info about what these directories are all about... what are they for?

I am not having any particular problems, but I am wondering what they are for.

Re: Quick run-down on directories 80, 90, msql.1 vs mssql.2 mssql.3

Mike Dimmick9-Mar-06 11:46

Mike Dimmick

9-Mar-06 11:46

The '80' directory contains client tools and any components shared between instances of SQL Server 2000 (which is version 8.0). The '90' directory similarly contains client tools and components shared between instances of SQL Server 2005 (version 9.0).

Directories named MSSQL.n and MSSQL$name contain the program files and (by default) data files for a particular instance of SQL Server. Different instances can be at different service pack levels, which is why they've got separate copies of a lot of the program files.

Stability. What an interesting concept. -- Chris Maunder

Question

Hamid_RT9-Mar-06 3:59

Hamid_RT

9-Mar-06 3:59

Hi all,
How to use Linked servers (sp_addlinkedserver)
thanks

Re: Question

shm5314-Mar-06 7:19

shm53

14-Mar-06 7:19

Look at Books online. There is a full explanation there. You can also go to MSDN and search for linked servers

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.