why the size of all SqlParameters generated by VS2010 are set to 0, while when I look in the dataset all the columns are set to different sizes but when I read it from sqldataadapter they are all set to 0. Isn't it going to make some other issues in future? I mean, I have many sqlparameter with NVarChar types that they are generated by VS2010 and the size is 0!
View 1 RepliesI have the seperate sql commands that will use the same parameters from a database. I can add the parameters to 1 of the commands, but when I add them to the others I get an error.
dim updateCmd as new sqlcommand("USP_TableUpdate", myConn) with {.commandtype = commandtype.storedprocedure}
dim insertCmd as new sqlcommand("USP_TableInsert", myConn) with {.commandtype = commandtype.storedprocedure}
dim deleteCmd as new sqlcomman("USP_TableDelete", myConn) with {.commandtype = commandtype.storedprocedure}
[Code]...
I was looking at a tutorial for SQLParameters and apparently I need to Import something for my code to work.I downloaded Microsoft Patterns and Practices a couple of weeks ago, and have been using that but I can't figure out what I need to Import for the VB.NET code on this website to work:[URL] Of course, I'll me modifying that to what I need it to do but at present I'm just after an understanding of how it works, but I've got no clue what to do about Microsoft.ApplicationBlocks.Data.SQLHelper, where do I find it?
View 5 RepliesI am try to modify this code
_adapter.UpdateCommand = New SqlCommand
With _adapter.UpdateCommand
.Connection = _connection
.CommandType = CommandType.StoredProcedure
.CommandText = "CaseInfo_Update"
[Code]...
I have a table, I add a dataadapter to it and it has all the commands. There are lists of paramters for update,insert and delete. I wonder where does the Visual Studio find the related informatio on the size of the parameter? Since I believe it is reading from a wrong place or I did not set someting correctly. While the corresponding NvarChar column in dataset and database table is having the size of 20, in dataadapter it is all 0!
View 3 Repliesway to create and initialize SqlParameters in VB.NET? Using 3 lines per variable seems quite excessive. Unfortunately the constructors for this class are rather ridiculous, so I'm thinking of just writing my own sub for initializing each parameter. This is how I've been doing it.
Dim ID As New SqlParameter("@ID", SqlDbType.Int)
ID.Value = val
query.Parameters.Add(ID)
[Code]....
I have this code
Code:
Public Function ExecuteDataReaderSP( _
ByVal storedProcedureName As String, _
ByVal ParamArray arrParam() As SqlParameter) As SqlDataReader[code]....
I try various ways to pass the parameters, every time it return a different error.How is the correct way to pass those parameters?
I'm doing this right now - .Add'ing parameters and then at the bottom I'm looping through them and setting the Source column by just removing the "@" character from the parameter name.
[Code]...
Now all went well about from using the structure correctly. The working of the structure was perfect. How ever i missed Two important issues. The structure needed a fixed size of 10 items (9 in programming terms starting from 0) And also out of the 5 items allowed to be chosen as one of the member types for the structure a limit of 5 items of that particular type.
[Code]...
I have a label which appears full screen on a projector (VGA 2). In this label I will be sending strings. Some one liner's, some wrapped paragraphs. Some multi-line with carrage returns. My goal is to have the font dynamically change size to be as large as possible without overflowing the fixed label size.
View 10 RepliesWhats the font size real meaning? since when i use Arial font size 10 in the report its gonna take different space than the textbox im using (Both using exactly same font type/size/unit) its kinda if i set 10 milimiters to the font size why would the i and M for example have so diferent size.
i wish it was like in the Notepad where all the letters take the same space. what i need its to give a certain texbox(in the report) with auto grow to have always the same lines of height but its not posible to calculate it from vb b4 being inputed to the report.
How to make the form size automatic setting the size equals to the screen. or Maximize the whole form including the form components.
View 3 RepliesIm trying to resize a picturebox dynamically using .size.height and .size.width Its not working. This is the error message: "Expression is a value and therefore cannot be the target of an assignment." Never used height and width before. Been trying to find the answer, but it seems beyond me. Im sure its easy. Anyone know whats wrong with this?
[Code]...
I had set a print format to print some word in a Text box, when I input the text in text box is an normal size from system,but I want it print out to printer follow the Rectangle size that is was set to print out on paper.actuary i want it can auto size the font size follow by the length of string.
View 1 RepliesI'm new to VB in Visual Studio 2008 and am just trying out some simple test.I just want to change the Font & Boldness of some text but get the following errorProperty 'Size' is Read onlyI have been browsing the forums and it seems that changing the font size etc isn't as simple as
TextBox.Font.Size = 12
TextBox.Font.Bold = True
Is this true, and if so what do I need to do
I am working with vb.net and want to increase the size of image when the cursor is over that image, but the image should come back to its original size when the cursor leaves that image area.I've used the following code to increase the size of image:[code]I've used the default size class but, it gives some different dimensions.by the code that brings the image into its original size that I've been declared into the picture box properties.
View 2 Replieswhen I click the Open button a file is opened and its items are sorted alphabetically. to do this I have doubled the size of my list. However, when I click the button again to reopen the same file, the items will ADD ON to the previous open-file event even though I have this piece of lstListboxTwo.Items.Clear()(the correct thing is to clear the previous items and add the new ones)So I think this has to do with the new size of my list..I think that I have to set the list size back to its normal size when re-clicking on the button.
Public Class frmForm
Dim List() As String = {""}
Dim count As Integer
[code]....
I have wondered the solution to this question for many years! I doubt if anyone else knows much about it because the internet is absolutely zero help in this!
I have made a form1 with a webbrowser control on it. When the program is run it brings up the homepage (which is Google). However the homepage doesn't seem to fit inside the webbrowser control.
So I am hoping that someone could tell me how to make the (...I dunno how to ask this retarded question...) webpage fit completely (100%) inside the size of the webbrowser control. Meaning...I would like to see the entire webpage from the internet in the
size of the webbrowser control. To fill the entire size (whatever size I want).
Etc... if my webbrowser ontrol is seh, set to 600px by 400px, how can I program this so when it brings up the homepage (or any other page), it fills the entire size of the webbrowser control? Without any scrollbars. How to make the contents from the web
(or local) fill the size of the webbrowser - almost like a mini browser if you will.
Okay here's what I'm trying to do. I want to change the font size of a label based on the size of the form.If the form size is 0 through let's say 500 I want the label size to be 50. How can I write this?
View 5 RepliesIf I have form say sized 1300 x 800, I would like to proportionally size the form to the computers screen size. I can get it to size to the screen size, but it is not proportional
View 11 RepliesI developed a form application on my computer, but when it was used in another computer with different screen size, i was told the form didn't fit. Do I have to adjust the form size or any other ways to let the form compatible on different screen size? (could be different screen size or wide screen)
View 2 RepliesSo that's how I want it:
If I re-size the form, the textbox inside should be re-sized to fit the form, NOT DOCK!
Try it yourself: Plug in a USB flash drive (just a normal one with a single primary partition on it, as is the manufactures configured) to your computer.
Run WIM "Select * From Win32_DiskDrive"
Note the USB drive's size (in my case, it is a Kinston DataTraveller G3 2GB drive):
Win32_DiskDrive instance
BytesPerSector: 512
Caption: Kingston DataTraveler G3 USB Device
[CODE]....
Why the partition is bigger than the disk on which the partition is created and just a part of the disk?
How do I connect the size of any button in the form to the size of the window so that it would change proportionally to the size of the window?
View 1 RepliesI am after a property that makes a control (textbox, datagrid or other) move according to the forms size. Because some of the controls I got does that, and I really don't want it. I've been looking at them but could not find it
View 4 RepliesI'm writing a couple of custom controls in VB.Net 3.5, in VS2008, and would like to resize the font size based on the height of the control, and vice-versa. Is there any way of converting a font of say 38.25pts into a me.height, or the other way round?
I realise the font width will change dependent on the font used (which isn't an issue for my purposes), but as far as I know, the font height is usually consistent Accessibility/Large font settings won't be an issue with this application.
I am trying to split the image into 9 equal regions , and the below code does it well the problem is i want to get the selected image size and not picturebox sizeso what should i change to get the selected image size instead of picture box sizei dont want the picture box to grow in size with image because it will hide other buttons/textboxes etc
Dim xi As Integer = (PictureBox1.Image.Height)
Dim yi As Integer = PictureBox1.Image.Width
Dim px As Integer = xi / 3
[code]......
I want to to increase size/move when the form's size changes....
View 4 Repliesi've been coding a sidebar but i dont know how to make the size to aoutomatically fix the screen size..i mean if the screen resolution is 1000x789 or 890x678 s stilll fit to it I have find in google and youtube but still i didn't get any ides on how to do it And also if possible can we code s sidebar that automaticcally hide when we did not move our mouse to it?
View 1 Repliesi want to make it so my toolstriptextbox will smoothly size with the form as i resize it. I tried using a timer and just say txtbox1.width = me.size.width - 100 or whatever space for the buttons and handling it for when it reaches negative numbers (with autosize off on the textbox) but its not at all smooth.
View 4 Replies