Im working on an Asp.net / VB.net website and coming from a C# / WPF background things are still a little new to me. I have declared a DataTable like so: Public notificationList As DataTable And I have then used the Page_Load event handler to populate it and bind it to a control on my page, which all works fine
[Code]....
However in another method i need to be able to access this DataTable, yet whenever I do it always appears as nothing. Do I need to be storing this value elsewhere like in the session etc?
I have a datatable which loads data from an Excel Spreadsheet. One of the columns in the Excel SpreadSheet was of type "Date/Time" in which date values are stored. Now I appended the datatable with three new rows and I wanted to store string values in these rows using the code below. However due to the fact that one of the columns are date/time type, an error is generated as date/time column does not accept string value. I have two questions
a. Is it possible to store string value in date/time DataColumn?
Basically, I want to have a database that's lightweight and I won't need to install amillion other things on my clients computers for them to access this.I just need a simple method of reading and writing values so that they're not hardcoded into the program. I could do MySQL (which is what I'm very familiar with), but it doesn't need to be making calls remotely.
I am trying to store things such as user data for each user in my program, like with a class I made named UserData. I would like to have data different for each user. How can I do this? Also, I need to be able to access other user's data from my account.I tried using Settings, but they only had a limited number of classes, and the settings didn't seem to save for some reason.
i have declared an array which i want to populate with names, as they are entered into an input box.It does not seem to work i have tried many other methods with the array but to no success.
Dim namearray() As String Dim i As Integer name = InputBox("Enter the candidates name:", "candidatename", "", 500, 500) name = namearray(i) i = i + 1
I have my form set in french as well, and it automatically changes the text format to use ','. However When I try to insert my values into the database it says cannot convert nvarchar to decimal? Worst case, Is there a way I can disable the numbers from changing to use ',' and just use '.' always regardless what language it is? My working language is vb.net?
when I add a product to the shopping cart it adds it very well but the problem is in the session, it stores it in the server not in the client browser.
so if some body visit the website from another computer he can see the added products on his browser while it should be empty.
Is there a way to save it on the client side instead of the server side ??
I have my form set in french as well, and it automatically changes the text format to use ','. However When I try to insert my values to the database it says cannot convert nvarchar to decimal? Worst case, Is there a way I can disable the numbers from changing to use ',' and just use '.' always regardless what language it is?
I have this string mainString="/MyApp/ViewPage.aspx?userId=admin&password=1&id=975"
I am getting value in mainString using this code Dim mainString As String = Request.QueryString("dest")
And I have two sting variables 1)strTempUsername 2)strTempPassword In these variables I want to store userId and password values from mainString.
So for this requirement how I write logic in code Dim arrArray() As String '/MyApp/ViewPage.aspx?userId=admin&password=1&id=975" strIndexq = mainString.IndexOf("?") ' Check QuestionMark Exist or not in mainString If strIndexq > 0 Then Dim strTemp As String [Code] .....
Here I am getting userId and password but in this code I will get problem when after ? if userId and password starts wit capital letters and password maybe contain characters like "1&a"
And after getting userid and password. I want to remove userid and password from mainstring. So I want mainstring look like: "/MyApp/ViewPage.aspx?id=975"
I've got two data tables with store numbers. I need to find out what store numbers are in one data table that arent in another.say one table A might look like:
34, 35, 39
the other table B may be
34, 35, 39, 45
I need to find the 45 If I use nested For Next I can get matches but anything not a match would show up not just the 45 value as the next progresses.
I am using VS 2010 and I want to read the Text File values and place them into variables. This is my code Me.OpenFileDialog1.FileName = Nothing If Me.OpenFileDialog1.ShowDialog = System.Windows.Forms.DialogResult.OK Then Me.TextBox2.Text = Me.OpenFileDialog1.FileName filename = Me.TextBox2.Text End If [Code] ..... I am unable to move pointer to next line.
I have the String and integers to which some values are assigned. now i need to read the string and integer values and assigned them to the datatable which i have created using VB.Net.
I have an application in which I have two text boxes in which I enter name and age, after I enter the name and age then I click the Add button when I click the add button then the Name and the age should be displayed on the Datagrid contol in the same application. But the data should not get saved in the Database, it should just show the data on the Datagrid contol. And they have told me that its mandatory that I have to use the DataTable object.
And when i click the Commit Changes then only the data should get saved to the Data base...This i can do .
Dim dt As DataTable = New DataTable("Intervenant") For Each column As DataControlField In grdvIntervenants.Columns dt.Columns.Add(New DataColumn(column.HeaderText)) Next
[code]....
I am developing in ASP.NET using VB.NET as background code. I am on vs2008 with windows 7 enterprise edition.I have just restarted doing VB.Net and my first time using a gridview without a DataBase, so maybe I am missing something. Basically, I am trying to add a DataRow (dr) to a DataTable (dt) and then put said DataTable into a Gridview (grdvIntervenants).My first step is to take the gridview and put all its data into a DataTable. Then i create a DataRow(dr) that I populate with variables and I add said DataRow to the DataTable. After that, I put the DataTable as the DataSource and bind the GridView.
The problem is that my GridView shows the rows but they are empty.While debugging, I found out that this error was beside all the DataRow.Item:"In order to evaluate an indexed property, the property must be qualified and the arguments must be explicitly supplied by the user" Seraching for it on the net.I did not totally understand the error, so i tried many different ways of adding the data into the DataRow but to no avail. I also tried different way of adding the column thinking the index problem might be coming from there, but again, the problem persisted. Now, something I found weird was that the Item property of my DataRow gives the quoted error, but I see the values into the ItemArray of the DataRow.I also found out that the same error appears beside the columns property into the dataTable.When I try to access the data from the DataSource in my rowDatabound method using the DataBinder, it gives me null results...
I have two data tables. dtAllResults is the master data table which contains ResultIDs and everything related to each ResultID. dtNoCV is the other data table which only contains ResultIDs. If the ResultID from dtNoCV is located in dtAllResults I want to update some checkbox cells in dtAllResults (as seen below).
I'm looking for better performance, because dtNoCV may contain a few hundred ResultIDs and I'm afraid this loop will slow things down.
Private Function prvfnc_UpdateDGVSource(ByRef dtAllResults As DataTable, ByVal dtNoCV As DataTable, ByVal intEnumValue As Integer) As String Try
I am using strongly typed dataset and have many tables in that. The problem is now I want to filter data from GetData() function which has a query like select * from table_name
How can I filter a particular table and distinct values from it. Also if I try to filter it return all column but rest have null values except the one I asked, so I cannot assign it as a datasource to a datagrid or combobox. How can I do this..
I want to loop through a databale and change the values of a specific column in that datatable.eg: the database returns Request_ID, Desc, Date and Status_Ind. The Status_Ind column contains integer values. I dont want to show the integer values to the user. I want to convert that to a string value based on the integer values returned in that columns.
I am having a problem trying to replace the missing values in my Dataset tables with a default string. The columns in my datatables should be all strings.Here's the code I am using, but I am getting the DBNull to string conversion error.
Code:
For i = 0 To MyDs.Tables(j).Columns.Count - 1 For k = 0 To MyTable.Rows.Count - 1 IIf(IsDBNull(Trim(MyDs.Tables(j).Rows(k)(i).Value)), "None", Trim(MyDs.Tables(j).Rows(k)(i).Value)) Next Next
