2,634 Topics
 | |
 | Below i write the coding which is not working properly yo me.I want to open excel file and use select statement with where clause.But one I run the coding it give me exception it says "No Value give for one or more parameters" Pls help me. [ICODE] Excel.Workbook theWorkbook = … |
| | I m writting a project i want to save finger print image in sqlserver but io.filemode.open is error occured, how can i solve for this, help me '///////////////coding [code=vbnet] Dim sqlConn As New SqlClient.SqlConnection(ConnectionString) sqlConn.Open() Dim sqlComm As New SqlClient.SqlCommand("SELECT * From InkPaperData", sqlConn) Dim SaveAdapter As SqlClient.SqlDataAdapter '(" Select … |
| | hello frds, I have write table in xml file and want to execute query from xml direclty. how I perform. My way is --- first I write two table "ftable" and "stable" in xml as "ftable.xml" and "stable.xml" then create query as " Select id,name from ftable UNION Select sid, … |
| | Here i am attatching the source code and the excel file. When i use this code it generates the error , "The external table is not in correct format'. Code: [code=asp.net] private string StrConn = ""; OleDbDataAdapter da; DataSet ds = new DataSet(); StrConn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath + … |
| | Hi guys! Long time no see! I'm trying to get a datagrid to work, but although when I run it there is no error, nothing appears on the datagrid. Yet, there seems nothing wrong with my code: [code=VB.NET] SQL = "select * from upload " & _ "where field003 like … |
| | hi frds, I want to write a table in xml file by datareader directly. but I dont know how i write directly. I don't want to use dataset b'coz my table ir very large. And dataset is slower then datareader. So provide help. thank you |
| | hi folks.. In my application am storing some textbox values to a datatable inside a dataset.Now I want to save the multiple rows of datatable to my sqltable..ll anybody plz help me.. with thanks and regards. jithesh.P.  |
| | I don't have a problem reading in one big array of numbers from a file. I can't figure out how to read in multiple arrays that are delimited by certain characters. For example, my dataset has the following format. #BEGIN 1 1 .1 .2 2 .8 .3 3 .9 .5 …  |
| | I m useing this below Cods, But its not working ..... Private Sub btnadd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnadd.Click Dim con As System.Data.SqlClient.SqlConnection Dim cmd As New System.Data.SqlClient.SqlCommand Dim cmdd As New System.Data.SqlClient.SqlCommand Dim da As New System.Data.SqlClient.SqlDataAdapter Dim ds As New DataSet Dim dt As … |
| | Hi All, First, let me say that -daniweb- has been a great help for me as I've gotten back into programming over the last 6 months (after a 10 year respite). I've put together some decent code, but Python finally has me stumped. I have some code that generates some … |
| | There is a big problem for me as I have to handle a project made by an other person and I m not aware of this code.I have two tables in SQL Server 2005 named AudioFileDetails having fields---- FileId int 4, FileName varchar 1000, Subject varchar 500, DistrictId smallint 2 … |
| | Hi Guys I write this problem in under ASP category,but i didnt have any reply,anywya i think coz anyone cant uderstand what iam saying,but today I found that kind of request in another forum.So i write copy it into here. My problem and this one also same .Please help me … |
| | Hello to everyone! I'm developing a C# application that manages an Access database. In order to perform a word search within the database registers, I have used a SQL command based on the 'LIKE' condition. I attach the complete code below: [code] myConnection.Open(); OleDbDataAdapter adapt_pregunta = new OleDbDataAdapter(); string query_c … |
| | Hello to everyone! I'm developing a C# application that manages an Access database. In order to perform a word search within the database registers, I have used a SQL command based on the 'LIKE' condition. I attach the complete code below: [code] myConnection.Open(); OleDbDataAdapter adapt_pregunta = new OleDbDataAdapter(); string query_c … |
| | I have a text file say log file. i have to extract all the characters between "<" sign and ">" sign. i.e. between <> and put it into the database and log file is of kind Sun, 24 Jun 2007 21:49:49 GMT: Received request </abc/abc.gif>, from <111.1.11.11>:<1111> at domain <localhost/abc.net> … |
| | HI I am developing web site in ASP.net and crystal reports,this is first time i using asp.net and crystal reports.Still ia writing test coing to do this.i mention what is problem is.what i did is first I created crystal report viewer and crystal report.After I drag crystal report i select … |
| | I am a Python newbie! I'm trying to list the feature classes in a dataset (Access .MDB) and then list the fields in each feature class. I'm able to list the feature classes and I'm able to list the fields in a particular feature class if I name it specifically. … |
| | Dear Friends I have a Query. I have a Stored Procedure Which takes an Input parameter . I want to fill Dataset with table based on the same input parameter.I have already used it with data reader . But with Data Adaptor and Data Set its not properly working .The … |
| | I have the code for transferring data from the datagridview to the excel spreadhseet.. my datagridview has colored data in it and I want the excel spreadsheet also to have the colored data. i get the error "property access must assign to the property or use its value vb.net error" … |
| | I am trying to open an excel spreadsheet using vb.net. The data has to be fetched from a datagridview.. the datagridview has colored data in it and i want it to appear colored on excel spreadsheet too.. How do i get it colored ? [CODE] Private Sub Button4_Click(ByVal sender As … |
| | Hi I have 4 comboboxes..and any value that I choose.. I get a whole set of fields displayed in my datagrid view.. I want to make a difference..the value that I choose in the combobox, has to appear green in color in my datagridview. How do I do this ? …  |
| | Hi fellows, I have learned to create stored procedures,but dont know on how to implement it in my code...I have a dataadapter called ada and a dataset ds..The form consists of three textboxes and a combobox...I need the valuse from the database to the comboox...How to fill the dataset and … |
 | |
| | hi ... i have a query i have created an application in c# i have put this code in button [code] string strXmlPath = ""; XmlDocument doc = new XmlDocument(); strXmlPath = ("C:/App_Data/Document.xml"); DataSet ds = new DataSet(); XmlTextWriter writer = new XmlTextWriter(strXmlPath,System.Text.Encoding.UTF8); writer.WriteStartElement("folder"); writer.WriteElementString("FolderName", "App_Data"); writer.WriteElementString("FolderPath", "C:/App_Data/Document.xml"); writer.WriteEndElement(); writer.WriteStartElement("folder2"); … |
| | Hi all, I am trying to grab data from the database that this application is connecting to and then show entries in a treeview. [CODE] public void dbcall() { SqlConnection sqlconn = new SqlConnection("user id=USERNAME;" + "password=PASSWORD;server=SERVER;" + "database=DBNAME;" + "connection timeout=30"); SqlCommand select = new SqlCommand("SELECT * from MAIN", … |
| | i have 2 tables with same fields except that table2 has 1 additional field..but otherwise table1 and table2 have same fields and have different number of records in each and each row in each table could be the same or completely different.. i am trying to add the distinct values … |
| | [B][U]Note : -- [/U][/B][COLOR="Red"]Actually the IP address of my system is 192.168.1.253. The sql server is on the system 192.168.1.12. On my system the program is working properly. When I publish tht web service in inetpub, I can access also on machine 192.168.1.144 by the URL "http://192.168.1.253/MyWebServices/Service.asmx". But the same … |
| | Hi, I am not getting any results from stored procedure ,passing a parameter to the stored procedure . My code is [code=asp]<%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.SqlClient" %> <%@ Import Namespace="System.Web.UI" %> <script language="VB" runat="server"> Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load Trace.Write("This msg is … |
| | i created a sql database with table land. columns; LandID int PK LandCodeID int LandName nvarchar(100) LandFlag image Allow Nulls ive created a dataset in my solution. from my Data Sources i can drag & drop the table Land to my Form1 as DataGridView. it puts all the columns above … |
| | FOLKS: I fill my data grid view with data and i try to color a few cells based on a condition but nothing seems to work..no errors either..can u pls help me >? [CODE]Private Sub Button11_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Dim con As OleDbConnection = New OleDb.OleDbConnection("provider=microsoft.jet.oledb.4.0;data … |
| | I want to try and store distinct values of table1 in an array and compare that with values in table2 in each field. But I am not sure where I need to pass the sql statement..can u please take a look at it ? for that matter..i will just have … |
| | I want To pass A DataSet in a QueryString.So that I can get it another page.Is it possible.How i can i do it Pls help |
| | first just read my aspx&aspx.cs codes then repaly me aspx.cs code: [code=asp.net]namespace ReceiptsEntryPro { public partial class Groups : System.Web.UI.Page { RecieptBusiness objbs = new RecieptBusiness(); string strid; protected void Page_Load(object sender, EventArgs e) { GlidMax(); ItemsGet(); //repGroups.DataSource = dsrep; //repGroups.DataBind(); } protected void btnSave_Click(object sender, EventArgs e) { string … |
| | when i click "button1" on my form..i get field name as ' Expr1002' and the data in it are -1.. i believe it is soemthing to do with the da.fill() .. can u please asssist me with thsi ? [QUOTE] Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) … |
| | Greetings... I am trying to get a 2-d vector filled with a records form a dataset. this is what I have: [code] int StudentNum = 1, rflds; TDataSet *Students = DSet; String stu; rflds = Students->FieldCount; //Number of fields in the dataset vector< vector<String> > dataset(Students->RecordCount, vector<String>()); while (StudentNum <= … |
| | I am trying to add a new record to data base using VB.net. Here is my code: Imports System.Data Imports System.Data.OleDb Imports System.Data.SqlClient Dim objConnection As New OleDb.OleDbConnection objConnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= C:\Documents and Settings\ambarda\My Documents\db1.mdb;" Dim ds As New DataSet Dim sql As String = "SELECT * FROM Sheet1" … |
| | I want a button click event to do this: can i use "UNMATCHED" keyword in the same SQL Statment using a UNION ? pls help me with this!! table1 is my master Db and table2 is my work DB.. both have same columns expect that primary key in both tables … |
| | the code worked perfect on Friday and when I come back today and try.. the RAM alone works fine in the T-SQL but the Mfg, Make, GraphicsCard and GraphicsVersion do not work atall.. they dont give me any queries atall in the data grid view o/p.. why am i stuck …  |
| | I did all this code for a form that inputs, delets, updates, and views data in a database and everything works but i keep getting errors that my update and delete isn't working and it's some kind of exception. here's the entire code using System; using System.Collections.Generic; using System.ComponentModel; using … |
| | this is my code.. i got both my work database and my master database on the datagrid views in my form...but how do i go about comparing.. and generating the crystal report ? [QUOTE] imports System.Data.oledb Public Class Form1 Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles … |
| | I need to choose a value from a combo box and check if that exists in a table and if it does..i need to make a button glow green.. I am not sure how I have to check if the chosen value exists in that table.. can you please help …  |
| | Hello, I have a C# GUI that is supposed to call a backend I have in a C++ CLI/CLR shared library. That library calls another DLL that was created by MATLAB, but I can't get the second DLL called... Is it a mistake to put the backend in a DLL? … |
| | I need to choose a value from a combo box and check if that exists in a table and if it does..i need to make a button glow green.. I am not sure how I have to check if the chosen value exists in that table.. can you please help … |
| | the code worked perfect on Friday and when I come back today and try.. the RAM alone works fine in the T-SQL but the Mfg, Make, GraphicsCard and GraphicsVersion do not work atall.. they dont give me any queries atall in the data grid view o/p.. why am i stuck … |
| | HI all, I just want to ask how we can add more than 1 table in dataset or dataadapter through coding not through wizard. |
| | What I'm trying to do is having a sign up form that they can fill out, click sign up and have all the information implanted into the database but I'm having problems. This is my VB Page. [code]Imports System Imports System.Data Imports System.Data.SqlClient Imports System.Text Partial Class _Default Inherits System.Web.UI.Page … |
| | first, i am sorry if i can't speak english well i have problem where i can't insert data to data base mySQl using vb2005. it is my simple code on vb. ---------------------------------- [code]Imports MySql.Data Imports MySql.Data.MySqlClient Public Class Form1 Dim xobjConnection As New MySqlConnection("Server=localhost;uid=root;pwd=;database=test1;") Dim xobjAdapter As New MySqlDataAdapter() Dim … |
| | there is another problem that i am facing..i got 2 comboboxes filled with values from MS Access and they have values like 1.00,2.00,2.98,3.00,3.25 and 8.00 I want to be able to choose 2 values i.e. one value from each combo box and when I hit click I should get queries … |
| | Hello All, This is my first post here but after reading and trying for a couple of days now i figured i might just ask whether what i'm trying to do is possible.......... I have written the code below to check for changes in fields and i want to update … |
| | hello frds, I m working on windows app in .net envirement with c#. I want to fetch large amount of data from a table and load it to my app. by dataset. but problem is, it unable to handle this or take a long time. My table have approx 10 …  |
The End.