What connection string are you using?.

Mandar Patankar Microsoft Certified professional

Please check the session time out period. In your webconfig file look into SessionState property and look for timeout atribute. This attribute decides the timeout period for your session.

Mandar Patankar Microsoft Certified professional

Ed, thanks for your response but I figured out the problem. I was running some background threads in my application and these threads were updating the windows controls like listbox and textbox.So, if user clicks on the form while these threads are updating these controls a exception was raised. The solution which I figured out and probably works fine is updating controls using delegate invoke from background threads. Common example of using methodinvoker and creating static object of the form class. Thanks Mandar Patankar Microsoft Certified professional

Thanks for replying ed. this is the error message An unhandled exception of type 'System.ComponentModel.Win32Exception' occurred in system.windows.forms.dll Additional information: Error creating window handle. this error is random. Application works fine for some time and suddenly when you are switching between tab pages this error is raised. Mandar Patankar Microsoft Certified professional

I am not sure what created this error. but the error which I got in my c# application says "Windows form exception Error creating windows handle". I dont know whether it exceded the number of handles but I am surprised that limit is atleast 1000 and I dont have 1000 controls on my form.My application has single form and one tabcontrol with 7 tabpages. There are many callback event firing in the application these events populate the listboxes on each tabpage. I read it in some message forums that controls on tabpage does exceed the number of windows handle used. IF anyone has any idea about this issue please let me know.All responses will be highly appreciated. Mandar Patankar Microsoft Certified professional

If you want a free chart component you can use OWC11 library (office web component library). I have used this and its ok. Mandar Patankar Microsoft Certified professional

First of all you need to start your web service. and See if you can view the wsdl from another machine. you can do this by typing your webservice address in webbrowser. now add a webrefrence to your client after that you should be able to consume the webservce method as normal methods. Mandar Patankar Microsoft Certified professional

Assuming that your dataAdapter is an OLeDB adapter. Here is what you can do. Change the connection string of dataadapter in button click event.open a fileopendialog box in the buttonclick event 'textPath is a textbox which displays the selected db path Private Sub dbConnect_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles dbConnect.Click OpenFileDialog1.ShowDialog() txtPath.Text = OpenFileDialog1.FileName Dim DBString As String DBString = "Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Data Source=" & txtPath.Text & ";Jet OLEDB:Engin" & _ "e Type=5;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System database=;Jet OLEDB" & _ ":SFP=False;persist security info=False;Extended Properties=;Mode=Share Deny None" & _ ";Jet OLEDB:Encrypt Database=False;Jet OLEDB:Create System Database=False;Jet OLE" & _ "DB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=F" & _ "alse;User ID=Admin;Jet OLEDB:Global Bulk Transactions=1" dataconn.ConnectionString = DBString End Sub I hope this helps Mandar Patankar Microsoft Certified professional

Create a master detail Dataset and there after bind that dataset to datagrid. Mandar Patankar Microsoft Certified professional

Yes, look into Office web component library (normally refered as OWC11) using this u can create charts and then convert them into jpeg. these charts are similar to Excel charts you can also make them interactive but I have not explored them in that depth. Mandar Patankar Microsoft Certified professional

Hi there, Instead of using the two else statement in the if block i would rather use one as follows If box1= "" and box2="" and box3="" then SQL= no query or no search else ' this indicates at least one box has the a text 'then SQl query can be as follows SQl = "Select * from Table where ColumnA=box1.text or ColumnA=box2.text or columnA=box3.text end if I hope this helps Mandar Patankar Microsoft Certified professional

I assume when you are saying combobox you are refering to windows forms and not webforms. This is what you need to do. change the the combobox MaxDropItems property to your needs. Mandar Patankar Microsoft Certified professional

I assume when you are saying combobox you are refering to windows forms and not webforms. This is what you need to do. change the the combobox MaxDropItems property to your needs. Mandar Patankar Microsoft Certified professional

Try using this Directory.Move("SourceDirName", "destDirName") I think this should solve your problem. Mandar Patankar Microsoft Certified professional

Hi there, As far as my knowledge goes, I dont think so you can create tables through queries in an access database.However there is an alternate way for this using the ADOX object.I am not aware of what programming language you are working on but I am quite sure if it works with asp it has to work on any microsoft platform (.Net,vb6) . Dim AccessTable as ADOX.Table AccessTable.Name = "Table1" AccessTable.Columns.Append ("Column1", adInteger) AccessTable.Columns.Append "Column2", adVarWChar, 30 AccessTable.Keys.Append ("PK_Column1", 1, "Column1") 'Add a primary key Hope this helps Mandar Patankar Microsoft Certified professional

what you need to do is add rows dynamically to the table source of the datagrid for eg:- you have a material table as a datasource to your datagrid.Now you dynamically add rows to this table.The rows added are material detail selected by user. the user selects specific material from the drop down combobox here is a sample code snippet Private Sub btnadd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnadd.Click Dim drow As DataRow = material.NewRow Dim drv As DataRowView = CType(cmbmatnam.SelectedItem, DataRowView) Try drow("column1") = drv("mat_id") drow("Column2") = drv("mat_name") drow("Column3") = drv("Rate") drow("Column4") = drv("Quantity") drow("Column6") = "Enter Quantity" material.Rows.Add(drow) material.AcceptChanges() Catch ex1 As System.NullReferenceException MessageBox.Show("There are No Materials In this Category") Catch ex2 As System.Data.ConstraintException MessageBox.Show("Material Is already Selected") Catch ex As Exception MessageBox.Show(ex.Message) End Try End Sub I hope this helps Mandar Patankar Microsoft Certified professional

It all depends on what type of control you are writing your text.lets assume that you are writing your text in a textbox control. Then you need to keep the width of this control fix and it will have a variable height which will be intialized at run time. keep the multiline property =false first see how many characters can fit in a single line of this textbox. Now increase the height when ever the limit is reached or you need to go to next line. lets say the textbox can fit 20 chars now if the string length is more than 20 then u need to go to next line.So increase the height of the textbox. or U can use a list box. where you can make it grow to certain height and then enable the scrollbar so that it doesnt go beyond the form boundary. hope this helps Mandar Patankar Microsoft Certified professional

I think There are several ways of doing this but of which i pretty much sure about is running your sql server instance on a server with Static IP. You also need to configure listener ports on the server. The connection string will look something like this This is Oledb provider Provider=sqloledb;Data Source=10.20.50.100,1521;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd if you are using Sql client on a Net framework skip the provider part and rest is same. I hope this is helpful enough Mandar Patankar Microsoft Certified professional

'you may need to add refrences for this to work look ADO library 'DataBase Connection parameters Public stConn As String 'Connection String Public Cnt As New ADODB.Connection 'Connection Object public StConn as String stConn = "Provider=sqloledb;" & _ "Data Source=ServerName;" & _ "Initial Catalog=Database;" & _ "User Id=sa;" & _ "Password=yourpassword;" Cnt.OPEN strconn Qry_str = "your Query Insert,Update,Delete;" Cnt.Execute Qry_str Mandar Patankar Microsoft Certified professional

Dim RecordArray() as string Dim SqlAdap as New sqlAdapter(QueryString,ConnectionString) Dim RowTable as New datatable SqlAdap.fill(RowTable) Dim Myrow as Datarow redim recordArray(rowtable.rows.count-1) as String Dim i as integer=0 'If u need to inser all the fields from the row ' u can create two dimensional array For each myrow in Rowtable.rows recordArray(i) = myRow(0) i+=1 next Mandar Patankar Microsoft Certified professional