|
Search This on Net 
|
|
|
|
|
Thank you for your reply. I don't know why you have taken 7 months time to reply for this message, if you really want to answer this question.
This is already resolved.
Anyway, thanks for this very simple but nonsensical reply. Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration.
|
|
|
|
|
i m using access database for my website...........i m a bit confused abt connection string for server....I simply included *.mdb file on my server.....this is what i wrote:-
<connectionStrings >
<add name ="conn" connectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=~App_Data\db1.mdb; " />
</connectionStrings >
is it right....if not then whts right way and if yes then why its not connecting to the database
plz guide me....
|
|
|
|
|
Did you test it and get any Error. First test it and get an Error and google it , if you dont find an answer you come and post here. That is a Good way to learn.
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.somee.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
Does it finds the database.
Check whether SqlConnection.Open gives you any error to this connection.
|
|
|
|
|
Yeah, great idea. Try defining an OleDb provider and then using SqlConnection to open it.
Omg...
If anything you should ask about IDbConnection... but since he stated clearly he wants Access, and the connection string uses OLEDB, i bet the farm it's going to be an OleDbConnection.
the connection string seems fine, by the way.
If you need any more help about OleDb, feel free to ask.
var question = (_2b || !(_2b));
|
|
|
|
|
Yes .. You are right. ![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif) 
|
|
|
|
|
|
Hi,
I am trying to get a response from a URL using the HttpWebRequest
object. this is my code below.
HttpWebRequest myReq = (HttpWebRequest)WebRequest.Create(url);
WebResponse myResp = myReq.GetResponse();
Stream stream = myResp.GetResponseStream();
System.Drawing.Image oImg = System.Drawing.Image.FromStream(stream);
It was working fine in my local machine. But when we hosted in server suddenly we got an error.
This is the details of the error I got.
System.Net.WebException: The remote server returned an error: (404) Not Found. at System.Net.HttpWebRequest.GetResponse()
The url exists and we are able to access it using a regular browser.
Thanks,
S.Thanagvel
|
|
|
|
|
hi
I am facing same problem. Please let me know the solution. My mail id infogopal@yahoo.com
|
|
|
|
|
I want to dispaly the alert window fro gridview command filed button
|
|
|
|
|
Why do you want to do that? Any specific reason?
|
|
|
|
|
I am using command field
when i delete a record i want to display alert window how can i do this?
|
|
|
|
|
add following javascript to command button onclientclick event
function confirmDelete()
{
return confirm('Do you want to delete record?');
}
|
|
|
|
|
I used this but its also firing for updating and deleting
|
|
|
|
|
Are you using same button for updating and deleting?
Use that script only on delete button.
|
|
|
|
|
I want to delete one row from grid view, before deleating i want to dispaly the aler
|
|
|
|
|
Already answered, please check above.
|
|
|
|
|
I have a grid view which can have any number of records.
I have a text box to search for card numbers.
I highlight the rows with matching card numbers in RowDataBound event.
Now i want to bring the Highlighted rows to top. I do not want to remove all other records. I want to show all records and want to bring highlighted records to top.
I urgently need the solution for this query. Any help will be appreciated.
Thanks in Advance!
Inderjeet Kaur
I tried using
Select * from abc where condition = searchcondition
UNION ALL
Select * from abc where condition <> searchcondition
But, it works only if i have to search one fileld. Now i have to run search on two fileds it will return lots on rows
Inderjeet Kaur
Sr. Software Engg
|
|
|
|
|
What you can do , is to order by the Card numbers. do it on your SQL Side and the rows that have the card number you searched for will be on the top part
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.somee.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
Hi
Order By wll bring the rows in asc or desc order. What if i want in between records on top
SELECT
*
FROM
(
SELECT
TranID AS TranID,
CardAcceptorIdCode as MerchantNumber,
PrimaryAccountNumber AS CardNumber,
TranTime as TxnDate,
TransactionAmount as TxnAmount,
CASE CCL1.LutDescription WHEN 'REDEMPTION' THEN 'PURCHASE' ELSE CCL1.LutDescription END as TxnType,
CASE CCL1.LutDescription WHEN 'REDEMPTION' THEN 'CR' WHEN CCL1.LutDescription THEN 'DR' END as DbCrdDetails,
LocalTxnDate,
LocalTxnTime,
PrimaryCurrencyCode AS Currency,
TxnCode_internal AS MTC,
ISNULL(ExcludeRecon, 0) AS ExcludeRecon
--CASE ExcludeRecon WHEN NULL THEN 0 ELSE ExcludeRecon END AS ExcludeRecon
FROM
CCardTransactions inner join
CCardLookup CCL1 on TranType = CCL1.LUTCode and TranType in (10,40,37,42,30) and CCL1.LUTID = 'LM'
WHERE
TRANTIME BETWEEN 'Jul 29 2009 12:00AM' AND 'Jul 29 2009 11:59PM' AND
CardAcceptorIdCode = 48484
) AS CCARDTRAN1
WHERE
CardNumber = '2423423453534556'
--ORDER BY CardNUmber
UNION ALL
SELECT
*
FROM
(
SELECT
TranID AS TranID,
CardAcceptorIdCode as MerchantNumber,
PrimaryAccountNumber AS CardNumber,
TranTime as TxnDate,
TransactionAmount as TxnAmount,
CASE CCL1.LutDescription WHEN 'REDEMPTION' THEN 'PURCHASE' ELSE CCL1.LutDescription END as TxnType,
CASE CCL1.LutDescription WHEN 'REDEMPTION' THEN 'CR' WHEN CCL1.LutDescription THEN 'DR' END as DbCrdDetails,
LocalTxnDate,
LocalTxnTime,
PrimaryCurrencyCode AS Currency,
TxnCode_internal AS MTC,
ISNULL(ExcludeRecon, 0) AS ExcludeRecon
--CASE ExcludeRecon WHEN NULL THEN 0 ELSE ExcludeRecon END AS ExcludeRecon
FROM
CCardTransactions inner join
CCardLookup CCL1 on TranType = CCL1.LUTCode and TranType in (10,40,37,42,30) and CCL1.LUTID = 'LM'
WHERE
TRANTIME BETWEEN 'Jul 29 2009 12:00AM' AND 'Jul 29 2009 11:59PM' AND
CardAcceptorIdCode = 48484
) AS CCARDTRAN2
WHERE
CardNumber <> '2423423453534556'
This is my query and i want top bring records searched by CardNUmber or TxnType on top
Inderjeet Kaur
Sr. Software Engg
|
|
|
|
|
You can choose if you want them asc or desc by adding something like
Order by CardNumber asc
or
Order by CardNumber desc
Hope this Helps
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.somee.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
Self Manipulation of Records of dataset is required here.
after binding the database initially and on card number entry,You try to highlight those matching rows and finally after completing highlight part,remove those all rows from dataset and insert at Top position and then rebind the Grid.This should be done at the end in order not to break performance issue.
Hope so I am correct.
All The Best
Sundeep Ganiga
When the only tool you have is a hammer, everything looks like a nail.
Come Forth Yourself to Click "Good Answer" for any expected solution.
Let us Support our C Project Programmers who provide solutions here.
|
|
|
|
|
i want to edit a grid view which contain a dropdownlist which is not bound to any datasource i want to use ListItem. How can i do so? What changes i have to do for my solution?
<asp:TemplateField HeaderText="Variable Price">
<ItemTemplate>
<asp:Label ID="tbPrice" Width="100px" runat="server" />
</ItemTemplate>
<EditItemTemplate>
<asp:DropDownList ID="ddlVariable"
Width="100px"
runat="server" />
</EditItemTemplate>
</asp:TemplateField>
|
|
|
|
|
Do you want to use them on the server side ?
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.somee.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
