| vb.net reference (2 replies) |
| ASPFriends.com 'aspngvb' list |
| Hello all.. 1. does anyone know where I can download a good vb.net reference file? 2. has anyone had any luck using the following code in vb.net? I keep getting asked to dim "Right", which can't be right. strString Right(strString,4) thanks shaun |
|
| codebehind error with IsDBNull (2 replies) |
| ASPFriends.com 'aspngvb' list |
| Copied from [aspngfreeforall] to [aspngvb] by Alex Lowe webmaster@asp grandrapids.net Hi, I've got a page working and now I'm trying to move it to use codebehind and I'm getting a compilation error. The page takes a text input and triggers a stored procedure that returns several parameters. The problem I'm having is with IsBDNull: I have the line: If Not IsDBNull( cmdChassisCheck.Parameters( "@lon... |
|
| Downloading Files (2 replies, VIP) |
| ASPFriends.com 'aspngvb' list |
| Copied from [aspngfreeforall] to [aspngvb] by Alex Lowe webmaster@asp grandrapids.net Have a small library function in my application. The application allows you to search through library, find a document (mostly Word or PowerPoint Docs), and download them. The code is below. Seems to work fine except when I have a file that holds spaces (i.e. "c:/temp/Good Stuff to Read.Doc"). Not sure if I need ... |
|
| Null Handling (3 replies, VIP) |
| ASPFriends.com 'aspngvb' list |
| What are the best practice to handle db null in VB.NET... say for example, you have something like this... While myDataReader.Read() myVar0 myDataReader.GetString(0) myVar1 myDataReader.GetString(1) myVar2 myDataReader.GetString(2) End While How would you check for nulls on each field of the data reader. Hendrix |
|
| How to test a SqlDataAdapter object (3 replies, VIP) |
| ASPFriends.com 'aspngvb' list |
| Hi everyone, I just want to test if my SqlDataAdapter contains records... How can i do it?? Here is some part of my code Dim sqlAdapter As New SqlDataAdapter(strQuery, strConnection) Dim type As New DataSet() sqlAdapter.Fill(type) If sqlAdapter is Nothing (????) Then (if the query return 0 records then responsE.redirect("toto.aspx") mContext HttpContext.Current mContext.Response.Redirect("toto.asp... |
|
| Better Way? (3 replies) |
| ASPFriends.com 'aspngvb' list |
| Hi folks, I created a form with a simple on click run some function. The problem is that when the button is clicked, it runs page load and renders the page and *then* runs my function. So the literal I'm outputting to in the function never fills. I was actually able to fix this by a simple if/then in the page load: If Len(Request.Form("register")) 0 Then getresults(s,E) End If (register is the ID ... |
|
| Month & Year? (6 replies) |
| ASPFriends.com 'aspngvb' list |
| Hey folks, What's the asp.net way to grab the name of the current month and year? I need a variable containing "February2002". Thanks, Rachel |
|
| RIF: Drop down in a Data Grid (2 replies, VIP) |
| ASPFriends.com 'aspngvb' list |
| SGkgLCANCmNvdWxkIHlvdSBzZW5kIHRoZSBjb2RlIG9mIHRoZSBkYXRhZ3JpZCBwbGVhc2UgPyAN CndpdGhvdXQgaXQgLCBpdCBpcyB2ZXJ5IHRvIHVuZGVyc3RhbmQgd2hhdCBpcyB5b3VyIHByb2Js ZW0gLi4gDQpUaGFua3MgDQpGcmVkDQoNCgktLS0tLU1lc3NhZ2dpbyBvcmlnaW5hbGUtLS0tLSAN CglEYTogUmFodWxfQ2hhb2ppIFttYWlsdG86UmFodWxfQ2hhb2ppQFNhdHlhbS5jb21dIA0KCUlu dmlhdG86IGdpbyAyLzIxLzIwMDIgMTI6MDEgDQoJQTogYXNwbmd2YiANCglDYzogDQoJT2dnZXR0 bzogW2FzcG5ndmJ... |
|
| Null Zero (2 replies) |
| ASPFriends.com 'aspngvb' list |
| Hi all, I am converting a program from VB 6 to .NET I used to have a function that I called NZ NZ would accept two parameters input and output It would check to see if the input value was Null, and output a 0 otherwise it would output the value passed How can I define the input paramater so that it accepts the Value "NULL" as well as a numeric value I keep getting a Cast from type 'DBNull' to type... |
|
| Update Question (3 replies) |
| ASPFriends.com 'aspngvb' list |
| Has anyone had any problems with the update command using the sql command builder in vb.net? I am getting an error saying that my table needs a primary key to update it, well it does and it happens to be an identity column. Database is SQL Server 2000. I can get my updates to work using the fillschema method of the dataAdpater but I want to get away from that. Here is my code with the old methods ... |
|
