2,634 Topics
 | |
| | i have a database table containing: SEG,AMK,101427Y,EG3902,EG3902-G1 SEG,AMK,101427Y,EGS650,EGS650-G1 SEG,AMK,103852S,EG3901,EG3901-G1 SEG,AMK,103852S,EG3904,EG3904-G1 SEG,AMK,103852S,EGS104,EGS104-G1 SEG,AMK,103852S,EGS650,EGS650-G1 SEG,AMK,106581C,EG3901,EG3901-G1 SEG,AMK,106581C,EG3902,EG3902-G1 SEG,AMK,111713M,EG3901,EG3901-G1 SEG,AMK,111713M,EG3902,EG3902-G1 another table containing: 1 SEG-AMK EG1832 Mechanics and Materials 286 1.5 EG1832 2 SEG-AMK EG1833 Electrical Principles 375 1.5 EG1833 EG1952 EG1903 3 SEG-AMK EG1835.1 Engineering Mathematics (1) 456 1.5 EG1835 EG1001 4 SEG-AMK … |
| | So I must build an app that has to do with mail address management and more. Let's say the user has an excel file with 2 millions of rows (email addresses). I made it the oledb way and the first mistake I made was putting ~500k rows in a datagridview, … |
 | hi all, Im working with a asp.net c# application and using sql server, as my database and using stored procedures. And i've to generate dynamic check box and button's.which is users can click the checkbox and when user can submit at the time i have to get checked checkbox values … |
| | I'm Developing application using ASP.NET and VB.NET. It is used Ajax controls as well. I added dropdownlist (Standard controller) and databind to it. It is working well. But if i added Ajax combo box, it is not working. (It means data not filling to combobox) No any errors showing. This … |
| | > I have 1 form whose columns are slno,type,shape and another form where i want to retrive data from database using combo box. if i select slno from combo box in form2,then rest of the fields should display in other textbox in form2. Dim cn As New SqlConnection("Data Source=.\INSTANCE;initial catalog=record;user=sa;password=gariahat") …  |
| | Hi all, i am developing web application in asp.net backend MS-Sql.<br/> i have to retrieve a particular table values for example table name "costomer" and its fields are "c_id,c_name,c_contactno" like that and when i retrieve this values, it should be bind the checkbox for UI. now i've code for generate … |
| | Dear Members, I am developing automatic image id creator using vs2008.Using excel file,folder images for image.Below is my code.I want all images to be place and printed seperately acording to the dtabase fetche from excel.Kindly help please. Regards JR Imports System Imports System.ComponentModel Imports System.Drawing Imports System.IO Imports System.Runtime.CompilerServices Imports … |
| | Hi guys, I am developing a software that has to transform a dataset in a graph database. So far I have developed the dataset import. Basically, I open the file and afterward it is displayed in the tab1 and stored in a matrix of Objects. Now I don't have any …  |
| | Im developing application using ASP.net + VB.net Now i want to change column width at run time. But in run time it doesn't work. This is what i did up to now. data bind in form load like this. myGrid.datasource = myDataSet.table(0) myGrid.databind() In here dataset come properly. in grid … |
 | I have 2 functions, one of which works and one of which doesn't. I do not understand this, because the only difference is that the second function puts in just the name of the variable, where the 1st function puts in the value. There is only one line to build … |
| | Hi all, Im working on a web application in which I need to show data from MySQL on page scroll. Ive found a reference online, below is the code. I want to customize this and show my data in ASP:GridView ASPX page <form id="form1" runat="server"> <div> <h1> Demo page: Load … |
| | so im trying to get a gridview to work! im doing it mannualy `Inline Code Example Here` abre_ligacao() Dim sqlqtz As String = "SELECT * FROM cobranca ORDER BY cobranca" 'MsgBox(sqlatendimento) Dim dsqtz As DataSet = GetData(sqlqtz) If (dsqtz.Tables.Count > 0) Then GridView1.DataSource = dsqtz GridView1.DataBind() Else MsgBox("Não há dados …  |
 | I have the code below in VS 2012. It dynamically allocates a DataGridView and an Update button, then it binds the grid to MS Access database table. That all works well. When I click the Update button btnUpdate_Click() is called, which calls the DataAdapter's Update() method. That produces the syntax … |
 | this is code i use to call in a record using a textbox and a button Dim SearchProduct As String = txtBC.Text Dim con As OleDbConnection = New OleDbConnection("Provider = Microsoft.Jet.OLEDB.4.0;" & _ "Data Source = '" & Application.StartupPath & "\POS.mdb'") ' Use wildcard' Dim cmd As OleDbCommand = New …  |
 | The program can run , but after i insert the user detail and go to refresh the dataTable i get this error msg "This database cannot be imported " Imports System.Data Imports System.Data.SqlClient Public Class frmMain Dim con As SqlConnection Dim cmd As SqlCommand Dim adapter As SqlDataAdapter Private Sub … |
| | I need help on a program I am currently creating as all I am trying to do is read all the cells in the datagrid to see if there are any null values and then display a message. I have racked my head around this for ages and I just …  |
| | I have been trying to get my database insert and delete to work for a long time now, and I still cant get it working. I now have just 2 hours left before I absolutely have to have it finished and I can only insert numeric values. I suspect im … |
| | I have no idea why the program isnt working, its practically the same code I used in the last project so why wont the database update? The code for the program is as follows: 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; … |
| | I need a voice of experience. I am working on a project for school. My project is a small B&M store. I am coding in VB .net I have an Access database with 3 tables - Inventory, SoldInventory and Sales. I need to create a simple POS. I would like … |
 | Hello everyone I'm using VB.Net and I have a database contains two tables "Personne" and "PersonneCopy" ( Same schema as Personne [4 columns = N°, FirstName, LastName, B_Day]) I load the first table in a Datagridview all it's fine with that, here's the code: Dim Connection As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data … |
| | Dear All I have 7 columns of yes/no data type I want to show them in datagridview in checkbox form. I have written this code where I am showing some values from database to datagridview with a column having check box. I just want to show databse value in Under … |
| | Seems like this should be simple. I am binding comboboxes successfully to my Access DB. It looks like this: Dim da As New OleDbDataAdapter(asql, con) Dim ds As New DataSet da.Fill(ds) cboEmployeeNumber.ValueMember = "ID" cboEmployeeNumber.DataSource = ds.Tables(0) cboEmployeeNumber.SelectedIndex = 0 Works great. Then I try to bind a text box …  |
 | When I use the insert function I can see new data at the front end. But I cannot see the new data in Access. Other times when I close the application and restart, new recorded is not there. If I look in Access application and closed it then open VS2010 …  |
| | i have create windows application using 2007 Access database and i have this code : if (!UserNameTextBox.Text.Trim().Equals("")) { errorProvider1.Clear(); if (!PasswordTextBox.Text.Trim().Equals("")) { errorProvider2.Clear(); if (!RePasswordTextBox.Text.Trim().Equals("")) { errorProvider3.Clear(); OleDbConnection conn = new OleDbConnection(System.Configuration.ConfigurationManager.ConnectionStrings["Lands.Properties.Settings.LandsConnectionString"].ConnectionString); try { conn.Open(); this.usersTableAdapter1.FillUser(landsDataSet.Users, UserNameTextBox.Text.Trim()); if (landsDataSet.Users.Rows.Count > 0) { errorProvider1.SetError(UserNameTextBox, "إسم المستخدم المدخل مستعمل من قبل الرجاء … |
| | I added a DataBase.accdb file into a project (VS 2010) then created a DataSet. but now I've a small problem: I want to have the connection string in the app.config file, to allow customer to edit it. I go to the app.config file and find no connection string created inside. … |
| | Hello, I'm trying to program a basic program at the moment and have run into some difficulties. I have a method as follows: public static void loadDB() { // load data into datasets - this will be called on form2 the login screen loadTblStaff(); loadTblCars(); } the method is called … |
| | I have been struggling with this since yesterday and I really need to get it finished. I have no clue why its not working. THe porblem im facing at the moment is as follows: I have a method loadDB(); That is looks like this: public static void loadDB() { // … |
| | I'm trying to visualize how this will be set up... I need my VB.NET application to read year 2013 values (Year, Employee, and Annual Performance Score) from a CSV file and write them to an Access DB. This DB is linked to my VB.NET project using a dataset. No problem, … |
| | I got this error from another computer, without visual studio. See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.NullReferenceException: Object reference not set to an instance of an object. at PAMS_Upload.frmMain.Validate_OtherDimensions() at PAMS_Upload.frmMain.btnLoadOther_Click(Object sender, EventArgs e) … |
 | Hi All, I sort of want to get a "best practices" perspective regarding numeric values. First, I'll give my scenario: In my SSIS package, a CSV file is used for data extraction. Once extracted, a staging table is loaded with all the values from the CSV. One column, called "IPI_Value" … |
| | Work has informed me that I need to run reports a certain way. I need to pull data out of the system database, and compile a report. I have a database with 3 tables. Personel (contains employee data), Q1 (1st quarter data) and Q2 (second quarter data). I'm trying to … |
 | Dear Expert, Please find below coding as I have a problem in data update as there is no error found but when i update the table it update the table in right table and then it return some thing wrong while returning the records. Kindly help me in this matter. … |
| | Hello Everybody How can store name of dynamically created checkbox in a String array when I don't know how many checkbox will user select at runtime. Say I have 10 dynamic checkboxes and out of 10 user select 6 checkboxes randomly now how can get the name of those selected … |
| | Dear All I am trying to create groupbox dynamically and these GB will create on selection on checkbox. Means I have 5 check boxes now if I select 1st CB then 1 GB with some other dynamic checkbox shall be created, if I select 3rd check then another GB shall … |
| | I have a access database from where I am populating the datagridview on button click event. but what I exactly I want to add record of access database in datagridview when button is clicked. Means on 1st click 1 record should be add in datagridview, on 2nd click another record …  |
| | Hello I am making a win form application on frame work 3.5 using C#. I am creating dynamic checkboxes depending on the numbers of records in access table. After this I am also able to get the name, text and other properties of dynamically created checkboxes and I am displaying … |
| | i am a newbie to C# and ASP.Net programming, i have created a database which has 6 tables connected to each other by foreign keys. my problem is how do i insert data into all the tables at once considering the foreign keys they have. i just need a sample … |
| | Imports System.Data.OleDb Public Class Form3 Dim cmd As New OleDbCommand Dim rdr As OleDbDataReader Dim strmsg As String Dim db As New mydb1 Dim da As New OleDbDataAdapter Dim dset As New DataSet Private Sub Form3_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load db.dbconnection() strmsg = "select Class …  |
 | I need to create dataset in my module.If i retrieve the database (Huge amount of data are there),It takes too much time to load..Is it possible to resolve this issue.. |
| | hi all i am creating web site accidently i am facing one bug like i didn see pagging on grid after doing same thing on another form it works perfect Please look into my pronlem i am posting my Code here Please Help ASAP Thanks In advance This is my … |
| | -1 down vote favorite I have done this condition to control if the elements of the row of the slq table are equal with the elements of the row of mysql table after this if the condition is true I have to overwrite the elements of the mysql table. Please … |
 | Good day, I am having trouble with the excel file that i was uploaded.. after i uploaded the excel file i want to validate each header and each datatype of it. just to make sure that my dbase has integrity.let say i have 10 columns. Is there a way on … |
 | hi guys, wondered if anyone could help please, i have populated my combobox with the names i want, but im at a total loss on how to populate the textboxes based on my selection im guessing its got something to do with combobox_selectedIndexChanged but i dont know how to do …  |
 | Hi I have a dataset created programatically and I want to use this dataset to bind it to Microsoft ReportViewer. I tried the Microsoft ReportViewer with DataSet created at design time and it works well. I have searched a lot and this is the best thing I can find but … |
 | Its a Requiredment, i have a asmx service that returns a list<dataset> and the schema defination keeps on repeating foreach dataset in the List. How can i prevent. Thanks |
 | Hi All, I have two datasets, myds.Tables(0) and UmbrellaFromExcelDataSet.CancelTemplate . I've updated the UmbrellaFromExcelDataSet.CancelTemplate using data from myds.Tables(0) and now I want to put that data update into the database that it orignally came from. The database isn't updating though. My code is as follows: Me.UmbrellaFromExcelDataSet.CancelTemplate.AcceptChanges() Dim csvRow As DataRow … |
| | Hello there, I face this error message when I try to save a new record in Table: viruses_analysis, I would like to use the same way in the code below, but where is the error? please be informed that I used the same way in other applications and worked very … |
| | Hi All, I've tried the following to format my date in 'dd/mm/yyyy' instead of 'dd/mm/yyy hh:mm:ss' when importing data from csv to DataSet. CONVERT(VARCHAR(10), [dateColumnName], 103) AS [DD/MM/YYYY] and CONVERT(DATETIME, [dateColumnName], 101) AS [DD/MM/YYYY] Both give me the error: Undefined function 'CONVERT' in expression What would be the correct method … |
| | Hi all, I'm trying to bring up a table of data using a select query to create a DataSet that I'm displaying in a datagrid. When I use SELECT * FROM myTable it works fine, but when I only want the specific columns SELECT URN, 'CanX Reason', 'Date to take … |
| | hi, i have agridview in desktop application, i fill it with data using dataset, how can i chose arow from gridview and make right click on that cell then do search for that info i chosed from gridview? Best Regards, IT_Techno |
The End.