Database

VB and remote database(web)

4-Sep-05 9:38

I am not quite sure I undestand the purpose of your request...

-Is the problem to avoid any users to make changes within your transaction scope..
-Or is the issue to get an over view of other user transactions on the database..

-A hint would be to try execute the folowing stored procedure 'sp_lock'
this will give you all information about existing locks..

Re: Update DataSet

Zeeshan Gulzar6-Sep-05 5:51

Zeeshan Gulzar

6-Sep-05 5:51

Thanks for reply

I am trying with example.

I have a datagrid shows, currect prices of shares, bound with dataset. I update my local dataset with DB after every 2 second. I think it is a poor design. Because if one row is updated in any 2 second, i update full dataset.

I want, this datagrid shows current share prices, which is updated in DB through my background service without updating the whole dataset.

Zeeshan

aluizs2-Sep-05 18:03

aluizs

2-Sep-05 18:03

Hi.

I would like connect a database (acess) on web using vb, but I do not know do a connection string.
Do you could help me send me a string or said where I can found it.

Thanks
André

inset a Datacolumn

PaulaM2-Sep-05 3:23

PaulaM

2-Sep-05 3:23

hi im a newbe at C# and ado.net,only started three months ago my question is:
i want to add a column at the beginning of a my bound datatable,how do i do that?

code example in c# would be appreciated

thanks for the help

regards paula

Re: inset a Datacolumn

Besinci2-Sep-05 9:37

2-Sep-05 9:37

Try YourTable.Columns 's add method where you define a new DataColumn..

But.. this does not guaranty the insert at in the beginneng of the columns, this depends on the existing columns in your table. -To do that
first you have to empty the table for columns YourTable.Clear method will do this, -but before you do this you have to temporarily store any existing columns. then you add your new column and afterwards add the other columns to the table..

Here, code sample for your pupose..

System.Data.DataTable yourTable= new System.Data.DataTable("YourTable");

System.Collections.ArrayList myExistingColumns = new System.Collections.ArrayList();
foreach (System.Data.DataColumn column in yourTable.Columns) //keep any axisting columns..
{
myExistingColumns.Add(column);
}

yourTable.Columns.Clear(); // remove all columns.
yourTable.Columns.Add(new System.Data.DataColumn("MyNewColumn")); //add a new column at the ordinal 0.

foreach (object column in myExistingColumns) //let's movve the existing column back to the table
{
yourTable.Columns.Add((System.Data.DataColumn)column);
}

updating the DB

minkinin2-Sep-05 3:16

2-Sep-05 3:16

Hi guys pls help,I want to add a new column to more than 500 tables in the database,pls help how can I do that.anyone who can provide me with a code?????????? Big Grin | :-D

cheerz

Besinci2-Sep-05 10:04

2-Sep-05 10:04

Good luck hehe Smile | :)

You have to automate this somehow.. but don't panic.. I assume it's a SQL-database you are using.

1. you have to traverse all tables for your purpose.. tablenames is stored in the sysobject table.
2. for each table you have to fire ALTER table sql statement.. syntaxt is as following..

sample....

Examples
A. Alter a table to add a new column
This example adds a column that allows null values and has no values provided through a DEFAULT definition. Each row will have a NULL in the new column.

ALTER TABLE doc_exa ADD column_b VARCHAR(20) NULL

B. Alter a table to drop a column
This example modifies a table to remove a column.

ALTER TABLE doc_exb DROP COLUMN column_b

C. Alter a table to add a column with a constraint
This example adds a new column with a UNIQUE constraint.

ALTER TABLE doc_exc ADD column_b VARCHAR(20) NULL
CONSTRAINT exb_unique UNIQUE

minkinin4-Sep-05 20:20

4-Sep-05 20:20

Does that mean that I have to fire ALTER table sql statement for each table manually?I actually want to autamate a text file looping through the table names in the sysobject table,also excluding the sys tables when altering,how can I do that?
pls help.
Thanx Guys!!

Besinci4-Sep-05 21:24

4-Sep-05 21:24

Sure you have to fire a Alter table statement...

I could provide you with a code sample... but later on the day if you are patient.

unless..

You have to read all tablenames from the sysobject-table with the xtype of 'U' and furthermore you have to deselect the tablename 'dtproperties' too, I gues the name is. -This will filter all the usertables.

minkinin4-Sep-05 22:27

4-Sep-05 22:27

Sure I am patient.
how can I generate a SQL script Automatically using a code?
something like" Alter Tabe MyTable
ADD Column Null
Default getdate()
pls help???

Besinci5-Sep-05 7:49

5-Sep-05 7:49

Here you go Smile | :)

this will do it..

using System;

namespace Tester
{
///

/// Summary description for Class2.
///

public class Class1
{

public Class1()
{

}

public void GenerateColumns(System.Data.SqlClient.SqlConnection connection)
{
string selectstr = "SELECT name FROM sysobjects WHERE xtype ='U' AND name <> 'dtproperties' ORDER BY name";//select only user tables
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(selectstr, connection);
cmd.Connection = connection;

cmd.Connection.Open();
System.Data.SqlClient.SqlDataReader dr = cmd.ExecuteReader();
while(dr.Read())
{
this.AddColumn(dr.GetString(0), cmd.Connection.ConnectionString);
}
cmd.Connection.Close();
}

private void AddColumn(string tableName, string connnectionStr)
{
//ALTER TABLE table ADD column VARCHAR(20) NULL
string alterTableStr = string.Format("ALTER TABLE {0} ADD {1} {2} {3}", tableName, "YourColumnName", "datetime Default getdate()", "NULL");
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(alterTableStr, new System.Data.SqlClient.SqlConnection(connnectionStr));
try
{
cmd.Connection.Open();
cmd.ExecuteNonQuery();
}
catch(System.Exception e)
{
System.Windows.Forms.MessageBox.Show(e.Message);
}
finally
{
cmd.Connection.Close();
}
}
}
}

-- modified at 14:02 Monday 5th September, 2005

minkinin6-Sep-05 23:38

I need to load custom data to Analysis Server (MS-OLAP) without going through any OLE DB Provider.

6-Sep-05 23:38

Thanx Guys!!
that code really helped me.
keep on helping the others.
cheerz...... Laugh | :laugh:

kuldeepjangir2-Sep-05 3:13

kuldeepjangir

2-Sep-05 3:13

Hello,

I am developing an application where I need to load custom data to Analysis Server (MS-OLAP) without going through any OLE DB Provider.
I am able to load data into dimensions/cubes using Microsoft OLE DB provider for ODBC Drivers. But my requirement is loading data at runtime from a buffer. Is there any way to do this? Are there any APIs which can help me to load this data directly?

Thanks & regards,
kuldeep kumar

SqlDataAdapter question.. What....

Besinci2-Sep-05 2:40