I am working Asp.net(c#)+sql server.I have one id--> textbox and one next--> button,when I am input a id then if id match my datatable then display message match id in ur datatable if not match then next match id display in textbox.
View 4 RepliesI am trying to create strogly typed datasets for my project. When I right click on the xsd file that I need to generate a strongly typed dataset for I can't find the 'Advanced' properties as described in the below article (almost half way down)[URL]As I do not see the Advanced properties option I can't find the 'Custom Tool' property/option to set its value to 'MSDatasetGenerator'. Do I have to install some kind of patch on my VS 2005?
View 5 RepliesI want to change the text of the user name text box which is inside a log in view on selected index chaged event of a drop down list.
this is my code:
[Code]....
but both ddl and tb are null
Anyone knows how can I find the controls in code behind?
guess it's straightforward. On page load, i wanna check the group of which a particular belong to. Say, someADNameeckham belongs to Account. In that case, I only wanna get "Account". But I have no idea how to get the group name of a particular user belong to. It's for LAN web portal so I guess security is not a very big concern here.
View 5 RepliesI need to find the Sum of the Cost ,I tried doing it , but i am not aware of the syntax.
var pss = new PrintingServiceDataContext();
var strActualvalue = pss.PrintJobs.Where(s => s.OwnerID == txtOwnerID.Text && s.CreatedOn >= firstDay && s.CreatedOn <= today).Select(s => Sum(new {PCost = s.Cost }));
I am Working on an asp.net c# application.
I wish to find the url of the application. For example, my application is NRCME I want to return http://localhost:4833/NRCME/ when running locally. From the server I want to return
http://servername/NRCME/
I used to use datasets instead of sqldatareaders and I used to be able to do something like this
If dataset.tables(0).Rows(0)(1).ToString()) = "N" Then
lbl.Text = dataset.tables(0).Rows(0)(2).ToString())
Else
'Do Nothing
End If
This obviously doesn't work with sqldatareaders.I have code to see if the SQLDatareader has any rows but was wondering if there was a way to get the value of each rowI'm guessing this is possible and i've had a look around but can't seem to find anything
Dim conn As SqlConnection = New SqlConnection("server='h'; user id='w'; password='w'; database='w'; pooling='false'")
conn.Open()
Dim query As New SqlCommand("DECLARE @investor varchar(10), @sql varchar(1000) Select @investor = 69836 select @sql = 'SELECT * FROM OPENQUERY(db,''SELECT * FROM table WHERE investor = ''''' + @investor + ''''''')' EXEC(@sql)", conn)
Dim oDR As SqlDataReader = query.ExecuteReader()
If oDR.HasRows or dataset.tables(0).Rows(0)(1).ToString()) = "N" Then
lbl.Text = dataset.tables(0).Rows(0)(2).ToString())
Else
'Do Nothing
End If
That is the code I have at the moment which obviously doesn't work
had table indatalist and I had to find id of tr in table I did my code but error apeared (object refrence...).
<asp:DataList ID="DataList2" runat="server" RepeatColumns="4"
RepeatDirection="Horizontal" onitemdatabound="DataList2_ItemDataBound">
<ItemTemplate>
<table width="90%" border="0" cellspacing="0" cellpadding="2">
<tr id="AllText" runat="server">
[code]...
c#
i have string. string source ="my sweet babe stef" ;
i want cut this string to be 2 word. should be like ="my sweet";
how can i find this two word and cut other?
I am scraping a page from the net and I have the page HTML code in a string, now I want to find the value MIAMI which is in here:
<A HREF="test2.cgi?city=MIAMI">MIAMI</a></td> <td>
Now Miami will be dynamic, so how can I search for like the text between...
<A HREF="test2.cgi?city= and ">
i need to find the remote users ip address using asp.net and also i need clarification whether multiusers have same ip address
View 2 Replies1. How would I be able to find a certain row by a column name and be able to get all its data?2. How to exclude the last row from the Min and Max methods?Actually, my two questions are for one action.
What I need to do in finding a row is to go to the end of the data table and get the row before the end, then get the data for that row, at the same time, I want to exclude the value of the last row from my min and max used methods.
[code]...
How do I find my web server name on my pc?
View 2 RepliesI am a beginner of C# programming. I have read a few books about C#.net. But I cannot find some exercises in the books. Someone told me to build up a blog to practice my coding.
But it is a huge task for a beginner. I just want some tasks to have a step by step learning process.
I need to look for specific types in all assemblies in a web site or windows app, is there an easy way to do this? Like how the controller factory for ASP.NET MVC looks across all assemblies for controllers.
View 3 RepliesI have migrated a database from one server to another and following the migration had an orphaned user (WholeSystem_webuser), which has been fixed using the auto_fix option of sp_change_users_login
•The WholeSystem_webuser account is used by ASP.NET pages to connect to the database and run stored procedures.
•I can log in to Management Studio as WholeSystem_webuser OK and execute the sp's from there
•When I try to run my ASP.NET page it was saying “Can’t find stored procedure [procedure name]”
•If I drop the sp and create it as [dbo].[GetContactsCount] instead of [WholeSystem_ webuser]. [GetContactsCount] it says “The EXECUTE permission was denied on the object 'GetContactsCount', database 'WholeSystem', schema 'dbo'.” (which is what I’d expect as the connection string is using the WholeSystem_webuser account??) –does that show that the web user is logging into the database OK??
•If I try and configure the SqlDataSource in VWD to see what it is looking at though, it won’t let me get beyond the connection string window and says “Default schema could not be retrieved for this connection”
•I tried setting up a new login/user/connection string but still get the
“Default schema could not be retrieved for this connection” error
IN SQL Server:
•Users mapped to the login WholeSystem_webuser - WholeSystem_webuser, default schema dbo
•User WholeSystem_webuser has default schema dbo and db_dataread and db_datawrite permissions
•There is a schema dbo whose owner is dbo, and a schema WholeSystem_webuser whose owner is WholeSystem_webuser
I am new to .NET dev and I cut and paste a lot of code. One strugel i have is when I I use a class name, I need to find out what I need to add in the reference (using clause at the top) and what DLL to use. Is their a easy way to find out what class is on what DLL. My pc is littered with 500 - 600 .NET dll.
View 4 RepliesWe plan to develop a ASP.NET ( VS 2010 ) web site.We need to know if there are any ready made startup ASP.NET web sites so we can get them and adjust / upgrade according to our needs.
View 1 RepliesI have Downloaded the sample from codeplex,where in the ex. says 1.Add the RssDataSource and RssHyperLink to the Toolbox in Visual Studio How do I do it? I dont find the file to add? what file is it?
View 2 RepliesI usually use expressions like this
CommandArgument='<%# Container.DataItemIndex.ToString() %> '
But I could not find Container in the msdn,
My application name is MyApp and i added the util.dll as a reference in my MyApp. I have some forms and methods in util.dll (say frmErr.vb). Consider that i'm opening this frmErr.vb form (which is in util.dll) from MyApp so how can i find that i'm opening this form from MyApp in frmErr.vb Load function?
View 3 RepliesI have a Datagrid in image below. [URL] I can't find row Index in Datagridview when I call a event in DropDownList.
protected void DescriptionOfProduct_SelectedIndexChanged(object sender, EventArgs e)
{
DropDownList _DescriptionOfProduct = (DropDownList)gvSales.FindControl("DescriptionOfProduct");
Label _Unit = (Label)gvSales.FindControl("Unit");
Label _PriceType = (Label)gvSales.FindControl("PriceType");
//...
}
I have stored procedure in my database but its give error "Could not find stored procedure"Is this error occuring when maked error in permision,sp code or connection code
View 3 Repliesis there any way to find out to which route my url is getting mapped in asp.net mvc.
View 2 Repliesi have a string contain:
kasjbdfkjasbdf klsajdfl
ajbfk <html> ... </html> ksadfksadfwie...
now i wnat to find string beetwen <html> tag (with regex)