jvcoach23

i do early binding for everything so far. I now have a need to do latebinding (i think). I'm have a log file that i use to record changes made in a vb app. It uses reflection (think that the right term) where i pass in an object and it takes the object and creates a single string out of the properties in that table, there is a column where i store the object name. Now i'd like to take that object name and query against it using my class structure. So, say i have a class named ClassIndex with property names like tblClassIndexID, ClassName, ClassTitle if i query my table and bring back a certain row, i look and see that the class name was ClassIndex. in early binding i'd do dim oClassIndex as new ClassIndex how do i do this using late binding. hope that is clear enough thanks shannon

i have an asp.net site. I'd like to be able to create a textarea with javascript. I don't want to use a post back. does anyone have a code snibit they can share. i've found a couple on the net, but haven't been able to get them to work. what kind of plumbing needs to be in place so that the textareas show up in the correct spot. do i need to put it in a table, or can i have a div tag and add it inside the div tag. not real handy with javascript, so if you have code example that would be great. thanks shannon

thank you, i'll give it a try

well.. right now i'm not doing any interface work, this is all just in the background.. logic that will eventually write data to the database. i'm doing it in code because there is some string munipulation that would be much harder for me to do in sql.. So i'm looking for ways to filter the data in the class thanks

It's Sql server.. i was going to have about 80 queries that would have to hit the sql box. i was just looking to optimize things.. if i can do just one query, then filter in code, that would be faster than doing the 80 queries. is filtering a class on a property hard to do???

I have a custom class QBank with a public property called QBankID. I populate the ilist(to QBank). when the iList is populated, is there a way i can filter on the QBankID property for where it = x. I could filter this in the database call.. but i'd like to bring back a larger dataset and only make one call to the database for the data retrieval, then in code filter for the id i want, work on that.. and than filter for another id and so on. i'm just trying to limit my db calls. I could loop through the iList to get the value, just wondering if there is a better way.. thanks shannon

I'm working with vb.net 2005. I have a class that i've loaded up with my data. Then created a datasource off the class. I load up the datagridview with data from a class.. all this is working fine. I've got data. My problem is with the tag on the datagridview. I've gone in and bound it to the column in the datasource taht I want (i've done it like this before) when i create the double click event on the datagridview, in other code i've been able to do a datagridview.tag and get the value of column and row that i've double clicked on. I can't figure it out why it's giving me a value = nothing instead. there must be something that I'm forgetting because like I said.. i've done this before... hopefully someone can help. Here is what I'm doing to load up the datagridview with data... With oBuildingUtils .LoadFromDB() End With With oBuildings oBuildings = oBuildingUtils.Load("") End With Me.BuildingDataGridView.DataSource = oBuildings Like i mention above.. this part is working.. just not when i double click on the datagridview. thanks shannon

It's VS 2003. If memory serves it has something to do with Crystal... but can't remember for sure. There was a dll you had to download that replaced the old one.. and that fixed the problem. I just can't remember where i put that dll at.

I've done some searching but can't find a refference to fix this. I have a drop down box that has data in it, but it is not displaying, if i click on where the values should be, it is getting the value, everything is wired and working, i just can't see the value that is suppose to display. I remember seeing it a while back, that there is a patch or something... but can't find where that is.. can anyone help

I tried this... .Parameters.Add("@intTblWaitingListId", SqlDbType.Int) .Parameters("@intTblWaitingListId").Direction = ParameterDirection.InputOutput .Parameters("@intTblWaitingListId").Value = mintTblWaitingListId Still no good.. here is the trace file and what was sent to sql server... declare @p1 int set @p1=10 exec spWaitingList_Save @intTblWaitingListId=@p1 output,@intTblCamperId=781,@intTblWeekId=1,@intPriority=0,@intMisses=0 select @p1 kind of weird.. thanks shannon

The mintTblWaitingListId =0. i've checked while debuging and it is indeed 8. Here is the sp portion you'd be interested in i think ALTER procedure [dbo].[spWaitingList_Save] @intTblWaitingListId int=null OUTPUT ,@intTblCamperId int=null ,@intTblWeekId int=null ,@intPriority int=null ,@intMisses int=null No, i haven't tried telling the parm a direction before I do the add. guess i just figured that wouldn't work since I figured that you would have to add it before you coudl tell it that it had a direction... but I'll try it.. thanks shannon

I'm using Vb 2005 and Sql 2005. I'm trying to use the ParameterDirection.inputout... and it's not working. With cm .Parameters.Add("@intTblWaitingListId", SqlDbType.Int).Value = mintTblWaitingListId .Parameters("@intTblWaitingListId").Direction = ParameterDirection.InputOutput end with cn.Open() cm.ExecuteNonQuery() when i trace this in sql.. this is what it is sending in declare @p1 int set @p1=8 exec spWaitingList_Save @intTblWaitingListId=@p1 output,@intTblCamperId=781,@intTblWeekId=1,@intPriority=0,@intMisses=0 select @p1 the set @p1=8.. the 8 seems to be the number of times I've tried running this for.. since it seems to increment each time I run it. now.. if I take comment out the .Parameters("@intTblWaitingListId").Direction = ParameterDirection.InputOutput then the value getting passed into @intTblWaitingListId is the value I want. anyone have any ideas... thanks shannon

I think i got it.. Here is the code Me.CampersBindingSource.AddNew() Debug.WriteLine(Me.CampersBindingSource.CurrencyManager.Position.ToString) Debug.WriteLine(Me.CampersBindingSource.Count) Dim count1 As Integer = Me.CampersBindingSource.Count + 1 Me.CampersBindingSource.CurrencyManager.Position = count1

a vb 2005 question.. I've got a datasource that is bound to an object. I'm getting my results to a detail view fine.. and can use the bingingnavigator to click through each row. I'd like to be able to click on the + sign in the binding navigator and go to a new, blank "row" that I can later save. I've got a click event for the add sign, and did a Me.CampersBindingSource.EndEdit() this is creating the blank row at the end but I can't figure out how to get the UI to go to this last record. I've tried the movelast and position, but I'm not doing something right. would seem that I should be working with the bindingnavigator.. but i'm not sure.. Can someone help please. do i need to use a currency manager to move on the index... if so, how.. thanks shannon

i got it figured out. there is pluming that has to go on.. Here is the line of code that was needed. Me.EmailsBindingSource.DataSource = oEmails I had tried that before.. but was trying to have a datasource = Emails.. which was my class... instead of going after what had been instantiated.. think that is the right term.. anyway... here is what the complete code looks like Public Class frmMain Private Sub frmMain_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim oemail As asr.Email Dim oEmails As New asr.Emails With oEmails .sEmail = "steve" .LoadFromDb() oEmails = .Load("") End With For Each oemail In oEmails Debug.WriteLine(oemail.EmailAddress) Next Me.EmailsBindingSource.DataSource = oEmails End Sub wow.. glad i got past this one.. on to the next one.. thanks shannon

i have a class that I've tried to make into a datasource with the wizard. when I do a debug.writeline and step through the each row in the ex: For Each oemail In oEmails Debug.WriteLine(oemail.EmailAddress) Next i see my 27 rows of data. however, when I drag the "Email" datasource as a datagridview to my form.. the data isn't showing up in the grid. What am I not doing that the two are not wired together. I looked in my EmailBindingSource and it says that the datasource is Email... but it's still not working.. also.. when I drop the datasource on the form... no lines of code are added.. I don't know there there are suppose to be any.. but figured I'd mention it. Seems to me there should be something... otherwise how does it know to grab the data from the datasource object after the object is laoded up What it did add to the design is a BindingSource and a BindingNavigator. any help would be great. thanks shannon

playing around some more.. i have figured out that when i use a try and catch that that is when I'm getting my error. So i need to make sure I return a dataset in the catch and the error goes away... not sure if i want to do that.. but that is why i'm getting the warning.. thanks again for your help shannon

So if i'm using a function that is making a database call and returning a dataset, then I need to make sure that that dataset has at least a table and row in the table.. so if the db call returns nothing, i need to manually add a row.. am i getting this.. thanks shannon

I'm trying to write a function in a class. when I create the function, before I even put any real meat in the function, i'm getting the warning that the function doesn't return a value on all code paths. A null reference exception could occur at run time when teh result is used. I've done some digging but can't turn anything up. can anyone help me out on by explaining what is going on. I did this in vb 2003 and didn't run into it... hope someone can explain it to me. thanks shannon

great.. many thanks

I'm getting an error on the dim hti as hittest says typehittest is not defined.. it's simple isn't it.. what I'm not getting

I have a datagrid.. I'd like to know how you click on a column.. and get the column header name. I tried something like this and can get the index value.. but can't figure out how to get the actual name. DataGrid1.HitTest(e.X, e.Y).Column thanks shannon

yes.. i'm still interested thanks shannon

Never mind.. it was a PEBTKAC error.. i had the rowheadersvisable = false in a class i was using to format the grid.. thanks for the help shannon

column headers visable are set to true. I'm talking about on the left hand side, if you were to click on it, it would show you a > sign.. except the sign is solid black. got any more ideas.. thanks