|
Basicaly i need to develope simple sql query designer like sql server query designer. I need that to generate simple select statement. It is use to design query for the reports in the system
Dushan Perera
|
|
|
|
|
You need to either post the work on Rentacoder and pay someone to do it, or ask more specific questions.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
We use this product to give our used access to the database QueryBuilder[^]
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
You could always take a look at articles here on CP - specifically this[^] one.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
Hello! I can´t show videos in WS.
I have a GenericHandler:
]]>
using System;
using System.Web;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;
public class VideoHandler : IHttpHandler
{
private localhost.wsDataReader example;
public void ProcessRequest (HttpContext context)
{
example = new localhost.wsDataReader();
context.Response.BinaryWrite((byte[]) example.ShowVideo() );
}
public bool IsReusable
{
get {
return false;
}
}
}
If we only execute it shows a window for download the video: open, save or cancel.
This .ashx uses the WebMethod called ShowVideo():
using System;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Data.SqlClient;
[WebService(Namespace = "http://localhost/wsDataReader/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class wsDataReader : System.Web.Services.WebService
{
public SqlConnection ConexionConBD;
public SqlCommand Orden;
public SqlDataReader Lector;
[WebMethod(Description = "this method returns a video using DataReader")]
public byte[] ShowVideo()
{
string Conexion ="Data Source=.\\SQLEXPRESS;AttachDbFilename=\"|DataDirectory|\\BDvideos.mdf\";Integra" +
"ted Security=True;User Instance=True";
ConexionConBD = new SqlConnection(Conexion);
string Consulta = "SELECT Video FROM Videos";
Orden = new SqlCommand(Consulta, ConexionConBD);
ConexionConBD.Open();
Lector = Orden.ExecuteReader();
Lector.Read();
return (byte[]) Lector["Video"];
}
}
I don´t want download the video. I only want show the video in a WindowsFormsApplication or in a Website (.aspx)...
What can I do?
|
|
|
|
|
You can't really use a webservice if you don't want to download the video. Do you know anything about what a webservice is ?
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
Javier Aballay wrote: I don´t want download the video
Ok so how do you propose to move your eyeballs to the server. You need to research different way of displaying the video, get away from the idea that the vidio is not downloaded.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
i have a problem with how to pass the server name or its address in the code.
???
??
?
thanks in advance,,,
|
|
|
|
|
What the hell are you talking about ? What server name ? Is this an ASP.NET question ?
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
i have a project in c# and sql server and i have to make the server name in this project as a parameter how i make the end user to chose the server name to connect the project to the server database.
thanks for your efforts.
|
|
|
|
|
Hi there,
I’m trying to write a program that reads .xls file, formats it by removing specific rows and columns into table, sorts the data and then displays the data in dataGridView.
The .xls file is not formatted into table and in order to do that I need to delete 4 first rows and 2 first columns.
And here’s the problem when I’m trying to do that the program removes only 2 first rows and columns one and three instead of one and two. Here’s the code:
DataTable sampleDataTable = new DataTable();<br />
<br />
OleDbConnection aConnection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\file.xls;Extended Properties=Excel 8.0");<br />
<br />
aConnection.Open();<br />
<br />
OleDbDataAdapter oleDbCommand = new OleDbDataAdapter("Select * from [file$]", aConnection);<br />
oleDbCommand.Fill(sampleDataTable);<br />
<br />
dataGridView1.DataSource = sampleDataTable;<br />
<br />
dataGridView1.Columns.RemoveAt(0);<br />
dataGridView1.Columns.RemoveAt(1);<br />
<br />
dataGridView1.Rows.RemoveAt(0);<br />
dataGridView1.Rows.RemoveAt(1);<br />
dataGridView1.Rows.RemoveAt(2);<br />
dataGridView1.Rows.RemoveAt(3);<br />
I don’t know what’s wrong as I tested it several times by programatiacally counting coulumns and rows but it’s still not working. It does work when I format the file before opening it by the program though.
Hope that somebody will point me in the right direction.
Thanks, Darius
|
|
|
|
|
One problem I can see is that after removing a row at index 0, the row that was at index 1 is now at index 0 (everything gets shifted).
So you would want this I believe:
dataGridView1.Columns.RemoveAt(0);
dataGridView1.Columns.RemoveAt(0);
dataGridView1.Rows.RemoveAt(0);
dataGridView1.Rows.RemoveAt(0);
dataGridView1.Rows.RemoveAt(0);
dataGridView1.Rows.RemoveAt(0);
|
|
|
|
|
Thanks howlett,
I just tried it and it worked, so now I can move further. Thanks again, Darius
|
|
|
|
|
Can anyone help me how to navigate a web page which has frames using C#. I need to click on a hyperlink automatically on a particular frame within the table of a website.
Regards...
|
|
|
|
|
do you know the id of the link and the frame in which the link migh reside? if you do then you can access the link using window.frames[...].document.getElementById("....") and call its click method from there. I'd suggest though that you look into Jquery. It is rich Javascript framework that will be a part of Visual Studio 2010. It makes traversing and manipulating DOM elements very easy. More information on Jquery is http://jquery.com/
|
|
|
|
|
Thankxx alot dear,, I'll try this approach 2day. Actually the link i wanna click exist in a Column of a table using MSHTML lib,, if u have any more ideas plz do share.
Regards
|
|
|
|
|
Hi guyz i am working on an ftp application need to know how to upload a file.
i am having a trouble at
Stream ftpstream = ftp.GetRequestStream();
error is
The remote server returned an error: (550) File unavailable (e.g., file not found, no access)..
|
|
|
|
|
GetRequestStream[^] on msdn with example to upload a file.
Dude this is the 4th time you ask this question, there are plenty of examples on the net; if you don't figure it out this time then maybe you should re-evaluate your entire code.
modified on Monday, March 30, 2009 4:32 PM
|
|
|
|
|
thanks man its really helpfull.
|
|
|
|
|
Yeah that documentation, its a bugger, only wish they didn't hide it under the clever name of msdn[^]. If they only had a way of remembering it easily, as if the internet where a book and that would be a page and you could bookmark[^] it..
|
|
|
|
|
Hi guys!
I wonder if anyone can help me figure out a thing because I think my head will explode soon if I keep head butting my keyboard
The problem is:
I inject from C# a DLL (coded in C) into a process.
The injected DLL hooks Winsock and give recv/send packets back to the controller (the C# program) through SendMessage/WM_COPYDATA.
So far so good, it works flawlessy.
Now I have the inverse problem. How can I give data back to the DLL?
For example the controller receive a specific packet from the DLL and tells it how to act. I dont want to add too much things to the DLL but keeping it pretty simple/small and make the controller do the hard work.
Hope I explained my problem enough
Thank you all in advance.
|
|
|
|
|
Hi
I have Date Var in Oracle, and I try to insert Data from my C# program
sql = "insert into Table(MyDate) values (" + convert.todatetime(txt) + ")";
I get an Error, what can i do ?
|
|
|
|
|
E_Gold wrote: I get an Error, what can i do ?
If I were you, I'd post the error here.
E_Gold wrote: sql = "insert into Table(MyDate) values (" + convert.todatetime(txt) + ")";
Use parameters instead of concatenation[^]
|
|
|
|
|
it will be nice if u paste ur error msg here though i find a prob with your code. I just want to be sure
|
|
|
|
|
It would be even nicer if you didn't use SMSSpeak to write your posts.
|
|
|
|