I am working with a datagridview on my form and have a CellContent Click event as shown below;
[code...]
Now, when I check the checkbox Yes and type in the comments textbox, the Comments are not stored to the table. However, the checkbox is set to a true value.
I currently have this working already for one of my combo box's, but when i try to use the same code i get this error ''There is no row at position 6.'' . The are 2 fields in the table asset_type_id, asset_type_name', im trying to dispaly the values in a combo box for the field 'asset_type_name.
the code for ' Friend Sub RetrieveCustomerInformation2()' works but the other friend sub throws the error.
Imports System.Data.SqlClient
Imports System.Data
Imports System
Imports System.Data.OleDb
[Code]...
I've noticed that in C# XML comments and code comments can have different colors by changing the settings in Tools > Options > Environment > Fonts and Colors > Display Items:
- Comment: controls code comments XML comment: controls XML comments
This works well in C# <summary>This XML comment is green</summary>
[Code]...
I'm using a stored procedure, but am receiving a "Procedure sp_OrderTracking_Update_UpdateItem has no parameters and arguments were supplied" error. Here is my stored procedure:
[Code]...
I am trying to decrypt my password stored in aspnet_membership table... I am using the following code,
[Code]...
but at the line of DecryptPassword(encodedPassword) it shows error as "Length of the data to decrypt is invalid."
how to calculate numeric values in a sql table in vb.net. For example I am developing a system which returns the required fields in GridView, I then copied the "NetValue" field in a list box. Is ther a way of calculating (adding them together) all the Net values listed in the list box? or is there a better way around it?
View 2 RepliesI'm using a DataReader to display informations stored in a table.I created Two button to go to next record and to go back. [code] In ASP.NET I didn't find a way to do like it, because DataReader hasn't the EOF property.How can I convert this last code (VB6) to ASP.NET ??
View 2 RepliesHow to insert images into sql table without using a stored procedure? I am working on a windows form for employees profiles (vb.net) and i have a combobox and a few textboxes. My combobox is manually connected to a database and also the other controls. When I fill the blanks and hit save, automatically the data is saved in my db and when I look into my combobox I see the new employee name. When I select a name, every control get filled. I have a picture box where the selected picture profile will be display. The picture will be display also when I select a name from a combobox. It will be retrieve from db table GeneralInfo Column Foto. What I need is to include in my sql statements the code to be able to save, update and delete the image from and to db.
This is part of my insert code:
Private Sub savenewprofileonload(ByVal sender As System.Object, ByVal e As System.EventArg)Handles btn_saveprofile_onnewprofile_tap1.Click
Dim mconn As New SqlConnection("Data Source=(local); Initial Catalog=mydb;Integrated Security=true;")
Dim cmd As New SqlCommand
[Code] .....
Can I use different stored procedures from 1 table adaptor that has all the stored procedures in it?
View 3 RepliesI have a stored procedure, and I want to save the results of the stored procedure into a table. Is there a way I can do this with a simple query without creating the table beforehand.
View 8 RepliesI have a datatable with some rows I need to insert that datatable in to database using a stored procedure.
For Each row As DataRow In dt.Rows
cmd.Parameters.Add(New MySqlParameter("@DOWNLOAD_ID", dt.Rows(0)("DOWNLOAD_ID").ToString()))
cmd.Parameters.Add(New MySqlParameter("@FINALY_FIELDCODE", dt.Rows(0)("FINALY_FIELDCODE").ToString().Replace("|", "").ToString()))[code]....
When i do this I got an exception {"Parameter '@DOWNLOAD_ID' has already been defined."} How to get rid of this exception and can we insert the datatable with out for loop.
I have a very specifically designed table in a .aspx page. I have an <asp:SqlDataSource> tag that works fine with a DetailsView. I have tried DetailsView, ListView, Gridview etc. and cannot obtain the desired design. Is it possible to execute a Stored Procedure and have the individual results displayed in the individual cells of a web page table? This seems like it should be simple but it apparently is not.
View 2 Repliesi am new to stored procedure and VB.Net, i am trying to insert a value to a column in a table in my database using VB.Net and Stored procedure Here's the procedure:
1. A user will input a value to a textbox, for example lastname.
2. When the user click the save button, the button will call the stored procedure.
Here's my code in stored procedure:
[Code]...
stored many row records into another table from data grid view?
View 1 Repliesis there a way to validate controls on a form, where the validation rules themselves are stored in a database table?My problem is my application is used to submit forms to mulitple government agenices both local and state level. Every entity seems to have there own rules about what needs to be in what location. i would like to not have to code all of the various rules for all the different fields. My thought was to store them in a database table and then perform validation based on rule table lookups...however I would like to use the .NET validation controls.
View 2 RepliesI have a stored procedure that creates temporary table to populate return table. It works perfectly fine when I execute it on SQL management studio but when I try to import this sttored procedure, it give me an error Invalid object name '#TOTAL' which #TOTAL is the temp table that is created.Does VS2010 not allow temporary tables in Stored Procedure?
[Code]...
Check if park_id already exist in table calendar by stored procedure? [code]...
View 2 RepliesI have a date/time variable stored in a column in an SQLite table. I need to select the string with the last 3 digits trimmed off. [code]
View 1 RepliesHow to edit a Word Document (.docx) stored in a SQL Server Table?
Here is the tentative work flow:
Read BLOB from SQL Table through Ideablade
Write BLOB to disk as .docx
Open .docx using Word
[Code].....
I am sure there are a lot of people doing this already.
In a DataSetIf I right-click on a TablesetAdd QueryCreate New Stored Procedure. The creation will fail for me using a SQL 2008 database. "There was a Problem with the UPDATE stored procedure. The stored procedure was not created."If I "Preview the SQL Script..." copy it and run it manually it fails because it is not putting brackets around my user name. "CREATE PROCEDURE SDSDBLUESKY.UpdateQuery" Fails"CREATE PROCEDURE [SDSDBLUESKY].UpdateQuery" WorksThis is a work around because it links to this if I do manually when it gives me the preview option, and don't rewrite it. But is there some setting change in VS2005 to get this to work correctly in the first place?
View 1 RepliesNeed to design a program that can encrypt and decrypt messages stored in simple text files using a private key stored in a separate file. Software should also be able to allow the users to enter simple messages that either displays the encrypted or decrypted message. The encryption method should use a simple substitution method. It should be set out in the following format:
Example (the "@" is the separator):
@
The character The Code End of line
A @ 4gh EOL
B @ 84!9 EOL
Has to use the 256 ASCII character codes. The separator will be used to separate the character and its corresponding code.Here are the pseudocodes I have come up with:
� Read any private key file
separator = readline(file);
while not EOF(file) do
tempStr = readline(file);
[code].....
i am writing a vb.net program which gets a c program as an input and checks it for errors,now i want my program to skip the comments in the c program,i have written some code but its not working
For Each line In TextBox1.Lines
sample = TextBox1.Lines(k)
Dim len As String
len = sample.Length
[code]....
I used to be a C# developer so this commenting style was very easy in C#. This is driving me crazy but how do you do this in VB.NET without getting a syntax error?: Private ReadOnly Property AcceptableDataFormat(ByVal e As System.Windows.Forms.DragEventArgs) As Boolean
[Code]...
I do not understand vb comments. I read that it is possible to give a hint in the code completion box when someone (or myself?) is using my code. But I do not find something in visual studio.
View 4 RepliesI have been using the method summary XML Comments at the top of my procedures lately and am wondering if there are any logical or good practices related to this.I never put anything in the remarks because I put the description of the method in the summary tag. What belongs in the summary and what belongs in remarks?I seldom put anything in the returns tag because it seems like it would be redundant as I usually explain what is being returned in the summary. Should I simply keep the type of object returned in the returns tag?
View 4 Repliesi am writing a program which takes a c program as input and it has to check whether there is a nesting of comments in that c program and gives an output based on that,how do i go about that
View 1 RepliesIs there a way to add comments to an array initialization? For example:
Dim test As UShort() = { _
1, _
2, _
3, _
4 _
}
I'd like to add a comment on each line, but the obvious syntaxes fail (for obvious reasons)
1, 'test _
1 'test, _
So, am I out of luck?
When I'm writing comments in my code, I often forget to add the initial space after the comment identifier.
'this is a comment
when really it is supposed to be
' this is a comment
I realize this is quite trivial, and you could simply say "just add the damn space you idiot", but I'd really like to automate this so that I just don't have to worry about it. add the comment space?note I do realize that a catch all string replace or regex replace could screw up other things ... IE:
Dim something As String = "I'm a nerd"
would actually come out
Dim something As String = "I' m a nerd"
if it's only on a line by it's self and is not followed by a second single quote... IE: '' would not trigger the replacement.
Is it possible to compile the code without the comments? Or are the comments not compiled as default?
View 3 RepliesI've been searching for this for the last 2 days, but can't find anything that works.
I just want to generate a chm, html, word document it doesn't matter what, form my xml comments. It needs to be freeware.