Showing posts with label vbnet. Show all posts
Showing posts with label vbnet. Show all posts

Wednesday, March 28, 2012

install of Report Designer onto a machine w/just VS 03 & VB.Net

Hi:
I recently got Reporting Services and am trying to install it. Microsoft's
web site says:
Additional Software Required to Use Specific Features in Reporting Services
a.. Microsoft Visual Studio® .NET 2003 (any edition) or the standard edition
of Visual Basic® .NET, Visual C#® .NET, Visual C++® .NET Standard, or Visual
J#® .NET to use Report Designer. Report Designer can be installed on the
same computer as Report Server components or on a separate computer.
I have the SQL Server on one box, I put most of Reporting Services on
another box (our web server), and I'm trying to put the Report Designer on
my machine.
I have VS 03, with just VB.net, installed on my machine now. It was a
discount version, and didn't have db access wizards, nor any other
languages. It's been ok because I just used System.Data.SqlClient and
System.Data.SqlTypes, etc, to specify my db access, and manually coded the
interfaces and was able to connect fine.
So I'm trying to install Reporting Services - and just the Report designer,
onto my machine so I can author a report or two without writing raw XML.
When I run the install CD I get all sorts of errors IIS not installed, etc,
etc.Where can I get some specific, applicable instructions on doing this
install ?
ThanksI think your problem is that you are trying to install the server and the
client tools. When you install just the client tools you should not be
getting any errors about IIS (IIS is not required for the development
environment).
Bruce L-C
"steve" <steve@.earthlink.net> wrote in message
news:uufO0khiEHA.632@.TK2MSFTNGP12.phx.gbl...
> Hi:
> I recently got Reporting Services and am trying to install it. Microsoft's
> web site says:
> Additional Software Required to Use Specific Features in Reporting
Services
> a.. Microsoft Visual Studio® .NET 2003 (any edition) or the standard
edition
> of Visual Basic® .NET, Visual C#® .NET, Visual C++® .NET Standard, or
Visual
> J#® .NET to use Report Designer. Report Designer can be installed on the
> same computer as Report Server components or on a separate computer.
> I have the SQL Server on one box, I put most of Reporting Services on
> another box (our web server), and I'm trying to put the Report Designer on
> my machine.
> I have VS 03, with just VB.net, installed on my machine now. It was a
> discount version, and didn't have db access wizards, nor any other
> languages. It's been ok because I just used System.Data.SqlClient and
> System.Data.SqlTypes, etc, to specify my db access, and manually coded the
> interfaces and was able to connect fine.
> So I'm trying to install Reporting Services - and just the Report
designer,
> onto my machine so I can author a report or two without writing raw XML.
> When I run the install CD I get all sorts of errors IIS not installed,
etc,
> etc.Where can I get some specific, applicable instructions on doing this
> install ?
> Thanks
>
>sql

Sunday, February 19, 2012

Inserting problem with sqlserver and vb.net

hi there i ve got a quick question regarding table and adding primary key and values
Basically i have a empty table called ReligionType and have two fields ReligionID and ReligionName. I would like to add a new data into this table (i set the indentity and identity seed in sql server but when i execute the value in sqladapter it give me error on

"An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll"

This is the code that i wrote in vb.net


con2.Open() //sql connection

Me.SqlDataAdapter2.Fill(DataSet1)

Me.SqlInsertCommand2.CommandText() = "Insert into ReligionType(ReligionName) Values (@.ReligionName) SELECT @.@.identity As 'ReligionID' GO"

Me.SqlInsertCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@.RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, False, CType(0, Byte), CType(0, Byte), "", System.Data.DataRowVersion.Current, Nothing))

Me.SqlInsertCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@.ReligionName", System.Data.SqlDbType.NVarChar, 20)).Value = inputdata.Text

Me.SqlInsertCommand2.ExecuteNonQuery()

'Me.SqlDataAdapter2.Fill(DataSet1)
con2.Close()

so where did i go wrong ?
please helpHi,
i suppose the SQL should look like this.

"Insert into ReligionType(ReligionName) Values (@.ReligionName); SELECT @.@.identity As 'ReligionID' GO"

Hope this helps.

Regards...|||thanks but it still doesnt work|||The GO command would cause a problem...

The GO command isn't a T-SQL command (although it works in Query Analyzer). Take it out and give it a try.
I haven't looked too hard at the rest of the code...|||Still when i have remove the word go it still doesnt work
ps... i forgot to mention that the data in the table is currently empty

and also have type try and catch statement and this is the result of message

"Object reference not set to an instance of an object."

so what did i do wrong ?