i create a library with a datagridview, that i polute manually from several database querys...
thats just fine.... works excelent..
but if i browse the aspx page from another computer on the network, when the code tries to read the data set give me an error
Cannot find the table 0
seems like a problemwith the connection or the query, but if i browse the page from the localmachine i works just fine
please help
Public MM_CONEXION_STRING As String = "server=HP001SQL2000;uid=xxx;pwd=xxxxx;database=GSSDOTNET;"Dim myConnection As New SqlConnection(MM_CONEXION_STRING)Dim myCommand As New SqlCommand(SQL, myConnection)
myConnection.Open()Dim objDS As New System.Data.DataSet()
objDS=myCommand.ExecuteReader()For Each FILA As System.Data.DataRow In objDS.Tables(0).Rows .......
I know this should be the easiest thing in the world but I cant seem to find out how to allow my windows control library dll which is loaded in a webpage to access sql. It works perfectly from within visual studio though, what do I need to do allow my webpage dll to access sql without throwing a security exception? Any links or help would be greatly appreciated.
It is posible with Entreprise Library to use the SAME QUERY, by example, "Select isnull(Val,33) from calculs where Col1 is not null" (specific for Sql Server) to select data from Oracle too ? or the only way is to use specific stored procedures (queries) wtitten in 2 ways : for Oracle and for Sql Server?
The dataset2 control doesn't seem to want to place the text in the right spot. I put it right after the 1st Dataset and the user comments wound up all the way down in the footer of the site. I want them to appear in the white area just underneath the article text. Here's a link to one of my articles so you can see this. http://www.link-exchangers.com/view_full_article.aspx?aid=50 Down at the bottom left corner you'll see white space below the article. I'd like to have all the comments lined up going down the page. Is the dataset the best control for this task?
Does anyone know how to reference the ongoing dataset within the dataflow in sql?
So here is the scenario I have.
1) OLE DB SOURCE 2) Lookup a value and that column gets added to the dataset 3) Lookup another value but this time I would rather code the sql rather than select a referencing table. How do I reference the current dataset?
I am trying to upload a file in ASP.net 2.0 to a SQL database using the FileUpload control. I am doing this by way of a typed dataset.Here is my code.Dim rta As New ResponseTableAdapterDim rdt As ResponseDataTable = rta.GetResponseByID(1)Dim rr As ResponseRow = rdt(0)Dim fs As New FileStream(fu.PostedFile.FileName, FileMode.Open, FileAccess.Read)Dim br As New BinaryReader(fs)Dim image() As Byte = br.ReadBytes(fs.Length)br.Close()fs.Close()rr.UploadFile = imagerr.NameFile = fs.Namerta.Update(rdt)The code runs without an error but afterwards I find that nothing has been stored in the UploadFile cell in the database but the file name has been stored in the NameFile cell in the database. Any ideas?Your help is much appreciated. James
Ive run into a situation where some code im using will not function the same when between these two cases. So, this has me wondering what is going on behind the scenes. What is the sequence of events that are occurring that would possibly be messing things up.Here is the sample codeIts a gridview that is using a sqldatasource control. The code works fine, but if you want to bind the grid to a dataset and call databind yourself, things dont work as expected and the other features that the code performs just isnt happening, at least not for me.
I have used my parameter value in where clause of my dataset control SQL query. When I choose a single value in my multiple-value parameter then I get output as expected. Hovewer when I choose multuple values I get an arror:
Only one expression can be specified in the select list when the subquery is not introduced with EXISTS. ---------------------------- Query execution failed for dataset 'DATABASE'. (rsErrorExecutingCommand) ---------------------------- An error has occurred during report processing. (rsProcessingAborted)
I am convinced that it's a syntax problem. Is there a way I can change syntax of data output from query:
select @parameter
I need output to be like: value, value, value ... etc.
The dataset control query looks something like the following:
select ID, a, b, c, d from DATASET.dbo.Table where ID in (select @parameter)
I have been searching through google for weeks to solve this and got this far and got stuck. Is it possible at all to achieve what I am looking for?
DB-Library Error 10007: General SQL Server error: Check messages fromthe SQLServer.CREATE PROCEDURE [dbo].[spu_Import_Export_Image](@srvr varchar(50),@db varchar(50),@usr varchar(15),@pwd varchar(50),@tbl varchar(50),@col varchar(50),@mod varchar(1),@imgpath1 varchar(1000),@pk varchar(50))ASBEGINdeclare @path varchar(50)declare @whr varchar(200)declare @fil varchar(100)declare @cmd varchar(1000)declare @imgpath varchar(800)declare @ext varchar(5)--declare @pk varchar(50)declare @KeyValue varchar(8000)declare @image varchar(50)--declare @imgpath1 varchar(1000)declare @imgpath2 varchar(1000)declare @sellist varchar(2000)set @path = 'c: extCopy.exe'select @sellist = 'DECLARE curKey CURSOR FOR SELECT ' + @pk +' FROM '+ @tbl + ' ORDER BY ' + @pkexec (@sellist)OPEN curKeyFETCH NEXT FROM curKey INTO @KeyValueWHILE (@@fetch_status = 0)BEGINset @whr = '"where '+ @pk +' = "' + @KeyValueset @fil = @imgpath1 + '' + @KeyValue --+ @extset @cmd = @path + ' /S ' + @srvr + ' /D ' + @db + ' /U ' + @usr+ ' /P ' + @pwd+ ' /T ' + @tbl + ' /C ' + @col + ' /W ' + @whr + '/F ' + @fil+ ' /' + @modexec Master..xp_cmdShell @cmdFETCH NEXT FROM curKey INTO @KeyValueENDCLOSE curKeyDEALLOCATE curKeyENDGOAbove srcipt runs fine with image data type in one table but when irun for some other table it gives me Error MessageTEXTCOPY Version 1.0DB-Library version 8.00.194SQL Server 'WSQL01' Message 170: Line 1: Incorrect syntax near '99'.(Concerning line 1)DB-Library Error 10007: General SQL Server error: Check messages fromthe SQLServer.ERROR: Could not use database 'test1'NULL-----------Aslo it only runs on server console if i run it from workstation uingsame files and tables it gives me an error again. Can anybody help meand reply me at Join Bytes! asap.thnx,dharmesh
Tempdb has grown to over 17 GB. It had no max growth limit set and actually took up all the disk space on the drive. I tried to run DBCC SHRINKDATABASE and received a bunch of errors about table corruptions. So, I found Brian Knight's post about stopping and restarting tempdb in minimal mode. I did that. It came back up and tempdb was correctly only 2 MB. It freed up 17 GB on the disk. Then, I stopped and restarted the service again, not in minimal mode, and it won't come back up. It has taken back that 17 GB of disk space. From the error log, I can see that it is stuck on rebuilding tempdb. Why is it trying to rebuild tempdb to 17 GB???
While in minimal mode, we did set the maximum growth limits to 1 GB for both data and log for tempdb, but that seemed to have no effect.
Line 1 Name: George Addresss date raise 125254 Test 10 125254 Test 10 125254 Test 10 125254 Test 10
Total: 80% 40
Name: Mik Addresss date raise 125254 Test 10 125254 Test 10 125254 Test 10
Total: 70% 30
Name: Jonathan Addresss date raise 125254 Test 10 125254 Test 10 125254 Test 10
Total: 70% 30 Line 10
Line 15 Total for this division: 33% ((100 )/3) 100
Department:B ¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦¦.. Here is what I did I have a list control that is grouped by department. this will get me the info from Line 1 to Line 10 then this list control is actually under another list control that is grouped by department to get the info from Line 15. I used this example for simplicity and what I am doing is fairly similar to this situation. My problem is, I need to find away to know how many totals I have to count the total for the entire department. In other words : from the example above how can I know I have to divide by 3 to get 33%. I can get the 100 without any problem but I cant tell what number I need to divided by. I tried to use Count(Name.Field) I was hoping this will give me 3 which indicates the divided number. But I was getting 7 for some reason. How can I get the number of times the list control was implemented for one department which is in this case 3?
Select a.Field1,b.Field from table a, table b where a.patientid=@patID if(@select=1)
select a.Field1, a.Field2 from table a
else if(@select=2) select b.Field1, b.Field2 from table b end
When I bind this storedprocedure with Dataset, all the Fields Corresponding to table a and table b are displayed in the Dataset.Finally, when i bind this Dataset with my chart, the fields corresponding to table b are not displayed in the Chart. The reason for that may be because Report Server cannot bind with multiple Datasets? Please Clarify. If the Report Server cannot bind with multiple datasets, then how to call different StoredProcedures (according to Criteria) in a Single Report in Report Server project?
I have a web form which has 5 check boxes and i storing the values 1 - 5 for each check box the user clicks . I want to design part of a report in this fashion,
if the user clicks on the first checkBox i want A to appear in the report, and if the user clicks on the second i want B and so forth.
If the user clicks on A& B i want the data to be displayed as A,B. This is my sproc i am using.
Select
laa.PlanId,
laa.LoanId, ( 1-5 values are stored)
los.Name
From
LoansAttriApplied laa
Inner Join LoanOptions los on laa.LoanId = los.LoanId
Where
PlanId = @PlanId
So based on this Query if the user select 4 check boxes for plan No, 104 , I will get 4 rows. So based on the dataset i get
can I display the data in A,B or 1,2,3 instead of
1
2
3
Can someone please give me some insight into this.
Hi All, I am placing a Matrix inside the table control for grouping requirements,but when we export the report to the Excel, the contents inside the table cell are ignored. Is there any way to get the full report exported, as per the Requirement.Please help me with this issue.
I have a report with multiple datasets, the first of which pulls in data based on user entered parameters (sales date range and property use codes). Dataset1 pulls property id's and other sales data from a table (2014_COST) based on the user's parameters. I have set up another table (AUDITS) that I would like to use in dataset6. This table has 3 columns (Property ID's, Sales Price and Sales Date). I would like for dataset6 to pull the Property ID's that are NOT contained in the results from dataset1. In other words, I'd like the results of dataset6 to show me the property id's that are contained in the AUDITS table but which are not being pulled into dataset1. Both tables are in the same database.
I have a small number of rows in a dataset, Table 1.Β There is a CLOB on a large dataset, Table 2.Β They join on a PK.Β I would like to retrieve this CLOB and add it to the data flow for Table1.Β In short I want to emulate the following:
Table 1:Β Small table without CLOB, 10 rows.Β Table 2: Large table with CLOB, 10,000,000 rows
select CLOB from table2 where pk = (select pk from table1)
I want this to return the CLOBs for the small number of rows in Table 1.Β The PK is indexed obviously so it should be a fast look up.
Table 1 and Table 2 live on different Oracle databases.Β How do I perform this operation efficiently in SSIS?Β It seems the Lookup and Merge Join wont do this.
I have a report with multiple datasets, the first of which pulls in data based on user entered parameters (sales date range and property use codes). Dataset1 pulls property id's and other sales data from a table (2014_COST) based on the user's parameters.
I have set up another table (AUDITS) that I would like to use in dataset6. This table has 3 columns (Property ID's, Sales Price and Sales Date). I would like for dataset6 to pull the Property ID's that are NOT contained in the results from dataset1. In other words, I'd like the results of dataset6 to show me the property id's that are contained in the AUDITS table but which are not being pulled into dataset1. Both tables are in the same database.
I found out the data I need for my SQL Report is already defined in a dynamic dataset on another web service. Is there a way to use web services to call another web service to get the dataset I need to generate a report? Examples would help if you have any, thanks for looking
Hi, I have a stored procedure attached below. It returns 2 rows in the SQL Management studio when I execute MyStorProc 0,28. But in my program which uses ADOHelper, it returns a dataset with tables.count=0. if I comment out the line --If @Status = 0 then it returns the rows. Obviously it does not stop in if @Status=0 even if I pass @status=0. What am I doing wrong? Any help is appreciated.
ALTER PROCEDURE [dbo].[MyStorProc]
(
@Status smallint,
@RowCount int = NULL,
@FacilityId numeric(10,0) = NULL,
@QueueID numeric (10,0)= NULL,
@VendorId numeric(10, 0) = NULL
)
AS
SET NOCOUNT ON
SET CONCAT_NULL_YIELDS_NULL OFF
If @Status = 0
BEGIN
SELECT ...... END If @Status = 1 BEGIN SELECT...... END
UPDATE #2: When it said "Do you want to install Microsoft SQL Server" I said "yes" and that caused it to work. I exited and re-ran and now the print runs w/o the "install SQL Server" (If the prompt had said "Do you want to install the print dialog" we wouldn't be having this discussion...)
UPDATE: After posting this i discovered that the same thing occurs when attempting to print the report direct from IE6: First a dialog pops up "Do you want to install this software?" Name: Microsoft SQL Server. When I click "Don't Install" I get the dialog "unable to load client print control." Since this happens direct from IE6 I suspect it's browser settings. I'll resume tomorrow and post a followup.
My WinForm C# app integrates Reporting Services by calling them from WebBrowser controls. The problem is attempts to print cause a dialog: "unable to load client print control."
I've read prior posts that say "enable Active-X in your browser" - I don't know how to do that from a WebBrowser control.
Any ideas how to support Reporting Services "Print" from within a WebBrowser control?
i have two datasets.one dataset have old data from some other database.second dataset have original data from sql server 2005 database.both database have same field having id as a primary key.i want to transfer all the data from first dataset to new dataset retaining the previous data but if old dataset have the same id(primary key) as in the new one then that row will not transfer. but if the id(primary key) have changed values then the fields updated with that data.how can i do that.
D2 is a list of data. each row in D2 has a classid. D2 may or may not have all the classids in D1. all classids in D2 must be in D1.
I want to show fields in D2 and group the data with classids in D1 and show every group as a seperate table. If no data in D2 is available for a classid, It shows a empty table.
Hi! When I use dbrpcparam to add empty string as a parameter to a stored prosedure, as a result I have NULL, but I need to get an empty string. It seems to me the DB library for C does not allow to pass an empty string as a parameter of a stored procedure. It gets converted to NULL. ?? Do you know how I can avoid the problem? Thank you. Anny.
I am porting the proC programs from Oracle to C on windows. Does anybody know that If I am using DB library for C, does it support the dynamic binding of the table and conditions like Oracle`s embedded sql ( 4th method?)
ex: select unknown columns from unknown tables where unknown colum= unknown value
We are looking for an ETL library or callable application that wouldallow us to transfer and transform data between platforms but mainlyinto a SQL server database. We would be calling this tool fromjavascript programs. Is there something out there in the midrangeprice-wise? So far I am finding just high-end ETL tools that are alittle over kill for us.Thanks.
This is not an actual question but more of a topic that I cannot find any information on and that may be because there is nothing about it.Basicly is there any SQL Database Table Libraries out there?......For instance I am creating a tedious database table right now which includes the names of all the countires (around 200 ) its simply used for a registration process where a users country information gets saved in the database...Since the worlds country names do not get changed very much is there a sql database table out there thats pre-made so I dont have to sit here and enter in all 200 or so countries by hand?....this is what I mean by database table libraries, it can basicly include all common things a website may use like a province/state dropdown list (pre-made database table), the worlds countries (again pre-made database table) and so on....If someone can come to my rescue and help me find some information on this it would be great cause well It's probably going to take a bit to enter in every country name, then the same for all the provinces/states, then bind them somewhat so when a user clicks on canada the provinces/states for canada are only avalible in the next list.Thank You All.Adam
I have been receiving the following error when I look into the NT error log and I am not sure what it is referring to. First thing that happens is that I receive an error that my Open Objects may be too low and then the following error: DB-LIBRARY error - SQL Server connection timed out. The source listed is SQLCTR60.
Hi, I have the following problem: Anytime I`m starting the PC, the following message appears: "SQLDUMPER library failed to initialize.....TRY TO RE-INSTALL THE FILE" Could anyone help me deal with this? What should I do? thank you, Enno
Does anyone know if this SQL is part of MS Office or is it XP... I haven't figured that out. It says reinstall the program but doesn't say what program. I know I never intentionally installed an SQL program. At this time I get the same message as everyone seems to be getting - SQL Dumper Library failed... reinstall .... The problem for me started when I added Office 2007 and added the business contacts program. Any ideas are appreciated!
when i start up my computer it displays the message sqldumper library failed initialization. your installation is either corrupt or has been tampered with. uninstall then rerun setup. what do i do?
HI all,i want to log different activities of my application like (order approved, order rejected etc) to a sql database using Enterprise Library 2.0.can anyone help me by giving a link(step by step procedure for this).or explain how to create my own sample application to log some event to DB(by creating a new database and tables for this).Thanks in advance.regards,Jon.
