2,634 Topics
 | |
| | hi all, i am in trouble to solve this. i want to show the report in the manner in which the tablix column 1 record should continue in the same page in column 2. LIKE THIS: column1 column 2 1 6 2 7 3 8 4 9 5 10 and … |
| | Hi guys about my previous post on [Copy Selected rows from Datagrid to another](http://www.daniweb.com/software-development/vbnet/threads/471088/copy-selected-rows-from-datagrid-to-another) that was answered by oussama_1 and Deep Modi, I was wodering if is it possible to detect that there is a similar row between the 2 Datarids to avoid redundancy? Does it require a datatable or …  |
| | hello i have an error while am trying to retrieve data from a tb in data base using Stored Procedure any help please? this is my web.config <?xml version="1.0"?> <!-- For more information on how to configure your ASP.NET application, please visit http://go.microsoft.com/fwlink/?LinkId=169433 --> <configuration> <connectionStrings> <clear/> <add name="myConnectionString" connectionString=" … |
| | Hi I am using vs2008 Professional. Some columns of my dataset are presented in a matrix correctly. However,there is another dataset column I need to add. How can I insert a new column which is not an aggregate column to the right Thanks |
| | Hi guys how do I sort out this error = "object reference not set to an instance of an object" try { String connection = "Data Source=(LocalDB)\\v11.0;AttachDbFilename=C:\\Users...."; SqlConnection conn = new SqlConnection(connection); SqlCommand db = new SqlCommand("select * from Tbl", conn); SqlCommandBuilder builder = new SqlCommandBuilder(da); ds = new DataSet(); … |
| | Hello all, I am having an issue learning some things in visual studio 2013 asp.net using vb. I am following a fellows instruction on doing a report with a parameter. In this part of the code: Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click Protected Sub Button1_Click(sender As …  |
| | an i ask for help? what is wrong with my codes thanks in advance Sub show1() Dim DReader As MySqlDataReader SqlCmd = New MySqlCommand("SELECT * FROM book WHERE accesion_num = '" & b_id & "' ", SqlCon) DReader = SqlCmd.ExecuteReader While DReader.Read accnum.Text = DReader.Item(0) isbn.Text = DReader.Item(1) txteditbooktittle.Text = … |
 | hi I have filled my datasetfrom my sql db then used that data to show at crystal report, when i go back again to fill it with another data it show to me the old one why ? how can i solve this problem ?? Best Regards |
| | Hi Everyone, I really require your assistance on the issue. I was debugging my code [C# console application] and i step down to the place where there is DATASET in my code and i clicked on the magnifying glass to see the data inside the DATASET. after clicking on the …  |
| | I want to fill GridView ,But i dont want to use datasource..I want to use the method,thru which i add the data using row by row As in VB.net [code] Dim row0 As String() = {"A","B","C"}; Me.DataGridFile.Rows.Add(row0) [/code]. [code] public partial class refresh : System.Web.UI.Page { string query; SqlCommand cmd; … |
| | Hi I have a page for users to edit their details, I've used the following code to prefill the form. protected void loadData() { OleDbConnection conn = new OleDbConnection(); conn.ConnectionString = ConfigurationManager.ConnectionStrings["ProjectDatabaseConnectionString"].ConnectionString; conn.Open(); DataTable dt = new DataTable(); DataSet ds = new DataSet(); ds.Tables.Add(dt); OleDbDataAdapter da = new OleDbDataAdapter("SELECT * …  |
 | Hi I've run this code and i get no errors but my form data is not saved on the dataset or database. This is the click event code. [code] Dim conn As New SqlConnection("Data Source=.\SQLEXPRESS; AttachDbFilename=|DataDictionary|\TMSDB.mdf;Integrated Security=True Instance=True") Dim ds As New DataSet conn.Open() Dim Adp As New SqlDataAdapter("select * … |
| | Greetings, Can someone please tell me on how to use this class? Public Function GetDataFromStoredProcedure(ByVal spName As String) As DataTable Dim ds As New SqlDataAdapter Dim dt As New DataTable Dim cmd As New SqlCommand Dim con As New SqlConnection(_connectionString) Try _success = True con.Open() cmd.CommandType = CommandType.StoredProcedure cmd.CommandText = … |
| | Development Environment used: 1.Microsoft Visual Studio 2010 2. Programming Language: C# 3. Database MySql I am trying to use BCrypt class by Derek Slager for creating and authenticating username and password. A form is use to create new user to save Username and Password to database, but this Password is … |
| | I would like to do is to read CSV file begin to display to datagridview. show all the rows in the CSV but only the columns between START and END. This code below is for import all data from csv to datagridview. If OpenFileDialog1.ShowDialog(Me) = DialogResult.OK Then Try Dim fi …  |
| | Hi, im developing a software in vb 2012 with a access 2010 local db, but for some reason i can´t remove records from the database. the following code breaks on line 6. i cant find the problem. the dataset is transmissoes and the the table is utilizador_avancado. can anyone help, …  |
 | hi, I have a Gridview like below:  What I want is: 1) User can click at **LINE** column, for example user click at **M23** and it will redirect to other page. 2) At the other page, it will display something like this: **Please insert countermeasure for M23** where … |
 | I want to print data from XML in readable formate which is the last section of XML file .My code writes data from database to XML file . Here is a code i use to write XML Note: myread is a dll containing dataset,data adapter and connection string. ds As … |
| | Hi guys. I need help in copying selected row from DataGrid to another. What I want is if I click a row it will be copied to another DataGrid. I set my DataGrid Selection Mode to FullRowSelect. Is it possible for me to update my database using the copied rows. … |
| | Recieving the error "Dynamic SQL generation is not supported against multiple base tables." When pressing the save button Code for Save button: private void btnSave_Click(object sender, EventArgs e) { DataGridQuestions.EndEdit(); adapter.Update(ds, "Questions"); MessageBox.Show("Updated"); DataBind(); } Code for filling data adapter private void DataBind() { string connectionString = ("Data Source=" + … |
| | Hi all, I was going through a lot of resources on how to populate a dataset.And i kind of got an error when trying to populate the created dataset with 4 select statements. but my sql uses the where clause,the other statements i saw select certain columns and go to …  |
| | Hi, I have a problem with changing the password from Microsoft Access Database. I get an Error "[B]No data exists for the row/column[/B]". The password in the database is encrypted and when I change the password it should be decrypting the password and new password should be updated with encryption … |
| | Hi guys. I'm having problems in updating records in Excel. Whenever I update a cell the value I input it goes 4 cells above the intended cell and I know the reason. In my Select query: `SELECT * FROM [Sheet1$A5:R1048576] where [ITEM CODE] is not null` Meaning I skipped reading … |
| | Hi I am a fresher to VB and now stuck with a code for my project. Project Description : I have a .xlsx Excel File which has two Coulmns "Key" and "Summary", I have populated combobox on the form using DataSet as shown below : Dim dt As New System.Data.DataTable() … |
| | Hello. I meed some help with this. I am trying to delete a record from database(SQL Server) Am i missing something? Private Sub cmdDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdDelete.Click _DataSet.Tables(0).Rows(CInt(txtCurrent.Text) - 1).Delete() ' tho, it can remove the deleted rows ' we cannot call the DataSet.AcceptChanges …  |
| | Hello everyone. I would like to ask for your help, I've been stuck in this problem for wholde day. every time I run this code it gives me an error of "The report has no tables" even though I have a dataset. my dataset is datatable that came from the … |
| | This is an example of Inserting and Retrieving data from xml file. [code]private void Page_Load(object sender, System.EventArgs e) { // Put user code to initialize the page here if(!IsPostBack) { BindGrid(); } } private void BindGrid() { ds = new DataSet(); try { ds.ReadXml(@"c:\inetpub\wwwroot\WebApplication10\XMLFile1.xml"); DataGrid1.DataSource = ds; DataGrid1.DataBind(); } catch(Exception … |
| | Hello can anybody send me sample project in VB.NET to ADD,EDIT, DELETE the Customer details....or any similar project for beginners.... just want to learn how to ADD, EDIT, DELETE DATA in the table using DATASET, DATA ADAPTER, DATAROW etc. Please send me the project. Thanks in advance |
| | 1)On receipt of the signed MSA back from the customer, the original should be sent to the legal representative and a controlled copy should be sent to the TM/Account Manager by ___________. B D M DM 2)Runtime Profiling is used by which category of users? Developers and System Administrators Configuration …  |
| | i am using employee table to test if i am doing the whole program correct. I have 5 buttons. one is to add records and another to save(commit), to update, to delete and to clear. I am having trouble with the code to save the record to the data set. …  |
| | hello all, its a very deficult situation for me, bcoz i am not expert thats way taking help from u all. problum : i m creating a project for commission calculation type in the form i have one combobox which is filled by ms access database containing parent ID. these … |
 | Hi, I am selecting value from one combobox and want to use its value to update the second combobox. but the error is that the second combobox is not showing any value. plz help me. namespace ShopSoftware { public partial class frmSelling : Form { public frmSelling() { InitializeComponent(); } …  |
| | Hi again I want to display my table in excel to my datagrid. I want select the 5th row of my spreadsheet as the column header. I have no problems of displaying it in DGV when my column header is at the first row. Now I need to have my … |
| | how to can i insert data in another table without using wizard dataset and i have a variable that date and time that can be used on date time picker please help can anyone simplyfy the code?  |
| | Hi, I'm a beginner in Vb.net. I have a problem like this. My table name in dtabase is *tblsales*  and i have 4 combobox in month and year  i need to find data between this 4 combobox. And this is the code i've tried before. For … |
 | Well Hello daniweb, I want to point out that I am barely beginning to learn VB.net for my A-Level Computing Course. So, I was asked to make a Currency Conversion Program and make it have a Transaction Log that is automatically updated when the user makes a conversion. I chose … |
| | hi I am trying to save multiple images into one ID and I am getting no where ...I am posting the code so for storing and retrieving image (one image)...but need to store more than one ....need some help here ... using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using … |
| | I have added a access database to my project and created the connection, dataset and all via the wizard. But when I run the program I encounter error > An unhandled exception of type 'System.TypeInitializationException' occurred in System.Data.dll > Additional information: The type initializer for '<Module>' threw an exception. From …  |
| | Thank you all for helping me in completing my collage mini-project //form1 using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; using System.IO; using Microsoft.Office.Interop.Excel; using ClosedXML.Excel; namespace merge_excel { public partial class Form1 : Form { public Form1() { InitializeComponent(); … |
 | i successfully designed and filled my Crystal report via code not via wizard. i added Crystal report via addNEWITEM i added dataset in aap_code via addNEWITEM i added datatable into dataset via addNEWITEM Via code i made report and filled dataset and table with data Run and display. Successfully done. … |
| | it's confusing, see: 1. I added a dataset in app_code folder and then added a dummy datatable (field names similar to one in database), so it is visible to Crystal report in ADO.net datasets list. 2. Dragged all field names from Datatable to Crystal report. 3. Now as i added … |
 | In my project, at some point I tend to load all rows in my DataSet and add them to my FlowLayoutPanel in order of their "Time" Item. This is what I'm trying to do but I need the controls to be added first if their "Time" value are the oldest … |
| | I have query that updates the database but the problem was the datagrid is not updating.. i have to restart the program in order for the datagridview to take effect Imports System.Data.OleDb Public Class frmUsers Dim cnn3 = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\Renz\Documents\Visual Studio 2012\FINAL\Database\AuditDB.mdb;") Dim sql2 As String Dim ds1 As … |
| | Hi I need help in making an auto complete feature in my datagridview where if I input a certain cell it will automatically have a value or it will have a autocomplete suggestion (like a textbox link to a table) based on my other table. I don't have any clues … |
 | Hello, I have created a report using SAP Crystal Report on Visual Studio 2010. As datasource, a interal dataset is used to populate the report which is included in my project. Everything seems to work fine until during runtime when I load the report onto the report viewer, it keep … |
| | Im puzzled, the thing is, i have a software that was running ok, with a connection of to access 2010 db. A rotine to add a customer, to the database that was already coded, started to fail. saing that the insert method of the tableadapter was not avalaible. the tableadapter … |
| | Hi, i need some help if possible. I designed a software on vb 2012 with a local access 2010 database, it runs ok,it add's delete and changes record's. However when i start the software it deletes the added records on the previous session. the software is designed with the dataset's. … |
| | i am trying to create and fill crystal report via code but an error occurred, REPORT HAS NO TABLES but when i try to extract data from DATASET then it shows exact data,no problem but doesn't work for Crystal report. CODE: protected void Dataset_load() { SqlConnection sqlcon = new SqlConnection(conStr); … |
| | I am having a problem getting this code to work in deleting records from a database. The path to the database is correct and I have another couple of event handlers that work fine using this same datbase so I know that the path to the Db is good. Any … |
| | I' sorry but i need some help, i cant find the error. I want to add a new record to the database (access 2010), but although the dataset is updated, the added information does not save do DB. THe code bellow is the code that i run when press the … |
The End.