2,634 Topics
 | |
| | Thanks to Daniweb I've almost finished my project just the last few bits to do e.g to prevent double bookings I've had a search around and found [url]http://www.daniweb.com/forums/thread129022.html[/url] which has helped me to make this [CODE] Private Sub Button2_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click Dim con … |
| | Hi, im writing a little app that will run a stroed procedure on my sql database and whip the results (a list of email addresses) in to a new mail items "to" box. I have my connection strings working and can extract the data fine. I can create the new … |
| | hi i m new c# and this is my very 1st project ,here i want to add or view data and this is the code i have used.everything works fine but i cant navigate through records properly,i m working with 2 tables i.e BankMaster and BranchMaster [ICODE] private void branchmaster_Load(object …  |
| | I have made a window application using Visual Studio2008,C#,MS Access database. In my application there are three tables "country","state","person" .On the form,there are 2 comboboxes one for "country" and other is for selecting "state" , also a textbox for entering the name of a person for each country-state pair. Now … |
| | Yet another date time related sql statement i need help with, oh how I loathe them. I need to find the records between now and a week ahead. I have this so far [CODE] Dim con As New OleDb.OleDbConnection Dim OleDBCon As System.Data.OleDb.OleDbConnection Dim ds As New DataSet Dim da … |
| | Hey all I'm having loads of problems trying to update my database with a dataset, I have been looking around forums and posts and trying all sorts of work around's, as far as I can assume, I will need to manually create (insert, update) function querys (even though as far … |
 | I Use visual Basic 8.0 and Mysql 5.0 I have one Table1: [COLOR="Red"]Table1[/COLOR]: RecordID , Integer = primary key auto_increment NOT NULL Articlenr , Integer Articlename, Char(20) Table1: has two records: RecordID, Articlenr ,Articlename 1 , 1000, Hamer 2 , 2000, saw I want to use Datagridview to update Mysql … |
| | I was wondering whether anyone could tell em whats wrong with this code. Its trying to get the records where the theorydates (stored in a database as shorttime) are before 2 years ago and return the records in a datagrid but it doesnt. [CODE] Private Sub ExpiredTheoryTest_Load(ByVal sender As System.Object, …  |
| | Hi This is my first time posting after daniweb has helped me alot but I couldn't find a solution for this so I thought hey why not ask. Basically I would like to have an sql statement which selects all the bookings from a table in microsoft access callled tblBookings … |
| | [B]CON90000027 16/07/2009 109900024 17/07/2009 002440 S KEERTHI EXECUTIVE INFORMATION TECHNOLOGY [/B] 22/07/2009 ho plant 2wheeler 3 test for direct amount1 7.50 21/07/2009 plant ho 2wheeler 6 test for direct amount 15.00 23/07/2009 plant ho 2wheeler 1 test for direct amount2 2.50 ------------- 25.00 ------------- [B]CON90000028 16/07/2009 109900025 17/07/2009 002440 S … |
| | Hi everyone, In my database table I created a column whose data type is Image. I have successfully inserted a image from PictureBox control in binary format in that table field. Now I would like to retrieve that image stored in binary format and would like to show this in …  |
| | Hi, I have got a serious problem. I have connect a table with the windows form. The table looks like Id name age place country 1 sss 11 ttt qqq 2 ww 12 eee qqq Now I'm able to display all of them in a richtextbox in the following format … |
 | hie if you could help me out i'll be forever grateful!! okay i am creating an ordering system but when i try to add a new customer it allos me to add but it doesnt save to the database and i can not also call it up the code i … |
| | I have a column structure in gridview account dept1 dept2 dept3 1 1 1 1 1 1 2 12 3 1 3 12 These rows are different records from database. I want to have account dept1 dept2 dept3 1 1 1 1 2 12 3 1 12 Is there a … |
| | [code] Private Sub btnLoad_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLoad.Click Dim sqlconnection As New SqlCeConnection("Data Source = \My Documents\NuttyCafe.sdf; Password = pass1234;") Dim sqlSelectTable As SqlCeCommand = sqlconnection.CreateCommand() sqlSelectTable.CommandText = "SELECT* FROM Product p inner join Category c on p.categoryID = c.categoryID where p.ProductTitle=@ProductTitle" Dim daResult As … |
| | [code] public partial class QuestionPage : System.Web.UI.Page { string scon = "Data Source=RBWORKSTATION2\\SQLEXPRESS;Initial Catalog=onlineexamdb;Integrated Security=True;MultipleActiveResultSets=true"; SqlDataAdapter da; SqlCommand cmd; DataSet ds; SqlConnection con; ArrayList myArrayList = new ArrayList(); public String ques, option1,option2,option3,option4; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { SqlConnection con = new SqlConnection(scon); con.Open(); da = … |
 | In an [URL="http://www.guardian.co.uk/technology/2010/jan/24/computer-security-crime-anonymous-datasets"]interview[/URL] with The Observer newspaper, Dr Ian Brown from the Oxford Internet Institute who is writing a report on anonymous datasets for the European Commission warns that "criminals could identify individuals through mobile phone data and use the information to track people's movements and find out when they … |
| | Hi, 1. How to print a report automatically through vb.net.For example if the print button is clicked the report has to automatically print, How can we do that?? 2. How to retieve the rows one by one when the parameter value is entered in the text box and the columns … |
| | Hello, I've got a problem with my project... in short I've got a mysql db bond through a DataSet and BindingSource - if I'm editing like a user the gridview then all changes are commited to the db no problem... But I need the user to responsibly change foreign keys … |
| | Hello friends! I've been playing around with the MS Chart class type (System.Windows.Forms.DataVisualization.Charting) and have a situation where I would like to know how to code a query of my data using LINQ. The data I'm playing with is the PowerBall drawings data that is updated each drawing: [URL="http://www.powerball.com/powerball/winnums-text.txt"]http://www.powerball.com/powerball/winnums-text.txt[/URL] I'm … |
| | im trying to add a new records to database access but when i click the button submit it say's Syntax error in INSERT INTO statement, OledbException was unhandled da.Update(ds, "MSHS") = syntax error INSERT INTO here's my code [CODE]Public Class StudentRegistrationForm Dim inc As Integer Dim con As New OleDb.OleDbConnection … |
| | hi this is my code protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { SqlConnection con = new SqlConnection(scon); con.Open(); da = new SqlDataAdapter("select Question,Option1,Option2,Option3,Option4 from QuestionData", con); ds = new DataSet(); da.Fill(ds); } } and this is `.aspx` <asp:FormView ID="FormView1" runat="server" DataSourceID="SqlDataSource1" Width="870px" AllowPaging="True" BorderColor="#999999" BorderStyle="Solid" CellPadding="3" ForeColor="Black" … |
 | hi, its very urgent for me, hi , i wants to show the label when status='C' and 'F' (selected from the database) here i want to show the label message as like "rooms 2 (status ='C' ) and 3 (status='F') are free" by using database conditions......... here iam using sqlserver … |
| | Hi, I am getting so much of problem on DataList This is my code in asp.net <asp:Button ID="NextQusButton" runat="server" onclick="NextQusButton_Click" Text=" Next " onclientclick="javascript: return validate()" Height="26px" /> </p> <p> <asp:DataList ID="ItemsList" runat="server" DataSourceID="SqlDataSource1" onitemcommand="ItemsList_ItemCommand" Visible="False"> <ItemTemplate> Question: <%#Container.ItemIndex %> <%# DataBinder.Eval(Container.DataItem, "Question")%> <br /> <asp:CheckBox ID="CheckBox1" runat="server" /> <%# … |
| | Hi I have a ASP.Net code below that need to query with MS SQL database. [code] "select SUM(ShopCartItem.Price-OfferedPrice) As Discount from ShopCartItem " & _ "Inner Join Product " & _ "On ShopCartItem.ProductID = Product.ProductID " & _ "Where(ShopCartItem.ShopCartID = @ShopCartID) And ShopCartItem.ProductID != @ProductID" [/code] The MS SQL query … |
 | Hello, I can pull 3 tables data into my program and read from all of them, i can update all 3 datasets but when it comes to updating the actual database i can only send the updates from the last dataset. [CODE] Imports System.Data Dim con As New OleDb.OleDbConnection Dim … |
| | Hello all, I am creating a project for myself to practice Database connectivity, updating, deleting and adding items. I am having an issue updating one of the tables i have added, within a table there is a column called Today's Date which will contain the date the last time the … |
| | My following question regards a problem I am having remembering python code. It has been about a year and a half since I last opened the shell or wrote any sort of code. I am attempting to rewrite the bullseye program that was seen in the Greater New York Programming … |
| | [code] SqlConnection con = new SqlConnection(scon); con.Open(); SqlDataAdapter da = new SqlDataAdapter("select Question,Option1,Option2,Option3,Option4 from QuestionData", con); DataSet ds = new DataSet(); da.Fill(ds); foreach (DataColumn dc in ds.Tables[0].Columns) { foreach (DataRow dr in ds.Tables[0].Rows) { Questionlable.Text = dr[0].ToString(); OptionList.Items[0].Text = dr[1].ToString(); OptionList.Items[1].Text = dr[2].ToString(); OptionList.Items[2].Text = dr[3].ToString(); OptionList.Items[3].Text = dr[4].ToString(); } … |
| | Hi, I want to set typed dataset in my appl. joining 2 database tables. I can define dataset as xyz.xsd no problem, I define the relations. So this is a fixed set that I can use. But what if I have to add additional conditions to filter the data within … |
| | I need help urgently for 3-tier coding in retrieving data from database and display it in label. It would be a great help if anyone solve it for me. thanks [B]I got the code for data access layer but im not sure if it's right:[/B] [code] Public Function getFeedbackQ(ByVal Question1 … |
| | So i need to add a supreport to the main report that i have and im not sure how to do that so i google it and im not getting it right can anyone help me here please :$ [CODE]Dim strConnection As String = "Server=OADMIN\SQLEXPRESS; Database=EHV2;uid=admin;Password=ehvgem" Dim Connection As New … |
| | Hi, I am currently doing an advanced search of a product. It is such varies into 3 categories: Product Title / Description, Price and Product Specifications I have called 3 datasets to check on each of these categories. Now, for reason, when I merge these 3 dataset [code] dsPrice.Merge(dsKeyword) 'Then … |
| | I have an Object, called boot. This boot contains two other objects - a headset and a shellset. Each headset and shellset contains 1 head and 1 shell respectively. My code is not working as expected....I really need some help on this one! Here is the code for my Head/HeadSet … |
| | Hi! When my login form is loaded, I wish to retrieve the list of usernames from the database login to a combo box on the login form. unfortunately I am stuck with this error messsage " syntax error in FROM clause". Below is my codes.. help me out please Thank …  |
| | how to convert from 'string' to 'System.Data.DataTable' I Have this code and my computer appear kode error I have put all the web site on the attach The best overloaded method match for 'System.Data.OleDb.OleDbDataAdapter.Fill(System.Data.DataTable, object)' has some invalid arguments cannot convert from 'string' to 'System.Data.DataTable' [code] using System; using System.Data; … |
| | Zdravím, mám jeden dotaz, jelikož na komponentu LV nejde použít wizard jako na DGW, chtěl bych se zeptat, jak postupovat při vypisování jednotlivých řádku z DataTable, viz kód: Hello, i have got one questions, because with ListView component i cannot use the Wizard, i would like to ask, how to … |
 | i have a problem when there is no data entered in the database and the data is entered for the first time. then it is giving an error even though the data is get saved. here is the code : [CODE] Protected Sub submit1_Click(ByVal sender As Object, ByVal e As … |
| | Hi, I need to write a program to send data from a particular excel sheet in a workbook to a notepad. Say,I've an xl sheet with the following columns: "Name,Age,Salary" with values "john,24,1000" respectievely,Now I need a C# program to read the xl sheet and write the values onto the … |
| | hi this is my coding if i run this coding. first time i able to get data then i click second time i got error Procedure or function "procedure name" display has too many arguments specified" why this error plz explain for me [code] Dim mydst As New DataSet MyConnection.ConnectionString … |
| | hi this is my coding when i run this coding for display the content in textboxes from the database by click event in datagrid. "Procedure or Function 'sp_developer_display' expects parameter '@developerid', which was not supplied." this error will display my sp in sql express is [code=text] ALTER PROCEDURE dbo.sp_developer_display ( … |
| | Hi. I would like to create those checked rows in gridview with a button click. For example, an user checks 2 rows in the gridview, and clicks on the create button. I would want the selected row/s to be created to the database. How would I go about doing this? … |
 | i've written this code, it works. whenever I click the OK button of the NewModel.vb, it will insert a new record, then the datasource of the datagridview will be reinstantiated and rebinded with all the records in the database. the datagridview will be rebinded with the records from the database. … |
| | i want to display the inserted row to my datagridview. how can i accomplish this? [CODE=vb] Imports System.Data.SqlClient Public Class Model Dim sqldata As SqlDataAdapter Dim modeldata As New DataSet Dim sqlquery As String Dim conn As New SqlConnection Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles … |
| | How do i connect to a database from c# with compact framework. (PDA) the database runs on the desktop. i use Pervasive on the destop. i want write directly on the desktop. is that possible, and how? |
| | Hi, I have a datagridview which displays customer orders. I have implemented a search panel with various options to narrow down the subset of orders by applying a string of filters to the bindingsource. I have also added an unbound checkbox column to allow the user to select/deselect orders along …  |
| | hi this is my coding when i run this coding for display "Procedure or Function 'sp_developer_display' expects parameter '@developerid', which was not supplied." this error will display my sp in sql express is ALTER PROCEDURE dbo.sp_developer_display ( @developerid int ) AS /* SET NOCOUNT ON */ select developercode,developername,qualification,dateofjoin,designation,experience,knownsoft from tst_m_developermaste …  |
| | Dear friends! Can anyone tell me how can I connect an additional data query I created inside the tableadapter (inside dataset-editor) to a combo box list? So I will actually see the data in list. I managed to create a query inside tableadapter, which only contains data from one column … |
| | I need some help... i am the beginner vb.net developer, so i need someone correct my coading to insert data from text field into database mssql... below is my coading; Protected Sub btnSimpan_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSimpan.Click Dim dtTemp As New DataSet Dim ddClass As … |
| | I have a dataset class in my Project, How do I export the tables in the dataset to PDF using ItextSharp Thanks |
The End.