2,634 Topics
![]() | |
Hi Everyone I have a monthcalendar control and a datagrid on my form. I want to display records from a dataset depending on the dates that i select from my month calendar control. Please help | |
Hi. Stuck with some problem again. Here is the case. I have a sql server database table for storing users information. In the table there's a field called menu_link which stores menu URLs for my web application. This is to restrict which menus are viewable to authorized users. Those who … | |
Hi ,I work with vb.net 2005 . I want to know if I want to connet to data base with Ms Access which data source i can use (ODBC or OLEDB) I write the following code in form load event (by OLEDB) : [COLOR=#0000ff]Dim[/COLOR] conn [COLOR=#0000ff]As[/COLOR] [COLOR=#0000ff]New[/COLOR] OleDb.OleDbConnection([COLOR=#800000]"Jet OLEDB:Global Partial … | |
hi, i am developing paging in asp web application by using VB.net. i am getting out put for when i am setting the paging for 10 but it is not going for the next page with paging.If i set the paging to8 or less than 10 i am getting the … | |
i calling the method to display in web browser using JSP....ii have create the piechart using java code and save it ask JPEG......i just want to use JSP to calling and dispaly the method and display the JPEG pie chart in web browser..... anyone who can help me here i'm … | |
Hi Folks, I'm working on a small application that interacts with a sql database. I've managed to pull a list of customers (Company names) from the Customer table and populate a combobox. Now I'm trying to populate some textboxs or labels with the company address from the same database based … | |
Hello, I am very new to ASP and have been taught by one of my colleagues that I could leverage Dreamweaver (i have version 8) to create ASPx pages that collaborate with Microsoft Access -- to implement a webpage that displays, as I would like to call it, news snippets … | |
Hello everyone, I just started working with .net and need to create a simple login page. I have the design page but am struggling with the code behind. This is what I have so far. Alot of it is what I got from samples over the net. Below are the … | |
I have a form with a datagrid on it. If I 1) scroll to the right to a field that wasn't originally displayed on the grid 2) click on the header of that field to sort the datagrid 3) then scroll down to bottom area of the datagrid and selects … | |
i want to pass a parameter as a datarow to the web service cant it possible dataset we can pass but want ot pass datarow please help me out i need it urjent | |
Hi i am basha, i am new to VB.NET. I have a problem, i am able to retrieve data in datagrid throug dataset. code is [DG.DataSource=ds] but if i change any data in grid, it's not changing in database. please tell me why its not changing and tell me the … | |
Why can't I get the changes in my grid to update the data base? Here's the code.............. Public Class frmAddChangeDelete Inherits System.Windows.Forms.Form Dim currpath As String = System.Environment.CurrentDirectory Dim connService As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source= " & currpath & "\ServiceCalls.mdb") Private daCustomers Private daCalls Private daStatus Private serviceDS As New … | |
Hi Every one,:confused: I have a month calendar control and a datagrid on my form. I want to display records from a dataset of the dates selected from a month calendar control. I use VB.NET and Access database. Please Help:!: | |
hi, i m novice to asp.i m using one stored procedure in sql server2000 which is using cursor.this is doing the following things 1) select the peticlur records from one table 2) insert the record in another table relavant to retireved ID 3) select the second table values i m … | |
I have a mdb file and I access it through ADO.NET, from time to time I have to update an existing record, so I do this: [code] Dim dsDataGen As New DataSet Dim daDataGen As OleDbDataAdapter Dim cbDataGen As OleDbCommandBuilder Private Sub Data_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) … | |
hi, i m novice to asp.i m using one stored procedure in sql server2000 which is using cursor.this is doing the following things 1) select the peticlur records from one table 2) insert the record in another table relavant to retireved ID 3) select the second table values i m … | |
What I ask can be very familiar to most of you. So, please don't point me a URL in MSDN, I can't understand the stuff there. Instead please add the "lacking" codes and help me to complete the code.I need to store First Name and Last Name of userswhich come … | |
hi there, this is my first post and i hope to contribute to this community in any way that i can. scenario: I have a database table with columns-> name, address, zipcode. each row contains the address of a person. desired result: i need to generate letters in crystal reports, … | |
I want to fill a drop down list with some data in a data source. I defined a page level array and redim it in Page_Load. I get an error saying "Object reference not set to an instance of an object" The error occurs at the statement, Page.DataBind() Below is … | |
Hi, Does anyone know how to format a DataGrid control with fixed Height and Width values with a vertical scroll. The DataGrid columns are bound to a Dataset. Thanks | |
Hi, Iam a new comer.Joined today.Would like to clear one of my doubts. I have a doubt regarding the columns in datagrid. Iam using vb.net2005 (win application) I have a typed dataset, with the column names as that of the database(sql) table fields.i had set a datagrid's datasource to this … | |
hello!!! again i encounter a problem ......... I was wondering if anyone can point me in the right direction. What i am trying to do is create a volume dataset. I have been aiming to create a coloured cube and put a cylindrical object inside it (of a different colour). … | |
I spent my whole day but I could not solve the problem. I dont have much experience in Asp.net. Please help... DropDownList dont send selected value to the Sub DropDown_SelectedIndexChanged The Error Message is:[B]Exception Details: [/B]System.NullReferenceException: Object reference not set to an instance of an object.[B] [/B][B]Source Error:[/B] Line 38: … | |
Hi all, I am having a wee bit trouble with with the SQL Command Builder. It does not build anything but frustration. From all the books I have read and everything this is how you go about updating changes from dataset or datatable without writing your own updating logic. Build … | |
hi... i create a new table with this code Dim SQLCreate As New SqlCommand Dim Conn As New SqlConnection Dim DA As New SqlDataAdapter Dim DS As New Data.DataSet 'Create DB SQLCreate.CommandText = "CREATE TABLE test (ID integer NOT NULL)" SQLCreate.Connection = Conn Conn.ConnectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\RBD.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True" … | |
Cheers to my first 6hours of coding ... but that's the catch when you start (or start over) ... you get stuck with silly problems: I have created a DataGrid with a DataSet from a search result class- Now I've added a button in my rows to get a new … | |
hi all i write this code Protected Sub btnCreate_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnCreate.Click Dim SQLCreate As New SqlCommand Dim Conn As New SqlConnection Dim DA As New SqlDataAdapter Dim DS As New Data.DataSet 'Create DB SQLCreate.CommandText = "CREATE TABLE test " SQLCreate.Connection = Conn Conn.ConnectionString … | |
[COLOR=#0000ff]well thanks expert team it solve some of my prob but tell me how can i pick up reports on sql query basis bcz it works in sql but doesnt shows any result there would be a single command plz tell me that or if just ignore the sql query … | |
[COLOR=blue]i wrote this code in the display of a page[/COLOR] sub Display() dim strcon as string ="Provider=Microsoft.Jet.OLEDB.4.0;DataSource =Sales.mdb" dim strcommand as string ="Select * from sales" dim myconnect as oledbconnection = new oledbconnection dim myAdaptor as oledbDataAdapter = new oledbDataAdapter dim salesDS as DataSet = new DataSet myconnect.ConnectionString=strcon myAdaptor.SelectCommand=new oleDbComman(strcommand,myconnect) … | |
My page displays the info in the text boxes, but when we run the click sub for the update button it returns the info that it has been updated sucessfully. Here is the page code and below that is the stored procedure it uses, but not update in the database. … | |
i have Connected to MSAccess using OLEDB in ASP.Net. I have opened the Connection. i have a dataset which contains a table with 500 rows and about 140 columns. I have used nesting for loops to read every row and column of the dataset Table.The Problem is if i read … | |
Hi! I'm trying to teach myself VB.NET and having some troubles right now... please help me out :sad: I'm working with NorthWind database in MS SQL Server. I suppose I'm trying to populate tables into ListBoxes and the following highlighted lines are giving me an error (Value of type '1-dimensional … | |
I've got the dropdownlist that has datatextfield from dataset from database. And i've the problem with my dataset If i have 1 row in dataset. My dropdownlist will have one item too. And i query on event selectedindexchange So if i have only one item in dropdownlist, it doesn't work. … | |
Hiii I got a error while working with datatables... The code and Error Are Given below DataSet ds; SqlDataAdapter da; ds=new DataSet(); da=new SqlDataAdapter("Select * from emp",cn); da.Fill(ds,"emp"); DataTable dt; DataRow drr; dt=ds.Tables("emp"); c:\inetpub\wwwroot\CSExs\MoveRec.aspx.cs(109): 'System.Data.DataSet.Tables' denotes a 'property' where a 'method' was expected Please Help me.... | |
Hi! Since there is no problem (any longer) to update database via simple datatable binded to a datagridview I would like to go to a second level. Binding related tables and queries in order they are able to update data in my database. I don't find that as a problem … | |
Dear All, I have a value, strObjectAPIID, and I am comparing it to a dataset value in a loop. What i want is, if the value is equal, do not do anything, but if it is not equal, write it to the table. However, i have to check the value … | |
Can some enlightened one please help me!! :cheesy: How do i place a value into a datagrid cell. It is an unbound datagrid and i have fetched some values from a database using a dataset. Now i want to place that value in the datagrid. Also, how do i add … | |
Hi guys, I'm currently making a GUI which displays a graph. At the moment it reads coordinates within an array in the code: public int datax[] = {1, 2, 3, 4, 5, 6, 7, 8, 9, 10}; public int datay[] = {1, 1, 1, 1, 1, 1, 1, 1, 1, … ![]() | |
Scenerio. I am extracting Primary key from Listbox to read against the Products Table in Northwind database to populate the textbox controls. This particular column "UnitPrice" is giving me this error message:- " Cast from string "Display" to type "Interger" is not valid". Can someone point me to the right … | |
What's wrong with this? I know i must have missed out something. But what's that i'm missing? [CODE]Dim ds As DataSet = New DataSet Dim da As SqlDataAdapter = New SqlDataAdapter("SELECT * FROM Member WHERE MemberUserName = @MemberUserName", Conn) da.SelectCommand.Parameters.Add("@MemberUserName", SqlDbType.VarChar) da.SelectCommand.Parameters("@MemberUserName").Value = Session("Username") ' Fill DataSet with the data … | |
Hi, I just want to say thank you in advance to anyone that replies to this. I'm new to JAVA & my 4th assignment has got me stumped. I have to write a program that reads 4 integers and prints the largest and smallest value that the user entered (using … | |
Hello everyone!!! I'm very new to programming in general I'm working with VS 2005 and database built with sqlserver 2005 express. I've built a GUI to add new raw materials into a database Ive Dragged over my conn and adapter generated a dataset. I also am using a DG to … | |
Hi! I'm not sure which forum to place this in, so if there is a more appropriate one, please move it or let me know and I will repost it there. thanks. A while back I developed a simple vb.net program for keeping track of rebates. I didn't want to … | |
I am working on this screen, where top part of the screen is a browse/edit/add panel for table called "Package" And depending on the Package_ID (@@Identity) I am filling a datagrid in the bottom part of the same screen which has data from various other tables , like "Components" , … | |
i am trying to create a guest book in asp.net...but i found a compilation error: Object reference not set to an instance of an object. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and … | |
I am using an SQLDataAdapter to bind information from a database table to a listbox. However, the user have to select an item from a dropdown list box, DropdownMovie before the information for that particular movie is bind to the listbox. No errors in the codings. But when i run … | |
Guys, i have been struggling with this for past three days... here is what i have... aspx page [CODE]<form id="Form1" method="post" runat="server"> <asp:repeater id="titleRepeater" runat="server" EnableViewState="False"> <ItemTemplate> <b><%# DataBinder.Eval(Container.DataItem,"Item_No") %> <br> </b> <asp:DataGrid ID="maingrid" Runat="server" AutoGenerateColumns=True DataSource='<%# GetDataSource( Container.DataItem )%>' OnItemDataBound="maingrid_showformatting" ShowFooter=True > </asp:DataGrid> <br> </ItemTemplate> </asp:repeater></form>[/CODE] codebehind [code] Private … | |
[b][color=sienna]Understanding Caching in ASP.NET. [/color][/b][b][color=#a0522d]This tutorial is based on ASP.NET 1.1[/color][/b] This tutorial explains about The Importance of Caching, Declarative Page Output Caching, Programmatic Page Caching, Caching Page Fragments, Caching Data and Monitoring Performance. Caching is one of the coolest features in Asp.net. Caching enables you to store the expensive … | |
I have been trying to create a form to put data into a access database. I had the web host set up a ODBC connection for me. I use web matrix wizard to create the code and changed the connection string for the ODBC connection. I know I have to … |
The End.