Page 1 of 1
DataSet with VB.NET
Posted: Wed Jun 23, 2010 9:38 am
by 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
DataSet with VB.NET
Posted: Thu Jun 24, 2010 12:36 am
by Vladimir
Hello,
Yes, you can use a dynamic data connection. We have prepared sample for you, please see the attached archive.
Thank you.
DataSet with VB.NET
Posted: Thu Jun 24, 2010 3:23 am
by 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...
DataSet with VB.NET
Posted: Fri Jun 25, 2010 2:36 am
by 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.
DataSet with VB.NET
Posted: Fri Jun 25, 2010 6:52 am
by beso
Thank you.
DataSet with VB.NET
Posted: Fri Jun 25, 2010 6:58 am
by Andrew
Always glad to help you! Have a nice day!
DataSet with VB.NET
Posted: Tue Nov 09, 2010 2:52 pm
by 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 ??!