DataSet with VB.NET

[beso]

Is The possible To Set a Connection and dataset For Stireport, dinamicali (i mean from VB.Net code in web APP) ????
Or Only connection string;
Or how send username and passwor if it dont write in connection string

[Vladimir]

Hello,

Yes, you can use a dynamic data connection. We have prepared sample for you, please see the attached archive.

Thank you.

[beso]

Hello,
Thank you...
Can you help Me prepar sample code for SQL Server connection ... I hev Data on Sql Server.... please... excuse me!.
Thank you...

[Vladimir]

Hello,

This is a question of Microsoft .NET Framework. You can read about this in the documentation about ADO.NET, or on numerous websites. For example,

Code: Select all

// SQL Connection String
string connString = "Data Source=SERVER\SQLEXPRESS;Initial Catalog=master;Integrated Security=True";
// Create the data adapter
SqlDataAdapter dataAdapter = new SqlDataAdapter("SELECT * FROM users ORDER BY username", connString);
// Create the DataSet
DataSet dataSet = new DataSet();
// Fill the DataSet using our DataAdapter
dataAdapter.Fill(dataSet);

Thank you.

[beso]

Thank you.

[Andrew]

Always glad to help you! Have a nice day!

[hadisaadat_du]

Hi every body.
I sea allmost all topic in forum and seem int all of them posit that we know what is our tables and columns in dataset of our reportbut allways not thus 1-sometime we may want to edit the report in webdesigner that we dont know any thing about its data set but we sure it works with our data base , so befor call the design() function we pass what data set to our report via regdata(//what_dataset) ??
2- or we may want to set full access to data base to one user to create the every report that need to design well we pass a full data base to designer dictionary and he/she design every report by every columns in every tables or viwes in database and save it , in viwe report mode namely after load our report and we want to pass it to stiwebviewer we pass what data set to it since we cant pass all data base to our report ??!