i am making use of two listboxes. the data from one listbox is transfered to other listbox on button click, bt teh the data which is selected must be added to the table in the sql server. but it is not storing values it is throwing execption...
private void InsertRecords(StringCollection sc) { SqlConnection conn = new SqlConnection("Data Source=ABCD;Integrated Security=True"); StringBuilder sb = new StringBuilder(string.Empty);
I want to start a new thread to query a database while my web application continues running. I was under the impression that by using threads I can run the querying process independently while the normal web application page cycle carries on, but I could be wrong.
public class DbAsyncQuery { Dictionary<string, object> serviceResults = new Dictionary<string, object>(); public void UpdateBillingDB() { QueryAllServices(); foreach (KeyValuePair<string, object> p in serviceResults) { IEnumerable results = (IEnumerable)p.Value; IEnumerable<object> sessions = results.Cast<object>(); DbUtil.MakeBillingDBEntry(sessions, p.Key); } } public static string[] servicesToQuery = new string[] // Must go in config file ultimately { "xxx.x.xxx.xx" }; public delegate void Worker(); private Thread worker; public void InitializeThread(Worker wrk) { worker = new Thread(new ThreadStart(wrk)); worker.Start(); } public void InitializeQuery() { Worker worker = QueryAllServices; InitializeThread(worker); } private void QueryAllServices() { Dictionary<string, DateTime> lastEntries = DbUtil.GetLastEntries(); foreach (string ip in servicesToQuery) { string fullServicePath = "http://" + ip + ":800/MyWebService.asmx"; //object[] lastEntry = new object[] { lastEntries[ip] }; object[] lastEntry = new object[] { new DateTime(2011, 1, 1, 0, 0, 0) }; object obj = WebServiceHandler.CallWebService (fullServicePath, "MyWebService", "GetBillingDBEntries", lastEntry); serviceResults.Add(ip, obj); } } }
It seems to basically stall and wait to finish the query before loading the page (which can be thousands of rows, so it takes awhile). I put this in the following section of Global.asax:
This is one of my first web pages, and I'm new to threading. I understand there is a difference between creating your own thread and using the ThreadPool. In this method, I am using my own thread, I think. Not sure if that's the best way. The querying process can be completely independent, and its only going to occur on scheduled intervals (every 8 hours or so). The user doesn't need to have up to the minute data, so it can take awhile. I just don't want the site to wait for it to finish, if that's possible.
There are numbers from 1 to 100 saved in DB Table 1.There is a Gridview, which is bind from from DB table 1. Which shows all the numbers that are there in DB Table 1 inside Gridview.
Requirement is that I have to show numbers in Gridview along with progress bar.i.e.,
if number in Gridview is 1, it should show progress 1% using progress bar if number in Gridview is is 60, it should show progress 60% using progress bar if number in Gridview is is 37, it should show progress 37% using progress bar
we are migrating existing windows form application to asp.net(3.5) intranet portal, there is a requirement whereby database connection should be made by the logged in windows user. Is it possible to achieve this functionality?
I want to load data to my application domain using a thread so it will be executed at all times. How can I achieve this? I want the thread will start when iis starts and terminate when iis exits.
Note:
I want to do this so I can use disconnected architecture in my asp.net application.
i have grid with linkbutton and path of image files how can i open that images in windows default application below is the code in rowdatabound LinkButton btn = new LinkButton();
I want to remove checked items from checklistbox (winform control) in class file method which i am calling asynchronously using deletegate. but it showing me this error message:-
Cross-thread operation not valid: Control 'checkedListBox1' accessed from a thread other than the thread it was created on.
i have tried invoke required but again got the same error. Sample code is below:
CheckedListBox1.DataSource=ds.Table[0]; CheckedListBox1.DisplayMember="Name"; CheckedListBox1.ValueMember="ID"; [intelligence Not Shown in VS But Its working fine for me].
now i want To Find out The Selected Item value in checkedListBox.
I had another thread on this problem but I wanted to start this one so no one had to look at the code I posted in the other thread. I have a successful connection but want to display data from the SQL database on my website in my Windows form application. Here's the code I have so far. Used some of the ADONET Tutorial1 here. The table Ray Rover Activation has a number of different columns but to start out I just wanted to see if I could display data for the EmailAddress column.
Code:
[code]....
If I comment out the Sub DoStuff I don't get any errors but neither is anything displayed other than the messagebox message. If I don't comment out DoStuff then I get an error, "Incorrect syntax near the keyword 'FROM'". Maybe someone could enlighten me some on what I need to do get the data in the column EmailAddress to display.
I developed an application using VS2010 and now when i try to deploy it on windows XP maching running IIS 5.1 i get the database version error which says:
The database '<database file path>' cannot be opened because it is version 655. This server supports version 612 and earlier. A downgrade path is not supported.
<database file path> . Create is aborted.
An attempt to attach an auto-named database for file <database file path> failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
I have 2 ListBoxes. 1st SelectionMode is Multiple. Once I select many options from 1st ListBox I can copy it in ListBox2 but i Unable to remove it.
Code :
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click For i = 0 To ListBox1.SelectedItems.Count - 1 ListBox2.Items.Add(ListBox1.SelectedItems(i).ToString()) ' ListBox1.Items.Remove(ListBox1.SelectedItems(i).ToString()) it is not removing. Next End Sub
I have a windows application and a web application. The windows as well as web application has a login page. The username and password are same for the windows and web application.
In the windows application, the user enters the username and password. With this username and password in windows application, is it possible to log into the web application? If yes, How to pass the data from windows application to web application, thereby logging into the web application. Is it possible to pass the username and password from a windows application to a web application?
I want a example of multithreading .i want to use it in a web form not on console.i am using C#.net .and how to use thread.sleep method for a particular thread.
I need to create a website that analyze a SQL database with Chart; I have some application that modify the database, and i want to show the changes in another application using a Chart.
i have the code for asynchronous call to the database. i execute the sql command into the begin method that will executed onto the separate thread. now i want to execute the another database call asynchronously so that this also execute onto the separate thread. code for one database cal is here....
I'm experiencing a to me mysterious error when sending e-mails through a SMTP-server from an ASP.NET web application. I get the famous error "unable to relay for xxx@yyy.zzz". What's mysterious to me is that when I cut and paste the exact same code that sends the e-mail into an usual .NET Windows Forms application, send the e-mail with this application, it all works just fine. This made me think that perhaps the problem is that the ASP.NET application runs as NETWORK SERVICE while the Windows Forms application runs on a domain user account, but it turns out that I have another ASP.NET application sending e-mail through the same SMTP-server running under NETWORK SERVER at the same IIS, and this application does not experience this problem.
I've further tried to send e-mails through the SMTP-server manually by telnet the smtp-server on port 25 and running the SMTP-protocol manually, and it all works fine. The SMTP-server is not configured with any kind of authentication or SSL.
Another mysterious fact is that the ASP.NET application can send e-mails from an adress within the same domain to an e-mail adress within the same domain, but not to any adress outside of the domain. But the Windows Forms application, that uses the exact same code, can send e-mails from any adress to any adress both within AND outside of the domain.
So to summarize:
The ASP.NET application can send e-mails from addresses within the domain to adresses within the domain, but not to addresses outside of the domain. A Windows Forms application running the same code on the same computer can send e-mails from ANY address to ANY address. Another ASP.NET application on the same IIS running under the same account (NETWORK SERVICE) can send e-mails using the same SMTP-server from ANY adress to ANY adress. There is no authentication configured on the SMTP-Server. Both the ASP.NET application and the Windows Forms application utilizes the System.Net.Mail.SmtpClient class to send a System.Net.Mail.MailMessage.
The code that sends the e-mail massage is:
private void button1_Click(object sender, EventArgs e) { MailMessage mesasge = new MailMessage(txtFrom.Text, txtTo.Text, "Test mail", txtBody.Text); SmtpClient client = new SmtpClient(); if (!(string.IsNullOrEmpty(txtUserName.Text))) //Is false since txtUserName.Text is empty client.Credentials = new System.Net.NetworkCredential(txtUserName.Text, txtPassword.Text); client.EnableSsl = false; client.Host = txtServer.Text; client.Port = 25; try { client.Send(mesasge); } catch (Exception ex) { txtResponse.Text = ex.Message; } }
As far as I can understand, this should be a matter of configuration rather than coding issues.
Can someone explain me what is is the relationship between App Domain and thread? msdn says "threads are free to cross application domain boundaries; a new thread is not created for each application domain." suppose there is one thread t inside Appdomain a1 .there is an another App domain a2 .thread t can cross to a2 from a1 means it can access a2 memory area If thread can cross the app domain boundaries share the memory space then how application domain isolation is still there?
i want a continously running thread in my web application for sending mail to admin if the logged complaint of the user in not solved by technician within 24 hours.
i am able to send mail to administrator
i just want a watch on database for unsolved issues with timespan of more than 24 hours and inform to administrator about the same
How can i add a progressbar to a search of a datagriview in my code :
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click Dim nwindConn As SqlConnection = New SqlConnection("Data Source=.SQLEXPRESS;Initial Catalog=teste1;Integrated Security=SSPI;") Dim selectCMD As SqlCommand = New SqlCommand("SELECT Username from TABELA1 WHERE Username = '" + TextBox2.Text + "'", nwindConn) selectCMD.CommandTimeout = 30 Dim custDA As SqlDataAdapter = New SqlDataAdapter custDA.SelectCommand = selectCMD nwindConn.Open() Dim custDS As DataSet = New DataSet custDA.Fill(custDS, "TABELA1") Dim bs As New BindingSource() bs.DataSource = custDS.Tables("TABELA1") ' your dataset/data table DataGridView1.DataSource = bs usernameLabel.Text = IIf(custDS.Tables("TABELA1").Rows.Count > 0, "O utilizador já existe", "Poderá registar-se com esste nome") nwindConn.Close() End Sub