|
If you just specify how the data should be combined into the second table, it's easy enough to insert it. Example:
insert into SecondTable (serial1, serial2)
select f1.serial, f2.serial
from FirstTable f1
inner join FirstTable f2 on f2.something = f1.something
where f1.something = something and f2.something = something
However, it's not really clear how you mean that the data should be combined into what you show.
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
I have a excel files in store data. some cells are fill up and some cells are blank. when excel to import grid view and save data base. that time if cell is blank then store the in database but i want to store null value.
|
|
|
|
|
Hi,
how i write a method or function which returns time range values for example( 8:00 AM to 5:00PM with interval of 15 minutes) becuase i have to add times to each table header cell .
Any help?
Regards
|
|
|
|
|
rameez Raja wrote: how i write a method or function which returns time range values for example( 8:00 AM to 5:00PM with interval of 15 minutes) becuase i have to add times to each table header cell .
I did give you an example code. See your previous post.
please don't forget to vote on the post that helped you.
|
|
|
|
|
You can write two diffrent function for getting two values
public function get_time_range(BYVAL seta AS Datetime,BYVAL Setb as Datetime) AS Double
{
Dim Diff1,Diff2,Diff3 AS DOUBLE
IF Setb < Seta THEN RETURN 0
Diff1 = DateDiff(DateInterval.Day, Seta.Date, Setb.Date)
Diff2 = DateDiff(DateInterval.Minute, Seta.Minute, Setb.Minute)
Diff3 = DateDiff(DateInterval.Second, Seta.Second, Setb.Second)
Return Diff1 + Diff2/60 + Diff3/60
}
|
|
|
|
|
hi all,
how can i add new row to the gridview without reload the old already created rows,because i have a gridview with 2 templete column one of them are dropdownlist ,when i create new row with the same critera the dropdown list in the first row reload from start and dont have the last selected value
so how can i create new row and the first row keep(stored) the value in it
how can i do that ?
thanks for advice
Kareem Elhosseny
modified on Saturday, July 12, 2008 4:55 AM
|
|
|
|
|
Where we can use HTML controls?please give me some example.I think in order form that a customer want to see a preview of her order.is it correct?
|
|
|
|
|
bbc_sh wrote: Where we can use HTML controls?please give me some example.I think in order form that a customer want to see a preview of her order.is it correct?
There are no more differece between htmlControl and WebControl.The main defference is that webControls have default runat="server" while htmlControls do not have.
so that htmlControls are not accessible in code behind page but if you set runat="server" property of that control then it work like as webcontrol but with its own property values
Suppose
you use input text and you set runat="server" to it then you can access the value of this control in code behind side by using "Value" property ot "Text" like as textbox
please don't forget to vote on the post that helped you.
|
|
|
|
|
Hi, all
how i merge the corresponding cells of table control based upon database startdatetime and enddatetime .
i have added header cells with interval of 15 minutes from 8:00AM to 5:00PM
for example 8:00AM To 9:00AM
iam developing reservtion application .
any help is highly appercaited.
Regards
Rameez
|
|
|
|
|
rameez Raja wrote: i have added header cells with interval of 15 minutes from 8:00AM to 5:00PM
try this code
TimeSpan timeSpan1 = TimeSpan.Parse("5:00");
TimeSpan timeSpan2 = TimeSpan.Parse("20:00");
TimeSpan timeSpanDiff = timeSpan2.Subtract(timeSpan1);
int mins = timeSpanDiff.Hours * 60 + timeSpanDiff.Minutes;
int cells = mins / 15;
string minDiff = "0:15";
for (int i = 0; i < cells; i++)
{
Response.Write(timeSpan1.ToString() + " - " + timeSpan1.Add(TimeSpan.Parse(minDiff)) + "<br>");
timeSpan1 = timeSpan1.Add(TimeSpan.Parse(minDiff));
}</br>
please don't forget to vote on the post that helped you.
|
|
|
|
|
Hi friends,
I have an Authentication part in my website (which is written in .net) in my local system every thing is ok but when I move it to our server, when some one authenticates every thing goes well as he is authenticated and no error is thrown but he is not authenticated and he redirects to login page as he is anonymous! I though may it is because of the server time setting so the cookie is expired but it was not! at last after too much trying I decided to check it on another server and this time it worked correctly!! so I think there is some settings in IIS which cause this problem but as I have searched by now I found nothing! every help or suggestion would be very helpfull,
thanks in advanced.
|
|
|
|
|
hi
any body who knows names of books regarding MCAD windows application Development Exams Perpartion .
regards
|
|
|
|
|
Ok here is my code:
string[] info = new string[2];
info[0] = DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString();
info[1] = "OPEN";
SqlDataSource sds = new SqlDataSource(ConfigurationManager.ConnectionStrings["HelpDeskConnectionString"].ConnectionString, "Select ID From [Company_Ticket]");
sds.ID = "SqlDataSource1";
this.Controls.Add(sds);
TextBox txt = new TextBox();
txt.ID = "txtTime";
txt.Text = info[0];
txt.Visible = false;
this.Controls.Add(txt);
txt.ID = "txtStatus";
txt.Text = info[1];
txt.Visible = false;
this.Controls.Add(txt);
QueryStringParameter qsp = new QueryStringParameter();
qsp.Name = "AdminName";
qsp.QueryStringField = "Admin";
qsp.Type = TypeCode.String;
ControlParameter cp = new ControlParameter();
cp.ControlID = "TextBox2";
cp.Name = "Issue";
cp.Type = TypeCode.String;
sds.InsertParameters.Add(cp);
cp.ControlID = "TextBox1";
cp.Name = "Company";
cp.Type = TypeCode.String;
sds.InsertParameters.Add(cp);
cp.ControlID = "txtTime";
cp.Name = "Started";
cp.Type = TypeCode.DateTime;
sds.InsertParameters.Add(cp);
cp.ControlID = "txtStatus";
cp.Name = "TheStatus";
cp.Type = TypeCode.String;
sds.InsertParameters.Add(cp);
sds.InsertCommand = "INSERT INTO [Company_Ticket] (Admin, Started, Issue, Company, Status) VALUES (@AdminName, @Started, @Issue, @Company, @TheStatus)";
sds.Insert();
Ok here is the error I get:
The variable name '@TheStatus' has already been declared. Variable names must be unique within a query batch or stored procedure.
Must declare the scalar variable "@AdminName".
I don't get it.. I declare TheStatus only once.. and why do I keep getting this about AdminName?
|
|
|
|
|
You are only instantiating a ControlParameter once. Create a new instance for each parameter -
ControlParameter cp = new ControlParameter();
cp.ControlID = "TextBox2";
cp.Name = "Issue";
cp.Type = TypeCode.String;
sds.InsertParameters.Add(cp);
cp = new ControlParameter();
cp.ControlID = "TextBox1";
cp.Name = "Company";
cp.Type = TypeCode.String;
sds.InsertParameters.Add(cp);
etc...
|
|
|
|
|
WOW I can not believe I didnt notice that.
I have making a v2 for my company for a ticketing software and used the same method in the last one. It worked... because I did use cp = new ControlParameter().
I was combining the two to see if I could figure it out and I over looked that... WOW
Thanks though!
|
|
|
|
|
Hi all,
I have created helptooltip usercontrol and using it on my other controls and pages.
aspx is
<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="HelpTooltipButton.ascx.cs" Inherits="Controls.HelpTooltipButton" %>
<asp:ImageButton ID="TooltipButton" runat="server" Height="19px" Width="19px" ImageUrl="~/Images/HelpIcon_sm.gif" />
the code behind is :
protected override void OnPreRender(EventArgs e)
{
this.TooltipButton.TabIndex = 1000;
functionScript = new System.Text.StringBuilder("showPopup('" + Content + "','" + Title + "','" + TooltipButton.ClientID + "');return false;");
TooltipButton.OnClientClick = functionScript.ToString();
TooltipButton.CausesValidation = ButtonValidator;
}
This control is being used in other user controls.
In my main aspx page, I have used multiview control, to use for tabstrip.
when I am on one tab, and if help button is clicked, helptooltip opens.
without closing that tooltip if I move to other tab, the tooltip is still open.
I would like to close that popup when I move from one tab to other.
I tried to use mouseover and mouseout events for the tooltip as:
protected override void OnPreRender(EventArgs e)
{
if ((TEAMAppConstants.m_AppMode == TEAMAppConstants.AppMode.AdminPages) && (TEAMAppConstants.SelectedUseCase == TEAMAppConstants.DASHBOARD_STATUS))
{
return;
}
this.TooltipButton.TabIndex = 1000;
functionScript = new System.Text.StringBuilder("showPopup('" + Content + "','" + Title + "','" + TooltipButton.ClientID + "');return false;");
TooltipButton.Attributes.Add("onmouseover", functionScript.ToString());
TooltipButton.Attributes.Add("onmouseout", "hidePopup('" + TooltipButton.ClientID.ToString() + "');");
TooltipButton.CausesValidation = ButtonValidator;
}
here, onmouseover tooltip opens, but on mouseout I javascript exception as object not found.
can anyone please suggest me, how can I handle onmouseout event to close the already opened tooltip help?
Many thanks.
|
|
|
|
|
Is there a way to create a config file that controls the elements on specific pages. For example I have 2 pages viz. page1.aspx and page2.aspx. I want to have a config file in which I can control the visible property of the textbox controls on both pages.
Something like this:-
<page id = "page1.aspx">
<controls>
<control1 ID = "Textbox1" Visible = "false">
</controls>
</page>
<page id = "page2.aspx">
<controls>
<control1 ID = "Textbox1" Visible = "true">
</controls>
</page>
|
|
|
|
|
Well, you could create an HttpModule that reads the config file, identifies the current page, and injects a Load or PreRender event handler to hide or display controls.
Can I ask why you would want to do this? What's wrong with setting the property on the page?
|
|
|
|
|
I have a need to enter names and addresses throughout a web application. How can I create a control (C#) that I can include in a FormView control that will allow names and addresses to be entered with the fields bound to a datasource via a Formview Template?
|
|
|
|
|
Do a google search and tons of examples are bound to pop up.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
My code is
public void Insert()
{
string query =
"INSERT INTO WordTable (Word_ID,Word,Help) " +
"VALUES (@Word_ID,@Word,@Help)";
SqlConnection conn = new SqlConnection(cs);
SqlCommand cmd = new SqlCommand(query, conn);
cmd.Parameters.Add(new SqlParameter("@Word_ID",this.Word_ID));
cmd.Parameters.Add(new SqlParameter ("@Word",this.word));
cmd.Parameters.Add(new SqlParameter ("@Help",this.Help));
conn.Open();
cmd.ExecuteScalar();
}
And the exception is
System.Data.SqlClient.SqlException was unhandled by user code
Message="String or binary data would be truncated.\r\nThe statement has been terminated."
Source=".Net SqlClient Data Provider"
ErrorCode=-2146232060
Class=16
LineNumber=1
Number=8152
Procedure=""
Server="\\\\.\\pipe\\F52FA45D-C426-4C\\tsql\\query"
State=13
StackTrace:
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteScalar()
at SQLWord.Insert() in e:\asp.net\hangaro\App_Code\SQLWord.cs:line 48
at WordList.AddWord(SQLWord w) in e:\asp.net\hangaro\App_Code\WordList.cs:line 52
at Add_Word.WriteToSQL() in e:\asp.net\hangaro\Add_Word.aspx.cs:line 60
at Add_Word.Add_Click(Object sender, EventArgs e) in e:\asp.net\hangaro\Add_Word.aspx.cs:line 36
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
InnerException:
I have checked the values of
this.Word_ID etc...
What shall I do ?
Apurv
|
|
|
|
|
Try executenonquery instead of executescalar.
scalar is for a select statement, it returns the first value of the first row.
I didn't get any requirements for the signature
|
|
|
|
|
I am trying to change a LinkButton to disabled/enabled:
LinkButton newNext = (LinkButton)DataList1.FindControl("NextHyperLink");
newNext.Enabled = !pdDataSource.IsLastPage;
this will not work.. it returns that newNext is null...
The linkbuttons are in the HeadTemplate of the DataList1??
|
|
|
|
|
Problem is seems like where you are calling Find Control.
Datalist contains more that one items so you will need to provide specific item.
Can post here code that in which you are calling ?
Parwej Ahamad
R & D: REST services with WCF
|
|
|
|
|
In which event you are trying to access?
If page load i think you cannot...
Try by accessing in the ItemDataBound event... by using e.Item.FindControl
EVEN THE WORD IMPOSSIBLE SAYS I M POSSIBLE.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
