Dynamically Insert single record into MS access from SQL server - C# Discussion Boards

Hello

Does anyone have already experienced the BeginGetResponse illutrated in the Microsoft example ?

http://msdn.microsoft.com/en-us/library/system.net.httpwebrequest.begingetresponse.aspx[^]

My need will be to make an hrttprequest in asynchronous mode. To not let the user wait for a response that can be processed in backround.
First I was thinking to use a BackroundWorker, then I see that begingetresponse example
But it react exacly as the BeginResponse : when I step over it wait a few seconds to get the response.
So maybe I misunderstand something but I don't see any advantage of this method ??

Thank for your help

When you run it, is it timing out? Or is it receiving a response?

The difficult we do right away...
...the impossible takes slightly longer.

BeginGetResponse will execute the method in the AsyncCallBack asynchronously. If you do like in the MSDN example then it will wait for that asynchronous operation to finish
this is the code that will cause it to wait and also implements a timeout method so if the asynchronous operation takes to long it will end the asynchronous operation.

C#

// this line implements the timeout, if there is a timeout, the callback fires and the request becomes aborted
      ThreadPool.RegisterWaitForSingleObject (result.AsyncWaitHandle, new WaitOrTimerCallback(TimeoutCallback), myHttpWebRequest, DefaultTimeout, true);

      // The response came in the allowed time. The work processing will happen in the
      // callback function.
      allDone.WaitOne();

Thank for the answer

But it seems that the BeginGetResponse itself takes long to come back

// Start the asynchronous request.
IAsyncResult result=
(IAsyncResult) myHttpWebRequest.BeginGetResponse(new AsyncCallback(RespCallback),myRequestState);

I test it a few times yesterday
But today I try again and now it return immediately !
Even if I cut the network connexion !

I probably miss something ! Confused | :confused:

Some told me that I have to wrap this code example in a dedicated thread !
But if so I dond see the advantage of using the BeginGetResponse

I'm thinking you must have missed something initially, BeginGetResponse should return immedialtely.
The only reason I would see to run that in a dedicated thread is if you want to worry about a timeout or want to ensure the asynchronous method completes like the example, as the method will block waiting for the ManualResetEvent to be set. Using the ManualResetEvent is for situations where you can't process the next step until that process has completed.

Thank you Trak4Net

Ok ... maybe I was too tired yesterday
I will try again tonight

But indeed I'm expecting that BeginGetResponse return immediately whatever the connexion state !

Some more investigation turns out this is a known issue. Apparently it blocks during the name resolution so does not return immediately as you would think. Sorry, I should have looked into it a little more before replying.

http://social.msdn.microsoft.com/forums/en-US/netfxnetcom/thread/2cb74a7e-6e8f-4d05-b86a-2401df5d2ed3/[^]

Hi ALL,

I have two databases(SQlserver and MS Access) with same schemas (same tables). SQL server database has data but Access has no data (blank database).

My goal : when user enters a ClientId and click insert button then I need to retrive that single record from all tables in sql server database and insert into tables in MS Access Database.

Achieved: i retrived from all tables in sql server databases with client id and stored the data in Dataset.

Problem: Insert into Access tables????

i have table array and i am looping thru all tables in array and trying to insert data from above dataset into Ms Access dynamically.

Can you suggest how insert into Access for all tables dynamically in loop . i cannot wrie insert statement for each table. i need one which is generic for every table so that i will pass parametrs. Its not a bulk insert, its single record push into multiple tables.

-------This is My code-------------------------------------------------------

private void InsertMsiClientIntoTest(string ClientId)
{
SqlConnection sqlConnection = null;
SqlDataAdapter sqlDataAdapter = null;
DataSet sqlserverDataset = new DataSet();
sqlserverDataset.Tables.Add();
sqlConnection = new SqlConnection();
sqlConnection = new SqlConnection("Data Source=THINK;Initial Catalog=" + dbName + ";Integrated Security=True;");
sqlConnection.Open();
sqlDataAdapter = new SqlDataAdapter(ClientSQL.PopulateTables, sqlConnection);
sqlDataAdapter.SelectCommand.Parameters.AddWithValue("@ClientId", cmbId.Text);
sqlDataAdapter.Fill(sqlserverDataset);
GetDataFromTablesForID(sqlserverDataset);
InsertAllTableDataIntoAccess(sqlserverDataset,tableArray);
}

private DataSet GetDataFromTablesForID(DataSet dsTablesList)
{
SqlConnection sqlConnection = null;
SqlDataAdapter sqlDataAdapter = null;
string tableName = string.Empty;
string QueryText = string.Empty;
int i =0;
tableArray = new string[dsTablesList.Tables[0].Rows.Count];
DataSet sqlserverDataset = new DataSet();
sqlserverDataset.Tables.Add();
sqlConnection = new SqlConnection();
sqlConnection = new SqlConnection("Data Source=THINK;Initial Catalog=" + dbName + ";Integrated Security=True;");
sqlConnection.Open();
foreach (DataRow itemRow in dsTablesList.Tables[0].Rows)
{
tableArray[i] = itemRow[0].ToString();
i++;
}
foreach (string tableItem in tableArray)
{
tableName = tableItem;

QueryText = "select x.* from" + " " + tableName + " " +
"x inner join ClientMajor ci on ci.ClientId = x.ClientId where ci.MajorClientId =@ClientId";
}
sqlDataAdapter = new SqlDataAdapter(QueryText, sqlConnection);
sqlDataAdapter.SelectCommand.Parameters.AddWithValue("@ClientId", cmbExceedId.Text);
sqlDataAdapter.Fill(sqlserverDataset);
}

return sqlserverDataset;

}

private void InsertAllTableDataIntoAccess(DataSet Inputset, string[] tableArray)
{
string connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings["mdb"].ToString();
OleDbConnection oledbConnection = null;
OleDbDataAdapter oledbDataAdapter = null;
DataSet resultSet = new DataSet();
oledbConnection = new OleDbConnection(connectionstring);
oledbConnection.Open();
foreach (string tableItem in tableArray)
{
//????????? I NEED THE FOLLOWING CODE......////////////???????
oledbDataAdapter.InsertCommand.CommandText="insert into "
oledbDataAdapter.Fill(resultSet.Tables[0]);
}
}

Thanks in Advance...

If you have two datasets 1) from MSSQL 2) from MS Access and all column names and table names match you should be able to iterate the datatables in the datasets and us importrow method to copy a row from one to the other and then use data adapter to execute update command and should use the assigned insert/update commands assigned to the data adapter to populate the data into the database.

Why would you do this Confused | :confused:

?

You have no reason to have all the data in memory at once so use a DataReader, not a DataSet.

0) ExecuteReader on the SELECT command
1) Iterate the DataReader's columns to create the INSERT command and its parameters
2) Read from the DataReader
3) Set the INSERT command's parameter values
4) ExecuteNonQuery
5) Repeat from 2 as necessary

You should also use a try/catch and a transaction.

modified 30-Jul-12 11:39am.

Hi;
How can I data transfer between two active forms. from FORM 1 to FORM 2.

You can use delegates to pass data between forms - this article[^] describes this approach in some detail.

A new Windows Phone App - Speed Dial

modified 29-Jul-12 6:33am.

Hi Abhinav, please note my comment (written today) on that article you linked to, indicating what I think is a major flaw in its implementation.

best, Bill

"Everything we call real is made of things that cannot be regarded as real." Niels Bohr

That depends on what you're transferring and why.

There are various methods to do so, some more appropriate than others depending on what your application is doing.

Form2 could expose properties that your Form1 code sets, or you could use delegates to pass data to a method on Form2, or both forms could be using the same data object where Form1 sets some values in this object and Form2 picks it up by some notification method the data object exposes, ...

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Please describe in more detail exactly what you mean by "transfer data" here.

Re the comments by esteemed colleagues, Dave Kreskowiak, and Abhinav S: I don't know why, but every time I see someone advocate using delegates, in this type of context, without also using the words "and events," a kitten inside my mind dies Smile | :)

I'll try to get over that !

thanks, Bill

"Everything we call real is made of things that cannot be regarded as real." Niels Bohr

modified 30-Jul-12 1:07am.

BillWoodruff wrote:
without also using the words "and events," a kitten inside my mind dies I'll try to get over tha

A new Windows Phone App - Speed Dial

Well, they kind of go hand-in-hand in a case like this, not that I ever use them for this.

I've got a bigger problem with "esteemed colleagues". This is like calling the crew from Animal House "proper gentlemen"! Big Grin | :-D

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

hello
how do convert any Image and gif or swf to dot matrix display and scroll it.
please send me sample code with c#.
very thanks.
hosseinjavidian@gmail.com

Never post your email address in any forum, unless you really like spam! If anyone replies to you, you will receive an email to let you know

Ideological Purity is no substitute for being able to stick your thumb down a pipe to stop the water

Image Processing for Dummies with Give this a go - C# and GDI+ Part 1 - Per Pixel Filters[^].

A new Windows Phone App - Speed Dial

You're going to have to explain exactly what you mean by "dot matrix display". Are you talking about an LED driven piece of hardware? Are you talking about some control you drop of your form? Are you talking about some LED display contorl you're creating??

Without knowing this, it's pretty much impossible to tell you "how to scroll" on this display.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

try this: A C# LED matrix display[^]

Or if you're interested in interacting with physical leds try this excelent article
I/O Ports Uncensored - 1 - Controlling LEDs (Light Emiting Diodes) with Parallel Port[^]

there are no facts, only interpretations

You do realise that the original poster doesn't get replies to questions when you reply to someone else, don't you? I don't think Dave's particularly in need of doing this.

*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington

"Mind bleach! Send me mind bleach!" - Nagy Vilmos

CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier

Pete is correct. Why are you telling ME this??

I already know this stuff, and, frankly, would NEVER use a parallel port to control anything as it's too easy to blow the port up. I'd use hardware dedicated to the purpose like something from Phidgets or a Netduino or Arduino.

Since the original poster never specified what they were using as an "LED display" the question is unanswerable. I really don't feel like going through every possibility of scrolling an image on every type of "LED display" as it would take a small book to describe them all.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak