2,634 Topics
 | |
| | I am using a FileUpload control to allow the user to import the contents of an Excel spreadsheet into an DataAdapter and then import into an Oracle database table. This works great when I use a local filesystem project. However, when I try to run this on the server, I …  |
| | I know this might have came up, but i have a login code and once logged in it would show u your information that u entered in the sql database just for that one person that logged in. Here is my problem when i login it shows another users information, …  |
| | Hi all Im trying to create a site that is multi language, in order to do this all copy, alt tag text and url links are stored in a db. I then get all the info for that language and put it into a cached dataset. i then loop through … |
| | I would be very grateful of any insight/resolution of the following issue I need to overcome. Using VS/VB2008 Pro/SQLExpress - all running on XP, I am building a WinForm Application (a Quotation application for Landscape Designers). 48 Bound controls on my form work perfectly with DataSet and Tables when Updating … |
 | I'm having difficulty understanding DataSets. I created a DataSet within a private void caled Form1_Load [code] private void Form1_Load(object sender, EventArgs e) { DataSet fooBar = new DataSet(); adapter.Fill(fooBar, "value_" + x); DataRow dRow = fooBar.Tables["ShiftLat_" + x].Rows[0]; }[/code] How can I call this data from another private void within …  |
| | Hello, I want to check the username & password of the user with the already stored database and then login. Iam using asp.net(vb) with sql server as database. Please help ME [CODE] Imports System.Data.SqlClient Imports System.Data Partial Class MasterPage Inherits System.Web.UI.MasterPage Dim con As New SqlConnection("server=localhost;database=reg1;integrated security=yes;") Dim ds As … |
| | Hi all, I have a grid view I am trying to use, and it displays a large number of pill codes, (thousands) that I would like to be able to filter down. I have set up a dropdown list that gives the different options to filter on, basically every letter … |
| | I've created a dynamic object with properties using the following code: [code] // For each jpeg in the directory... foreach (string name in array1) { x++; // select row where jpeg name is equal IF FOUND: adapter.SelectCommand = new OleDbCommand("SELECT shift1 FROM ShiftTable WHERE imgName = '" + (name) + … |
| | How to connect to a WAMP server database (located in default MySQL database location in WAMP) using C# 2010? I tried... SqlConnection conn = new SqlConnection("Data Source = C:\\wamp\\bin\\mysql5.1.36\\data\\testdatabase; User ID=; Password=;"); SqlDataAdapter da = new SqlDataAdapter("SELECT * from transactions", conn); DataSet ds = new DataSet(); da.Fill(ds, "Transactions"); DataGridView1.DataSource = …  |
| | pls help..iv juz started learning vb.net..encountered this problem in this code: [code] Private Sub NavigateRecords() TextBox1.Text = ds.Tables("stdDataSet").Rows(inc).Item(0)-error msg appeared here sayin null reference evception was unhandled. Object reference not set to an instance of an object. TextBox2.Text = ds.Tables("stdDataSet").Rows(inc).Item(1) TextBox3.Text = ds.Tables("stdDataSet").Rows(inc).Item(2) TextBox4.Text = ds.Tables("stdDataSet").Rows(inc).Item(3) this is the full …  |
| | I am currently working in an ASP.Net application where i need to implement ASP.Net Membership and Roles. I have used Login controls in my pages. Also I am using a menu in the master page, which is getting data bindings from database. For data bindings I am using XMLDatasource and … |
| | I want to retrive data from table into combobox ..when the user click combobox items it's corresponding data will be show. [B]In details :[/B] I have PERSON table , my program allow to the user search by : Person Name When the user enters the name into TextBox the combobox … |
| | hi, i'm getting error of [COLOR="Red"]data source object is invalid[/COLOR] when i try to load a transaction report from sql database. [COLOR="Red"]Error 4 Overload resolution failed because no accessible 'Fill' can be called with these arguments: 'Public Function Fill(startRecord As Integer, maxRecords As Integer, ParamArray dataTables() As System.Data.DataTable) As Integer': … |
| | Hello all, I’m a bit weird because just 2 days ago I had an interview for a .NET developer post .They promised to call me last day but they didn’t so I just want to confirm few answers given by my side. Please review them and let me hear your … |
| | [CODE] Inherits System.Windows.Forms.Form Dim bill As New POS Dim mypath = Application.StartupPath & "\db1.accdb" Dim connection As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=d:\db1.accdb;Persist Security Info=False;") Dim cmd As OleDbCommand Dim cmdGetIdentity = New OleDbCommand() Dim sql2 As OleDbDataAdapter = New OleDbDataAdapter("Select * from customer", connection) Dim db1 As DataSet = New DataSet Dim … |
| | [CODE]Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Dim conn As New SqlConnection Dim cmd As SqlCommand Dim dp As New SqlDataAdapter Dim ds As New DataSet Dim i As Integer Dim str As String = "UPDATE aspnet_Membership SET aspnet_Membership.Email='" & Email.Text & "' WHERE UserId='" …  |
| | hi there, i just want to ask for help about my codes in adding up data in my database using oledb connection. the codes is working during execution because the added item can be searched during execution only but once i close the application the data is not saved in … |
| | hi i need an vb.net program for access database, in an sql query for append (single column) .txt file into existing .mdb table , i used this code but is not working [CODE] Pth2 = My.Application.Info.DirectoryPath STTConn2.ConnectionString = "Provider=Microsoft.jet.oledb.4.0; Data Source=" & Pth2 & "\LugatWordsOk.mdb; User Id=admin; Password=;" STTSql2 = … |
| | hi guys, i'm having a problem manipulating the datagridview. i have an access database named "ETB.mdb" and a table inside it named "ETB" it is a read-only database and it has to stay that way, anyway, what i'm trying to do is to retrieve the data on the database put … |
| | Dear DaniWeb Programmers, please help me with my problem. im trying to fetch rows in 3 TABLES using JOined Queries im tried the query first in MS ACCESS and it worked but when i tried to show it in Crystal report it wont show its data. Heres the code below: … |
| | Here is my code first and then ill explain what im doing. [code=c] ds.Dispose(); ds = new DataSet(); db = new DBconnect(); Co = new Cards('S', Global.GlobalCompanyID).SetSql(); ds = db.GetDataSet(Co); dt = ds.Tables[0]; dr = dt.Rows[0]; Out = dr[1].ToString(); if (Out != "") { Time tm = new Time(""); // …  |
| | There is a list of dataset and I need to reshuffle them randomly then partition the dataset into n groups. I am using dictionary to store the list of dataset, but I am not sure how to partition items of a dictionary into n groups? What I can think of … |
| | hi, I am new to programming and looking for some help, here is the portion of the assignment that is giving me headaches: using one function, upload (i.e., input) the integer value and the color text, ignoring the word "Color:"; the function must only upload one data pair (i.e., the …  |
| | [CODE]using System; using System.Data; using System.Configuration; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.SqlClient; public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { string connectionString; connectionString =("Data Source=INTRANETSERVER1;User ID=sa;Initial Catalog=HrData"); SqlConnection myConnection = new SqlConnection(connectionString); SqlDataAdapter … |
| | Hi, I am using visual basic express 2008 . and i am adding few rows to the database using some stored procedure. it is working fine. after adding the row i am displaying in a grid using dataset . fine.but when i close the program and reopen the program i … |
| | Hello, I'm kind of new to this but have successfully launched a database UI before but this time I am using the Datagridview to display by data. I do this by OLEDB and establish my connection (see code below) and bind too two different datagrids: [CODE][/CODE] Public Sub FindTroubleshootingTable() Dim … |
| | hi... to all i've created ssrs reports local following is my code.. public void source(string tbname,string Rptname) { ReportViewer1.Visible = true; string myQuery = "select * from " + tbname; SqlConnection myConnection = new SqlConnection(ConnectionString); SqlCommand myCommand = new SqlCommand(myQuery, myConnection); myCommand.Connection.Open(); SqlDataAdapter da = new SqlDataAdapter(myCommand); DataSet dt = … |
| | Hey There, its Ruan. uhh, i need help, as i did indeed hit a brick wall. at the moment, i can connect to a database through textboxes, ill put the code at the bottom. What i want to do/know, is, How or What is the code or manner to read … |
 | I am trying to sort a vector that is a [B]protected[/B] member of a templated class into a Descending order based on the [I]second[/I] member of the contained std::pair objects. The vector has the following declaration:[CODE]vector< pair <const T, int> > mode; //holds pairs to define the mode(s) of the … |
| | This is my code [CODE] string srch1; string srch2; if (cb1.SelectedItem.ToString() == "Book Title") { srch1 = "Book_Title"; } else if (cb1.SelectedItem.ToString() == "Call Number") { srch1 = "Call_Number"; } else { srch1 = "Accession_Number"; } if (cb2.SelectedItem.ToString() == "Ascending Order") { srch2 = "ASC"; } else { srch2 = … |
| | I am using a datagridview for the output of the results and I have made 4 combobox each have its condition, asceding and descending, starts and contains with, search from table.. I am writing this with lots of code, is there any way to make this short? [CODE] string bncw … |
| | Hi all I have a gantt chart which i draw with JFreeChart. I want to add to this grpah a line that shows the current date. Does any 1 knows how to do it? Here is the code that i've written: [code] /* * To change this template, choose Tools … |
| | I've started to work something with ASP.NET in c# (i'm newbie), and i have a question: I've a DataGrid and inside DataGrid i have Columns with TemplateColumn, BoundColumn and ButtonColumn. I've binded DataSet to my DataGrid and it's all working fine but I want to know how can I programmatically … |
| | Hi, pl write me the simple example to connect student table of school database of Access through VB.net and code to AddNewRecord,DeleteRecord, UpdateRecord, SearchRecord. the fields in the table are say- Name, Desig and Age and textbox in form are- TxtName, TxtDesig, TxtAge the event under which each code has … |
 | I've posted this problem on several forums and no one has come up with the correct answer, but anyway here it goes: I've tried stringifying and querystring'ing the parameter but the Response error continues to be {"Message":"Object reference not set to an instance of an object.","StackTrace":" at ProvaReportLocale._Default.GetColumns() in \\ProvaReportLocale\\Default.aspx.cs:line … |
| | What is wrong with this code?: [code] <%@page language="vb"%> <%@import namespace="system.data"%> <%@import namespace="system.data.oledb"%> <script runat="server"> sub page_load(o as object, e as eventargs) dim conn as new oledbconnection( _ "Provider=microsoft.jet.oledb.4.0;" & _ "Data source=c:\users\asus\desktop\banking.mdb.mdb;") dim ds as new dataset("mydataset") dim objcmd as new oledbdataadapter("select * from tblusers " & _ "where … |
| | Hi, I just wanna update a gridview, but the thing is values for the gridview will be generated inside a for loop. for(int i=0; i< 10; i++) { string x1 = SomeMethod(i).ToString(); string x2 = SomeMethod(i).ToString(); // This x1 and x2 values need to be stored in DataSet or Table … |
| | Hi, I'm developing an application for my psing SQL Server 2005 as database and VB.Net 2008. Ive created the form and successfully connected all text boxes etc. Using the code, I have managed to open the database and fill the dataset. However when i BIND the Datagrid datasource to the …  |
| | Hi There, This is my code. I'm pretty sure that theres nothing wrong so far with this code. But gives me an unexpected error. The error says, Invalid column name 'Sep'. But, even through out the whole code, nor on the database theres any column or word called, 'Sep'. So … |
| | Hi I new here I have a couple of questions. I am trying to authenticate login and password and Im getting a few errors. 1. first is the db error in my dbqueries class file. I am using sqlce for testing purposes. [code] public DataSet Login(string Username, string Password) { … |
| | I have a couple of template classes "Stats<T>" and "Numerical<T>" within a "Statistics" namespace. The Numerical<T> class inherits publicly from Stats<T>. They are defined as below.[CODE] namespace Statistics { //declare Statistics namespace template <typename T> class Stats { protected: vector<T> dataSet; //contains the actual data set to be analyzed /* … |
| | Hi All, I think that answer to this should be fairly easy, but having googled it for a while and changed some settings I am no closer to the solution. I simply want to change the database that a dasaset points to in my c# application. I've got a winform … |
| | Hi all, I'm trying to implement K-means on a database.I have a table like this: The main task is to group id's and return them based on similarity in intensities depending on the number of clusters that the user want to see them. [CODE]id I1 I2 I3 I4 I5 1 … |
| | How do i cancel the filtering |
| | I need functionality to retrieve the new pk, like I could in DAO. I would like my "nLog" function (see code below) to return the new pk. I have found [URL="http://support.microsoft.com/default.aspx?scid=kb;en-us;815629&Product=adonet"]this[/URL], and I was able to make it work fine in my environment, so I'm pretty sure the problem I … |
| | yo, I've been struggling with this problem for a few weeks now, so I'm hoping you guys can help a dude out... I'm using a monthcalender control and a listbox;which displays roomnames, if it's available or not(roomstatus), it's price and it's capacity. problem 1: so depending on which date you … |
| | i want to update the row in gridview but it give me one error Object reference not set to an instance of an object. how to update the current row selected in grid view.......please help! [CODE] public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { … |
| | Hi all, I am trying to use Ajax and Jquery on master page. In my existing project i have used the Ajaxpro2.dll it's working fine. but when i am trying to use jquery then its not working. Then in jquery script instead of `$` i have used 'jquery' keyword then … |
| | Good morning all; This one is blowing my mind and I could use a little expertise. I'm retrieving data from an Excel sheet, using a simple SQL query using a textbox as input to my variable. It works great when I enter an integer to search for (such as 213 … |
| | helo all i wanted to import .csv file to my application [CODE] private DataSet ReadExcelData(string sFilePath) { DataSet dsOutput = new DataSet(); string sConnection = string.Empty; try { if (TypeExcel == "Excel 12.0 Xml") { sConnection = "provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + sFilePath + ";Extended Properties=\"Excel 12.0 Xml;HDR=YES;IMEX=1\""; } else if (TypeExcel … |
The End.