2,634 Topics
 | |
| | We're using a lot of typed datasets in ASP.NET application, most of them have many tables+adapters and each table has some functions that call Oracle Stored Procedures. It works using System.Data.OracleClient. Our purpose is to make a migration to ODP.NET ( Oracle.DataAccess ). If i build a new typed dataset, … |
| | I m facing problem in Update operation,Select operation is completed. To Perform Update operation- 1)Add Class Products 2) Add a new method called UpdateProducts below is the Vb code,but i want to work with C# Code [code] Public Sub updateProducts(ByVal ProductID As Integer, _ ByVal ProductName As String, _ ByVal … |
| | Hi, I've tried to get the geolocation of the clients IP, with this code: [CODE=vb] Dim rssReq As System.Net.WebRequest = _ System.Net.WebRequest.Create("http://freegeoip.appspot.com/xml/" _ & vl_bContadorVisitasBE.vcConVisIP) 'Crear el Proxy Dim px As New System.Net.WebProxy("http://freegeoip.appspot.com/xml/" _ & vl_bContadorVisitasBE.vcConVisIP, True) 'Asignar el Proxy al objeto WebRequest rssReq.Proxy = px 'Establecer el tiempo de … |
| | hey,, i created one application in asp.net in vc# wich required the results of a stored procedure to be displayed into a datagridview.heres d code..,, SqlConnection mysql = new SqlConnection(@"Integrated Security=SSPI;Data Source=MANU\SQLEXPRESS;Initial Catalog=info;"); mysql.Open(); SqlCommand searchcmd = new SqlCommand("search", mysql); searchcmd.CommandType = CommandType.StoredProcedure; searchcmd.Parameters.Add(new SqlParameter("@sname", SqlDbType.VarChar, 20)); searchcmd.Parameters["@sname"].Value = textBox1.Text.ToString(); … |
| | I am an intermediate web designer and am working on my first backend page. I have a working editor and just need to add the ability to insert photos into the editor. I have dynamically displayed the images in a modal popup window and just need to add a click … |
| | [CODE]Hello everyone, I am write a program, which have to read an excel file and save it in an access table. The excel file will be upload. The data will be read and saved in an access table named smsbestand. Can anyone one help here is the code: extension = … |
| | this is products.vb code file [CODE]Imports Microsoft.VisualBasic Imports System.Data.SqlClient ' Use the unique namespace for this application Namespace Proj06Web ' ' Name the Class Public Class Products Function GetAllCategories() As SqlDataReader ' Get all products as return a dataset to the caller ' uses sp_Get_Products stored proc to return all … |
| | Hi all I am creating an app that utilises and MS Access back end and queries it quite a bit at various times. What I would like to do is bring in an entire table and then query the row(s) i want as I need them. This is what I … |
| | SOURCE CODE [code] <asp:Repeater ID="Repeater1" runat="server"> <HeaderTemplate> <table border="1" width="100%"> <tr bgcolor=Gray> <th>ProductId</th> <th>ProductName</th> <th>Description</th> <th>Weight</th> <th>isInStock</th> </tr> </HeaderTemplate> <ItemTemplate> <tr> <td width ="10%" height ="50%"><%# DataBinder.Eval(Container.DataItem,"ProdID") %></td> <td width ="10%" height ="50%"><asp:HyperLink id="hlEdit" runat="server" NavigateUrl="Frmuser.aspx" Text='<%# DataBinder.Eval(Container.DataItem, "ProdName") %>'></asp:HyperLink></td> <td width ="10%" height ="50%" ><%# DataBinder.Eval(Container.DataItem,"Descr") %></td> <td width … |
| | I need to convert this into PHP. I heard of ASP to PHP convert programs but they don't work they just append $ to a couple of places thats all. Since my other posts have remained unanswered I don't really expect replies from here either, but I a desperate. Could … |
| | Hi; I am new to VB.net and am developing a memory quiz. The quiz contains more than 100 questions imported from access 2002 db. For the learning process, I need to run the game again and again. At the moment, I can't randomize the question order, I am getting the … |
| | Hello, I am new to this forum and need a little help. I am taking an intro to Java Course and we are creating a project that reads in a set of user inputted numbers and stops when the user inputs any letter. From a textbook example they have the … |
| | First i'll explain my program a bit. Im writing a Windows based app. In the main form, i have a DataGridView which binded to a DataSet. When i double-click the RowHeader, a detailed view of the selected customer will pop-up. So i can make changes to the customer details, and …  |
| | Hello Guys I am trying create a DataGrid in Windows forms application, but i am unable to fill the data into that. I am using data sets and data adapters for that, but i am getting a empty datagrid. I am quite new to c# so can some body please …  |
| | This is not a homework problem & my first post in 2+ years. I just got asked to do this in C# based on my asp & DB experience & I am tearing my hair out as they want in done in one day & 2 MS videos say to … |
| | Very very new to visual basic.net (first day actually) but struggling already with the basics. I am attempting to create a single form application taking data from an existing MS Access database using SQL query. All works great, I can fill the dataset, seek, sort and display all my data … |
| | Getting error for the simple code Please help me out. Thank you[code]I have a textbox and one table. Once the user enters data in the textbox & click save button, the data gets saved to database. I've written following code but I'm getting following error. Please help me out. Thank … |
| | Hi; I need help woth random number generation. I am developing a game show which has more than 100 questions and for each question there are 4 options. I am using a random function which ranomizes the value of t (row value of database). But the problem is that I … |
| | Hello all. I am new to ASP.NET XML so I am looking for some guidance. I have an XML string that needs to read into an ASP.NET C# Gridview. The XML data actually comes from the CRM SDK crm web service (FetchXML). The XML Elements contain (dots) and attributes which … |
 | in my webapplication i create a dynamic datalist but it is not getting please help me this is my code thanku protected void btn_Click(object sender, EventArgs e) { DataList datlst = new DataList(); datlst.ID = "mydatalist"; da = new SqlDataAdapter("select emname from emp", con); ds = new DataSet(); da.Fill(ds, "emp"); … |
| | i created a form with 4 textbox tht user can insert their data and stored it in sql server 2000 databse..than i manage to display the data when user starting the program... i also create an update button for user to update their data... the problem is when i want …  |
| | I have a listbox and a datagrid. When the form is loaded the listbox is filled with a list of tables from a selected database (SQL 2008). [CODE] sqlstr = "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME" [/CODE] Then I have a SelectedIndexChanged that populates … |
| | I have to import data from excel to datagridview control & then to sql database. i tried to import from excel with below code but its showing err msg .. i couldnot understand where it goes wrong... can anyone help me for this.. if its ok or have any other …  |
| | Talking about a shoebox type of database here. Would like to make a nice interface in C# for it. Typically something around 50 records or so. (e.g. my wine cellar;) ) To use a genuine SQL DB seems to me like a bit of an overkill. Could use a flat … |
 | I dont know what im doing wrong, but the dataadapter, doesnt find the table im looking for: Public Shared Function DSet(ByVal ID As Integer, ByVal Name As String, ByVal Address As String, ByVal City As String, ByVal State As String, _ ByVal ZipCode As Integer, ByVal Phone As String) As … |
| | I'm trying to store or arrange three sets of two-dimensional data into three 2xN matrices that are stored as NumPy arrays. [CODE] 1. import os # for file handling functions 2. import numpy as np # for array/matrix processing 3. import matplotlib.pyplot as plt # for general plotting 4. from … |
| | hi all i need is the comments for this piece of code here it is: [code=vb.net] Private Sub populate() con = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _ System.Environment.CurrentDirectory.ToString() & "\DataBase.mdb") ' con.Open() dAdapt = New Data.OleDb.OleDbDataAdapter("select * from Watches", con) dSet = New DataSet dAdapt.Fill(dSet) dBind.DataSource = dSet dBind.DataMember = dSet.Tables(0).ToString() … |
| | Hi i have DataSet1.xsd item , i want to fill this DataSet1.xsd with the dataset ds which is developed in default.aspx.cs page. Later i want to bind the crystal report viewer with this dataset. Please specify url or tutorial links which have worked for u . Hoping to get some … |
| | [code=c#] I created a new crystalreport1.rpt , and also created a new DataSet1.xsd . For the crystalrepor1.rpt i have the given DataSet1.xsd as datasource . Now in the default.aspx i want to create a dataset of my requirement and assign that to dataset1.xsd and bind this to crystalreportviewer control which … |
| | Hi i want to get contact details from outlook and display that contact details in my datagrid view using csv file. My grid view display only few columns such as Name, Address, Email and category. In outlook i will add the contact details such as First Name, LastName, Business address … |
| | Hi, Can anybody give an example of adding columns to an already populated dataset/datatable and reflecting changes to an already populated datagridview so that I can modify/added the row and use dataadapter.update to change the datasource. Thanks snky |
 | There’s a serious amount of money to anyone who can prove that the answer is yes, and rather surprisingly it is online DVD rental service [URL="http://www.netflixprize.com/index"]Netflix[/URL] that is posing the question and providing the cash. It all revolves around the movie recommendation system that Netflix developed, CinematchSM, that can predict … |
| | Here's a summary of what I want my service to accomplish: 1. X number of applications send objects to my service via socket programming. This service deserializes these objects from each socket stream, and pools them in a list. 2. The application then acts as a relay to Y number … |
| | Hi, i have a user table in backend with many columns n from that i need to user the email id and password for login. I have read the data in my code using a data reader, but am not getting how to match the entered username and password by … |
| | Hello all, This will hopefully be a quick and easy answer. I am having some difficulties with multiple lists that have certain characteristics, so what do I have: 4 lists, all the same length that signify: [row] [coumn] [VAR1] [VAR2] So basically I have 2 variables at each location (row,col) … |
| | Hi, I populate a datagridview with ( select a,b,c from ....) so this is my datatable, but I have more column on the grid < d,e,f > and I edit those columns which are not defined in datatable ( d,e,f) and when I update a,b,c inserted but d,e,f are not. … |
| | I am writing a code in C# to read, add, delete and update a sql database row by row. Whenever I try to delete an entry, i get a "[COLOR="Red"]concurrency violation error: the DeleteCommand affected 0 of the expected 1 records.[/COLOR]". Please help me to solve that error and also … |
| | [code]' Add template and surname to database. Returns added template ID. Public Function AddTemplate(ByRef template As TTemplate) As Long Dim da As New OleDbDataAdapter("select * from Biodata", connection) Dim txtsurname As System.Windows.Forms.TextBox txtsurname = New System.Windows.Forms.TextBox() ' Create SQL command containing ? parameter for BLOB. da.InsertCommand = New OleDbCommand("INSERT INTO …  |
| | I have dropdown & Gridview on FrmSatelliteMain,In dropdown DataValueField uid is there,Now i want that as the user selects the value in dropdown ,on basis of uid i will fetch the records fromm DB & bind to Gridview using AJAX. Plz frnds dont tell me dat,dat do it using AJAX … |
| | How do i update a database from dataset. [code]SqlDataAdapter.Update()[/code] is not working |
| | I know how to fetch the records from DB,But i want to ask u just small thing. SQL TABLE [code] roll name marks 1 Ritu 10 2 Sneha 20 3 Ruchi 30 [/code] CODE BEHIND PAGE Default.aspx [code] protected void Page_Load(object sender, EventArgs e) { cmbRoll.Items.Add("--Select--"); cmbRoll.Items.Add("1"); cmbRoll.Items.Add("2"); cmbRoll.Items.Add("3"); cmbRoll.Attributes.Add("onChange", … |
| | I know how to fetch the records from DB,But i want to ask u just small thing. SQL TABLE [code] roll name marks 1 Ritu 10 2 Sneha 20 3 Ruchi 30 [/code] CODE BEHIND PAGE Default.aspx [code] protected void Page_Load(object sender, EventArgs e) { cmbRoll.Items.Add("--Select--"); cmbRoll.Items.Add("1"); cmbRoll.Items.Add("2"); cmbRoll.Items.Add("3"); cmbRoll.Attributes.Add("onChange", … |
| | I want to just bind the dropdown with DB,I have three rows in mine DB.Instead of adding the column data,In mine dropdown System.Data.DropDown is coming three times y So??? [code] using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; … |
| | I want to select multiple records from sql table and insert it to a dataset when the selected index is changed from a combo box. for example if i select "1" from the combo box then, only values with "1" in the sql table's mentioned column should be inserted into … |
 | hi friends,i am using dropdownlist in gridview.i am populating it using [code] Dim dsUserRoles As DataSet = objUser.GetRoles() CType(gvUsers.Rows(gvUsers.EditIndex).FindControl("ddlRoleName"), _ DropDownList).DataSource = dsUserRoles CType(gvUsers.Rows(gvUsers.EditIndex).FindControl("ddlRoleName"), DropDownList).DataTextField = "RoleName" CType(gvUsers.Rows(gvUsers.EditIndex).FindControl("ddlRoleName"), DropDownList).DataValueField = "RoleId" CType(gvUsers.Rows(gvUsers.EditIndex).FindControl("ddlRoleName"), DropDownList).DataBind()[/code] but when iam runnig if had some no.of.cols and when i click on editlink dropdownlist is replacing … |
| | Hi , I'm confused on dataset/datatable updating to datasource. According to one view, mass updating of datasource with datatable.rowstatechanges thru dataadapter is not professional and not to be used in real production environment. On the other hand, a lot of sources in internet and else talks about how to use … |
| | Please help me with this question. That's multiple choice questions. Which of the following are true about using ADO.NET DataSets and DataTables? 1) The connection to the database must remain valid for the life of the data objects. 2) All tables in a dataset must come from the same database. … |
 | hi there could you please help it's agent, i'm doing search button my code gives me this erro 'CurrentPageIndex' is not a member of 'System.Web.UI.WebControls.GridView'. here is my code [code] Private Sub txtSearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles txtSearch.Click BindData() End Sub Private Sub BindData() Dim connection … |
| | Hi, I have database connection problem. A part of the source is shown Below [code=csharp] private void Form3_Load(object sender, EventArgs e) { string connectionstring="Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\hospdb.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"; SqlConnection con=new SqlConnection(connectionstring); DataSet ds=new DataSet(); string command="SELECT Name,Address,Phone,Branch,Class FROM hosptab WHERE (Branch = 'SKIN')"; SqlDataAdapter da=new SqlDataAdapter(command,con); da.Fill(ds,"hospital"); DataTable dt=ds.Tables["hospital"]; //da.Fill(hospdbDataSet, … |
| | Hi expert, i facing a problem when i try to connect to database by using vb.net below is my code: Imports System.Data Imports System.Data.OleDb Public Class Form1 Dim dSet As New DataSet Dim da As OleDb.OleDbDataAdapter Private Sub btnLogin_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLogin.Click Dim User, … |
The End.