|
Hi,
How do I send a Textbox value to a SQL View?
Example: I have a Textbox and I want to do a SQL View based upon the value of the Textbox.
Can anyone please help?
Kind Regards
|
|
|
|
|
just pass the value with sqlcommand
cmd=create view + "'textbox1.text'" + as select.....
|
|
|
|
|
Abhijit Jana wrote: create view + "'textbox1.text'" + as select.....
Not a good method, it is very near to SQL Injection Attacks[^].
|
|
|
|
|
Llama_4 wrote: I want to do a SQL View based upon the value of the Textbox.
Creating the view ? Parameterized views are not allowed in SQL Server 2000
|
|
|
|
|
I don't know why GE' designed it's API this way: you can get features like placemarks, but they don't have the Lon/Lat info at all! Yes, you can make GE "fly" there and then you can get the Lon/Lat via the camera, but the prerequisit is the feature's HasView==1. In practice I found most features don't have view.
How can I get the Lat/Lon of a feature?
|
|
|
|
|
sduhd wrote:
How can I get the Lat/Lon of a feature?
Not sure, have you looked through all of their documentation?
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
|
I implemented code exporting data from dataset to pdf file. with same code when my pc installed Crystall Report 10 developer enterprise edition, it got no error. but i got one error with Crystall Report 11. What is cause?. Whether the cause is Crystall Report 11?. it's very urgent problem. Thank you.
here is error:
The Report Application Server failed
at CrystalDecisions.ReportAppServer.ConvertDotNetToErom.ThrowDotNetException(Exception e)
at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext)
at CrystalDecisions.CrystalReports.Engine.FormatEngine.ExportToStream(ExportRequestContext reqContext)
at CrystalDecisions.CrystalReports.Engine.FormatEngine.Export(ExportRequestContext reqContext)
at CrystalDecisions.CrystalReports.Engine.FormatEngine.Export()
at CrystalDecisions.CrystalReports.Engine.ReportDocument.Export()
at ACE.BbqOnPC.frmBBQWizard.CreatePDFReportFile(String psReportFile, DataSet pdsReportData) in c:\Working\bbqcd\source\BbqOnPC\frmBBQWizard.cs:line 2858
at ACE.BbqOnPC.frmBBQWizard.CreatePDFReportFile() in c:\Working\bbqcd\source\BbqOnPC\frmBBQWizard.cs:line 2802
Inner Exception :
The Report Application Server failed
at CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export(ExportOptions pExportOptions, RequestContext pRequestContext)
at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext)
Belove is code:
psReportFile: pdf file path
pdsReportData: data
public void CreatePDFReportFile(string psReportFile, System.Data.DataSet pdsReportData)
{
try
{
ReportDocument loRepDoc = new ReportDocument();
ReportDocument loSubRepDoc = null;
loRepDoc.Load(Application.StartupPath.TrimEnd(new char[]{'\\'}) + "\\" + psReportFile);
loRepDoc.Database.Tables[0].SetDataSource(pdsReportData);
for (int index = 0; index < loRepDoc.ReportDefinition.Sections.Count; index ++ )
{
Section loSection = loRepDoc.ReportDefinition.Sections[index];
for (int intCounter = 0; intCounter < loSection.ReportObjects.Count; intCounter ++)
{
if (loSection.ReportObjects[intCounter].Kind == CrystalDecisions.Shared.ReportObjectKind.SubreportObject)
{
SubreportObject loSubReport = (SubreportObject) loSection.ReportObjects[intCounter];
loSubRepDoc = loSubReport.OpenSubreport(loSubReport.SubreportName);
if (loSubRepDoc != null)
{
for (int intCounter1 = 0; intCounter1 < loSubRepDoc.Database.Tables.Count; intCounter1 ++ )
{
loSubRepDoc.Database.Tables[intCounter1].SetDataSource(pdsReportData);
}
}
}
}
}
string lsPdfTempFile = Application.UserAppDataPath.TrimEnd(new char[]{'\\'}) + "\\temp.pdf";
loRepDoc.ExportToDisk(ExportFormatType.PortableDocFormat, lsPdfTempFile);
/*
CrystalDecisions.Shared.DiskFileDestinationOptions DiskOpts = new CrystalDecisions.Shared.DiskFileDestinationOptions();
loRepDoc.ExportOptions.ExportDestinationType = CrystalDecisions.Shared.ExportDestinationType.DiskFile;
loRepDoc.ExportOptions.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.PortableDocFormat;
DiskOpts.DiskFileName = Application.UserAppDataPath.TrimEnd(new char[]{'\\'}) + "\\temp.pdf";
loRepDoc.ExportOptions.DestinationOptions = DiskOpts;
loRepDoc.Export();
*/
}
finally
{
}
}
heomo
|
|
|
|
|
hi
please help me.....
am doing a mantanence project. i have writen some code to copy a file from server to harddisk. but there is some problem. i have developed this as windows application. now they want as web. tyhe problem is, i was reading the file path and copying in dos.in windos the path is already is there in html page in javascript. can i move the value to a the code behind string(C#). if we can convert how is it possible?
in code behind there is string Customer, book
on html page there is values of customer1 and journal as
var customer1 ='<%=Session["customer"]%>';<br />
var journal = '<%=Session["journal"]%>';
how can we get the values of customer1 and journal to Customer, book
please help me....
please
|
|
|
|
|
If you read the values in javascript from the Session object...why don't you read on the server (code behind) from the Session object also?
There are 10 kinds of people: those who understand binary and those who don't
|
|
|
|
|
This is a mainanance project.
am biginer to .net
so dont know much. i dont know how to do that. thats y am asking. i just want to know how we can get the value of javascript variable in c#
This is the function in javascript
function display()
{
var localpath1 = document.getElementById('lblerr');
lblerr.innerText = localpath;
}
|
|
|
|
|
from the javascript function i understand that you have an asp:Label control on your page. In this case in the code behind just use:
string Value = lblerr.Text;
My first reply referd at this code you wrote:
<br />
var customer1 ='<%=Session["customer"]%>';<br />
var journal = '<%=Session["journal"]%>';<br />
Using <%=Session["customer"]%> means that you insert a C# call to retrieve data from the Session object, which is also available in the code behind.
string customerValue = (string)Session["customer"];
Hope it helps.
There are 10 kinds of people: those who understand binary and those who don't
|
|
|
|
|
there are ListBox,textBox to combine
baseControl is control
how to do?
alex
xufei@wxhx.com
|
|
|
|
|
ComboBox cb = new ComboBox(); 
Regards,
mav
--
Black holes are the places where God divided by 0...
|
|
|
|
|
how to check database if exist on the server using c#?
thanks in advance, 
******************************
I just want to
know everything
|
|
|
|
|
use microsoft sqlserver connection info dll files
private static Server srvSql;
private static ServerConnection srvConn;
void ReadDatabase(string _ServerName)
{
try
{
srvConn = new ServerConnection(_ServerName);
srvConn.LoginSecure = true;
srvSql = new Server(srvConn);
foreach (Database MyServer in srvSql.Databases)
{
cmboDB.Items.Add(MyServer.Name);
//Here you can check wheather database exist or not
}
}
catch (Exception DbExp)
{
MessageBox.Show("Error in Connection !!!!", "Database ", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
|
|
|
|
|
Take One Textbox anb Button........
Write the following code for Button click....
SqlConnection cn = new SqlConnection("server=ms08; uid=sa; pwd=;");
string Qry ="SELECT Count(*) FROM master.dbo.sysdatabases WHERE name = '" + TextBox1.Text + "'";
SqlDataAdapter da = new SqlDataAdapter(Qry,cn);
DataSet ds =new DataSet();
da.Fill(ds);
DataRow dr=ds.Tables[0].Rows[0];
if(dr[0].ToString() == "1")
MessageBox.Show(Exists..")
else
MessageBox.Show("Does not exists....");
venki
|
|
|
|
|
Try to connect to the database and catch any exceptions that it may throw back at you about not being able to connect to the specified database.
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
|
to Abhijit Jana , Venki56 and Paul Conrad
Thanks for your help,
Cheers.
******************************
I just want to
know everything
|
|
|
|
|
Hi Friends,
I got a strange question on my application. Sometimes when I going to start my application, a installer will appear, and asking for reinsall. After reinstalled, the application can be run.
It was not happened everytimes, but very occasionally. I'm thinking what's wrong in my project design?
1. will it related to the problem of some missing folder? (coz I set all folder AlwaysCreate to true)
2. any wrong step I made on my installer?
My project is related to PDF, is it related to PDF problem?
Please help, and give some hints. Thanks so much
|
|
|
|
|
Hi!
I guess you've created a setup and deployment project to install your application and are starting the program using a shortcut created there, right?
In this case, Windows Installer checks if all the key files in your installation are still there and if not tries to reinstall them.
I can't describe it in all details but this should get you started.
Regards,
mav
--
Black holes are the places where God divided by 0...
|
|
|
|
|
Hi, I was woundering if some of the higher level C# programmers could help me with my code. I have read all the Doc. that i can find about it, But i still cant get it to fully work. If I comment out the keyboadx ref's the mouseclickx works fine. If I dont neather the mouseclickx nor the keyboardx works at all. I cant get the keyboardx to work in any fashion.
I made a link to a paste it site because i didnt know how it it is looked at about paste long code in forums.
http://rafb.net/p/bmuAVm81.html[^]
|
|
|
|
|
Hi,
the problem is with your INPUT struct; its original C definition has a union which
puts MOUSEINPUT and KEYBDINPUT at the same location; yours has not, so the substructs
are located sequentially.
There is a way to mimic union behavior in C# using explicit offsets, but in this case
it would be easier to come up with two different INPUT structs (say INPUTK and INPUTM),
and two prototypes for SendInput accordingly.
Luc Pattyn [Forum Guidelines] [My Articles]
this months tips:
- use PRE tags to preserve formatting when showing multi-line code snippets
- before you ask a question here, search CodeProject, then Google
|
|
|
|
|
And as usual, Luc has the answer.
I wouldn't even have thought of checking the original structs.
My current favourite word is: Waffle
Cheese is still good though.
|
|
|
|
|
![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
when it fails no part is beyond suspicion...
Luc Pattyn [Forum Guidelines] [My Articles]
this months tips:
- use PRE tags to preserve formatting when showing multi-line code snippets
- before you ask a question here, search CodeProject, then Google
|
|
|
|
|
Thank you for the reply. I have modifed my code serveral time to try to make the struct more like you said. but to no avail can i get it to work. this is the code I have this time.
Let me know what you see wrong on this one..
Thank you very much
Danzar
http://rafb.net/p/uPx4EW73.html[^]
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
