drexler_kk wrote:

I have select all the client company into dt1 from the database,and now how could I check if the user is typing each character into combobox2 will display the similar company name on the combobox?

I am not sure if I understand your question Do you want to auto search (Auto Complete) the results from the combobox? Meaning when you press 'A', it will fetch all the combo items starting with 'A' and so on.

Mubashir Senior Engineer Storan Technologies Inc, USA Every job is a self portrait of the person who did it.

Hello Everyone, We have just moved from a x86 system to Win2003 64-bit version and there I couldnt find the ODBC Drivers. The only driver listed is the SQL Server one. All other drivers are missing. I have some applications that are using the Text Driver and now they are failing. What should I need to install in order to get those drivers back? Thanks in advance

Mubashir Software Engineer Storan Technologies Inc, USA Every job is a self portrait of the person who did it.

modified on Friday, December 19, 2008 2:37 AM

Hi, Your question is not that specific. Here are some general steps to achieve what you want. 1. Create a database. 2. Create a table in that database that will hold your user credentials like username/password etc. 3. Create a database connection with your VB.net application. 4. Now you can do queries to your database like to insert a user or to get a user etc. Thanks,

Mubashir Software Architect Storan Technologies Inc, USA Every job is a self portrait of the person who did it.

Try and change the mail type to HTML and then you can send anything formatted well in HTML.

Mubashir Software Architect Storan Technologies Inc, USA Every job is a self portrait of the person who did it.

Mri1a wrote:

How to use .mdf file in asp.

Do you want to use ASP with SQL Server ? Bcoz MDF is a SQL Server Database file. If yes, then try google it, I believe there are thousands of articles available. If you have any problem using them...we are here to help you out. But atleast take an initiative ;)

Mubashir Software Architect Storan Technologies Inc, USA Every job is a self portrait of the person who did it.

Access the items of Arraylist like myarraylist(0), myarraylist(1) and so on. Note Arraylist item will return object so you have to cast it into the correct object (2D array in your case).

Mubashir Software Architect Storan Technologies Inc, USA Every job is a self portrait of the person who did it.

mysybet123 wrote:

Me.dataset.Table1.select ( "Col22>=0" )

Is it Me.dataset.Table(1).Select("Col22>=0") what is the error? Make sure 'Col22' is there in your dataset's table 1.

Mubashir Software Architect Storan Technologies Inc, USA Every job is a self portrait of the person who did it.

ejaz_pk wrote:

If x.Item(1).ToString = Me.TextBox1.Text Then

I think this line is causing the issue. Does your datatable has column 1?

Mubashir Software Architect Storan Technologies Inc, USA Every job is a self portrait of the person who did it.

N a v a n e e t h wrote:

Normally codebehind file used to inherit System.Web.UI.Page, Instead of this I inherited this in my CAuthentication class.

Why do you need to do this?? For your session check, you can use your existing class and I suggest you should pass the Session object to your session checker function and then check the sessions and proceed to redirection. Like public CheckAuthentication(System.Web.SessionState.HttpSessionState oSession ) { if ( oSession["login"] == null ) Response.Redirect("expired.aspx"); } Also pass the response object the same way. NOTE: Remove the inheritance from your class

Mubashir Software Architect Storan Technologies Inc, USA Every job is a self portrait of the person who did it.

Yea I am a proud Paki ;) you can find me on mubashir01@hotmail.com regards,

Mubashir Software Architect Storan Technologies Inc, USA Every job is a self portrait of the person who did it.

Good, so you are out of one problem. Now it seems like your program stuck into a never ending loop. It is a typical logical error, try debugging your code.

Mubashir Software Architect Storan Technologies Inc, USA Every job is a self portrait of the person who did it.

Sure.. For i = 0 To ordAsc.Count - 1 SelectQuery = "SELECT customers.customer_id,customers.customer_type FROM customers INNER JOIN cust_order ON customers.customer_id=cust_order.customer_id WHERE cust_order.order_id=" & ordAsc(i) & "" command = New OleDbCommand(SelectQuery, Conn) total = command.ExecuteReader() While total.Read() cstAsc.Add(total.GetValue(0)) typAsc.Add(total.GetValue(1)) End While total.Close() '<--- Next See above, right after the while loop. I see you have the same mistake in all your code. Fix them with the same

Mubashir Software Architect Storan Technologies Inc, USA Every job is a self portrait of the person who did it.

OK, see this For i = 0 To ordAsc.Count - 1 SelectQuery = "SELECT customers.customer_id,customers.customer_type FROM customers INNER JOIN cust_order ON customers.customer_id=cust_order.customer_id WHERE cust_order.order_id=" & ordAsc(i) & "" command = New OleDbCommand(SelectQuery, Conn) total = command.ExecuteReader() While total.Read() cstAsc.Add(total.GetValue(0)) typAsc.Add(total.GetValue(1)) End While Next Here you are looping thru some list and executing reader without closing it. That is why it is throwing exception. Make sure you close the reader after you finish fetching records.

Mubashir Software Architect Storan Technologies Inc, USA Every job is a self portrait of the person who did it.

I see you havnt closed your reader 'total' after the first query. try, total.Close()

Mubashir Software Architect Storan Technologies Inc, USA Every job is a self portrait of the person who did it.

sixecho wrote:

i want to know how to change data from an array to a string.

Loop through your array contents and append them in a string.

Mubashir Software Architect Storan Technologies Inc, USA Every job is a self portrait of the person who did it.

History.back to me, is not the right way as I found it useless in firefox. So Simply navigate to your WebForm1.aspx like btnDone.Attributes.Add("onClick", "window.location = 'WebForm1.aspx'; return false;"

Mubashir Software Architect Storan Technologies Inc, USA Every job is a self portrait of the person who did it.

What is the issue? Your submit1 control has a value "" (empty). And you cannot convert that empty value into boolean.

Mubashir Software Architect Storan Technologies Inc, USA Every job is a self portrait of the person who did it.

YES, see Submit1 is empty and you cannot convert "" into a boolean.

Mubashir Software Architect Storan Technologies Inc, USA Every job is a self portrait of the person who did it.

'Help me'....Off course we are here to help you. Try to give subjects that makes sense so will be a lot easier for us.

piter_crao wrote:

within a website have very link. within a link have very link how do?

Can you provide more description of what you exactly want?

Mubashir Software Architect Storan Technologies Inc, USA Every job is a self portrait of the person who did it.

Hi, You can cater the row enter event of the grid which will give you the row index of the current selected row...from there you can get each cell value in that row and populate the textboxes.

Mubashir Software Architect Storan Technologies Inc, USA Every job is a self portrait of the person who did it.