I want to fetch data from sql and use them to make a new data I really like to store the records in variables and maybe do some operations on some of them , but the main point is to update three tables in ways that are not the same,that means I need the raw data !
View 15 RepliesI am trying to pass a different template to a Telerik Grid, depending on if the add button or the edit button is pressed (on creation: a few field to fill. on existing: add button : some extra fields to fill, edit button : most field are read-only, new field to fill).
Dim myGrid = Html.Telerik().Grid(Of SomeModel) _
.Name("myGrid")
If Model.Action = AddNewData Then
myGrid.Editable(Sub(editing) _
[code]....
I have no idea on how to do the if "gridBoutonPushed = Add" then part.
I am using following data to add new data to my table
Me.TblResultTableAdapter.Fill(Me.DbResultDataSet.tblResult)
Dim drNewRowEditSummary As DataRow
drNewRowEditSummary = DbResultDataSet.tblResult.NewRow
drNewRowEditSummary.Item(1) = "Test"
DbResultDataSet.tblResult.Rows.Add(drNewRowEditSummary)
TblResultTableAdapter.Update(DbResultDataSet.tblResult)
How can I edit my data using similar method as above?
window is loaded, binded textboxes get filled, user edits textboxes and clicks a save button it works, all except crashing with a "vb.net 2010 Concurrency violation: the UpdateCommand affected 0 of the expected 1 records." most of the time but the data does get updated'form.vb code for button_click?
Dim dtNewRow As DataRow
dtNewRow = dbDataSet.Table.NewRow()
dtNewRow.Item(dbDataSet.Table.Column) = Textbox.Text '<--this line is followed by 33 more that vary on column and textbox
[code].....
I have a application with Access Database.
Open/Edit/Delete is through below code
Public conn As New OleDb.OleDbConnection
Public da As OleDb.OleDbDataAdapter
[code]....
I am displaying this data in a datagrid by connecting datasource and datamember.What i need is to displat a dropdown on second column in the datagrid. When i change the data it should update the database PBL (Visual Studio 2010 Ultimate)
I am trying to edit, add, and update my database. I have the code for updating and it updates fine (I can see the modified time on the file), but I was wondering why none of my changes were being saved when I closed the window. Then I realized I was an idiot and I don't have any code to actually accept edits on this form, I just have code for updating and adding new rows It wouldn't update without me telling it which rows have been edited and need updating, right I mean I can't just type a new value in the textbox, click save, and expect it to save the change.This is the update and new row code I'm using:
Private Sub SaveToolStripButton2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SaveToolStripButton2.Click
Try
[code].....
I'm having problems editing the text of a particular column in a datagridview from the front end. The text enters ok but as soon as the cell loses focus it goes back to the old value. The datagrid view readonly property is set to false and I don't have any problem writing to the other columns.
View 2 RepliesPrivate cs As New SqlConnection("Data Source=ANKIT-PC;Initial Catalog=mrks_analysis;Integrated Security=True")
Private da As New SqlDataAdapter("select * from sbs", cs)
[Code].....
i used the above mentioned command to get data from db to my datagrid.
Currently the complete grid is editable.
i want that the Sno field to become non editable + and the rest rows i want a combobox from which user selects the data and which gets stored in db.
well this may be a simple question to some but for me, im not even sure where to start. I have never done a program in VB.NET yet that uses a MySQL database. So this should be a fun thing to learn. I looked at an example for access databases and it seemed pretty straight forward. But I must use MySQL as the database is on a Linux server in Ohio.
What I got so far is how to connect to the database using ADODB. Here the example I'm giving. You got 4 col's call AccountNum (primary key), Phone, Name, and Address. For each row is data of a client. What I'm trying to do: the program asks for the account number. You type in the account number of the client. It then
compares it to the rows of AccountNum col till it finds a row with it. Then it asks if you'd like to change the phone number or address.
So what I'm looking for is the, how to call rows and change data in col's.
I can add new data to the database and have it saved and everything (though my method not be great, but it works) but I'm having a hard time figuring out how to edit existing data and save it. assume it would be better to have it check whether or not the row exists, and if it does, just update it rather than trying to insert new rows? This is the code I have right now to
Dim newRefractiveRow As EyeBaseDataSet.Spectacle_RxRow
newRefractiveRow = EyeBaseDataSet.Spectacle_Rx.NewSpectacle_RxRow
With newRefractiveRow
[code].....
I am writing a windows application that interacts with data stored in an Excel Spreadsheet. I merely want to change the text value of a cell that already has text written in it.
View 2 RepliesMy form just isn't updating the row in the database: Here's my code:
Protected Sub btnSubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSubmit.Click
If Request.QueryString("a") = "edit" Then
Dim CategoryText As String = lstCategory.SelectedItem.Text
Dim conn As New SqlConnection("Data Source=.SQLEXPRESS; Initial Catalog=LogansArchive; Integrated Security=True;")
[Code] .....
I've never used nested SELECTs in SQL before so I'm not sure if I did it right. Aside from that, this is all stuff I've done before so I'm relatively sure that it's all correct. Finally, there are no errors being reported when I debug, although the updates don't seem to be coming through from the text fields (txtContent.Text isn't changing to reflect the new value).
after editing my cell in the datagrid . i am sorting then i select the next record the selection was do to the 1 cell on the row .i don't know what is the problem
View 2 Repliesi am working on an application titled Asset Management for my b.tech major project.The company under which i am pursuing it only asked me to include sumitting asset information,,retrieving information and generating reports and editing of data with admin login.I made all that but my college faculty is not impressed with it.I will be if somebody can tell me what features do i add to it and how do i make it more interesting.
View 2 RepliesIt seems like when there is only one row at the data grid view with a data source pointing to a data table, it's row state for the data table doesn't change when editing. It remained "unchanged" reguardless to how many columns I had entered. However,after editing, when you click on a different row or click on any of the column headers to change their sorting, the row's state from the data table then gets changed to "modified". I'm not sure why the data table's row states gets changed only when you do those things instead of finishing editing itself. Couldn't the data grid view be able to change the data table's row states when you finished editing a cell?
View 5 RepliesHow do you set focus to a specific control in a datagridview row after clicking the edit button? I'm able to do it for a new row when the grid is binding, but not for an existing row. The control doesn't seem to exist yet.[code]
View 1 RepliesMy work dropped a vb.net program in my lap that I need to modify. Die vb. Anyway, I work in Netbeans and can't find a module that will allow for syntax highlighting of vb. Is there a creative solution out there for this that doesn't involve using a different IDE?
View 1 RepliesI have a form which contains a populated datagridview and I have a button that calls a second form in which I want to be able to add additional rows to the first form's rows.My form2 has about 10 text boxes which the user will use to add columns in a new row...How can I capture the 10 textbox's information and add a row with 10 columns to display the textbox's info?
View 3 RepliesI'm just familiarising myself to edit registry in VB. I am having a problem with changing a value in the HKEY_LOCAL_MACHINE key. When ever I change a value at runtime it always assumes that I am going in the "Wow6432Node" key, even though I don't put that in the parenthesis. Example:
My.Computer.Registry.SetValue("HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindowsCurrentVersionExplorerAdvancedFolderHiddenSHOWALL", "CheckedValue", 1) and it doesn't change the value in the string above, but changes it as if I have put
[code].....
I'm working on a piece of code at the moment that uses an older style DataGrid to allow the user to enter information into the table. It already has an add and delete button. Currently the user enters information into 3 textboxes that are in the footer, and the other rows use labels to display the information.
Essentially what I am wanting to do is take the line that the user has clicked the edit button on, and move the text from there in to the footer (deleteing the row that it was displayed on) so the user can make changes and then click the add button again. At the moment I have tried using FindControls to find the textbox and setting the text that way but it doesnt like it.
I have a pretty simple question I was hoping someone could help me with, there are two text files - first is C:Test1.txt and the other C:Test2.txt.C:Test1.txt data consists of, the column is separated by a space (" ")
Data Data
Data Data
Data Data
C:Test2.txt data consists of
Data
Data
Data
The fields in Test2 Column 1 are the fields in Column 1 Test1, what I'm trying to do is add the matching fields from Test1. So for example:
[Code]...
I have this 40 mb (game) file.The only way to change certain lines in it, is using hex editing software.For my program, I need to change a certain texture in this file.But when I use a streamreader in combination with a streamwriter, the resulting file is a lot smaller and when I load it, the game crashes.How can I hex-edit and replace a certain string in this file?(I use visual basic .net express edition 2008)
View 9 RepliesSo what I'm wanting to do is to pretty much hack a game. I was wanting to know if I can hex edit a game using Visual Basic by using String.Split? Idk if it can be done and I don't wanna waste my time on it if it can't be done.
View 10 RepliesI was wondering - How would i edit a .exe's offset's, like a 4byte offset with the int of 5000, and changing the int to 10000.
View 3 RepliesI would like to know a way (of course I want to know the best way) to edit a csv file, preferably without having to read the original and write the results to a new one.
Example 1: I want to split the contents of a column into two columns 123abc into 123, abc
Example 2: I want to remove letters from the beginning of a column AB123 into 123
Clarification: I do not need help solving my examples; I just need to be pointed in the right direction of reading and editing the same file.Here is a code example of using a temporary file that seems to me is too slow
Dim currentLine as string()
tempFile.AutoFlush = True
Do Until origFile.EndOfData
[code]....
i've continued making my Program and wanted to make an Control Panel for my Server.
[Code]...
This happens ONLY on editRow in dataTable. >>in my class I set my property to format shortDate.. In debug I check the property as it beginsEdit and endsEdit its formatted as shortDate... BUT its changed to longDate in my dataTable. (dataTable edit class change to longDate?)[code]...
View 1 Replieshow I can simply dynamically edit a cell in a gridview. i.e. Just click on it and type, and post the changes when I lose focus to the gridview?I have tried defining a cell as a template control (textbox) and get it to display and let me type in, but it does nothing beyond that. I cannpt even get the default value from the underlying dataset into that cell.
View 4 RepliesI'm trying to update some records in my table using the GridView Item templates. It's like this:
<asp:GridView ID="grdCursos" runat="server" CssClass="grdTable"
AutoGenerateColumns="False" DataKeyNames="CourseID">
<Columns>
[Code].....
I have a system where I would like to show a warning to a user if there try and edit a record that is currently been edited. If this is the case the user will not be able to save the record but only view it.I have an idea of using some kind of class to monitor the activity of records been edited etc but this seams a little over kill. My other concern is that what if the browser crashes or there shut their computer down on how this will effect the state of the page.
Another thought was to use last updated time stamp but this also looks a no go because the way records are been updated? how I could implement something like this. No code is necessary.based on the comments I have added these additional details.database is SQL server 2008 asp.net 3.5 one record could be many parts of the database for instance, the booking table session table and a row in the interrupter table.the user will look at a list of sessions that need booking select a booking and fill out a booking form to make the booking. Want to stop is someone else trying to do the same booking at the same time or while someone else is doing the booking.