Re: Access dataset update into Sql sever - C# Discussion Boards

N a v a n e e t h17-Oct-07 19:55

17-Oct-07 19:55

You have to specify update command in DataAdapter. Then call DataAdapter.Update(DataSet)

My Website | Ask smart questions

pekhaleyogesh17-Oct-07 20:14

pekhaleyogesh

17-Oct-07 20:14

i writr following code
Hi there,

I have two databases, MS Access and SQL Server 2000

Using a procedure in Visual Studio i would like to copy all the records from one table in MS Access into an existing table in SQL Server (the tables have the same name and the same layout)

I tried to prepare one Dataset to copy from Access into SQL Server but when i run the command 'DaSQL.Update(DsSQL, "Tabella") nothing happens (not even an exeption has been raised), looking during debug, the DataSet seems filled though...

Please could anyone explain what's wrong and / or is there a more quicker way to copy data from a table to another?

Note i woul have as a final goal to get data from an AS400 database by ODBC, manage it, and put it on SQL Server for a 'data mining' scope (eliminating the use of MS Access, not suited for FE-BE).

the procedure goes like this;

' Create a connection to the MS Access Database

Dim connectionToAccess As New OleDbConnection(DBConnectionAccString)

strsql = "SELECT * FROM [TABELLA]"

connectionToAccess.Open()

Dim DaAccess As New OleDbDataAdapter(strsql, connectionToAccess)

Dim DsAccess As New DataSet("ACCESS")

DaAccess.FillSchema(DsAccess, SchemaType.Source, "Tabella")

DaAccess.Fill(DsAccess, "Tabella")

' Create a connection to the SQL Database

Dim connectionToSQL As New SqlConnection(DBConnectionSQLString)

connectionToSQL.Open()

Dim DaSQL As New SqlDataAdapter(strsql, connectionToSQL)

Dim DsSQL As New DataSet("SQL")

DaSQL.FillSchema(DsSQL, SchemaType.Source, "Tabella")

DaSQL.Fill(DsAccess, "Tabella")

DaSQL.Update(DsSQL, "Tabella")

Note I tried also the following, withou a result;

DsSQL = DsAccess.Copy

DaSQL.Update(DsSQL, "Tabella")

Please is there someone who could respond !!???

Yogesh Pekhale
pekhaleyogesh@gmail.com

Tobias Schoenig17-Oct-07 19:57

Tobias Schoenig

17-Oct-07 19:57

Hi,

there's a method called SqlDataAdapter.Update(DataSet myDS). This method should solve your problem.

Tobias

pekhaleyogesh17-Oct-07 20:14

pekhaleyogesh

17-Oct-07 20:14

Yogesh Pekhale
pekhaleyogesh@gmail.com

Click event in DOM document

I.explore.code17-Oct-07 21:44

I.explore.code

17-Oct-07 21:44

hi I believe u r using C# for all this. now in .NET 2005, u have different namespaces for different types of the DBs for eg. OleDB for Access and SqlClient for SQL server 2000/05, but the good news is that one thing remains common in the both and that is Dataset.

So now from ur question, I infer that u want to transfer ur data from Access to SQL server, if thats right, then the one way is to , first populate the dataset1 with data from Access for different tables, follow the same approach. Now u can put this data in a datagrid and then finally use properties and constructors u insert all the grid rows one by one using a for loop into ur SQL server DB.

Other approach is to use SQL servr Integration Services (SSIS) directly to transfer data from any data source to any destination.

A.Asif17-Oct-07 19:37

A.Asif

17-Oct-07 19:37

Hi All,

I am writing a project in C# using a web browser control. Objective of this project is to automate the browser. I have an element that I want to be clicked automatically. I am using mshtml.IHTMLDocument3 interface to access DOM document and then find the element by ID. Once I do find the element by ID, I cast it to mshtml.IHTMLElement; but when I do that, I get null reference to mshtml.IHTMLElement variable. Therefore, my click method does not work. Please Help. I need this for my job.

mshtml.IHTMLDocument3 doc = (mshtml.IHTMLDocument3)this.LPBrowser.Document.DomDocument;

doc.getElementById("newlink");

mshtml.IHTMLElement a;

a = (mshtml.IHTMLElement)doc; //Casting here but a becomes null

a.click(); //null.click() so this doesn't work

Thanks.

Abdul Asif.

Re: Click event in DOM document

Guffa17-Oct-07 19:49

Guffa

17-Oct-07 19:49

The getElementById method returns a reference, it doesn't convert the doc variable into an element reference.

---
"Anything that is in the world when you're born is normal and ordinary and is just a natural part of the way the world works. Anything that's invented between when you're fifteen and thirty-five is new and exciting and revolutionary and you can probably get a career in it. Anything invented after you're thirty-five is against the natural order of things."
-- Douglas Adams

How to move picturebox along with cursor movements

Chintan.Desai17-Oct-07 19:19

Chintan.Desai

17-Oct-07 19:19

Hi all guys,

I am building one eFlowchart whose work is similar to normal paper flowchart.There are lots of picturebox ctrl on eFlowchart.I hav to allow author to connect all picturebox with its connector.

But main problem is how to move picturebox smoothly with mouse cursor.I am using mouse_down and mouse_move event.

I have taken click coordinates in mouse_down event with e.x and e.y and then making plus-minus in mouse_move event, but still I am getting slight a bit roughness in ctrl movements.ctrl in design time in visual studios are very smooth,I wanna that type of smoothness.

Pls help

Thank you guys.

Regards
Chintan
www.visharadsoft.com
(I am thinking to change humans to computer, but unfortunately GOD will not give me the source code)

Re: How to move picturebox along with cursor movements

Abhijit Jana17-Oct-07 19:35

Abhijit Jana

17-Oct-07 19:35

Hi Chintan,
Here is ur soln~ Laugh | :laugh:

Delcare these varibale as private
Private dragging As Boolean
Private beginX, beginY As Integer

Private Sub PictureBox1_MouseDown(ByVal sender As System.Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles PictureBox1.MouseDown
dragging = True
beginX = e.X
beginY = e.Y
End Sub

Private Sub PictureBox1_MouseUp(ByVal sender As System.Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles PictureBox1.MouseUp
dragging = False
End Sub

Private Sub PictureBox1_MouseMove(ByVal sender As System.Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles PictureBox1.MouseMove
If dragging = True Then
PictureBox1.Location = New Point(PictureBox1.Location.X + e.X - beginX, PictureBox1.Location.Y + e.Y - beginY)
Me.Refresh()
End If
End Sub

Good luck Cool | :cool:

Let me know when done !!!! Wink | ;)

Happy Programming
-----
Abhijit

Re: How to move picturebox along with cursor movements

Chintan.Desai25-Oct-07 22:55

Chintan.Desai

25-Oct-07 22:55

Hi abhijit

Ya, you are correct tht I had already posted the question and also got the solution frm u,but all this I had programmed for child picture boxes on form control, but now as my requirement got change, I have to move every child picturebox on picture box ctrl ( instead of form control ).

When i move the child picturebox on picture control from xy1 location to xy2 location then picture looks like blur ( it seems that its own ghost is following at each mouse_move event).I am not getting the smotheness in dragging.

pls reply

thx

Regards
Chintan
www.visharadsoft.com
(I am thinking to change humans to computer, but unfortunately GOD will not give me the source code)

How can I add properties to a property?

JoeRip17-Oct-07 19:05

JoeRip

17-Oct-07 19:05

I want to wrap an object and add properties to that object's properties.

IE, I currently consume an object called Song. Song has a property called Artist.

I happen to know that the Artist can only be 256 chars long. But I want my code to be able to refer to that value programmatically, like this:

Song myTune = GetSong("Hello Dolly");

int x = myTune.Artist.MaxLength;

How can I do this? How do I "add" a property to the existing property of an object? Is that allowed syntactically?

JoeRip17-Oct-07 19:21

JoeRip

17-Oct-07 19:21

That was not asked well.

I want to create my own class that wraps Song. So, I'll actually end up with something like:

// get the Song
Song aTune = GetSong("Hello Dolly");

// wrap that Song in my own object
mySongObject mySong = new mySongObject(aTune);

// Get the Artist of the Song
string artist = mySong.Artist;

// Get the maximum length of the Artist property
int x = mySong.Artist.MaxLength;

The above example assumes that my class is a base class that takes a Song as it's argument. However, I could instead derive my class from Song, and use a cast. Which of these approaches is best here?

Then, once that's settled - can both mySong.Artist and mySong.Artist.MaxLength yield values? If so, how do I implement this?

Guffa17-Oct-07 20:01

Guffa

17-Oct-07 20:01

JoeRip wrote:
I could instead derive my class from Song, and use a cast.

No, you couldn't. That would enable you to cast your object to Song, but not the other way.

JoeRip wrote:
can both mySong.Artist and mySong.Artist.MaxLength yield values? If so, how do I implement this?

You can create a class for the Artist property, that has properties and an implicit conversion to string. That way you can both get the artist as a string and get properties from it:

public class LimitedString {

   private string _value;
   private int _maxLength;

   publlic LimitedString(string value, int maxLength) {
      _value = value;
      _maxLength = maxLength;
   }

   public string Value { get{ return _value; } }
   public int MaxLength { get { return _maxLength; } }

   public static implicit operator string(LimitedString limited) {
      return limited.Value;
   }

}

N a v a n e e t h17-Oct-07 19:41

17-Oct-07 19:41

JoeRip wrote:
How do I "add" a property to the existing property of an object? Is that allowed syntactically?

Yes it is allowed.

JoeRip wrote:
int x = myTune.Artist.MaxLength;

In song class Artist should be a property for a class which contains MaxLength property. See the below example

public class Song
{
	public SongArtist Artist
	{
		get{}
		set{}
	}
        public static void Main()
	{
		Song mySong = new Song();
		int x = mySong.Artist.MaxLength;
	}
}

public class SongArtist
{
	public int MaxLength
	{
		get {}
		set {}
	}
}

My Website | Ask smart questions

JoeRip17-Oct-07 19:45

JoeRip

17-Oct-07 19:45

I'm not quite following. What is happening in the Main() method of this class?

N a v a n e e t h17-Oct-07 19:54

how to get the innerHtml from iframe in C# ?

17-Oct-07 19:54

Creating object for Song class. In your example you are getting the object from GetSong() method. You can change that in your way

My Website | Ask smart questions

classes

kabutar17-Oct-07 19:02

kabutar

17-Oct-07 19:02

hi,
while using inheritance if we have two classess ie animal and bird -when do we craete a new object this way in main function

animal obj = new bird();

and when are the instances that we create an object to call a method::

i know that we do so wen we have to call a method from another class and to call a nonstatic function into a static function again we create an object.

otherthan these what are the other instances we do so ......
thanks

Re: classes

Chintan.Desai17-Oct-07 19:33

Chintan.Desai

17-Oct-07 19:33

1st learn to write proper question, then expect to get proper answer.

Regards
Chintan
www.visharadsoft.com
(I am thinking to change humans to computer, but unfortunately GOD will not give me the source code)

Re: classes

kabutar17-Oct-07 19:35

kabutar

17-Oct-07 19:35

what are the times that we create an object to call a method::

i know that we do so wen we have to 1) call a method from another class and
2)to call a nonstatic function into a static function again we create an object.

otherthan these what are the other instances we do so ......

thanks

kkun17-Oct-07 16:51

kkun

17-Oct-07 16:51

how to get the innerHtml from iframe in C# ?
thanks ~

Re: how to get the innerHtml from iframe in C# ?

N a v a n e e t h17-Oct-07 18:58