Topics

i have a talbe that contains 60M to 100M rows of data column name.....data type.....length ...key..................char...........42 ...desc................varchar......200 ...ref...................int...............4 all three columns are indexed and key is the primary key. i am doing the following operation: if (!DataIsInTable(key)) InsertIntoTable(key); it's fairly slow when the number of rows are 100M. i wonder if there are some advanced method to improve its performance? what happen if i don't check if the data is in the table? would the failing process faster than selecting? thankx....

Here's the situation... I have web user control (.ascx) that has some properties I would like to define when the user control is added to the form. Currently I am under the impression that the code (c#) in the user control should be: public string name { get { return name; } set { name = value; } } and then in the web form's asp.net code I set the name when I declare the user control: <uc1:WebUserControl1 id="WebUserControl11" name="testing" runat="server"></uc1:WebUserControl1> If I don't declare the name there then it all works fine (except I have an unnamed control) Can anyone see what I'm doing wrong?

I get "Option Strict disallows late binding" error on the lines shown. What am I doing wrong? Dim dr As DataRow dr = ddlDC.DataSource.Tables(0).NewRow dr.Item(0) = "ALL" dr.Item(1) = "ALL" ddlDC.DataSource.Tables(0).Rows.InsertAt(dr, 0)

I have a ListBox control bound to an ArrayList: Dim m_expressionFilters As ArrayList Dim m_expressionBindingManager As BindingManagerBase m_expressionFilters = New ArrayList m_expressionBindingManager = BindingContext(m_expressionFilters) lstboxFilters.DataSource = m_expressionFilters When I add an Item to the ArrayList, that change is immediately reflected in the ListBox: m_expressionBindingManager.SuspendBinding() m_expressionFilters.Add(CurrentFilter) m_expressionBindingManager.ResumeBinding() However, when I call the Clear method of the ArrayList, the changes are not reflected in the ListBox: m_expressionBindingManager.SuspendBinding() m…

I have converted a VB6 application to be .net that gets appointments from a MySQL database and then writes them to several user's calendars in Exchange 2003. All is fine and dandy until the code goes to update a MAPI.AppointmentItem. Here is the declarations so you can see what is what and the part of the code that is erroring out: PrivateFunction WriteAppointments(ByVal colCalendar As MAPI.Messages, ByVal aobjNewAppts As cAppointments, ByVal astrDocName AsString) AsBoolean Dim objApptInfo As cApptInfo Dim objAppt As MAPI.AppointmentItem Dim objApptFields As MAPI.Fields Dim objFld As MAPI.Field DimlstrTempStart AsString Dim lstrTempEnd AsString DimlngCount AsL…

Hi, I would like in some event to delete few characters from my TextBox. I don't want to do txtBox.Text = newText since it has bad performace (my text might be big). I would like to "send" to the Text the character 8 (backspace) the required times. How can I do that?

im creating a crystal report. in the details section of the report designer i have placed some re-occouring data, eg product_bought, quantity, delivery_address store_name, has_product, price i want it to come out like this: Product quantity address product_bought, quantity, delivery_address product_bought, quantity, delivery_address product_bought, quantity, delivery_address product_bought, quantity, delivery_address store has item price store_name, has_product, price store_name, has_product, price store_name, has_product, price store_name, has_product, price instead, its comming out like this: Product qu…

this is the way i find out if i have added a row to a dataset or not. there is a boolean value and after the row is added for the first time i set the value to false, so the next time the row is edited rather than added again. i can do this as the dataset is empty when i start, and i am only adding one row. im sure there is a more professional and better way to do this. can anyone tell me how they do it? if(workRecordCreated == false) { workRow = ds.Tables["work_details"].NewRow(); workRow["patient_id"] = guid; workRow["sitting"] = this.chkSit.Enabled; workRow["details"] = this.details.text; } else { ds.Tables["work_details"].Rows[ds.Tables["work_details"].Rows.C…

Hello, I'm developing a dialog based C# 2.0 application. My dialog has some buttons on it. I need to handle some "keyPress" events on my dialog such that each time for example key 1 was pressed, a certain action is taken. But, when I defined the event handler I found it not wokring. The problem was that the focus is on buttons not on the dialog and the handler belongs to my dialog. To solve the problem I used: this.Focus(); But didn't work! How can keep the focus always on my dialog such that I can handle the key event. Or is there any other solution that lets me use the key handler? Thx

hi i have a vs2005 setup-project for installing an application. is there a way to run this setup in silent-mode? best regards george

Say i am binding to an ArrayList. The ArrayList contains a group of ObjectA's defined, loosely, as the following: public class ObjectA { private ObjectB objB; public ObjectB ContainedObject { get{return objB;} } } Is it possible to bind to a property of Object B? Ive tried using a binding string of "ContainedObject.SomeProperty" but obviously that doesnt work. Any thoughts? Saz

I need to use sql reporting service to draw graphs with datatable attached at the bottom of the X-axis. I know this can be done with Excel but I can't find a way to do it with the chart object of reporting service. Does anyone know if reporting service has such capabilities? If it does, how I can do it. I also need to draw graphs with two y-axis, one at each end of the graph, can this be done? Thanks for your help.

Not sure why I get "Object reference not set to an instance of an object" -- This is what I have: Created a User Object: Public Class UserFields Private intUserLoginNum As Integer = 0 Private strUserEmail As String = "" Public Property UserLoginNum() As String Get Return intUserLoginNum End Get Set(ByVal Value As String) intUserLoginNum = Value End Set End Property Public Property [b]email_address()[/b] As String Get Return strUserEmail End Get Set(ByVal Value As String) strUserEmail = Value End Set End Property End Class Trying to assign a…

Problem with MS Access Database on server. "you need permission to view its data" I'm trying to access a MS Access Database on my company's Microsoft 2003 Server through an asp page. And I keep getting the error: The Microsoft Jet database engine cannot open the file 'xxxxxxx.mdb.' It is already opened exclusively by another user, or you need permission to view its data. Now since I'm only testing and I know no one else has opend the database. Also typically when you open the access database an .ldb file is generated in the same folder. No .ldb file exists so I'm pretty sure the db is not open exclusively by another user. I can open the database just fine di…

I am currently writing a vb.net application (call it appMain) using sql 2000, the front end app and the database will be loaded on a client machine. What I would like to do is have another app (call it appRemote) that could be loaded on another computer in a different country (no link between this machine and the machine that holds the DB). What I would like to be able to do is allow appRemote to connect to the DB and retreive data (only require read access). The problem is that I don't know the best way to do this, over the internet I guess ??? But then what about security?? Could someone please let me know the best way to acheive this, and maybe a link to a good so…

Hey, I'm pretty new at VB.NET and had gained interest in creating a tic-tac-toe game from scratch.. although i had no idea where to begin so i downloaded some source code... though i need some help decifering it as a lot of it doesn't make sense... mainly what each private sub does and some of the confusing bits in it.. like bytes and chars and whatnot... I know it's a lot of code to just go and summerize, but any help is appreciated, especially with the math and checking stuff. The form is composed of 9 picturebox controls.. XO 1-5 and thats for the playing board. Again, any help is appreciated :) Dim chrXOChar As Char = "X" Private Sub XO1PictureBox_Click(ByV…

I want to pass value in txtPassword.Text to to @Pwd varBinary(50) in SqlServer200 variable in a stored procedure. Vb.net code I am using is as follows 'Resets the existing password with the new password Dim n As Integer sqlCmd = New SqlCommand("usp_SavePassword", conUserAccess) sqlCmd.CommandType = CommandType.StoredProcedure sqlCmd.Parameters.Add("@UserId", txtUserId.Text) sqlCmd.Parameters.Add("@Pwd", txtConfirmPassword.Text) If (txtConfirmPassword.Text = String.Empty) Then End If OpenConnection() sqlCmd.ExecuteNonQuery() ResetMessage() lblMessage.Text = "Your password has updated w…