C / C++ / MFC

kumar sanghvi13-Dec-09 22:14

kumar sanghvi

13-Dec-09 22:14

im using MFC...how to create bitmap dynamically..

S p k 52113-Dec-09 22:17

S p k 521

13-Dec-09 22:17

Please go through CreateBitmap()

Rajesh R Subramanian13-Dec-09 22:23

Rajesh R Subramanian

13-Dec-09 22:23

kumar sanghvi wrote:
im using MFC...how to create bitmap dynamically..

http://lmgtfy.com/?q=MFC+Create+bitmap+dynamically[^]

“Follow your bliss.” – Joseph Campbell

Adam Roderick J13-Dec-09 22:36

Adam Roderick J

13-Dec-09 22:36

i never used Imgtfy, good answer Smile | :)

Величие не Бога может быть недооценена.

Rajesh R Subramanian13-Dec-09 23:33

Rajesh R Subramanian

13-Dec-09 23:33

Thanks. I don't want to use it either, but some people ask for it. Smile | :)

“Follow your bliss.” – Joseph Campbell

Adam Roderick J13-Dec-09 22:34

Adam Roderick J

13-Dec-09 22:34

CBitmap may be helpful for you [^]

Величие не Бога может быть недооценена.

MSSQL Database get database

Sameerkumar Namdeo14-Dec-09 18:44

Sameerkumar Namdeo

14-Dec-09 18:44

go for GDI+ Bitmap.
you can easily draw rect on it.

MsmVc13-Dec-09 19:17

13-Dec-09 19:17

Hi all

I am using Ms SQL Server 2005.I try to get all databases names of MSSQL.I am able to connect with mssql through this code.

#import ".\sqldmo.dll" no_namespace
#include "afxwin.h"
_SQLServer2Ptr spSQLServer;
CString str1="",str2="",str3="",m_MHOST="";
	LPWSTR HOST;
	HRESULT hr;
	if SUCCEEDED(hr = CoInitialize(NULL))
	{
		try
		{
		
			if (SUCCEEDED(spSQLServer.CreateInstance(__uuidof(SQLServer2))))
			{
				try
				{
					HOST=(_bstr_t)m_MHOST;
				
					
						spSQLServer->LoginSecure = TRUE;
						spSQLServer->Connect((_bstr_t)m_MHOST);
					
				
					
					str1.Format(_T("Connected to %s"), (LPTSTR) spSQLServer->Name);
				
			
				}
				catch(_com_error pCE)
				{
				
					
					str2.Format(_T("%s"),(TCHAR*)pCE.Description());
					MessageBox(str2,"Message");
					return ;
				}
			}
			else
			{
				str3.Format(_T("Unable to create the SQL Server object.\n"));
		
			}
		}
		catch(_com_error pCE)
		{
			str2.Format(_T("\n%s Error: %ld\r\n%s\r\n%s\r\n"),
				(TCHAR*)pCE.Source(),
						pCE.Error(),
				(TCHAR*)pCE.Description(),
				(TCHAR*)pCE.ErrorMessage());
			AfxMessageBox(str2);
			return;
		}

	
	}
	else
	{
		str2.Format(_T("Call to CoInitialize failed.\n"));
	}

i try to get database name through this way.

QueryResultsPtr Qry;
	CString dbs="SELECT * FROM SYS.DATABASES";
	Qry=spSQLServer->ExecuteWithResults((_bstr_t)dbs);

but i am not able to get database name.Please help me

Durga_Devi14-Dec-09 2:12

14-Dec-09 2:12

Hi,
Before executing the query "SELECT * FROM SYS.DATABASES", execute this query "USE master" and try ur select query.
I think it will work.

MsmVc16-Dec-09 1:14

16-Dec-09 1:14

see my problem is not using master.My problem is how i fetch mssql all database in listbox.

Durga_Devi16-Dec-09 1:28

16-Dec-09 1:28

That what i am saying. If u want to query any sys databases. First we have to switch to master user and then only we can fetch the records from the sysdatabases. From the ordinary user u cant execute the query.

MsmVc16-Dec-09 1:30

16-Dec-09 1:30

ok can you give me some line of example to fetch MSSQL Database?

MsmVc16-Dec-09 17:11

16-Dec-09 17:11

Hello can you give some line of code?

Durga_Devi16-Dec-09 20:12

16-Dec-09 20:12

Give me some time. I dont have sql server now to write sample. will send it by tomorrow.

MsmVc16-Dec-09 20:15

16-Dec-09 20:15

ok i am waiting for your example..

MsmVc16-Dec-09 22:33

16-Dec-09 22:33

hi durga

i have solve problem to show database through this code

spDatabases = spSQLServer->Databases;
	 for(int i=1;i<=spDatabases->Count;i++) {
    spDatabase = spDatabases->Item(i);
    _bstr_t db_name(spDatabase->GetName());
    CString s((LPCSTR)db_name);
	m_lsmssqldatabase.AddString(s);
    }

Can you give me idea how to show Table Name of particullar database.Plz help me

Durga_Devi16-Dec-09 23:25