Database

28-Oct-09 14:42

PLEASE use

 tags when posting your code.

Are you trying to get the sum of noofpages?


<pre>

Declare
  @Var INT

Select @Var = SUM(case statement)
From ....

Print '@Var     ' + Convert(varchar(1000),@Var)

Re: how to add int Value

getaccessyr28-Oct-09 22:10

getaccessyr

28-Oct-09 22:10

hi
Thanks for your reply

how can we get the NoofPages count here thru when case?

explain in detail.

regards,
Yamuna

Re: how to add int Value

Mycroft Holmes29-Oct-09 0:11

29-Oct-09 0:11

yamunarani wrote:
explain in detail.

The new snd codz plz

Sorry if you cannot work it out then I can't help you.

Never underestimate the power of human stupidity
RAH

MSSQL SERVER

MsmVc28-Oct-09 1:23

MsmVc

28-Oct-09 1:23

Hi All

How can i install and configure mssql database server for netwoek?I have a network and all machine is member of domain.How can i make connection through client with server?In the client side i have Xp OS and Server Side XP server 2003.
Plz help me

dan!sh 28-Oct-09 2:24

dan!sh

28-Oct-09 2:24

Open Surface Area configuration for your server and enable remote connections then clients will be able to connect to it through a valid username and password.

It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD

MsmVc28-Oct-09 2:27

MsmVc

28-Oct-09 2:27

Thanks for reply.I am try to do.

MsmVc28-Oct-09 18:32

MsmVc

28-Oct-09 18:32

Sorry to say there is no effect.Still i am hunting how to connect.
Can you provide me how o install MsSQL server on Server machine then configure on client machine document.
Plz help me.

Execute Nonquery : Connection properly has not been initialized

Rob Graham29-Oct-09 8:08

Rob Graham

29-Oct-09 8:08

Persumably you have access to the media for SQL Srver (it does not automatically come with Windows Server 2003, but is a separate product). If so the installation istructions for SQL Server 2008 can be found here[^]. There are similar instructions for each version of SQL Server since SQL 7.0 elsewhere on the same web server. Just navigate to the "SQL Server" node and select the appropriate version.

It is not likely that anyone will be willing to duplicate all of those instructions in a reply to your post, so your best bet is to use the provided link.

Mangesh Tomar27-Oct-09 22:56

Mangesh Tomar

27-Oct-09 22:56

i am inserting two record in data base usin txtReg and txtname using acess database when i run my program it shows following error
Execute Nonquery : Connection properly has not been initialized
here is my code

need help

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb ;

namespace studentManagementSystem1
{
public partial class StudentDetails : Form
{
public OleDbCommand cmd;
public OleDbConnection con;

string connectionString, query;
public StudentDetails()
{
InitializeComponent();
}

private void StudentDetails_Load(object sender, EventArgs e)
{

// TODO: This line of code loads data into the 'studmanageDataSet.master' table. You can move, or remove it, as needed.
this.masterTableAdapter.Fill(this.studmanageDataSet.master);

connectionString =@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\studentManagementSystem1\studmanage.mdb";

}

private void btnAdd_Click(object sender, EventArgs e)
{

int rows;

query = "INSERT INTO master(RegNo,Name)VALUES(@RegNo,@Name)";

cmd = new OleDbCommand(query, con);
con = new OleDbConnection(this.connectionString);

cmd.Parameters.AddWithValue("@RegNo", txtRegNo.Text );
cmd.Parameters.AddWithValue("@Name", txtName.Text );

try
{
con = new OleDbConnection(this.connectionString);

con.Open();
rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
MessageBox.Show("records inserted successfully");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
con.Close();
}
}

private void btnEdit_Click(object sender, EventArgs e)
{

}

}
}

Re: Execute Nonquery : Connection properly has not been initialized

Covean27-Oct-09 23:24

Covean

27-Oct-09 23:24

I would say just change the order of these two lines from:

cmd = new OleDbCommand(query, con);
con = new OleDbConnection(this.connectionString);

to:

con = new OleDbConnection(this.connectionString);
cmd = new OleDbCommand(query, con);

because you initializing your OleDbCommand (cmd) with a not initilized connection value.

Edit:
I reviewed your code and saw some other things you do wrong.
Your function btnAdd_Click should look like:

private void btnAdd_Click(object sender, EventArgs e)
{
    int rows;
    query = "INSERT INTO master(RegNo,Name)VALUES(@RegNo,@Name)";
    con = null;

    try
    {
        con = new OleDbConnection(this.connectionString); 
        con.Open();

        cmd = new OleDbCommand(query, con);
        cmd.Parameters.AddWithValue("@RegNo", txtRegNo.Text );
        cmd.Parameters.AddWithValue("@Name", txtName.Text );

        rows = cmd.ExecuteNonQuery();
        if (rows > 0)
            MessageBox.Show("records inserted successfully");
    }
    catch (Exception ex)
    {
        MessageBox.Show(ex.Message);
    }
    finally
    {
        if(con != null)
            con.Close();
    }
}

Greetings
Covean

PS: Its a not the best way to do queries in the ui-code.

Re: Execute Nonquery : Connection properly has not been initialized

i.j.russell27-Oct-09 23:25

i.j.russell

27-Oct-09 23:25

Two points:

1. This is a database forum not a c# one which is where your question should go as it's an ADO.Net issue.
2. If you have already started a thread, don't start a new one on exactly the same issue 12 hours later.

Have you even tried using Google to find an answer by searching on the error message?

Repost

Not Active28-Oct-09 1:12

Not Active

28-Oct-09 1:12

1) You have already asked this question in another thread on this forum
2) You have been advised this is not the correct forum for your question
3) It's clear you don't understand what you are doing. Go read a book, then come back and ask any questions in the appropriate forum.

only two letters away from being an asset

SSIS Permission Problem

Vimalsoft(Pty) Ltd27-Oct-09 22:05

Vimalsoft(Pty) Ltd

27-Oct-09 22:05

Good Day All

I have a Package created and hosted in a Machine(Theresa) that has SQL 2008 and i have my Development Machine(Vuyiswa) that has IIS and am Debugging from the my machine. i have a ASP.NET 2.0 App and am executing a Package that in another machine. The First thing i did was to share a directory where the Packages are stored when i install the packages and supplied "Everyone","ASP.NET","Vuyiswa" Accounts permissions to to access this share. i can go into the share from the another machine without any problem. i have a code like this in my ASP.NET App

try
       {
           //Start the SSIS Here
           Application app = new Application();
           Package package = null;
           package = app.LoadPackage(@"D:\Program Files\Microsoft SQL Server\100\DTS\Packages\OMEGA\OMEGA.dtsx", null);
           //@"C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Packages\OMEGA\OMEGA.dtsx", null);

           Variables vars = package.Variables;

           vars["Time1"].Value = time;

           vars["Time2"].Value = time;

           vars["Time3"].Value = time;

           vars["TTBLTYPE"].Value = THREAD_DATA[1].ToString();

           //package.Connections["SQLNCLI10.1"].ConnectionString = obj.GetConnectionString(THREAD_DATA[0].ToString());
           //Excute Package
           Microsoft.SqlServer.Dts.Runtime.DTSExecResult results = package.Execute();

           if (results == Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Failure)
           {
               foreach (Microsoft.SqlServer.Dts.Runtime.DtsError local_DtsError in package.Errors)
               {

                   Console.WriteLine("Package Execution results: {0}", local_DtsError.Description.ToString());
                   Console.WriteLine();
               }
           }

       }
       catch (DtsException ex)
       {
           Exception = ex.Message;
       }

This execute Fine until the

Microsoft.SqlServer.Dts.Runtime.DTSExecResult results = package.Execute();

it does not stop here , but i trap it here

if (results == Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Failure)

and the Error am Getting is

"SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E4D.\r\nAn OLE DB record is available.  Source:\"Microsoft SQL Server Native Client 10.0"  Hresult: 0x80040E4D  Description:  "Login failed for user 'sa'

On my Package i use the "sa" credentials and my Protection Level is "Dont Save Sensative"

Thank you

Vuyiswa Maseko,

Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

Re: SSIS Permission Problem

Rob Graham29-Oct-09 8:39

Rob Graham

29-Oct-09 8:39

Does your sql server support sql authentication? It is usually not enabled by default, but must be turned on.

Re: SSIS Permission Problem

Vimalsoft(Pty) Ltd29-Oct-09 20:17

Vimalsoft(Pty) Ltd

29-Oct-09 20:17

yes it does. i have resolved this Problem by adding a dts config file. The Problem was that the Connection Manager was not saving the Password. so i had to make sure that is there by Explicitly adding it in the config File.

Thank you for your Reply

EnumAvailableSqlServers does not list SQL 2000 server.

hoangthu197427-Oct-09 21:15

hoangthu1974

27-Oct-09 21:15

Hi all,

I used VS2005 with EnumAvailableSqlServers to list all the SQL Server, but when I upgrade to VS Team 2008, EnumAvailableSqlServers does not list SQL 2000 Server in the list.

Imports Microsoft.SqlServer.Management.Smo.SmoApplication

Dim dtServer As DataTable = EnumAvailableSqlServers(False)

Please help me!

Thanks a lot.

Re: EnumAvailableSqlServers does not list SQL 2000 server.

Abhishek Sur27-Oct-09 22:46

Abhishek Sur

27-Oct-09 22:46

Have you upgraded Sql Server as well ?

SMO is changed in Sql Server 2008 Smile | :)

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Microsoft Bing MAP using Javascript
CLR objects in SQL Server 2005
Uncommon C# Keywords/xml>

Re: EnumAvailableSqlServers does not list SQL 2000 server.

hoangthu197427-Oct-09 22:49

hoangthu1974

27-Oct-09 22:49

Not yet, I use SQL Server 2005 Express and SQL Server 2000. Do I have to upgrade my SQL Server to 2008?

Re: EnumAvailableSqlServers does not list SQL 2000 server.

Abhishek Sur27-Oct-09 22:53

Abhishek Sur

27-Oct-09 22:53

No... Have you taken the proper reference to SMO dll.. Actually if you have, it should be working.

The dlls will only change if you change the Version of Management objects. Check if the reference is kept intact after installing VS 2008. Cool | :cool:

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Microsoft Bing MAP using Javascript
CLR objects in SQL Server 2005
Uncommon C# Keywords/xml>

Re: EnumAvailableSqlServers does not list SQL 2000 server.

hoangthu197427-Oct-09 23:01

hoangthu1974

27-Oct-09 23:01

My VS Team 2008 DVD only have SQL 2005 Express. Thus, I have to buy SQL 2008 or only need SQL 2008 Express?
Thanks.

how to desinged tables?

iceman861627-Oct-09 15:55

iceman8616

27-Oct-09 15:55

hi everybody! I am working for a project named "Video Monitor". It required "record video by plan".
My logic designed as follow:
1.date type data.

------------------------
date               date type
---------      ------------
monday         working day
   .                     .
   .                     .
   .                     .
friday         working day
saturday      rest      day
sunday         rest      day
1.1               New Year's Day
2009.10.30   special day 1
2010.2.3      special day 2
   .                     .
   .                     .
   .                     .
--------------------------

2.day record plan

-------------------------------------------------------------------
day                  time                  action                           cameraNum
----               -------            ---------                        ------------
working day      06.00      begin record by timed                  1,2
working day      18.00      end record by timed                     1,2
rest day         06.00      begin record by move detect         3,4
New Year's day 06.00      begin record by move detect         1,2,3,4
special day 1   09.00      begin record by timed                  2
special day 1   12.00      end record by timed                     2
   .                  .                        .                                    .
   .                  .                        .                                    .
   .                  .                        .                                    .
---------------------------------------------------------------------

How to designed database and tables? column's type?...

somebody tell me to save such datas in txt file or XML file. but i think save
to database is best. am i think right?

Mycroft Holmes27-Oct-09 20:57

27-Oct-09 20:57

We use a combination of a user defined function UDF and a table called holidays, this allows us to generate a record set of #n dates and if the date is in the holiday table it is flagged. We use a combination of dayinweek and the holiday table to define processing dates. I am stuck with a Chinese New Year that does not have a fixed date.

iceman861627-Oct-09 22:43

iceman8616

27-Oct-09 22:43

Can you explain in detail, thank you!

Mycroft Holmes28-Oct-09 14:32

28-Oct-09 14:32

Do you know what a UDF is and how they function?

Create a UDF that returns a rowset with dates and their state for defined period eg 200 days from 1/10/2009

In the UDF you create a table variable that you populate using the DataAdd function in a while loop

You then update the state based of DayOfWeek function

You then do a join to the holiday table to update the state based on dates entered by the user into the holiday table

(All of the above can be achieved in 1 step but try it in 3 steps to get a feel for the processes)

Return the rowset to the stored proc that called it where it can be used in a join or select statement.