2,634 Topics
 | |
| | Hi all, Can anyone send me the Apriori Algorithm implementation in C and a dataset so that I can able execute and learn. Your help is greately appreciated. Thanks, Arthur  |
| | i use the following code to write sql data to xml file. [code]SqlDataAdapter ad = new SqlDataAdapter("SELECT name AS [@label], salary AS [@value] FROM Employee FOR XML PATH('set'),ROOT('chart')", cnn); cnn.Close(); DataSet ds = new DataSet("chart"); ad.Fill(ds,"set"); XmlDataDocument doc = new XmlDataDocument(ds); doc.Save(Server.MapPath(Request.ApplicationPath)+"\\t.xml");[/code] i get the file as [code=xml]<chart> <set> <xml> … |
| | Hi till now i am used window application in which there is no problem in connection using following code [code] Dim cnn As SqlConnection cnn = New SqlConnection("data source=RAKESH-676DD0E1;initial catalog=rw;integrated security=SSPI") cnn.Open() Dim da As SqlDataAdapter Dim dt As New DataTable da = New SqlDataAdapter("select * from publicity", cnn) da.Fill(dt) … |
| | I have a web application using vb.net. What I need to do is get my datagrid to update and delete rows in a datagrid. I have a grid view that calls a web service, passing in a query string. The problem I am having is, I am not sure what …  |
| | am using custom pagination using the following [code]Case "Prev" If GridView1.PageIndex > 0 Then GridView1.PageIndex = Int32.Parse(GridView1.PageCount) - 1 End If Case "Next" If GridView1.PageIndex < (GridView1.PageCount - 1) Then GridView1.PageIndex = Int32.Parse(GridView1.PageCount) + 1 End If[/code] for first and last its wrking properly but in using this two pagination … |
| | Hi everybody, I have a VB 2005 (Express) application with SQL 2005 database; a report (named 'c:\Items.rpt') already designed and set to "Items" table. When I preview this report from Crystal Reports, it shows data correctly. How can I show it from within VB code depending on its default dataset …  |
| | Hello I'm working with VS2005 and C#, I'm using Firebird, however I think Database engine is not relevant in this case. I want to create a lookup field and a Calculated field for my table, I search in google, but I have not find a good answer. My code at … |
 | I am trying to use a clientdataset without an associated Table. I am attempting to extract and edit data from a Cad program. The Cad program has an interface in which the user selects specific entities within the Cad file (lines, circles, text etc) and provides basic information and attributes …  |
| | [CODE]header.h file: #include <stdlib.h> #include <math.h> #include <malloc.h> #include <stdio.h> #include <string.h> #define STRBUF 256 /* Default string buffer size */ #define SEPARATOR(a) (a == ' ' || a == ',') ? 1 : 0 #define SUCCESS(a) if(a == NULL) { printf("\nUnsuccessful Allocation");\ exit(0);} #define HASHTBLSIZE 101 typedef struct tupleclass{ … |
| | i am writing the following following code public int insert (datatable object) { --my plan define job } i can insert one row in a time and i would like to insert at one time calling all data in datatables(nearly 10000 row) how to insert this data in to data … |
| | Hi, This is my first post on this forum. Apologies in advance if this isn' the right place or there isn't enough info. I'm basically trying to retreive an ID from a quesry string... xyz/nuts.aspx?nuttype=7 What I'm having trouble with is defining the variable and referencing the querystring in the … |
 | I want to execute a stored procedure using LINQ and retrive the results into DataSet. Thanks in advance. |
| | I am adding checkbox to datagridview. how can I add a checkbox to the header so that when I click that all the checkboxes should be checked and corresponding rows should be deleted.. I am able to delete one row at a time. How to delete multiple rows.. [CODE]DataGridViewCheckBoxColumn chkBoxColumn … |
| | Hello I am trying to create a combo box that would display data from a dataset, and also a 'Please Select' as the first item. I have written the following code which derives from a combo box and it works fine in visual studio 2003 but in 2008 would not … |
| | Hi, I am just start programming by using C# not longer time,there are few thing i don't understand. 1) I have a task that need me to access to the database in the server. Can i know what coding what i should use in the C# webform for me to … |
| | Hi all, I am new to asp.net programming and i have a 2 queries : I am using a web form to allow the user to enter values into a database and i am successful in performing this task. now i have another form for retrieving values from the database … |
| | I have a dataset and when I write it to an XML file I am getting this: [code] <?xml version="1.0" encoding="utf-8" ?> - <string xmlns="http://tempuri.org/"> - <DATASET> <DATAROW ConfigItemName="xx" EnvironmentName="xx" AssetOnlyInd="x" AssetTagDesc="xx" SerialNum="xx" /> <DATAROW ConfigItemName="xx" EnvironmentName="xx" AssetOnlyInd="x" AssetTagDesc="xx" SerialNum="xx" /> <DATAROW ConfigItemName="xx" EnvironmentName="xx" AssetOnlyInd="x" AssetTagDesc="xx" SerialNum="xx" /> <DATAROW ConfigItemName="xx" … |
| | hello, i am using .net 1.1,vb ,i have 2 web applications.one is installed in client side server which is currently working offline(intranet)..other is at my side which is online website.frequently i have to give master data to client .So using httprequest and xml , i am giving him data.I have … |
| | Hello I try pass data from a table in Firebird to SQL server Mobile. I'm using c# in vs2005, and I have problems with transactions. At the end, if I want to rollback transaction, I would like to undo changes, but in the code I show you, Changes allways saves … |
| | Hi all, i want to create one crystalreport from following storeprocedure [CODE=SQL] CREATE PROCEDURE dbo.usp_proc1 ( @ID as int ) as declare @Var1 as varchar(1000); set @Var1 = ' select ID,Name,Email from Demo where ID='+Convert(varchar,@ID) print @Var1; exec(@Var1); [/CODE] This is not the actual code but its a demo of … |
| | I have a simple form that collects names in time slots. The form lists all the time slots with the names and blank spots available. The problem I'm running into is people are overwriting other names so they can get a time slot they want. I've done some research and … |
| | hi, i am doing a project using C#. in my project, i stroed the database information into the dataset. i do't know how to collect the data from dataset using query. i know collect data from dataset using datarow method, but task is collect data from dataset by using query. … |
| | I'm new to datasets, and trying to update a SQL Server database with one. I'm having trouble understanding how to correctly write the dataset info to the server db and preserve the relationship keys. When I write to the main table in the server database, it will assign the new … |
| | hi, I have Created a vb.net Application with MS ACCESS DATABASE, everything is working fine, But, There is a small problem . Everytime i ADD a new record it saves succesfully but i can only view that particular saved data only after restarting the application..Pls Help me ****************************************************** Imports System.Data …  |
| | Hi There, I am very very new to C#. I need to create a Windows Service, which should check my sql server database for every 30 seconds, and it should do some calculations on some table and insert them in some other table. I have the C# code to do … |
 | Hi I have dropdown list in my asp.net page.I wrote a below coing coidng in the `SelectedIndexChanged`, protected void cmb_Se_SelectedIndexChanged(object sender, EventArgs e) { SqlConnection con=new SqlConnection("Data Source=20.1.2.58;Initial Catalog=Customer;User ID=test123"); string str = "select ExecutiveName from Executive where TeCode='"+cmb_Te.Text+"'"; con.Open(); SqlCommand command=new SqlCommand(str,con); SqlDataAdapter adpter=new SqlDataAdapter(command); DataSet data=new DataSet(); adpter.Fill(data); … |
| | Dear All, I have a problem with my Dataset. I am working on VB 2005. My problem is that any changes I make to the DataSet (like adding new query, modifying existing one) I cannot find it (the changes I made to the dataset) while I am working on one … |
| | Hi All, Please Help me with this issue as i m very new to VB.NET. I have Created a vb.net Application with MS ACCESS DATABASE, everything is working fine, But, There is a small problem that i am facing . Everytime i ADD a new record it saves succesfully but … |
 | hi i'm using oledb to read from an excel file into dataset. my program is showing the dataset using datagridview, when i'm trying to change the cell content and update the dataset i get an error : "Update unalbe to find tablemapping['Table'] or DataTable ['Table'] my code is: [CODE=c#]public static … |
| | i am trying to generate a method in event handler of combo box. I am trying to read data from the database using array so that when i click on the combo box it will link to the textboxes. I have declared two arrays, one for combo box and another … |
| | How do I display multiple questions per day? Also, I am using Visual Studio 2005 and am using a database to retrieve the data. This is the sample code: [code] private string GetCurrentQuestion() { string str = ""; DataAccess da = new DataAccess(); DataSet ds = new DataSet(); da.Connect(); ds … |
| | Hi, I am very much a novice in .Net.. I started doing an application which uses reports. I am using report viewer control.My database is a .mdb(access) file. i just want add parameters to the report. The problem starts here. Through some browsing I found that Local Reports does not … |
| | pls give me the complete code for it ..i tryed but not getting the output..pls help..iam pasting the code here but no output [code=aspnet] SqlConnection cn = new SqlConnection(ConfigurationSettings.AppSettings["con"].ToString()); protected void Page_Load(object sender, EventArgs e) { Response.Write("sql is connected"); SqlDataAdapter da = new SqlDataAdapter("select countryid,countryname from countryname", cn); DataSet ds … |
| | Guys I have a dropdownlist control with categories so when I select something from ddlCategory I wana display all the products fall under that category in a datagrid but I dont seem to get that right... here is the bit I have done [CODE=C#] protected void Page_Load(object sender, EventArgs e) … |
| | hi i'm using a datagrid view control which get's his datasource from a dataset control. my code is: [CODE=c#]dataGrid = new DataGridView(); dataGrid.DataSource = dataSet.Tables["Vertexes"]; this.Controls.Add(dataGrid);[/CODE] the datagridview in shown fine. the problem is that when i try to cahnge cells color like this: [CODE=c#]for (int x = 0; x … |
| | I have the ff error and I have no idea what is [COLOR="Red"]Line 1: Incorrect syntax near ','. [/COLOR] [COLOR="Red"]Exception Details: System.Data.SqlClient.SqlException: Line 1: Incorrect syntax near ','.[/COLOR] Source Error: Line 101: dgItems.SelectedItem.Cells[0].Text; Line 102: [COLOR="Green"]the application point the error in the ff line that fills in the dataset[/COLOR] [COLOR="Red"]Line …  |
| | Can someone please help with this project of mine? I am not really good at GUI... create a new account, check account status. and make purchase with a credit card. Create a New Account You must ask the user to input some information: applicant's name (e.g. "John Smith"), application date …  |
| | I have 2 datagrid, 1 with details of Category and the other with the products user selected from the other datagrid, what Im saying is I have a select command on my 1st datagrid so when I select something from my 1st datagrid it should be added to the 2nd … |
| | hello sir , i am getting problem with crystal report VB.net and SQL Server i want selected values to be printed in crystal report so i have written sql query for that . dataset shows selected values but crystal report shows all data in database Please help me . following … |
| | Hi everyone, hope ur all. After a long time i m posting here. M in a problem abt. dataview.rowfilter. Matter is i have to create datareader from dataset, thats ok. The dataset is being filled up,no probs. After that i m applying rowfilter which is not working : [ICODE] da.Fill(s); … |
| | I'm not sure if I'm doing this correctly but up to now I get an exception error. Can you see why? : [code] public void countHeap(){ System.out.println("input data:"); for (int i = 0; i < dataSet.length; i++) { System.out.print(" "+dataSet[i]); count++; } noDataElements = count; formHeapTree(); } public void formHeapTree(){ …  |
| | Private Sub frmtourmaster1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim ds As DataSet Dim i As Integer objConn = New connctionclass1 ds = New DataSet ds = objConn.funFillTourLocation() For i = 0 To ds.Tables(0).Rows.Count - 1 cmbindiantourcode.Items.Add(ds.Tables(0).Rows(i).Item("tour_location")) Next cmbindiantourcode.SelectedIndex = 0 End sub [B]My connection to the … |
| | Doing a small project in which data from warranty cards are entered into a database ie. warranty card number, salesman name and ID, etc etc......after all the data has been entered into the database I need to check and see if there are any duplicate warranty card numbers in the … |
| | hai friends i am writing the code for search button; while i am wrote and complied that it gives the following error. so many times i checked and posting into the forum now please clarify this problem.. code is: [code=asp.net]using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using … |
| | I am new to vb.net crystal report. I have created a dataset,a report and a vb page. I am running a view for the month of jan. so my report looks like project name jan aaa 01 bbb 20 ccc 30 but i want a report like the below project … |
| | I realize that the response time of my GUI is extremely slow! I have three combo boxes - I want the user to select a template from one drop down list, which will populate the second drop down list with customers related to that template. When a customer is selected, … |
| | how can I select which data I want on a report from code in vb.net? I've been trying to use a dataset but that isnt working. |
| | Hi everybody If I can Store The database accessed information in DataTable object then what is the purpose of DataSet, Similarly if i can use DataAdopter object with dataSet , then what is Command Object? |
 | Hello I'm making a wabsite with a gridview(so far..) but,when i try to fill with a dataset ...nothing ,i can't see no data and my dataset is never empty ,it contains data .I ran some debugs and the dataset reads correctly from the sql server database here's the code [CODE] … |
 | Hi I'm getting the following exception from accessDa.Update(ds.Tables(0)) [B]No value given for one or more required parameters[/B] In the following code[COLOR="Red"] (marked in red)[/COLOR]. [code] Protected Sub DataTableCurrMonthForWorker(ByVal ccMifal, ByVal ccWorkerID, ByVal theYear, ByVal theMonth) Dim totInsert As Integer Dim currDay As Integer = 1 Dim theDate As Date Dim … |
The End.