|
|
It would work, so long as you don't change the size of the RTB with the form, 'cause the white and yellow formatting will follow the flow of the text, not the lines in the box.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
The connection string for SQL Server 2005 Express version is something like:
Trusted_Connection=yes;Server=[ip]\SQLEXPRESS;Database=[database];user=[user];password=[pw];
But how about the one for SQL Server 2000?
Thanks!
|
|
|
|
|
I am using SqlConnection and SqlDataAdapter.
Please Help! Thanks!
|
|
|
|
|
Specifying a trusted connection and a user name and password is pointless. Choose one or the other. If I remember correctly, if you put both, it will go for a trusted connection.
Archyami wrote: But how about the one for SQL Server 2000?
Same deal - But you cannot specify files directly. They must already be attached to the server.
|
|
|
|
|
I have an XML file that may go upto 1GB and may contaion 5 lakh records. I wanted to retrieve last or latest 3000 records. I was trying to use XmlTextReader, but was a fail.
Is there any way by which i can read from end of a XML file and get all the details taking into account of performance.
Thanks in advance
Praveen Raghuvanshi
Software Engineer,
|
|
|
|
|
Use xPath, it's the quickest method of reading xml. However if you only need the latest 3000 records, i'd recommend creating a temp-file like construction in order to read the required data only.
|
|
|
|
|
Thanks Eduard for your reply.....
could you please elaborate or send me a link for xPath and the other solution described by you.
Also, how i will be reading the find from end....
Praveen Raghuvanshi
Software Engineer
|
|
|
|
|
xPath is supported by the .NET framework in the namespace System.XML.XPath. You can find loads of manuals, how-to's and articles around the web.
I love it when a plan comes together
|
|
|
|
|
Hi guys,
Please help!!! this issue is driving me crazy. I have a crystal report which during creation I used an Oledb connection with SQL server 2000 to fetch the tables. In my C# code I am passing dbname, server, id and pwd to another server and I am getting a problem because I believe the report is trying to look for the OLEDB settings that I had used during the report creation.... I don't know if I am making any sense, here is my code.
try
{
bool rt=true;
string sErrMessage=string.Empty;
DBUtilObj obj = null;
obj=new DBUtilObj();
rt=obj.g_sGetConnectString(out m_sCnn, out m_sServer, out m_sDBName, out m_sUserId, out m_sPassword,out sErrMessage);
cryShared.TableLogOnInfo tbLogInfo=null;
Pinn rpt = new Pinn();
foreach ( cryEngine.Table tb in rpt.Database.Tables)
{
tbLogInfo=tb.LogOnInfo;
tbLogInfo.ConnectionInfo.ServerName=m_sServer;
tbLogInfo.ConnectionInfo.DatabaseName=m_sDBName;
tbLogInfo.ConnectionInfo.UserID=m_sUserId;
tbLogInfo.ConnectionInfo.Password=m_sPassword;
tb.ApplyLogOnInfo(tbLogInfo);
tb.Location="\"" + m_sDBName+".dbo.\"" +
tb.Location.Substring(tb.Location.LastIndexOf(".")+1);
}
crystalReportViewer1.ReportSource=rpt;
}
catch(Exception ex)
{
MessageBox.Show(this, ex.Message,"SelecSoftware Pinnacle+™",MessageBoxButtons.OK,MessageBoxIcon.Error);
}
finally
{
}
Please help!!!!!!!!!!
sasa
|
|
|
|
|
Hello,
I would like to make a call to a web service at regular intervals and I'm interested in opinions on how best to do it.
My web service will need to read in some data from a database and move it to another application. This needs to happen for one case every 10 minutes, another case every hour and another case every 24 hours.
The easiest method I think is to use the built-in Windows Task Scheduler service as I've read somewhere that a Windows service would probably be overkill for what I want to do - the web service can report success if it is called so there's no need to audit the Windows Task Scheduler (I understand that there are potential problems with relying on the WTS to report errors).
The WTS seems a bit of a poor cousin of UNIX/Linux's cron. I wonder why MS has never bothered turning it into something actually useful?
So, can anyone tell me how to:
1. Add a job to the WTS which will call a web service (how do I call a web service on the command line)?
2. Implement something better - can I implement something in the web service itself or should I just write a separate service for each process that needs to call my service.
Thanks
|
|
|
|
|
Erhm, there are several issues you're talking about. For example, you say the webservice can report whether your process was succesfull. In fact, the webservice can only report that the webservice process went succesfull. It did send the data to your app. The webservice cannot report whether the parsing of that data on your 'local' machine was succesfull.
Second, you cannot start a webservice from the commandline. You need to develop an app. which has a reference to the webservice and invoke a method within the webservice. You should schedule your app calling, and make you app report if something went wrong (and what) or (which is what we aim for) everything went fine.
I think you can schedule you app. using WTS don't think you'll run into problems there.
|
|
|
|
|
thx for the reply.
The web service will exist on the same machine as the database and the application so no problem there
I don't want to start the web service from the command line, I just want to call a method on the web service. I did find this though which seems to work well:
Save the following as MSFT.vbs:
set SOAPClient = createobject("MSSOAP.SOAPClient")
SOAPClient.mssoapinit "http://www.webservicex.net/stockquote.asmx?WSDL"
WScript.Echo "MSFT = " & SOAPClient.GetQuote("MSFT")
Then from a command prompt, run:
C:\>MSFT.vbs
I just have to verify it working under WTS now
|
|
|
|
|
If you are using SQL Server, you should consider using DTS/SSIS instead. These have been designed to do exactly what you have stated. A web-service gives you no benefit, and requires a lot of extra work that is taken care of by SQL Server.
the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Thx, my fault for not being clearer - when I say reading data from a database I'm actually calling another web service (from my web service) which provides the data from a crm system. Totally agree about DTS if it were just a SQL server of course
|
|
|
|
|
If you've got SQL Server 2005, then you could still do this. Bear in mind that you can host CLR applications inside SQL Server, so you would still be able to leverage this.
the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
My apologies to Mexicans by the way for the screen name - it's a temporary one I got from bugmenot.com and I didn't realise it could be construed as being offensive. I'm on site at the moment and haven't got my proper details
|
|
|
|
|
This is how a checkedlistcontrol is populated:
chklstUserRoles.DataSource = dsUsersAndRoles.Tables["Roles"].DefaultView;
chklstUserRoles.DisplayMember = "Name";
chklstUserRoles.ValueMember = "RoleID";
I would like to loop through a checkedlistBox control and collect the IDs that is allocated to each checked item in the control.
This does not quite work:
for (int i = 0; i <= chklstUserRoles.CheckedItems.Count - 1; i++)
{
strRoleIds += chklstUserRoles.SelectedValue.ToString() + ",";
//strRoleIds += chklstUserRoles.CheckedItems[i].ToString() + ",";
}
Thanks
|
|
|
|
|
How to check if network share requires authentication from me using WMI or any other way ?
Thanks.
|
|
|
|
|
The only way to tell is to try and access it. If it fails, then you need to authenticate to the target server.
WMI won't help you in this case.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
I'm trying to find out how to bind an Itemtemplate which is dropdown ascx control to another data bound column in a webgrid.
I have this:
************************************************************
Diary di = Diary.GetDiaryItem(d);
grdDiary.DataSource =di.DiaryHistory;
C1.Web.C1WebGrid.C1BoundColumn col1 = new C1.Web.C1WebGrid.C1BoundColumn();
col1.DataField="DiaryEvent";
grdDiary.Columns.Add(col1);
C1.Web.C1WebGrid.C1TemplateColumn col2 = new C1.Web.C1WebGrid.C1TemplateColumn();
col2.ItemTemplate = LoadTemplate(@"Modules\EventCtl.ascx");
grdDiary.Columns.Add(col2);
grdDiary.DataBind();
**************************************************************
col2(dropdown) needs to reflect col1
Any help would be gratefully received!!
|
|
|
|
|
Hi all! Please clarify my one doubt regarding new operator. When it is needed to use new while creating an object.
Don't Quit
|
|
|
|
|
Nitin1981 wrote: When it is needed to use new while creating an object.
always.
|
|
|
|
|
Hi J4amie C! Thanks for reply. Please clarify few doubts.
1. Is it necessary to be used with reference types only?
If so why DataReader can be used without new.
2. If value types dont reuire a new then
Why in windows forms it is used like this?. where point(it is a structure) is a value type.
Form1.location = new System.Drawing.Point(x,y);
Regards
Don't Quit
|
|
|
|
|
Nitin1981 wrote: If so why DataReader can be used without new
It can't. It is just the new data reader is instantiated inside the ExecuteDataReader method rather than in YOUR code.
Nitin1981 wrote: If value types dont reuire a new then
Value types require a new. You might be getting confused with primative types (e.g. 1, true, 3.1415, "some string") which also happen to be mostly value types (strings are reference types)
|
|
|
|