|
I want to assign a stored procedure for an sql datasource. The stored procedure belongs to different user-defined schema rather than the dbo. The stored procedure is being detected but but when I click test it says "Could not find stored procedure 'sp_name'".
|
|
|
|
|
Hey dude, are you aware you posted this in the .NET framework forum? Seems like it should be in one of the Database forums yes?
|
|
|
|
|
First i ve created .xsd file and then add to my project. After that add a crystal report. I am not getting any table in the Database field of the crystal Report and getting error "The Report has no Tables"
<pre> Public Sub sPrintProjectExpenseReport(ByVal Print As Boolean, Optional ByVal findstring As String = "")
Dim ObjDataAdapter As SqlDataAdapter
Dim ObjDataset As DataSet
Dim sql As String
Try
sql= "Select * from project"
ObjDataAdapter = New SqlDataAdapter(sql, ObjCon)
ObjDataset = New DataSet()
ObjDataAdapter.Fill(ObjDataset, "ProjectwiseExpenseReport")
''''export xsd
'ObjDataset.WriteXmlSchema(Application.StartupPath & "\ProjectwiseExpenseReport.xsd")
'MsgBox("Report Exported")
Dim ObjReport As New CRProjectwiseExpense
ObjReport.SetDataSource(ObjDataset.Tables("ProjectwiseExpenseReport")) '' error is here
If Print Then
ObjReport.PrintToPrinter(1, False, 0, 0)
Else
FrmCRViewer.ObjReportViewer.ReportSource = ObjReport
FrmCRViewer.Show()
End If
Catch ex As Exception
MsgBox(Err.Description, MsgBoxStyle.Critical)
End Try
End Sub
|
|
|
|
|
First assign the report like generate report by Datasource
then
Set all the data source by programmatic
it will start work
|
|
|
|
|
plz give a sample. how does this action should be done!!!
i can't get you.
sorry
|
|
|
|
|
is it possible ?
1)can i force stop CLR from doing something? whenever i need.
2) can i force to start clr to work?whenever i need
some one asked me the Question, plz don't tell what does clr do....
|
|
|
|
|
No, you cannot stop the .NET framework. This would even be dangerous, as it would halt the execution of all applications that are using the framework.
Can you tell us what you're trying to achieve? Perhaps there's an alternative method to reach that goal. If the target is a Windows Service, then yes - those can be paused, started and stopped.
I are troll 
|
|
|
|
|
I'm trying to get the latest installed version of .Net on a given machine. I've tried a couple of different ways, but it keeps coming back with 2.0, which is curious since I'm running a WPF app on a machine that I *KNOW* has 3.5 SP1 on it.
How should I go about properly retrieving the .Net version?
What happens if a .Net app is run on a system that doesn't have the appropriate version of .Net?
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001
|
|
|
|
|
This registry key seems to have all the infor required - on this system anyway.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\NET Framework Setup\NDP
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
Why are you using VB6? Do you hate yourself? (Christian Graus)
|
|
|
|
|
Davey's reply covers the first part of your question. More info about the entire detection process could be found here.
As for what happens, in general the program will crash on startup, normally with an incredibly useless message. If you have 2.0 and need 3.0 or 3.5 then it will sometimes crash saying it could not find PresentationFramework.dll or whatever WPF one it is looking for.
|
|
|
|
|
hi all,
m working with some datas from database. i had all the datas in datatable. i want to export this datas to a Excel file. when i tried to add reference Microsoft.Office.Interop, i dont found the reference. bcose of this i cannot use Excel.Application class. Do any 1 have an idea ?
Thanks in Advance..
|
|
|
|
|
Do you have Excel installed on your local machine?
I are troll
|
|
|
|
|
|
|
Hi
I created a client and server app. using Sockets, is there a way that the client can locate the listening server without knowing the server IP Address in C#/VB.NET?
|
|
|
|
|
It needs some way to locate the server. It could be a domain name or subdomain e.g. http://myserver.mydomain.com. This will resolve via DNS to an IP address assuming the DNS is configured correctly.
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
Why are you using VB6? Do you hate yourself? (Christian Graus)
|
|
|
|
|
hi,
i am connecting ms access database to vb.net application.with out writing directly i stored connection string in inf file.i need to access that connection string from the inf file.
reply please.......
Thank you.
|
|
|
|
|
u can try this
sqlconnection Sqlconn=new sqlconnection();
Sqlconn=Application.startuppath("Initial catalog=db;server=servername;userid=;password=;");
now u can use this connection string any where at ur form.
|
|
|
|
|
Hi,
My application is designed in .net framework 2.0 which is working fine with 4+ client with more then 1000+ users.
But in one client environment application is closing suddenly without giving any error message or event in event log.
We have UI +Web services +DB layers. All are developed in .framework 2.0.
Right now in client environment in IIS7 my application is running. And in user machines
Framework 2.0, 3.0, 3.5 is there becoz of windows updates.
Any one can guess what could be the problem application is closing randomly.
There is no timeframe when application close.
Regards,
Pritesh
|
|
|
|
|
hello,everyone. I have come to the follow question.
A file from Host (AS/400 or IBM 9000) in EBCDIC(ibm 1388 or cp935) encode , include some chinese chars.
Now, I would translate the string in this file to chinese chars in Windows OS and .net Framework, which is gb2312 encode. I have search many archives, but can't find a way.
Please help me ! Thanks.
hope for help
modified on Saturday, July 4, 2009 10:40 AM
|
|
|
|
|
A quick scan of google brings up a product called TextPipe Pro which claims to do it. Not sure if that helps you or not but it might be worth looking at if all else fails.
|
|
|
|
|
TextPipe is a software, not source code. I need a way to translate the code in .net framework.
thank you , anyway.
hope for help
|
|
|
|
|
A quick scan of google brings up some examples of converting between GB2312 and unicode.
static void Main(string[] args) {
string infile = args[0];
string outfile = args[1];
using (StreamReader sr = new StreamReader(infile, Encoding.GetEncoding(936))) {
using (StreamWriter sw = new StreamWriter(outfile, false, Encoding.UTF8)) {
sw.Write(sr.ReadToEnd());
sw.Close();
}
sr.Close();
}
}
It shouldn't be too hard to start from that and figure out how to convert from EBCDIC.
|
|
|
|
|
This can only trans 936 to Utf8, can't translate 1388 to 936.
hope for help
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
