Database

FirstPrevNext

Re: server : error 18025 Navneet Hegde30-Mar-07 3:47 Navneet Hegde 30-Mar-07 3:47  How can I do that, Please help a bit , for last 5 hours I am wrestling with it Develop2Program & Program2Develop Re: server : error 18025 kubben30-Mar-07 3:54 kubben 30-Mar-07 3:54  Here is a link to a decent example: http://builder.com.com/5100-6388-6161839-2.html[^] Ben Re: server : error 18025 kubben30-Mar-07 3:56 kubben 30-Mar-07 3:56  Here's another link for I think the mail you are trying to send: http://articles.techrepublic.com.com/5100-6345_11-5094201.html[^] Ben Re: server : error 18025 Navneet Hegde30-Mar-07 3:58 Navneet Hegde 30-Mar-07 3:58  thanks for your prompt reply , I will try those link , Hope i get the result again thanks a lot Develop2Program & Program2Develop selecting primary key from grid view govindkedia30-Mar-07 1:07 govindkedia 30-Mar-07 1:07  HI, I am stuck in my project as. i want to select primary key frm the data listed in grid view..so that i can use that key value to actually list the data which are related to tht key in other table... so could any one tell how can i do tht... Re: selecting primary key from grid view gauthee30-Mar-07 1:47 gauthee 30-Mar-07 1:47  You would have a datasource to ur grid right! that is datatable/dataset for this you can set a primary key. Gautham Re: selecting primary key from grid view Tirthadip30-Mar-07 1:54 Tirthadip 30-Mar-07 1:54  bind your Primary key field to the DataKey of gridview.. and then retreive data with.... Dim primaryField As String<br /> primaryField =myGridview.Datakeys(Seletedrow.index).value.tostring() Tirtha Miles to go before I sleep Re: selecting primary key from grid view govindkedia30-Mar-07 2:19 govindkedia 30-Mar-07 2:19  thanks so much...for the tip.. but tell me one more thing now.. could i use this "primaryfield" to comapre with detailview which is binded with anotehr dataset in which this primaryfield is a forign key so will it work detailview.pageindex = primaryField.to string() ; or if u could guide me a bit on this.. tht will be very helpful i am using C# thanks again govind Re: selecting primary key from grid view Tirthadip30-Mar-07 2:39 Tirthadip 30-Mar-07 2:39  please be specific...I could't understand your problem Tirtha Miles to go before I sleep Need Help In Query: Shahzad.Aslam30-Mar-07 0:44 Shahzad.Aslam 30-Mar-07 0:44  Hi select CAST((datediff(day,createdon,getdate())/30) as float) Avg, from customers I want to give the result in Fraction is it possible? it is not showing the fraction result. createdon is the datetime field Any Help is appreciated. Regards Shahzad Aslam Software Engineer Re: Need Help In Query: Krish - KP30-Mar-07 1:00 Krish - KP 30-Mar-07 1:00  datediff function's date part "day" returns difference in number of days i.e 1 / 2 / 3 ..... if u r looking for even part of day, get the difference in hours/minutes/ ... then try converting that to days so that you get the result as you are expecting Regards KP Change a field on all tabel ,, row by row ? kindman_nb30-Mar-07 0:33 kindman_nb 30-Mar-07 0:33  Hi .. How can I path all rows on the table to change a field .. eg Serial .. like that For i=0 to datatabale.Rows.Count-1<br /> .<br /> .<br /> next i but I want to use any method instead of "Update table set ....." By using Datatable can I do it "path on all rows to change certain field" by usting the index of the row : DataTable.Rows(i)("Serial") .. I'm sorry , that my english isn't good .. but I hope if any one understand what I mean .. and thanks for my best Forum jooooo Re: Change a field on all tabel ,, row by row ? kubben30-Mar-07 2:19 kubben 30-Mar-07 2:19  You can use a cursor to do something similar to a for loop, but it is very slow compared to a single update statement. I would suggest you think seriously about using a single update statement instead. Ben Re: Change a field on all tabel ,, row by row ? kindman_nb30-Mar-07 2:32 kindman_nb 30-Mar-07 2:32  Thanks Ben.. but I think on that method : I want to gove some records a serial >> like 1,2,3 .... and I can't make that fields Identifier because the serial will be repeated again with another invoice ... then I'd like to path all selected feilds and give every one it's serial ... from the first to the end .. then if I user Update statement .. I can't know which record will take No 1 and which will take No 3 ... I want by the for .. next .. to give all selected row it's serial .. I know that is strange and there's another method to solve that .. but on my project now , I need this method ... again .. I hope if any one understand what I mean jooooo Re: Change a field on all tabel ,, row by row ? kubben30-Mar-07 2:36 kubben 30-Mar-07 2:36  Well, perhaps you should still look at using an update statement, but then using a scalar function. You could pass in some value you would help the function know what serial number to return. Just a thought. Ben issue reading records from SQL CE 2005 vvr198329-Mar-07 23:15 vvr1983 29-Mar-07 23:15  I have written a class for operating the SQLCE database with OLE DB, it work perfect on INSERT ,UPTDATE and so on, but when I use 'select' statement to get values from database it doesn’t return values properly even though the GetNextRows method succeeds. HRESULT hr = NOERROR; m_pIRowset = NULL; m_prghRows = &m_rghRows[0]; hr = pICmdText->SetCommandText(DBGUID_SQL, pwszQuery); if(!FAILED(hr)) { hr = pICmdText->Execute(NULL, IID_IRowset, NULL, NULL, (IUnknown **)&m_pIRowset); if (FAILED(hr)){ AfxMessageBox(_T("failed")); m_pIRowset = NULL; } // Get IColumnsInfo interface hr = m_pIRowset->QueryInterface(IID_IColumnsInfo, (void**)&m_pIColumnsInfo); if(FAILED(hr)){ AfxMessageBox(_T("failed")); } // Get the column metadata m_ulNumCols//m_pDBColumnInfo hr = m_pIColumnsInfo->GetColumnInfo(&m_ulNumCols, &m_pDBColumnInfo,&m_pStringsBuffer); if(FAILED(hr) || 0 == m_ulNumCols){ AfxMessageBox(_T("failed")); } // Create a DBBINDING array. m_dwBindingSize = m_ulNumCols; m_prgBinding = (DBBINDING*)CoTaskMemAlloc(sizeof(DBBINDING)*m_dwBindingSize); if (NULL == m_prgBinding){ hr = E_OUTOFMEMORY; AfxMessageBox(_T("Memory allocation failure")); } // Set initial offset for binding position m_dwOffset = 0; // Prepare structures to create the accessor UINT lCount; ULONG dwOrdinal; for (lCount = 0; lCount< m_ulNumCols; lCount++) { dwOrdinal = m_pDBColumnInfo[lCount].iOrdinal; m_prgBinding[lCount].iOrdinal = dwOrdinal; m_prgBinding[lCount].dwPart = DBPART_VALUE | DBPART_STATUS | DBPART_LENGTH; m_prgBinding[lCount].obLength = m_dwOffset; m_prgBinding[lCount].obStatus = m_prgBinding[lCount].obLength + sizeof(ULONG); m_prgBinding[lCount].obValue = m_prgBinding[lCount].obStatus + sizeof(DBSTATUS); m_prgBinding[lCount].wType = m_pDBColumnInfo[lCount].wType; m_prgBinding[lCount].pTypeInfo = NULL; m_prgBinding[lCount].pObject = NULL; m_prgBinding[lCount].pBindExt = NULL; m_prgBinding[lCount].dwMemOwner = DBMEMOWNER_CLIENTOWNED; m_prgBinding[lCount].dwFlags = 0; m_prgBinding[lCount].bPrecision = m_pDBColumnInfo[lCount].bPrecision; m_prgBinding[lCount].bScale = m_pDBColumnInfo[lCount].bScale; switch(m_prgBinding[lCount].wType){ case DBTYPE_WSTR: m_prgBinding[lCount].cbMaxLen = sizeof(WCHAR)*(m_pDBColumnInfo[lCount].ulColumnSize + 1); // Extra buffer for null terminator break; default: m_prgBinding[lCount].cbMaxLen = m_pDBColumnInfo[lCount].ulColumnSize; break; } // Calculate the offset, and properly align it m_dwOffset = m_prgBinding[lCount].obValue + m_prgBinding[lCount].cbMaxLen; m_dwOffset = ROUND_UP(m_dwOffset, 8); } // Get IAccessor interface hr = m_pIRowset->QueryInterface(IID_IAccessor, (void**)&m_pIAccessor); if(FAILED(hr)) { AfxMessageBox(_T("failed")); } // Create the accessor // hr = m_pIAccessor->CreateAccessor(DBACCESSOR_ROWDATA, m_dwBindingSize, m_prgBinding, 0, &m_hAccessor,NULL); if(FAILED(hr)) { AfxMessageBox(_T("failed")); } // Allocate data buffer. // m_pData = (BYTE*)CoTaskMemAlloc(m_dwOffset); if (NULL == m_pData) { hr = E_OUTOFMEMORY; CString errors; errors.Format(_T("%d"),m_pDBColumnInfo[2].ulColumnSize); MessageBox(NULL,errors,NULL,MB_OK); AfxMessageBox(_T("failed")); } // Retrive a row // hr = m_pIRowset->GetNextRows(DB_NULL_HCHAPTER, 0, 1, &m_cRowsObtained,&m_prghRows); if (SUCCEEDED(hr) && hr != DB_S_ENDOFROWSET) { // Set data buffer to zero // memset(m_pData, 0, m_dwOffset); // Fetch actual data hr = m_pIRowset->GetData(m_prghRows[0], m_hAccessor, m_pData); if (FAILED(hr)) { m_pIRowset->ReleaseRows(1, m_prghRows, NULL, NULL, NULL); AfxMessageBox(_T("failed")); } } if (hr == DB_S_ENDOFROWSET) { m_bIsEOF = TRUE; } } venkat remote connection marwan_siala29-Mar-07 23:14 marwan_siala 29-Mar-07 23:14  how can i let SQL server 2005 accept remote connections Re: remote connection andyharman30-Mar-07 6:12 andyharman 30-Mar-07 6:12  The Surface Area Configurator Getting following error while running sql server 2000 report service setup mohd imran abdul aziz29-Mar-07 20:40 mohd imran abdul aziz 29-Mar-07 20:40  Dear All, I am making web application using Asp.net C#(Visual Studio2005). And Sql server 2000 as a back End upgraded with service pack 3 and analysis service. Now I am trying to install sql server 2000 report services. But I run SQL2KRSSP1-ENG.EXE setup Then following error occurs The upgrade patch can not be installed by window installer because the program to be upgraded may be missing , or the upgrade patch may update a different version of the program Verify that the program to be upgraded exists on your computer and that you have the correct upgrade patch. I redownload the same exe to other location. And again run but getting same error Please Guide me or atleast give some help full link. thanks regards imran khan xp_sendmail Navneet Hegde29-Mar-07 20:31 Navneet Hegde 29-Mar-07 20:31  Hi All, I am getting error server msg:18025 when I try to execute extended stored procedure [ xp_Semdmail ]. Please do suggest way out. EXEC master..xp_sendmail '1', 'New title, mention in the next report to distributors.','','','navneethegde@gmail.com Develop2Program & Program2Develop DTS Mkanchha29-Mar-07 19:30 Mkanchha 29-Mar-07 19:30  How, I do DTS in SQL SERVER 2005 Mohan Balal Re: DTS andyharman29-Mar-07 22:51 andyharman 29-Mar-07 22:51  Either upgrade to SSIS or try http://msdn2.microsoft.com/en-us/library/ms143706.aspx[^] Data transfer keroed_edmond29-Mar-07 17:57 keroed_edmond 29-Mar-07 17:57  i am planning to do an extensive data transfer from tables in one database to different database that has a different table structure can someone point me in the direction i should be reading up where i can accomplish this? kenny Re: Data transfer Chetan Patel29-Mar-07 20:55 Chetan Patel 29-Mar-07 20:55  INSERT INTO Table1 ([Table2] (Field1,Field2) ) SHAPE { OPENQUERY([Adventure Works DW],'SELECT Field1,Field2 FROM database.Table') As Table2 } Best Regards, Chetan Patel Getting the connection string dptalt29-Mar-07 8:36 dptalt 29-Mar-07 8:36  I have developed an application that connects to a SQL Server 2003 database. My connection string is stored in the application configuration file. In development it is connecting to our company server but when I installed the application on site it will connect to their own SQL Server 2007 database. So when I installed the application on site I went into the configuration file and changed the server name to the new name. Well, for some reason my application cannot connect. Is there an easy way to get the connection string needed to connect to the new database?

Last Visit: 31-Dec-99 18:00     Last Update: 25-Apr-24 21:56 Refresh ᐊ Prev1...1615161616171618161916201621162216231624 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.