|
To be honest, I never use the server explorer, nor is there any need for you to do so. Your DB communication is in no way related to the server explorer. If you write a proper data layer for your app, then you won't really expect to see any database connectivity within the IDE at all.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
there is no differece between asp.net or vb.net or c# for connection or fatch from data base .. you have missing command objects
dim objcmd as new sqlcommand
|
|
|
|
|
thanks for the reply
could u please explain how will i use this ?
bit confused
thanks
ninja coding
|
|
|
|
|
Hello,
I am using C# ,APS.NET,MYSQL
In my database I have got 4 field PictureFilefile_id type int, PictureFilePictfile_name type varchar, PictureFilefile_size int , file MEDIUMBLOB
I have the following code to fetch the details from database
========================================================================
MySql.Data.MySqlClient.MySqlConnection conn = new MySql.Data.MySqlClient.MySqlConnection();
MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand();
MySql.Data.MySqlClient.MySqlDataReader myData ;
string SQL;
UInt32 FileSize;
byte[] rawData;
FileStream fs;
conn.ConnectionString = CreateConnStr ("127.0.0.1", "dbourwebsite", "root", "root", "3306");
//SQL = "SELECT file_name, file_size, file FROM file";
SQL = "SELECT PictureFilefile_id, PictureFilePictfile_name, PictureFilefile_size, file FROM tblpicturefile where PictureFilefile_id=1";
try
{
conn.Open();
cmd.Connection = conn;
cmd.CommandText = SQL;
myData = cmd.ExecuteReader();
DataTable dtPictureTable = new DataTable();
dtPictureTable.Load(myData);
GridView1.DataSource = dtPictureTable;
GridView1.DataBind();
if (!myData.HasRows)
throw new Exception("There are no BLOBs to fetch");
=======================================================================
In the DESING VIEW
===================
<asp:gridview id="GridView1" runat="server" backcolor="LightGoldenrodYellow" bordercolor="Tan"
="" borderwidth="1px" cellpadding="2" forecolor="Black" gridlines="None" visible="False" autogeneratecolumns="False" width="532px">
<footerstyle backcolor="Tan">
<columns>
<asp:boundfield datafield="PictureFilefile_id" headertext="Image ID">
<headerstyle horizontalalign="Left">
<asp:boundfield datafield="PictureFilePictfile_name" headertext="Name">
<headerstyle horizontalalign="Left">
<asp:imagefield dataalternatetextfield="file" headertext="Piture Image" dataimageurlfield="file">
<headerstyle horizontalalign="Left">
<selectedrowstyle backcolor="DarkSlateBlue" forecolor="GhostWhite">
<pagerstyle backcolor="PaleGoldenrod" forecolor="DarkSlateBlue" horizontalalign="Center">
<headerstyle backcolor="Tan" font-bold="True">
<alternatingrowstyle backcolor="PaleGoldenrod">
================================================================================================
it fetch the details vorrect from database but insetad of image it says Sysytem.Byte[].
can you suggest me ways or tell me where I am wrong 
regards
Aditi
|
|
|
|
|
where's code for your image data.
something like
rawData= (byte[])myData["file"];
and you need to take some template column to display that in Grid. You are missing a lil. see this:
http://www.odetocode.com/Articles/172.aspx[^]
Any systematic work reflects its significance for a long time. So let's discuss the best...
|
|
|
|
|
hi aditi
your image datatype u can take binary your problem is solve
have a nice day
|
|
|
|
|
hi every body
how can i build a internet chat service (WAN chat) ?
i have a server and web site but i dont know how can build this project or what algorithm i can use ?
please give me any help about this ![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
|
Hi Mohy,
I did some checking. There's a couple ways to approach this. One is to build a basic chat using ASP.NET AJAX. The sample shows a way to start writing asynchronous Web applications using ASP.NET. I think this will show you how to implement the approach you are looking for. Check it out at Basic Chat Using ASP .NET AJAX
Another idea that might be outside the box of what you were thinking of is that you integrate with Microsoft Office Communicator 2007. There's a bunch of features that let you integrate Communicator in Windows and Web applications. You can use the SDK to show presence and embed communication entry points to Communicator in your application. You can download the SDK from Microsoft Office Communicator 2007 SDK.
Hope this helps.
-- bruce
Check out http://blogs.msdn.com/usisvde for the latest information for large and small ISV's.
|
|
|
|
|
I want to get the list of direct interfaces of a class the method Type.GetInterfaces
retrieve all interfaces in the hierarchy and it doesn't accept an BindingFlag parameter like GetMethods.
How can I do it?
|
|
|
|
|
I think you can't do that, because with interfaces there are no real hierarchies as with classes.
If a class implements an interface that extends another interface then the class implements both directly.
-^-^-^-^-^-
no risk no funk ................... please vote ------>
|
|
|
|
|
Just a note ... you don't inherit Interfaces, you impliment them 
An interface is a definition. You impliment definitions, but inherit implimentations.
|
|
|
|
|
Hi all,
I'm now study the vista sidebar programming, and I wanna do sth when my gadget closed or sidebar closed. I found nothing in the .net framework to catch th gadget closed or sidebar closed event, anyone knows how to make this?? Or any idea???
Thanks!!
|
|
|
|
|
You will probably need to look at the Windows Vista (Win32) API and use P/Invoke calls and/or handle the WndProc messages your self.
|
|
|
|
|
I wrote COM object in VC++ 6.0, and I tried to send a meanful exception to client.
So I tried to use IErrorInfo interface.
I implement the interface in such a way:
class ATL_NO_VTABLE CPAMServer :
public CComObjectRootEx<CComSingleThreadModel>,
public CComCoClass<CPAMServer, &CLSID_PAMServer>,
public IDispatchImpl<IPAMServer, &IID_IPAMServer, &LIBID_PrivilegeAttributesManager>,
public IDispatchImpl<IErrorInfo, &IID_IErrorInfo, &LIBID_PrivilegeAttributesManager>
and in a function of a com object wrote such a code:
CComObject<CPAMServer> *pTemp;
CComObject<CPAMServer>::CreateInstance(&pTemp);
pTemp->AddRef();
SetErrorInfo(0, pTemp);
return -5;
And when I call the method in My .NET code I got a COMException with code -5. The point is that the thrown exception not only doesn't contain the ierrorinfo object, but also it does not in a manner with http://msdn2.microsoft.com/en-us/library/9ztbc5s1.aspx
I also have searched some to change the way of unmarshaling of exceptions using MarshalAs or something like that but nothing has found. Can anyone help me with the method of getting ierrorinfo object in the managed code?
|
|
|
|
|
Hi all,
As with ascii character we can increment alphabet by increment ascii value of it (Like ch='H' and ch = ch + 1 gives me ch='I'). IS it pobbiel to do the same for Unicode character? I wan to increment Unicode character in VB.NET.
Thanks in advance
Priyank
|
|
|
|
|
As both the letters found in the alphabet and the individual order of the characters is not a universal constant you can't universily say you can do this in Unicode nor ASCII.
If the task is more specific to convert the characters a-z as typically defined in a US/UK alphabet, then yes - you can do it in both Unicode and ASCII. The first 127 character points in Unicode match the 127 characters of ASCII.
|
|
|
|
|
Can anybody tell me how to convert a .msg file to .eml file.using a .net component or some .net / COM libary. 
Thanks in advance.
|
|
|
|
|
Do not use the word 'Urgent' in your subject title. It is considered rude around here. As far as your problem goes, look at the structure of the .msg file and compare to a .eml file and see what you can do, if anything at all about it.
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
My .NET application uses a PrintPreviewControl to show the user the report before printing. But I need to extend it, to allow drill-down, etc. But PrintPreviewControl is a black-box control with no ability to be modified. So I will need to write my own.
But I can't be the first person to need this, there must be source code available for a PrintPreviewControl somewhere that I could use. I would be happy to pay for it, I bought one supposed version, but it was just a useless wrapper for the .NET version. If anyone knows where I can get an open PrintPreviewControl to use, I would appreciate it.
|
|
|
|
|
|
Thanks. I had found them in my earlier search, but had difficulty communicating with them. Have you actually used their product? Thanks.
|
|
|
|
|
I've used it as part of their reporting suite - it's very good. Plus, you can get the source code so you can do with it what you want.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Thanks, I appreciate it. I already have an email into them for clarification.
|
|
|
|
|
I have an abstract class, like so:
abstract class BaseClass
{
protected int m_n1;
protected string m_s1;
protected string m_s2;
public BaseClass(int n1, string s1, string s2)
{
m_n1 = n1;
m_s1 = s1;
m_s2 = s2;
}
protected abstract void MyFunction();
}
I'm trying to derive from it like this:
public class MyClass: BaseClass
{
public MyClass(int n1, string s1, string s2) : base(n1, s1, s2)
{
}
protected override void MyFunction()
{
}
}
The compiler is telling me this
<code>No overload for method 'BaseClass' takes '3' arguments</code>
What am I doing wrong?
-- modified at 15:20 Wednesday 29th August, 2007
"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
|
|
|
|
|
Well - apart from anything else, the code doesn't build. If you can't compile up BaseClass the compiler can't match up the base call. You need to change your reference to s1 to m_s1 in the member declaration.
protected string m_s1;
Deja View - the feeling that you've seen this post before.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
