2,634 Topics
 | |
| | static void Main(string[] args) { string[,] fp = readFilePaths(); OleDbConnection con = new OleDbConnection(); OleDbDataAdapter da; DataSet ds = new DataSet(); con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/Documents and Settings/kyalanur/Desktop/Nav tool/PCGDataManager.mdb;User ID=;Password=;"; string sq = "SELECT * FROM History"; con.Open(); da = new OleDbDataAdapter(sq, con); da.Fill(ds, "History"); for (int i = 0; i …  |
| | Hi all, I have two dropdownlist (country and city dropdownlists) taking their data from access database, in order for filtering the data shown in gridview. I want city dropdownlist get notified and change whenever a country selected from country dropdown list I mean, wheneever user selects a country, I want … |
| | hi, I am from c# field and now are doing a project using VB, I wants to ask about question as below: 1) private static DataSet ds; I wants to convert the C# codes above to VB syntax, but VB seems like don't have equivalent keywords of "static"(Correct me if … |
| | Dear All, I have a search page on which I have two DropDownLists. One for Catagory and another for Item. When I select both of them it takes me to the result page and displays the result in GridView. It works for a single value but for more than one … |
| | Hi, I have two DropdownLists. One is for Category and another is for Product. The concept is that with each Category and Product selected, the website will display the result on another page and show all the results present in the database. With more than 25 Categories with me and … |
| | Please review the code as i am geting the error where i have placed arrow mark on the code section. Afer editing when i click on the update the below error is fired. what i am doing wrong Error: Unable to cast object of type 'System.Web.UI.WebControls.DataGridLinkButton' to type 'System.Web.UI.WebControls.TextBox'. using … |
| | hey acctually i want to retrive data from text file nd save it to sql database bt i just have to implement some conditions like if there are 3 entries exists in text file with the same ID but i just have to get only 2 of them so in … |
| | hi guys this is just a simple question i want to know how to store images in database here is my code that i used so far: [CODE]Private Sub btnOpen_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnOpen.Click OpenFileDialog1.ShowDialog() txtimg.Text = OpenFileDialog1.FileName PictureBox1.Image = Bitmap End Sub Private Sub … |
| | I am debugging this error on my dataset table.I dunno what error is this should called.I calling store procedure then return to me this error.When i run in mssql is showing fine.But debug in C# ,1st table is showing fine but 2nd table is showing error mark in all my … |
| | Dear all, I have tested my code in order to pass single value to single parameter field in crystal report from VB.NET Form, it is ok but the problem is that I want to pass multiple values to only one parameter field called "Product Name" and it displays only one … |
| | Hi. I'm trying to print from datagridview but I don't understand how to do it. I've found some coding and this is the best for me. [URL="http://www.vbnettutorial.net/?Id=132&Desc=VB.Net-Print-Datagridview-in-WinForms"]http://www.vbnettutorial.net/?Id=132&Desc=VB.Net-Print-Datagridview-in-WinForms[/URL] But the tutorial is using server and I'm using this to call my table from Acces to datagridview. I don't know where to … |
| | hello everyone still now i m working in c# window application and now im working in asp.net i made a same form and same coding in window application but this code is not working in asp.net... i want to do here is: [B]member_id textbox[/B] when i put some data in … |
| | i m using access 2007 and i create one view from 3 table now i want to pass this view in crystalreport but it can't work? view name is = Com_Out_Qua_Panding here is my code [code]Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click Dim ReportForm As … |
 | Hi I am trying to update my database based on the selected values in two comboboxes. Combobox1 = Manufacturers Combobox2 = Orderlists In the App the user selects a manufacturer and then an orderlist and then presses Ok button which updates the default orderlist for the manufacturer. I am having … |
| | I have input data in excel and csv format.so depending upon whether user is giving excel or csv ,i have to use that.i have attached the code. [CODE] if (excelfileupload.HasFile) { String FilePath = Server.MapPath("~/Files/FileName.csv"); System.IO.File.Delete(FilePath); DropDownList1.Visible = true; DataSet excelds = (DataSet)Session["excelDataSet"]; DataTable samples = excelds.Tables[0]; ArrayList rowcontents = … |
| | Hi i have 3 list view...1=Courses, 2=Semester, 3= Section.. when i select any course so in semesterlist view semester should come with respect to Corses...similary when i select semester so section should come with respect to semester...but i m not able to do it...... i have written this code... [CODE] …  |
| | I am working on a database project and am in need of help. I have a database used for tech support call logging where each call is logged per machine_serial#. There are 3 tables for this example. Customer, Machine & calls. In the database customer and machine have a relationship … |
| |  |
| | * i had created a dataset which is "dataset1.xsd"-> data table in dataset1.xsd is "trns" trns filds are mentioned below-:which is same as my database table trns trns-> "tdate" "ttime" "tGoldQty" "tSilverQty" "tGoldRate" "tSilverRate" "tPaid" * my rdlc file is report1.rdlc- from report menu - i had select report data … |
| | Hi all, I have a problem while deleting xml File. In detail i have generated xml file with encrypted format. now when i am importing this file with decryption all data read and inserted to database using dataset. Record inserted successfully but when all process completed i want to delete … |
 | i'd lyk to upload files into the database via a dataset to first test some conditions. i've maitained the dataset's state between postbacks to add all the rows b4 updating. however the datarow line[CODE]dim autorow as datarow autorow= viewstate("dataset").tables("datatable").newrow ' the dataset and the datatable are all declared [/CODE] pops … |
| | this is a part of my code. can anyone help to write database tables to xml format without usingbuiltin function in .net (i.e xmltextwriter and writexml) private void WriteDataSetToXmlFile(DataSet ds, string fileName) { if (ds != null) { string b = TextBox2.Text; string absoluteFileName = Server.MapPath(fileName); System.IO.FileStream myFileStream = new … |
| | Hi i am using ASP.NET.I want to create Insertquery using Dataset.I have created this using DataSet1TableAdapters; FirstNameTableAdapter first = new FirstNameTableAdapter(); DataSet1.LoginDataTable de = first.InsertQuery(TextBox1.Text, TextBox2.Text); and error is Error: Cannot implicitly convert type 'int' to 'DataSet1.LoginDataTable I also want to use same iN Dataset and want to create Login. … |
| | [CODE]public partial class goruntule : Form { SqlDataAdapter da = null; DataSet ds = null; SqlCommandBuilder cmdBuilder; DataSet changes; public goruntule() { InitializeComponent(); } private void goruntule_Load(object sender, EventArgs e) { label1.Text = PERSONEL_TAKIP.main_form.goruntulenecek_tablo; DataTable dtusers = new DataTable(); da = new SqlDataAdapter("SELECT * FROM " + PERSONEL_TAKIP.main_form.goruntulenecek_tablo, PERSONEL_TAKIP.main_form.myConnection); da.Fill(ds); … |
 | Helllo I'm doing a theatre booking system for an assignment. I have got to the stage where I can generate the seating plan from the database. The problem that I am having is that the seats are running in the wrong direction. I have swapped my x's and y's but … |
| | Hey there =) Im struggling to save a file to my MySQL database. I managed to save a image to the database with this code [CODE] SqlConnection con = new SqlConnection(Properties.Settings.Default.NorthWestConnectionString); SqlDataAdapter da = new SqlDataAdapter("Select * From MyImages", con); SqlCommandBuilder MyCB = new SqlCommandBuilder(da); DataSet ds = new DataSet("MyImages"); … |
| | Hi. I am doing a C# windows form application and I am using Ms Access for the database. I have a sql query which retrieves data from 2 tables and I am displaying it in a crystal report. The problem I am having is for example i have 4 records …  |
| | hi i want to show my table in afrid view reading from database but i couldint i tried many times can any one help me this is my code: [CODE] <%@ Page Language="JScript" Debug="true" %> <%@ Import Namespace="System" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.OleDb" %> <%@ Import Namespace="System.Data.sqlClient" … |
| | The problem is Red color there. when add record into table. I want have same LoadingNo but different RecNo. But I'm using this only can add record until 2 only. Expert please help me!! [CODE]private string CalculateNewRecordNumber(string record) { string[] data = record.Split('/'); DateTime currentDate = DateTime.Today; int recordYear = … |
 | Hi, I am working with crystal report using dataset. The dataset is filled first then applied to crystal report. Its working perfect , but when I click on the next button of the crystal report viewer it goes to 2 nd page but it doesn't go to the 3 rd … |
| | Hi. I am doing a C# windows form application and I am retrieving data from a database and saving in a datatable temporarily. I have to access each cell and update them. [CODE] try { string TaskStatus = "Assigned"; SqlCommand cmd1 = new SqlCommand("SELECT Day_Date FROM tblDaily_Task_Schedule WHERE Task_Status='" + … |
| | I am using SQL Server 2005 and Visual Studio 2008. I would like to add a report using an existing dataset. I want to group by Reservation Month BUT the field is dateTime. How can i only display reservvations per month? |
| | Hello, I want to save multiple record in database from DataGridView. I have some code but their is an error i.e [B] Column named id cannot be found. Paramater name:columnName[/B] [CODE]SqlConnection cn = new SqlConnection(); cn.ConnectionString = "path of connection"; cn.Open(); string q = "select * from abc"; SqlDataAdapter da … |
| | Hello, I'm newbie here, my problem is in Windows Forms I have a Dataset and I added a query to it. What I want is, returned result of the second query should fill the count datatable. OR add a new column to my existing datatable. then I can use the … |
| | I have combo box of programme and another is courses.. when i select any programme combo box so courses combobox add courses with respect to programme... the problem is when select another programme so previously programm's course also included in combobox.. i want to remove previously courses..in courses combobox. [CODE] … |
| | Hi i have a dataset already created (which may consist of many tables) now i would liek to fill the datagrid view from it. BY CODE how can i do so? |
| | Hi, I am using dataset to fill the data first and then using those datasets to design the crystal reports.. the reports are working properly, but when i click on the next button it does not navigate through the report.. Regards, Victoryy... |
| | i cant tell really what the problem is but i get the following error oe ex. [CODE]Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Try Dim Connection As New Data.SqlClient.SqlConnection("C:\Documents and Settings\Administrator\My Documents\Visual Studio 2008\Projects\LugWdLib\LugWdLib\lugthes_source.sdf") Dim Command As New SqlClient.SqlCommand ' declare a command to select … |
| | Hey, Basically I have a text box to search data from my SQL DB from, and I want the information to then display in a listview underneath. I have been trying for a while now and still can't get it to work, but on the button click it should display … |
| | Hey so I'm having some problems with vb.net 2008. I need to create a search form where a combobox populates with names then the user clicks a name and the textboxes in the form are filled with the correct data for example txt_Firstname txt_last txt__nameage would all be filled with …  |
 | afternoon all hope someone can help, i want to populate a report and print it directly without the user hitting the print button. i have this working in a diffrent project but for some reason it wont work in this one. i get the error missing parameter, on the last … |
| | [CODE]using System; using System.Data; using System.Configuration; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; /// <summary> /// Summary description for class1 /// </summary> public class class1 { SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["privacycloudconnection"]); SqlConnection con1 = new SqlConnection(ConfigurationManager.AppSettings["cloudconnection"]); SqlCommand cmd, cmd1, … |
| | So with my program I'm trying to count the number of operations it takes to perform a insertion sort/quick sort. And because functions are calling other functions from inherited classes, it gets a bit confusing as to where I can place the operation to increment the number of operations. Right … |
| | Hi guys, i have two tabs one is expiry date and block. my problem is, when i click block tab for 1st time it will correctly populate the datagridview. but when i click expiry date tab then block tab again, i got this error 'Provided column already belongs to the …  |
| | i have datagrid view which uses dataset.. i would like to filter my datagridview by idCardNumber (getting it from the textbox1) how can i do so? could u explain pls? |
| | I got a dataset which contains the following data: id code description eff_date end_date --------------------------------------------------------- 1 ADV ADVANCE 2007-12-01 2007-12-31 2 ADV ADVANCE 2008-01-01 3 BUS BUS TICKET 2005-03-09 2007-04-05 4 BUS BUS TICKET 2007-04-06 5 PET PETROL FEES 2008-01-02 2009-10-11 6 PET PETROL FEES 2009-10-12 7 BOK BOOK 2010-01-01 … |
| | i have a private sub that reads 4 lines of data from a text file, and then uses whats read and stores them in varibles. see below [CODE] Dim FileName As String = configfileV Dim TextFromTheFile As String ' Whole text Dim Lines() As String ' File splitted to lines … |
| | I feel guilty about posting again but I need help again and I have tried other sources of help e.g google and asking someone who is familiar with vb.net but still can't find the solution to it. It must be another simple fix but I cant find any reference to … |
| | I return 30 tables or so from sql in a stored procedure. In the stored procedure I select these tables via... [CODE]select * from myTable1 select * from myTable2 select * from myTable3[/CODE] etc. These tables lose their sql table name when returned in a dataset and have default names … |
| | the code is below. the system said me that the insert into sql syntax error any solutions? [CODE] Dim dbProvider As String Dim dbSource As String Dim constr As New OleDb.OleDbConnection Dim sql As String Dim ds As New DataSet Dim da As OleDb.OleDbDataAdapter form load code: dbProvider = "PROVIDER=Microsoft.Jet.OLEDB.4.0;" …  |
The End.